1 [% INCLUDE 'doc-head-open.inc' %]
2 <title>Koha › Reports › Guided reports › 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>
7 <body id="rep_dictionary" class="rep">
8 [% INCLUDE 'header.inc' %]
9 [% INCLUDE 'circ-search.inc' %]
11 <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> › <a href="/cgi-bin/koha/reports/guided_reports.pl">Guided reports wizard</a>
12 [% IF ( new_dictionary ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> › <strong>Name the new definition</strong>
13 [% ELSIF ( step_2 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> › <strong>Step 2: Choose the area </strong>
14 [% ELSIF ( step_3 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> › <strong>Step 3: Choose columns </strong>
15 [% ELSIF ( step_4 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> › <strong>Step 4: Specify a value </strong>
16 [% ELSIF ( step_5 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> › <strong>Step 5: Confirm definition</strong>
17 [% ELSE %]<strong> Dictionary </strong>[% END %]</div>
19 <div id="doc3" class="yui-t2">
24 [% IF ( start_dictionary ) %]
25 [% INCLUDE 'dictionary-toolbar.inc' %]
28 [% IF ( start_dictionary ) %]
29 <p>Use the dictionary to define custom criteria for reporting.</p>
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" />
36 Filter by area <select name="areas">
37 <option value="">All</option>
38 [% FOREACH area IN areas %]
39 [% IF ( area.selected ) %]
40 <option value="[% area.id %]" selected="selected" >[% area.name %]</option>
42 <option value="[% area.id %]">[% area.name %]</option>
46 <input name="submit" value="Go" type="submit" />
50 <table border="1" cellspacing="0" cellpadding="5">
58 [% FOREACH definition IN definitions %]
59 [% UNLESS ( loop.odd ) %]
60 <tr class="highlight" valign="top">
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" />
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>
84 <label for="definition_name">Definition name:</label>
85 <input type="text" id="definition_name" name="definition_name" />
88 <label for="definition_description">Definition description:</label>
89 <textarea name="definition_description" id="definition_description" rows="3" cols="20"></textarea>
93 <fieldset class="action"><input type="hidden" name="phase" value="New Term step 2" />
94 <input name="submit" value="Next" type="submit" /></fieldset>
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="areas">Select table </label><select name="areas" id="areas">
107 [% FOREACH area IN areas %]
108 <option value="[% area.id %]">[% area.name %]</option>
113 <fieldset class="action"><input name="submit" value="Next" type="submit" /></fieldset>
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 %]" />
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 ) %]
135 <optgroup label="[% column.table %]">
137 <option value="[% column.name %]">
138 [% IF ( column.description ) %][% column.description %]
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="<< Delete" class="button" style="width : 6em;" onclick="delColumn()" /> </td>
150 <td style="border: 0;"><select id="selectedColumns" name="columns" size="25" style="width:200px;height:300px;"></select> </td> </tr></table>
152 <input type="hidden" name="phase" value="New term step 4" />
154 <fieldset class="action"><input type="submit" name="submit" value="Next" /></fieldset>
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 %]" />
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>
178 [% IF ( column.date ) %]
179 <li><span class="label">Choose: </span><table>
181 <td><input type="radio" name="[% column.name %]_all" value="all" />All dates</td>
183 <td><input type="radio" name="dates" value="range" />Date range<br />
186 <td>Start of date range</td>
187 <td><input type="text" size="10" id="[% column.name %]_start_value" name="[% column.name %]_start_value" value="" />
188 <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfrom1" style="cursor: pointer;" />
189 <script type="text/javascript">
191 inputField : "[% column.name %]_start_value",
192 ifFormat : "[% DHTMLcalendar_dateformat %]",
193 button : "buttonfrom1",
197 <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
201 <td>End of date range</td>
203 <input type="text" size="10" id="[% column.name %]_end_value" name="[% column.name %]_end_value" value="" />
204 <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfrom2" style="cursor: pointer;" />
205 <script type="text/javascript">
207 inputField : "[% column.name %]_end_value",
208 ifFormat : "[% DHTMLcalendar_dateformat %]",
209 button : "buttonfrom2",
213 <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
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>
226 <input type="hidden" name="phase" value="New term step 5" />
228 <fieldset class="action">
229 <input type="submit" name="submit" value="Next" />
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 %]" />
241 <h3>Add new definition</h3>
243 <fieldset class="rows">
244 <legend>Step 5 of 5: Confirm details</legend>
246 <span class="label">Name:</span>
247 [% definition_name %]
250 <span class="label">Description:</span>
251 [% definition_description %]
254 <span class="label">Area:</span>
258 <span class="label">Data:</span>
264 [% FOREACH criteria_loo IN criteria_loop %]
266 <td>[% criteria_loo.name %]</td>
267 <td>[% criteria_loo.value %]</td>
270 </table></li></ol> </fieldset>
272 <fieldset class="action"><input type="hidden" name="sql" value="[% query %]" />
273 <input type="hidden" name="phase" value="New Term step 6" />
274 <input type="submit" name="submit" value="Save" /> </fieldset>
281 [% INCLUDE 'guided-reports-view.inc' %]
284 <script type="text/javascript">
286 function setObjects() {
287 selectedColumnsObj=document.getElementById('selectedColumns');
288 availableColumnsObj=document.getElementById('availableColumns');
292 function addColumn() {
293 for (i=0;i<availableColumnsObj.length;i++) {
294 if (availableColumnsObj.options[i].selected==true) {
295 var newColumnObj=document.createElement("OPTION");
296 newColumnObj.value=availableColumnsObj.options[i].value;
297 newColumnObj.text=availableColumnsObj.options[i].text;
298 selectedColumnsObj.appendChild(newColumnObj);
299 newColumnObj.selected=true;
304 function delColumn() {
305 for (i=0;i<=selectedColumnsObj.options.length;i++) {
306 if (selectedColumnsObj.options.selectedIndex>=0) {
307 selectedColumnsObj.remove(selectedColumnsObj.options.selectedIndex)
314 [% INCLUDE 'intranet-bottom.inc' %]