@@ -, +, @@
statistics
---
.../intranet-tmpl/prog/en/modules/reports/cash_register_stats.tt | 4 +++-
reports/cash_register_stats.pl | 6 +++---
2 files changed, 6 insertions(+), 4 deletions(-)
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cash_register_stats.tt
+++ a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cash_register_stats.tt
@@ -178,7 +178,8 @@
Patron card number |
Patron name |
Transaction branch |
- Transaction date |
+ Transaction original date |
+ Transaction updated |
Transaction type |
Notes |
Amount |
@@ -194,6 +195,7 @@
[% loopresul.bfirstname %] [% loopresul.bsurname %] |
[% loopresul.branchname %] |
[% loopresul.date | $KohaDates %] |
+ [% loopresul.timestamp | $KohaDates with_hours => 1 %] |
[% IF loopresul.accounttype == "ACT" %]
All payments to the library
--- a/reports/cash_register_stats.pl
+++ a/reports/cash_register_stats.pl
@@ -61,9 +61,9 @@ my $manualinv_types = $sth_manualinv->fetchall_arrayref({});
if ($do_it) {
- $fromDate = output_pref({ dt => eval { dt_from_string($input->param("from")) } || dt_from_string,
+ $fromDate = output_pref({ dt => eval { dt_from_string(scalar $input->param("from")) } || dt_from_string,
dateformat => 'sql', dateonly => 1 }); #for sql query
- $toDate = output_pref({ dt => eval { dt_from_string($input->param("to")) } || dt_from_string,
+ $toDate = output_pref({ dt => eval { dt_from_string(scalar $input->param("to")) } || dt_from_string,
dateformat => 'sql', dateonly => 1 }); #for sql query
my $whereTType = q{};
@@ -93,7 +93,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.accounttype, al.amountoutstanding, al.note,
+ al.borrowernumber, DATE(al.date) as date, al.timestamp, al.accounttype, al.amountoutstanding, al.note,
bi.title, bi.biblionumber, i.barcode, i.itype
FROM accountlines al
LEFT JOIN borrowers bo ON (al.borrowernumber = bo.borrowernumber)
--
|