[Koha-patches] [PATCH] Bug 4501 Don't return null vendor to claims processing
Colin Campbell
colin.campbell at ptfs-europe.com
Fri May 14 18:24:13 CEST 2010
The empty vendor created by the select if any subscriptions
have no associated vendor generates a 'wrong-looking' display
and selecting it gives no options
---
C4/Serials.pm | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/C4/Serials.pm b/C4/Serials.pm
index bca9fc8..f8a9bf5 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 (planneddate < now() OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|;
+ WHERE id > 0 AND (planneddate < now() OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|;
return $dbh->selectall_arrayref($query, { Slice => {} });
}
--
1.6.6.1
More information about the Koha-patches
mailing list