|
Lines 1261-1270
sub GetOverduesForBranch {
Link Here
|
| 1261 |
my $i = 0; |
1261 |
my $i = 0; |
| 1262 |
my $sth; |
1262 |
my $sth; |
| 1263 |
if ($location) { |
1263 |
if ($location) { |
| 1264 |
$sth = $dbh->prepare("$select AND items.location = ? 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 ORDER BY borrowers.surname, borrowers.firstname"); |
1267 |
$sth = $dbh->prepare("$select GROUP BY borrowers.borrowernumber 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 |
- |
|
|