| | |
|---|
| | | e.shop_short_name shopName, |
|---|
| | | sum(IFNULL(b.gift_money, 0) + IFNULL(b.real_money, 0)) totalBalance, |
|---|
| | | sum(IFNULL(b.gift_money, 0)) giftBalance, |
|---|
| | | sum(IFNULL(d.goods_cash, 0) + IFNULL(d.proj_cash, 0) + IFNULL(d.card_cash, 0)) totalShopping |
|---|
| | | (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 |
|---|
| | | left join money_card_use b on a.ID = b.vip_id and b.status='有效' |
|---|
| | | left join sys_vip_level c on a.LEVEL_ID = c.ID |
|---|
| | | left join achieve_new d on a.ID = d.vip_id |
|---|
| | | left join sys_shop_info e on a.SHOP_ID=e.ID |
|---|
| | | where a.ID=#{id} |
|---|
| | | </select> |
|---|
