select L.xfbm as bm,B.DEPARTMENTNAME as 发布部门,L.dcdblb,A.SELECTNAME as 检查类别,sum(L.zxs) as 总项数, sum(L.ywc) as 已完成,sum(L.wwc) as 未完成,sum(L.yq) as 逾期,DATE_FORMAT(L.fkrq,'%Y') as 年份 from uf_dcjcjh L LEFT JOIN hrmdepartment B on B.id=L.xfbm left join (select * from workflow_selectitem where fieldid = 43508) A on A.SELECTVALUE = L.dcdblb where L.xfcj = '0' and L.fkrq like '${year}%' group by L.xfbm,A.SELECTNAME |