select
lcaa.clmnum,
COALESCE((SELECT 1 FROM clm_subtask_swfswti sub WHERE t.clmnum=sub.clmnum LIMIT 1),'0') AS iscleancase-- 是否清洁件
from clm_baseinfo_lcaa lcaa
LEFT JOIN clm_worktask_swflwti t on lcaa.clmnum = t.clmnum
and t.status = 1
where lcaa.status = 1
and lcaa.procecode='C'
and lcaa.inspectflag is null
and t.submitdte BETWEEN CAST(date_format(date_add(now(), interval - 1 day),'%Y%m%d') AS SIGNED integer) AND CAST(date_format(date_add(now(), interval - 1 day),'%Y%m%d') AS SIGNED integer)
-- perid 是有效的督查规则那边传递过来的外包商id
<if test="perid!=null and perid!=''">
and t.fircheckusr in (#{perid})
</if>
coalesce,sql函数去判断查询出来的东西符合条件返回‘0’,否则返回1
最新推荐文章于 2023-05-06 11:49:24 发布