From 91000f17f1367f78f10ab974a5e6b3781d05a2e1 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>
---
 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 270c99984b..bbcd98eead 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 aa04abec74..7b2898ed5c 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.34.1