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

(-)a/misc/cronjobs/overdue_notices.pl (-2 / +2 lines)
Lines 465-470 SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, branchname Link Here
465
    AND b.branchcode = items.homebranch
465
    AND b.branchcode = items.homebranch
466
    AND biblio.biblionumber   = biblioitems.biblionumber
466
    AND biblio.biblionumber   = biblioitems.biblionumber
467
    AND issues.borrowernumber = ?
467
    AND issues.borrowernumber = ?
468
    AND issues.branchcode = ?
468
    AND TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0
469
    AND TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0
469
END_SQL
470
END_SQL
470
471
Lines 613-619 END_SQL Link Here
613
                    ) unless $test_mode;
614
                    ) unless $test_mode;
614
                    $verbose and warn "debarring $borr\n";
615
                    $verbose and warn "debarring $borr\n";
615
                }
616
                }
616
                my @params = ($borrowernumber);
617
                my @params = ($borrowernumber,$branchcode);
617
                $verbose and warn "STH2 PARAMS: borrowernumber = $borrowernumber";
618
                $verbose and warn "STH2 PARAMS: borrowernumber = $borrowernumber";
618
619
619
                $sth2->execute(@params);
620
                $sth2->execute(@params);
620
- 

Return to bug 17470