17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT
(
SELECT
GROUP_CONCAT( CONCAT( t4.dpName, '(', IFNULL( t6.realname, '' ), ')' ) )
FROM
workflow_item t3
RIGHT JOIN department t4 ON (t3.department_id = t4.id AND t3.workflow_id = t2.wk_id)
LEFT JOIN workflow_trace t5 ON t3.id = t5.wk_item_nowid
LEFT JOIN USER t6 ON t5.operater_id = t6.id
WHERE
t4.CODE IN ( 'business_cy', 'business_sx', 'business_zz', 'business_pm', 'business_qxj' )
AND t3.workflow_id = t2.wk_id
)
FROM
USER t
RIGHT JOIN workflow_management t2 ON t.id = t2.operater_id
LEFT JOIN department dt ON dt.id = t.departmentId