View | Details | Raw Unified | Return to bug 20144
Collapse All | Expand All

(-)a/C4/Circulation.pm (-7 / +9 lines)
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
- 

Return to bug 20144