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

   1 [% INCLUDE 'doc-head-open.inc' %]
   2 <title>Koha &rsaquo; Reports &rsaquo; Guided reports &rsaquo; Dictionary</title>
   3 [% INCLUDE 'doc-head-close.inc' %]
   4 [% INCLUDE 'calendar.inc' %]
   5 <style type="text/css">fieldset.rows table { clear: none; margin: 0;}</style>
   6 </head>
   7 <body id="rep_dictionary" class="rep">
   8 [% INCLUDE 'header.inc' %]
   9 [% INCLUDE 'circ-search.inc' %]
  10
  11 [%- BLOCK area_name -%]
  12     [%- SWITCH area -%]
  13         [%- CASE 'CIRC' -%]Circulation
  14         [%- CASE 'CAT'  -%]Catalog
  15         [%- CASE 'PAT'  -%]Patrons
  16         [%- CASE 'ACQ'  -%]Acquisitions
  17         [%- CASE 'ACC'  -%]Accounts
  18     [%- END -%]
  19 [%- END -%]
  20
  21 <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/guided_reports.pl">Guided reports wizard</a>
  22 [% IF ( new_dictionary ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Name the new definition</strong>
  23 [% ELSIF ( step_2 ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Step 2: Choose the area </strong>
  24 [% ELSIF ( step_3 ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Step 3: Choose columns </strong>
  25 [% ELSIF ( step_4 ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Step 4: Specify a value </strong>
  26 [% ELSIF ( step_5 ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Step 5: Confirm definition</strong>
  27 [% ELSE %] &rsaquo; <strong> Dictionary </strong>[% END %]</div>
  28
  29 <div id="doc3" class="yui-t2">
  30
  31 <div id="bd">
  32 <div id="yui-main">
  33 <div class="yui-b">
  34 [% IF ( start_dictionary ) %]
  35     <div id="toolbar">
  36         <ul class="toolbar">
  37             <li><a id="newdictionary" class="btn btn-small" href="/cgi-bin/koha/reports/dictionary.pl?phase=Add%20New%20Definition"><i class="icon-plus"></i> New definition</a></li>
  38         </ul>
  39     </div>
  40 [% END %]
  41 <h1>Dictionary</h1>
  42 [% IF ( start_dictionary ) %]
  43         <p>Use the dictionary to define custom criteria for reporting.</p>
  44
  45                 [% IF ( definitions ) %]
  46         <h2>Current terms</h2>
  47                 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
  48         <input type="hidden" name="phase" value="View Dictionary" />
  49   [% IF ( areas ) %]
  50         Filter by area
  51         <select name="area">
  52           <option value="">All</option>
  53         [% FOREACH area IN areas %]
  54           [%- IF ( area.selected ) -%]
  55           <option value="[% area.id %]" selected="selected">[%- PROCESS area_name area=area.id -%]</option>
  56           [%- ELSE -%]
  57           <option value="[% area.id %]">[%- PROCESS area_name area=area.id -%]</option>
  58           [%- END -%]
  59         [% END %]
  60         </select>
  61       <input name="submit" value="Go" type="submit" />
  62   [% END %]
  63       </form>
  64       <br />
  65                 <table border="1" cellspacing="0" cellpadding="5">
  66                 <tr>
  67                 <th>Name</th>
  68                 <th>Description</th>
  69                 <th>Area</th>
  70                 <th>Definition</th>
  71                 <th>&nbsp;</th>
  72                 </tr>
  73                 [% FOREACH definition IN definitions %]
  74                         [% UNLESS ( loop.odd ) %]
  75                                 <tr class="highlight" valign="top">
  76                         [% ELSE %]
  77                                 <tr valign="top">
  78                         [% END %]
  79                         <td>[% definition.name %]</td>
  80                         <td>[% definition.description %]</td>
  81                         <td>[% definition.areaname %]</td>
  82                         <td>[% definition.saved_sql %]</td>
  83                         <td><form method="post" action="/cgi-bin/koha/reports/dictionary.pl">
  84                         <input type="hidden" name="id" value="[% definition.id %]" />
  85                         <input type="hidden" name="phase" value="Delete Definition" />
  86                         <input type="submit" name="submit" value="Delete Definition" />
  87                         </form></td>
  88                         </tr>
  89                 [% END %]
  90                 </table>
  91                 [% END %]
  92 [% END %]
  93
  94 [% IF ( new_dictionary ) %]
  95 <h3>Add new definition</h3>
  96 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
  97 <fieldset class="rows"><legend>Step 1 of 5: Name the new definition</legend><ol>
  98 <li>
  99 <label for="definition_name">Definition name:</label>
 100 <input type="text" id="definition_name" name="definition_name" />
 101 </li>
 102 <li>
 103 <label for="definition_description">Definition description:</label>
 104 <textarea name="definition_description" id="definition_description" rows="3" cols="20"></textarea>
 105 </li>
 106 </ol></fieldset>
 107
 108 <fieldset class="action"><input type="hidden" name="phase" value="New Term step 2" />
 109 <input name="submit" value="Next" type="submit" /></fieldset>
 110 </form>
 111 [% END %]
 112
 113 [%- IF ( step_2 ) -%]
 114 <h3>Add new definition</h3>
 115 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
 116   <fieldset class="rows">
 117     <legend>Step 2 of 5: Choose the area</legend>
 118     <ol>
 119       <li>
 120         <input type="hidden" name="phase" value="New Term step 3" />
 121         <input type="hidden" name="definition_name" value="[% definition_name %]" />
 122         <input type="hidden" name="definition_description" value="[% definition_description %]" />
 123         <label for="area">Select table </label><select name="area" id="area">
 124       [%- FOREACH area IN areas -%]
 125         <option value="[%- area.id -%]">[%- PROCESS area_name area=area.id -%]</option>
 126       [%- END -%]
 127         </select>
 128       </li>
 129     </ol>
 130   </fieldset>
 131   <fieldset class="action"><input name="submit" value="Next" type="submit" /></fieldset>
 132 </form>
 133 [%- END -%]
 134
 135 [% IF ( step_3 ) %]
 136 <h3>Add new definition</h3>
 137 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
 138 <fieldset class="rows">
 139 <legend>Step 3 of 5: Choose columns</legend>
 140 <input type="hidden" name="area" value="[% area %]" />
 141 <input type="hidden" name="definition_name" value="[% definition_name %]" />
 142 <input type="hidden" name="definition_description" value="[% definition_description %]" />
 143
 144 <table style="border: 0;margin:1em;"><tr>
 145 <td style="border: 0;"><select id="availableColumns" name="oldcolumns2" size="25" style="width:200px;height:300px;">
 146 [% FOREACH column IN columns %]
 147 [% IF ( column.table ) %]
 148 [% IF ( loop.first ) %]
 149 [% ELSE %]
 150 </optgroup>
 151 [% END %]
 152
 153 <optgroup label="[% column.table %]">
 154 [% ELSE %]
 155 <option value="[% column.name %]">
 156 [% IF ( column.description ) %][% column.description %]
 157 [% ELSE %]
 158 [% column.name %]
 159 [% END %]
 160 </option>
 161 [% END %]
 162 [% END %]
 163 </optgroup>
 164 </select></td>
 165
 166 <td style="border: 0;"><input type="button" name="Add" value="Add" class="button"  style="width : 6em; margin-bottom : .5em;" onclick="addColumn()" /><br /><input type="button" name="delete" value="&lt;&lt; Delete" class="button" style="width : 6em;"  onclick="delColumn()" />  </td>
 167
 168 <td style="border: 0;"><select id="selectedColumns" name="columns" size="25" style="width:200px;height:300px;"></select>     </td>   </tr></table>
 169
 170 <input type="hidden" name="phase" value="New Term step 4" />
 171 </fieldset>
 172 <fieldset class="action"><input type="submit" name="submit" value="Next" /></fieldset>
 173 </form>
 174 [% END %]
 175
 176 [% IF ( step_4 ) %]
 177 <h3>Add new definition</h3>
 178 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
 179 <fieldset class="rows">
 180 <legend>Step 4 of 5: Specify a value</legend>
 181 <input type="hidden" name="area" value="[% area %]" />
 182 <input type="hidden" name="definition_name" value="[% definition_name %]" />
 183 <input type="hidden" name="definition_description" value="[% definition_description %]" />
 184 <input type="hidden" name="columnstring" value="[% columnstring %]" />
 185
 186 [% FOREACH column IN columns %]
 187 <input type="hidden" name="criteria_column" value="[% column.name %]" />
 188 <ol><li><span class="label">Column: </span> [% column.name %]</li>
 189 [% IF ( column.distinct ) %]
 190         <li><label for="[% column.name %]_value">Choose: </label> <select id="[% column.name %]_value" name="[% column.name %]_value">
 191                 [% FOREACH value IN column.values %]
 192                         <option value="[% value.availablevalues %]">[% value.availablevalues %]</option>
 193                 [% END %]
 194         </select></li>
 195 [% END %]
 196 [% IF ( column.date ) %]
 197         <li><span class="label">Choose: </span><table>
 198         <tr valign="top">
 199         <td><input type="radio" name="[% column.name %]_all" value="all" />All dates</td>
 200         <td>OR</td>
 201         <td><input type="radio" name="dates" value="range" />Date range<br />
 202         <table>
 203         <tr>
 204         <td>Start of date range</td>
 205     <td><input type="text" size="10" id="from" name="[% column.name %]_start_value" value="" class="datepickerfrom" />
 206         <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
 207         </td>
 208         </tr>
 209         <tr>
 210         <td>End of date range</td>
 211         <td>
 212     <input type="text" size="10" id="to" name="[% column.name %]_end_value" value="" class="datepickerto" />
 213         <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
 214         </td>
 215         </tr>
 216         </table></td>
 217         </tr>
 218 </table></li>
 219 [% END %]
 220 [% IF ( column.text ) %]
 221         <li><label for="[% column.name %]_value">Search string matches: </label> <input type="text" size="13" name="[% column.name %]_value" /></li>
 222 [% END %]
 223
 224 [% END %]
 225 </ol>
 226 <input type="hidden" name="phase" value="New Term step 5" />
 227 </fieldset>
 228 <fieldset class="action">
 229 <input type="submit" name="submit" value="Next" />
 230 </fieldset>
 231 </form>
 232 [% END %]
 233
 234 [% IF ( step_5 ) %]
 235 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
 236 <input type="hidden" name="area" value="[% area %]" />
 237 <input type="hidden" name="definition_name" value="[% definition_name %]" />
 238 <input type="hidden" name="definition_description" value="[% definition_description %]" />
 239 <input type="hidden" name="columnstring" value="[% columnstring %]" />
 240
 241 <h3>Add new definition</h3>
 242
 243 <fieldset class="rows">
 244   <legend>Step 5 of 5: Confirm details</legend>
 245   <ol>
 246     <li>
 247       <span class="label">Name:</span>[%- definition_name -%]
 248     </li>
 249     <li>
 250       <span class="label">Description:</span>[%- definition_description -%]
 251     </li>
 252     <li>
 253       <span class="label">Area:</span>[%- PROCESS area_name area=area -%]
 254     </li>
 255     <li>
 256       <span class="label">Data:</span>
 257       <table>
 258         <tr>
 259           <th>Columns</th>
 260           <th>Values</th>
 261         </tr>
 262       [%- FOREACH criteria_loo IN criteria_loop -%]
 263         <tr>
 264           <td>[%- criteria_loo.name -%]</td>
 265           <td>[%- criteria_loo.value -%]</td>
 266         </tr>
 267       [%- END -%]
 268       </table>
 269     </li>
 270   </ol>
 271 </fieldset>
 272
 273 <fieldset class="action"><input type="hidden" name="sql" value="[% query %]" />
 274 <input type="hidden" name="phase" value="New Term step 6" />
 275 <input type="submit" name="submit" value="Save" />         </fieldset>
 276
 277 </form>
 278 [% END %]
 279 </div>
 280 </div>
 281 <div class="yui-b">
 282 [% INCLUDE 'guided-reports-view.inc' %]
 283 </div>
 284 </div>
 285 <script type="text/javascript">
 286 //<![CDATA[
 287 function setObjects() {
 288     selectedColumnsObj=document.getElementById('selectedColumns');
 289         availableColumnsObj=document.getElementById('availableColumns');
 290 }
 291 setObjects();
 292
 293 function addColumn() {
 294   for (i=0;i<availableColumnsObj.length;i++) {
 295     if (availableColumnsObj.options[i].selected==true) {
 296           var newColumnObj=document.createElement("OPTION");
 297           newColumnObj.value=availableColumnsObj.options[i].value;
 298           newColumnObj.text=availableColumnsObj.options[i].text;
 299           selectedColumnsObj.appendChild(newColumnObj);
 300           newColumnObj.selected=true;
 301         }
 302   }
 303 }
 304
 305 function delColumn() {
 306   for (i=0;i<=selectedColumnsObj.options.length;i++) {
 307     if (selectedColumnsObj.options.selectedIndex>=0) {
 308           selectedColumnsObj.remove(selectedColumnsObj.options.selectedIndex)
 309     }
 310   }
 311 }
 312 //]]>
 313 </script>
 314
 315 [% INCLUDE 'intranet-bottom.inc' %]