From 045bd089a7c782a66ecf1f4d77bd78859fa6cb74 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Thu, 23 Jul 2020 17:46:19 +0800
Subject: [PATCH] 20200723 代码提交
---
src/main/java/com/xcong/excoin/modules/member/controller/ViewController.java | 9 +
src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java | 16 ++
src/main/resources/templates/febs/views/modules/member/memberDataInfoAllAloneTest.html | 73 ++++++++++++
src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java | 2
src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java | 64 ++++++++++
src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java | 9 +
src/main/resources/mapper/modules/MemberMapper.xml | 181 +++++++++++++++++++++++++++++
7 files changed, 351 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java b/src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java
index 6489673..695610f 100644
--- a/src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java
+++ b/src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java
@@ -271,6 +271,15 @@
}
/**
+ * 平台全部信息---列表Test
+ */
+ @GetMapping("memberDataInfoAllAloneTest")
+ public FebsResponse memberDataInfoAllAloneTest(MemberEntity memberEntity, QueryRequest request) {
+ Map<String, Object> data = getDataTable(memberService.findMemberDataInfoAllAloneTestListInPage(memberEntity, request));
+ return new FebsResponse().success().data(data);
+ }
+
+ /**
* 用户详细信息---列表
* @return
*/
diff --git a/src/main/java/com/xcong/excoin/modules/member/controller/ViewController.java b/src/main/java/com/xcong/excoin/modules/member/controller/ViewController.java
index d368eb6..1b007d6 100644
--- a/src/main/java/com/xcong/excoin/modules/member/controller/ViewController.java
+++ b/src/main/java/com/xcong/excoin/modules/member/controller/ViewController.java
@@ -103,6 +103,15 @@
return FebsUtil.view("modules/member/memberDataInfoAllAlone");
}
/**
+ * 平台全部信息---列表Test
+ * @return
+ */
+ @GetMapping("memberDataInfoAllAloneTest")
+ @RequiresPermissions("memberDataInfoAllAloneTest:view")
+ public String memberDataInfoAllAloneTest() {
+ return FebsUtil.view("modules/member/memberDataInfoAllAloneTest");
+ }
+ /**
* 基础数据---查询
*/
@GetMapping("memberDataInfoLists/{id}")
diff --git a/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java b/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java
index 5bcfd42..e2abe3b 100644
--- a/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java
+++ b/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java
@@ -94,11 +94,13 @@
IPage<MemberEntity> findMemberAloneTestInPage(Page<MemberEntity> page, @Param("record") MemberEntity member);
IPage<MemberDataInfoVo> selectMemberDataInfoDtoListInPageAlone(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity);
+ IPage<MemberDataInfoVo> findMemberDataInfoAllAloneTestListInPage(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity);
IPage<MemberDataInfoVo> selectMemberDataInfoDtoRealListInPageAlone(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity);
IPage<MemberDataInfoVo> findMemberDataInfoAloneTestDtoListInPage(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity);
String selectTotalAmountUsdtBForBasicRealDataAlone();
String selectTotalAmountUsdtBForBasicRealTestDataAlone();
+ String selectTotalAmountUsdtBForBasicRealTestAllDataAlone();
String selectTotalAmountUsdtBForBasicData();
@@ -130,45 +132,59 @@
String selectTotalAmountUsdtSForBasicRealDataAlone();
String selectTotalAmountUsdtSForBasicRealTestDataAlone();
+ String selectTotalAmountUsdtSForBasicRealTestAllDataAlone();
String selectTotalAmountUsdtCZForBasicRealDataAlone();
String selectTotalAmountUsdtCZForBasicRealTestDataAlone();
+ String selectTotalAmountUsdtCZForBasicRealTestAllDataAlone();
String selectTotalAmountUsdtTXForBasicRealDataAlone();
String selectTotalAmountUsdtTXForBasicRealTestDataAlone();
+ String selectTotalAmountUsdtTXForBasicRealTestAllDataAlone();
String selectReturnMoneyForBasicRealDataAlone();
String selectReturnMoneyForBasicRealTestDataAlone();
+ String selectReturnMoneyForBasicRealTestAllDataAlone();
String selectClosingpriceForBasicRealDataAlone();
String selectClosingpriceForBasicRealTestDataAlone();
+ String selectClosingpriceForBasicRealTestAllDataAlone();
String selectSellClosingpriceForBasicRealDataAlone();
String selectSellClosingpriceForBasicRealTestDataAlone();
+ String selectSellClosingpriceForBasicRealTestAllDataAlone();
String selectRewardratioForBasicRealDataAlone();
String selectRewardratioForBasicRealTestDataAlone();
+ String selectRewardratioForBasicRealTestAllDataAlone();
String selectSFCCForBasicRealDataAlone();
String selectSFCCForBasicRealTestDataAlone();
+ String selectSFCCForBasicRealTestAllDataAlone();
String selectBBZHForBasicRealDataAlone();
String selectBBZHForBasicRealTestDataAlone();
+ String selectBBZHForBasicRealTestAllDataAlone();
String selectHYZHForBasicRealDataAlone();
String selectHYZHForBasicRealTestDataAlone();
+ String selectHYZHForBasicRealTestAllDataAlone();
String selectprepriceForBasicRealDataAlone();
String selectprepriceForBasicRealTestDataAlone();
+ String selectprepriceForBasicRealTestAllDataAlone();
String selectBBZCForBasicRealDataAlone();
String selectBBZCForBasicRealTestDataAlone();
+ String selectBBZCForBasicRealTestAllDataAlone();
String selectHYZCForBasicRealDataAlone();
String selectHYZCForBasicRealTestDataAlone();
+ String selectHYZCForBasicRealTestAllDataAlone();
String selectDLZCForBasicRealDataAlone();
String selectDLZCForBasicRealTestDataAlone();
+ String selectDLZCForBasicRealTestAllDataAlone();
String selectTotalAmountUsdtBForBasicAllDataAlone();
diff --git a/src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java b/src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java
index 6fdb3f9..7a5d3e1 100644
--- a/src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java
+++ b/src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java
@@ -91,4 +91,6 @@
IPage<MemberDataInfoVo> findMemberDataInfoAloneTestDtoListInPage(MemberEntity memberEntity, QueryRequest request);
+ IPage<MemberDataInfoVo> findMemberDataInfoAllAloneTestListInPage(MemberEntity memberEntity, QueryRequest request);
+
}
diff --git a/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java b/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java
index 9d4f831..aef4b35 100644
--- a/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java
+++ b/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java
@@ -1179,4 +1179,68 @@
return selectMemberListInPage;
}
+
+ @Override
+ public IPage<MemberDataInfoVo> findMemberDataInfoAllAloneTestListInPage(MemberEntity memberEntity,
+ QueryRequest request) {
+ Page<MemberEntity> page = new Page<>(request.getPageNum(), request.getPageSize());
+ IPage<MemberDataInfoVo> selectMemberListInPage = memberMapper.findMemberDataInfoAllAloneTestListInPage(page, memberEntity);
+ //USDT充币总额+USDT提币总额
+ String totalAmountUsdtB = memberMapper.selectTotalAmountUsdtBForBasicRealTestAllDataAlone();
+ String totalAmountUsdtS = memberMapper.selectTotalAmountUsdtSForBasicRealTestAllDataAlone();
+ //USDT充值总额+USDT提现总额
+ String totalAmountUsdtCZ = memberMapper.selectTotalAmountUsdtCZForBasicRealTestAllDataAlone();
+ String totalAmountUsdtTX = memberMapper.selectTotalAmountUsdtTXForBasicRealTestAllDataAlone();
+ //佣金
+ String returnMoneyByMid = memberMapper.selectReturnMoneyForBasicRealTestAllDataAlone();
+ //开仓手续费总额
+ String closingpriceByMid = memberMapper.selectClosingpriceForBasicRealTestAllDataAlone();
+ //平仓总手续费
+ String sellClosingpriceByMid = memberMapper.selectSellClosingpriceForBasicRealTestAllDataAlone();
+
+ //总盈亏
+ String rewardratioByMid = memberMapper.selectRewardratioForBasicRealTestAllDataAlone();
+
+ //持仓人数
+ String notNullNumber = memberMapper.selectSFCCForBasicRealTestAllDataAlone();
+ //币币账户不为空的人数
+ String walletNumber = memberMapper.selectBBZHForBasicRealTestAllDataAlone();
+ //合约账户不为空的人数
+ String walletCoinNumber = memberMapper.selectHYZHForBasicRealTestAllDataAlone();
+ //持仓手续费
+ String doingPrice = memberMapper.selectprepriceForBasicRealTestAllDataAlone();
+
+ //账户金额
+ String walletNum = memberMapper.selectBBZCForBasicRealTestAllDataAlone();
+ String walletCoinNum = memberMapper.selectHYZCForBasicRealTestAllDataAlone();
+ String agentNum = memberMapper.selectDLZCForBasicRealTestAllDataAlone();
+
+ double platformProfitAndLoss = 0 ;
+ platformProfitAndLoss = platformProfitAndLoss + (totalAmountUsdtB == null ? 0 : Double.parseDouble(totalAmountUsdtB));
+ platformProfitAndLoss = platformProfitAndLoss + (totalAmountUsdtCZ == null ? 0 : Double.parseDouble(totalAmountUsdtCZ));
+ platformProfitAndLoss = platformProfitAndLoss - (totalAmountUsdtS == null ? 0 : Double.parseDouble(totalAmountUsdtS));
+ platformProfitAndLoss = platformProfitAndLoss - (totalAmountUsdtTX == null ? 0 : Double.parseDouble(totalAmountUsdtTX));
+ List<MemberDataInfoVo> records = selectMemberListInPage.getRecords();
+ for(MemberDataInfoVo memberDataInfoVo : records) {
+ memberDataInfoVo.setChargeUsdt(totalAmountUsdtCZ == null ? 0 : Double.parseDouble(totalAmountUsdtCZ));
+ memberDataInfoVo.setAppealUsdt(totalAmountUsdtTX == null ? 0 : Double.parseDouble(totalAmountUsdtTX));
+ memberDataInfoVo.setChargeCoin(totalAmountUsdtB == null ? 0 : Double.parseDouble(totalAmountUsdtB));
+ memberDataInfoVo.setAppealCoin(totalAmountUsdtS == null ? 0 : Double.parseDouble(totalAmountUsdtS));
+ memberDataInfoVo.setClosingPrice(closingpriceByMid == null ? "0" : closingpriceByMid);
+ memberDataInfoVo.setSellClosingPrice(sellClosingpriceByMid == null ? "0" : sellClosingpriceByMid);
+ memberDataInfoVo.setFee(returnMoneyByMid == null ? "0" : returnMoneyByMid);
+ memberDataInfoVo.setYingkui(rewardratioByMid == null ? "0" : rewardratioByMid);
+ memberDataInfoVo.setNotNullNumber(notNullNumber == null ? "0" : notNullNumber);
+ memberDataInfoVo.setWalletNumber(walletNumber == null ? "0" : walletNumber);
+ memberDataInfoVo.setWalletCoinNumber(walletCoinNumber == null ? "0" : walletCoinNumber);
+ memberDataInfoVo.setPlatformProfitAndLoss(platformProfitAndLoss == 0 ? "0" : platformProfitAndLoss+"");
+ memberDataInfoVo.setDoingPrice(doingPrice == null ? "0" : doingPrice);
+ memberDataInfoVo.setWalletNum(walletNum == null ? "0" : walletNum);
+ memberDataInfoVo.setWalletCoinNum(walletCoinNum == null ? "0" : walletCoinNum);
+ memberDataInfoVo.setAgentNum(agentNum == null ? "0" : agentNum);
+ }
+ selectMemberListInPage.setTotal(1);
+ return selectMemberListInPage;
+ }
+
}
diff --git a/src/main/resources/mapper/modules/MemberMapper.xml b/src/main/resources/mapper/modules/MemberMapper.xml
index c0c6052..3bbf7c4 100644
--- a/src/main/resources/mapper/modules/MemberMapper.xml
+++ b/src/main/resources/mapper/modules/MemberMapper.xml
@@ -202,8 +202,13 @@
<select id="selectMemberDataInfoDtoListInPage" resultType="com.xcong.excoin.modules.member.vo.MemberDataInfoVo">
select COUNT(m.id) as memberCount from member m
</select>
+
<select id="selectMemberDataInfoDtoListInPageAlone" resultType="com.xcong.excoin.modules.member.vo.MemberDataInfoVo">
select COUNT(m.id) as memberCount from member m WHERE (FIND_IN_SET('22015141', m.referer_ids) or m.id = 10)
+ </select>
+
+ <select id="findMemberDataInfoAllAloneTestListInPage" resultType="com.xcong.excoin.modules.member.vo.MemberDataInfoVo">
+ select COUNT(m.id) as memberCount from member m WHERE (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
</select>
<select id="selectMemberDataInfoDtoRealListInPageAlone" resultType="com.xcong.excoin.modules.member.vo.MemberDataInfoVo">
@@ -262,6 +267,16 @@
s.symbol = 'USDT'
AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
and m.account_type = 1;
+ </select>
+ <select id="selectTotalAmountUsdtBForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(s.amount),'0') as amount
+ FROM
+ member_coin_charge s
+ LEFT JOIN member m ON m.id = s.member_id
+ where
+ s.symbol = 'USDT'
+ AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
</select>
<select id="selectTotalAmountUsdtBForBasicAllDataAlone" resultType="java.lang.String">
SELECT
@@ -334,6 +349,18 @@
AND a.is_inside = 'N'
AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
and m.account_type = 1;
+ </select>
+ <select id="selectTotalAmountUsdtSForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.amount),'0') as amount
+ FROM
+ member_coin_withdraw a
+
+ LEFT JOIN member m ON m.id = a.member_id
+ WHERE
+ a. STATUS = 2
+ AND a.is_inside = 'N'
+ AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
</select>
<select id="selectTotalAmountUsdtSForBasicAllDataAlone" resultType="java.lang.String">
SELECT
@@ -409,6 +436,17 @@
AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
and m.account_type = 1;
</select>
+ <select id="selectTotalAmountUsdtCZForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(amount_usdt),'0')
+ FROM
+ member_quick_buy_sale a
+ LEFT JOIN member m ON m.id = a.member_id
+ WHERE
+ a.order_type = 'B'
+ AND a.order_status = 3
+ AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
+ </select>
<select id="selectTotalAmountUsdtCZForBasicAllDataAlone" resultType="java.lang.String">
SELECT
IFNULL(SUM(amount_usdt),'0')
@@ -481,6 +519,17 @@
AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
and m.account_type = 1;
</select>
+ <select id="selectTotalAmountUsdtTXForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(amount_usdt),'0')
+ FROM
+ member_quick_buy_sale a
+ LEFT JOIN member m ON m.id = a.member_id
+ WHERE
+ a.order_type = 'S'
+ AND a.order_status = 2
+ AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
+ </select>
<select id="selectTotalAmountUsdtTXForBasicAllDataAlone" resultType="java.lang.String">
SELECT
IFNULL(SUM(amount_usdt),'0')
@@ -536,6 +585,19 @@
AND (FIND_IN_SET('22015141', m.referer_ids) or m.id = 10)
</select>
<select id="selectReturnMoneyForBasicRealTestDataAlone" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(s.amount), '0')
+ FROM
+ member_account_money_change s
+
+ LEFT JOIN member m ON m.id = s.member_id
+ WHERE
+ s.type = 3
+ AND s.content LIKE '%佣金到账%'
+ AND s. STATUS = '1'
+ AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
+ </select>
+ <select id="selectReturnMoneyForBasicRealTestAllDataAlone" resultType="java.lang.String">
SELECT
IFNULL(SUM(s.amount), '0')
FROM
@@ -615,6 +677,18 @@
AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
and m.account_type = 1;
</select>
+ <select id="selectClosingpriceForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.opening_fee_amount),'0')
+ FROM
+ contract_order a
+
+ LEFT JOIN member m ON m.id = a.member_id
+ WHERE
+ a.closing_type = '0'
+ and a.order_status = '1'
+ AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
+ </select>
<select id="selectClosingpriceForBasicAllDataAlone" resultType="java.lang.String">
SELECT
IFNULL(SUM(a.opening_fee_amount),'0')
@@ -690,6 +764,18 @@
AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
and m.account_type = 1;
</select>
+ <select id="selectSellClosingpriceForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.closing_fee_amount),'0')
+ FROM
+ contract_order a
+
+ LEFT JOIN member m ON m.id = a.member_id
+ WHERE
+ a.closing_type IN (2,3,4, 5, 6, 7, 8, 9)
+ and a.order_status = '1'
+ AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
+ </select>
<select id="selectSellClosingpriceForBasicAllDataAlone" resultType="java.lang.String">
SELECT
IFNULL(SUM(a.closing_fee_amount),'0')
@@ -762,6 +848,17 @@
AND a.order_status = '1'
AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
and m.account_type = 1;
+ </select>
+ <select id="selectRewardratioForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.reward_amount), '0')
+ FROM
+ contract_order a
+ LEFT JOIN member m ON m.id = a.member_id
+ WHERE
+ a.closing_type IN (2,3,4, 5, 6, 7, 8, 9)
+ AND a.order_status = '1'
+ AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
</select>
<select id="selectRewardratioForBasicAllDataAlone" resultType="java.lang.String">
SELECT
@@ -854,10 +951,29 @@
id
FROM
member m
- WHERE
- m.account_type = '1'
- AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
+ WHERE (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
and m.account_type = 1
+ )
+ GROUP BY
+ s.member_id
+ ) b
+ </select>
+ <select id="selectSFCCForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ COUNT(b.id)
+ FROM
+ (
+ SELECT
+ s.id
+ FROM
+ contract_hold_order s
+ WHERE
+ s.member_id IN (
+ SELECT
+ id
+ FROM
+ member m
+ WHERE (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
)
GROUP BY
s.member_id
@@ -944,6 +1060,17 @@
AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
and m.account_type = 1;
</select>
+ <select id="selectBBZHForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ COUNT(a.id)
+ FROM
+ member_wallet_coin a
+ LEFT JOIN member m ON m.id = a.member_id
+ WHERE
+ a.wallet_code = 'USDT'
+ AND a.available_balance > 1
+ AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
+ </select>
<select id="selectBBZHForBasicAllDataAlone" resultType="java.lang.String">
SELECT
COUNT(a.id)
@@ -1007,6 +1134,18 @@
AND a.total_balance > 1
AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
AND m.account_type = 1;
+ </select>
+ <select id="selectHYZHForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ COUNT(a.id)
+ FROM
+ member_wallet_contract a
+
+ LEFT JOIN member m ON m.id = a.member_id
+ WHERE
+ a.wallet_code = 'USDT'
+ AND a.total_balance > 1
+ AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
</select>
<select id="selectHYZHForBasicAllDataAlone" resultType="java.lang.String">
SELECT
@@ -1079,6 +1218,14 @@
WHERE (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
AND m.account_type = 1;
</select>
+ <select id="selectprepriceForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.hold_amount),'0')
+ FROM
+ contract_order a
+ LEFT JOIN member m ON m.id = a.member_id
+ WHERE (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
+ </select>
<select id="selectprepriceForBasicData" resultType="java.lang.String">
SELECT
IFNULL(SUM(a.hold_amount),'0')
@@ -1132,6 +1279,16 @@
a.wallet_code = 'USDT'
AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
and m.account_type = 1;
+ </select>
+ <select id="selectBBZCForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(available_balance),'0')
+ FROM
+ member_wallet_coin a
+ LEFT JOIN member m ON m.id = a.member_id
+ WHERE
+ a.wallet_code = 'USDT'
+ AND (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
</select>
<select id="selectBBZCForBasicAllDataAlone" resultType="java.lang.String">
SELECT
@@ -1195,6 +1352,15 @@
WHERE (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
and m.account_type = 1;
</select>
+ <select id="selectHYZCForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(total_balance),'0')
+ FROM
+ member_wallet_contract a
+
+ LEFT JOIN member m ON m.id = a.member_id
+ WHERE (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
+ </select>
<select id="selectHYZCForBasicAllDataAlone" resultType="java.lang.String">
SELECT
IFNULL(SUM(total_balance),'0')
@@ -1254,6 +1420,15 @@
WHERE (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
and m.account_type = 1;
</select>
+ <select id="selectDLZCForBasicRealTestAllDataAlone" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(total_balance),'0')
+ FROM
+ member_wallet_agent a
+
+ LEFT JOIN member m ON m.id = a.member_id
+ WHERE (m.id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)
+ </select>
<select id="selectDLZCForBasicAllDataAlone" resultType="java.lang.String">
SELECT
IFNULL(SUM(total_balance),'0')
diff --git a/src/main/resources/templates/febs/views/modules/member/memberDataInfoAllAloneTest.html b/src/main/resources/templates/febs/views/modules/member/memberDataInfoAllAloneTest.html
new file mode 100644
index 0000000..745a35e
--- /dev/null
+++ b/src/main/resources/templates/febs/views/modules/member/memberDataInfoAllAloneTest.html
@@ -0,0 +1,73 @@
+<div class="layui-fluid layui-anim febs-anim" id="febs-user" lay-title="平台全部数据">
+ <div class="layui-row febs-container">
+ <div class="layui-col-md12">
+ <div class="layui-card">
+ <div class="layui-card-body febs-table-full">
+ <table id=usersTable></table>
+ </div>
+ </div>
+ </div>
+ </div>
+</div>
+<!-- 表格操作栏 start -->
+<script type="text/html" id="user-option">
+ <span shiro:lacksPermission="user:view,user:update,user:delete">
+ <span class="layui-badge-dot febs-bg-orange"></span> 无权限
+ </span>
+</script>
+<!-- 表格操作栏 end -->
+<script data-th-inline="none" type="text/javascript">
+// 引入组件并初始化
+layui.use([ 'jquery', 'form', 'table', 'febs'], function () {
+ var $ = layui.jquery,
+ laydate = layui.laydate,
+ febs = layui.febs,
+ form = layui.form,
+ table = layui.table,
+ $view = $('#febs-user'),
+ tableIns;
+
+ form.render();
+ // 表格初始化
+ initTable();
+
+ function initTable() {
+
+ tableInss = febs.table.init({
+ elem: $('#usersTable'),
+ url: ctx + 'member/memberDataInfoAllAloneTest',
+ cols: [[
+ {field: 'memberCount', title: '注册用户数', minWidth: 120,align:'center'},
+ {field: 'notNullNumber', title: '持仓用户数', minWidth: 120,align:'center'},
+ {field: 'walletNumber', title: '币币账户有余额个数', minWidth: 200,align:'center'},
+ {field: 'walletNum', title: '币币账户余额', minWidth: 200,align:'center'},
+ {field: 'walletCoinNumber', title: '合约账户有余额个数', minWidth: 200,align:'center'},
+ {field: 'walletCoinNum', title: '合约账户余额', minWidth: 200,align:'center'},
+ {field: 'agentNum', title: '代理账户余额', minWidth: 200,align:'center'},
+ {field: 'platformProfitAndLoss', title: '平台剩余USDT',
+ templet: function (d) {
+ if (d.platformProfitAndLoss > '0') {
+ return '<span style="color:green;">'+d.platformProfitAndLoss+'</span>'
+ } else {
+ return '<span style="color:red;">'+d.platformProfitAndLoss+'</span>'
+ }
+ }, minWidth: 200,align:'center'},
+ {field: 'chargeCoin', title: '充币', minWidth: 200,align:'center'},
+ {field: 'appealCoin', title: '提币', minWidth: 200,align:'center'},
+ {field: 'fee', title: '佣金', minWidth: 200,align:'center'},
+ {field: 'closingPrice', title: '开仓手续费', minWidth: 200,align:'center'},
+ {field: 'sellClosingPrice', title: '平仓手续费', minWidth: 200,align:'center'},
+ {field: 'doingPrice', title: '持仓手续费', minWidth: 200,align:'center'},
+ {field: 'yingkui', title: '订单盈亏',
+ templet: function (d) {
+ if (d.yingkui > '0') {
+ return '<span style="color:green;">'+d.yingkui+'</span>'
+ } else {
+ return '<span style="color:red;">'+d.yingkui+'</span>'
+ }
+ }, minWidth: 200,align:'center'},
+ ]]
+ });
+ }
+})
+</script>
\ No newline at end of file
--
Gitblit v1.9.1