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 |
- |
|
|