|
Lines 575-588
AND items.itemlost = 0
Link Here
|
| 575 |
AND TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0 |
575 |
AND TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0 |
| 576 |
END_SQL |
576 |
END_SQL |
| 577 |
my @borrower_parameters; |
577 |
my @borrower_parameters; |
| 578 |
if ($branchcode) { |
578 |
|
| 579 |
if ($owning_library) { |
579 |
if ($owning_library) { |
| 580 |
$borrower_sql .= ' AND items.homebranch=? '; |
580 |
$borrower_sql .= ' AND items.homebranch=? '; |
| 581 |
} else { |
581 |
} else { |
| 582 |
$borrower_sql .= ' AND issues.branchcode=? '; |
582 |
$borrower_sql .= ' AND issues.branchcode=? '; |
| 583 |
} |
|
|
| 584 |
push @borrower_parameters, $branchcode; |
| 585 |
} |
583 |
} |
|
|
584 |
push @borrower_parameters, $branchcode; |
| 585 |
|
| 586 |
if ( $overdue_rules->{categorycode} ) { |
586 |
if ( $overdue_rules->{categorycode} ) { |
| 587 |
$borrower_sql .= ' AND borrowers.categorycode=? '; |
587 |
$borrower_sql .= ' AND borrowers.categorycode=? '; |
| 588 |
push @borrower_parameters, $overdue_rules->{categorycode}; |
588 |
push @borrower_parameters, $overdue_rules->{categorycode}; |
| 589 |
- |
|
|