mybatis 语法

 @Override
    public List<ContractApplyCard> listByIds(List<Integer> contractCerificateIds, JSONObject queryFilter) {
        return this.baseMapper.listByIds(contractCerificateIds,queryFilter);
    }

 <select id="listByIds" resultType="com.tj.common.entity.contract.ContractApplyCard">
        select *
        from tj_contract_apply_card as tcac
        where id in
         <foreach item='item' index='index' collection='item' open='(' separator=',' close=')'>
              #{item}
        </foreach>
        <if test="queryFilter.teamCustomerName != null and queryFilter.teamCustomerName != ''">
            AND tcac.team_customer_name like concat('%', #{queryFilter.teamCustomerName}, '%')
        </if>
        <if test="queryFilter.state != null and queryFilter.state != ''">
            AND tcac.state = #{queryFilter.state}
        </if>
        <if test="queryFilter.saleType != null and queryFilter.saleType != ''">
            AND tcac.sale_type = #{queryFilter.saleType}
        </if>
        AND tcac.is_delete = 0
    </select>