应用ID:__oSi0GbbYmn1RtxZ4FVB
视图ID:__i4UOB3LJYxgx2K8yAlc
脚本:
SELECT count(1) AS sum FROM companyinfocollect.employees b WHERE b.item_domain_id = #{id} AND b.occupation_type = 1 AND b.employed = 0 AND b.hire_date < DATE_SUB(NOW(), INTERVAL 3 DAY) AND NOT EXISTS ( SELECT 1 FROM obpm2.tenant_xlcp x WHERE x.number = b.id_no AND x.creator_created_time <= DATE_SUB(NOW(), INTERVAL 7 DAY) AND x.employee_id = b.employee_id)