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

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

Return to bug 8112