From bb69f4c3843a0b13a80d17fde992575ead4c81b6 Mon Sep 17 00:00:00 2001
From: Owen Leonard <oleonard@myacpl.org>
Date: Mon, 17 Jul 2023 11:39:21 +0000
Subject: [PATCH] Bug 12732: Add basket creation date to late orders table for
 sorting

This patch modifies the late orders page so that the table of
information contains a column for basket creation date. This will allow
administrators to configure the table to sort by default on basket
creation date if they wish.

To test, apply the patch and restart services.

- Go to Acquisitions -> Late orders.
- The table of late orders should include a column labeled "Basket date"
  showing the basket creation date.
- The dates should be formatted correctly and the column should sort
  correctly.
- Go to Administration -> Table settings and navigate to the settings
  for the lateorders page.
- Try changing various settings for the table to confirm that everything
  works correctly, including setting the default sort to use the basket
  date column.

Signed-off-by: Emmi Takkinen <emmi.takkinen@koha-suomi.fi>
Signed-off-by: Emily Lamancusa <emily.lamancusa@montgomerycountymd.gov>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
---
 admin/columns_settings.yml                                  | 2 ++
 koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt | 2 ++
 2 files changed, 4 insertions(+)

diff --git a/admin/columns_settings.yml b/admin/columns_settings.yml
index c6a672e875..6befc620fc 100644
--- a/admin/columns_settings.yml
+++ b/admin/columns_settings.yml
@@ -93,6 +93,8 @@ modules:
               columnname: total_cost
             -
               columnname: basket
+            -
+              columnname: basket_date
             -
               columnname: basket_group
             -
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt
index b0b18d5821..7b1192281e 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt
@@ -81,6 +81,7 @@
             <th>Quantity</th>
             <th>Total cost</th>
             <th>Basket</th>
+            <th>Basket date</th>
             <th>Basket group</th>
             <th>Library</th>
             <th>Budget</th>
@@ -149,6 +150,7 @@
                     [% lateorder.basket.basketname | html %] ([% lateorder.basketno | html %])
                 [% END %]
             </td>
+            <td data-sort="[% lateorder.basket.creationdate | html %]">[% lateorder.basket.creationdate | $KohaDates %]</td>
             <td>
                 [% IF ( lateorder.basket.basketgroupid ) %]
                     [% IF ( CAN_user_acquisition_group_manage ) %]
-- 
2.39.5