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