From 1aba7a311632e3dc234e557f0727ecb0e0c8daf8 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Tue, 7 Feb 2017 15:55:30 +0000 Subject: [PATCH] Bug 14365 - SQL Reports Last Edit Date column - Show in interface Test Plan: 1) Apply these patches 2) Modify a saved sql report 3) Note the "Last modified" column is updated 4) Run the report 5) Note the "Last run" column is updated Signed-off-by: Cab Vinton Signed-off-by: Kyle M Hall Signed-off-by: Jonathan Druart --- .../intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt index ad53c08..de0f378 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt @@ -95,7 +95,7 @@ $("#delColumn").on("click",function(){ { "aTargets": [ 1, 2 ], "sType": "natural" } ], "aoColumns": [ - null,null,null,null,null,null,null,null,{ "sType": "title-string" },null,[% IF (usecache) %]null,[% END %]null,null + null,null,null,null,null,null,null,null,{ "sType": "title-string" },null,null,null,[% IF (usecache) %]null,[% END %]null,null ], 'oLanguage': { 'sZeroRecords': _("No matching reports found") @@ -329,6 +329,8 @@ canned reports and writing custom SQL reports.

Notes Author Creation date + Last modified + Last run Public [% IF (usecache) %] Cache expiry (seconds) [% END %] Saved results @@ -357,6 +359,8 @@ canned reports and writing custom SQL reports.

[% savedreport.notes %] [% savedreport.borrowersurname %][% IF ( savedreport.borrowerfirstname ) %], [% savedreport.borrowerfirstname %][% END %] ([% savedreport.borrowernumber %]) [% savedreport.date_created | $KohaDates %] + [% savedreport.last_modified | $KohaDates with_hours => 1 %] + [% savedreport.last_run | $KohaDates with_hours => 1 %] [% IF (savedreport.public) %] Yes [% ELSE %] -- 2.1.4