@@ -, +, @@ aqorders.datecancellationprinted --- acqui/ordered.pl | 3 +-- acqui/spent.pl | 3 +-- 2 files changed, 2 insertions(+), 4 deletions(-) --- a/acqui/ordered.pl +++ a/acqui/ordered.pl @@ -71,8 +71,7 @@ LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id WHERE budget_id=? AND - (datecancellationprinted IS NULL OR - datecancellationprinted='0000-00-00') AND + datecancellationprinted IS NULL AND (quantity > quantityreceived OR quantityreceived IS NULL) GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber, tleft, --- a/acqui/spent.pl +++ a/acqui/spent.pl @@ -80,8 +80,7 @@ LEFT JOIN aqbooksellers ON WHERE aqorders.basketno=aqbasket.basketno AND budget_id=? AND - (datecancellationprinted IS NULL OR - datecancellationprinted='0000-00-00') AND + datecancellationprinted IS NULL AND datereceived IS NOT NULL GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber, tleft, --