From 5fa093e3317da94cf47411f6310d7b14c1a182fd Mon Sep 17 00:00:00 2001 From: =?utf-8?q?Fr=C3=A9d=C3=A9rick=20Capovilla?= Date: Wed, 18 May 2011 11:25:03 -0400 Subject: [PATCH] Corrects GetSuppliersWithLateIssues GetSuppliersWithLateIssues returned every supplier with an order with a planneddate in the past, even if the order was received. I modified the query so it doesn't see a received order as "late". --- C4/Serials.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index bf4a2e6..0d3e614 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -96,7 +96,7 @@ sub GetSuppliersWithLateIssues { FROM subscription LEFT JOIN serial ON serial.subscriptionid=subscription.subscriptionid LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id - WHERE id > 0 AND (planneddate < now() OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|; + WHERE id > 0 AND ((planneddate < now() AND serial.STATUS =1) OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|; return $dbh->selectall_arrayref($query, { Slice => {} }); } -- 1.5.6.5