parent: 8b2e0157 | patch | commit | ignore whitespace
Helius
2021-11-12 1e73259f37922b2556659b60dac0140ed9eb7832 
Merge branch 'ty_fix' into score_shop
1 files modified
2 ■■■■■ changed files
zq-erp/src/main/resources/mybatis/mapper/hive/SysVipInfoDao.xml 2 ●●●●● patch | view | raw | blame | history 
 zq-erp/src/main/resources/mybatis/mapper/hive/SysVipInfoDao.xml


@@ -1461,7 +1461,7 @@


               c.LEVEL_NAME vipLevel,


               a.POINT_ALL integral,


               e.shop_short_name shopName,


               sum(IFNULL(b.gift_money, 0) + IFNULL(b.real_money, 0)) totalBalance,


               sum(IFNULL(b.gift_money, 0)) totalBalance,


               sum(IFNULL(b.gift_money, 0)) giftBalance,


               (select sum(IFNULL(d.goods_cash, 0) + IFNULL(d.proj_cash, 0) + IFNULL(d.card_cash, 0)) from achieve_new d where d.vip_id=a.id) totalShopping


        from sys_vip_info a