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