1 [% INCLUDE 'doc-head-open.inc' %]
2 <title>Koha › Reports › Patrons with the most Checkouts</title>
3 [% INCLUDE 'doc-head-close.inc' %]
4 [% INCLUDE 'calendar.inc' %]
7 [% INCLUDE 'header.inc' %]
8 [% INCLUDE 'cat-search.inc' %]
10 <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> [% IF ( do_it ) %]› <a href="/cgi-bin/koha/reports/bor_issues_top.pl">Patrons with the most checkouts</a> › Results[% ELSE %]› Patrons with the most checkouts[% END %]</div>
12 <div id="doc3" class="yui-t2">
19 <script language="JavaScript" type="text/javascript">
20 function Dopop(link) {
21 newin=window.open(link,'width=500,height=400,toolbar=false,scrollbars=yes');
26 [% FOREACH mainloo IN mainloop %]
27 <h1>Top [% mainloo.limit %] List patrons for Checkouts</h1>
28 [% IF ( mainloo.loopfilter ) %]
30 [% FOREACH loopfilte IN mainloo.loopfilter %]
31 <p>[% IF ( loopfilte.err ) %] [% END %] [% loopfilte.crit %] =[% loopfilte.filter %][% IF ( loopfilte.err ) %] [% END %]</p>
37 <th rowspan="2">Rank</th>
38 [% FOREACH loopco IN mainloo.loopcol %]
39 <th colspan="2">[% loopco.coltitle %]</th>
43 [% FOREACH loopco IN mainloo.loopcol %]
45 <th>Checkout count</th>
48 [% FOREACH loopro IN mainloo.looprow %]
50 [% IF ( loopro.hilighted ) %]<td>[% ELSE %]<td>[% END %]
51 [% loopro.rowtitle %]</td>
52 [% FOREACH loopcel IN loopro.loopcell %]
53 [% IF ( loopcel.hilighted ) %]<td>[% ELSE %]<td>[% END %]
54 [% IF ( loopcel.reference ) %]<a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=[% loopcel.reference %]">[% END %]
55 [% IF ( loopcel.value ) %][% loopcel.value %][% END %]
56 [% IF ( loopcel.reference ) %]</a>[% END %]
58 [% IF ( loopcel.hilighted ) %]<td>[% ELSE %]<td>[% END %]
59 [% IF ( loopcel.count ) %][% loopcel.count %][% END %]
67 <h1>Patrons with the most Checkouts</h1>
68 <form method="post" action="/cgi-bin/koha/reports/bor_issues_top.pl">
69 <fieldset class="rows">
70 <ol><li><label for="from">Checkout date from:</label> <input type="text" readonly="readonly" size="10" id="from" name="Filter" />
71 <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="openCalendarFrom" style="cursor: pointer;" />
72 <script language="JavaScript" type="text/javascript">
73 function validate1(date) {
74 var day = date.getDate();
75 var month = date.getMonth() + 1;
76 var year = date.getFullYear();
77 var weekDay = date.getDay();
78 var dayMonth = month + '-' + day;
79 var dateString = year + '-' + month + '-' + day;
80 var dateTo = document.getElementById('to').value.split("-");
81 var limitDate = new Date(dateTo[0], (dateTo[1] - 1), dateTo[2]);
82 if (date > limitDate) {
92 ifFormat : "[% DHTMLcalendar_dateformat %]",
93 button : "openCalendarFrom",
94 disableFunc : validate1,
95 dateStatusFunc : validate1
99 <label class="inline" for="to">To: </label> <input readonly="readonly" size="10" id="to" name="Filter" value="" type="text" />
100 <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" id="openCalendarTo" style="cursor: pointer;" border="0" />
101 <script type="text/javascript">
102 function validate2(date) {
103 var day = date.getDate();
104 var month = date.getMonth() + 1;
105 var year = date.getFullYear();
106 var weekDay = date.getDay();
107 var dayMonth = month + '-' + day;
108 var dateString = year + '-' + month + '-' + day;
109 var dateFrom = document.getElementById('from').value.split("-");
110 var limitDate = new Date(dateFrom[0], (dateFrom[1] - 1), dateFrom[2]);
111 if (limitDate > date) {
121 ifFormat : "[% DHTMLcalendar_dateformat %]",
122 button : "openCalendarTo",
123 disableFunc : validate2,
124 dateStatusFunc : validate2
127 </script><span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
128 <li> <label for="fromRO">Check-in date from:</label> <input type="text" readonly="readonly" size="10" id="fromRO" name="Filter" />
129 <img src="[% themelang %]/lib/calendar/cal.gif" border="0" id="openCalendarFromRO" style="cursor: pointer;" alt="Show Calendar" />
130 <script language="JavaScript" type="text/javascript">
131 function validate1(date) {
132 var day = date.getDate();
133 var month = date.getMonth() + 1;
134 var year = date.getFullYear();
135 var weekDay = date.getDay();
136 var dayMonth = month + '-' + day;
137 var dateString = year + '-' + month + '-' + day;
138 var dateTo = document.getElementById('toRO').value.split("-");
139 var limitDate = new Date(dateTo[0], (dateTo[1] - 1), dateTo[2]);
140 if (date > limitDate) {
149 inputField : "fromRO",
150 ifFormat : "[% DHTMLcalendar_dateformat %]",
151 button : "openCalendarFromRO",
152 disableFunc : validate1,
153 dateStatusFunc : validate1
157 <label class="inline" for="toRO">To: </label> <input type="text" readonly="readonly" size="10" id="toRO" name="Filter" value="" />
158 <img src="[% themelang %]/lib/calendar/cal.gif" id="openCalendarToRO" style="cursor: pointer;" alt="Show Calendar" border="0" />
159 <script type="text/javascript">
160 function validate2(date) {
161 var day = date.getDate();
162 var month = date.getMonth() + 1;
163 var year = date.getFullYear();
164 var weekDay = date.getDay();
165 var dayMonth = month + '-' + day;
166 var dateString = year + '-' + month + '-' + day;
167 var dateFrom = document.getElementById('fromRO').value.split("-");
168 var limitDate = new Date(dateFrom[0], (dateFrom[1] - 1), dateFrom[2]);
169 if (limitDate > date) {
179 ifFormat : "[% DHTMLcalendar_dateformat %]",
180 button : "openCalendarToRO",
181 disableFunc : validate2,
182 dateStatusFunc : validate2
185 </script><span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
187 <label for="branch">Library: </label>
188 <select name="Filter" id="branch"><option value="" > Any Library</option>
189 [% FOREACH branchloo IN branchloop %]
190 <option value="[% branchloo.value %]" >[% branchloo.branchname %] </option>
194 <label for="documenttype">Item Type: </label><select name="Filter" id="documenttype"><option value="" > Any item type</option>
195 [% FOREACH itemtypeloo IN itemtypeloop %]
196 <option value="[% itemtypeloo.value %]" >[% itemtypeloo.description %] </option>
201 <label for="patroncategory">Patron Category: </label><select name="Filter" id="patroncategory"><option value="" > Any Category code</option>
202 [% FOREACH borcatloo IN borcatloop %]
203 <option value="[% borcatloo.value %]" >[% borcatloo.description %] </option>
210 <fieldset class="rows">
212 <li><label for="numlimit">Limit to: </label> <select name="Limit" id="numlimit">
213 <option value ="5" selected="selected"> 5</option>
214 <option value ="10">10</option>
215 <option value ="15">15</option>
216 <option value ="20">20</option>
217 <option value ="">No Limit</option>
218 <!-- <option value ="25">25</option>
219 <option value ="40">40</option>
220 <option value ="50">50</option>
221 <option value ="100">100</option>-->
223 <li><label for="criteria">By: </label> <select name="Criteria" id="criteria">
224 <option value ="" selected="selected">None</option>
225 <option value ="branchcode">Library</option>
226 <option value ="categorycode">Categorycode</option>
227 <option value ="itemtype">Itemtype</option>
228 <option value ="Day">Day</option>
229 <option value ="Week">Week</option>
230 <option value ="Month">Month</option>
231 <option value ="Year">Year</option>
236 <fieldset class="rows">
237 <legend>Output</legend>
238 <ol><li><label for="outputscreen">To screen into the browser: </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" /></li>
239 <li><label for="outputfile">To a file: </label><input type="radio" name="output" value="file" id="outputfile" />
240 <label class="inline" for="basename">Named: </label><input type="text" name="basename" id="basename" value="Export" />
241 <label class="inline" for="MIME">Into an application: </label>
242 <select name="MIME" id="MIME">
243 [% FOREACH mimeloo IN mimeloop %]
244 <option value="[% mimeloo.type %]">[% mimeloo.type %]</option>
247 <label class="inline" for="sep">Delimiter: </label>
253 <fieldset class="action">
254 <input type="submit" value="Submit" />
255 <input type="hidden" name="report_name" value="[% report_name %]" />
256 <input type="hidden" name="do_it" value="1" />
264 [% INCLUDE 'reports-menu.inc' %]
267 [% INCLUDE 'intranet-bottom.inc' %]