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

   1 [% INCLUDE 'doc-head-open.inc' %]
   2 <title>Koha &rsaquo; Reports [% IF ( do_it ) %]&rsaquo; Catalog statistics &rsaquo; Results[% ELSE %]&rsaquo; Catalog statistics[% END %]</title>
   3 [% INCLUDE 'doc-head-close.inc' %]
   4 [% INCLUDE 'calendar.inc' %]
   5 <script type="text/javascript">
   6 //<![CDATA[
   7     function changeRemovedDateTrStatus() {
   8         var Cellvalue = $("input[name='Cellvalue']:checked").val();
   9         if(Cellvalue == "deleteditems") {
  10             $("#removeddatetr").show();
  11             $("input[value='deleteditems.timestamp']").attr('disabled', false);
  12             $("#deldateFrom").attr('disabled', false);
  13             $("#deldateTo").attr('disabled', false);
  14         } else {
  15             $("#removeddatetr").hide();
  16             $("input[value='deleteditems.timestamp']").attr('disabled', true).attr('checked', false);
  17             $("#deldateFrom").attr('disabled', true).val('');
  18             $("#deldateTo").attr('disabled', true).val('');
  19         }
  20     }
  21
  22     $(document).ready(function() {
  23         $('#acqdateFrom, #deldateFrom')
  24           .datepicker('option', 'onSelect', function(selectedDate) {
  25             var id = $(this).attr('id').replace('From', 'To');
  26             $('#' + id).datepicker('option', 'minDate', selectedDate);
  27           });
  28         $('#acqdateTo, #deldateTo')
  29           .datepicker('option', 'onSelect', function(selectedDate) {
  30             var id = $(this).attr('id').replace('To', 'From');
  31             $('#' + id).datepicker('option', 'maxDate', selectedDate);
  32           });
  33
  34         $("input[name='Cellvalue']").change(function() {
  35             changeRemovedDateTrStatus();
  36         });
  37         changeRemovedDateTrStatus();
  38     });
  39 //]]>
  40 </script>
  41 </head>
  42 <body id="rep_catalogue_stats" class="rep">
  43 [% INCLUDE 'header.inc' %]
  44 [% INCLUDE 'cat-search.inc' %]
  45
  46 <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/catalogue_stats.pl">Catalog statistics</a> &rsaquo; Results[% ELSE %]&rsaquo; Catalog statistics[% END %]</div>
  47
  48 <div id="doc3" class="yui-t2">
  49
  50    <div id="bd">
  51         <div id="yui-main">
  52         <div class="yui-b">
  53
  54 [% IF ( do_it ) %]
  55         [% FOREACH mainloo IN mainloop %]
  56                 <h1>Catalog statistics</h1>
  57                 [% IF ( mainloo.loopfilter ) %]
  58             <p>Filtered on:</p>
  59                         [% FOREACH loopfilte IN mainloo.loopfilter %]
  60                                         <p>[% loopfilte.crit %] =[% loopfilte.filter %]</p>
  61                         [% END %]
  62                 [% END %]
  63
  64                 <table>
  65                         <tr>
  66                                 <th>[% mainloo.line %] / [% mainloo.column %]</th>
  67                                 [% FOREACH loopco IN mainloo.loopcol %]
  68                                         <th>[% loopco.coltitle %]</th>
  69                                 [% END %]
  70                                 <th>TOTAL</th>
  71                         </tr>
  72                                 [% FOREACH loopro IN mainloo.looprow %]
  73                                         <tr>
  74                                                 [% IF ( loopro.hilighted ) %]<td class="hilighted">[% ELSE %]<td>[% END %]
  75                                                 [% loopro.rowtitle %]</td>
  76                                                 [% FOREACH loopcel IN loopro.loopcell %]
  77                                                         [% IF ( loopcel.hilighted ) %]<td>[% ELSE %]<td>[% END %]
  78                                                                 [% IF ( loopcel.value ) %][% loopcel.value %]
  79                                                                 [% ELSE %]&nbsp;
  80                                                                 [% END %]
  81                                                         </td>
  82                                                 [% END %]
  83                                                 [% IF ( loopro.hilighted ) %]<td>[% ELSE %]<td>[% END %]
  84                                                         [% loopro.totalrow %]
  85                                                 </td>
  86                                         </tr>
  87                                 [% END %]
  88                                 <tr>
  89                                         <th>TOTAL</th>
  90                                         [% FOREACH loopfoote IN mainloo.loopfooter %]
  91                                                 <th>
  92                                                         [% loopfoote.totalcol %]
  93                                                 </th>
  94                                         [% END %]
  95                                         <th>[% mainloo.total %]</th>
  96                                 </tr>
  97                 </table>
  98         [% END %]
  99 [% ELSE %]
 100
 101         <form method="post" action="/cgi-bin/koha/reports/catalogue_stats.pl">
 102         <fieldset class="rows">
 103         <legend>Catalog statistics</legend>
 104         <table>
 105                 <thead>
 106                         <tr>
 107                         <th>Title</th>
 108                         <th>Row</th>
 109                         <th>Column</th>
 110                         <th>Filter</th>
 111                         </tr>
 112                 </thead>
 113                 <tbody>
 114       <tr>
 115         <td>Koha full call number</td>
 116         <td><input type="radio" name="Line" value="items.itemcallnumber" /></td>
 117         <td><input type="radio" name="Column" value="items.itemcallnumber" /></td>
 118         <td><label for="callnoFrom">From</label> <input type="text" name="Filter" id="callnoFrom" /> <label for="callnoTo">To</label> <input type="text" name="Filter" id="callnoTo" /></td>
 119       </tr>
 120      <tr>
 121         <td>&nbsp;</td>
 122         <td colspan="2"><select name="cotedigits" id="cotedigits">
 123           <option value=""> </option>
 124           <option value ="1">1</option>
 125           <option value ="2">2</option>
 126           <option value ="3">3</option>
 127           <option value ="4">4</option>
 128           <option value ="5">5</option>
 129           </select>
 130           <label for="cotedigits">characters</label>
 131         </td>
 132         <td>&nbsp;</td>
 133       </tr>
 134                          <tr>
 135                 <td>Item type</td>
 136                                 <td><input type="radio" name="Line" value="[% item_itype %]" /></td>
 137                                 <td><input type="radio" name="Column" value="[% item_itype %]" /></td>
 138                                 <td><select name="Filter" id="[% item_itype %]">
 139                                         <option value=""> </option>
 140                     [% FOREACH itemtype IN itemtypes %]
 141                         <option value="[% itemtype.itemtype %]">[% itemtype.translated_description %]</option>
 142                     [% END %]
 143                                         </select>
 144                                 </td>
 145                         </tr>
 146                          <tr>
 147                                 <td>Publisher</td>
 148                                 <td><input type="radio" name="Line" value="publishercode" /></td>
 149                                 <td><input type="radio" name="Column" value="publishercode" /></td>
 150                                 <td><input type="text" name="Filter" /></td>
 151                         </tr>
 152                         <tr>
 153                 <td>Publication year</td>
 154                                 <td><input type="radio" name="Line" value="publicationyear" /></td>
 155                                 <td><input type="radio" name="Column" value="publicationyear" /></td>
 156                 <td><label for="pubyearFrom">From</label> <input type="text" name="Filter" id="pubYearFrom" /> <label for="pubyearTo">To</label> <input type="text" name="Filter" id="pubyearTo" /></td>
 157                         </tr>
 158                         <tr>
 159                 <td>Home library</td>
 160                                 <td><input type="radio" name="Line" value="items.homebranch" /></td>
 161                                 <td><input type="radio" name="Column" value="items.homebranch" /></td>
 162                                 <td><select name="Filter" id="branch">
 163                                         <option value=""> </option>
 164                                         [% FOREACH CGIBranc IN CGIBranch %]
 165                                         [% IF ( CGIBranc.selected ) %]<option value="[% CGIBranc.value %]" selected="selected">[% CGIBranc.branchname %]</option>[% ELSE %]<option value="[% CGIBranc.value %]">[% CGIBranc.branchname %]</option>[% END %]
 166                                         [% END %]
 167                                         </select>
 168                                 </td>
 169                         </tr>
 170                         <tr>
 171                 <td>Shelving location</td>
 172                                 <td><input type="radio" name="Line" value="items.location" /></td>
 173                                 <td><input type="radio" name="Column" value="items.location" /></td>
 174                                 <td><select name="Filter" id="location">
 175                                         <option value=""> </option>
 176                                         [% FOREACH locationloo IN locationloop %]
 177                                         [% IF ( locationloo.selected ) %]<option value="[% locationloo.code %]" selected="selected">[% locationloo.description %]</option>[% ELSE %]<option value="[% locationloo.code %]">[% locationloo.description %]</option>[% END %]
 178                                         [% END %]
 179                                         </select>
 180                                 </td>
 181                         </tr>
 182                         <tr>
 183                                 <td>Collection</td>
 184                                 <td><input type="radio" name="Line"   value="items.ccode" /></td>
 185                                 <td><input type="radio" name="Column" value="items.ccode" /></td>
 186                                 <td><select name="Filter" id="ccode">
 187                                         <option value=""> </option>
 188                                         [% FOREACH authval IN authvals %]
 189                                         [% IF ( authval.selected ) %]<option value="[% authval.code %]" selected="selected">[% authval.description %]</option>[% ELSE %]<option value="[% authval.code %]">[% authval.description %]</option>[% END %]
 190                                         [% END %]
 191                                         </select>
 192                                 </td>
 193                         </tr>
 194             [% IF (notforloan) %]
 195                 <tr>
 196                     <td>[% notforloan_label %]</td>
 197                     <td><input type="radio" name="Line"   value="items.notforloan" /></td>
 198                     <td><input type="radio" name="Column" value="items.notforloan" /></td>
 199                     <td>
 200                         [% IF (notforloan_avlist) %]
 201                             <select name="Filter" id="notforloan">
 202                                 <option value="">&nbsp;</option>
 203                                 [% FOREACH av IN notforloan_avlist %]
 204                                     <option value="[% av.authorised_value %]">
 205                                         [% av.lib %]
 206                                     </option>
 207                                 [% END %]
 208                             </select>
 209                         [% ELSE %]
 210                             <input type="text" name="Filter" id="notforloan" />
 211                         [% END %]
 212                     </td>
 213                 </tr>
 214             [% ELSE %]
 215                 <tr style="display:none">
 216                     <td colspan="4"><input type="hidden" name="Filter" /></td>
 217                 </tr>
 218             [% END %]
 219             [% IF (materials) %]
 220                 <tr>
 221                     <td>[% materials_label %]</td>
 222                     <td><input type="radio" name="Line"   value="items.materials" /></td>
 223                     <td><input type="radio" name="Column" value="items.materials" /></td>
 224                     <td>
 225                         [% IF (materials_avlist) %]
 226                             <select name="Filter" id="materials">
 227                                 <option value="">&nbsp;</option>
 228                                 [% FOREACH av IN materials_avlist %]
 229                                     <option value="[% av.authorised_value %]">
 230                                         [% av.lib %]
 231                                     </option>
 232                                 [% END %]
 233                             </select>
 234                         [% ELSE %]
 235                             <input type="text" name="Filter" id="materials" />
 236                         [% END %]
 237                     </td>
 238                 </tr>
 239             [% ELSE %]
 240                 <tr style="display:none">
 241                     <td colspan="4"><input type="hidden" name="Filter" /></td>
 242                 </tr>
 243             [% END %]
 244             <tr>
 245                 <td colspan="3">Filter barcode</td>
 246                 <td>
 247                     <select name="Filter" id="like">
 248                         <option value="1">like</option>
 249                         <option value="0">not like</option>
 250                     </select>
 251                     <input type="text" name="Filter" id="barcode" />
 252                     (use * to do a fuzzy search)
 253                 </td>
 254             </tr>
 255             <tr>
 256                 <td>Date acquired (item)</td>
 257                 <td><input type="radio" name="Line" value="items.dateaccessioned" /></td>
 258                 <td><input type="radio" name="Column" value="items.dateaccessioned" /></td>
 259                 <td>
 260                     <label for="acqdateFrom">From</label>
 261                     <input type="text" name="Filter" id="acqdateFrom" class="datepicker" />
 262                     <label for="acqdateTo">To</label>
 263                     <input type="text" name="Filter" id="acqdateTo" class="datepicker" />
 264                 </td>
 265             </tr>
 266             <tr id="removeddatetr">
 267                 <td>Date deleted (item)</td>
 268                 <td><input type="radio" name="Line" value="deleteditems.timestamp" /></td>
 269                 <td><input type="radio" name="Column" value="deleteditems.timestamp" /></td>
 270                 <td>
 271                     <label for="deldateFrom">From</label>
 272                     <input type="text" name="Filter" id="deldateFrom" class="datepicker" />
 273                     <label for="deldateTo">To</label>
 274                     <input type="text" name="Filter" id="deldateTo" class="datepicker"/>
 275                 </td>
 276             </tr>
 277                 </tbody>
 278         </table><br /></fieldset>
 279
 280     <fieldset class="rows">
 281         <legend>Cell value</legend>
 282         <ol>
 283             <li>
 284                 <label for="cellvalue_items">Count total items</label>
 285                 <input type="radio" name="Cellvalue" value="items" id="cellvalue_items" checked="checked" />
 286             </li>
 287             <li>
 288                 <label for="cellvalue_biblios">Count unique biblios</label>
 289                 <input type="radio" name="Cellvalue" value="biblios" id="cellvalue_biblios" />
 290             </li>
 291             <li>
 292                 <label for="cellvalue_deleteditems">Count deleted items</label>
 293                 <input type="radio" name="Cellvalue" value="deleteditems" id="cellvalue_deleteditems" />
 294             </li>
 295         </ol>
 296     </fieldset>
 297
 298         <fieldset class="rows">
 299         <legend>Output</legend>
 300         <ol><li><label for="outputscreen">To screen into the browser: </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" /></li>
 301                 <li><label for="outputfile">To a file: </label><input type="radio" name="output" value="file" id="outputfile" />
 302                         <label class="inline" for="basename">Named: </label><input type="text" name="basename" id="basename" value="Export" />
 303                         <label class="inline" for="MIME">Into an application: </label>
 304                         <select name="MIME" id="MIME">
 305                         [% FOREACH CGIextChoic IN CGIextChoice %]
 306                         <option value="[% CGIextChoic.type %]">[% CGIextChoic.type %]</option>
 307                         [% END %]
 308                         </select>
 309                         <!-- <label class="inline" for="sep">Delimiter: </label> -->
 310             <select name="sep" id="sep" size="1">
 311             [% FOREACH value IN CGIsepChoice.values.sort() %]
 312               [% IF ( value == CGIsepChoice.default ) %]
 313                 <option value="[% value %]" selected="selected">[% value %]</option>
 314               [% ELSE %]
 315                 <option value="[% value %]">[% value %]</option>
 316               [% END %]
 317             [% END %]
 318             </select>
 319                 </li>
 320         </ol>
 321         </fieldset>
 322
 323         <fieldset class="action">
 324         <input type="submit" value="Submit" />
 325         <input type="hidden" name="report_name" value="[% report_name %]" />
 326         <input type="hidden" name="do_it" value="1" />
 327         </fieldset>
 328         </form>
 329 [% END %]
 330 </div>
 331 </div>
 332 <div class="yui-b">
 333 [% INCLUDE 'reports-menu.inc' %]
 334 </div>
 335 </div>
 336 [% INCLUDE 'intranet-bottom.inc' %]