From e4c4dcc79ca2f4072167f1dda537fb813ecc13ca Mon Sep 17 00:00:00 2001 From: Lyon3 Team Date: Fri, 15 Mar 2013 17:00:06 +0100 Subject: [PATCH] Bug 9824 - Hide basket with no expected items in basqket list by bookseller --- C4/Acquisition.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 4a9eae6..73ec1d6 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -595,7 +595,7 @@ sub GetBasketsInfosByBookseller { ) AS expected_items FROM aqbasket LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno - WHERE booksellerid = ? + WHERE booksellerid = ? and quantity>quantityreceived and aqorders.datecancellationprinted IS NULL GROUP BY aqbasket.basketno }; my $sth = $dbh->prepare($query); -- 1.7.2.5