应用ID:__oSi0GbbYmn1RtxZ4FVB
视图ID:__i4UOB3LJYxgx2K8yAlc
脚本:
SELECT count(1) FROM tenant_employees b INNER JOIN tenant_user_credentials d ON b.tenant_user_id=d.tenant_user_id AND d.credential_type=0 LEFT JOIN tenant_departments e ON b.department_id=e.id WHERE b.leave_time is null AND b.occupation_type=1 AND b.hired_date < DATE_SUB(NOW(), INTERVAL 3 DAY) AND ( (SELECT COUNT(1) FROM tenant_xlcp WHERE number=d.number) < 1 OR ((SELECT COUNT(1) FROM tenant_xlcp WHERE employee_id = b.id) < 1 && (SELECT MAX(creator_created_time) FROM tenant_xlcp WHERE number=d.number) < DATE_SUB(NOW(), INTERVAL 7 DAY)) ) AND b.organization_id = #{id}