| | |
|---|
| | | 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; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | @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; |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
