|
Lines 1264-1270
sub GetOverduesForBranch {
Link Here
|
| 1264 |
$sth = $dbh->prepare("$select AND items.location = ? GROUP BY borrowers.borrowernumber ORDER BY borrowers.surname, borrowers.firstname"); |
1264 |
$sth = $dbh->prepare("$select AND items.location = ? GROUP BY borrowers.borrowernumber ORDER BY borrowers.surname, borrowers.firstname"); |
| 1265 |
$sth->execute($branch, $location); |
1265 |
$sth->execute($branch, $location); |
| 1266 |
} else { |
1266 |
} else { |
| 1267 |
$sth = $dbh->prepare("$select GROUP BY borrowers.borrowernumber ORDER BY borrowers.surname, borrowers.firstname"); |
1267 |
$sth = $dbh->prepare("$select GROUP BY borrowers.borrowernumber, items.itemnumber ORDER BY borrowers.surname, borrowers.firstname"); |
| 1268 |
$sth->execute($branch); |
1268 |
$sth->execute($branch); |
| 1269 |
} |
1269 |
} |
| 1270 |
while ( my $data = $sth->fetchrow_hashref ) { |
1270 |
while ( my $data = $sth->fetchrow_hashref ) { |
| 1271 |
- |
|
|