Revision bc40bcab
Von Moritz Bunkus vor mehr als 8 Jahren hinzugefügt
| SL/DN.pm | ||
|---|---|---|
| 492 | 492 |
|
| 493 | 493 |
} elsif ($form->{customer}) {
|
| 494 | 494 |
$where .= qq| AND (ct.name ILIKE ?)|; |
| 495 |
push(@values, '%' . trim($form->{customer}) . '%');
|
|
| 495 |
push(@values, like($form->{customer}));
|
|
| 496 | 496 |
} |
| 497 | 497 |
|
| 498 | 498 |
my %columns = ( |
| ... | ... | |
| 504 | 504 |
foreach my $key (keys(%columns)) {
|
| 505 | 505 |
next unless ($form->{$key});
|
| 506 | 506 |
$where .= qq| AND $columns{$key} ILIKE ?|;
|
| 507 |
push(@values, '%' . trim($form->{$key}) . '%');
|
|
| 507 |
push(@values, like($form->{$key}));
|
|
| 508 | 508 |
} |
| 509 | 509 |
|
| 510 | 510 |
if ($form->{dunning_level}) {
|
| ... | ... | |
| 619 | 619 |
|
| 620 | 620 |
} elsif ($form->{customer}) {
|
| 621 | 621 |
$where .= qq| AND (ct.name ILIKE ?)|; |
| 622 |
push(@values, '%' . $form->{customer} . '%');
|
|
| 622 |
push(@values, like($form->{customer}));
|
|
| 623 | 623 |
} |
| 624 | 624 |
|
| 625 | 625 |
my %columns = ( |
| ... | ... | |
| 630 | 630 |
foreach my $key (keys(%columns)) {
|
| 631 | 631 |
next unless ($form->{$key});
|
| 632 | 632 |
$where .= qq| AND $columns{$key} ILIKE ?|;
|
| 633 |
push(@values, '%' . $form->{$key} . '%');
|
|
| 633 |
push(@values, like($form->{$key}));
|
|
| 634 | 634 |
} |
| 635 | 635 |
|
| 636 | 636 |
if ($form->{dunning_level}) {
|
Auch abrufbar als: Unified diff
(I)LIKE-Argumente immer mit Funktion SL::DBUtils::like erstellen