From 31a84730a77d2e2fdc07bfd99da38b9c193a58e5 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Mon, 30 Jun 2014 15:35:41 +0200 Subject: [PATCH] =?utf8?q?Auftr=C3=A4ge=20bei=20Anzeige=20der=20Lieferunge?= =?utf8?q?n=20in=20Kundenstammdaten=20richtig=20zuordnen.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Und richtigen Beleg (VK/EK) öffnen. Behebt #2467. --- SL/Controller/CustomerVendor.pm | 3 ++- templates/webpages/customer_vendor/get_delivery.html | 2 +- 2 files changed, 3 insertions(+), 2 deletions(-) diff --git a/SL/Controller/CustomerVendor.pm b/SL/Controller/CustomerVendor.pm index af109e967..91994a1c3 100644 --- a/SL/Controller/CustomerVendor.pm +++ b/SL/Controller/CustomerVendor.pm @@ -470,7 +470,8 @@ sub action_get_delivery { ON p.id = i.parts_id LEFT JOIN oe - ON (oe.ordnumber = ${arap}.ordnumber AND NOT ${arap}.ordnumber = '') + ON (oe.ordnumber = ${arap}.ordnumber AND NOT ${arap}.ordnumber = '' + AND ". ($arap eq 'ar' ? 'oe.customer_id IS NOT NULL' : 'oe_vendor_id IS NOT NULL') ." ) ${where} ORDER BY ${arap}.transdate DESC LIMIT 15"; diff --git a/templates/webpages/customer_vendor/get_delivery.html b/templates/webpages/customer_vendor/get_delivery.html index 7cfc76fe7..5250110b3 100644 --- a/templates/webpages/customer_vendor/get_delivery.html +++ b/templates/webpages/customer_vendor/get_delivery.html @@ -27,7 +27,7 @@ [% HTML.escape(row.shiptoname) UNLESS loop.prev.shiptoname == row.shiptoname %]  [% IF row.id %][% END %][% HTML.escape(row.invnumber) || ' ' %][% IF row.id %][% END %] - [% IF row.oe_id %][% END %][% HTML.escape(row.ordnumber) || ' ' %][% IF row.oe_id %][% END %] + [% IF row.oe_id %][% END %][% HTML.escape(row.ordnumber) || ' ' %][% IF row.oe_id %][% END %] [% HTML.escape(row.transdate) || ' ' %] [% HTML.escape(row.description) || ' ' %] [% HTML.escape(row.qty) || ' ' %] -- 2.20.1