From 9b92c0c6d139606ffbeee21abff016acb019cca1 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Tue, 1 Aug 2017 10:53:41 +0200 Subject: [PATCH] =?utf8?q?DeliveryValueReport:=20Tabelle=20hei=C3=9Ft=20de?= =?utf8?q?livery=5Forders=20(mit=20s=20am=20Ende).?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/Controller/DeliveryValueReport.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/SL/Controller/DeliveryValueReport.pm b/SL/Controller/DeliveryValueReport.pm index f6bc617d1..0a714d2a2 100644 --- a/SL/Controller/DeliveryValueReport.pm +++ b/SL/Controller/DeliveryValueReport.pm @@ -284,7 +284,7 @@ sub calc_qtys_price { my %oi_by_id = map { $_->id => $_ } @$orderitems; my $query = sprintf <<'', join ', ', ("?")x@all_doi_ids; SELECT DISTINCT doi.id, closed FROM delivery_orders - LEFT JOIN delivery_order_items doi ON (doi.delivery_order_id = delivery_order.id) + LEFT JOIN delivery_order_items doi ON (doi.delivery_order_id = delivery_orders.id) WHERE doi.id IN (%s) my %doi_is_closed = selectall_as_map($::form, SL::DB->client->dbh, $query, (id => 'closed'), @all_doi_ids); -- 2.20.1