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

   1 [% INCLUDE 'doc-head-open.inc' %]
   2 <title>Koha &rsaquo; Reports [% IF ( do_it ) %]&rsaquo; Patrons statistics &rsaquo; Results[% ELSE %]&rsaquo; Patrons statistics[% END %]</title>
   3 [% INCLUDE 'doc-head-close.inc' %]
   4 [% INCLUDE 'calendar.inc' %]
   5 <style type="text/css">
   6         .sql {display:none;}
   7         .debug {display:none;}
   8 </style>
   9 </head>
  10 <body>
  11 [% INCLUDE 'header.inc' %]
  12 [% INCLUDE 'cat-search.inc' %]
  13
  14 <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; <a href="/cgi-bin/koha/reports/borrowers_stats.pl">Patrons statistics</a>[% IF ( do_it ) %] &rsaquo; Results[% END %]</div>
  15
  16 <div id="doc3" class="yui-t2">
  17
  18    <div id="bd">
  19         <div id="yui-main">
  20         <div class="yui-b">
  21
  22 [% IF ( do_it ) %]
  23         [% FOREACH mainloo IN mainloop %]
  24                 <h1>Patrons statistics</h1>
  25                 [% IF ( mainloo.loopfilter ) %]
  26                         <p>Filtered on</p>
  27                         [% FOREACH loopfilte IN mainloo.loopfilter %]
  28                                 <p>
  29                                         [% loopfilte.crit %] = [% loopfilte.filter %]
  30                                 </p>
  31                         [% END %]
  32                 [% END %]
  33                 <table>
  34                         <tr>
  35                                 <th>[% mainloo.line %] / [% mainloo.column %]</th>
  36                                 [% FOREACH loopco IN mainloo.loopcol %]
  37                                         <th>[% IF ( loopco.coltitle_display ) %][% loopco.coltitle_display %][% ELSE %][% loopco.coltitle %][% END %]
  38                                         </th>
  39                                 [% END %]
  40                                 <th>TOTAL</th>
  41                         </tr>
  42                                 [% FOREACH loopro IN mainloo.looprow %]
  43                                         <tr[% UNLESS ( loop.odd ) %] class="highlight"[% END %]>
  44                                                 <td>[% IF ( loopro.rowtitle_display ) %][% loopro.rowtitle_display %][% ELSE %][% loopro.rowtitle %][% END %]
  45                                                 </td>
  46                                                 [% FOREACH loopcel IN loopro.loopcell %]
  47                                                 <td>[% IF ( loopcel.value ) %][% loopcel.value %][% ELSE %]&nbsp;[% END %]
  48                                                 </td>
  49                                                 [% END %]
  50                                                 <td>[% loopro.totalrow %]</td>
  51                                         </tr>
  52                                 [% END %]
  53                                 <tr>
  54                                         <th>TOTAL</th>
  55                                         [% FOREACH loopfoote IN mainloo.loopfooter %]
  56                                                 <th>[% loopfoote.totalcol %]</th>
  57                                         [% END %]
  58                                         <th>[% mainloo.total %]</th>
  59                                 </tr>
  60                 </table>
  61         [% END %]
  62 [% ELSE %]
  63
  64         <form method="post" action="/cgi-bin/koha/reports/borrowers_stats.pl">
  65         <fieldset class="rows"><legend>Patrons statistics</legend>
  66         <table>
  67                 <thead>
  68                         <tr>
  69                         <th>Title</th>
  70                         <th>Row</th>
  71                         <th>Column</th>
  72                         <th>Filter</th>
  73                         </tr>
  74                 </thead>
  75                 <tbody>
  76                         <tr class="highlight">
  77                         <td>Patron category</td>
  78                         <td><input type="radio" name="Line" value="categorycode" /></td>
  79                         <td><input type="radio" name="Column" value="categorycode" /></td>
  80                         <td><select name="Filter"  size="1" id="catcode">
  81                                 <option value=""></option>
  82                                 [% FOREACH CAT_LOO IN CAT_LOOP %]
  83                                 <option value="[% CAT_LOO.categorycode %]">[% CAT_LOO.description %]</option>
  84                                 [% END %]
  85                                 </select>
  86                         </td>
  87                         </tr>
  88                         <tr>
  89                         <td>Patron status</td>
  90                         <td colspan="2"></td>
  91                         <td ><select name="status"><option value=""> </option><option value="debarred">debarred</option><option value="gonenoadress">gone no address</option><option value="lost">lost</option></select></td>
  92                         </tr>
  93                         <tr class="highlight">
  94                         <td>Patron activity</td>
  95                         <td colspan="2"><select name="period" id="period">
  96                         <option value="1">1</option>
  97                         <option value="2">2</option>
  98                         <option value="3">3</option>
  99                         </select>
 100                         <label for="period">years of activity</label>
 101                         </td>
 102                         <td><select name="activity"><option value=""> </option><option value="active">active</option><option value="nonactive">no active</option></select></td>
 103                         </tr>
 104
 105                         <tr>
 106                         <td rowspan="2">Zip Code</td>
 107                         <td><input type="radio" name="Line" value="zipcode" /></td>
 108                         <td><input type="radio" name="Column" value="zipcode" /></td>
 109                         <td><select name="Filter"  size="1" id="zipcode">
 110                                 <option value=""> </option>
 111                                 [% FOREACH ZIP_LOO IN ZIP_LOOP %]
 112                                 <option value="[% ZIP_LOO.zipcode %]">[% ZIP_LOO.zipcode %]</option>
 113                                 [% END %]
 114                                 </select>
 115                         </td>
 116                         </tr>
 117                         <tr>
 118                         <td colspan="2"><select name="digits" id="digits">
 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>
 125                         <option value ="6">6</option>
 126                         <option value ="7">7</option>
 127                         <option value ="8">8</option>
 128                         <option value ="9">9</option>
 129                         <option value ="10">10</option>
 130                         </select>
 131                         <label for="digits">digits</label>
 132                         </td>
 133                         <td>&nbsp;</td>
 134                         </tr>
 135
 136                         <tr class="highlight">
 137                         <td>Library</td>
 138                         <td><input type="radio" name="Line"   value="branchcode" /></td>
 139                         <td><input type="radio" name="Column" value="branchcode" /></td>
 140                         <td>
 141                                 <select name="Filter"  size="1" id="branch">
 142                                 <option value=""></option>
 143                                 [% FOREACH BRANCH_LOO IN BRANCH_LOOP %]
 144                                         <option value="[% BRANCH_LOO.branchcode %]">[% BRANCH_LOO.branchcode %] - [% BRANCH_LOO.branchname %]</option>
 145                                 [% END %]
 146                                 </select>
 147                         </td>
 148                         </tr>
 149                     <tr>
 150             <td>Date of Birth</td>
 151             <td colspan="2"></td>
 152                 <td><label for="from">From</label> <input type="text" readonly="readonly" size="10" id="from" name="Filter" />
 153                     <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="openCalendarFrom" style="cursor: pointer;" />
 154                    <script type="text/javascript">
 155                                    //<![CDATA[
 156                                     function validate1(date) {
 157                         var day = date.getDate();
 158                         var month = date.getMonth() + 1;
 159                         var year = date.getFullYear();
 160                         var weekDay = date.getDay();
 161                         var dayMonth = month + '-' + day;
 162                         var dateString = year + '-' + month + '-' + day;
 163                         var dateTo = document.getElementById('to').value.split("-");
 164                         var limitDate = new Date(dateTo[0], (dateTo[1] - 1), dateTo[2]);
 165                         if (date > limitDate) {
 166                                 return true;
 167                         } else {
 168                                 return false;
 169                         }
 170                     }
 171                     Calendar.setup({
 172                             inputField : "from",
 173                             ifFormat : "[% DHTMLcalendar_dateformat %]",
 174                             button : "openCalendarFrom",
 175                             disableFunc : validate1,
 176                             dateStatusFunc : validate1
 177                     });
 178                                         //]]>
 179                     </script>
 180                     <label for="to">To</label> <input readonly="readonly" size="10" id="to" name="Filter" value="" type="text" />
 181                         <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" id="openCalendarTo" style="cursor: pointer;" border="0" />
 182                           <script type="text/javascript">
 183                                                   //<![CDATA[
 184                                                    function validate2(date) {
 185                                 var day = date.getDate();
 186                                 var month = date.getMonth() + 1;
 187                                 var year = date.getFullYear();
 188                                 var weekDay = date.getDay();
 189                                 var dayMonth = month + '-' + day;
 190                                 var dateString = year + '-' + month + '-' + day;
 191                                 var dateFrom = document.getElementById('from').value.split("-");
 192                                 var limitDate = new Date(dateFrom[0], (dateFrom[1] - 1), dateFrom[2]);
 193                                 if (limitDate > date) {
 194                                         return true;
 195                                 } else {
 196                                         return false;
 197                                 }
 198                             }
 199
 200                             Calendar.setup({
 201                                     inputField : "to",
 202                                     ifFormat : "[% DHTMLcalendar_dateformat %]",
 203                                     button : "openCalendarTo",
 204                                     disableFunc : validate2,
 205                                     dateStatusFunc : validate2
 206                             });
 207                                                         //]]>
 208                         </script><span class="hint">[% INCLUDE 'date-format.inc' %]</span>
 209                     </td>
 210                 </tr>
 211             <tr>
 212                 <td>Sex</td>
 213                 <td><input type="radio" name="Line" value="sex" /></td>
 214                 <td><input type="radio" name="Column" value="sex" /></td>
 215                 <td>
 216                     <select id="sex" size="1" name="Filter">
 217                         <option value="" />
 218                         <option value="M">Men</option>
 219                         <option value="F">Women</option>
 220                     </select>
 221                 </td>
 222             </tr>
 223                         [% IF ( SORT1_LOOP ) %]
 224                                 <tr class="highlight">
 225                                 <td>Sort1</td>
 226                                 <td><input type="radio" name="Line" value="sort1" /></td>
 227                                 <td><input type="radio" name="Column" value="sort1" /></td>
 228                                 <td>
 229                                         <select id="sort1" size="1" name="Filter">
 230                                         <option value=""/>
 231                                         [% FOREACH SORT1_LOO IN SORT1_LOOP %]
 232                                                 <option value="[% SORT1_LOO.authorized_value %]">[% SORT1_LOO.lib %]</option>
 233                                         [% END %]
 234                                         </select>
 235                                 </td>
 236                                 </tr>
 237                         [% END %]
 238                         [% IF ( SORT2_LOOP ) %]
 239                                 <tr[% UNLESS ( SORT1_LOOP ) %] class="highlight"[% END %]>
 240                                 <td>Sort2</td>
 241                                 <td><input type="radio" name="Line" value="sort2" /></td>
 242                                 <td><input type="radio" name="Column" value="sort2" /></td>
 243                                 <td>
 244                                         <select id="sort2" size="1" name="Filter">
 245                                         <option value=""/>
 246                                         [% FOREACH SORT2_LOO IN SORT2_LOOP %]
 247                                                 <option value="[% SORT2_LOO.value %]">[% SORT2_LOO.value %]</option>
 248                                         [% END %]
 249                                         </select>
 250                                 </td>
 251                                 </tr>
 252                         [% END %]
 253                 </tbody>
 254         </table><br /></fieldset>
 255
 256         <fieldset class="rows">
 257         <legend>Output</legend>
 258 <ol><li><label for="outputscreen">To screen into the browser: </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" /> </li>
 259 <li><label for="outputfile">To a file:</label>          <input type="radio" name="output" value="file" id="outputfile" /> <label class="inline" for="basename">Named: </label><input type="text" name="basename" id="basename" value="Export" /> <label class="inline" for="MIME">Into an application
 260                 </label>[% CGIextChoice %]
 261                 [% CGIsepChoice %]</li></ol>
 262         </fieldset>
 263
 264         <fieldset class="action">
 265         <input type="submit" value="Submit" />
 266         <input type="hidden" name="report_name" value="[% report_name %]" />
 267         <input type="hidden" name="do_it" value="1" />
 268         </fieldset>
 269         </form>
 270 [% END %]
 271
 272 </div>
 273 </div>
 274 <div class="yui-b">
 275 [% INCLUDE 'reports-menu.inc' %]
 276 </div>
 277 </div>
 278 [% INCLUDE 'intranet-bottom.inc' %]