From 04f52dbe5c79ab3315dfc08d700d8b9082303eba Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Fri, 21 Oct 2011 10:23:30 -0400 Subject: [PATCH] Fix for Bug 7075 - Fine in days triggered for patrons with past overdues when fine in days is set to 0 Content-Type: text/plain; charset="utf-8" Changes "WHERE finedays IS NOT NULL" to "WHERE finedays > 0" in order to accomodate 0 values in issuingrules.finedays. --- C4/Members.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/C4/Members.pm b/C4/Members.pm index 56718f0..c0165c6 100644 --- a/C4/Members.pm +++ b/C4/Members.pm @@ -639,7 +639,7 @@ sub IsMemberBlocked { LEFT JOIN issuingrules ON (issuingrules.itemtype=biblioitems.itemtype) }; } $strsth.= - qq{ WHERE finedays IS NOT NULL + qq{ WHERE finedays > 0 AND date_due < returndate AND borrowernumber = ? ORDER BY blockingdate DESC, blockedcount DESC -- 1.7.3