From dc36db346fc09ea8f4b4d3e648225555f1c2c8cc Mon Sep 17 00:00:00 2001
From: Helius <wangdoubleone@gmail.com>
Date: Sun, 11 Oct 2020 14:47:55 +0800
Subject: [PATCH] modify
---
src/main/resources/mapper/modules/MemberMapper.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/main/resources/mapper/modules/MemberMapper.xml b/src/main/resources/mapper/modules/MemberMapper.xml
index cd8de9b..6a6c7e1 100644
--- a/src/main/resources/mapper/modules/MemberMapper.xml
+++ b/src/main/resources/mapper/modules/MemberMapper.xml
@@ -11,7 +11,7 @@
c.available_balance coinTotal,
d.total_balance agentTotal
from member a
- left join member_wallet_contract b on a.id=b.member_id
+ left join (select member_id, sum(total_balance) total_balance from member_wallet_contract group by member_id) b on a.id=b.member_id
left join member_wallet_coin c on a.id=c.member_id and c.wallet_code='USDT'
left join member_wallet_agent d on a.id=d.member_id
left join member_authentication e on a.id=e.member_id
@@ -92,7 +92,7 @@
c.available_balance coinTotal,
d.total_balance agentTotal
from member a
- left join member_wallet_contract b on a.id=b.member_id
+ left join (select member_id, sum(total_balance) total_balance from member_wallet_contract group by member_id) b on a.id=b.member_id
left join member_wallet_coin c on a.id=c.member_id and c.wallet_code='USDT'
left join member_wallet_agent d on a.id=d.member_id
left join member_authentication e on a.id=e.member_id
--
Gitblit v1.9.1