Lines 2426-2432
FROM issues
Link Here
|
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 (TO_DAYS( date_due )-TO_DAYS( NOW() )) > 0 |
|
|
2430 |
AND (TO_DAYS( date_due )-TO_DAYS( 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 |
- |
|
|