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 ) %]
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>
32 [% IF ( start_dictionary ) %]
33 <p>Use the dictionary to define custom criteria for reporting.</p>
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" />
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>
46 <option value="[% area.id %]">[% area.name %]</option>
50 <input name="submit" value="Go" type="submit" />
54 <table border="1" cellspacing="0" cellpadding="5">
62 [% FOREACH definition IN definitions %]
63 [% UNLESS ( loop.odd ) %]
64 <tr class="highlight" valign="top">
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" />
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>
88 <label for="definition_name">Definition name:</label>
89 <input type="text" id="definition_name" name="definition_name" />
92 <label for="definition_description">Definition description:</label>
93 <textarea name="definition_description" id="definition_description" rows="3" cols="20"></textarea>
97 <fieldset class="action"><input type="hidden" name="phase" value="New Term step 2" />
98 <input name="submit" value="Next" type="submit" /></fieldset>
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>
117 <fieldset class="action"><input name="submit" value="Next" type="submit" /></fieldset>
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 %]" />
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 ) %]
139 <optgroup label="[% column.table %]">
141 <option value="[% column.name %]">
142 [% IF ( column.description ) %][% column.description %]
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="<< Delete" class="button" style="width : 6em;" onclick="delColumn()" /> </td>
154 <td style="border: 0;"><select id="selectedColumns" name="columns" size="25" style="width:200px;height:300px;"></select> </td> </tr></table>
156 <input type="hidden" name="phase" value="New Term step 4" />
158 <fieldset class="action"><input type="submit" name="submit" value="Next" /></fieldset>
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 %]" />
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>
182 [% IF ( column.date ) %]
183 <li><span class="label">Choose: </span><table>
185 <td><input type="radio" name="[% column.name %]_all" value="all" />All dates</td>
187 <td><input type="radio" name="dates" value="range" />Date range<br />
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>
196 <td>End of date range</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>
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>
212 <input type="hidden" name="phase" value="New Term step 5" />
214 <fieldset class="action">
215 <input type="submit" name="submit" value="Next" />
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 %]" />
227 <h3>Add new definition</h3>
229 <fieldset class="rows">
230 <legend>Step 5 of 5: Confirm details</legend>
232 <span class="label">Name:</span>
233 [% definition_name %]
236 <span class="label">Description:</span>
237 [% definition_description %]
240 <span class="label">Area:</span>
244 <span class="label">Data:</span>
250 [% FOREACH criteria_loo IN criteria_loop %]
252 <td>[% criteria_loo.name %]</td>
253 <td>[% criteria_loo.value %]</td>
256 </table></li></ol> </fieldset>
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>
267 [% INCLUDE 'guided-reports-view.inc' %]
270 <script type="text/javascript">
272 function setObjects() {
273 selectedColumnsObj=document.getElementById('selectedColumns');
274 availableColumnsObj=document.getElementById('availableColumns');
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;
290 function delColumn() {
291 for (i=0;i<=selectedColumnsObj.options.length;i++) {
292 if (selectedColumnsObj.options.selectedIndex>=0) {
293 selectedColumnsObj.remove(selectedColumnsObj.options.selectedIndex)
300 [% INCLUDE 'intranet-bottom.inc' %]