View | Details | Raw Unified | Return to bug 18283
Collapse All | Expand All

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/reports-toolbar.inc (+4 lines)
Lines 55-60 Link Here
55
                    <li><a id="ods" href="/cgi-bin/koha/reports/guided_reports.pl?reports=1&phase=Export&amp;format=ods&amp;sql=[% sql |uri %]&amp;reportname=[% name |uri %]">Open Document Spreadsheet</a></li>
55
                    <li><a id="ods" href="/cgi-bin/koha/reports/guided_reports.pl?reports=1&phase=Export&amp;format=ods&amp;sql=[% sql |uri %]&amp;reportname=[% name |uri %]">Open Document Spreadsheet</a></li>
56
                </ul>
56
                </ul>
57
            </div>
57
            </div>
58
            <div class="btn-group">
59
                <a class="btn btn-default btn-sm toggle_sql" id="toggle_sql_hid" href="#"><i class="fa fa-eye"></i> Show sql code</a>
60
                <a class="btn btn-default btn-sm toggle_sql" id="toggle_sql_vis" href="#" style="display:none;"><i class="fa fa-eye-slash"></i> Hide sql code</a>
61
            </div>
58
        [% END %]
62
        [% END %]
59
63
60
    [% END %]
64
    [% END %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt (-4 / +10 lines)
Lines 172-177 $("#delColumn").on("click",function(){ Link Here
172
    });
172
    });
173
[% END %]
173
[% END %]
174
174
175
    $(".toggle_sql").click(function(){
176
        $("#sql_output").toggle();
177
        $("#toggle_sql_hid").toggle();
178
        $("#toggle_sql_vis").toggle();
179
    });
180
175
    $("#table_reports").delegate(".confirmdelete", 'click', function(){
181
    $("#table_reports").delegate(".confirmdelete", 'click', function(){
176
        $(this).parents('tr').attr("class","warn");
182
        $(this).parents('tr').attr("class","warn");
177
        if(confirm(_("Are you sure you want to delete this saved report?"))){
183
        if(confirm(_("Are you sure you want to delete this saved report?"))){
Lines 822-830 canned reports and writing custom SQL reports.</p> Link Here
822
828
823
[% IF ( execute ) %]
829
[% IF ( execute ) %]
824
<h1>[% name %]</h1>
830
<h1>[% name %]</h1>
825
[% IF ( notes ) %]<p>[% notes %]</p>[% END %]
831
[% IF ( notes ) %]<p><span class="label">Notes:</span> [% notes %]</p>[% END %]
826
[% IF ( unlimited_total ) %]<p>Total number of rows matching the (unlimited) query is [% unlimited_total %].</p>[% END %]
832
[% IF ( unlimited_total ) %]<p><span class="label">Total number of results:</span> [% unlimited_total %][% IF unlimited_total > limit %] ([% limit %] shown)[% END %].</p>[% END %]
827
<pre id="sql_output">[% sql |html %]</pre>
833
<div id="sql_output" style="display:none;"><span class="label">Report SQL:</span><pre>[% sql |html %]</pre></div>
834
</br>
828
835
829
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get" id="limitselect">
836
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get" id="limitselect">
830
    <input type="hidden" name="phase" value="Run this report"/>
837
    <input type="hidden" name="phase" value="Run this report"/>
831
- 

Return to bug 18283