From 355cb12385a1c1922a96280517fe47c945138ab1 Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Wed, 18 Apr 2012 15:06:46 +0200 Subject: [PATCH 2/2] Bug 7162: Fix booksellers.pl display Basket infos don't take cancelled orders into account anymore. --- C4/Acquisition.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 88880f2..3fb27c0 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -489,7 +489,7 @@ sub GetBasketsInfosByBookseller { SUM(IF(aqorders.datereceived IS NULL, aqorders.quantity, 0)) AS expected_items FROM aqbasket LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno - WHERE booksellerid = ? + WHERE booksellerid = ? AND aqorders.datecancellationprinted IS NULL GROUP BY aqbasket.basketno }; my $sth = $dbh->prepare($query); -- 1.7.9.5