List<User> find(@Param("person")Person person,@Param("name")String name);
<if test="person.list1 != null">
and id in
<foreach collection="person.list1" index="index" item="item" open="(" separator="," close=")">
'${item}'
</foreach>
</if>
<if test="person.list2 != null">
and id in
<foreach collection="person.list2" index="index" item="item" open="(" separator="," close=")">
'${item}'
</foreach>
</if>
<select id="getEidList" resultType="java.lang.String">
SELECT efe.eid from ent_file_emergent_industry efe,ent_file ef
where 1 =1
and efe.eid = ef.eid
and efe.code in (SELECT code from dict_emergent_industry where type = 2 and remark in (
<foreach collection="param.customRemarkOrCodeList" index="index" item="item" open="(" separator="," close=")" >
'${item}'
</foreach>
))
and ef.plat_from = '${param.platFrom}'
and ef.delete_flag = 0
</select>