X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/840aea131eef33512dccc13184e01affafaafb37..5cfd34f0459bf58cee93d28a2cbe7e9f2684d1ca:/SL/IS.pm diff --git a/SL/IS.pm b/SL/IS.pm index 310dcbb59..6523d243b 100644 --- a/SL/IS.pm +++ b/SL/IS.pm @@ -1705,7 +1705,7 @@ sub get_customer { map { $form->{$_} = $ref->{$_} } keys %$ref; my $query = qq|SELECT dnn.dunning_description AS max_dunning_level FROM dunning_config dnn - WHERE id in (SELECT dunning_config_id from ar WHERE paid < amount AND customer_id = ? AND dunning_id IS NOT NULL) + WHERE id in (SELECT dunning_config_id from ar WHERE paid < amount AND customer_id = ? AND dunning_config_id IS NOT NULL) ORDER BY dunning_level DESC LIMIT 1|; $ref = selectfirst_hashref_query($form, $dbh, $query, $form->{customer_id}); map { $form->{$_} = $ref->{$_} } keys %$ref;