[Koha-bugs] [Bug 4036] Two conditions missing from circ template messages: USERBLOCKEDOVERDUE and USERBLOCKEDREMAINING

[bugzilla-daemon at kohaorg.ec2.liblime.com]

http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4036


Owen Leonard <oleonard at myacpl.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |henridamien at koha-fr.org




--- Comment #1 from Owen Leonard <oleonard at myacpl.org>  2010-01-11 16:19:46 ---
In the relevant portion of Members.pm (line 572):

    my $sth = $dbh->prepare(
        "SELECT COUNT(*) as latedocs
         FROM issues
         WHERE borrowernumber = ?
         AND date_due < now()"
    );

If I try a similar query:

mysql> select date_due,returndate,issuedate from issues WHERE borrowernumber =
51 and date_due < now();
+------------+------------+------------+
| date_due   | returndate | issuedate  |
+------------+------------+------------+
| 2010-01-11 | NULL       | 2009-12-28 | 
| 2010-01-11 | NULL       | 2009-12-28 | 
| 2010-01-11 | NULL       | 2009-12-28 | 
| 2010-01-11 | NULL       | 2009-12-28 | 
| 2010-01-11 | NULL       | 2009-12-28 | 
| 2010-01-11 | NULL       | 2009-12-28 | 
+------------+------------+------------+

Is it correct that IsMemberBlocked() should return -1 if my checkouts are due
today?


-- 
Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.