projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Brieffunktion: beim Drucken im WebDAV speichern
[kivitendo-erp.git]
/
SL
/
DN.pm
diff --git
a/SL/DN.pm
b/SL/DN.pm
index
e7959e0
..
1804959
100644
(file)
--- a/
SL/DN.pm
+++ b/
SL/DN.pm
@@
-492,7
+492,7
@@
sub get_invoices {
} elsif ($form->{customer}) {
$where .= qq| AND (ct.name ILIKE ?)|;
} elsif ($form->{customer}) {
$where .= qq| AND (ct.name ILIKE ?)|;
- push(@values,
'%' . trim($form->{customer}) . '%'
);
+ push(@values,
like($form->{customer})
);
}
my %columns = (
}
my %columns = (
@@
-504,7
+504,7
@@
sub get_invoices {
foreach my $key (keys(%columns)) {
next unless ($form->{$key});
$where .= qq| AND $columns{$key} ILIKE ?|;
foreach my $key (keys(%columns)) {
next unless ($form->{$key});
$where .= qq| AND $columns{$key} ILIKE ?|;
- push(@values,
'%' . trim($form->{$key}) . '%'
);
+ push(@values,
like($form->{$key})
);
}
if ($form->{dunning_level}) {
}
if ($form->{dunning_level}) {
@@
-619,7
+619,7
@@
sub get_dunning {
} elsif ($form->{customer}) {
$where .= qq| AND (ct.name ILIKE ?)|;
} elsif ($form->{customer}) {
$where .= qq| AND (ct.name ILIKE ?)|;
- push(@values,
'%' . $form->{customer} . '%'
);
+ push(@values,
like($form->{customer})
);
}
my %columns = (
}
my %columns = (
@@
-630,7
+630,7
@@
sub get_dunning {
foreach my $key (keys(%columns)) {
next unless ($form->{$key});
$where .= qq| AND $columns{$key} ILIKE ?|;
foreach my $key (keys(%columns)) {
next unless ($form->{$key});
$where .= qq| AND $columns{$key} ILIKE ?|;
- push(@values,
'%' . $form->{$key} . '%'
);
+ push(@values,
like($form->{$key})
);
}
if ($form->{dunning_level}) {
}
if ($form->{dunning_level}) {