4 bug_number => "BUG_33028",
6 "Fix calculations around fines and values with comma as decimal separator",
9 my ( $dbh, $out ) = @$args{qw(dbh out)};
11 my $rules = $dbh->selectall_arrayref(
12 q|select * from circulation_rules where rule_name IN ('fine', 'overduefinescap')|,
16 my $query = $dbh->prepare(
17 "UPDATE circulation_rules SET rule_value = ? where id = ?");
19 foreach my $rule ( @{$rules} ) {
20 my $rule_id = $rule->{'id'};
21 my $rule_value = $rule->{'rule_value'};
22 if ( $rule_value =~ /[a-zA-Z]/ ) {
25 'No only numbers in rule id %s ("%s") - fix it before restart this update',
31 if ( $rule_value =~ /,/ ) {
32 if ( $rule_value !~ /,.*?,/ ) {
33 $rule_value =~ s/,/./;
34 $query->execute( $rule_value, $rule_id );
39 'Many commas in rule id %s ("%s") - fix it before restart this update',
49 "BUG_33028 - Patch applied";