页面搜索栏数据查询

<select id="selectAdvertSet" parameterType="cn.webank.cfpd.cpmm.adm.dto.AdvertRetentSetInfoDTO" resultType="cn.webank.cfpd.cpmm.adm.dto.AdvertRetentSetInfoDTO">
        /*slave*/ SELECT
        a.advert_id,
        a.advert_name,
        a.retent_purpose,
        a.area,
        a.channel_id,
        a.efs_channel_id,
        a.project_id,
        a.create_time,
        a.deploy_way,
        a.advert_id advert_id_bak,
        a.product_cd,
        a.template_name,
        b.retent_num,
        c.repeat_num
        FROM
        advert_retent_set_info a
        LEFT JOIN (
        SELECT
        count(1) AS retent_num,
        advert_id
        FROM
        advert_retent_enp_info
        GROUP BY
        advert_id
        ) b ON a.advert_id = b.advert_id
        LEFT JOIN (select advert_id,count(1) repeat_num from advert_retent_enp_repeat GROUP BY advert_id) c on a.advert_id = c.advert_id
        where 1=1
        <if test="advert_name !=null and advert_name !='' ">
            and advert_name like concat('%',#{advert_name},'%')
        </if>
        <if test="advert_id !=null and advert_id !='' ">
            and a.advert_id like concat('%',#{advert_id},'%')
        </if>
        <if test="area !=null and area !='' ">
            and area = #{area}
        </if>
        <if test="channel_id !=null and channel_id !='' ">
            and channel_id like concat('%',#{channel_id},'%')
        </if>
        <if test="minCreate_time != null and minCreate_time !=''  " >
            and  date_format(create_time,'%Y-%m-%d') >= #{minCreate_time}
        </if>
        <if test="maxCreate_time != null and maxCreate_time !=''  " >
            and  #{maxCreate_time} >= date_format(create_time,'%Y-%m-%d')
        </if>
        order by create_time desc
        <if test="page == true" >
            limit #{start},#{pageSize}
        </if>
    </select>