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 a column </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="fa fa-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         <tr>
  75                         <td>[% definition.name %]</td>
  76                         <td>[% definition.description %]</td>
  77                         <td>[% definition.areaname %]</td>
  78                         <td>[% definition.saved_sql %]</td>
  79                         <td><form method="post" action="/cgi-bin/koha/reports/dictionary.pl">
  80                         <input type="hidden" name="id" value="[% definition.id %]" />
  81                         <input type="hidden" name="phase" value="Delete Definition" />
  82                         <input type="submit" name="submit" value="Delete Definition" />
  83                         </form></td>
  84                         </tr>
  85                 [% END %]
  86                 </table>
  87                 [% END %]
  88 [% END %]
  89
  90 [% IF ( new_dictionary ) %]
  91 <h3>Add new definition</h3>
  92 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
  93 <fieldset class="rows"><legend>Step 1 of 5: Name the new definition</legend><ol>
  94 <li>
  95 <label for="definition_name">Definition name:</label>
  96 <input type="text" id="definition_name" name="definition_name" />
  97 </li>
  98 <li>
  99 <label for="definition_description">Definition description:</label>
 100 <textarea name="definition_description" id="definition_description" rows="3" cols="20"></textarea>
 101 </li>
 102 </ol></fieldset>
 103
 104 <fieldset class="action"><input type="hidden" name="phase" value="New Term step 2" />
 105 <input name="submit" value="Next" type="submit" /></fieldset>
 106 </form>
 107 [% END %]
 108
 109 [%- IF ( step_2 ) -%]
 110 <h3>Add new definition</h3>
 111 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
 112   <fieldset class="rows">
 113     <legend>Step 2 of 5: Choose the area</legend>
 114     <ol>
 115       <li>
 116         <input type="hidden" name="phase" value="New Term step 3" />
 117         <input type="hidden" name="definition_name" value="[% definition_name %]" />
 118         <input type="hidden" name="definition_description" value="[% definition_description %]" />
 119         <label for="area">Select table:</label><select name="area" id="area">
 120       [%- FOREACH area IN areas -%]
 121         <option value="[%- area.id -%]">[%- PROCESS area_name area=area.id -%]</option>
 122       [%- END -%]
 123         </select>
 124       </li>
 125     </ol>
 126   </fieldset>
 127   <fieldset class="action"><input name="submit" value="Next" type="submit" /></fieldset>
 128 </form>
 129 [%- END -%]
 130
 131 [% IF ( step_3 ) %]
 132 <h3>Add new definition</h3>
 133 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
 134 <fieldset class="rows">
 135 <legend>Step 3 of 5: Choose a column</legend>
 136 <input type="hidden" name="area" value="[% area %]" />
 137 <input type="hidden" name="definition_name" value="[% definition_name %]" />
 138 <input type="hidden" name="definition_description" value="[% definition_description %]" />
 139
 140 <select id="availableColumns" name="columns" size="25" style="width:200px;height:300px;margin:1em;">
 141 [% FOREACH column IN columns %]
 142 [% IF ( column.table ) %]
 143 [% IF ( loop.first ) %]
 144 [% ELSE %]
 145 </optgroup>
 146 [% END %]
 147
 148 <optgroup label="[% column.table %]">
 149 [% ELSE %]
 150 <option value="[% column.name %]">
 151 [% IF ( column.description ) %][% column.description %]
 152 [% ELSE %]
 153 [% column.name %]
 154 [% END %]
 155 </option>
 156 [% END %]
 157 [% END %]
 158 </optgroup>
 159 </select>
 160
 161 <input type="hidden" name="phase" value="New Term step 4" />
 162 </fieldset>
 163 <fieldset class="action"><input type="submit" name="submit" value="Next" /></fieldset>
 164 </form>
 165 [% END %]
 166
 167 [% IF ( step_4 ) %]
 168 <h3>Add new definition</h3>
 169 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
 170 <fieldset class="rows">
 171 <legend>Step 4 of 5: Specify a value</legend>
 172 <input type="hidden" name="area" value="[% area %]" />
 173 <input type="hidden" name="definition_name" value="[% definition_name %]" />
 174 <input type="hidden" name="definition_description" value="[% definition_description %]" />
 175 <input type="hidden" name="columnstring" value="[% columnstring %]" />
 176
 177 [% FOREACH column IN columns %]
 178 <input type="hidden" name="criteria_column" value="[% column.name %]" />
 179 <ol><li><span class="label">Column: </span> [% column.name %]</li>
 180 [% IF ( column.distinct ) %]
 181         <li><label for="[% column.name %]_value">Choose: </label> <select id="[% column.name %]_value" name="[% column.name %]_value">
 182                 [% FOREACH value IN column.values %]
 183                         <option value="[% value.availablevalues %]">[% value.availablevalues %]</option>
 184                 [% END %]
 185         </select></li>
 186 [% END %]
 187 [% IF ( column.date ) %]
 188     <li class="radio">
 189         <label for="all_dates">All dates</label>
 190         <input type="radio" id="all_dates" name="[% column.name %]_date_type_value" value="all" checked="checked" />
 191         <label for="date_range">Date range</label>
 192         <input type="radio" id="date_range" name="[% column.name %]_date_type_value" value="range" />
 193     </li>
 194     <li class="radio">
 195         Start of date range
 196         <input type="text" size="10" id="from" name="[% column.name %]_start_value" value="" class="datepickerfrom" />
 197         <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
 198         End of date range
 199         <input type="text" size="10" id="to" name="[% column.name %]_end_value" value="" class="datepickerto" />
 200         <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
 201     </li>
 202 [% END %]
 203 [% IF ( column.text ) %]
 204         <li><label for="[% column.name %]_value">Search string matches: </label> <input type="text" size="13" name="[% column.name %]_value" /></li>
 205 [% END %]
 206
 207 [% END %]
 208 </ol>
 209 <input type="hidden" name="phase" value="New Term step 5" />
 210 </fieldset>
 211 <fieldset class="action">
 212 <input type="submit" name="submit" value="Next" />
 213 </fieldset>
 214 </form>
 215 [% END %]
 216
 217 [% IF ( step_5 ) %]
 218 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
 219 <input type="hidden" name="area" value="[% area %]" />
 220 <input type="hidden" name="definition_name" value="[% definition_name %]" />
 221 <input type="hidden" name="definition_description" value="[% definition_description %]" />
 222 <input type="hidden" name="columnstring" value="[% columnstring %]" />
 223
 224 <h3>Add new definition</h3>
 225
 226 <fieldset class="rows">
 227   <legend>Step 5 of 5: Confirm details</legend>
 228   <ol>
 229     <li>
 230       <span class="label">Name:</span>[%- definition_name -%]
 231     </li>
 232     <li>
 233       <span class="label">Description:</span>[%- definition_description -%]
 234     </li>
 235     <li>
 236       <span class="label">Area:</span>[%- PROCESS area_name area=area -%]
 237     </li>
 238     <li>
 239       <span class="label">Data:</span>
 240       <table>
 241         <tr>
 242           <th>Columns</th>
 243           <th>Values</th>
 244         </tr>
 245       [%- FOREACH criteria_loo IN criteria_loop -%]
 246         <tr>
 247           <td>[%- criteria_loo.name -%]</td>
 248           <td>[%- criteria_loo.value -%]</td>
 249         </tr>
 250       [%- END -%]
 251       </table>
 252     </li>
 253   </ol>
 254 </fieldset>
 255
 256 <fieldset class="action"><input type="hidden" name="sql" value="[% query %]" />
 257 <input type="hidden" name="phase" value="New Term step 6" />
 258 <input type="submit" name="submit" value="Save" />         </fieldset>
 259
 260 </form>
 261 [% END %]
 262 </div>
 263 </div>
 264 <div class="yui-b">
 265 [% INCLUDE 'guided-reports-view.inc' %]
 266 </div>
 267 </div>
 268 [% INCLUDE 'intranet-bottom.inc' %]