<!--and s1.approve_type not in (#{notInApproveType}) 这种 and s1.approve_type not in ('0,4')只过滤0没过滤4 --> <if test="notInApproveType != null"> and #{notInApproveType} not like concat('%',s1.approve_type,'%') </if>
<!--and s1.approve_type not in (#{notInApproveType}) 这种 and s1.approve_type not in ('0,4')只过滤0没过滤4 --> <if test="notInApproveType != null"> and #{notInApproveType} not like concat('%',s1.approve_type,'%') </if>