1 <!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
2 <title>Koha › Reports › Guided Reports › Dictionary</title>
3 <!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
4 <!-- TMPL_INCLUDE NAME="calendar.inc" -->
7 <!-- TMPL_INCLUDE NAME="header.inc" -->
8 <!-- TMPL_INCLUDE NAME="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 <!-- TMPL_IF NAME="start_dictionary" -->
18 <!-- TMPL_INCLUDE NAME="dictionary-toolbar.inc" -->
21 <!-- TMPL_IF NAME="start_dictionary" -->
22 <p>Use the dictionary to define custom criteria for reporting.</p>
24 <!-- TMPL_IF NAME="definitions" -->
25 <h2>Current Terms</h2>
26 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
27 Filter by area <select name="areas">
28 <option value="All">All</option>
29 <!-- TMPL_LOOP NAME="areas" -->
30 <option value="<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="name"--></option>
33 <input name="phase" value="Go" type="submit" />
36 <table border="1" cellspacing="0" cellpadding="5">
44 <!-- TMPL_LOOP NAME="definitions" -->
46 <td><!-- TMPL_VAR NAME="name" --></td>
47 <td><!-- TMPL_VAR NAME="description" --></td>
48 <td><!-- TMPL_VAR NAME="areaname" --></td>
49 <td><!-- TMPL_VAR NAME="saved_sql" --></td>
50 <td><form method="post" action="/cgi-bin/koha/reports/dictionary.pl">
51 <input type="hidden" name="id" value="<!-- TMPL_VAR NAME="id" -->" />
52 <input type="hidden" name="phase" value="Delete Definition" />
53 <input type="submit" name="submit" value="Delete Definition" />
57 </table><!-- TMPL_ELSE --> <!-- /TMPL_IF -->
61 <!-- TMPL_IF NAME="new_dictionary" -->
62 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
66 <li class="tabs-selected"><span class="a">Step 1: Name</span></li>
67 <li><span class="a">Step 2: Area</span></li>
68 <li><span class="a">Step 3: Columns</span></li>
69 <li><span class="a">Step 4: Values</span></li>
71 <div class="tabs-container">
72 <fieldset class="rows"><legend>Add New Definition</legend><ol>
74 <label for="definition_name">Definition Name:</label>
75 <input type="text" id="definition_name" name="definition_name" />
78 <label for="definition_description">Definition Description:</label>
79 <textarea name="definition_description" id="definition_description" rows="3" cols="20"></textarea>
83 <fieldset class="action"><input type="hidden" name="phase" value="New Term step 2" />
84 <input name="submit" value="Next" type="submit" /></fieldset>
90 <!-- TMPL_IF NAME="step_2" -->
93 <li><span class="a">Step 1: Name</span></li>
94 <li class="tabs-selected"><span class="a">Step 2: Area</span></li>
95 <li><span class="a">Step 3: Columns</span></li>
96 <li><span class="a">Step 4: Values</span></li>
98 <div class="tabs-container">
99 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
100 <fieldset class="rows">
101 <legend>Add New Definition</legend>
102 <ol><li><input type="hidden" name="phase" value="New Term step 3" />
103 <input type="hidden" name="definition_name" value="<!-- TMPL_VAR NAME="definition_name" -->" />
104 <input type="hidden" name="definition_description" value="<!-- TMPL_VAR NAME="definition_description" -->" />
105 <label for="areas">Select table </label><select name="areas" id="areas">
106 <!-- TMPL_LOOP NAME="areas" -->
107 <option value="<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="name"--></option>
112 <fieldset class="action"><input name="submit" value="Next" type="submit" /></fieldset>
118 <!-- TMPL_IF NAME="step_3" -->
119 <h1>Add New Definition</h1>
120 <div class="toptabs">
121 <ul class="tabs-nav">
122 <li><span class="a">Step 1: Name</span></li>
123 <li><span class="a">Step 2: Area</span></li>
124 <li class="tabs-selected"><span class="a">Step 3: Columns</span></li>
125 <li><span class="a">Step 4: Values</span></li>
127 <div class="tabs-container">
128 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
129 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->" />
130 <input type="hidden" name="definition_name" value="<!-- TMPL_VAR NAME="definition_name" -->" />
131 <input type="hidden" name="definition_description" value="<!-- TMPL_VAR NAME="definition_description" -->" />
133 <table style="border: 0;"><tr><td><select id="availableColumns" name="oldcolumns2" size="25" style="width:200px;height:300px;">
134 <!-- TMPL_LOOP NAME="columns" -->
135 <!-- TMPL_IF NAME="table" -->
136 <!-- TMPL_IF NAME="__first__" -->
141 <optgroup label="<!-- TMPL_VAR NAME="table"-->">
143 <option value="<!-- TMPL_VAR NAME="name" -->">
144 <!-- TMPL_IF NAME="description" --><!-- TMPL_VAR NAME="description" -->
146 <!-- TMPL_VAR NAME="name" -->
154 <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>
156 <td><select id="selectedColumns" name="columns" size="25" style="width:200px;height:300px;"></select> </td> </tr></table>
159 <input type="hidden" name="phase" value="New Term step 4" />
160 <input type="submit" name="submit" value="Next" />
166 <!-- TMPL_IF NAME="step_4" -->
167 <h1>Add New Definition</h1>
168 <div class="toptabs">
169 <ul class="tabs-nav">
170 <li><span class="a">Step 1: Name</span></li>
171 <li><span class="a">Step 2: Area</span></li>
172 <li><span class="a">Step 3: Columns</span></li>
173 <li class="tabs-selected"><span class="a">Step 4: Values</span></li>
175 <div class="tabs-container">
176 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
177 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->" />
178 <input type="hidden" name="definition_name" value="<!-- TMPL_VAR NAME="definition_name" -->" />
179 <input type="hidden" name="definition_description" value="<!-- TMPL_VAR NAME="definition_description" -->" />
180 <input type="hidden" name="columnstring" value="<!-- TMPL_VAR NAME="columnstring" -->" />
182 <!-- TMPL_LOOP NAME="columns" -->
184 <input type="hidden" name="criteria_column" value="<!-- TMPL_VAR NAME="name" -->" />
185 <!-- TMPL_VAR NAME="name" -->
186 <!-- TMPL_IF NAME="distinct" -->
187 <select name="<!-- TMPL_VAR NAME="name" -->_value">
188 <!-- TMPL_LOOP NAME="values" -->
189 <option value="<!-- TMPL_VAR NAME="availablevalues"-->"><!-- TMPL_VAR NAME="availablevalues" --></option>
193 <!-- TMPL_IF NAME="date" -->
196 <td><input type="radio" name="<!-- TMPL_VAR NAME="name" -->_all" value="all" />All dates</td>
198 <td><input type="radio" name="dates" value="range" />Date range<br />
201 <td>Start of date range</td>
202 <td><input type="text" size="10" id="<!-- TMPL_VAR NAME="name" -->_start_value" name="<!-- TMPL_VAR NAME="name" -->_start_value" value="" />
203 <img src="<!-- TMPL_VAR Name="themelang" -->/lib/calendar/cal.gif" id="buttonfrom1" style="cursor: pointer;" />
204 <script type="text/javascript">
206 inputField : "<!-- TMPL_VAR NAME="name" -->_start_value",
207 ifFormat : "%Y-%m-%d",
208 button : "buttonfrom1",
215 <td>End of date range</td>
217 <input type="text" size="10" id="<!-- TMPL_VAR NAME="name" -->_end_value" name="<!-- TMPL_VAR NAME="name" -->_end_value" value="" />
218 <img src="<!-- TMPL_VAR Name="themelang" -->/lib/calendar/cal.gif" id="buttonfrom1" style="cursor: pointer;" />
219 <script type="text/javascript">
221 inputField : "<!-- TMPL_VAR NAME="name" -->_end_value",
222 ifFormat : "%Y-%m-%d",
223 button : "buttonfrom1",
233 <!-- TMPL_IF NAME="text" -->
234 <p>Search string matches <input type="text" size="13" name="<!-- TMPL_VAR NAME="name" -->_value" /></p>
239 <input type="hidden" name="phase" value="New Term step 5" />
240 <input type="submit" name="submit" value="Next" />
246 <!-- TMPL_IF NAME="step_5" -->
247 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
248 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->" />
249 <input type="hidden" name="definition_name" value="<!-- TMPL_VAR NAME="definition_name" -->" />
250 <input type="hidden" name="definition_description" value="<!-- TMPL_VAR NAME="definition_description" -->" />
251 <input type="hidden" name="columnstring" value="<!-- TMPL_VAR NAME="columnstring" -->" />
253 <h3>Confirm Definition</h3>
255 <fieldset class="rows"><ol><li>
256 <span class="label">Name:</span>
257 <!-- TMPL_VAR NAME="definition_name" -->
260 <span class="label">Description:</span>
261 <!-- TMPL_VAR NAME="definition_description" -->
264 <span class="label">Area:</span>
265 <!-- TMPL_VAR NAME="areaname" -->
274 <!-- TMPL_LOOP NAME="criteria_loop" -->
276 <td><!-- TMPL_VAR NAME="name" --></td>
277 <td><!-- TMPL_VAR NAME="value" --></td>
280 </table></li></ol> </fieldset>
282 <fieldset class="action"><input type="hidden" name="sql" value="<!-- TMPL_VAR NAME="query" -->" />
283 <input type="hidden" name="phase" value="New Term step 6" />
284 <input type="submit" name="submit" value="Save" /> </fieldset>
291 <!-- TMPL_INCLUDE NAME="guided-reports-view.inc" -->
294 <script type="text/javascript">
296 function setObjects() {
297 selectedColumnsObj=document.getElementById('selectedColumns');
298 availableColumnsObj=document.getElementById('availableColumns');
302 function addColumn() {
303 for (i=0;i<availableColumnsObj.length;i++) {
304 if (availableColumnsObj.options[i].selected==true) {
305 var newColumnObj=document.createElement("OPTION");
306 newColumnObj.value=availableColumnsObj.options[i].value;
307 newColumnObj.text=availableColumnsObj.options[i].text;
308 selectedColumnsObj.appendChild(newColumnObj);
309 newColumnObj.selected=true;
314 function delColumn() {
315 for (i=0;i<=selectedColumnsObj.options.length;i++) {
316 if (selectedColumnsObj.options.selectedIndex>=0) {
317 selectedColumnsObj.remove(selectedColumnsObj.options.selectedIndex)
324 <!-- TMPL_INCLUDE NAME="intranet-bottom.inc" -->