Bugzilla – Attachment 119028 Details for
Bug 28061
Cash Register Stats table (cash_register_stats.pl) should include a timestamp
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 28061: Add timestamp to date column in cash_register_stats.tt
Bug-28061-Add-timestamp-to-date-column-in-cashregi.patch (text/plain), 2.50 KB, created by
Lucas Gass (lukeg)
on 2021-03-30 22:34:09 UTC
(
hide
)
Description:
Bug 28061: Add timestamp to date column in cash_register_stats.tt
Filename:
MIME Type:
Creator:
Lucas Gass (lukeg)
Created:
2021-03-30 22:34:09 UTC
Size:
2.50 KB
patch
obsolete
>From 5ca4bda5888879b467a2f25ac3ec74e3daee46fe Mon Sep 17 00:00:00 2001 >From: Lucas Gass <lucas@bywatersolutions.com> >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 @@ > <td><a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=[% loopresul.borrowernumber | uri %]">[% loopresul.cardnumber | html %]</a></td> > <td>[% loopresul.bfirstname | html %] [% loopresul.bsurname | html %]</td> > <td>[% loopresul.branchname | html %]</td> >- <td>[% loopresul.date | $KohaDates %]</td> >+ <td>[% loopresul.timestamp | $KohaDates with_hours => 1 %]</td> > <td> > [% IF loopresul.credit_type == "ACT" %] > <span>All payments to the library</span> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 28061
: 119028