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

   1 [% SET footerjs = 1 %]
   2 [% INCLUDE 'doc-head-open.inc' %]
   3 <title>Koha &rsaquo; Reports [% IF ( do_it ) %]&rsaquo; Acquisitions statistics &rsaquo; Results[% ELSE %]&rsaquo; Acquisitions statistics[% END %]</title>
   4 [% INCLUDE 'doc-head-close.inc' %]
   5 </head>
   6
   7 <body id="rep_acquisitions_stats" class="rep">
   8 [% INCLUDE 'header.inc' %]
   9 [% INCLUDE 'cat-search.inc' %]
  10
  11 <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/acquisitions_stats.pl">Acquisitions statistics</a> &rsaquo; Results[% ELSE %] &rsaquo; Acquisitions statistics [% END %]</div>
  12
  13 <div id="doc3" class="yui-t2">
  14
  15    <div id="bd">
  16         <div id="yui-main">
  17         <div class="yui-b">
  18
  19 [% IF ( do_it ) %]
  20         [% FOREACH mainloo IN mainloop %]
  21                 <h1>Acquisitions statistics </h1>
  22         [% IF ( mainloo.loopfilter.size ) %]
  23             <p><b>Filtered on:</b></p>
  24             [% FOREACH loopfilte IN mainloo.loopfilter %]
  25                 <p>
  26                     [% SWITCH loopfilte.crit %]
  27                         [% CASE '0' %] Placed on (from)
  28                         [% CASE '1' %] Placed on (to)
  29                         [% CASE '2' %] Received on (from)
  30                         [% CASE '3' %] Received on (to)
  31                         [% CASE '4' %] Vendor
  32                         [% CASE '5' %] Home library
  33                         [% CASE '6' %] Collection
  34                         [% CASE '7' %] Item type
  35                         [% CASE '8' %] Fund
  36                         [% CASE '9' %] Sort1
  37                         [% CASE '10' %] Sort2
  38                         [% CASE %] Unknown filter
  39                     [% END %]
  40                     : [% loopfilte.filter %]
  41                 </p>
  42                         [% END %]
  43                 [% END %]
  44
  45                 <table>
  46                         <tr >
  47                                 <th>[% mainloo.line %] / [% mainloo.column %]</th>
  48                                 [% FOREACH loopco IN mainloo.loopcol %]
  49                                         <th>[% loopco.coltitle %]</th>
  50                                 [% END %]
  51                                 <th>TOTAL</th>
  52                         </tr>
  53                                 [% FOREACH loopro IN mainloo.looprow %]
  54                                         <tr>
  55                                                 [% IF ( loopro.hilighted ) %]<td class="hilighted">[% ELSE %]<td>[% END %]
  56                                                 [% loopro.rowtitle %]</td>
  57                                                 [% FOREACH loopcel IN loopro.loopcell %]
  58                                                         [% IF ( loopcel.hilighted ) %]<td>[% ELSE %]<td>[% END %]
  59                                                                 [% IF ( loopcel.value ) %][% loopcel.value %]
  60                                                                 [% ELSE %] &nbsp;
  61                                                                 [% END %]
  62                                                         </td>
  63                                                 [% END %]
  64                                                 [% IF ( loopro.hilighted ) %]<td>[% ELSE %]<td>[% END %]
  65                                                         [% loopro.totalrow %]
  66                                                 </td>
  67                                         </tr>
  68                                 [% END %]
  69                                 <tr >
  70                                         <th>TOTAL</th>
  71                                         [% FOREACH loopfoote IN mainloo.loopfooter %]
  72                                                 <th>
  73                                                         [% loopfoote.totalcol %]
  74                                                 </th>
  75                                         [% END %]
  76                                         <th>[% mainloo.total %]</th>
  77                                 </tr>
  78                 </table>
  79         [% END %]
  80 [% ELSE %]
  81         <form method="post" action="/cgi-bin/koha/reports/acquisitions_stats.pl">
  82         <fieldset class="rows">
  83         <legend>Acquisitions statistics</legend>
  84         <table>
  85                 <thead>
  86                         <tr>
  87                         <th>Title</th>
  88                         <th>Row</th>
  89                         <th>Column</th>
  90                         <th>Filter</th>
  91                         </tr>
  92                 </thead>
  93                 <tbody>
  94                         <tr class="hilighted">
  95                 <td>Placed on</td>
  96                                 <td><input type="radio" name="Line" value="aqbasket.closedate" /></td>
  97                                 <td><input type="radio" checked="checked" name="Column" value="aqbasket.closedate" /> </td>
  98                                 <td> From <input type="text" size="10" id="from" name="Filter" value="" />
  99                                 <span class="hint">[% INCLUDE 'date-format.inc' %]</span>
 100                                         To <input size="10" id="to" name="Filter" type="text" value="" />
 101                                 <span class="hint">[% INCLUDE 'date-format.inc' %]</span>
 102                                 </td>
 103                         </tr>
 104                         <tr class="hilighted">
 105                                 <td>&nbsp;</td>
 106                                 <td colspan="2">group by <select name="PlacedOnDisplay">
 107                                         <option value="">None</option>
 108                                         <option value ="1">Day of week</option>
 109                                         <option value ="2">Month</option>
 110                                         <option value ="3">Year</option>
 111                                         </select>
 112
 113                                 </td>
 114                                 <td>&nbsp;</td>
 115                         </tr>
 116                         <tr>
 117                 <td>Received on</td>
 118                                 <td><input type="radio" name="Line" value="aqorders.datereceived" /></td>
 119                                 <td><input type="radio" name="Column" value="aqorders.datereceived" /></td>
 120                                 <td> From <input type="text" size="10" id="fromRO" name="Filter" value="" />
 121                                 <span class="hint">[% INCLUDE 'date-format.inc' %]</span>
 122                                         To <input type="text" size="10" id="toRO" name="Filter" value="" />
 123                                 <span class="hint">[% INCLUDE 'date-format.inc' %]</span>
 124                                 </td>
 125                         </tr>
 126                         <tr>
 127                                 <td>&nbsp;</td>
 128                                 <td colspan="2">group by <select name="ReceivedOnDisplay">
 129                                         <option value="">None</option>
 130                                         <option value ="1">Day of week</option>
 131                                         <option value ="2">Month</option>
 132                                         <option value ="3">Year</option>
 133                                         </select>
 134
 135                                 </td>
 136                                 <td>&nbsp;</td>
 137                         </tr>
 138                         <tr class="hilighted">
 139                                 <td>Vendor</td>
 140                                 <td><input type="radio" checked="checked" name="Line" value="aqbooksellers.name" /></td>
 141                                 <td><input type="radio" name="Column" value="aqbooksellers.name" /></td>
 142                 <td>
 143                     <select name="Filter">
 144                         <option value="">All vendors</option>
 145                         [% FOREACH bookseller IN booksellers %]
 146                             <option value="[% bookseller.name %]">[% bookseller.name %]</option>
 147                         [% END %]
 148                     </select>
 149                 </td>
 150             </tr>
 151             <tr>
 152                 <td>Home library</td>
 153                 <td><input type="radio" name="Line" value="items.homebranch" /></td>
 154                 <td><input type="radio" name="Column" value="items.homebranch" /></td>
 155                 <td>
 156                     <select name="Filter">
 157                         <option value="" selected="selected">All libraries</option>
 158                         [% FOREACH branch IN branches %]
 159                             <option value="[% branch.branchcode %]">[% branch.branchname %]</option>
 160                         [% END %]
 161                     </select>
 162                 </td>
 163             </tr>
 164             <tr>
 165                 <td>
 166                     [% IF ccode_label %]
 167                         [% ccode_label %]
 168                     [% ELSE %]
 169                         Collection
 170                     [% END %]
 171                 </td>
 172                 <td><input type="radio" name="Line" value="items.ccode" /></td>
 173                 <td><input type="radio" name="Column" value="items.ccode" /></td>
 174                 <td>
 175                     [% IF ccode_avlist.size %]
 176                         <select name="Filter">
 177                             <option value="" selected="selected">All</option>
 178                             [% FOREACH ccode_av IN ccode_avlist %]
 179                                 <option value="[% ccode_av.value %]">[% ccode_av.lib %]</option>
 180                             [% END %]
 181                         </select>
 182                     [% ELSE %]
 183                         <input type="text" name="Filter" />
 184                     [% END %]
 185                 </td>
 186             </tr>
 187                         <tr>
 188                 <td>Item type</td>
 189                                 <td><input type="radio" name="Line" value="biblioitems.itemtype" /></td>
 190                                 <td><input type="radio" name="Column" value="biblioitems.itemtype" /></td>
 191                 <td>
 192                     <select name="Filter" size="1" id="itemtypes">
 193                         <option value="">All item types</option>
 194                         [% FOREACH itemtype IN itemtypes %]
 195                         <option value="[% itemtype.itemtype %]">[% itemtype.translated_description %]</option>
 196                         [% END %]
 197                     </select>
 198                 </td>
 199                         </tr>
 200
 201                         <tr>
 202                                 <td>Fund</td>
 203                                 <td><input type="radio" name="Line" value="aqbudgets.budget_code" /></td>
 204                                 <td><input type="radio" name="Column" value="aqbudgets.budget_code" /></td>
 205                 <td>
 206                     <select name="Filter" size="1" id="budget">
 207                         <option value="">All funds</option>
 208                         [% FOREACH value IN Budgets.values %]
 209                         <option value="[% value %]">[% Budgets.labels.$value %]</option>
 210                         [% END %]
 211                     </select>
 212                 </td>
 213                         </tr>
 214
 215                         [% IF ( hassort1 ) %]
 216                                 <tr class="hilighted">
 217                                         <td>Sort1</td>
 218                                         <td><input type="radio" name="Line" value="aqorders.sort1" /></td>
 219                                         <td><input type="radio" name="Column" value="aqorders.sort1" /></td>
 220                     <td>
 221                         <select name="Filter" size="1" id="sort1">
 222                             <option value="">All</option>
 223                             [% FOREACH value IN Sort1.values %]
 224                             <option value="[% value %]">[% Sort1.labels.$value %]</option>
 225                             [% END %]
 226                         </select>
 227                     </td>
 228                                 </tr>
 229                         [% END %]
 230                         [% IF ( hassort2 ) %]
 231                                 [% IF ( HglghtSort2 ) %]<tr class="hilighted"> [% ELSE %]<tr>[% END %]
 232                                         <td>Sort2</td>
 233                                         <td><input type="radio" name="Line" value="aqorders.sort2" /></td>
 234                                         <td><input type="radio" name="Column" value="aqorders.sort2" /></td>
 235                     <td>
 236                         <select name="Filter" size="1" id="sort2">
 237                             <option value="">All</option>
 238                             [% FOREACH value IN Sort2.values %]
 239                             <option value="[% value %]">[% Sort2.labels.$value %]</option>
 240                             [% END %]
 241                         </select>
 242                     </td>
 243                                 </tr>
 244                         [% END %]
 245                 </tbody>
 246         </table><br />
 247         </fieldset>
 248
 249 <fieldset class="rows">
 250     <legend> Cell value </legend>
 251     <ol>
 252         <li>
 253             <label for="cellvalue1">Count items:</label><input type="radio" name="Cellvalue" id="cellvalue1" value="1" checked="checked" />
 254         </li>
 255         <li>
 256             <label for="cellvalue2">Count unique biblios:</label><input type="radio" name="Cellvalue" id="cellvalue2" value="2" />
 257         </li>
 258         <li>
 259             <label for="cellvalue3">Amount:</label><input type="radio" name="Cellvalue" id="cellvalue3" value="3" />
 260         </li>
 261         <li>
 262             <label for="cellvalue4">Ordered amount:</label><input type="radio" name="Cellvalue" id="cellvalue4" value="4" />
 263         </li>
 264         <li>
 265             <label for="cellvalue5">Spent amount:</label><input type="radio" name="Cellvalue" id="cellvalue5" value="5" />
 266         </li>
 267     </ol>
 268 </fieldset>
 269
 270         <fieldset class="rows">
 271         <legend>Output</legend>
 272     <ol>
 273         <li>
 274             <label for="outputscreen">To screen into the browser: </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
 275         </li>
 276         <li>
 277             <label for="outputfile">To a file:</label> <input type="radio" name="output" value="file" id="outputfile" />
 278             <label class="inline" for="basename">Named: </label> <input type="text" name="basename" id="basename" value="Export" />
 279             <label class="inline" for="MIME">Into an application:</label>
 280             <select name="MIME" id="MIME" size="1">
 281                 <option value="CSV">CSV</option>
 282             </select>
 283             <select name="sep" id="sep" size="1">
 284             [% FOREACH value IN CGIsepChoice.values.sort() %]
 285               [% IF ( value == CGIsepChoice.default ) %]
 286                 <option value="[% value %]" selected="selected">[% value %]</option>
 287               [% ELSE %]
 288                 <option value="[% value %]">[% value %]</option>
 289               [% END %]
 290             [% END %]
 291             </select>
 292         </li>
 293     </ol>
 294         </fieldset>
 295
 296         <fieldset class="action">
 297         <input type="submit" value="Submit" />
 298         <input type="hidden" name="report_name" value="[% report_name %]" />
 299         <input type="hidden" name="do_it" value="1" />
 300         </fieldset>
 301         </form>
 302 [% END %]
 303 </div>
 304 </div>
 305 <div class="yui-b">
 306 [% INCLUDE 'reports-menu.inc' %]
 307 </div>
 308 </div>
 309
 310 [% MACRO jsinclude BLOCK %]
 311     [% INCLUDE 'calendar.inc' %]
 312     <script type="text/javascript">
 313         $(document).ready(function() {
 314             // http://jqueryui.com/demos/datepicker/#date-range
 315             var dates = $( "#from, #to" ).datepicker({
 316                 changeMonth: true,
 317                 numberOfMonths: 1,
 318                 onSelect: function( selectedDate ) {
 319                     var option = this.id == "from" ? "minDate" : "maxDate",
 320                         instance = $( this ).data( "datepicker" );
 321                         date = $.datepicker.parseDate(
 322                             instance.settings.dateFormat ||
 323                             $.datepicker._defaults.dateFormat,
 324                             selectedDate, instance.settings );
 325                     dates.not( this ).datepicker( "option", option, date );
 326                 }
 327             });
 328             var datesRO = $( "#fromRO, #toRO" ).datepicker({
 329                 changeMonth: true,
 330                 numberOfMonths: 1,
 331                 onSelect: function( selectedDate ) {
 332                     var option = this.id == "fromRO" ? "minDate" : "maxDate",
 333                         instance = $( this ).data( "datepicker" );
 334                         date = $.datepicker.parseDate(
 335                             instance.settings.dateFormat ||
 336                             $.datepicker._defaults.dateFormat,
 337                             selectedDate, instance.settings );
 338                     datesRO.not( this ).datepicker( "option", option, date );
 339                 }
 340             });
 341         });
 342     </script>
 343 [% END %]
 344
 345 [% INCLUDE 'intranet-bottom.inc' %]