|
Lines 465-470
SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, branchname
Link Here
|
| 465 |
AND b.branchcode = items.homebranch |
465 |
AND b.branchcode = items.homebranch |
| 466 |
AND biblio.biblionumber = biblioitems.biblionumber |
466 |
AND biblio.biblionumber = biblioitems.biblionumber |
| 467 |
AND issues.borrowernumber = ? |
467 |
AND issues.borrowernumber = ? |
|
|
468 |
AND issues.branchcode = ? |
| 468 |
AND TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0 |
469 |
AND TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0 |
| 469 |
END_SQL |
470 |
END_SQL |
| 470 |
|
471 |
|
|
Lines 613-619
END_SQL
Link Here
|
| 613 |
) unless $test_mode; |
614 |
) unless $test_mode; |
| 614 |
$verbose and warn "debarring $borr\n"; |
615 |
$verbose and warn "debarring $borr\n"; |
| 615 |
} |
616 |
} |
| 616 |
my @params = ($borrowernumber); |
617 |
my @params = ($borrowernumber,$branchcode); |
| 617 |
$verbose and warn "STH2 PARAMS: borrowernumber = $borrowernumber"; |
618 |
$verbose and warn "STH2 PARAMS: borrowernumber = $borrowernumber"; |
| 618 |
|
619 |
|
| 619 |
$sth2->execute(@params); |
620 |
$sth2->execute(@params); |
| 620 |
- |
|
|