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