X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FHelper%2FShippedQty.pm;h=6b878a972d54f43a75fe2b936c58c70728798a80;hb=eaa42caeb03b5213754334a930b08407a0e74c53;hp=b93d4fae21c10f5f71f08f41e59b046ff9625912;hpb=cfb7f3d1f071035f866e3938d4f6a63f718f5551;p=kivitendo-erp.git diff --git a/SL/Helper/ShippedQty.pm b/SL/Helper/ShippedQty.pm index b93d4fae2..6b878a972 100644 --- a/SL/Helper/ShippedQty.pm +++ b/SL/Helper/ShippedQty.pm @@ -38,28 +38,6 @@ my $stock_item_links_query = <<''; WHERE oi.trans_id IN (%s) ORDER BY oi.trans_id, oi.position -my $stock_fill_up_doi_query = <<''; - SELECT doi.id, doi.delivery_order_id, doi.position, doi.parts_id, doi.description, doi.reqdate, doi.serialnumber, - (CASE WHEN doe.customer_id > 0 THEN -1 ELSE 1 END) * i.qty, p.unit - FROM delivery_order_items doi - INNER JOIN parts p ON p.id = doi.parts_id - INNER JOIN delivery_order_items_stock dois ON dois.delivery_order_item_id = doi.id - INNER JOIN delivery_orders doe ON doe.id = doi.delivery_order_id - INNER JOIN inventory i ON dois.id = i.delivery_order_items_stock_id - WHERE doi.delivery_order_id IN ( - SELECT to_id - FROM record_links - WHERE from_id IN (%s) - AND from_table = 'oe' - AND to_table = 'delivery_orders' - AND to_id = doi.delivery_order_id) - AND NOT EXISTS ( - SELECT NULL - FROM record_links - WHERE from_table = 'orderitems' - AND to_table = 'delivery_order_items' - AND to_id = doi.id) - sub calculate { my ($self, $data) = @_; @@ -184,9 +162,9 @@ sub init_require_stock_out { $::instance_conf->get_shipped_qty_require_stock_ sub init_services_deliverable { my ($self) = @_; - if ($::form->{type} =~ m/^sales_/) { + if (($::form->{type}//'') =~ m/^sales_/ || $self->{objects}->[0]->{customer_id}) { $::instance_conf->get_sales_delivery_order_check_service; - } elsif ($::form->{type} =~ m/^purchase_/) { + } elsif (($::form->{type}//'') =~ m/^purchase_/ || $self->{objects}->[0]->{vendor_id}) { $::instance_conf->get_purchase_delivery_order_check_service; } else { croak "wrong call, no customer or vendor object referenced";