IN条件范围查询
<if test="customerIds != null and customerIds.size() > 0">
AND customerId IN
<foreach collection="customerIds" item="value" separator="," open="(" close=")">
#{value}
</foreach>
</if>IN条件范围查询
<if test="customerIds != null and customerIds.size() > 0">
AND customerId IN
<foreach collection="customerIds" item="value" separator="," open="(" close=")">
#{value}
</foreach>
</if>