Revision 88dea78e
Von Moritz Bunkus vor etwa 8 Jahren hinzugefügt
| SL/CVar.pm | ||
|---|---|---|
| 9 | 9 |
|
| 10 | 10 |
use SL::DBUtils; |
| 11 | 11 |
use SL::MoreCommon qw(listify); |
| 12 |
use SL::Util qw(trim); |
|
| 12 | 13 |
|
| 13 | 14 |
sub get_configs {
|
| 14 | 15 |
$main::lxdebug->enter_sub(); |
| ... | ... | |
| 355 | 356 |
next unless ($params{filter}->{$name});
|
| 356 | 357 |
|
| 357 | 358 |
push @sub_where, qq|cvar.text_value ILIKE ?|; |
| 358 |
push @sub_values, '%' . $params{filter}->{$name} . '%'
|
|
| 359 |
push @sub_values, '%' . trim($params{filter}->{$name}) . '%'
|
|
| 359 | 360 |
|
| 360 | 361 |
} elsif ($config->{type} eq 'select') {
|
| 361 | 362 |
next unless ($params{filter}->{$name});
|
| ... | ... | |
| 406 | 407 |
} |
| 407 | 408 |
|
| 408 | 409 |
push @sub_where, qq|cvar.number_value $op ?|; |
| 409 |
push @sub_values, $form->parse_amount($myconfig, $params{filter}->{$name});
|
|
| 410 |
push @sub_values, $form->parse_amount($myconfig, trim($params{filter}->{$name}));
|
|
| 410 | 411 |
|
| 411 | 412 |
} elsif ($config->{type} eq 'bool') {
|
| 412 | 413 |
next unless ($params{filter}->{$name});
|
| ... | ... | |
| 418 | 419 |
|
| 419 | 420 |
my $table = $config->{type};
|
| 420 | 421 |
push @sub_where, qq|cvar.number_value * 1 IN (SELECT id FROM $table WHERE name ILIKE ?)|; |
| 421 |
push @sub_values, "%$params{filter}->{$name}%";
|
|
| 422 |
push @sub_values, "%" . trim($params{filter}->{$name}) . "%";
|
|
| 422 | 423 |
} elsif ($config->{type} eq 'part') {
|
| 423 | 424 |
next unless $params{filter}->{$name};
|
| 424 | 425 |
|
| 425 | 426 |
push @sub_where, qq|cvar.number_value * 1 IN (SELECT id FROM parts WHERE partnumber ILIKE ?)|; |
| 426 |
push @sub_values, "%$params{filter}->{$name}%";
|
|
| 427 |
push @sub_values, "%" . trim($params{filter}->{$name}) . "%";
|
|
| 427 | 428 |
} |
| 428 | 429 |
|
| 429 | 430 |
if (@sub_where) {
|
Auch abrufbar als: Unified diff
Einkaufs-/Verkaufssuchen: bei Textfeldern führende/anhängende Whitespaces entfernen