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