搭建流程数查询

select log.*,log.id as keyid,lt.datatype, CASE WHEN hrm.lastname IS NULL THEN hrmm.lastname ELSE hrm.lastname END AS operatorName,

ll.labelname as logtypelabelname ,sm.labelname as logsmalltypelabelname ,tl.labelname as belongtypelabelname,

gl.labelname as groupnamelabelname from ecology_biz_log log

left join ECOLOGY_BIZ_LOG_TYPE lt on log.logtype=lt.id

left join hrmresource hrm on log.userid = hrm.id

LEFT JOIN hrmresourcemanager hrmm ON log.userid = hrmm.id

left join htmllabelinfo ll on ll.indexid = log.logtypelabel and ll.languageid=7

left join htmllabelinfo sm on sm.indexid = log.logsmalltypelabel and sm.languageid=7

left join htmllabelinfo tl on tl.indexid = log.belongtypelabel and tl.languageid=7

left join htmllabelinfo gl on gl.indexid = log.groupNameLabel and gl.languageid=7

where (isdetail=0 or isdetail is null) and (( 1=1 and logType in ( 2 ) and logSmallType in ( 2 ) ) )

and year(operateDate)=2022

order by log.id desc;