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/circ/circulation.pl">Reports</a> › <strong>Guided Reports Wizard </strong></div>
13 <div id="doc3" class="yui-t2">
21 <!-- TMPL_IF NAME="start" -->
22 <form action="/cgi-bin/koha/reports/guided_reports.pl">
23 <input type="submit" name="phase" value="Build new"/>
24 <input type="submit" name="phase" value="Used saved"/>
25 <input type="submit" name="phase" value="Create report from SQL"/>
26 <input type="submit" name="phase" value="Create Compound Report"/>
27 <input type="submit" name="phase" value="View Dictionary"/>
31 <!-- TMPL_IF NAME="saved1" -->
32 Choose the report from the list
33 <form action="/cgi-bin/koha/reports/guided_reports.pl">
34 <select name="reports">
35 <!-- TMPL_LOOP NAME="savedreports" -->
36 <option value="<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="report_name"--></option>
39 <input type="submit" name="phase" value="Run this report">
44 <!-- TMPL_IF NAME="build1" -->
45 <h3>Step 1 of 6: Choose a Module to Report on</h3>
46 <form action="/cgi-bin/koha/reports/guided_reports.pl">
48 <!-- TMPL_LOOP NAME="areas" -->
49 <option value="<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="name"--></option>
53 <input type="submit" name="phase" value="Report on this Area">
58 <!-- TMPL_IF NAME="build2" -->
59 <h3>Step 2 of 6: Pick a Report Type</h3>
60 <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
61 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->">
63 <!-- TMPL_LOOP NAME="types" -->
64 <option value="<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="name"--></option>
68 <input type="submit" name="phase" value="Choose this type">
72 <img src="http://staff-crc.dev.kohalibrary.com/intranet-tmpl/prog/img/reports-tabular-graphic.gif" />
74 <img src="http://staff-crc.dev.kohalibrary.com/intranet-tmpl/prog/img/reports-summary-graphic.gif" />
76 <img src="http://staff-crc.dev.kohalibrary.com/intranet-tmpl/prog/img/reports-matrix-graphic.gif" />
79 <!-- TMPL_IF NAME="build3" -->
80 <h3>Step 3 of 6: Select Columns for Display</h3>
81 <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
82 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->">
83 <input type="hidden" name="type" value="<!-- TMPL_VAR NAME="type" -->">
84 <select id="availableColumns" name="oldcolumns2" multiple size="25" style="width:200px;height:300px;">
85 <!-- TMPL_LOOP NAME="columns" -->
86 <!-- TMPL_IF NAME="table" -->
88 <!-- TMPL_IF NAME="__first__" -->
93 <optgroup label="<!-- TMPL_VAR NAME="table"-->">
95 <option value="<!-- TMPL_VAR NAME="name" -->">
96 <!-- TMPL_IF NAME="description" --><!-- TMPL_VAR NAME="description" -->
98 <!-- TMPL_VAR NAME="name" -->
104 <input type="button" name="Add" value="Add" class="button" onClick="addColumn()"/>
105 <select id="selectedColumns" name="columns" multiple size="25" style="width:200px;height:300px;"></select>
106 <input type="button" name="delete" value="delete" class="button" onClick="delColumn()"/>
108 <input type="submit" name="phase" value="Choose these columns">
112 <!-- TMPL_IF NAME="build4" -->
113 <h3>Step 4 of 6: Select Criteria to Limit on </h3>
115 <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post" >
116 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->">
117 <input type="hidden" name="type" value="<!-- TMPL_VAR NAME="type" -->">
118 <input type="hidden" name="column" value="<!-- TMPL_VAR NAME="column" -->">
119 <!-- TMPL_LOOP NAME="criteria" -->
120 <input type=checkbox name="criteria_column" value="<!-- TMPL_VAR NAME="name" -->"><!-- TMPL_VAR NAME="description" --> =
121 <!-- TMPL_IF NAME="date" -->
122 <input type="text" size="10" id="<!-- TMPL_VAR NAME="name" -->_value" name="<!-- TMPL_VAR NAME="name" -->_value" value="" >
123 <img src="<!-- TMPL_VAR Name="themelang" -->/includes/calendar/cal.gif" id="buttonfrom1" style="cursor: pointer;" />
124 <script type="text/javascript">
126 inputField : "<!-- TMPL_VAR NAME="name" -->_value",
127 ifFormat : "%Y-%m-%d",
128 button : "buttonfrom1",
134 <select name="<!-- TMPL_VAR NAME="name" -->_value">
135 <!-- TMPL_LOOP NAME="values" -->
136 <option value="<!-- TMPL_VAR NAME="availablevalues"-->"><!-- TMPL_VAR NAME="availablevalues" --></option>
143 <!-- TMPL_IF NAME="definitions" -->
144 Dictionary Definitions <br />
145 <!-- TMPL_LOOP NAME="definitions" -->
146 <input type=checkbox name="definition" value="<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="name" --><br />
149 <input type="submit" name="phase" value="Choose these criteria">
154 <!-- TMPL_IF NAME="build5" -->
155 <h3>Step 5 of 6: Pick which columns to total</h3>
156 <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
157 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->">
158 <input type="hidden" name="type" value="<!-- TMPL_VAR NAME="type" -->">
159 <input type="hidden" name="column" value="<!-- TMPL_VAR NAME="column" -->">
160 <input type="hidden" name="definition" value="<!-- TMPL_VAR NAME="definition" -->">
161 <input type="hidden" name="criteria" value="<!-- TMPL_VAR NAME="criteriastring" -->">
162 <!-- TMPL_LOOP NAME="total_by" -->
163 <input type=checkbox name="total_by" value="<!-- TMPL_VAR NAME="name" -->"><!-- TMPL_VAR NAME="name"-->
164 <select name="<!-- TMPL_VAR NAME="name" -->_tvalue">
166 <!-- TMPL_LOOP NAME="select" -->
167 <option value="<!-- TMPL_VAR NAME="value"-->"><!-- TMPL_VAR NAME="value" --></option>
174 <input type="submit" name="phase" value="Choose Totals">
179 <!-- TMPL_IF NAME="build6" -->
180 <h3>Step 6 of 6: Select the ordering</h3>
181 <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
182 <input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->">
183 <input type="hidden" name="type" value="<!-- TMPL_VAR NAME="type" -->">
184 <input type="hidden" name="column" value="<!-- TMPL_VAR NAME="column" -->">
185 <input type="hidden" name="criteria" value="<!-- TMPL_VAR NAME="criteriastring" -->">
186 <input type="hidden" name="definition" value="<!-- TMPL_VAR NAME="definition" -->">
187 <input type="hidden" name="totals" value="<!-- TMPL_VAR NAME="totals" -->">
188 <!-- TMPL_LOOP NAME="order_by" -->
189 <input type=checkbox name="order_by" value="<!-- TMPL_VAR NAME="name" -->"><!-- TMPL_VAR NAME="name"-->
190 <select name="<!-- TMPL_VAR NAME="name" -->_ovalue">
192 <!-- TMPL_LOOP NAME="select" -->
193 <option value="<!-- TMPL_VAR NAME="value"-->"><!-- TMPL_VAR NAME="value" --></option>
200 <input type="submit" name="phase" value="Build Report">
205 <!-- TMPL_IF NAME="showreport" -->
206 <!-- TMPL_VAR NAME="sql" -->
209 <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
210 <input type="hidden" name="sql" value="<!-- TMPL_VAR NAME="sql" -->">
211 <input type="hidden" name="type" value="<!-- TMPL_VAR NAME="type" -->">
212 <input type="submit" name="phase" value="Save"> <input type="submit" name="phase" value="Execute">
216 <!-- TMPL_IF NAME="save" -->
217 <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
218 <input type="hidden" name="sql" value="<!-- TMPL_VAR NAME="sql" -->">
219 <input type="hidden" name="type" value="<!-- TMPL_VAR NAME="type" -->">
220 Report Name: <input type="text" name="reportname"> <br />
221 Notes: <textarea name="notes"></textarea><br />
222 <input type="submit" name="phase" value="Save Report">
226 <!-- TMPL_IF NAME="execute" -->
229 <!-- TMPL_LOOP NAME="results" -->
230 <!-- TMPL_VAR NAME="row" -->
233 <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
234 <select name="format">
235 <option value="csv">Comma Separated Text</option>
236 <option value="tab">Tab Separated Text</option>
238 <input type="submit" name="phase" value="Export">
239 <input type="hidden" name="sql" value="<!-- TMPL_VAR NAME="sql" -->">
243 <!-- TMPL_IF NAME="create" -->
244 <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
245 Report Name: <input type="text" name="reportname"> <br />
247 <select name="types">
248 <!-- TMPL_LOOP NAME="types" -->
249 <option value="<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="name"--></option>
253 SQl: <textarea name="sql" cols=30 rows=10></textarea><br />
254 <input type="submit" name="phase" value="Save Report">
258 <!-- TMPL_IF NAME="compound" -->
259 <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
260 Master: <select name="master">
261 <!-- TMPL_LOOP NAME="savedreports" -->
262 <option value="<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="report_name"--></option>
266 Sub report:<select name="subreport">
267 <!-- TMPL_LOOP NAME="savedreports" -->
268 <option value="<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="report_name"--></option>
272 <input type="submit" name="phase" value="Save Compound">
276 <!-- TMPL_IF NAME="save_compound" -->
277 <!-- TMPL_VAR NAME="master" --> <br />
278 <!-- TMPL_VAR NAME="subsql" -->
284 <!-- TMPL_INCLUDE NAME="guided-reports-view.inc" -->
287 <script type="text/javascript">
288 function setObjects() {
289 selectedColumnsObj=document.getElementById('selectedColumns');
290 availableColumnsObj=document.getElementById('availableColumns');
294 function addColumn() {
295 for (i=0;i<availableColumnsObj.length;i++) {
296 if (availableColumnsObj.options[i].selected==true) {
297 var newColumnObj=document.createElement("OPTION");
298 newColumnObj.value=availableColumnsObj.options[i].value;
299 newColumnObj.text=availableColumnsObj.options[i].text;
300 selectedColumnsObj.appendChild(newColumnObj);
301 newColumnObj.selected=true;
306 function delColumn() {
307 for (i=0;i<=selectedColumnsObj.options.length;i++) {
308 if (selectedColumnsObj.options.selectedIndex>=0)
309 selectedColumnsObj.remove(selectedColumnsObj.options.selectedIndex)
313 <!-- TMPL_INCLUDE NAME="intranet-bottom.inc" -->