From 4d80cc0ec729d40bf8f89242eb2449df763e4d93 Mon Sep 17 00:00:00 2001 From: Mathieu Saby Date: Wed, 18 Dec 2013 22:09:50 +0100 Subject: [PATCH] Bug 11027: Add a column for basketgroups in late orders table and improve other columns This patch makes 4 changes in late orders page : - adding a new column for basketgroup, displaying the name and number of the basketgroup - displaying the name of the basket as well as its number, with a hyperlink to this basket - displaying fund in a separate column to make sorting easier, and renaming it from "budget" to "fund" (the confusion can be found elsewhere in Koha...) - displaying branch in a separate column to make sorting easier (this column could be improved later, by getting branch from basketgroup if there is one) For that, in Aquisition.pm, I made some changes to GetLateOrders: - 3 new columns in SELECT - 1 new join To test : 1. Display the list of late orders of your instance. 2. Check you have 3 new columns for basketgroups, fund and branch 3. In basketgroup column you should have "name of basket group (number)" 4. In basket column you should have "name of basket (number)" 5. Check the links for basketgroups. They should send you to the page displaying information for each basketgroup (without possibiliy of editing them if they are closed) Signed-off-by: Mark Tompsett Signed-off-by: Katrin Fischer Patches pass QA script and all tests. Works as described. Also checked sorting and orders which are not in a basketgroup display correctly. Signed-off-by: Galen Charlton --- C4/Acquisition.pm | 4 ++++ .../prog/en/modules/acqui/lateorders.tt | 19 ++++++++++++------- 2 files changed, 16 insertions(+), 7 deletions(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 170829cb43..4b69825a9f 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -2096,6 +2096,9 @@ sub GetLateOrders { SELECT aqbasket.basketno, aqorders.ordernumber, DATE(aqbasket.closedate) AS orderdate, + aqbasket.basketname AS basketname, + aqbasket.basketgroupid AS basketgroupid, + aqbasketgroups.name AS basketgroupname, aqorders.rrp AS unitpricesupplier, aqorders.ecost AS unitpricelib, aqorders.claims_count AS claims_count, @@ -2116,6 +2119,7 @@ sub GetLateOrders { LEFT JOIN aqbudgets ON aqorders.budget_id = aqbudgets.budget_id, aqbasket LEFT JOIN borrowers ON aqbasket.authorisedby = borrowers.borrowernumber LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id + LEFT JOIN aqbasketgroups ON aqbasket.basketgroupid = aqbasketgroups.id WHERE aqorders.basketno = aqbasket.basketno AND ( datereceived = '' OR datereceived IS NULL 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 c76cf2d709..a0369458b2 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt @@ -117,6 +117,9 @@ $(document).ready(function() { Information Total cost Basket + Basket group + Branch + Fund Claims count Claimed date @@ -154,14 +157,16 @@ $(document).ready(function() { [% lateorder.unitpricesupplier %]x[% lateorder.quantity %] = [% lateorder.subtotal %] -

[% lateorder.budget %]

-

- [% lateorder.basketno %] - -

-

[% lateorder.branch %]

+ [% lateorder.basketname %] ([% lateorder.basketno %]) + + + [% lateorder.basketgroupname %] ([% lateorder.basketgroupid %]) + + [% lateorder.branch %] + + [% lateorder.budget %] [% lateorder.claims_count %] [% lateorder.claimed_date %] @@ -172,7 +177,7 @@ $(document).ready(function() { Total [% total %] -   +   -- 2.39.5