From: Bernd Bleßmann <bernd@kivitendo-premium.de>
Date: Tue, 1 Aug 2017 08:53:41 +0000 (+0200)
Subject: DeliveryValueReport: Tabelle heißt delivery_orders (mit s am Ende).
X-Git-Tag: release-3.5.4~926
X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/commitdiff_plain/9b92c0c6d139606ffbeee21abff016acb019cca1?ds=inline;hp=33e8932ce36d4fbe58a9649b1a233c54f6400d6d

DeliveryValueReport: Tabelle heißt delivery_orders (mit s am Ende).
---

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);