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