Lines 2423-2434
sub GetUpcomingDueIssues {
Link Here
|
2423 |
my $dbh = C4::Context->dbh; |
2423 |
my $dbh = C4::Context->dbh; |
2424 |
|
2424 |
|
2425 |
my $statement = <<END_SQL; |
2425 |
my $statement = <<END_SQL; |
2426 |
SELECT issues.*, items.itype as itemtype, items.homebranch, TO_DAYS( date_due )-TO_DAYS( NOW() ) as days_until_due, branches.branchemail |
2426 |
SELECT issues.*, items.itype as itemtype, items.homebranch, DATE( date_due )-DATE( NOW() ) as days_until_due, branches.branchemail |
2427 |
FROM issues |
2427 |
FROM issues |
2428 |
LEFT JOIN items USING (itemnumber) |
2428 |
LEFT JOIN items USING (itemnumber) |
2429 |
LEFT OUTER JOIN branches USING (branchcode) |
2429 |
LEFT OUTER JOIN branches USING (branchcode) |
2430 |
WHERE returndate is NULL |
2430 |
WHERE returndate is NULL |
2431 |
HAVING days_until_due > 0 AND days_until_due < ? |
2431 |
AND (DATE( date_due )-DATE( NOW() )) > 0 |
|
|
2432 |
AND (DATE( date_due )-DATE( NOW() )) < ? |
2432 |
END_SQL |
2433 |
END_SQL |
2433 |
|
2434 |
|
2434 |
my @bind_parameters = ( $params->{'days_in_advance'} ); |
2435 |
my @bind_parameters = ( $params->{'days_in_advance'} ); |
2435 |
- |
|
|