应用ID:__oSi0GbbYmn1RtxZ4FVB
视图ID:__XUx4E0QmsopnmW7Ep3F
脚本:
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 INNER JOIN tenant_xlcp a ON a.employee_id=b.id LEFT JOIN tenant_departments e ON b.department_id=e.id WHERE b.leave_time is null AND b.occupation_type=1 AND a.creator_created_time < DATE_SUB(CURDATE(), INTERVAL 6 MONTH)  AND b.organization_id = #{id}