View | Details | Raw Unified | Return to bug 8112
Collapse All | Expand All

(-)a/C4/Overdues.pm (-3 / +2 lines)
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
- 

Return to bug 8112