1 [% INCLUDE 'doc-head-open.inc' %]
2 <title>Koha › Reports › Guided Reports › Dictionary</title>
3 [% INCLUDE 'doc-head-close.inc' %]
4 [% INCLUDE 'calendar.inc' %]
7 [% INCLUDE 'header.inc' %]
8 [% INCLUDE 'circ-search.inc' %]
10 <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> › <strong> Dictionary </strong></div>
12 <div id="doc3" class="yui-t2">
17 [% IF ( start_dictionary ) %]
18 [% INCLUDE 'dictionary-toolbar.inc' %]
21 [% IF ( start_dictionary ) %]
22 <p>Use the dictionary to define custom criteria for reporting.</p>
25 <h2>Current Terms</h2>
26 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
27 <input type="hidden" name="phase" value="View Dictionary" />
28 Filter by area <select name="areas">
29 <option value="">All</option>
30 [% FOREACH area IN areas %]
31 [% IF ( area.selected ) %]
32 <option value="[% area.id %]" selected="selected" >[% area.name %]</option>
34 <option value="[% area.id %]">[% area.name %]</option>
38 <input name="submit" value="Go" type="submit" />
41 <table border="1" cellspacing="0" cellpadding="5">
49 [% IF ( definitions ) %]
50 [% FOREACH definition IN definitions %]
51 [% UNLESS ( loop.odd ) %]
52 <tr class="highlight" valign="top">
56 <td>[% definition.name %]</td>
57 <td>[% definition.description %]</td>
58 <td>[% definition.areaname %]</td>
59 <td>[% definition.saved_sql %]</td>
60 <td><form method="post" action="/cgi-bin/koha/reports/dictionary.pl">
61 <input type="hidden" name="id" value="[% definition.id %]" />
62 <input type="hidden" name="phase" value="Delete Definition" />
63 <input type="submit" name="submit" value="Delete Definition" />
72 [% IF ( new_dictionary ) %]
73 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
76 <ul class="ui-tabs-nav">
77 <li class="ui-tabs-selected"><span class="a">Step 1: Name</span></li>
78 <li><span class="a">Step 2: Area</span></li>
79 <li><span class="a">Step 3: Columns</span></li>
80 <li><span class="a">Step 4: Values</span></li>
82 <div class="tabs-container">
83 <fieldset class="rows"><legend>Add New Definition</legend><ol>
85 <label for="definition_name">Definition Name:</label>
86 <input type="text" id="definition_name" name="definition_name" />
89 <label for="definition_description">Definition Description:</label>
90 <textarea name="definition_description" id="definition_description" rows="3" cols="20"></textarea>
94 <fieldset class="action"><input type="hidden" name="phase" value="New Term step 2" />
95 <input name="submit" value="Next" type="submit" /></fieldset>
102 <div class="toptabs">
103 <ul class="ui-tabs-nav">
104 <li><span class="a">Step 1: Name</span></li>
105 <li class="ui-tabs-selected"><span class="a">Step 2: Area</span></li>
106 <li><span class="a">Step 3: Columns</span></li>
107 <li><span class="a">Step 4: Values</span></li>
109 <div class="tabs-container">
110 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
111 <fieldset class="rows">
112 <legend>Add New Definition</legend>
113 <ol><li><input type="hidden" name="phase" value="New Term step 3" />
114 <input type="hidden" name="definition_name" value="[% definition_name %]" />
115 <input type="hidden" name="definition_description" value="[% definition_description %]" />
116 <label for="areas">Select table </label><select name="areas" id="areas">
117 [% FOREACH area IN areas %]
118 <option value="[% area.id %]">[% area.name %]</option>
123 <fieldset class="action"><input name="submit" value="Next" type="submit" /></fieldset>
130 <h1>Add New Definition</h1>
131 <div class="toptabs">
132 <ul class="ui-tabs-nav">
133 <li><span class="a">Step 1: Name</span></li>
134 <li><span class="a">Step 2: Area</span></li>
135 <li class="ui-tabs-selected"><span class="a">Step 3: Columns</span></li>
136 <li><span class="a">Step 4: Values</span></li>
138 <div class="tabs-container">
139 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
140 <input type="hidden" name="area" value="[% area %]" />
141 <input type="hidden" name="definition_name" value="[% definition_name %]" />
142 <input type="hidden" name="definition_description" value="[% definition_description %]" />
144 <table style="border: 0;"><tr><td><select id="availableColumns" name="oldcolumns2" size="25" style="width:200px;height:300px;">
145 [% FOREACH column IN columns %]
146 [% IF ( column.table ) %]
147 [% IF ( loop.first ) %]
152 <optgroup label="[% column.table %]">
154 <option value="[% column.name %]">
155 [% IF ( column.description ) %][% column.description %]
165 <td><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>
167 <td><select id="selectedColumns" name="columns" size="25" style="width:200px;height:300px;"></select> </td> </tr></table>
170 <input type="hidden" name="phase" value="New Term step 4" />
171 <input type="submit" name="submit" value="Next" />
178 <h1>Add New Definition</h1>
179 <div class="toptabs">
180 <ul class="ui-tabs-nav">
181 <li><span class="a">Step 1: Name</span></li>
182 <li><span class="a">Step 2: Area</span></li>
183 <li><span class="a">Step 3: Columns</span></li>
184 <li class="ui-tabs-selected"><span class="a">Step 4: Values</span></li>
186 <div class="tabs-container">
187 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
188 <input type="hidden" name="area" value="[% area %]" />
189 <input type="hidden" name="definition_name" value="[% definition_name %]" />
190 <input type="hidden" name="definition_description" value="[% definition_description %]" />
191 <input type="hidden" name="columnstring" value="[% columnstring %]" />
193 [% FOREACH column IN columns %]
194 <input type="hidden" name="criteria_column" value="[% column.name %]" />
196 [% IF ( column.distinct ) %]
197 <select name="[% column.name %]_value">
198 [% FOREACH value IN column.values %]
199 <option value="[% value.availablevalues %]">[% value.availablevalues %]</option>
203 [% IF ( column.date ) %]
206 <td><input type="radio" name="[% column.name %]_all" value="all" />All dates</td>
208 <td><input type="radio" name="dates" value="range" />Date range<br />
211 <td>Start of date range</td>
212 <td><input type="text" size="10" id="[% column.name %]_start_value" name="[% column.name %]_start_value" value="" />
213 <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfrom1" style="cursor: pointer;" />
214 <script type="text/javascript">
216 inputField : "[% column.name %]_start_value",
217 ifFormat : "[% column.DHTMLcalendar_dateformat %]",
218 button : "buttonfrom1",
222 <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
226 <td>End of date range</td>
228 <input type="text" size="10" id="[% column.name %]_end_value" name="[% column.name %]_end_value" value="" />
229 <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfrom2" style="cursor: pointer;" />
230 <script type="text/javascript">
232 inputField : "[% column.name %]_end_value",
233 ifFormat : "[% column.DHTMLcalendar_dateformat %]",
234 button : "buttonfrom2",
238 <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
245 [% IF ( column.text ) %]
246 <p>Search string matches <input type="text" size="13" name="[% column.name %]_value" /></p>
250 <input type="hidden" name="phase" value="New Term step 5" />
251 <input type="submit" name="submit" value="Next" />
258 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
259 <input type="hidden" name="area" value="[% area %]" />
260 <input type="hidden" name="definition_name" value="[% definition_name %]" />
261 <input type="hidden" name="definition_description" value="[% definition_description %]" />
262 <input type="hidden" name="columnstring" value="[% columnstring %]" />
264 <h3>Confirm Definition</h3>
266 <fieldset class="rows"><ol><li>
267 <span class="label">Name:</span>
268 [% definition_name %]
271 <span class="label">Description:</span>
272 [% definition_description %]
275 <span class="label">Area:</span>
285 [% FOREACH criteria_loo IN criteria_loop %]
287 <td>[% criteria_loo.name %]</td>
288 <td>[% criteria_loo.value %]</td>
291 </table></li></ol> </fieldset>
293 <fieldset class="action"><input type="hidden" name="sql" value="[% query %]" />
294 <input type="hidden" name="phase" value="New Term step 6" />
295 <input type="submit" name="submit" value="Save" /> </fieldset>
302 [% INCLUDE 'guided-reports-view.inc' %]
305 <script type="text/javascript">
307 function setObjects() {
308 selectedColumnsObj=document.getElementById('selectedColumns');
309 availableColumnsObj=document.getElementById('availableColumns');
313 function addColumn() {
314 for (i=0;i<availableColumnsObj.length;i++) {
315 if (availableColumnsObj.options[i].selected==true) {
316 var newColumnObj=document.createElement("OPTION");
317 newColumnObj.value=availableColumnsObj.options[i].value;
318 newColumnObj.text=availableColumnsObj.options[i].text;
319 selectedColumnsObj.appendChild(newColumnObj);
320 newColumnObj.selected=true;
325 function delColumn() {
326 for (i=0;i<=selectedColumnsObj.options.length;i++) {
327 if (selectedColumnsObj.options.selectedIndex>=0) {
328 selectedColumnsObj.remove(selectedColumnsObj.options.selectedIndex)
335 [% INCLUDE 'intranet-bottom.inc' %]