From bc543a65698e7f8765846cdc82570abd803b0b3a 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.
---
 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 90fb535472..0f5c9b5f94 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 2de9b35463..8a2ca36afe 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt
@@ -76,6 +76,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>
@@ -144,6 +145,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.30.2