X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/93a4e424476aae2551b2d070133cd42d5d2f3d52..a3db203d790b5317f70c79adc7abbacd94c94a4c:/SL/CT.pm 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 | .