From 5ca4bda5888879b467a2f25ac3ec74e3daee46fe Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Tue, 30 Mar 2021 22:29:52 +0000 Subject: [PATCH] Bug 28061: Add timestamp to date column in cash_register_stats.tt To test: -Have some configuared cash registers. -Do some transactions -Go to the reports module > Statistic wizards > Cash register -Generate the table and look at the 'Transaction date' column, no timestamp -Apply patch and look again -You should see the timestamp --- koha-tmpl/intranet-tmpl/prog/en/modules/reports/cash_register_stats.tt | 2 +- reports/cash_register_stats.pl | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cash_register_stats.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cash_register_stats.tt index fa6c521503..b4c27da1f2 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cash_register_stats.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cash_register_stats.tt @@ -157,7 +157,7 @@ [% loopresul.cardnumber | html %] [% loopresul.bfirstname | html %] [% loopresul.bsurname | html %] [% loopresul.branchname | html %] - [% loopresul.date | $KohaDates %] + [% loopresul.timestamp | $KohaDates with_hours => 1 %] [% IF loopresul.credit_type == "ACT" %] All payments to the library diff --git a/reports/cash_register_stats.pl b/reports/cash_register_stats.pl index e0a01f4636..b31c0a82c7 100755 --- a/reports/cash_register_stats.pl +++ b/reports/cash_register_stats.pl @@ -106,7 +106,7 @@ if ($do_it) { SELECT round(amount,2) AS amount, description, bo.surname AS bsurname, bo.firstname AS bfirstname, m.surname AS msurname, m.firstname AS mfirstname, bo.cardnumber, br.branchname, bo.borrowernumber, - al.borrowernumber, DATE(al.date) as date, al.credit_type_code, al.debit_type_code, al.amountoutstanding, al.note, + al.borrowernumber, DATE(al.date) as date, al.timestamp, al.credit_type_code, al.debit_type_code, al.amountoutstanding, al.note, bi.title, bi.biblionumber, i.barcode, i.itype FROM accountlines al LEFT JOIN borrowers bo ON (al.borrowernumber = bo.borrowernumber) -- 2.11.0