Revision bc8ddcc1
Von Tamino Steinert vor 12 Monaten hinzugefügt
SL/IC.pm | ||
---|---|---|
319 | 319 |
$form->{l_assembly} = 1 if $form->{searchitems} eq 'assembly' || $form->{searchitems} eq ''; |
320 | 320 |
$form->{l_part} = 1 if $form->{searchitems} eq 'part' || $form->{searchitems} eq ''; |
321 | 321 |
$form->{l_assortment} = 1 if $form->{searchitems} eq 'assortment' || $form->{searchitems} eq ''; |
322 |
$form->{l_parent_variant} = 1 if $form->{searchitems} eq 'parent_variant' || $form->{searchitems} eq ''; |
|
323 |
$form->{l_variant} = 1 if $form->{searchitems} eq 'variant' || $form->{searchitems} eq ''; |
|
324 | 322 |
push @where_tokens, "p.partnumber ILIKE ? OR p.description ILIKE ?"; |
325 | 323 |
push @bind_vars, (like($form->{all})) x 2; |
326 | 324 |
} |
... | ... | |
372 | 370 |
# Oder Bedingungen fuer Ware Dienstleistung Erzeugnis: |
373 | 371 |
if ( $form->{l_part} || $form->{l_assembly} |
374 | 372 |
|| $form->{l_service} || $form->{l_assortment} |
375 |
|| $form->{l_parent_variant} || $form->{l_variant} |
|
376 | 373 |
) { |
377 | 374 |
my @or_tokens = (); |
378 | 375 |
push @or_tokens, "p.part_type = 'service'" if $form->{l_service}; |
379 | 376 |
push @or_tokens, "p.part_type = 'assembly'" if $form->{l_assembly}; |
380 | 377 |
push @or_tokens, "p.part_type = 'part'" if $form->{l_part}; |
381 | 378 |
push @or_tokens, "p.part_type = 'assortment'" if $form->{l_assortment}; |
382 |
push @or_tokens, "p.part_type = 'parent_variant'" if $form->{l_parent_variant}; |
|
383 |
push @or_tokens, "p.part_type = 'variant'" if $form->{l_variant}; |
|
384 | 379 |
push @where_tokens, join ' OR ', map { "($_)" } @or_tokens; |
385 | 380 |
} |
386 | 381 |
else { |
Auch abrufbar als: Unified diff
Varianten: alle Artikeltypen ermöglichen