koha-tmpl/intranet-tmpl/prog/en/modules/reports/issues_stats.tt

   1 [% USE Branches %]
   2 [% INCLUDE 'doc-head-open.inc' %]
   3 <title>Koha &rsaquo; Reports &rsaquo; Circulation statistics [% IF ( do_it ) %]&rsaquo; Results[% END %]</title>
   4 [% INCLUDE 'doc-head-close.inc' %]
   5 [% INCLUDE 'calendar.inc' %]
   6 <style type="text/css">
   7         .sql {display:none;}
   8 </style>
   9 </head>
  10 <body id="rep_issues_stats" class="rep">
  11 [% INCLUDE 'header.inc' %]
  12 [% INCLUDE 'cat-search.inc' %]
  13
  14 <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> [% IF ( do_it ) %]&rsaquo; <a href="/cgi-bin/koha/reports/issues_stats.pl">Circulation statistics</a> &rsaquo; Results [% ELSE %]&rsaquo; Circulation statistics[% END %]</div>
  15
  16 <div id="doc3" class="yui-t2">
  17
  18    <div id="bd">
  19         <div id="yui-main">
  20         <div class="yui-b">
  21
  22 [% IF ( do_it ) %]
  23     [% FOREACH mainloo IN mainloop %]
  24         <h1>Circulation statistics</h1>
  25         [% IF ( mainloo.loopfilter ) %]
  26             <p>Filtered on:</p>
  27             <ul>
  28             [% FOREACH loopfilte IN mainloo.loopfilter %]
  29                 [% IF ( loopfilte.err ) %]<li class="error">Error:
  30                                 [% ELSIF ( loopfilte.sql ) %]<li class="sql">
  31                                 [% ELSE %]<li>
  32                                 [% END %]
  33                                         [% loopfilte.crit %] [% loopfilte.filter %]
  34                                 </li>
  35             [% END %]
  36             </ul>
  37         [% END %]
  38
  39         <table>
  40             <tr>
  41                 <th>[% mainloo.line %] / [% mainloo.column %]</th>
  42                 [% FOREACH loopco IN mainloo.loopcol %]
  43                     <th>[% loopco.coltitle_display |html %]</th>
  44                 [% END %]
  45                 <th>TOTAL</th>
  46                 </tr>
  47                 [% FOREACH loopro IN mainloo.looprow %]
  48                     <tr>
  49                         <td>[% loopro.rowtitle_display or "UNKNOWN VALUE" |html %]</td>
  50                     [% FOREACH loopcel IN loopro.loopcell %]
  51                                                 <td>[% loopcel.value %]</td>
  52                     [% END %]
  53                                                 <td>[% loopro.totalrow %]</td>
  54                     </tr>
  55                 [% END %]
  56             <tr>
  57                 <th>TOTAL</th>
  58                 [% FOREACH loopfoote IN mainloo.loopfooter %]
  59                 <th>[% loopfoote.totalcol %]</th>
  60                 [% END %]
  61                 <th>[% mainloo.total %]</th>
  62             </tr>
  63         </table>
  64     [% END %]
  65 [% ELSE %]
  66
  67     <form method="post" action="/cgi-bin/koha/reports/issues_stats.pl">
  68     <fieldset class="rows">
  69         <legend>Circulation statistics</legend><table>
  70         <thead>
  71             <tr>
  72                 <th>Title</th>
  73                 <th>Row</th>
  74                 <th>Column</th>
  75                 <th>Filter</th>
  76             </tr>
  77         </thead>
  78         <tbody>
  79             <tr>
  80                 <td>Period</td>
  81                 <td><input type="radio" name="Line" value="datetime" /></td>
  82                 <td><input type="radio" name="Column" value="datetime" /></td>
  83                 <td><label for="from">From</label> <input type="text" size="10" id="from" name="Filter" class="datepickerfrom" />
  84                     <label for="to">To</label> <input size="10" id="to" name="Filter" value="" type="text" class="datepickerto" />
  85                     <span class="hint">[% INCLUDE 'date-format.inc' %]</span>
  86                     </td>
  87                 </tr>
  88             <tr>
  89                 <td><label for="PeriodTypeSel">Type:</label><select name="PeriodTypeSel" id="PeriodTypeSel">
  90                     <option value ="issue">Checkout</option>
  91                     <option value ="renew">Renewal</option>
  92                     <option value ="return">Checkin</option>
  93                     <option value ="localuse">Local Use</option>
  94                     </select></td>
  95                 <td colspan="2"><label for="DisplayBy">group by</label> <select name="DisplayBy" id="DisplayBy">
  96                     <option value="">None</option>
  97                     <option value ="1">Day of week</option>
  98                     <option value ="2">Month</option>
  99                     <option value ="3">Year</option>
 100                     </select>
 101                 </td>
 102                 <td>
 103                     <label for="PeriodDaySel">Select day: </label><select name="PeriodDaySel" id="PeriodDaySel">
 104                     <option value =""></option>
 105                     <option value ="Monday">Monday</option>
 106                     <option value ="Tuesday">Tuesday</option>
 107                     <option value ="Wednesday">Wednesday</option>
 108                     <option value ="Thursday">Thursday</option>
 109                     <option value ="Friday">Friday</option>
 110                     <option value ="Saturday">Saturday</option>
 111                     <option value ="Sunday">Sunday</option>
 112                     </select>
 113                     <label for="PeriodMonthSel">Select month:</label> <select name="PeriodMonthSel" id="PeriodMonthSel">
 114                     <option value =""></option>
 115                     <option value ="January">January</option>
 116                     <option value ="February">February</option>
 117                     <option value ="March">March</option>
 118                     <option value ="April">April</option>
 119                     <option value ="May">May</option>
 120                     <option value ="June">June</option>
 121                     <option value ="July">July</option>
 122                     <option value ="August">August</option>
 123                     <option value ="September">September</option>
 124                     <option value ="October">October</option>
 125                     <option value ="November">November</option>
 126                     <option value ="December">December</option>
 127                     </select>
 128                 </td>
 129         </tr>
 130         <tr>
 131             <td>Patron category</td>
 132             <td><input type="radio" name="Line" value="borrowers.categorycode" /></td>
 133             <td><input type="radio" name="Column" value="borrowers.categorycode" /></td>
 134            <td><select name="Filter" id="borcat">
 135                <option value=""> </option>
 136                [% FOREACH categoryloo IN categoryloop %]
 137                  [% IF ( categoryloo.selected ) %]<option value="[% categoryloo.categorycode %]" selected="selected">[% categoryloo.description %]</option>[% ELSE %]<option value="[% categoryloo.categorycode %]">[% categoryloo.description %]</option>[% END %]
 138                [% END %]
 139                </select>
 140              </td>
 141         </tr>
 142         <tr>
 143             <td>Item type</td>
 144             <td><input type="radio" name="Line" value="itemtype" /></td>
 145             <td><input type="radio" name="Column" value="itemtype" /></td>
 146            <td><select name="Filter" id="itemtype">
 147                <option value=""> </option>
 148                [% FOREACH itemtypeloo IN itemtypeloop %]
 149                  [% IF ( itemtypeloo.selected ) %]<option value="[% itemtypeloo.code %]" selected="selected">[% itemtypeloo.description %]</option>[% ELSE %]<option value="[% itemtypeloo.code %]">[% itemtypeloo.description %]</option>[% END %]
 150                [% END %]
 151                </select>
 152              </td>
 153         </tr>
 154         <tr>
 155             <td>Library</td>
 156             <td><input type="radio" name="Line" value="branch" /></td>
 157             <td><input type="radio" name="Column" value="branch" /></td>
 158             <td><select name="Filter" id="branch">
 159                 <option value=""> </option>
 160                 [% PROCESS options_for_libraries libraries => Branches.all() %]
 161                </select>
 162              </td>
 163         </tr>
 164         <tr>
 165             <td>Collection</td>
 166             <td><input type="radio" name="Line"   value="items.ccode" /></td>
 167             <td><input type="radio" name="Column" value="items.ccode" /></td>
 168             <td><select name="Filter" id="ccode">
 169                 <option value=""> </option>
 170                 [% FOREACH ccodeloo IN ccodeloop %]
 171                                         [% IF ( ccodeloo.selected ) %] <option value="[% ccodeloo.code %]" selected="selected">[% ccodeloo.description %]</option>[% ELSE %]<option value="[% ccodeloo.code %]">[% ccodeloo.description %]</option>[% END %]
 172                 [% END %]
 173                 </select>
 174             </td>
 175         </tr>
 176         <tr>
 177             <td>Shelving location</td>
 178             <td><input type="radio" name="Line" value="items.location" /></td>
 179             <td><input type="radio" name="Column" value="items.location" /></td>
 180             <td><select name="Filter" id="location">
 181                 <option value=""> </option>
 182                 [% FOREACH locationloo IN locationloop %]
 183                                         [% IF ( locationloo.selected ) %]<option value="[% locationloo.code %]" selected="selected">[% locationloo.description %]</option>[% ELSE %]<option value="[% locationloo.code %]">[% locationloo.description %]</option>[% END %]
 184                                 [% END %]
 185                </select>
 186             </td>
 187         </tr>
 188         <tr>
 189             <td>Item call number</td>
 190             <td></td>
 191             <td></td>
 192             <td>From <input type="text" name="Filter" size="10" /> (inclusive) to <input type="text" name="Filter" size="10" /> (exclusive) </td>
 193         </tr>
 194         [% IF ( hassort1 ) %]
 195         <tr><td>Patron sort 1</td>
 196                         <td><input type="radio" name="Line" value="borrowers.sort1" /></td>
 197                         <td><input type="radio" name="Column" value="borrowers.sort1" /></td>
 198                         <td><select name="Filter" id="sort1">
 199                <option value=""> </option>
 200                [% FOREACH Bsort IN Bsort1 %]
 201                            [% IF ( Bsort.selected ) %]<option value="[% Bsort.authorised_value %]" selected="selected">[% Bsort.lib %]</option>[% ELSE %]<option value="[% Bsort.authorised_value %]" >[% Bsort.lib %]</option>[% END %]
 202                [% END %]
 203                </select>
 204             </td>
 205         </tr>
 206         [% END %]
 207         [% IF ( hassort2 ) %]
 208         <tr><td>Patron sort 2</td>
 209             <td><input type="radio" name="Line" value="borrowers.sort2" /></td>
 210             <td><input type="radio" name="Column" value="borrowers.sort2" /></td>
 211                 <td><select name="Filter" id="sort2">
 212                <option value=""> </option>
 213                [% FOREACH Bsort IN Bsort2 %]
 214                            [% IF ( Bsort.selected ) %]<option value="[% Bsort.authorised_value %]" selected="selected">[% Bsort.lib %]</option>[% ELSE %]<option value="[% Bsort.authorised_value %]" >[% Bsort.lib %]</option>[% END %]
 215                [% END %]
 216                </select>
 217             </td>
 218         </tr>
 219         [% END %]
 220         <tr><td>Home library</td>
 221             <td><input type="radio" name="Line" value="items.homebranch" /></td>
 222             <td><input type="radio" name="Column" value="items.homebranch" /></td>
 223             <td><select name="Filter" id="homebranch">
 224                     <option value=""> </option>
 225                     [% PROCESS options_for_libraries libraries => Branches.all() %]
 226                 </select>
 227             </td>
 228         </tr>
 229
 230         <tr><td>Holding library</td>
 231             <td><input type="radio" name="Line" value="items.holdingbranch" /></td>
 232             <td><input type="radio" name="Column" value="items.holdingbranch" /></td>
 233             <td><select name="Filter" id="holdingbranch">
 234                     <option value=""> </option>
 235                     [% PROCESS options_for_libraries libraries => Branches.all() %]
 236                 </select>
 237             </td>
 238         </tr>
 239
 240         </tbody>
 241     </table><br /></fieldset>
 242
 243 <fieldset class="rows"><legend>Cell value </legend><ol><li><label for="cellvalue1">Count total items:</label> <input type="radio" name="Cellvalue" value="1" id="cellvalue1" checked="checked" /> </li>
 244             <li><label for="cellvalue3">Count unique items:</label> <input type="radio" name="Cellvalue" id="cellvalue3" value="3" /> </li></ol></fieldset>
 245
 246         <fieldset class="rows">
 247         <legend>Output</legend>
 248     <ol>
 249         <li>
 250             <label for="outputscreen">To screen into the browser: </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
 251         </li>
 252         <li>
 253             <label for="outputfile">To a file:</label> <input type="radio" name="output" value="file" id="outputfile" />
 254             <label class="inline" for="basename">Named: </label><input type="text" name="basename" id="basename" value="Export" />
 255             <label class="inline" for="MIME">Into an application:</label>
 256             <select name="MIME" id="MIME" size="1">
 257             [% FOREACH value IN CGIextChoice %]
 258                 <option value="[% value %]">[% value %]</option>
 259             [% END %]
 260             </select>
 261             <select name="sep" id="sep" size="1">
 262             [% FOREACH value IN CGIsepChoice.values.sort() %]
 263               [% IF ( value == CGIsepChoice.default ) %]
 264                 <option value="[% value %]" selected="selected">[% value %]</option>
 265               [% ELSE %]
 266                 <option value="[% value %]">[% value %]</option>
 267               [% END %]
 268             [% END %]
 269             </select>
 270         </li>
 271     </ol>
 272         </fieldset>
 273
 274         <fieldset class="action">
 275         <input type="submit" value="Submit" />
 276         <input type="hidden" name="report_name" value="[% report_name %]" />
 277         <input type="hidden" name="do_it" value="1" />
 278         </fieldset>
 279         </form>
 280 [% END %]
 281
 282 </div>
 283 </div>
 284 <div class="yui-b">
 285 [% INCLUDE 'reports-menu.inc' %]
 286 </div>
 287 </div>
 288 [% INCLUDE 'intranet-bottom.inc' %]