From b7a97dd7615b85c595a17e99db6f8d881d8bab27 Mon Sep 17 00:00:00 2001 From: David Bourgault Date: Mon, 25 Sep 2017 15:30:50 -0400 Subject: [PATCH] Bug 12502 - Add ordernumber and ISBN to late order Adds ordernumber as 2nd column and ISBN as last Followed test plan and patch worked as described. Also ran QA test tools and all modified files passed Signed-off-by: Alex Buckley --- C4/Acquisition.pm | 3 ++- koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt | 10 ++++++++-- 2 files changed, 10 insertions(+), 3 deletions(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index e1a71c6..c854c1a 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -2137,7 +2137,7 @@ sub GetLateOrders { my @query_params = (); my $select = " SELECT aqbasket.basketno, - aqorders.ordernumber, + aqorders.ordernumber AS ordernumber, DATE(aqbasket.closedate) AS orderdate, aqbasket.basketname AS basketname, aqbasket.basketgroupid AS basketgroupid, @@ -2155,6 +2155,7 @@ sub GetLateOrders { biblio.author, biblio.title, biblioitems.publishercode AS publisher, biblioitems.publicationyear, + biblioitems.isbn AS isbn, ADDDATE(aqbasket.closedate, INTERVAL aqbooksellers.deliverytime DAY) AS estimateddeliverydate, "; my $from = " 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 b6d139e..d53ca20 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt @@ -56,6 +56,7 @@ [% ELSE %] [% END %] + Order No. Order date Estimated delivery date Vendor @@ -69,6 +70,7 @@ Claimed date Internal note Vendor note + ISBN @@ -78,6 +80,9 @@ + [% lateorder.ordernumber %] + + [% lateorder.orderdate | $KohaDates %] ([% lateorder.latesince %] days) @@ -135,14 +140,15 @@ + [% lateorder.isbn %] [% END %] - Total + Total [% total %] -   +   -- 2.7.4