X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FCommon.pm;h=dc1cc04ecb94b13e81922f003f1231fa321bb726;hb=937e37ad007405c6a3a389ee18006379ffecc073;hp=ff6c7218abb0f302d845093d41a5913674e69758;hpb=b3f351139a745a2d01dd35e5a70f72e61b2c2adb;p=kivitendo-erp.git diff --git a/SL/Common.pm b/SL/Common.pm index ff6c7218a..dc1cc04ec 100644 --- a/SL/Common.pm +++ b/SL/Common.pm @@ -85,7 +85,7 @@ sub retrieve_parts { } if ($form->{no_services}) { - $filter .= qq| AND (inventory_accno_id is not NULL or assembly=TRUE)|; # @mb hier nochmal optimieren ... nach kurzer ruecksprache alles i.o. + $filter .= qq| AND (inventory_accno_id is not NULL or assembly=TRUE)|; } substr($filter, 1, 3) = "WHERE" if ($filter); @@ -94,7 +94,8 @@ sub retrieve_parts { $order_dir = $order_dir ? "ASC" : "DESC"; my $query = - qq|SELECT id, partnumber, description, ean | . + qq|SELECT id, partnumber, description, ean, | . + qq| warehouse_id, bin_id | . qq|FROM parts $filter | . qq|ORDER BY $order_by $order_dir|; my $sth = $dbh->prepare($query); @@ -501,6 +502,8 @@ sub save_email_status { } elsif ($form->{script} eq 'ir.pl') { $table = 'ap'; + } elsif ($form->{script} eq 'do.pl') { + $table = 'delivery_orders'; } return $main::lxdebug->leave_sub() if (!$form->{id} || !$table || !$form->{formname});