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 |
- |
|
|