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

(-)a/C4/Circulation.pm (-3 / +2 lines)
Lines 2419-2426 SELECT issues.*, items.itype as itemtype, items.homebranch, TO_DAYS( date_due )- Link Here
2419
FROM issues 
2419
FROM issues 
2420
LEFT JOIN items USING (itemnumber)
2420
LEFT JOIN items USING (itemnumber)
2421
LEFT OUTER JOIN branches USING (branchcode)
2421
LEFT OUTER JOIN branches USING (branchcode)
2422
WhERE returndate is NULL
2422
WHERE returndate is NULL
2423
AND ( TO_DAYS( NOW() )-TO_DAYS( date_due ) ) < ?
2423
HAVING days_until_due > 0 AND days_until_due < ?
2424
END_SQL
2424
END_SQL
2425
2425
2426
    my @bind_parameters = ( $params->{'days_in_advance'} );
2426
    my @bind_parameters = ( $params->{'days_in_advance'} );
2427
- 

Return to bug 9362