Lines 206-211
canned reports and writing custom SQL reports.</p>
Link Here
|
206 |
|
206 |
|
207 |
|
207 |
|
208 |
[% IF ( build1 ) %] |
208 |
[% IF ( build1 ) %] |
|
|
209 |
[% IF ( cache_error) %] |
210 |
<div class="dialog alert"> |
211 |
<b> Please choose a cache_expiry less than 30 days </b> |
212 |
</div> |
213 |
[% END %] |
209 |
<h1>Build A Report</h1> |
214 |
<h1>Build A Report</h1> |
210 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
215 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
211 |
<fieldset class="rows"> |
216 |
<fieldset class="rows"> |
Lines 218-228
canned reports and writing custom SQL reports.</p>
Link Here
|
218 |
[% IF (public) %] |
223 |
[% IF (public) %] |
219 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0">False (default)</option> <option value="1" selected="selected">True</public> </select></li> |
224 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0">False (default)</option> <option value="1" selected="selected">True</public> </select></li> |
220 |
[% ELSE %] |
225 |
[% ELSE %] |
221 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0" selected="selelcted">False (default)</option> <option value="1">True</public> </select></li> |
226 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0" selected="selected">False (default)</option> <option value="1">True</public> </select></li> |
222 |
[% END %] |
227 |
[% END %] |
223 |
[% IF (usecache) %] <li><label for="cache_expiry">Cache expiry:</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input>seconds</li> [% END %] |
228 |
[% IF (usecache) %] <li> |
|
|
229 |
<label for="cache_expiry">Cache expiry:</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input> |
230 |
<select id="cache_expiry_units" name="cache_expiry_units"> |
231 |
<option value="seconds">Seconds (default)</option> |
232 |
<option value="minutes">Minutes</option> |
233 |
<option value="hours">Hours</option> |
234 |
<option value="days">Days</option> |
235 |
</select> |
236 |
</li>[% END %] |
224 |
</ol> |
237 |
</ol> |
225 |
</fieldset> |
238 |
<ofieldset> |
226 |
<fieldset class="action"> |
239 |
<fieldset class="action"> |
227 |
<input type="hidden" name="phase" value="Report on this Area" /> |
240 |
<input type="hidden" name="phase" value="Report on this Area" /> |
228 |
<input type="submit" name="submit" value="Next >>" /> |
241 |
<input type="submit" name="submit" value="Next >>" /> |
Lines 236-241
canned reports and writing custom SQL reports.</p>
Link Here
|
236 |
<h1>Build A Report</h1> |
249 |
<h1>Build A Report</h1> |
237 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
250 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
238 |
<input type="hidden" name="area" value="[% area %]" /> |
251 |
<input type="hidden" name="area" value="[% area %]" /> |
|
|
252 |
<input type="hidden" name="public" value="[% public %]" /> |
253 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
239 |
<fieldset class="rows"><legend>Step 2 of 6: Pick a Report Type</legend> |
254 |
<fieldset class="rows"><legend>Step 2 of 6: Pick a Report Type</legend> |
240 |
<ol><li><label for="types">Choose: </label> |
255 |
<ol><li><label for="types">Choose: </label> |
241 |
<select id="types" name="types"> |
256 |
<select id="types" name="types"> |
Lines 269-274
canned reports and writing custom SQL reports.</p>
Link Here
|
269 |
<form id="column_submit" action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
284 |
<form id="column_submit" action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
270 |
<input type="hidden" name="area" value="[% area %]" /> |
285 |
<input type="hidden" name="area" value="[% area %]" /> |
271 |
<input type="hidden" name="type" value="[% type %]" /> |
286 |
<input type="hidden" name="type" value="[% type %]" /> |
|
|
287 |
<input type="hidden" name="public" value="[% public %]" /> |
288 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
272 |
<fieldset> |
289 |
<fieldset> |
273 |
<div class="yui-g"> |
290 |
<div class="yui-g"> |
274 |
<div class="yui-u first"> <div style="float: left;"><select id="availableColumns" name="oldcolumns2" multiple="multiple" size="25" style="min-width: 200px;height:300px;"> |
291 |
<div class="yui-u first"> <div style="float: left;"><select id="availableColumns" name="oldcolumns2" multiple="multiple" size="25" style="min-width: 200px;height:300px;"> |
Lines 317-322
canned reports and writing custom SQL reports.</p>
Link Here
|
317 |
<input type="hidden" name="area" value="[% area %]" /> |
334 |
<input type="hidden" name="area" value="[% area %]" /> |
318 |
<input type="hidden" name="type" value="[% type %]" /> |
335 |
<input type="hidden" name="type" value="[% type %]" /> |
319 |
<input type="hidden" name="column" value="[% column %]" /> |
336 |
<input type="hidden" name="column" value="[% column %]" /> |
|
|
337 |
<input type="hidden" name="public" value="[% public %]" /> |
338 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
320 |
<fieldset><legend>Step 4 of 6: Select Criteria to Limit on</legend> |
339 |
<fieldset><legend>Step 4 of 6: Select Criteria to Limit on</legend> |
321 |
<table> |
340 |
<table> |
322 |
[% FOREACH criteri IN criteria %] |
341 |
[% FOREACH criteri IN criteria %] |
Lines 413-418
canned reports and writing custom SQL reports.</p>
Link Here
|
413 |
<input type="hidden" name="column" value="[% column %]" /> |
432 |
<input type="hidden" name="column" value="[% column %]" /> |
414 |
<input type="hidden" name="definition" value="[% definition %]" /> |
433 |
<input type="hidden" name="definition" value="[% definition %]" /> |
415 |
<input type="hidden" name="criteria" value="[% criteriastring %]" /> |
434 |
<input type="hidden" name="criteria" value="[% criteriastring %]" /> |
|
|
435 |
<input type="hidden" name="public" value="[% public %]" /> |
436 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
416 |
<fieldset><table> |
437 |
<fieldset><table> |
417 |
[% FOREACH total_b IN total_by %] |
438 |
[% FOREACH total_b IN total_by %] |
418 |
<tr><td><input type="checkbox" name="total_by" id="[% total_b.name %]" value="[% total_b.name %]" /> <label for="[% total_b.name %]">[% total_b.name %]</label></td> |
439 |
<tr><td><input type="checkbox" name="total_by" id="[% total_b.name %]" value="[% total_b.name %]" /> <label for="[% total_b.name %]">[% total_b.name %]</label></td> |
Lines 443-448
canned reports and writing custom SQL reports.</p>
Link Here
|
443 |
<input type="hidden" name="criteria" value="[% criteriastring %]" /> |
464 |
<input type="hidden" name="criteria" value="[% criteriastring %]" /> |
444 |
<input type="hidden" name="definition" value="[% definition %]" /> |
465 |
<input type="hidden" name="definition" value="[% definition %]" /> |
445 |
<input type="hidden" name="totals" value="[% totals %]" /> |
466 |
<input type="hidden" name="totals" value="[% totals %]" /> |
|
|
467 |
<input type="hidden" name="public" value="[% public %]" /> |
468 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
446 |
<fieldset><table>[% FOREACH order_b IN order_by %] |
469 |
<fieldset><table>[% FOREACH order_b IN order_by %] |
447 |
<tr><td><input type="checkbox" id="[% order_b.name %]" name="order_by" value="[% order_b.name %]" /> <label for="[% order_b.name %]">[% order_b.name %]</label></td><td> |
470 |
<tr><td><input type="checkbox" id="[% order_b.name %]" name="order_by" value="[% order_b.name %]" /> <label for="[% order_b.name %]">[% order_b.name %]</label></td><td> |
448 |
<select name="[% order_b.name %]_ovalue"> |
471 |
<select name="[% order_b.name %]_ovalue"> |
Lines 473-478
canned reports and writing custom SQL reports.</p>
Link Here
|
473 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
496 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
474 |
<input type="hidden" name="sql" value="[% sql %]" /> |
497 |
<input type="hidden" name="sql" value="[% sql %]" /> |
475 |
<input type="hidden" name="type" value="[% type %]" /> |
498 |
<input type="hidden" name="type" value="[% type %]" /> |
|
|
499 |
<input type="hidden" name="public" value="[% public %]" /> |
500 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
476 |
<p>You will need to save the report before you can execute it</p> |
501 |
<p>You will need to save the report before you can execute it</p> |
477 |
<fieldset class="action"><input type="hidden" name="phase" value="Save" /> |
502 |
<fieldset class="action"><input type="hidden" name="phase" value="Save" /> |
478 |
<input type="submit" name="submit" value="Save" /> </fieldset> |
503 |
<input type="submit" name="submit" value="Save" /> </fieldset> |
Lines 483-488
canned reports and writing custom SQL reports.</p>
Link Here
|
483 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
508 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
484 |
<input type="hidden" name="sql" value="[% sql |html %]" /> |
509 |
<input type="hidden" name="sql" value="[% sql |html %]" /> |
485 |
<input type="hidden" name="type" value="[% type %]" /> |
510 |
<input type="hidden" name="type" value="[% type %]" /> |
|
|
511 |
<input type="hidden" name="public" value="[% public %]" /> |
512 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
486 |
<fieldset class="rows"> |
513 |
<fieldset class="rows"> |
487 |
<legend>Save Your Custom Report</legend> |
514 |
<legend>Save Your Custom Report</legend> |
488 |
<ol> |
515 |
<ol> |
Lines 545-550
canned reports and writing custom SQL reports.</p>
Link Here
|
545 |
[% IF ( reportname ) %]<input type="text" id="reportname" name="reportname" value="[% reportname %]" /> |
572 |
[% IF ( reportname ) %]<input type="text" id="reportname" name="reportname" value="[% reportname %]" /> |
546 |
[% ELSE %]<input type="text" id="reportname" name="reportname" />[% END %] |
573 |
[% ELSE %]<input type="text" id="reportname" name="reportname" />[% END %] |
547 |
</li> |
574 |
</li> |
|
|
575 |
[% IF (public) %] |
576 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0">False (default)</option> <option value="1" selected="selected">True</public> </select></li> |
577 |
[% ELSE %] |
578 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0" selected="selected">False (default)</option> <option value="1">True</public> </select></li> |
579 |
[% END %] |
580 |
[% IF (usecache) %] <li> |
581 |
<label for="cache_expiry">Cache expiry:</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input> |
582 |
<select id="cache_expiry_units" name="cache_expiry_units"> |
583 |
<option value="seconds" selected="selected">Seconds (default)</option> |
584 |
<option value="minutes">Minutes</option> |
585 |
<option value="hours">Hours</option> |
586 |
<option value="days">Days</option> |
587 |
</select> |
588 |
</li>[% END %] |
548 |
<li><label for="notes">Notes:</label> <textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li> |
589 |
<li><label for="notes">Notes:</label> <textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li> |
549 |
<li><label for="types">Type:</label> |
590 |
<li><label for="types">Type:</label> |
550 |
<select id="types" name="types"> |
591 |
<select id="types" name="types"> |
Lines 620-626
Sub report:<select name="subreport">
Link Here
|
620 |
[% ELSE %] |
661 |
[% ELSE %] |
621 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0" selected="selelcted">False (default)</option> <option value="1">True</public> </select></li> |
662 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0" selected="selelcted">False (default)</option> <option value="1">True</public> </select></li> |
622 |
[% END %] |
663 |
[% END %] |
623 |
[% IF (usecache) %] <li><label for="cache_expiry">Cache expiry:</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input>seconds</li> [% END %] |
664 |
[% IF (usecache) %] <li> |
|
|
665 |
<label for="cache_expiry">Cache expiry:</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input> |
666 |
<select id="cache_expiry_units" name="cache_expiry_units"> |
667 |
<option value="seconds">Seconds (default)</option> |
668 |
<option value="minutes">Minutes</option> |
669 |
<option value="hours">Hours</option> |
670 |
<option value="days">Days</option> |
671 |
</select> |
672 |
</li>[% END %] |
624 |
<li><label for="notes">Notes:</label><textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li> |
673 |
<li><label for="notes">Notes:</label><textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li> |
625 |
<li><textarea id="sql" name="sql" rows="10" cols="60">[% sql %]</textarea></li> |
674 |
<li><textarea id="sql" name="sql" rows="10" cols="60">[% sql %]</textarea></li> |
626 |
</ol> |
675 |
</ol> |
Lines 657-662
Sub report:<select name="subreport">
Link Here
|
657 |
<br />Use of this keyword is not allowed in Koha reports due to security and data integrity risks. Only SELECT queries are allowed. |
706 |
<br />Use of this keyword is not allowed in Koha reports due to security and data integrity risks. Only SELECT queries are allowed. |
658 |
<br />Please return to the "Saved Reports" screen and delete this report or retry creating a new one. |
707 |
<br />Please return to the "Saved Reports" screen and delete this report or retry creating a new one. |
659 |
[% ELSIF ( error.queryerr ) %]The database returned the following error: <br />[% error.queryerr %]<br />Please check the log for further details. |
708 |
[% ELSIF ( error.queryerr ) %]The database returned the following error: <br />[% error.queryerr %]<br />Please check the log for further details. |
|
|
709 |
[% ELSIF ( error.cache_expiry ) %]Please select a cache expiry less than 30 days. |
660 |
[% ELSE %] |
710 |
[% ELSE %] |
661 |
[% END %] |
711 |
[% END %] |
662 |
[% END %] |
712 |
[% END %] |