From cc2f1d2cb7e9635e31068cde4b896cf7703264a6 Mon Sep 17 00:00:00 2001
From: Helius <wangdoubleone@gmail.com>
Date: Tue, 19 Jul 2022 15:21:16 +0800
Subject: [PATCH] fix
---
src/main/resources/mapper/dapp/DappIdoAssetsDao.xml | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/main/resources/mapper/dapp/DappIdoAssetsDao.xml b/src/main/resources/mapper/dapp/DappIdoAssetsDao.xml
index 1fc6842..96d0e1d 100644
--- a/src/main/resources/mapper/dapp/DappIdoAssetsDao.xml
+++ b/src/main/resources/mapper/dapp/DappIdoAssetsDao.xml
@@ -15,11 +15,11 @@
a.address,
a.invite_id,
(select count(1) from dapp_member x where a.invite_id=x.referer_id) addressCnt,
- sum(c.coin_amount) coinAmount,
- sum(c.usdt_amount) usdtAmount
+ IFNULL(sum(c.coin_amount),0) coinAmount,
+ IFNULL(sum(c.usdt_amount),0) usdtAmount
from dapp_member a
- inner join dapp_member b on find_in_set(a.invite_id, substring_index(b.referer_ids, ',', 10))
- inner join dapp_ido_assets c on c.member_id=b.id
+ left join dapp_member b on find_in_set(a.invite_id, substring_index(b.referer_ids, ',', 10))
+ left join dapp_ido_assets c on c.member_id=b.id
<where>
<if test="record.address != null and record.address != ''">
and (a.address = #{record.address} or a.invite_id=#{record.address})
--
Gitblit v1.9.1