Lines 375-384
foreach my $branchcode (@branches) {
Link Here
|
375 |
$verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address; |
375 |
$verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address; |
376 |
|
376 |
|
377 |
my $sth2 = $dbh->prepare( <<'END_SQL' ); |
377 |
my $sth2 = $dbh->prepare( <<'END_SQL' ); |
378 |
SELECT biblio.*, items.*, issues.*, TO_DAYS(NOW())-TO_DAYS(date_due) AS days_overdue |
378 |
SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS(NOW())-TO_DAYS(date_due) AS days_overdue |
379 |
FROM issues,items,biblio |
379 |
FROM issues,items,biblio, biblioitems |
380 |
WHERE items.itemnumber=issues.itemnumber |
380 |
WHERE items.itemnumber=issues.itemnumber |
381 |
AND biblio.biblionumber = items.biblionumber |
381 |
AND biblio.biblionumber = items.biblionumber |
|
|
382 |
AND biblio.biblionumber = biblioitems.biblionumber |
382 |
AND issues.borrowernumber = ? |
383 |
AND issues.borrowernumber = ? |
383 |
AND TO_DAYS(NOW())-TO_DAYS(date_due) BETWEEN ? and ? |
384 |
AND TO_DAYS(NOW())-TO_DAYS(date_due) BETWEEN ? and ? |
384 |
END_SQL |
385 |
END_SQL |
385 |
- |
|
|