From c05761827519b3406d46f008816f03ad3fb39404 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Thu, 23 Jul 2020 17:24:01 +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/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/templates/febs/views/modules/member/memberDataInfoAloneTest.html | 73 ++++++++++
src/main/resources/mapper/modules/MemberMapper.xml | 194 +++++++++++++++++++++++++++
7 files changed, 367 insertions(+), 0 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 2f16167..6489673 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
@@ -253,6 +253,15 @@
}
/**
+ * 平台详细信息---列表Test
+ */
+ @GetMapping("memberDataInfoAloneTest")
+ public FebsResponse memberDataInfoAloneTest(MemberEntity memberEntity, QueryRequest request) {
+ Map<String, Object> data = getDataTable(memberService.findMemberDataInfoAloneTestDtoListInPage(memberEntity, request));
+ return new FebsResponse().success().data(data);
+ }
+
+ /**
* 平台全部信息---列表alone
*/
@GetMapping("memberDataInfoAllAlone")
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 c442e92..d368eb6 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
@@ -85,6 +85,15 @@
return FebsUtil.view("modules/member/memberDataInfoAlone");
}
/**
+ * 平台详细信息---列表Test
+ * @return
+ */
+ @GetMapping("memberDataInfoAloneTest")
+ @RequiresPermissions("memberDataInfoAloneTest:view")
+ public String memberDataInfoAloneTest() {
+ return FebsUtil.view("modules/member/memberDataInfoAloneTest");
+ }
+ /**
* 平台全部信息---列表alone
* @return
*/
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 30f87b9..5bcfd42 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
@@ -95,8 +95,10 @@
IPage<MemberDataInfoVo> selectMemberDataInfoDtoListInPageAlone(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 selectTotalAmountUsdtBForBasicData();
@@ -127,32 +129,46 @@
String selectDLZCForBasicData();
String selectTotalAmountUsdtSForBasicRealDataAlone();
+ String selectTotalAmountUsdtSForBasicRealTestDataAlone();
String selectTotalAmountUsdtCZForBasicRealDataAlone();
+ String selectTotalAmountUsdtCZForBasicRealTestDataAlone();
String selectTotalAmountUsdtTXForBasicRealDataAlone();
+ String selectTotalAmountUsdtTXForBasicRealTestDataAlone();
String selectReturnMoneyForBasicRealDataAlone();
+ String selectReturnMoneyForBasicRealTestDataAlone();
String selectClosingpriceForBasicRealDataAlone();
+ String selectClosingpriceForBasicRealTestDataAlone();
String selectSellClosingpriceForBasicRealDataAlone();
+ String selectSellClosingpriceForBasicRealTestDataAlone();
String selectRewardratioForBasicRealDataAlone();
+ String selectRewardratioForBasicRealTestDataAlone();
String selectSFCCForBasicRealDataAlone();
+ String selectSFCCForBasicRealTestDataAlone();
String selectBBZHForBasicRealDataAlone();
+ String selectBBZHForBasicRealTestDataAlone();
String selectHYZHForBasicRealDataAlone();
+ String selectHYZHForBasicRealTestDataAlone();
String selectprepriceForBasicRealDataAlone();
+ String selectprepriceForBasicRealTestDataAlone();
String selectBBZCForBasicRealDataAlone();
+ String selectBBZCForBasicRealTestDataAlone();
String selectHYZCForBasicRealDataAlone();
+ String selectHYZCForBasicRealTestDataAlone();
String selectDLZCForBasicRealDataAlone();
+ String selectDLZCForBasicRealTestDataAlone();
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 1315b5e..6fdb3f9 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
@@ -89,4 +89,6 @@
IPage<MemberEntity> findMemberAloneTestInPage(MemberEntity member, QueryRequest request);
+ IPage<MemberDataInfoVo> findMemberDataInfoAloneTestDtoListInPage(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 06ce417..9d4f831 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
@@ -1115,4 +1115,68 @@
return selectMemberListInPage;
}
+
+ @Override
+ public IPage<MemberDataInfoVo> findMemberDataInfoAloneTestDtoListInPage(MemberEntity memberEntity,
+ QueryRequest request) {
+ Page<MemberEntity> page = new Page<>(request.getPageNum(), request.getPageSize());
+ IPage<MemberDataInfoVo> selectMemberListInPage = memberMapper.findMemberDataInfoAloneTestDtoListInPage(page, memberEntity);
+ //USDT充币总额+USDT提币总额
+ String totalAmountUsdtB = memberMapper.selectTotalAmountUsdtBForBasicRealTestDataAlone();
+ String totalAmountUsdtS = memberMapper.selectTotalAmountUsdtSForBasicRealTestDataAlone();
+ //USDT充值总额+USDT提现总额
+ String totalAmountUsdtCZ = memberMapper.selectTotalAmountUsdtCZForBasicRealTestDataAlone();
+ String totalAmountUsdtTX = memberMapper.selectTotalAmountUsdtTXForBasicRealTestDataAlone();
+ //佣金
+ String returnMoneyByMid = memberMapper.selectReturnMoneyForBasicRealTestDataAlone();
+ //开仓手续费总额
+ String closingpriceByMid = memberMapper.selectClosingpriceForBasicRealTestDataAlone();
+ //平仓总手续费
+ String sellClosingpriceByMid = memberMapper.selectSellClosingpriceForBasicRealTestDataAlone();
+
+ //总盈亏
+ String rewardratioByMid = memberMapper.selectRewardratioForBasicRealTestDataAlone();
+
+ //持仓人数
+ String notNullNumber = memberMapper.selectSFCCForBasicRealTestDataAlone();
+ //币币账户不为空的人数
+ String walletNumber = memberMapper.selectBBZHForBasicRealTestDataAlone();
+ //合约账户不为空的人数
+ String walletCoinNumber = memberMapper.selectHYZHForBasicRealTestDataAlone();
+ //持仓手续费
+ String doingPrice = memberMapper.selectprepriceForBasicRealTestDataAlone();
+
+ //账户金额
+ String walletNum = memberMapper.selectBBZCForBasicRealTestDataAlone();
+ String walletCoinNum = memberMapper.selectHYZCForBasicRealTestDataAlone();
+ String agentNum = memberMapper.selectDLZCForBasicRealTestDataAlone();
+
+ 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 720a828..c0c6052 100644
--- a/src/main/resources/mapper/modules/MemberMapper.xml
+++ b/src/main/resources/mapper/modules/MemberMapper.xml
@@ -210,6 +210,10 @@
select COUNT(m.id) as memberCount from member m WHERE (FIND_IN_SET('22015141', m.referer_ids) or m.id = 10) and m.account_type = 1
</select>
+ <select id="findMemberDataInfoAloneTestDtoListInPage" 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) and m.account_type = 1
+ </select>
+
<select id="selectTotalAmountUsdtBForBasicRealDataBymemberId" resultType="java.lang.String">
SELECT
IFNULL(SUM(a.amount),'0') as amount
@@ -245,6 +249,18 @@
where
s.symbol = 'USDT'
AND FIND_IN_SET('22015141', m.referer_ids)
+ and m.account_type = 1;
+ </select>
+
+ <select id="selectTotalAmountUsdtBForBasicRealTestDataAlone" 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)
and m.account_type = 1;
</select>
<select id="selectTotalAmountUsdtBForBasicAllDataAlone" resultType="java.lang.String">
@@ -303,6 +319,20 @@
a. STATUS = 2
AND a.is_inside = 'N'
AND FIND_IN_SET('22015141', m.referer_ids)
+ and m.account_type = 1;
+ </select>
+
+ <select id="selectTotalAmountUsdtSForBasicRealTestDataAlone" 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)
and m.account_type = 1;
</select>
<select id="selectTotalAmountUsdtSForBasicAllDataAlone" resultType="java.lang.String">
@@ -367,6 +397,18 @@
AND FIND_IN_SET('22015141', m.referer_ids)
and m.account_type = 1;
</select>
+ <select id="selectTotalAmountUsdtCZForBasicRealTestDataAlone" 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)
+ and m.account_type = 1;
+ </select>
<select id="selectTotalAmountUsdtCZForBasicAllDataAlone" resultType="java.lang.String">
SELECT
IFNULL(SUM(amount_usdt),'0')
@@ -427,6 +469,18 @@
AND FIND_IN_SET('22015141', m.referer_ids)
and m.account_type = 1;
</select>
+ <select id="selectTotalAmountUsdtTXForBasicRealTestDataAlone" 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)
+ and m.account_type = 1;
+ </select>
<select id="selectTotalAmountUsdtTXForBasicAllDataAlone" resultType="java.lang.String">
SELECT
IFNULL(SUM(amount_usdt),'0')
@@ -481,6 +535,19 @@
AND s. STATUS = '1'
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="selectReturnMoneyForBasicAllDataAlone" resultType="java.lang.String">
SELECT
IFNULL(SUM(s.amount), '0')
@@ -533,6 +600,19 @@
a.closing_type = '0'
and a.order_status = '1'
AND FIND_IN_SET('22015141', m.referer_ids)
+ and m.account_type = 1;
+ </select>
+ <select id="selectClosingpriceForBasicRealTestDataAlone" 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)
and m.account_type = 1;
</select>
<select id="selectClosingpriceForBasicAllDataAlone" resultType="java.lang.String">
@@ -597,6 +677,19 @@
AND FIND_IN_SET('22015141', m.referer_ids)
and m.account_type = 1;
</select>
+ <select id="selectSellClosingpriceForBasicRealTestDataAlone" 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)
+ and m.account_type = 1;
+ </select>
<select id="selectSellClosingpriceForBasicAllDataAlone" resultType="java.lang.String">
SELECT
IFNULL(SUM(a.closing_fee_amount),'0')
@@ -656,6 +749,18 @@
a.closing_type IN (2,3,4, 5, 6, 7, 8, 9)
AND a.order_status = '1'
AND FIND_IN_SET('22015141', m.referer_ids)
+ and m.account_type = 1;
+ </select>
+ <select id="selectRewardratioForBasicRealTestDataAlone" 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)
and m.account_type = 1;
</select>
<select id="selectRewardratioForBasicAllDataAlone" resultType="java.lang.String">
@@ -734,6 +839,30 @@
s.member_id
) b
</select>
+ <select id="selectSFCCForBasicRealTestDataAlone" 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.account_type = '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
+ )
+ GROUP BY
+ s.member_id
+ ) b
+ </select>
<select id="selectSFCCForBasicAllDataAlone" resultType="java.lang.String">
SELECT
COUNT(b.id)
@@ -803,6 +932,18 @@
AND FIND_IN_SET('22015141', m.referer_ids)
and m.account_type = 1;
</select>
+ <select id="selectBBZHForBasicRealTestDataAlone" 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)
+ and m.account_type = 1;
+ </select>
<select id="selectBBZHForBasicAllDataAlone" resultType="java.lang.String">
SELECT
COUNT(a.id)
@@ -852,6 +993,19 @@
a.wallet_code = 'USDT'
AND a.total_balance > 1
AND FIND_IN_SET('22015141', m.referer_ids)
+ AND m.account_type = 1;
+ </select>
+ <select id="selectHYZHForBasicRealTestDataAlone" 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)
AND m.account_type = 1;
</select>
<select id="selectHYZHForBasicAllDataAlone" resultType="java.lang.String">
@@ -916,6 +1070,15 @@
WHERE FIND_IN_SET('22015141', m.referer_ids)
AND m.account_type = 1;
</select>
+ <select id="selectprepriceForBasicRealTestDataAlone" 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)
+ AND m.account_type = 1;
+ </select>
<select id="selectprepriceForBasicData" resultType="java.lang.String">
SELECT
IFNULL(SUM(a.hold_amount),'0')
@@ -957,6 +1120,17 @@
WHERE
a.wallet_code = 'USDT'
AND FIND_IN_SET('22015141', m.referer_ids)
+ and m.account_type = 1;
+ </select>
+ <select id="selectBBZCForBasicRealTestDataAlone" 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)
and m.account_type = 1;
</select>
<select id="selectBBZCForBasicAllDataAlone" resultType="java.lang.String">
@@ -1011,6 +1185,16 @@
WHERE FIND_IN_SET('22015141', m.referer_ids)
and m.account_type = 1;
</select>
+ <select id="selectHYZCForBasicRealTestDataAlone" 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)
+ and m.account_type = 1;
+ </select>
<select id="selectHYZCForBasicAllDataAlone" resultType="java.lang.String">
SELECT
IFNULL(SUM(total_balance),'0')
@@ -1060,6 +1244,16 @@
WHERE FIND_IN_SET('22015141', m.referer_ids)
and m.account_type = 1;
</select>
+ <select id="selectDLZCForBasicRealTestDataAlone" 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)
+ and m.account_type = 1;
+ </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/memberDataInfoAloneTest.html b/src/main/resources/templates/febs/views/modules/member/memberDataInfoAloneTest.html
new file mode 100644
index 0000000..5905fc2
--- /dev/null
+++ b/src/main/resources/templates/febs/views/modules/member/memberDataInfoAloneTest.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/memberDataInfoAloneTest',
+ 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