From f7dd473e8d098053d97819a553bde15910bd4d72 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Mon, 24 Sep 2018 13:33:59 +0100 Subject: [PATCH] Bug 21385: (followup) - make query consistent The expected items query wasn't consistent with other queries in this module with regards to identifying cancelled orders --- C4/Acquisition.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 439ae41e1c..5e9dcc16a5 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -700,7 +700,7 @@ sub GetBasketsInfosByBookseller { COUNT(DISTINCT aqorders.biblionumber) AS total_biblios, SUM( IF(aqorders.datereceived IS NULL - AND aqorders.datecancellationprinted IS NULL + AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00') , aqorders.quantity , 0) ) AS expected_items -- 2.18.0