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

(-)a/misc/cronjobs/overdue_notices.pl (-8 / +7 lines)
Lines 575-588 AND items.itemlost = 0 Link Here
575
AND    TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0
575
AND    TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0
576
END_SQL
576
END_SQL
577
            my @borrower_parameters;
577
            my @borrower_parameters;
578
            if ($branchcode) {
578
579
                if ($owning_library) {
579
            if ($owning_library) {
580
                    $borrower_sql .= ' AND items.homebranch=? ';
580
                $borrower_sql .= ' AND items.homebranch=? ';
581
                } else {
581
            } else {
582
                    $borrower_sql .= ' AND issues.branchcode=? ';
582
                $borrower_sql .= ' AND issues.branchcode=? ';
583
                }
584
                push @borrower_parameters, $branchcode;
585
            }
583
            }
584
            push @borrower_parameters, $branchcode;
585
586
            if ( $overdue_rules->{categorycode} ) {
586
            if ( $overdue_rules->{categorycode} ) {
587
                $borrower_sql .= ' AND borrowers.categorycode=? ';
587
                $borrower_sql .= ' AND borrowers.categorycode=? ';
588
                push @borrower_parameters, $overdue_rules->{categorycode};
588
                push @borrower_parameters, $overdue_rules->{categorycode};
589
- 

Return to bug 41315