|
Lines 220-226
canned reports and writing custom SQL reports.</p>
Link Here
|
| 220 |
<td>[% savedreport.type | html %]</td> |
220 |
<td>[% savedreport.type | html %]</td> |
| 221 |
<td>[% savedreport.groupname | html %]</td> |
221 |
<td>[% savedreport.groupname | html %]</td> |
| 222 |
<td>[% savedreport.subgroupname | html %]</td> |
222 |
<td>[% savedreport.subgroupname | html %]</td> |
| 223 |
<td>[% savedreport.notes | html %]</td> |
223 |
<td>[% savedreport.notes | $raw %]</td> |
| 224 |
<td>[% savedreport.borrowersurname | html %][% IF ( savedreport.borrowerfirstname ) %], [% savedreport.borrowerfirstname | html %][% END %] ([% savedreport.borrowernumber | html %])</td> |
224 |
<td>[% savedreport.borrowersurname | html %][% IF ( savedreport.borrowerfirstname ) %], [% savedreport.borrowerfirstname | html %][% END %] ([% savedreport.borrowernumber | html %])</td> |
| 225 |
<td><span title="[% savedreport.date_created | html %]">[% savedreport.date_created | $KohaDates %]</span></td> |
225 |
<td><span title="[% savedreport.date_created | html %]">[% savedreport.date_created | $KohaDates %]</span></td> |
| 226 |
<td><span title="[% savedreport.last_modified | html %]">[% savedreport.last_modified | $KohaDates with_hours => 1 %]</span></td> |
226 |
<td><span title="[% savedreport.last_modified | html %]">[% savedreport.last_modified | $KohaDates with_hours => 1 %]</span></td> |
|
Lines 697-703
canned reports and writing custom SQL reports.</p>
Link Here
|
| 697 |
[% IF ( execute ) %] |
697 |
[% IF ( execute ) %] |
| 698 |
<h1>[% name | html %]</h1> |
698 |
<h1>[% name | html %]</h1> |
| 699 |
[% IF ( notes ) %]<p><span class="label">Notes:</span> [% notes | html %]</p>[% END %] |
699 |
[% IF ( notes ) %]<p><span class="label">Notes:</span> [% notes | $raw %]</p>[% END %] |
| 700 |
[% IF ( unlimited_total ) %]<p><span class="label">Total number of results:</span> [% unlimited_total | html %][% IF unlimited_total > limit %] ([% limit | html %] shown)[% END %].</p>[% END %] |
700 |
[% IF ( unlimited_total ) %]<p><span class="label">Total number of results:</span> [% unlimited_total | html %][% IF unlimited_total > limit %] ([% limit | html %] shown)[% END %].</p>[% END %] |
| 701 |
<div id="sql_output" style="display:none;"><span class="label">Report SQL:</span><pre>[% sql | html %]</pre></div> |
701 |
<div id="sql_output" style="display:none;"><span class="label">Report SQL:</span><pre>[% sql | html %]</pre></div> |
|
Lines 811-817
canned reports and writing custom SQL reports.</p>
Link Here
|
| 811 |
[% IF saved_results %] |
811 |
[% IF saved_results %] |
| 812 |
<h1>Saved report results</h1> |
812 |
<h1>Saved report results</h1> |
| 813 |
<h2>[% name | html %]</h2> |
813 |
<h2>[% name | html %]</h2> |
| 814 |
<p>[% notes | html %]</p> |
814 |
<p>[% notes | $raw %]</p> |
| 815 |
<table> |
815 |
<table> |
| 816 |
[% FOREACH rows IN saved_results %] |
816 |
[% FOREACH rows IN saved_results %] |
| 817 |
<tr> |
817 |
<tr> |
|
Lines 827-833
canned reports and writing custom SQL reports.</p>
Link Here
|
| 827 |
<fieldset class="rows"> |
827 |
<fieldset class="rows"> |
| 828 |
<legend>[% reportname | html %]</legend> |
828 |
<legend>[% reportname | html %]</legend> |
| 829 |
<ol> |
829 |
<ol> |
| 830 |
[% IF ( notes ) %]<li><span class="label">Notes:</span> [% notes | html %]</li>[% ELSE %][% END %] |
830 |
[% IF ( notes ) %]<li><span class="label">Notes:</span> [% notes | $raw %]</li>[% ELSE %][% END %] |
| 831 |
<li><textarea id="sql">[% sql | html %]</textarea></li> |
831 |
<li><textarea id="sql">[% sql | html %]</textarea></li> |
| 832 |
</ol> |
832 |
</ol> |
| 833 |
</fieldset> |
833 |
</fieldset> |