modify

Helius

2021-01-05 186fcc376789dc0c42248afe6b84b40ad3698051

modify

 zq-erp/src/main/resources/mybatis/mapper/hive/SysVipInfoDao.xml

@@ -108,6 +108,10 @@
        <!-- 扩展属性 -->
        <result property="staffName" column="STAFF_NAME"/>
        <result property="shopName" column="SHOP_NAME"/>
        <association property="vipLevel" javaType="com.matrix.system.hive.bean.SysVipLevel" >
            <result property="levelName" column="levelName"/>
            <result property="vipLevel" column="vipLevel"/>
        </association>
    </resultMap>

    <!-- 查询几天内过生日的会员 -->
@@ -965,12 +969,15 @@
        a.province,
        a.city,
        a.area,
        a.recommend_id
        a.recommend_id,
        e.level_name levelName,
        e.vip_level vipLevel
    </sql>
    <sql id="from">
        from sys_vip_info a
        left join sys_users c on c.su_id =a.STAFF_ID
        left join sys_shop_info d ON d.ID=a.SHOP_ID
        left join sys_vip_level e on a.level_id=e.id
       
    </sql>