From bd7f40947aad870d52038671c32ab6ee27d5e1bc Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 21 Sep 2018 15:10:15 +0100 Subject: [PATCH] Bug 21385: Correctly count all items in basket for booksellers list --- C4/Acquisition.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 384b598e43..b64752d988 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -709,7 +709,7 @@ sub GetBasketsInfosByBookseller { WHERE booksellerid = ?}; unless ( $allbaskets ) { - $query.=" AND (closedate IS NULL OR (aqorders.quantity > aqorders.quantityreceived AND datecancellationprinted IS NULL))"; + $query.=" AND (closedate IS NULL OR (aqorders.quantity >= aqorders.quantityreceived AND datecancellationprinted IS NULL))"; } $query.=" GROUP BY aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items"; -- 2.18.0