From: Frédérick Capovilla <[email protected]>
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 3fcbac6..f2f1894 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.7.4.4
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
