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> |