View | Details | Raw Unified | Return to bug 10606
Collapse All | Expand All

(-)a/C4/Circulation.pm (-3 / +3 lines)
Lines 2421-2432 sub GetUpcomingDueIssues { Link Here
2421
    my $dbh = C4::Context->dbh;
2421
    my $dbh = C4::Context->dbh;
2422
2422
2423
    my $statement = <<END_SQL;
2423
    my $statement = <<END_SQL;
2424
SELECT issues.*, items.itype as itemtype, items.homebranch, TO_DAYS( date_due )-TO_DAYS( NOW() ) as days_until_due, branches.branchemail
2424
SELECT issues.*, items.itype as itemtype, items.homebranch, DATE( date_due )-DATE( NOW() ) as days_until_due, branches.branchemail
2425
FROM issues 
2425
FROM issues 
2426
LEFT JOIN items USING (itemnumber)
2426
LEFT JOIN items USING (itemnumber)
2427
LEFT OUTER JOIN branches USING (branchcode)
2427
LEFT OUTER JOIN branches USING (branchcode)
2428
WHERE returndate is NULL
2428
WHERE returndate is NULL
2429
HAVING days_until_due > 0 AND days_until_due < ?
2429
AND (DATE( date_due )-DATE( NOW() )) > 0
2430
AND (DATE( date_due )-DATE( NOW() )) < ?
2430
END_SQL
2431
END_SQL
2431
2432
2432
    my @bind_parameters = ( $params->{'days_in_advance'} );
2433
    my @bind_parameters = ( $params->{'days_in_advance'} );
2433
- 

Return to bug 10606