@@ -, +, @@ view --- koha-tmpl/intranet-tmpl/prog/css/reports.css | 6 ++++++ .../prog/en/modules/reports/guided_reports_start.tt | 16 ++++++++++++++-- 2 files changed, 20 insertions(+), 2 deletions(-) --- a/koha-tmpl/intranet-tmpl/prog/css/reports.css +++ a/koha-tmpl/intranet-tmpl/prog/css/reports.css @@ -7,6 +7,12 @@ width: 80%; } +#sql_output { + border: 1px solid #ddd; + margin-bottom: .5em; + padding: .5em; +} + ins { background-color: #e6ffe6; } --- 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 @@ -719,7 +719,11 @@ canned reports and writing custom SQL reports.

[% name | html %]

[% IF ( notes ) %]

Notes: [% notes | html %]

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

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

[% END %] - + +
@@ -1054,7 +1058,7 @@ canned reports and writing custom SQL reports.

} $(document).ready(function(){ - + var showsql; hide_bar_element(); if ( $('.chart-column-conf').length == 1 ) { @@ -1321,6 +1325,14 @@ canned reports and writing custom SQL reports.

$("#sql_output").toggle(); $("#toggle_sql_hid").toggle(); $("#toggle_sql_vis").toggle(); + if( !showsql ){ + showsql = CodeMirror.fromTextArea(sql, { + lineNumbers: false, + mode: "text/x-sql", + lineWrapping: true, + readOnly: true + }); + } }); $(".toggle_chart_settings").click(function(){ --