[Koha-patches] [PATCH 2/3] bug 4429: do not include items due today in overdue count

Galen Charlton gmcharlt at gmail.com
Sat May 1 18:48:48 CEST 2010


Use curdate() instead of now() in GetMemberIssuesAndFines.

Signed-off-by: Galen Charlton <gmcharlt at gmail.com>
---
 C4/Members.pm |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/C4/Members.pm b/C4/Members.pm
index 848fdd1..19cc9fa 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -678,7 +678,7 @@ sub GetMemberIssuesAndFines {
     $sth = $dbh->prepare(
         "SELECT COUNT(*) FROM issues 
          WHERE borrowernumber = ? 
-         AND date_due < now()"
+         AND date_due < curdate()"
     );
     $sth->execute($borrowernumber);
     my $overdue_count = $sth->fetchrow_arrayref->[0];
-- 
1.7.0




More information about the Koha-patches mailing list