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

(-)a/Koha/Patrons.pm (-3 / +2 lines)
Lines 399-406 sub search_patrons_to_update_category { Link Here
399
        $query{join} = ["accountlines"];
399
        $query{join} = ["accountlines"];
400
        $query{columns} = ["borrowernumber"];
400
        $query{columns} = ["borrowernumber"];
401
        $query{group_by} = ["borrowernumber"];
401
        $query{group_by} = ["borrowernumber"];
402
        $query{having} = \['IFNULL(sum(accountlines.amountoutstanding),0) <= ?',$params->{fine_max}] if defined $params->{fine_max};
402
        $query{having} = \['COALESCE(sum(accountlines.amountoutstanding),0) <= ?',$params->{fine_max}] if defined $params->{fine_max};
403
        $query{having} = \['IFNULL(sum(accountlines.amountoutstanding),0) >= ?',$params->{fine_min}] if defined $params->{fine_min};
403
        $query{having} = \['COALESCE(sum(accountlines.amountoutstanding),0) >= ?',$params->{fine_min}] if defined $params->{fine_min};
404
    }
404
    }
405
    return $self->search($search_params,\%query);
405
    return $self->search($search_params,\%query);
406
}
406
}
407
- 

Return to bug 25683