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