<?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.ruoyi.excel.wecom.mapper.CustomerExportDataMapper">


    <select id="getDistinctDate" resultType="java.util.Date">
        select distinct add_date from customer_export_data order by add_date
    </select>

    <!-- 查询客户导出数据VO列表(用于导出) -->
    <select id="selectCustomerExportDataVOList" resultType="com.ruoyi.excel.wecom.vo.CustomerExportDataVO">
        SELECT
            customer_name as customerName,
            description,
            add_user_name as addUserName,
            add_user_account as addUserAccount,
            add_user_department as addUserDepartment,
            add_time as addTime,
            add_date as addDate,
            source,
            mobile,
            company,
            email,
            address,
            position,
            phone,
            tag_group1 as tagGroup1,
            tag_group2 as tagGroup2,
            tag_group3 as tagGroup3,
            tag_group4 as tagGroup4,
            tag_group5 as tagGroup5,
            tag_group6 as tagGroup6,
            tag_group7 as tagGroup7,
            tag_group8 as tagGroup8,
            tag_group9 as tagGroup9,
            tag_group10 as tagGroup10,
            tag_group11 as tagGroup11,
            tag_group12 as tagGroup12,
            tag_group13 as tagGroup13,
            tag_group14 as tagGroup14,
            tag_group15 as tagGroup15,
            tag_group16 as tagGroup16,
            tag_group17 as tagGroup17,
            tag_group18 as tagGroup18
        FROM customer_export_data
        <where>
            <if test="startDate != null">
                AND add_time &gt;= #{startDate}
            </if>
            <if test="endDate != null">
                AND add_time &lt;= #{endDate}
            </if>
            <if test="customerName != null">
                AND customer_name like concat('%',#{customerName},'%')
            </if>
        </where>
        ORDER BY add_time DESC
    </select>
    <select id="selectCustomerExportDataList" resultType="com.ruoyi.excel.wecom.domain.CustomerExportData">
        SELECT
        customer_name as customerName,
        description,
        add_user_name as addUserName,
        add_user_account as addUserAccount,
        add_user_department as addUserDepartment,
        add_time as addTime,
        add_date as addDate,
        source,
        mobile,
        company,
        email,
        address,
        position,
        phone,
        tag_group1 as tagGroup1,
        tag_group2 as tagGroup2,
        tag_group3 as tagGroup3,
        tag_group4 as tagGroup4,
        tag_group5 as tagGroup5,
        tag_group6 as tagGroup6,
        tag_group7 as tagGroup7,
        tag_group8 as tagGroup8,
        tag_group9 as tagGroup9,
        tag_group10 as tagGroup10,
        tag_group11 as tagGroup11,
        tag_group12 as tagGroup12,
        tag_group13 as tagGroup13,
        tag_group14 as tagGroup14,
        tag_group15 as tagGroup15,
        tag_group16 as tagGroup16,
        tag_group17 as tagGroup17,
        tag_group18 as tagGroup18
        FROM customer_export_data
        <where>
            <if test="startDate != null">
                AND add_time &gt;= #{startDate}
            </if>
            <if test="endDate != null">
                AND add_time &lt;= #{endDate}
            </if>
            <if test="customerName != null">
                AND customer_name like concat('%',#{customerName},'%')
            </if>
        </where>
        ORDER BY add_time DESC
    </select>

    <!-- 根据客户唯一标识查询客户数据（客户名称+添加人账号+添加时间） -->
    <select id="selectByUniqueKey" resultType="com.ruoyi.excel.wecom.domain.CustomerExportData">
        SELECT *
        FROM customer_export_data
        WHERE customer_name = #{customerName}
          AND add_user_account = #{addUserAccount}
          AND add_time = #{addTime}
        LIMIT 1
    </select>

</mapper>
