X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FCT.pm;h=91fe2c022f8213a6442f24612a4d801f31c60ad3;hb=0ecb31986f567eb0b1e9949978458baba04c0ef9;hp=82e360cc70a6e82318d77a1114abc67be12ced8d;hpb=c7bffefd26718a316f989fefa780a7edd95444f9;p=kivitendo-erp.git diff --git a/SL/CT.pm b/SL/CT.pm index 82e360cc7..91fe2c022 100644 --- a/SL/CT.pm +++ b/SL/CT.pm @@ -101,10 +101,6 @@ sub populate_drop_down_boxes { $query = qq|SELECT id, description FROM business ORDER BY id|; $form->{all_business} = selectall_hashref_query($form, $dbh, $query); - # get tax zones - $query = qq|SELECT id, description FROM tax_zones|; - $form->{TAXZONE} = selectall_hashref_query($form, $dbh, $query); - # get shipto address $query = qq|SELECT shipto_id, shiptoname, shiptodepartment_1 | . @@ -630,6 +626,11 @@ sub search { $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 | .