Lines 287-304
canned reports and writing custom SQL reports.</p>
Link Here
|
287 |
<th>Public</th> |
287 |
<th>Public</th> |
288 |
[% IF (usecache) %] <th>Cache expiry (seconds)</th> [% END %] |
288 |
[% IF (usecache) %] <th>Cache expiry (seconds)</th> [% END %] |
289 |
<th>Saved results</th> |
289 |
<th>Saved results</th> |
290 |
<th>Saved SQL</th> |
|
|
291 |
<th> </th> |
290 |
<th> </th> |
292 |
[% IF ( CAN_user_reports_create_reports ) %] |
|
|
293 |
<th> </th> |
294 |
[% END %] |
295 |
</tr> |
291 |
</tr> |
296 |
</thead> |
292 |
</thead> |
297 |
<tbody> |
293 |
<tbody> |
298 |
[% FOREACH savedreport IN savedreports %] |
294 |
[% FOREACH savedreport IN savedreports %] |
299 |
[% UNLESS ( loop.odd ) %]<tr class="odd">[% ELSE %]<tr>[% END %] |
295 |
[% UNLESS ( loop.odd ) %]<tr class="odd">[% ELSE %]<tr>[% END %] |
300 |
<td>[% savedreport.id %]</td> |
296 |
<td>[% savedreport.id %]</td> |
301 |
<td>[% savedreport.report_name %]</td> |
297 |
<td> |
|
|
298 |
[% IF ( savedreport.report_name ) %] |
299 |
[% savedreport.report_name %] |
300 |
[% ELSE %] |
301 |
[ no name ] |
302 |
[% END %] |
303 |
</td> |
302 |
<td>[% savedreport.type %]</td> |
304 |
<td>[% savedreport.type %]</td> |
303 |
<td>[% savedreport.groupname %]</td> |
305 |
<td>[% savedreport.groupname %]</td> |
304 |
<td>[% savedreport.subgroupname %]</td> |
306 |
<td>[% savedreport.subgroupname %]</td> |
Lines 314-332
canned reports and writing custom SQL reports.</p>
Link Here
|
314 |
<td>[% IF ( savedreport.date_run ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=retrieve%20results&id=[% savedreport.id %]">[% savedreport.date_run %]</a>[% END %] |
316 |
<td>[% IF ( savedreport.date_run ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=retrieve%20results&id=[% savedreport.id %]">[% savedreport.date_run %]</a>[% END %] |
315 |
</td> |
317 |
</td> |
316 |
<td> |
318 |
<td> |
317 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Show%20SQL">Show</a> |
319 |
<div class="dropdown"> |
318 |
[% IF ( CAN_user_reports_create_reports ) %] |
320 |
<a class="btn btn-mini dropdown-toggle" id="reportactions[% savedreport.id %]" role="button" data-toggle="dropdown" href="#"> |
319 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Edit%20SQL">Edit</a> |
321 |
Actions <b class="caret"></b> |
320 |
<a title="Duplicate this saved report" href="/cgi-bin/koha/reports/guided_reports.pl?phase=Create report from SQL&sql=[% savedreport.savedsql |uri %]&reportname=[% savedreport.report_name |uri %]&notes=[% savedreport.notes |uri %]">Duplicate</a> |
322 |
</a> |
321 |
[% END %] |
323 |
<ul class="dropdown-menu pull-right" role="menu" aria-labelledby="reportactions[% savedreport.id %]"> |
322 |
</td> |
324 |
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Show%20SQL"><i class="icon-search"></i> Show</a></li> |
323 |
<td> |
325 |
[% IF ( CAN_user_reports_create_reports ) %] |
324 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Run%20this%20report">Run</a> |
326 |
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Edit%20SQL"><i class="icon-pencil"></i> Edit</a></li> |
325 |
<a href="/cgi-bin/koha/tools/scheduler.pl?id=[% savedreport.id %]">Schedule</a> |
327 |
<li><a title="Duplicate this saved report" href="/cgi-bin/koha/reports/guided_reports.pl?phase=Create report from SQL&sql=[% savedreport.savedsql |uri %]&reportname=[% savedreport.report_name |uri %]&notes=[% savedreport.notes |uri %]"><i class="icon-copy"></i> Duplicate</a></li> |
|
|
328 |
[% END %] |
329 |
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Run%20this%20report"><i class="icon-play"></i> Run</a></li> |
330 |
<li><a href="/cgi-bin/koha/tools/scheduler.pl?id=[% savedreport.id %]"><i class="icon-time"></i> Schedule</a></li> |
331 |
[% IF ( CAN_user_reports_create_reports ) %] |
332 |
<li><a class="confirmdelete" title="Delete this saved report" href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Delete%20Saved"><i class="icon-remove"></i> Delete</a></li> |
333 |
[% END %] |
334 |
</ul> |
335 |
</div> |
326 |
</td> |
336 |
</td> |
327 |
[% IF ( CAN_user_reports_create_reports ) %] |
|
|
328 |
<td><a class="confirmdelete" title="Delete this saved report" href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Delete%20Saved">Delete</a></td> |
329 |
[% END %] |
330 |
</tr> |
337 |
</tr> |
331 |
[% END %] |
338 |
[% END %] |
332 |
</tbody> |
339 |
</tbody> |