From 632b1193bba1ac8bdb19c0d4c2f5b8e048faff21 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 ea13caf..62cb1ba 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -2131,7 +2131,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, @@ -2149,6 +2149,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 d838834..a545c32 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt @@ -139,6 +139,7 @@ $(document).ready(function() { [% ELSE %] [% END %] + Order No. Order date Estimated delivery date Vendor @@ -152,6 +153,7 @@ $(document).ready(function() { Claimed date Internal note Vendor note + ISBN @@ -161,6 +163,9 @@ $(document).ready(function() { + [% lateorder.ordernumber %] + + [% lateorder.orderdate | $KohaDates %] ([% lateorder.latesince %] days) @@ -218,14 +223,15 @@ $(document).ready(function() { + [% lateorder.isbn %] [% END %] - Total + Total [% total %] -   +   -- 2.1.4