From 27bfdf62608008555876d295c18661c0f0f7e7ba Mon Sep 17 00:00:00 2001
From: Helius <wangdoubleone@gmail.com>
Date: Sat, 11 Jul 2020 17:08:53 +0800
Subject: [PATCH] modify
---
src/main/resources/mapper/modules/ContractOrderMapper.xml | 2 +-
src/main/resources/mapper/modules/CoinMapper.xml | 4 ++--
2 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/main/resources/mapper/modules/CoinMapper.xml b/src/main/resources/mapper/modules/CoinMapper.xml
index f6ce48b..3b82e81 100644
--- a/src/main/resources/mapper/modules/CoinMapper.xml
+++ b/src/main/resources/mapper/modules/CoinMapper.xml
@@ -30,7 +30,7 @@
b.symbol symbol,
b.create_time createTime
from member a
- inner join member_coin_charge b on a.id=b.member_id and b.status=2
+ inner join member_coin_charge b on a.id=b.member_id --and b.status=3
where find_in_set(#{record.refererId}, a.referer_ids)
<if test="record.account!=null and record.account!=''">
and (a.phone=#{record.account} or a.email=#{record.account} or a.invite_id=#{record.account})
@@ -67,7 +67,7 @@
b.symbol symbol,
b.create_time createTime
from member a
- inner join member_coin_withdraw b on a.id=b.member_id and b.status=2
+ inner join member_coin_withdraw b on a.id=b.member_id --and b.status=2
where find_in_set(#{record.refererId}, a.referer_ids)
<if test="record.account!=null and record.account!=''">
and (a.phone=#{record.account} or a.email=#{record.account} or a.invite_id=#{record.account})
diff --git a/src/main/resources/mapper/modules/ContractOrderMapper.xml b/src/main/resources/mapper/modules/ContractOrderMapper.xml
index ea41bc4..2133347 100644
--- a/src/main/resources/mapper/modules/ContractOrderMapper.xml
+++ b/src/main/resources/mapper/modules/ContractOrderMapper.xml
@@ -12,7 +12,7 @@
c.closing_fee_amount*(select fee_spread_ratio from platform_trade_setting) closing_fee_amount,
c.*
from member a
- inner join member_authentication b on a.id=b.member_id
+ left join member_authentication b on a.id=b.member_id
inner join contract_order c on a.id=c.member_id
<where>
<if test="record!=null">
--
Gitblit v1.9.1