3 [% INCLUDE 'doc-head-open.inc' %]
4 <title>Koha › Reports [% IF ( do_it ) %]› Catalog statistics › Results[% ELSE %]› Catalog statistics[% END %]</title>
5 [% INCLUDE 'doc-head-close.inc' %]
8 <body id="rep_catalogue_stats" class="rep">
9 [% INCLUDE 'header.inc' %]
10 [% INCLUDE 'cat-search.inc' %]
12 <nav aria-label="Breadcrumb" class="breadcrumb">
15 <a href="/cgi-bin/koha/mainpage.pl">Home</a>
18 <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a>
22 <a href="/cgi-bin/koha/reports/catalogue_stats.pl">Catalog statistics</a>
25 <a href="#" aria-current="page">
31 <a href="#" aria-current="page">
39 <div class="main container-fluid">
41 <div class="col-sm-10 col-sm-push-2">
45 [% FOREACH mainloo IN mainloop %]
46 <h1>Catalog statistics</h1>
47 [% IF ( mainloo.loopfilter ) %]
49 [% FOREACH loopfilte IN mainloo.loopfilter %]
50 <p>[% loopfilte.crit | html %] =[% loopfilte.filter | html %]</p>
54 <table id="catalogue_stats">
57 <th>[% mainloo.line | html %] / [% mainloo.column | html %]</th>
58 [% FOREACH loopco IN mainloo.loopcol %]
59 <th>[% loopco.coltitle | html %]</th>
65 [% FOREACH loopro IN mainloo.looprow %]
67 [% IF ( loopro.hilighted ) %]<td class="hilighted">[% ELSE %]<td>[% END %]
68 [% loopro.rowtitle | html %]</td>
69 [% FOREACH loopcel IN loopro.loopcell %]
70 [% IF ( loopcel.hilighted ) %]<td>[% ELSE %]<td>[% END %]
71 [% IF ( loopcel.value ) %][% loopcel.value | html %]
76 [% IF ( loopro.hilighted ) %]<td>[% ELSE %]<td>[% END %]
77 [% loopro.totalrow | html %]
84 <th>TOTAL (all results)</th>
85 [% FOREACH loopfoote IN mainloo.loopfooter %]
87 [% loopfoote.totalcol | html %]
90 <th>[% mainloo.total | html %]</th>
97 <form method="post" action="/cgi-bin/koha/reports/catalogue_stats.pl">
98 <fieldset class="rows">
99 <legend>Catalog statistics</legend>
111 <td>Koha full call number</td>
112 <td><input type="radio" name="Line" value="items.itemcallnumber" /></td>
113 <td><input type="radio" name="Column" value="items.itemcallnumber" /></td>
114 <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>
118 <td colspan="2"><select name="cotedigits" id="cotedigits">
119 <option value=""> </option>
120 <option value ="1">1</option>
121 <option value ="2">2</option>
122 <option value ="3">3</option>
123 <option value ="4">4</option>
124 <option value ="5">5</option>
126 <label for="cotedigits">characters</label>
132 <td><input type="radio" name="Line" value="[% item_itype | html %]" /></td>
133 <td><input type="radio" checked="checked" name="Column" value="[% item_itype | html %]" /></td>
134 <td><select name="Filter" id="[% item_itype | html %]">
135 <option value=""> </option>
136 [% FOREACH itemtype IN itemtypes %]
137 <option value="[% itemtype.itemtype | html %]">[% itemtype.translated_description | html %]</option>
144 <td><input type="radio" name="Line" value="publishercode" /></td>
145 <td><input type="radio" name="Column" value="publishercode" /></td>
146 <td><input type="text" name="Filter" /></td>
149 <td>Publication year</td>
150 <td><input type="radio" name="Line" value="publicationyear" /></td>
151 <td><input type="radio" name="Column" value="publicationyear" /></td>
152 <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>
155 <td>Home library</td>
156 <td><input type="radio" checked="checked" name="Line" value="items.homebranch" /></td>
157 <td><input type="radio" name="Column" value="items.homebranch" /></td>
158 <td><select name="Filter" id="branch">
159 <option value=""> </option>
160 [% PROCESS options_for_libraries libraries => Branches.all() %]
165 <td>Shelving location</td>
166 <td><input type="radio" name="Line" value="items.location" /></td>
167 <td><input type="radio" name="Column" value="items.location" /></td>
168 <td><select name="Filter" id="location">
169 <option value=""> </option>
170 [% FOREACH locationloo IN locationloop %]
171 [% IF ( locationloo.selected ) %]<option value="[% locationloo.code | html %]" selected="selected">[% locationloo.description | html %]</option>[% ELSE %]<option value="[% locationloo.code | html %]">[% locationloo.description | html %]</option>[% END %]
178 <td><input type="radio" name="Line" value="items.ccode" /></td>
179 <td><input type="radio" name="Column" value="items.ccode" /></td>
180 <td><select name="Filter" id="ccode">
181 <option value=""> </option>
182 [% FOREACH authval IN authvals %]
183 [% IF ( authval.selected ) %]<option value="[% authval.code | html %]" selected="selected">[% authval.description | html %]</option>[% ELSE %]<option value="[% authval.code | html %]">[% authval.description | html %]</option>[% END %]
188 [% IF (notforloan) %]
190 <td>[% notforloan_label | html %]</td>
191 <td><input type="radio" name="Line" value="items.notforloan" /></td>
192 <td><input type="radio" name="Column" value="items.notforloan" /></td>
194 [% IF (notforloan_avlist) %]
195 <select name="Filter" id="notforloan">
196 <option value=""> </option>
197 [% FOREACH av IN notforloan_avlist %]
198 <option value="[% av.authorised_value | html %]">
204 <input type="text" name="Filter" id="notforloan" />
209 <tr style="display:none">
210 <td colspan="4"><input type="hidden" name="Filter" /></td>
215 <td>[% materials_label | html %]</td>
216 <td><input type="radio" name="Line" value="items.materials" /></td>
217 <td><input type="radio" name="Column" value="items.materials" /></td>
219 [% IF (materials_avlist) %]
220 <select name="Filter" id="materials">
221 <option value=""> </option>
222 [% FOREACH av IN materials_avlist %]
223 <option value="[% av.authorised_value | html %]">
229 <input type="text" name="Filter" id="materials" />
234 <tr style="display:none">
235 <td colspan="4"><input type="hidden" name="Filter" /></td>
239 <td colspan="3">Filter barcode</td>
241 <select name="Filter" id="like">
242 <option value="1">like</option>
243 <option value="0">not like</option>
245 <input type="text" name="Filter" id="barcode" />
246 (use * to do a fuzzy search)
250 <td>Date acquired (item)</td>
251 <td><input type="radio" name="Line" value="items.dateaccessioned" /></td>
252 <td><input type="radio" name="Column" value="items.dateaccessioned" /></td>
254 <label for="acqdateFrom">From</label>
255 <input type="text" name="Filter" id="acqdateFrom" class="datepicker" />
256 <label for="acqdateTo">To</label>
257 <input type="text" name="Filter" id="acqdateTo" class="datepicker" />
260 <tr id="removeddatetr">
261 <td>Date deleted (item)</td>
262 <td><input type="radio" name="Line" value="deleteditems.timestamp" /></td>
263 <td><input type="radio" name="Column" value="deleteditems.timestamp" /></td>
265 <label for="deldateFrom">From</label>
266 <input type="text" name="Filter" id="deldateFrom" class="datepicker" />
267 <label for="deldateTo">To</label>
268 <input type="text" name="Filter" id="deldateTo" class="datepicker"/>
272 </table><br /></fieldset>
274 <fieldset class="rows">
275 <legend>Cell value</legend>
278 <label for="cellvalue_items">Count total items</label>
279 <input type="radio" name="Cellvalue" value="items" id="cellvalue_items" checked="checked" />
282 <label for="cellvalue_biblios">Count unique bibliographic records</label>
283 <input type="radio" name="Cellvalue" value="biblios" id="cellvalue_biblios" />
286 <label for="cellvalue_deleteditems">Count deleted items</label>
287 <input type="radio" name="Cellvalue" value="deleteditems" id="cellvalue_deleteditems" />
292 <fieldset class="rows">
293 <legend>Output</legend>
294 <ol><li><label for="outputscreen">To screen into the browser: </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" /></li>
295 <li><label for="outputfile">To a file: </label><input type="radio" name="output" value="file" id="outputfile" />
296 <label class="inline" for="basename">Named: </label><input type="text" name="basename" id="basename" value="Export" />
297 <label class="inline" for="MIME">Into an application: </label>
298 <select name="MIME" id="MIME">
299 [% FOREACH CGIextChoic IN CGIextChoice %]
300 <option value="[% CGIextChoic.type | html %]">[% CGIextChoic.type | html %]</option>
303 <!-- <label class="inline" for="sep">Delimiter: </label> -->
304 <select name="sep" id="sep" size="1">
305 [% FOREACH value IN CGIsepChoice.values.sort() %]
306 [% IF ( value == CGIsepChoice.default ) %]
307 <option value="[% value | html %]" selected="selected">[% value | html %]</option>
309 <option value="[% value | html %]">[% value | html %]</option>
317 <fieldset class="action">
318 <input type="submit" value="Submit" />
319 <input type="hidden" name="report_name" value="[% report_name | html %]" />
320 <input type="hidden" name="do_it" value="1" />
326 </div> <!-- /.col-sm-10.col-sm-push-2 -->
328 <div class="col-sm-2 col-sm-pull-10">
330 [% INCLUDE 'reports-menu.inc' %]
332 </div> <!-- /.col-sm-2.col-sm-pull-10 -->
333 </div> <!-- /.row -->
335 [% MACRO jsinclude BLOCK %]
336 [% INCLUDE 'calendar.inc' %]
337 [% INCLUDE 'datatables.inc' %]
338 [% INCLUDE 'columns_settings.inc' %]
340 function changeRemovedDateTrStatus() {
341 var Cellvalue = $("input[name='Cellvalue']:checked").val();
342 if(Cellvalue == "deleteditems") {
343 $("#removeddatetr").show();
344 $("input[value='deleteditems.timestamp']").prop('disabled', false);
345 $("#deldateFrom").prop('disabled', false);
346 $("#deldateTo").prop('disabled', false);
348 $("#removeddatetr").hide();
349 $("input[value='deleteditems.timestamp']").prop('disabled', true).prop('checked', false);
350 $("#deldateFrom").prop('disabled', true).val('');
351 $("#deldateTo").prop('disabled', true).val('');
355 $(document).ready(function() {
356 $('#acqdateFrom, #deldateFrom')
357 .datepicker('option', 'onSelect', function(selectedDate) {
358 var id = $(this).attr('id').replace('From', 'To');
359 $('#' + id).datepicker('option', 'minDate', selectedDate);
361 $('#acqdateTo, #deldateTo')
362 .datepicker('option', 'onSelect', function(selectedDate) {
363 var id = $(this).attr('id').replace('To', 'From');
364 $('#' + id).datepicker('option', 'maxDate', selectedDate);
367 $("input[name='Cellvalue']").change(function() {
368 changeRemovedDateTrStatus();
370 changeRemovedDateTrStatus();
372 columns_settings = [% FILTER collapse %]
376 "columnname": "[% mainloo.line | html %]_[% mainloo.column | html %]",
377 "cannot_be_toggled": 1,
378 "cannot_be_modified": 1
380 [% FOREACH loopco IN mainloo.loopcol %]
383 "columnname": "[% loopco.coltitle | html %]",
384 "cannot_be_toggled": 0,
385 "cannot_be_modified": 0
390 "columnname": "total",
391 "cannot_be_toggled": 0,
392 "cannot_be_modified": 0
397 var catalogue_stats = KohaTable("catalogue_stats", {
400 }, columns_settings );
405 [% INCLUDE 'intranet-bottom.inc' %]