X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FIC.pm;h=ce3bc00a8ea9ed4ef48aba1ceb1f9c4faf5359b5;hb=866738c6c3eeec3b398aa6f1aa6f946f8da0210e;hp=17867a0700c84449f41d9a5310335ad998fd6bc2;hpb=219d88ab03186a74e5dd474175e49bd74dacf15f;p=kivitendo-erp.git diff --git a/SL/IC.pm b/SL/IC.pm index 17867a070..ce3bc00a8 100644 --- a/SL/IC.pm +++ b/SL/IC.pm @@ -379,12 +379,20 @@ sub all_parts { push @select_tokens, $_; } - for ($form->{searchitems}) { - push @where_tokens, "p.part_type = 'part'" if /part/; - push @where_tokens, "p.part_type = 'service'" if /service/; - push @where_tokens, "p.part_type = 'assembly'" if /assembly/; - push @where_tokens, "p.part_type = 'assortment'" if /assortment/; + # Oder Bedingungen fuer Ware Dienstleistung Erzeugnis: + if ($form->{l_part} || $form->{l_assembly} || $form->{l_service} || $form->{l_assortment}) { + my @or_tokens = (); + push @or_tokens, "p.part_type = 'service'" if $form->{l_service}; + push @or_tokens, "p.part_type = 'assembly'" if $form->{l_assembly}; + push @or_tokens, "p.part_type = 'part'" if $form->{l_part}; + push @or_tokens, "p.part_type = 'assortment'" if $form->{l_assortment}; + push @where_tokens, join ' OR ', map { "($_)" } @or_tokens; } + else { + # gar keine Teile + push @where_tokens, q|'F' = 'T'|; + } + if ( $form->{classification_id} > 0 ) { push @where_tokens, "p.classification_id = ?"; push @bind_vars, $form->{classification_id};