1 <!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
2 <title>Koha -- Reports</title>
4 <!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
5 <!-- TMPL_INCLUDE NAME="calendar.inc" -->
8 <!-- TMPL_INCLUDE NAME="header.inc" -->
9 <!-- TMPL_INCLUDE NAME="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> › <strong> Dictionary </strong></div>
13 <div id="doc3" class="yui-t2">
21 <!-- TMPL_IF NAME="start_dictionary" -->
22 <p>Use the dictionary to define custom criteria for reporting.</p>
24 <h2>Current Terms</h2>
25 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
26 Filter By Area <select name="areas">
27 <option value="All">All</option>
28 <!-- TMPL_LOOP NAME="areas" -->
29 <option value="<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="name"--></option>
32 <input name="phase" value="Filter Dictionary" type="submit"> <input name="phase" value="Add New Definition" type="submit">
35 <table border="1" cellspacing="0" cellpadding="5">
42 <!-- TMPL_LOOP NAME="definitions" -->
44 <td><!-- TMPL_VAR NAME="name" --></td>
45 <td><!-- TMPL_VAR NAME="description" --></td>
46 <td><!-- TMPL_VAR NAME="area" --></td>
47 <td><!-- TMPL_VAR NAME="saved_sql" --></td>
48 <td><form method="post" action="/cgi-bin/koha/reports/dictionary.pl">
49 <input type="submit" name="phase" value="Delete Definition"><input type="hidden" name="id" value="<!-- TMPL_VAR NAME="id" -->">
57 <!-- TMPL_IF NAME="new_dictionary" -->
58 <h1>Add New Definition</h1>
59 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
61 <p><b>1 Name</b> | 2 Area | 3 Columns | 4 Values</p>
64 <td>Definition Name:</td>
65 <td><input type="text" name="definition_name"></td>
67 <td>Definition Description:</td>
68 <td><textarea name="definition_description"></textarea></td>
73 <input type="hidden" name="phase" value="New Term step 2">
74 <input name="submit" value="Next" type="submit">
78 <!-- TMPL_IF NAME="step_2" -->
79 <h1>Add New Definition</h1>
81 <p>1 Name | <b>2 Area</b> | 3 Columns | 4 Values</p>
82 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
83 <input type="hidden" name="phase" value="New Term step 3">
84 <input type="hidden" name="definition_name" value="<!-- TMPL_VAR NAME="definition_name" -->">
85 <input type="hidden" name="definition_description" value="<!-- TMPL_VAR NAME="definition_description" -->">
86 Select table <select name="areas">
87 <!-- TMPL_LOOP NAME="areas" -->
88 <option value="<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="name"--></option>
92 <input name="submit" value="Next" type="submit">
96 <!-- TMPL_IF NAME="step_3" -->
97 <h1>Add New Definition</h1>
99 <p>1 Name | 2 Area | <b>3 Columns</b> | 4 Values</p>
100 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
101 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->">
102 <input type="hidden" name="definition_name" value="<!-- TMPL_VAR NAME="definition_name" -->">
103 <input type="hidden" name="definition_description" value="<!-- TMPL_VAR NAME="definition_description" -->">
105 <select id="availableColumns" name="oldcolumns2" multiple size="25" style="width:200px;height:300px;">
106 <!-- TMPL_LOOP NAME="columns" -->
107 <!-- TMPL_IF NAME="table" -->
108 <!-- TMPL_IF NAME="__first__" -->
114 <optgroup label="<!-- TMPL_VAR NAME="table"-->">
116 <option value="<!-- TMPL_VAR NAME="name" -->">
117 <!-- TMPL_IF NAME="description" --><!-- TMPL_VAR NAME="description" -->
119 <!-- TMPL_VAR NAME="name" -->
125 <input type="button" name="Add" value="Add" class="button" onClick="addColumn()"/>
127 <select id="selectedColumns" name="columns" multiple size="25" style="width:200px;height:300px;"></select>
128 <input type="button" name="delete" value="delete" class="button" onClick="delColumn()"/>
130 <input type="hidden" name="phase" value="New Term step 4">
131 <input type="submit" name="submit" value="Next">
135 <!-- TMPL_IF NAME="step_4" -->
136 <h1>Add New Definition</h1>
138 <p>1 Name | 2 Area | 3 Columns | <b>4 Values</b></p>
139 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
140 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->">
141 <input type="hidden" name="definition_name" value="<!-- TMPL_VAR NAME="definition_name" -->">
142 <input type="hidden" name="definition_description" value="<!-- TMPL_VAR NAME="definition_description" -->">
143 <input type="hidden" name="columnstring" value="<!-- TMPL_VAR NAME="columnstring" -->">
145 <!-- TMPL_LOOP NAME="columns" -->
147 <input type=hidden name="criteria_column" value="<!-- TMPL_VAR NAME="name" -->">
148 <!-- TMPL_VAR NAME="name" -->
149 <!-- TMPL_IF NAME="distinct" -->
150 <select name="<!-- TMPL_VAR NAME="name" -->_value">
151 <!-- TMPL_LOOP NAME="values" -->
152 <option value="<!-- TMPL_VAR NAME="availablevalues"-->"><!-- TMPL_VAR NAME="availablevalues" --></option>
156 <!-- TMPL_IF NAME="date" -->
159 <td><input type="radio" name="<!-- TMPL_VAR NAME="name" -->_all" value="all">All Dates</td>
161 <td><input type="radio" name="dates" value="range">Date Range<br />
164 <td>Start of Date Range</td>
165 <td><input type="text" size="10" id="<!-- TMPL_VAR NAME="name" -->_start_value" name="<!-- TMPL_VAR NAME="name" -->_start_value" value="" >
166 <img src="<!-- TMPL_VAR Name="themelang" -->/lib/calendar/cal.gif" id="buttonfrom1" style="cursor: pointer;" />
167 <script type="text/javascript">
169 inputField : "<!-- TMPL_VAR NAME="name" -->_start_value",
170 ifFormat : "%Y-%m-%d",
171 button : "buttonfrom1",
178 <td>End of Date Range</td>
180 <input type="text" size="10" id="<!-- TMPL_VAR NAME="name" -->_end_value" name="<!-- TMPL_VAR NAME="name" -->_end_value" value="" >
181 <img src="<!-- TMPL_VAR Name="themelang" -->/lib/calendar/cal.gif" id="buttonfrom1" style="cursor: pointer;" />
182 <script type="text/javascript">
184 inputField : "<!-- TMPL_VAR NAME="name" -->_end_value",
185 ifFormat : "%Y-%m-%d",
186 button : "buttonfrom1",
196 <!-- TMPL_IF NAME="text">
197 <p>Search string matches <input type="text" size="13" name="<!-- TMPL_VAR NAME="name" -->_value"></p>
202 <input type="hidden" name="phase" value="New Term step 5">
203 <input type="submit" name="submit" value="Next">
207 <!-- TMPL_IF NAME="step_5" -->
208 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
209 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->">
210 <input type="hidden" name="definition_name" value="<!-- TMPL_VAR NAME="definition_name" -->">
211 <input type="hidden" name="definition_description" value="<!-- TMPL_VAR NAME="definition_description" -->">
212 <input type="hidden" name="columnstring" value="<!-- TMPL_VAR NAME="columnstring" -->">
214 <h3>Confirm Definition</h3>
219 <td><!-- TMPL_VAR NAME="definition_name" --></td>
222 <td>Description:</td>
223 <td><!-- TMPL_VAR NAME="definition_description" --></td>
227 <td><!-- TMPL_VAR NAME="area" --></td>
233 <!-- TMPL_LOOP NAME="criteria_loop" -->
235 <td><!-- TMPL_VAR NAME="name" --></td>
236 <td><!-- TMPL_VAR NAME="value" --></td>
241 <input type="hidden" name="sql" value="<!-- TMPL_VAR NAME="query" -->">
242 <input type="hidden" name="phase" value="New Term step 6">
243 <input type="submit" name="submit" value="Save">
253 <!-- TMPL_INCLUDE NAME="guided-reports-view.inc" -->
256 <script type="text/javascript">
257 function setObjects() {
258 selectedColumnsObj=document.getElementById('selectedColumns');
259 availableColumnsObj=document.getElementById('availableColumns');
263 function addColumn() {
264 for (i=0;i<availableColumnsObj.length;i++) {
265 if (availableColumnsObj.options[i].selected==true) {
266 var newColumnObj=document.createElement("OPTION");
267 newColumnObj.value=availableColumnsObj.options[i].value;
268 newColumnObj.text=availableColumnsObj.options[i].text;
269 selectedColumnsObj.appendChild(newColumnObj);
270 newColumnObj.selected=true;
275 function delColumn() {
276 for (i=0;i<=selectedColumnsObj.options.length;i++) {
277 if (selectedColumnsObj.options.selectedIndex>=0) {
278 selectedColumnsObj.remove(selectedColumnsObj.options.selectedIndex)
284 <!-- TMPL_INCLUDE NAME="intranet-bottom.inc" -->