X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FController%2FCustomerVendor.pm;h=91994a1c3002f14b913139557152b9e1cc6db476;hb=6e6038682b1a2b6e6bc74f1eee40eba21afcb7e9;hp=af109e967e1077134dd66958e73c350b4f17592d;hpb=fa7fc7eeb3ca718914affee06c0629a08d571288;p=kivitendo-erp.git 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";