<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yd.csf.service.dao.ConditionConfigMapper">

    <select id="page" resultType="com.yd.csf.feign.response.conditionconfig.ApiConditionConfigPageResponse">
        select cc.*,ct.name as conditionTypeName from condition_config cc
        left join condition_type ct on cc.condition_type_biz_id = ct.condition_type_biz_id and ct.is_deleted = 0
        <where>
            <if test="request.name != null and request.name != ''">
                and cc.name like concat('%', #{request.name}, '%')
            </if>
            and cc.is_deleted = 0
        </where>
    </select>

    <select id="selectBrokerRatioByBizIds" resultType="java.util.Map">
        SELECT
        aaf.agent_id AS brokerBizId,
        cc.conditional_value
        FROM agent_accumulated_fyc aaf
        LEFT JOIN condition_config cc
        ON aaf.total_fyc >= cc.min_value
        AND (cc.max_value IS NULL OR aaf.total_fyc &lt; cc.max_value)
        AND cc.condition_type_biz_id = 'condition_type_sk33eRvu75eF8IRL'
        WHERE aaf.agent_id IN
        <foreach collection="list" item="item" open="(" separator="," close=")">
            #{item}
        </foreach>
    </select>

</mapper>
