Lines 2421-2432
sub GetUpcomingDueIssues {
Link Here
|
2421 |
my $dbh = C4::Context->dbh; |
2421 |
my $dbh = C4::Context->dbh; |
2422 |
|
2422 |
|
2423 |
my $statement = <<END_SQL; |
2423 |
my $statement = <<END_SQL; |
2424 |
SELECT issues.*, items.itype as itemtype, items.homebranch, TO_DAYS( date_due )-TO_DAYS( NOW() ) as days_until_due, branches.branchemail |
2424 |
SELECT issues.*, items.itype as itemtype, items.homebranch, DATE( date_due )-DATE( NOW() ) as days_until_due, branches.branchemail |
2425 |
FROM issues |
2425 |
FROM issues |
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 (DATE( date_due )-DATE( NOW() )) > 0 |
|
|
2430 |
AND (DATE( date_due )-DATE( 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 |
- |
|
|