From cec0bc9ca26dcfe09873b3b8fda603907ed237fd 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 --- 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 7667e2e..991584b 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.7.4