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

(-)a/misc/cronjobs/overdue_notices.pl (-3 / +3 lines)
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
- 

Return to bug 6119