From 4520b70c8505d8f964a445b8b8ca5527335c57fd Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Mon, 20 Jul 2020 15:27:10 +0800
Subject: [PATCH] 20200720 代码提交
---
src/main/resources/templates/febs/views/modules/member/memberDataInfoAlone.html | 75 +++++++++
src/main/java/com/xcong/excoin/modules/member/controller/ViewController.java | 19 ++
src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java | 32 ++++
src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java | 4
src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java | 127 +++++++++++++++
src/main/resources/templates/febs/views/modules/member/memberDataInfoAll.html | 75 +++++++++
src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java | 18 ++
src/main/resources/mapper/modules/MemberMapper.xml | 119 ++++++++++++++
8 files changed, 469 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 053139d..5d87b15 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
@@ -204,6 +204,24 @@
}
/**
+ * 平台全部信息---列表
+ */
+ @GetMapping("memberDataInfoAll")
+ public FebsResponse memberDataInfoAll(MemberEntity memberEntity, QueryRequest request) {
+ Map<String, Object> data = getDataTable(memberService.findMemberDataInfoAllInPage(memberEntity, request));
+ return new FebsResponse().success().data(data);
+ }
+
+ /**
+ * 平台详细信息---列表alone
+ */
+ @GetMapping("memberDataInfoAlone")
+ public FebsResponse memberDataInfoAlone(MemberEntity memberEntity, QueryRequest request) {
+ Map<String, Object> data = getDataTable(memberService.findMemberDataInfoAloneDtoListInPage(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 96a9556..3791287 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
@@ -65,6 +65,25 @@
public String memberDataInfo() {
return FebsUtil.view("modules/member/memberDataInfo");
}
+
+ /**
+ * 平台全部信息
+ * @return
+ */
+ @GetMapping("memberDataInfoAll")
+ @RequiresPermissions("memberDataInfoAll:view")
+ public String memberDataInfoAll() {
+ return FebsUtil.view("modules/member/memberDataInfoAll");
+ }
+ /**
+ * 平台详细信息---列表alone
+ * @return
+ */
+ @GetMapping("memberDataInfoAlone")
+ @RequiresPermissions("memberDataInfoAlone:view")
+ public String memberDataInfoAlone() {
+ return FebsUtil.view("modules/member/memberDataInfoAlone");
+ }
/**
* 基础数据---查询
*/
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 828933f..e303696 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
@@ -90,5 +90,37 @@
String selectDLZCForBasicRealDataBymemberId(Long memberId);
IPage<MemberEntity> findMemberAloneInPage(Page<MemberEntity> page, @Param("record") MemberEntity member);
+
+ IPage<MemberDataInfoVo> selectMemberDataInfoDtoListInPageAlone(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity);
+
+ String selectTotalAmountUsdtBForBasicRealDataAlone();
+
+ String selectTotalAmountUsdtBForBasicData();
+
+ String selectTotalAmountUsdtSForBasicData();
+
+ String selectTotalAmountUsdtCZForBasicData();
+
+ String selectTotalAmountUsdtTXForBasicData();
+
+ String selectClosingpriceForBasicData();
+
+ String selectSellClosingpriceForBasicData();
+
+ String selectRewardratioForBasicData();
+
+ String selectSFCCForBasicData();
+
+ String selectBBZHForBasicData();
+
+ String selectHYZHForBasicData();
+
+ String selectprepriceForBasicData();
+
+ String selectBBZCForBasicData();
+
+ String selectHYZCForBasicData();
+
+ String selectDLZCForBasicData();
}
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 f783b72..667bcbd 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
@@ -74,4 +74,8 @@
IPage<MemberEntity> findMemberAloneInPage(MemberEntity member, QueryRequest request);
+ IPage<MemberDataInfoVo> findMemberDataInfoAloneDtoListInPage(MemberEntity memberEntity, QueryRequest request);
+
+ IPage<MemberDataInfoVo> findMemberDataInfoAllInPage(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 7890ecc..5e20ef9 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
@@ -807,4 +807,131 @@
return selectMemberListInPage;
}
+
+ @Override
+ public IPage<MemberDataInfoVo> findMemberDataInfoAloneDtoListInPage(MemberEntity memberEntity,
+ QueryRequest request) {
+ Page<MemberEntity> page = new Page<>(request.getPageNum(), request.getPageSize());
+ IPage<MemberDataInfoVo> selectMemberListInPage = memberMapper.selectMemberDataInfoDtoListInPageAlone(page, memberEntity);
+ //USDT充币总额+USDT提币总额
+ String totalAmountUsdtB = memberMapper.selectTotalAmountUsdtBForBasicRealDataAlone();
+ String totalAmountUsdtS = memberMapper.selectTotalAmountUsdtSForBasicRealData();
+ //USDT充值总额+USDT提现总额
+ String totalAmountUsdtCZ = memberMapper.selectTotalAmountUsdtCZForBasicRealData();
+ String totalAmountUsdtTX = memberMapper.selectTotalAmountUsdtTXForBasicRealData();
+ //佣金
+ String returnMoneyByMid = memberMapper.selectReturnMoneyForBasicRealData();
+ //开仓手续费总额
+ String closingpriceByMid = memberMapper.selectClosingpriceForBasicRealData();
+ //平仓总手续费
+ String sellClosingpriceByMid = memberMapper.selectSellClosingpriceForBasicRealData();
+
+ //总盈亏
+ String rewardratioByMid = memberMapper.selectRewardratioForBasicRealData();
+
+ //持仓人数
+ String notNullNumber = memberMapper.selectSFCCForBasicRealData();
+ //币币账户不为空的人数
+ String walletNumber = memberMapper.selectBBZHForBasicRealData();
+ //合约账户不为空的人数
+ String walletCoinNumber = memberMapper.selectHYZHForBasicRealData();
+ //持仓手续费
+ String doingPrice = memberMapper.selectprepriceForBasicRealData();
+
+ //账户金额
+ String walletNum = memberMapper.selectBBZCForBasicRealData();
+ String walletCoinNum = memberMapper.selectHYZCForBasicRealData();
+ String agentNum = memberMapper.selectDLZCForBasicRealData();
+
+ 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;
+ }
+
+
+ @Override
+ public IPage<MemberDataInfoVo> findMemberDataInfoAllInPage(MemberEntity memberEntity, QueryRequest request) {
+ Page<MemberEntity> page = new Page<>(request.getPageNum(), request.getPageSize());
+ IPage<MemberDataInfoVo> selectMemberListInPage = memberMapper.selectMemberDataInfoDtoListInPage(page, memberEntity);
+ //USDT充币总额+USDT提币总额
+ String totalAmountUsdtB = memberMapper.selectTotalAmountUsdtBForBasicData();
+ String totalAmountUsdtS = memberMapper.selectTotalAmountUsdtSForBasicData();
+ //USDT充值总额+USDT提现总额
+ String totalAmountUsdtCZ = memberMapper.selectTotalAmountUsdtCZForBasicData();
+ String totalAmountUsdtTX = memberMapper.selectTotalAmountUsdtTXForBasicData();
+ //佣金
+ String returnMoneyByMid = memberMapper.selectReturnMoneyForBasicRealData();
+ //开仓手续费总额
+ String closingpriceByMid = memberMapper.selectClosingpriceForBasicData();
+ //平仓总手续费
+ String sellClosingpriceByMid = memberMapper.selectSellClosingpriceForBasicData();
+
+ //总盈亏
+ String rewardratioByMid = memberMapper.selectRewardratioForBasicData();
+
+ //持仓人数
+ String notNullNumber = memberMapper.selectSFCCForBasicData();
+ //币币账户不为空的人数
+ String walletNumber = memberMapper.selectBBZHForBasicData();
+ //合约账户不为空的人数
+ String walletCoinNumber = memberMapper.selectHYZHForBasicData();
+ //持仓手续费
+ String doingPrice = memberMapper.selectprepriceForBasicData();
+
+ //账户金额
+ String walletNum = memberMapper.selectBBZCForBasicData();
+ String walletCoinNum = memberMapper.selectHYZCForBasicData();
+ String agentNum = memberMapper.selectDLZCForBasicData();
+
+ 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 18cf367..3581863 100644
--- a/src/main/resources/mapper/modules/MemberMapper.xml
+++ b/src/main/resources/mapper/modules/MemberMapper.xml
@@ -128,6 +128,14 @@
AND account_status = '1'
)
</select>
+ <select id="selectTotalAmountUsdtBForBasicData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.amount),'0') as amount
+ FROM
+ member_coin_charge a
+ WHERE
+ a.symbol = 'USDT'
+ </select>
<select id="selectTotalAmountUsdtSForBasicRealDataBymemberId" resultType="java.lang.String">
SELECT
IFNULL(SUM(a.amount),'0') as amount
@@ -154,6 +162,15 @@
account_type = '2'
AND account_status = '1'
)
+ </select>
+ <select id="selectTotalAmountUsdtSForBasicData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.amount),'0') as amount
+ FROM
+ member_coin_withdraw a
+ WHERE
+ a. STATUS = 2
+ AND a.is_inside = 'N'
</select>
<select id="selectTotalAmountUsdtCZForBasicRealDataBymemberId" resultType="java.lang.String">
@@ -184,6 +201,15 @@
AND account_status = '1'
)
</select>
+ <select id="selectTotalAmountUsdtCZForBasicData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(amount_usdt),'0')
+ FROM
+ member_quick_buy_sale
+ WHERE
+ order_type = 'B'
+ AND order_status = 3
+ </select>
<select id="selectTotalAmountUsdtTXForBasicRealDataBymemberId" resultType="java.lang.String">
SELECT
IFNULL(SUM(amount_usdt),'0')
@@ -211,6 +237,15 @@
account_type = '2'
AND account_status = '1'
)
+ </select>
+ <select id="selectTotalAmountUsdtTXForBasicData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(amount_usdt),'0')
+ FROM
+ member_quick_buy_sale
+ WHERE
+ order_type = 'S'
+ AND order_status = 2
</select>
<select id="selectReturnMoneyForBasicRealDataBymemberId" resultType="java.lang.String">
SELECT
@@ -261,6 +296,15 @@
AND account_status = '1'
)
</select>
+ <select id="selectClosingpriceForBasicData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.opening_fee_amount),'0')
+ FROM
+ contract_order a
+ WHERE
+ a.closing_type = '0'
+ and a.order_status = '1'
+ </select>
<select id="selectSellClosingpriceForBasicRealDataBymemberId" resultType="java.lang.String">
SELECT
IFNULL(SUM(a.closing_fee_amount),'0')
@@ -289,6 +333,15 @@
AND account_status = '1'
)
</select>
+ <select id="selectSellClosingpriceForBasicData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.closing_fee_amount),'0')
+ FROM
+ contract_order a
+ WHERE
+ a.closing_type IN (2,3,4, 5, 6, 7, 8, 9)
+ and a.order_status = '1'
+ </select>
<select id="selectRewardratioForBasicRealDataBymemberId" resultType="java.lang.String">
SELECT
IFNULL(SUM(a.reward_amount), '0')
@@ -316,6 +369,15 @@
account_type = '2'
AND account_status = '1'
)
+ </select>
+ <select id="selectRewardratioForBasicData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.reward_amount), '0')
+ FROM
+ contract_order a
+ WHERE
+ a.closing_type IN (2,3,4, 5, 6, 7, 8, 9)
+ AND a.order_status = '1'
</select>
<select id="selectRewardratioForBasicRealDataBymid" resultType="java.lang.String">
SELECT
@@ -349,6 +411,19 @@
s.member_id
) b
</select>
+ <select id="selectSFCCForBasicData" resultType="java.lang.String">
+ SELECT
+ COUNT(b.id)
+ FROM
+ (
+ SELECT
+ s.id
+ FROM
+ contract_hold_order s
+ GROUP BY
+ s.member_id
+ ) b
+ </select>
<select id="selectBBZHForBasicRealData" resultType="java.lang.String">
SELECT
COUNT(a.id)
@@ -367,6 +442,15 @@
AND account_status = '1'
)
</select>
+ <select id="selectBBZHForBasicData" resultType="java.lang.String">
+ SELECT
+ COUNT(a.id)
+ FROM
+ member_wallet_coin a
+ WHERE
+ a.wallet_code = 'USDT'
+ AND a.available_balance > 1
+ </select>
<select id="selectHYZHForBasicRealData" resultType="java.lang.String">
SELECT
COUNT(a.id)
@@ -384,6 +468,15 @@
account_type = '2'
AND account_status = '1'
)
+ </select>
+ <select id="selectHYZHForBasicData" resultType="java.lang.String">
+ SELECT
+ COUNT(a.id)
+ FROM
+ member_wallet_contract a
+ WHERE
+ a.wallet_code = 'USDT'
+ AND a.total_balance > 1
</select>
<select id="selectprepriceForBasicRealDataBymemberId" resultType="java.lang.String">
SELECT
@@ -408,6 +501,12 @@
account_type = '2'
AND account_status = '1'
)
+ </select>
+ <select id="selectprepriceForBasicData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.hold_amount),'0')
+ FROM
+ contract_order a
</select>
<select id="selectBBZCForBasicRealDataBymemberId" resultType="java.lang.String">
SELECT
@@ -435,6 +534,14 @@
AND account_status = '1'
)
</select>
+ <select id="selectBBZCForBasicData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(available_balance),'0')
+ FROM
+ member_wallet_coin
+ WHERE
+ wallet_code = 'USDT'
+ </select>
<select id="selectHYZCForBasicRealDataBymemberId" resultType="java.lang.String">
SELECT
IFNULL(SUM(total_balance),'0')
@@ -459,6 +566,12 @@
AND account_status = '1'
)
</select>
+ <select id="selectHYZCForBasicData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(total_balance),'0')
+ FROM
+ member_wallet_contract
+ </select>
<select id="selectDLZCForBasicRealDataBymemberId" resultType="java.lang.String">
SELECT
IFNULL(SUM(total_balance),'0')
@@ -483,6 +596,12 @@
AND account_status = '1'
)
</select>
+ <select id="selectDLZCForBasicData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(total_balance),'0')
+ FROM
+ member_wallet_agent
+ </select>
<select id="selectMemberBylowLevelInviteId" resultType="java.lang.String">
select id from member where FIND_IN_SET(#{inviteId},referer_ids)
diff --git a/src/main/resources/templates/febs/views/modules/member/memberDataInfoAll.html b/src/main/resources/templates/febs/views/modules/member/memberDataInfoAll.html
new file mode 100644
index 0000000..c7b122a
--- /dev/null
+++ b/src/main/resources/templates/febs/views/modules/member/memberDataInfoAll.html
@@ -0,0 +1,75 @@
+<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/memberDataInfoAll',
+ 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'},
+ {field: 'chargeUsdt', title: 'usdt充值', minWidth: 200,align:'center'},
+ {field: 'appealUsdt', title: 'usdt提现', minWidth: 200,align:'center'},
+ ]]
+ });
+ }
+})
+</script>
\ No newline at end of file
diff --git a/src/main/resources/templates/febs/views/modules/member/memberDataInfoAlone.html b/src/main/resources/templates/febs/views/modules/member/memberDataInfoAlone.html
new file mode 100644
index 0000000..02931f9
--- /dev/null
+++ b/src/main/resources/templates/febs/views/modules/member/memberDataInfoAlone.html
@@ -0,0 +1,75 @@
+<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/memberDataInfoAlone',
+ 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'},
+ {field: 'chargeUsdt', title: 'usdt充值', minWidth: 200,align:'center'},
+ {field: 'appealUsdt', title: 'usdt提现', minWidth: 200,align:'center'},
+ ]]
+ });
+ }
+})
+</script>
\ No newline at end of file
--
Gitblit v1.9.1