Lines 1-14
Link Here
|
1 |
[% INCLUDE 'doc-head-open.inc' %] |
1 |
[% INCLUDE 'doc-head-open.inc' %] |
2 |
<title>Koha › Reports › Guided Reports Wizard |
2 |
<title>Koha › Reports › Guided reports wizard |
3 |
[% IF ( saved1 ) %]› Saved Reports |
3 |
[% IF ( saved1 ) %]› Saved Reports |
4 |
[% ELSIF ( create ) %]› Create from SQL |
4 |
[% ELSIF ( create ) %]› Create from SQL |
5 |
[% ELSIF ( showsql ) %]› Saved Reports › SQL View |
5 |
[% ELSIF ( showsql ) %]› Saved reports › SQL view |
6 |
[% ELSIF ( execute ) %]› Saved Reports › [% name %] Report |
6 |
[% ELSIF ( execute ) %]› Saved reports › [% name %] Report |
7 |
[% ELSIF ( buildx ) %]› Build A Report, Step [% buildx %] of 6: |
7 |
[% ELSIF ( buildx ) %]› Build a report, step [% buildx %] of 6: |
8 |
[% IF ( build1 ) %]Choose a Module |
8 |
[% IF ( build1 ) %]Choose a module |
9 |
[% ELSIF ( build2 ) %]Pick a Report Type |
9 |
[% ELSIF ( build2 ) %]Pick a report type |
10 |
[% ELSIF ( build3 ) %]Select Columns for Display |
10 |
[% ELSIF ( build3 ) %]Select columns for display |
11 |
[% ELSIF ( build4 ) %]Select Criteria to Limit on |
11 |
[% ELSIF ( build4 ) %]Select criteria to limit on |
12 |
[% ELSIF ( build5 ) %]Pick which columns to total |
12 |
[% ELSIF ( build5 ) %]Pick which columns to total |
13 |
[% ELSIF ( build6 ) %]Select how you want the report ordered |
13 |
[% ELSIF ( build6 ) %]Select how you want the report ordered |
14 |
[% END %] |
14 |
[% END %] |
Lines 66-82
$(document).ready(function(){
Link Here
|
66 |
|
66 |
|
67 |
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> |
67 |
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> |
68 |
› <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> |
68 |
› <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> |
69 |
› <a href="/cgi-bin/koha/reports/guided_reports.pl">Guided Reports Wizard</a> |
69 |
› <a href="/cgi-bin/koha/reports/guided_reports.pl">Guided reports wizard</a> |
70 |
› |
70 |
› |
71 |
[% IF ( saved1 ) %]Saved Reports |
71 |
[% IF ( saved1 ) %]Saved reports |
72 |
[% ELSIF ( create ) %]Create from SQL |
72 |
[% ELSIF ( create ) %]Create from SQL |
73 |
[% ELSIF ( showsql ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved Reports</a> › SQL View |
73 |
[% ELSIF ( showsql ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved reports</a> › SQL view |
74 |
[% ELSIF ( execute ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved Reports</a> › <em>[% name %]</em> Report |
74 |
[% ELSIF ( execute ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved reports</a> › <em>[% name %]</em> Report |
75 |
[% ELSIF ( buildx ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build A Report</a> › Step [% buildx %] of 6: |
75 |
[% ELSIF ( buildx ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build a report</a> › Step [% buildx %] of 6: |
76 |
[% IF ( build1 ) %]Choose a Module |
76 |
[% IF ( build1 ) %]Choose a module |
77 |
[% ELSIF ( build2 ) %]Pick a Report Type |
77 |
[% ELSIF ( build2 ) %]Pick a report type |
78 |
[% ELSIF ( build3 ) %]Select Columns for Display |
78 |
[% ELSIF ( build3 ) %]Select columns for display |
79 |
[% ELSIF ( build4 ) %]Select Criteria to Limit on |
79 |
[% ELSIF ( build4 ) %]Select criteria to limit on |
80 |
[% ELSIF ( build5 ) %]Pick which columns to total |
80 |
[% ELSIF ( build5 ) %]Pick which columns to total |
81 |
[% ELSIF ( build6 ) %]Select how you want the report ordered |
81 |
[% ELSIF ( build6 ) %]Select how you want the report ordered |
82 |
[% END %] |
82 |
[% END %] |
Lines 90-101
$(document).ready(function(){
Link Here
|
90 |
[% INCLUDE "reports-toolbar.inc" %] |
90 |
[% INCLUDE "reports-toolbar.inc" %] |
91 |
|
91 |
|
92 |
[% IF ( start ) %] |
92 |
[% IF ( start ) %] |
93 |
<h2>Guided Reports</h2> |
93 |
<h2>Guided reports</h2> |
94 |
<p>Use the guided reports engine to create non standard reports. |
94 |
<p>Use the guided reports engine to create non standard reports. |
95 |
This feature aims to provide some middle ground between the built in |
95 |
This feature aims to provide some middle ground between the built in |
96 |
canned reports and writing custom SQL reports.</p> |
96 |
canned reports and writing custom SQL reports.</p> |
97 |
|
97 |
|
98 |
<h3>Build And Run Reports</h3> |
98 |
<h3>Build and run reports</h3> |
99 |
[% IF ( CAN_user_reports_create_reports ) %] |
99 |
[% IF ( CAN_user_reports_create_reports ) %] |
100 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
100 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
101 |
<input type="hidden" name="phase" value="Build new" /> |
101 |
<input type="hidden" name="phase" value="Build new" /> |
Lines 117-129
canned reports and writing custom SQL reports.</p>
Link Here
|
117 |
<h3>Reports Dictionary</h3> |
117 |
<h3>Reports Dictionary</h3> |
118 |
<p>Use the reports dictionary to define custom criteria to use in your reports</p> |
118 |
<p>Use the reports dictionary to define custom criteria to use in your reports</p> |
119 |
<form action="/cgi-bin/koha/reports/dictionary.pl"> |
119 |
<form action="/cgi-bin/koha/reports/dictionary.pl"> |
120 |
<input type="hidden" name="phase" value="View Dictionary"/> |
120 |
<input type="hidden" name="phase" value="View dictionary"/> |
121 |
<input type="submit" name="submit" value="View Dictionary"/> |
121 |
<input type="submit" name="submit" value="View dictionary"/> |
122 |
</form> |
122 |
</form> |
123 |
[% END %] |
123 |
[% END %] |
124 |
|
124 |
|
125 |
[% IF ( saved1 ) %] |
125 |
[% IF ( saved1 ) %] |
126 |
[% IF ( savedreports ) %]<h1>Saved Reports</h1> |
126 |
[% IF ( savedreports ) %]<h1>Saved reports</h1> |
127 |
|
127 |
|
128 |
<div id="pagertable_reports"> |
128 |
<div id="pagertable_reports"> |
129 |
[% INCLUDE 'table-pager.inc' perpage='20' %] |
129 |
[% INCLUDE 'table-pager.inc' perpage='20' %] |
Lines 133-144
canned reports and writing custom SQL reports.</p>
Link Here
|
133 |
<thead> |
133 |
<thead> |
134 |
<tr> |
134 |
<tr> |
135 |
<th>ID</th> |
135 |
<th>ID</th> |
136 |
<th>Report Name</th> |
136 |
<th>Report name</th> |
137 |
<th>Type</th> |
137 |
<th>Type</th> |
138 |
<th>Notes</th> |
138 |
<th>Notes</th> |
139 |
<th>Author</th> |
139 |
<th>Author</th> |
140 |
<th>Creation Date</th> |
140 |
<th>Creation date</th> |
141 |
<th>Saved Results</th> |
141 |
<th>Saved results</th> |
142 |
<th>Saved SQL</th> |
142 |
<th>Saved SQL</th> |
143 |
<th> </th> |
143 |
<th> </th> |
144 |
<th> </th> |
144 |
<th> </th> |
Lines 199-208
canned reports and writing custom SQL reports.</p>
Link Here
|
199 |
|
199 |
|
200 |
|
200 |
|
201 |
[% IF ( build1 ) %] |
201 |
[% IF ( build1 ) %] |
202 |
<h1>Build A Report</h1> |
202 |
<h1>Build a report</h1> |
203 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
203 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
204 |
<fieldset class="rows"> |
204 |
<fieldset class="rows"> |
205 |
<legend>Step 1 of 6: Choose a Module to Report on</legend> |
205 |
<legend>Step 1 of 6: Choose a module to report on</legend> |
206 |
<ol><li><label for="areas">Choose: </label><select name="areas" id="areas"> |
206 |
<ol><li><label for="areas">Choose: </label><select name="areas" id="areas"> |
207 |
[% FOREACH area IN areas %] |
207 |
[% FOREACH area IN areas %] |
208 |
<option value="[% area.id %]">[% area.name %]</option> |
208 |
<option value="[% area.id %]">[% area.name %]</option> |
Lines 222-228
canned reports and writing custom SQL reports.</p>
Link Here
|
222 |
<h1>Build A Report</h1> |
222 |
<h1>Build A Report</h1> |
223 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
223 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
224 |
<input type="hidden" name="area" value="[% area %]" /> |
224 |
<input type="hidden" name="area" value="[% area %]" /> |
225 |
<fieldset class="rows"><legend>Step 2 of 6: Pick a Report Type</legend> |
225 |
<fieldset class="rows"><legend>Step 2 of 6: Pick a report type</legend> |
226 |
<ol><li><label for="types">Choose: </label> |
226 |
<ol><li><label for="types">Choose: </label> |
227 |
<select id="types" name="types"> |
227 |
<select id="types" name="types"> |
228 |
<option value="1">Tabular</option> |
228 |
<option value="1">Tabular</option> |
Lines 249-255
canned reports and writing custom SQL reports.</p>
Link Here
|
249 |
[% END %] |
249 |
[% END %] |
250 |
|
250 |
|
251 |
[% IF ( build3 ) %] |
251 |
[% IF ( build3 ) %] |
252 |
<h3>Step 3 of 6: Select Columns for Display</h3> |
252 |
<h3>Step 3 of 6: Select columns for display</h3> |
253 |
<p>Note: Be careful selecting when selecting columns. If your choice is too broad it could result in a very large report that will either not complete, or slow your system down.</p> |
253 |
<p>Note: Be careful selecting when selecting columns. If your choice is too broad it could result in a very large report that will either not complete, or slow your system down.</p> |
254 |
|
254 |
|
255 |
<form id="column_submit" action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
255 |
<form id="column_submit" action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
Lines 303-309
canned reports and writing custom SQL reports.</p>
Link Here
|
303 |
<input type="hidden" name="area" value="[% area %]" /> |
303 |
<input type="hidden" name="area" value="[% area %]" /> |
304 |
<input type="hidden" name="type" value="[% type %]" /> |
304 |
<input type="hidden" name="type" value="[% type %]" /> |
305 |
<input type="hidden" name="column" value="[% column %]" /> |
305 |
<input type="hidden" name="column" value="[% column %]" /> |
306 |
<fieldset><legend>Step 4 of 6: Select Criteria to Limit on</legend> |
306 |
<fieldset><legend>Step 4 of 6: Select criteria to limit on</legend> |
307 |
<table> |
307 |
<table> |
308 |
[% FOREACH criteri IN criteria %] |
308 |
[% FOREACH criteri IN criteria %] |
309 |
<tr> |
309 |
<tr> |
Lines 314-320
canned reports and writing custom SQL reports.</p>
Link Here
|
314 |
[% IF ( criteri.date ) %] |
314 |
[% IF ( criteri.date ) %] |
315 |
<td> |
315 |
<td> |
316 |
<input type="text" size="10" id="[% criteri.name %]_value" name="[% criteri.name %]_value" value="" /> |
316 |
<input type="text" size="10" id="[% criteri.name %]_value" name="[% criteri.name %]_value" value="" /> |
317 |
<img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfrom[% criteri.name %]" style="cursor: pointer;" alt="Show Calendar" title="Show Calendar" /> |
317 |
<img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfrom[% criteri.name %]" style="cursor: pointer;" alt="Show calendar" title="Show calendar" /> |
318 |
<script type="text/javascript"> |
318 |
<script type="text/javascript"> |
319 |
Calendar.setup({ |
319 |
Calendar.setup({ |
320 |
inputField : "[% criteri.name %]_value", |
320 |
inputField : "[% criteri.name %]_value", |
Lines 337-343
canned reports and writing custom SQL reports.</p>
Link Here
|
337 |
[% IF ( criteri.daterange ) %] |
337 |
[% IF ( criteri.daterange ) %] |
338 |
<td>from |
338 |
<td>from |
339 |
<input type="text" size="10" id="from_[% criteri.name %]_value" name="from_[% criteri.name %]_value" value="" /> |
339 |
<input type="text" size="10" id="from_[% criteri.name %]_value" name="from_[% criteri.name %]_value" value="" /> |
340 |
<img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfromfrom_[% criteri.name %]" style="cursor: pointer;" alt="Show Calendar" title="Show Calendar" /> |
340 |
<img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfromfrom_[% criteri.name %]" style="cursor: pointer;" alt="Show calendar" title="Show calendar" /> |
341 |
<script type="text/javascript"> |
341 |
<script type="text/javascript"> |
342 |
Calendar.setup({ |
342 |
Calendar.setup({ |
343 |
inputField : "from_[% criteri.name %]_value", |
343 |
inputField : "from_[% criteri.name %]_value", |
Lines 348-354
canned reports and writing custom SQL reports.</p>
Link Here
|
348 |
</script> |
348 |
</script> |
349 |
to |
349 |
to |
350 |
<input type="text" size="10" id="to_[% criteri.name %]_value" name="to_[% criteri.name %]_value" value="" /> |
350 |
<input type="text" size="10" id="to_[% criteri.name %]_value" name="to_[% criteri.name %]_value" value="" /> |
351 |
<img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfromto_[% criteri.name %]" style="cursor: pointer;" alt="Show Calendar" title="Show Calendar" /> |
351 |
<img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfromto_[% criteri.name %]" style="cursor: pointer;" alt="Show calendar" title="Show calendar" /> |
352 |
<script type="text/javascript"> |
352 |
<script type="text/javascript"> |
353 |
Calendar.setup({ |
353 |
Calendar.setup({ |
354 |
inputField : "to_[% criteri.name %]_value", |
354 |
inputField : "to_[% criteri.name %]_value", |
Lines 377-383
canned reports and writing custom SQL reports.</p>
Link Here
|
377 |
</fieldset> |
377 |
</fieldset> |
378 |
|
378 |
|
379 |
[% IF ( definitions ) %] |
379 |
[% IF ( definitions ) %] |
380 |
<fieldset><legend>Dictionary Definitions</legend><table> |
380 |
<fieldset><legend>Dictionary definitions</legend><table> |
381 |
[% FOREACH definition IN definitions %] |
381 |
[% FOREACH definition IN definitions %] |
382 |
<tr><td><input type="checkbox" name="definition" value="[% definition.id %]" /> [% definition.name %]</td></tr> |
382 |
<tr><td><input type="checkbox" name="definition" value="[% definition.id %]" /> [% definition.name %]</td></tr> |
383 |
[% END %] |
383 |
[% END %] |
Lines 413-419
canned reports and writing custom SQL reports.</p>
Link Here
|
413 |
[% END %] |
413 |
[% END %] |
414 |
</table></fieldset> |
414 |
</table></fieldset> |
415 |
|
415 |
|
416 |
<fieldset class="action"><input type="hidden" name="phase" value="Choose These Operations" /> |
416 |
<fieldset class="action"><input type="hidden" name="phase" value="Choose these operations" /> |
417 |
<input type="button" name="back" value="<< Back" onclick="javascript:history.back()" /> |
417 |
<input type="button" name="back" value="<< Back" onclick="javascript:history.back()" /> |
418 |
<input type="submit" name="submit" value="Next >>" /></fieldset> |
418 |
<input type="submit" name="submit" value="Next >>" /></fieldset> |
419 |
</form> |
419 |
</form> |
Lines 443-456
canned reports and writing custom SQL reports.</p>
Link Here
|
443 |
</table></fieldset> |
443 |
</table></fieldset> |
444 |
|
444 |
|
445 |
<fieldset class="action"> |
445 |
<fieldset class="action"> |
446 |
<input type="hidden" name="phase" value="Build Report" /> |
446 |
<input type="hidden" name="phase" value="Build report" /> |
447 |
<input type="submit" name="submit" value="Finish" /></fieldset> |
447 |
<input type="submit" name="submit" value="Finish" /></fieldset> |
448 |
</form> |
448 |
</form> |
449 |
[% END %] |
449 |
[% END %] |
450 |
|
450 |
|
451 |
|
451 |
|
452 |
[% IF ( showreport ) %] |
452 |
[% IF ( showreport ) %] |
453 |
<h1>Confirm Custom Report</h1> |
453 |
<h1>Confirm custom report</h1> |
454 |
<p>Your report will be generated with the following SQL statement.</p> |
454 |
<p>Your report will be generated with the following SQL statement.</p> |
455 |
<p> |
455 |
<p> |
456 |
[% sql |html %] |
456 |
[% sql |html %] |
Lines 470-482
canned reports and writing custom SQL reports.</p>
Link Here
|
470 |
<input type="hidden" name="sql" value="[% sql |html %]" /> |
470 |
<input type="hidden" name="sql" value="[% sql |html %]" /> |
471 |
<input type="hidden" name="type" value="[% type %]" /> |
471 |
<input type="hidden" name="type" value="[% type %]" /> |
472 |
<fieldset class="rows"> |
472 |
<fieldset class="rows"> |
473 |
<legend>Save Your Custom Report</legend> |
473 |
<legend>Save your custom report</legend> |
474 |
<ol> |
474 |
<ol> |
475 |
<li><label for="reportname">Report Name: </label><input type="text" id="reportname" name="reportname" /></li> |
475 |
<li><label for="reportname">Report name: </label><input type="text" id="reportname" name="reportname" /></li> |
476 |
<li><label for="notes">Notes:</label> <textarea name="notes" id="notes"></textarea></li> |
476 |
<li><label for="notes">Notes:</label> <textarea name="notes" id="notes"></textarea></li> |
477 |
</ol></fieldset> |
477 |
</ol></fieldset> |
478 |
<fieldset class="action"><input type="hidden" name="phase" value="Save Report" /> |
478 |
<fieldset class="action"><input type="hidden" name="phase" value="Save report" /> |
479 |
<input type="submit" name="submit" value="Save Report" /></fieldset> |
479 |
<input type="submit" name="submit" value="Save report" /></fieldset> |
480 |
</form> |
480 |
</form> |
481 |
[% END %] |
481 |
[% END %] |
482 |
|
482 |
|
Lines 490-496
canned reports and writing custom SQL reports.</p>
Link Here
|
490 |
[% IF sql_param.input == 'date' %] |
490 |
[% IF sql_param.input == 'date' %] |
491 |
<p> |
491 |
<p> |
492 |
[% sql_param.entry %]: <input id="date_[% sql_param_entry %]" type="text" value="" size="10" name="sql_params"> |
492 |
[% sql_param.entry %]: <input id="date_[% sql_param_entry %]" type="text" value="" size="10" name="sql_params"> |
493 |
<img id="date_picker_[% sql_param_entry %]" alt="Show Calendar" src="/intranet-tmpl/prog/en/lib/calendar/cal.gif"> |
493 |
<img id="date_picker_[% sql_param_entry %]" alt="Show calendar" src="/intranet-tmpl/prog/en/lib/calendar/cal.gif"> |
494 |
<script type="text/javascript"> |
494 |
<script type="text/javascript"> |
495 |
Calendar.setup( { |
495 |
Calendar.setup( { |
496 |
inputField : "date_[% sql_param_entry %]", |
496 |
inputField : "date_[% sql_param_entry %]", |
Lines 526-533
canned reports and writing custom SQL reports.</p>
Link Here
|
526 |
<fieldset class="action"> |
526 |
<fieldset class="action"> |
527 |
<label for="format">Download the report: </label> |
527 |
<label for="format">Download the report: </label> |
528 |
<select name="format" id="format"> |
528 |
<select name="format" id="format"> |
529 |
<option value="csv">Comma Separated Text</option> |
529 |
<option value="csv">Comma separated text</option> |
530 |
<option value="tab">Tab Separated Text</option> |
530 |
<option value="tab">Tab separated text</option> |
531 |
</select> |
531 |
</select> |
532 |
<input type="hidden" name="sql" value="[% sql |html %]" /> |
532 |
<input type="hidden" name="sql" value="[% sql |html %]" /> |
533 |
<input type="hidden" name="phase" value="Export" /> |
533 |
<input type="hidden" name="phase" value="Export" /> |
Lines 539-547
canned reports and writing custom SQL reports.</p>
Link Here
|
539 |
[% IF ( create ) %] |
539 |
[% IF ( create ) %] |
540 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
540 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
541 |
<fieldset class="rows"> |
541 |
<fieldset class="rows"> |
542 |
<legend>Create Report From SQL</legend> |
542 |
<legend>Create report from SQL</legend> |
543 |
<ol> |
543 |
<ol> |
544 |
<li><label for="reportname">Report Name:</label> |
544 |
<li><label for="reportname">Report name:</label> |
545 |
[% IF ( reportname ) %]<input type="text" id="reportname" name="reportname" value="[% reportname %]" /> |
545 |
[% IF ( reportname ) %]<input type="text" id="reportname" name="reportname" value="[% reportname %]" /> |
546 |
[% ELSE %]<input type="text" id="reportname" name="reportname" />[% END %] |
546 |
[% ELSE %]<input type="text" id="reportname" name="reportname" />[% END %] |
547 |
</li> |
547 |
</li> |
Lines 562-568
canned reports and writing custom SQL reports.</p>
Link Here
|
562 |
</div> |
562 |
</div> |
563 |
</fieldset> |
563 |
</fieldset> |
564 |
|
564 |
|
565 |
<fieldset class="action"><input type="hidden" name="phase" value="Save Report" /> |
565 |
<fieldset class="action"><input type="hidden" name="phase" value="Save report" /> |
566 |
<input type="submit" name="submit" value="Save Report" /> <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved" class="cancel">Cancel</a> |
566 |
<input type="submit" name="submit" value="Save Report" /> <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved" class="cancel">Cancel</a> |
567 |
</fieldset> |
567 |
</fieldset> |
568 |
</form> |
568 |
</form> |
Lines 582-589
Sub report:<select name="subreport">
Link Here
|
582 |
[% END %] |
582 |
[% END %] |
583 |
</select> |
583 |
</select> |
584 |
<br /> |
584 |
<br /> |
585 |
<input type="hidden" name="phase" value="Save Compound" /> |
585 |
<input type="hidden" name="phase" value="Save compound" /> |
586 |
<input type="submit" name="submit" value="Save Compound" /> |
586 |
<input type="submit" name="submit" value="Save compound" /> |
587 |
</form> |
587 |
</form> |
588 |
[% END %] |
588 |
[% END %] |
589 |
|
589 |
|
Lines 594-600
Sub report:<select name="subreport">
Link Here
|
594 |
|
594 |
|
595 |
|
595 |
|
596 |
[% IF ( retresults ) %] |
596 |
[% IF ( retresults ) %] |
597 |
<h1>Saved Report Results</h1> |
597 |
<h1>Saved report results</h1> |
598 |
<h2>[% name %]</h2> |
598 |
<h2>[% name %]</h2> |
599 |
<p>[% notes %]</p> |
599 |
<p>[% notes %]</p> |
600 |
<table> |
600 |
<table> |
Lines 621-627
Sub report:<select name="subreport">
Link Here
|
621 |
<fieldset class="rows"> |
621 |
<fieldset class="rows"> |
622 |
<legend>Edit SQL report</legend> |
622 |
<legend>Edit SQL report</legend> |
623 |
<ol> |
623 |
<ol> |
624 |
<li><label for="reportname">Report Name:</label><input type="text" id="reportname" name="reportname" value="[% reportname %]" size="50" /></li> |
624 |
<li><label for="reportname">Report name:</label><input type="text" id="reportname" name="reportname" value="[% reportname %]" size="50" /></li> |
625 |
<li><label for="notes">Notes:</label><textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li> |
625 |
<li><label for="notes">Notes:</label><textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li> |
626 |
<li><textarea id="sql" name="sql" rows="10" cols="60">[% sql %]</textarea></li> |
626 |
<li><textarea id="sql" name="sql" rows="10" cols="60">[% sql %]</textarea></li> |
627 |
</ol> |
627 |
</ol> |
Lines 643-651
Sub report:<select name="subreport">
Link Here
|
643 |
[% IF ( id ) %] |
643 |
[% IF ( id ) %] |
644 |
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% id %]&phase=Run%20this%20report">Run this report</a></li> |
644 |
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% id %]&phase=Run%20this%20report">Run this report</a></li> |
645 |
[% END %] |
645 |
[% END %] |
646 |
<li>Access this report from the: <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved Reports Page</a></li> |
646 |
<li>Access this report from the: <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved reports page</a></li> |
647 |
<li>Schedule this report to run using the: <a href="/cgi-bin/koha/tools/scheduler.pl">Scheduler Tool</a></li> |
647 |
<li>Schedule this report to run using the: <a href="/cgi-bin/koha/tools/scheduler.pl">Scheduler tool</a></li> |
648 |
<li>Return to: <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Guided Reports</a></li> |
648 |
<li>Return to: <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Guided reports</a></li> |
649 |
</ul> |
649 |
</ul> |
650 |
[% END %] |
650 |
[% END %] |
651 |
[% END %] |
651 |
[% END %] |
Lines 664-670
Sub report:<select name="subreport">
Link Here
|
664 |
[% END %] |
664 |
[% END %] |
665 |
</div> |
665 |
</div> |
666 |
<fieldset class="action"><input type="hidden" name="phase" value="Use saved" /> |
666 |
<fieldset class="action"><input type="hidden" name="phase" value="Use saved" /> |
667 |
<input type="submit" name="submit" value="Saved Reports" /></fieldset> |
667 |
<input type="submit" name="submit" value="Saved reports" /></fieldset> |
668 |
</form> |
668 |
</form> |
669 |
[% END %] |
669 |
[% END %] |
670 |
|
670 |
|
Lines 681-687
Sub report:<select name="subreport">
Link Here
|
681 |
<h3>Filter</h3> |
681 |
<h3>Filter</h3> |
682 |
<ol> |
682 |
<ol> |
683 |
<li><label for="filter_date">Date: |
683 |
<li><label for="filter_date">Date: |
684 |
<img src="[% themelang %]/lib/calendar/cal.gif" id="datedueto_button" alt="Show Calendar" /></label> <input type="text" id="filter_date" name="filter_date" size="10" value="[% filter_date %]" /> |
684 |
<img src="[% themelang %]/lib/calendar/cal.gif" id="datedueto_button" alt="Show calendar" /></label> <input type="text" id="filter_date" name="filter_date" size="10" value="[% filter_date %]" /> |
685 |
<div class="hint">[% INCLUDE 'date-format.inc' %]</div> |
685 |
<div class="hint">[% INCLUDE 'date-format.inc' %]</div> |
686 |
<script type="text/javascript"> |
686 |
<script type="text/javascript"> |
687 |
Calendar.setup( |
687 |
Calendar.setup( |