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"> -->
33 <input name="phase" value="Add New Definition" type="phase">
34 <input name="submit" value="Add New Definition" type="submit">
37 <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="area" --></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">
61 <!-- TMPL_IF NAME="new_dictionary" -->
62 <h1>Add New Definition</h1>
63 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
65 <p><b>1 Name</b> | 2 Area | 3 Columns | 4 Values</p>
68 <td>Definition Name:</td>
69 <td><input type="text" name="definition_name"></td>
71 <td>Definition Description:</td>
72 <td><textarea name="definition_description"></textarea></td>
77 <input type="hidden" name="phase" value="New Term step 2">
78 <input name="submit" value="Next" type="submit">
82 <!-- TMPL_IF NAME="step_2" -->
83 <h1>Add New Definition</h1>
85 <p>1 Name | <b>2 Area</b> | 3 Columns | 4 Values</p>
86 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
87 <input type="hidden" name="phase" value="New Term step 3">
88 <input type="hidden" name="definition_name" value="<!-- TMPL_VAR NAME="definition_name" -->">
89 <input type="hidden" name="definition_description" value="<!-- TMPL_VAR NAME="definition_description" -->">
90 Select table <select name="areas">
91 <!-- TMPL_LOOP NAME="areas" -->
92 <option value="<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="name"--></option>
96 <input name="submit" value="Next" type="submit">
100 <!-- TMPL_IF NAME="step_3" -->
101 <h1>Add New Definition</h1>
103 <p>1 Name | 2 Area | <b>3 Columns</b> | 4 Values</p>
104 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
105 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->">
106 <input type="hidden" name="definition_name" value="<!-- TMPL_VAR NAME="definition_name" -->">
107 <input type="hidden" name="definition_description" value="<!-- TMPL_VAR NAME="definition_description" -->">
109 <select id="availableColumns" name="oldcolumns2" multiple size="25" style="width:200px;height:300px;">
110 <!-- TMPL_LOOP NAME="columns" -->
111 <!-- TMPL_IF NAME="table" -->
112 <!-- TMPL_IF NAME="__first__" -->
118 <optgroup label="<!-- TMPL_VAR NAME="table"-->">
120 <option value="<!-- TMPL_VAR NAME="name" -->">
121 <!-- TMPL_IF NAME="description" --><!-- TMPL_VAR NAME="description" -->
123 <!-- TMPL_VAR NAME="name" -->
129 <input type="button" name="Add" value="Add" class="button" onClick="addColumn()"/>
131 <select id="selectedColumns" name="columns" multiple size="25" style="width:200px;height:300px;"></select>
132 <input type="button" name="delete" value="delete" class="button" onClick="delColumn()"/>
134 <input type="hidden" name="phase" value="New Term step 4">
135 <input type="submit" name="submit" value="Next">
139 <!-- TMPL_IF NAME="step_4" -->
140 <h1>Add New Definition</h1>
142 <p>1 Name | 2 Area | 3 Columns | <b>4 Values</b></p>
143 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
144 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->">
145 <input type="hidden" name="definition_name" value="<!-- TMPL_VAR NAME="definition_name" -->">
146 <input type="hidden" name="definition_description" value="<!-- TMPL_VAR NAME="definition_description" -->">
147 <input type="hidden" name="columnstring" value="<!-- TMPL_VAR NAME="columnstring" -->">
149 <!-- TMPL_LOOP NAME="columns" -->
151 <input type=hidden name="criteria_column" value="<!-- TMPL_VAR NAME="name" -->">
152 <!-- TMPL_VAR NAME="name" -->
153 <!-- TMPL_IF NAME="distinct" -->
154 <select name="<!-- TMPL_VAR NAME="name" -->_value">
155 <!-- TMPL_LOOP NAME="values" -->
156 <option value="<!-- TMPL_VAR NAME="availablevalues"-->"><!-- TMPL_VAR NAME="availablevalues" --></option>
160 <!-- TMPL_IF NAME="date" -->
163 <td><input type="radio" name="<!-- TMPL_VAR NAME="name" -->_all" value="all">All Dates</td>
165 <td><input type="radio" name="dates" value="range">Date Range<br />
168 <td>Start of Date Range</td>
169 <td><input type="text" size="10" id="<!-- TMPL_VAR NAME="name" -->_start_value" name="<!-- TMPL_VAR NAME="name" -->_start_value" value="" >
170 <img src="<!-- TMPL_VAR Name="themelang" -->/lib/calendar/cal.gif" id="buttonfrom1" style="cursor: pointer;" />
171 <script type="text/javascript">
173 inputField : "<!-- TMPL_VAR NAME="name" -->_start_value",
174 ifFormat : "%Y-%m-%d",
175 button : "buttonfrom1",
182 <td>End of Date Range</td>
184 <input type="text" size="10" id="<!-- TMPL_VAR NAME="name" -->_end_value" name="<!-- TMPL_VAR NAME="name" -->_end_value" value="" >
185 <img src="<!-- TMPL_VAR Name="themelang" -->/lib/calendar/cal.gif" id="buttonfrom1" style="cursor: pointer;" />
186 <script type="text/javascript">
188 inputField : "<!-- TMPL_VAR NAME="name" -->_end_value",
189 ifFormat : "%Y-%m-%d",
190 button : "buttonfrom1",
200 <!-- TMPL_IF NAME="text">
201 <p>Search string matches <input type="text" size="13" name="<!-- TMPL_VAR NAME="name" -->_value"></p>
206 <input type="hidden" name="phase" value="New Term step 5">
207 <input type="submit" name="submit" value="Next">
211 <!-- TMPL_IF NAME="step_5" -->
212 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
213 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->">
214 <input type="hidden" name="definition_name" value="<!-- TMPL_VAR NAME="definition_name" -->">
215 <input type="hidden" name="definition_description" value="<!-- TMPL_VAR NAME="definition_description" -->">
216 <input type="hidden" name="columnstring" value="<!-- TMPL_VAR NAME="columnstring" -->">
218 <h3>Confirm Definition</h3>
223 <td><!-- TMPL_VAR NAME="definition_name" --></td>
226 <td>Description:</td>
227 <td><!-- TMPL_VAR NAME="definition_description" --></td>
231 <td><!-- TMPL_VAR NAME="area" --></td>
237 <!-- TMPL_LOOP NAME="criteria_loop" -->
239 <td><!-- TMPL_VAR NAME="name" --></td>
240 <td><!-- TMPL_VAR NAME="value" --></td>
245 <input type="hidden" name="sql" value="<!-- TMPL_VAR NAME="query" -->">
246 <input type="hidden" name="phase" value="New Term step 6">
247 <input type="submit" name="submit" value="Save">
257 <!-- TMPL_INCLUDE NAME="guided-reports-view.inc" -->
260 <script type="text/javascript">
261 function setObjects() {
262 selectedColumnsObj=document.getElementById('selectedColumns');
263 availableColumnsObj=document.getElementById('availableColumns');
267 function addColumn() {
268 for (i=0;i<availableColumnsObj.length;i++) {
269 if (availableColumnsObj.options[i].selected==true) {
270 var newColumnObj=document.createElement("OPTION");
271 newColumnObj.value=availableColumnsObj.options[i].value;
272 newColumnObj.text=availableColumnsObj.options[i].text;
273 selectedColumnsObj.appendChild(newColumnObj);
274 newColumnObj.selected=true;
279 function delColumn() {
280 for (i=0;i<=selectedColumnsObj.options.length;i++) {
281 if (selectedColumnsObj.options.selectedIndex>=0) {
282 selectedColumnsObj.remove(selectedColumnsObj.options.selectedIndex)
288 <!-- TMPL_INCLUDE NAME="intranet-bottom.inc" -->