Lines 2604-2615
sub GetUpcomingDueIssues {
Link Here
|
2604 |
my $dbh = C4::Context->dbh; |
2604 |
my $dbh = C4::Context->dbh; |
2605 |
|
2605 |
|
2606 |
my $statement = <<END_SQL; |
2606 |
my $statement = <<END_SQL; |
2607 |
SELECT issues.*, items.itype as itemtype, items.homebranch, TO_DAYS( date_due )-TO_DAYS( NOW() ) as days_until_due, branches.branchemail |
2607 |
SELECT issues.*, items.itype as itemtype, items.homebranch, DATE( date_due )-DATE( NOW() ) as days_until_due, branches.branchemail |
2608 |
FROM issues |
2608 |
FROM issues |
2609 |
LEFT JOIN items USING (itemnumber) |
2609 |
LEFT JOIN items USING (itemnumber) |
2610 |
LEFT OUTER JOIN branches USING (branchcode) |
2610 |
LEFT OUTER JOIN branches USING (branchcode) |
2611 |
WHERE returndate is NULL |
2611 |
WHERE returndate is NULL |
2612 |
HAVING days_until_due >= 0 AND days_until_due <= ? |
2612 |
AND (DATE( date_due )-DATE( NOW() )) >= 0 |
|
|
2613 |
AND (DATE( date_due )-DATE( NOW() )) <= ? |
2613 |
END_SQL |
2614 |
END_SQL |
2614 |
|
2615 |
|
2615 |
my @bind_parameters = ( $params->{'days_in_advance'} ); |
2616 |
my @bind_parameters = ( $params->{'days_in_advance'} ); |
2616 |
- |
|
|