From 7f6cd22146ffe9d224a73be99936585806867303 Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Date: Wed, 10 Feb 2021 17:31:56 +0000
Subject: [PATCH] Bug 26273: (follow-up) Format dates and money correctly.

This patch adds the missing formatting for the Datetime and Amount
fields.

Test plan
1/ Apply patch and reload register page to re-display the cashups table
2/ Note that the 'Date' field now displays a nicely formatted date
without an offset.
3/ Note that the 'Amount' field now displays the number according to
your money formatting preferences (with 2 decimal places in most cases)
4/ Signoff

Signed-off-by: Sally <sally.healey@cheshiresharedservices.gov.uk>
---
 koha-tmpl/intranet-tmpl/prog/en/modules/pos/register.tt | 13 ++++++++++---
 1 file changed, 10 insertions(+), 3 deletions(-)

diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/pos/register.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/pos/register.tt
index bb607901b1..e368f65043 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/pos/register.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/pos/register.tt
@@ -321,6 +321,7 @@
     [% Asset.js("lib/jquery/plugins/rowGroup/dataTables.rowGroup.min.js") | $raw %]
     [% Asset.js("js/cashup_modal.js") | $raw %]
     [% INCLUDE 'calendar.inc' %]
+    [% INCLUDE 'js-date-format.inc' %]
     <script>
         var sales_table = $("#sales").dataTable($.extend(true, {}, dataTablesDefaults, {
             orderFixed: [ 0, 'asc'],
@@ -421,18 +422,24 @@
                 {
                     "data": "timestamp",
                     "searchable": true,
-                    "orderable": true
+                    "orderable": true,
+                    "render": function(data, type, row, meta) {
+                        return $datetime(row.timestamp);
+                    }
                 },
                 {
                     "data": "amount",
                     "searchable": true,
-                    "orderable": true
+                    "orderable": true,
+                    "render": function(data, type, row, meta) {
+                        var amt = row.amount * -1;
+                        return (amt).format_price();
+                    }
                 },
                 {
                     "data": function( row, type, val, meta ) {
                         var result = '<a class="btn btn-default btn-xs" role="button" data-toggle="modal" data-cashup="'+encodeURIComponent(row.cashup_id)+'" data-register="[% register.description | html %]" href="#cashupSummaryModal"><i class="fa fa-pencil" aria-hidden="true"></i> '+_("Summary")+'</a>\n';
                         return result;
-
                     },
                     "searchable": false,
                     "orderable": false
-- 
2.11.0