1 # @tag: oe_ar_ap_delivery_orders_edit_notes_as_html
2 # @description: Einkaufs- und Verkaufsbelege: Bemerkungsfeld in HTML umwandeln
3 # @depends: requirement_spec_edit_html
4 package SL::DBUpgrade2::oe_ar_ap_delivery_orders_edit_notes_as_html;
11 use parent qw(SL::DBUpgrade2::Base);
14 my ($self, $table, $column) = @_;
16 my $sth = $self->dbh->prepare(qq|UPDATE $table SET $column = ? WHERE id = ?|) || $self->dberror;
18 foreach my $row (selectall_hashref_query($::form, $self->dbh, qq|SELECT id, $column FROM $table WHERE $column IS NOT NULL|)) {
19 next if !$row->{$column} || (($row->{$column} =~ m{^<[a-z]+>}) && ($row->{$column} =~ m{</[a-z]+>$}));
21 my $new_content = "" . $::request->presenter->escape($row->{$column});
22 $new_content =~ s{\r}{}g;
23 $new_content =~ s{\n\n+}{</p><p>}g;
24 $new_content =~ s{\n}{<br />}g;
25 $new_content = "<p>${new_content}</p>" if $new_content;
27 $sth->execute($new_content, $row->{id}) if $new_content ne $row->{$column};
36 $self->convert_column($_, 'notes') for qw(oe delivery_orders ar ap);