X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FCT.pm;h=ad92d4c34a90387e43ab2f66e8ec31d9ceb5ccb4;hb=7c3117b50d46f04f589aae322525f0797c4146e9;hp=d9a7ac704508930d5521299ccb2d1a36587037fd;hpb=93a4e424476aae2551b2d070133cd42d5d2f3d52;p=kivitendo-erp.git diff --git a/SL/CT.pm b/SL/CT.pm index d9a7ac704..ad92d4c34 100644 --- a/SL/CT.pm +++ b/SL/CT.pm @@ -624,6 +624,17 @@ sub search { $form->{l_invnumber} = $form->{l_ordnumber} = $form->{l_quonumber} = ""; } + if ($form->{obsolete} eq "Y") { + $where .= qq| AND obsolete|; + } elsif ($form->{obsolete} eq "N") { + $where .= qq| AND NOT obsolete|; + } + + if ($form->{business_id}) { + $where .= qq| AND (business_id = ?)|; + push(@values, conv_i($form->{business_id})); + } + my $query = qq|SELECT ct.*, b.description AS business | . qq|FROM $cv ct | .