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

(-)a/C4/Circulation.pm (-3 / +3 lines)
Lines 2604-2615 sub GetUpcomingDueIssues { Link Here
2604
    my $dbh = C4::Context->dbh;
2604
    my $dbh = C4::Context->dbh;
2605
2605
2606
    my $statement = <<END_SQL;
2606
    my $statement = <<END_SQL;
2607
SELECT issues.*, items.itype as itemtype, items.homebranch, TO_DAYS( date_due )-TO_DAYS( NOW() ) as days_until_due, branches.branchemail
2607
SELECT issues.*, items.itype as itemtype, items.homebranch, DATE( date_due )-DATE( NOW() ) as days_until_due, branches.branchemail
2608
FROM issues 
2608
FROM issues 
2609
LEFT JOIN items USING (itemnumber)
2609
LEFT JOIN items USING (itemnumber)
2610
LEFT OUTER JOIN branches USING (branchcode)
2610
LEFT OUTER JOIN branches USING (branchcode)
2611
WHERE returndate is NULL
2611
WHERE returndate is NULL
2612
HAVING days_until_due >= 0 AND days_until_due <= ?
2612
AND (DATE( date_due )-DATE( NOW() )) >= 0
2613
AND (DATE( date_due )-DATE( NOW() )) <= ?
2613
END_SQL
2614
END_SQL
2614
2615
2615
    my @bind_parameters = ( $params->{'days_in_advance'} );
2616
    my @bind_parameters = ( $params->{'days_in_advance'} );
2616
- 

Return to bug 10606