|
Lines 1237-1246
sub GetOverduesForBranch {
Link Here
|
| 1237 |
my $i = 0; |
1237 |
my $i = 0; |
| 1238 |
my $sth; |
1238 |
my $sth; |
| 1239 |
if ($location) { |
1239 |
if ($location) { |
| 1240 |
$sth = $dbh->prepare("$select AND items.location = ? ORDER BY borrowers.surname, borrowers.firstname"); |
1240 |
$sth = $dbh->prepare("$select AND items.location = ? GROUP BY borrowers.borrowernumber ORDER BY borrowers.surname, borrowers.firstname"); |
| 1241 |
$sth->execute($branch, $location); |
1241 |
$sth->execute($branch, $location); |
| 1242 |
} else { |
1242 |
} else { |
| 1243 |
$sth = $dbh->prepare("$select ORDER BY borrowers.surname, borrowers.firstname"); |
1243 |
$sth = $dbh->prepare("$select GROUP BY borrowers.borrowernumber ORDER BY borrowers.surname, borrowers.firstname"); |
| 1244 |
$sth->execute($branch); |
1244 |
$sth->execute($branch); |
| 1245 |
} |
1245 |
} |
| 1246 |
while ( my $data = $sth->fetchrow_hashref ) { |
1246 |
while ( my $data = $sth->fetchrow_hashref ) { |
| 1247 |
- |
|
|