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

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

Return to bug 10606