Bug 13452: 'Average loan time' report to obey item-level_itypes preference
[koha.git] / koha-tmpl / intranet-tmpl / prog / en / modules / reports / issues_avg_stats.tt
1 [% USE Branches %]
2 [% INCLUDE 'doc-head-open.inc' %]
3 <title>Koha &rsaquo; Reports &rsaquo; Average loan time</title>
4 [% INCLUDE 'doc-head-close.inc' %]
5 [% INCLUDE 'calendar.inc' %]
6 <script type="text/javascript">
7 //<![CDATA[
8         $(document).ready(function() {
9         // http://jqueryui.com/demos/datepicker/#date-range
10         var dates = $( "#from, #to" ).datepicker({
11             changeMonth: true,
12             numberOfMonths: 1,
13             onSelect: function( selectedDate ) {
14                 var option = this.id == "from" ? "minDate" : "maxDate",
15                     instance = $( this ).data( "datepicker" );
16                     date = $.datepicker.parseDate(
17                         instance.settings.dateFormat ||
18                         $.datepicker._defaults.dateFormat,
19                         selectedDate, instance.settings );
20                 dates.not( this ).datepicker( "option", option, date );
21             }
22         });
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         });
37 //]]>
38 </script>
39 </head>
40 <body id="rep_issues_avg_stats" class="rep">
41 [% INCLUDE 'header.inc' %]
42 [% INCLUDE 'cat-search.inc' %]
43
44 <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_avg_stats.pl">Average loan time</a> &rsaquo; Results [% ELSE %]&rsaquo; Average loan time[% END %]</div>
45
46 <div id="doc3" class="yui-t2">
47    
48    <div id="bd">
49         <div id="yui-main">
50         <div class="yui-b">
51
52 [% IF ( do_it ) %]
53         [% FOREACH mainloo IN mainloop %]
54         <h1>Average checkout period</h1>
55                 [% IF ( mainloo.loopfilter ) %]
56             <p>Filtered on:</p>
57                         [% FOREACH loopfilte IN mainloo.loopfilter %]
58                                         <p>[% IF ( loopfilte.err ) %]  [% END %] [% loopfilte.crit %] =[% loopfilte.filter %][% IF ( loopfilte.err ) %]  [% END %]</p>
59                         [% END %]
60                 [% END %]
61                 
62                 <table>
63                         <tr>
64                                 <th>[% mainloo.line %] / [% mainloo.column %]</th>
65                                 [% FOREACH loopco IN mainloo.loopcol %]
66                                         <th>[% loopco.coltitle %]</th>
67                                 [% END %]
68                                 <th>TOTAL</th>
69                         </tr>
70                                 [% FOREACH loopro IN mainloo.looprow %]
71                                         <tr>
72                                                 [% IF ( loopro.hilighted ) %]<td class="hilighted">[% ELSE %]<td>[% END %]
73                                                 [% loopro.rowtitle %]</td>
74                                                 [% FOREACH loopcel IN loopro.loopcell %]
75                                                         [% IF ( loopcel.hilighted ) %]<td class="hilighted">[% ELSE %]<td>[% END %]
76                                                                 [% IF ( loopcel.value ) %][% loopcel.value %][% END %]
77                                                         </td>
78                                                 [% END %]
79                                                 [% IF ( loopro.hilighted ) %]<td>[% ELSE %]<td>[% END %]
80                                                         [% loopro.totalrow %]
81                                                 </td>
82                                         </tr>
83                                 [% END %]
84                                 <tr>
85                                         <th>TOTAL</th>
86                                         [% FOREACH loopfoote IN mainloo.loopfooter %]
87                                                 <th>
88                                                         [% loopfoote.totalcol %]
89                                                 </th>
90                                         [% END %]
91                                         <th>[% mainloo.total %]</th>
92                                 </tr>
93                 </table>
94         [% END %]
95 [% ELSE %]
96
97         <form method="post" action="/cgi-bin/koha/reports/issues_avg_stats.pl">
98         <fieldset class="rows">
99         <legend>Average checkout period statistics</legend>
100         <table>
101                 <thead>
102                         <tr>
103                         <th>Title</th>
104                         <th>Row</th>
105                         <th>Column</th>
106                         <th>Filter</th>
107                         </tr>
108                 </thead>
109                 <tbody>
110                         <tr class="hilighted">
111                                 <td>Checkout date</td>
112                                 <td><input type="radio" name="Line" value="timestamp" /></td>
113                                 <td><input type="radio" name="Column" value="timestamp" /></td>
114                                 <td > <label for="from">From</label> <input type="text" size="10" id="from" name="Filter" />
115                                         <label for="to">To</label> <input size="10" id="to" name="Filter" value="" type="text" />
116                     <span class="hint">[% INCLUDE 'date-format.inc' %]</span>
117                                 </td>
118                         </tr>
119                         <tr class="hilighted"> 
120                                 <td>&nbsp;</td>
121                                 <td colspan="2">by <select name="IssueDisplay">
122                                         <option value=""> </option>
123                                         <option value ="1">Day</option>
124                                         <option value ="2">Month</option>
125                                         <option value ="3">Year</option>
126                                         </select>
127                                         
128                                 </td>
129                                 <td><!--Preparing Month and Day Selection--><input type="hidden" name="Filter" value="" /><input type="hidden" name="Filter" value="" /></td>
130                         </tr>
131                         <tr>
132                                 <td>Returns</td>
133                                 <td><input type="radio" name="Line" value="returndate" /></td>
134                                 <td><input type="radio" name="Column" value="returndate" /></td>
135                                 <td > <label for="fromRO">From</label> <input type="text" size="10" id="fromRO" name="Filter" />
136                                         <label for="toRO">To</label> <input type="text" size="10" id="toRO" name="Filter" value="" />
137                     <span class="hint">[% INCLUDE 'date-format.inc' %]</span>
138                                 </td>
139                         </tr>
140                         <tr> 
141                                 <td>&nbsp;</td>
142                                 <td colspan="2">by <select name="ReturnDisplay">
143                                         <option value=""> </option>
144                                         <option value ="1">Day</option>
145                                         <option value ="2">Month</option>
146                                         <option value ="3">Year</option>
147                                         </select>
148                                         
149                                 </td>
150                                 <td><input type="hidden" name="Filter" value="" /><input type="hidden" name="Filter" value="" /></td>
151                         </tr>
152                         <tr class="hilighted">
153                                 <td>Patron category</td>
154                                 <td><input type="radio" name="Line" value="borrowers.categorycode" /></td>
155                                 <td><input type="radio" name="Column" value="borrowers.categorycode" /></td>
156                 <td>
157                     <select name="Filter" size="1" id="borcat">
158                         <option value=""></option>
159                         [% FOREACH patron_category IN patron_categories %]
160                             <option value="[%- patron_category.categorycode -%]">[%- patron_category.description-%]</option>
161                         [% END %]
162                     </select>
163                 </td>
164                         </tr>
165                         <tr>
166                                 <td>Item type</td>
167                                 <td><input type="radio" name="Line" value="itemtype" /></td>
168                                 <td><input type="radio" name="Column" value="itemtype" /></td>
169                 <td>
170                     <select name="Filter" size="1" id="itemtypes">
171                         <option value=""></option>
172                         [% FOREACH itemtype IN itemtypes %]
173                         <option value="[%- itemtype.itemtype -%]">[%- itemtype.translated_description -%]</option>
174                         [% END %]
175                     </select>
176                 </td>
177                         </tr>
178                         <tr class="hilighted">
179                                 <td>Library</td>
180                                 <td><input type="radio" name="Line" value="branchcode" /></td>
181                                 <td><input type="radio" name="Column" value="branchcode" /></td>
182                 <td>
183                     <select name="Filter" size="1" id="branch">
184                         <option value=""></option>
185                         [% PROCESS options_for_libraries libraries => Branches.all() %]
186                     </select>
187                 </td>
188                         </tr>
189                         [% IF ( hassort1 ) %]
190                                 <tr class="hilighted"> 
191                                         <td>Sort1</td>
192                                         <td><input type="radio" name="Line" value="borrowers.sort1" /></td>
193                                         <td><input type="radio" name="Column" value="borrowers.sort1" /></td>
194                     <td>
195                         <select name="Filter" size="1" id="sort1">
196                             <option value=""></option>
197                             [%- FOREACH value IN Sort1.values %]
198                             <option value="[%- value -%]">[%- value -%]</option>
199                             [%- END %]
200                         </select>
201                     </td>
202                                 </tr>
203                         [% END %]
204                         [% IF ( hassort2 ) %]
205                                 [% IF ( HglghtSort2 ) %]<tr class="hilighted"> [% ELSE %]<tr>[% END %] 
206                                         <td>Sort2</td>
207                                         <td><input type="radio" name="Line" value="borrowers.sort2" /></td>
208                                         <td><input type="radio" name="Column" value="borrowers.sort2" /></td>
209                     <td>
210                         <select name="Filter" size="1" id="sort2">
211                             <option value=""></option>
212                             [%- FOREACH value IN Sort2.values %]
213                             <option value="[%- value -%]">[%- value -%]</option>
214                             [%- END %]
215                         </select>
216                     </td>
217                                 </tr>
218                         [% END %]
219                 </tbody>
220         </table><br /></fieldset>
221         
222         
223         <fieldset class="rows">
224         <legend>Output</legend>
225     <ol>
226         <li>
227             <label for="outputscreen">To screen into the browser: </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
228         </li>
229         <li>
230             <label for="outputfile">To a file:</label> <input type="radio" name="output" value="file" id="outputfile" />
231             <label class="inline" for="basename">Named: </label><input type="text" name="basename" id="basename" value="Export" />
232             <label class="inline" for="MIME">Into an application: </label>
233             <select name="MIME"  size="1" id="MIME">
234                 <option value="CSV">CSV</option>
235             </select>
236             <select name="sep" id="sep" size="1">
237             [% FOREACH value IN CGIsepChoice.values.sort() %]
238               [% IF ( value == CGIsepChoice.default ) %]
239                 <option value="[% value %]" selected="selected">[% value %]</option>
240               [% ELSE %]
241                 <option value="[% value %]">[% value %]</option>
242               [% END %]
243             [% END %]
244             </select>
245         </li>
246     </ol>
247         </fieldset>
248
249         <fieldset class="action">
250         <input type="hidden" name="Filter" value="" />
251         <input type="hidden" name="report_name" value="[% report_name %]" />
252         <input type="hidden" name="do_it" value="1" />
253         <input type="submit" value="Submit" />
254         </fieldset>
255         </form>
256 [% END %]
257
258 </div>
259 </div>
260 <div class="yui-b">
261 [% INCLUDE 'reports-menu.inc' %]
262 </div>
263 </div>
264 [% INCLUDE 'intranet-bottom.inc' %]