@@ -, +, @@ code and change wording -Add toggle link for SQL code -Change results count wording -Add 'Notes:' label report notes --- .../intranet-tmpl/prog/en/includes/reports-toolbar.inc | 4 ++++ .../prog/en/modules/reports/guided_reports_start.tt | 13 ++++++++++--- 2 files changed, 14 insertions(+), 3 deletions(-) --- a/koha-tmpl/intranet-tmpl/prog/en/includes/reports-toolbar.inc +++ a/koha-tmpl/intranet-tmpl/prog/en/includes/reports-toolbar.inc @@ -55,6 +55,10 @@
  • Open Document Spreadsheet
  • +
    + Show sql code + +
    [% END %] [% END %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt @@ -172,6 +172,12 @@ $("#delColumn").on("click",function(){ }); [% END %] + $(".toggle_sql").click(function(){ + $("#sql_output").toggle(); + $("#toggle_sql_hid").toggle(); + $("#toggle_sql_vis").toggle(); + }); + $("#table_reports").delegate(".confirmdelete", 'click', function(){ $(this).parents('tr').attr("class","warn"); if(confirm(_("Are you sure you want to delete this saved report?"))){ @@ -822,9 +828,10 @@ canned reports and writing custom SQL reports.

    [% IF ( execute ) %]

    [% name %]

    -[% IF ( notes ) %]

    [% notes %]

    [% END %] -[% IF ( unlimited_total ) %]

    Total number of rows matching the (unlimited) query is [% unlimited_total %].

    [% END %] -
    [% sql |html %]
    +[% IF ( notes ) %]

    Notes: [% notes %]

    [% END %] +[% IF ( unlimited_total ) %]

    Total number of results: [% unlimited_total %][% IF unlimited_total > limit %] ([% limit %] shown)[% END %].

    [% END %] + +
    --