Lines 2553-2564
sub GetUpcomingDueIssues {
Link Here
|
2553 |
my $dbh = C4::Context->dbh; |
2553 |
my $dbh = C4::Context->dbh; |
2554 |
|
2554 |
|
2555 |
my $statement = <<END_SQL; |
2555 |
my $statement = <<END_SQL; |
2556 |
SELECT issues.*, items.itype as itemtype, items.homebranch, TO_DAYS( date_due )-TO_DAYS( NOW() ) as days_until_due, branches.branchemail |
2556 |
SELECT * |
2557 |
FROM issues |
2557 |
FROM ( |
2558 |
LEFT JOIN items USING (itemnumber) |
2558 |
SELECT issues.*, items.itype as itemtype, items.homebranch, TO_DAYS( date_due )-TO_DAYS( NOW() ) as days_until_due, branches.branchemail |
2559 |
LEFT OUTER JOIN branches USING (branchcode) |
2559 |
FROM issues |
2560 |
WHERE returndate is NULL |
2560 |
LEFT JOIN items USING (itemnumber) |
2561 |
HAVING days_until_due >= 0 AND days_until_due <= ? |
2561 |
LEFT OUTER JOIN branches USING (branchcode) |
|
|
2562 |
WHERE returndate is NULL |
2563 |
) tmp |
2564 |
WHERE days_until_due >= 0 AND days_until_due <= ? |
2562 |
END_SQL |
2565 |
END_SQL |
2563 |
|
2566 |
|
2564 |
my @bind_parameters = ( $params->{'days_in_advance'} ); |
2567 |
my @bind_parameters = ( $params->{'days_in_advance'} ); |
2565 |
- |
|
|