From 270d5ada8cac5e01597b59ce3bc8df0cf0f36bad Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 1 Mar 2012 09:39:01 +0100 Subject: [PATCH 1/1] Bug 7166: Followup: Adds edit order notes when the basket is closed FIX field aqorders.notes --- C4/Acquisition.pm | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 0a96a02..15a68ea 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -714,8 +714,9 @@ sub GetPendingOrders { my $dbh = C4::Context->dbh; my $strsth = " SELECT ".($grouped?"count(*),":"")."aqbasket.basketno, - surname,firstname,aqorders.*,biblio.*,biblioitems.isbn, - aqbasket.closedate, aqbasket.creationdate, aqbasket.basketname + surname,firstname,biblio.*,biblioitems.isbn, + aqbasket.closedate, aqbasket.creationdate, aqbasket.basketname, + aqorders.* FROM aqorders LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno LEFT JOIN borrowers ON aqbasket.authorisedby=borrowers.borrowernumber -- 1.7.7.3