X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FIC.pm;h=d78ad30b03564ffea3fd79321367bdb801570b8f;hb=05fc6cefc7bae541f5a306e7b5e09473d91fa843;hp=eaa932c00768ad3d9123917dfc8743f07a260222;hpb=93618a69a94243bf03ed2a9e856d8d4e67036394;p=kivitendo-erp.git diff --git a/SL/IC.pm b/SL/IC.pm index eaa932c00..d78ad30b0 100644 --- a/SL/IC.pm +++ b/SL/IC.pm @@ -820,6 +820,8 @@ sub all_parts { description => 'p.', qty => 'ioi.', serialnumber => 'ioi.', + quotation => 'apoe.', + cv => 'cv.', ); # if the join condition in these blocks are met, the column @@ -933,7 +935,7 @@ sub all_parts { my $bsooqr = any { $form->{$_} } @oe_flags; my @bsooqr_tokens = (); - push @select_tokens, @qsooqr_flags if $bsooqr; + push @select_tokens, @qsooqr_flags, 'quotation', 'cv' if $bsooqr; push @select_tokens, @deliverydate_flags if $bsooqr && $form->{l_deliverydate}; push @select_tokens, $q_assembly_lastcost if ($form->{searchitems} eq 'assembly') && $form->{l_lastcost}; push @bsooqr_tokens, q|module = 'ir' AND NOT ioi.assemblyitem| if $form->{bought}; @@ -1559,7 +1561,7 @@ sub get_basic_part_info { my $dbh = $form->get_standard_dbh($myconfig); - my $query = qq|SELECT id, partnumber, description, unit FROM parts WHERE id IN (| . join(', ', ('?') x scalar(@ids)) . qq|)|; + my $query = qq|SELECT * FROM parts WHERE id IN (| . join(', ', ('?') x scalar(@ids)) . qq|)|; my $info = selectall_hashref_query($form, $dbh, $query, map { conv_i($_) } @ids);