2023年6月23日发(作者：)

in,countSELECT _name, _id, _state , _user_uuid , _priority , QuStatus , hengStatus , ROM sys_user aLEFT JOIN biz_document_user_info b ON = _id

LEFT JOIN (SELECT _uuid as task_user_uuid , COUNT(case WHEN _priority = 1 THEN '急单个数' end) AS pay_priority, COUNT(case WHEN ='已领取' THEN '已领取个数' end) as yiLingQuStatus , COUNT(case WHEN ='已完成' THEN '已完成个数' end) as yiWanChengStatus , COUNT(case WHEN IN('已完成','已领取') THEN '已完成个数' end) as totalFROM

bpm_activity a

LEFT JOIN bpm_task_user b on _id = _id

LEFT JOIN bpm_process_instance c on ce_id = ce_id

LEFT JOIN biz_pay_comfirm_info d on _uuid =

where TY_NAME in ('单证线上初审','单证线上初审','单证线下纸质审核','单证审核纸质资料','单证线上审核','项⽬单证线下纸质审核')and _status =_status =_status=_status=1GROUP BY _uuid

) z on _id = _user_uuid

WHERE _status=_status =1