<when test="c_planSearchView.whereCondition.inverseMemberDepartment">
and exists(select 1 from abd_plan_member t_plan_member
where t_plan_member.plan_=t.id_ and t_plan_member.dept_ not in
<foreach collection="c_planSearchView.whereCondition.memberDeptList" index="index" item="deptId" open="(" separator="," close=")">
#{deptId}
</foreach> )
</when>
网友评论