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

(-)a/misc/cronjobs/overdue_notices.pl (-4 / +3 lines)
Lines 388-394 foreach my $branchcode (@branches) { Link Here
388
388
389
    $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address;
389
    $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address;
390
390
391
    my $sth2 = $dbh->prepare( <<'END_SQL' );
391
    my $sth2 = $dbh->prepare( <<"END_SQL" );
392
SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue
392
SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue
393
  FROM issues,items,biblio, biblioitems
393
  FROM issues,items,biblio, biblioitems
394
  WHERE items.itemnumber=issues.itemnumber
394
  WHERE items.itemnumber=issues.itemnumber
Lines 455-464 END_SQL Link Here
455
            }
455
            }
456
            $borrower_sql .= '  AND categories.overduenoticerequired=1 ';
456
            $borrower_sql .= '  AND categories.overduenoticerequired=1 ';
457
            if($triggered) {
457
            if($triggered) {
458
                $borrower_sql .= ' AND TO_DAYS($date)-TO_DAYS(date_due) = ?';
458
                $borrower_sql .= " AND TO_DAYS($date)-TO_DAYS(date_due) = ?";
459
                push @borrower_parameters, $mindays;
459
                push @borrower_parameters, $mindays;
460
            } else {
460
            } else {
461
                $borrower_sql .= ' AND TO_DAYS($date)-TO_DAYS(date_due) BETWEEN ? and ? ' ;
461
                $borrower_sql .= " AND TO_DAYS($date)-TO_DAYS(date_due) BETWEEN ? and ? " ;
462
                push @borrower_parameters, $mindays, $maxdays;
462
                push @borrower_parameters, $mindays, $maxdays;
463
            }
463
            }
464
464
465
- 

Return to bug 8607