|
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 |
- |
|
|