From ec4ca023553f76dcb518e06ccf728e86a48e08fd Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Thu, 15 Oct 2020 17:10:21 +0800
Subject: [PATCH] 20201015
---
src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java | 452 ++++++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 390 insertions(+), 62 deletions(-)
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 30f4b47..e169a91 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
@@ -1,62 +1,390 @@
-package com.xcong.excoin.modules.member.mapper;
-
-import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.baomidou.mybatisplus.core.metadata.IPage;
-import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
-import com.xcong.excoin.modules.member.entity.MemberEntity;
-import com.xcong.excoin.modules.member.vo.MemberDataInfoVo;
-import com.xcong.excoin.modules.trademanage.vo.MemberAccountInfoVo;
-
-import org.apache.ibatis.annotations.Param;
-
-/**
- * @author wzy
- * @date 2020-06-10
- **/
-public interface MemberMapper extends BaseMapper<MemberEntity> {
-
- IPage<MemberEntity> selectMemberListInPage(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity);
-
- IPage<MemberDataInfoVo> selectMemberDataInfoDtoListInPage(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity);
-
- IPage<MemberAccountInfoVo> findMemberAccountInfoListInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
-
- String selectAgentForAccount(long memberId);
-
- String selectTradeSetting();
-
- String selectMemberDataInfoCount();
-
- String selectTotalAmountUsdtBForBasicRealData();
-
- String selectTotalAmountUsdtSForBasicRealData();
-
- String selectTotalAmountUsdtCZForBasicRealData();
-
- String selectTotalAmountUsdtTXForBasicRealData();
-
- String selectReturnMoneyForBasicRealData();
-
- String selectClosingpriceForBasicRealData();
-
- String selectSellClosingpriceForBasicRealData();
-
- String selectRewardratioForBasicRealData();
-
- String selectZCYHForBasicRealData();
-
- String selectSFCCForBasicRealData();
-
- String selectBBZHForBasicRealData();
-
- String selectHYZHForBasicRealData();
-
- String selectprepriceForBasicRealData();
-
- String selectBBZCForBasicRealData();
-
- String selectHYZCForBasicRealData();
-
- String selectDLZCForBasicRealData();
-
-}
+package com.xcong.excoin.modules.member.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.xcong.excoin.modules.member.entity.MemberEntity;
+import com.xcong.excoin.modules.member.vo.MemberDataInfoVo;
+import com.xcong.excoin.modules.trademanage.vo.MemberAccountInfoVo;
+
+import java.util.List;
+
+import org.apache.ibatis.annotations.Param;
+
+/**
+ * @author wzy
+ * @date 2020-06-10
+ **/
+public interface MemberMapper extends BaseMapper<MemberEntity> {
+
+ IPage<MemberEntity> selectMemberListInPage(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity);
+
+ IPage<MemberDataInfoVo> selectMemberDataInfoDtoListInPage(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity);
+
+ IPage<MemberAccountInfoVo> findMemberAccountInfoListInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ String selectAgentForAccount(long memberId);
+
+ String selectTradeSetting();
+
+ String selectMemberDataInfoCount();
+
+ String selectTotalAmountUsdtBForBasicRealData();
+
+ String selectTotalAmountUsdtSForBasicRealData();
+
+ String selectTotalAmountUsdtCZForBasicRealData();
+
+ String selectTotalAmountUsdtTXForBasicRealData();
+
+ String selectReturnMoneyForBasicRealData();
+
+ String selectClosingpriceForBasicRealData();
+
+ String selectSellClosingpriceForBasicRealData();
+
+ String selectRewardratioForBasicRealData();
+
+ String selectZCYHForBasicRealData();
+
+ String selectSFCCForBasicRealData();
+
+ String selectBBZHForBasicRealData();
+
+ String selectHYZHForBasicRealData();
+
+ String selectprepriceForBasicRealData();
+
+ String selectBBZCForBasicRealData();
+
+ String selectHYZCForBasicRealData();
+
+ String selectDLZCForBasicRealData();
+
+ List<String> selectMemberBylowLevelInviteId(String lowLevelInviteId);
+
+ String selectRewardratioForBasicRealDataBymid(Long memberId);
+
+ String selectTotalAmountUsdtBForBasicRealDataBymemberId(Long memberId);
+
+ String selectTotalAmountUsdtSForBasicRealDataBymemberId(Long memberId);
+
+ String selectTotalAmountUsdtCZForBasicRealDataBymemberId(Long memberId);
+
+ String selectTotalAmountUsdtTXForBasicRealDataBymemberId(Long memberId);
+
+ String selectReturnMoneyForBasicRealDataBymemberId(Long memberId);
+
+ String selectClosingpriceForBasicRealDataBymemberId(Long memberId);
+
+ String selectSellClosingpriceForBasicRealDataBymemberId(Long memberId);
+
+ String selectRewardratioForBasicRealDataBymemberId(Long memberId);
+
+ String selectprepriceForBasicRealDataBymemberId(Long memberId);
+
+ String selectBBZCForBasicRealDataBymemberId(Long memberId);
+
+ String selectHYZCForBasicRealDataBymemberId(Long memberId);
+
+ String selectDLZCForBasicRealDataBymemberId(Long memberId);
+
+ IPage<MemberEntity> findMemberAloneInPage(Page<MemberEntity> page, @Param("record") MemberEntity member);
+
+ 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();
+
+ 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();
+
+ 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();
+
+ String selectTotalAmountUsdtSForBasicAllDataAlone();
+
+ String selectTotalAmountUsdtCZForBasicAllDataAlone();
+
+ String selectTotalAmountUsdtTXForBasicAllDataAlone();
+
+ String selectReturnMoneyForBasicAllDataAlone();
+
+ String selectClosingpriceForBasicAllDataAlone();
+
+ String selectSellClosingpriceForBasicAllDataAlone();
+
+ String selectRewardratioForBasicAllDataAlone();
+
+ String selectSFCCForBasicAllDataAlone();
+
+ String selectBBZHForBasicAllDataAlone();
+
+ String selectHYZHForBasicAllDataAlone();
+
+ String selectprepriceForBasicAllDataAlone();
+
+ String selectBBZCForBasicAllDataAlone();
+
+ String selectHYZCForBasicAllDataAlone();
+
+ String selectDLZCForBasicAllDataAlone();
+
+ IPage<MemberAccountInfoVo> findMemberAccountInfoAloneListInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ IPage<MemberEntity> findMemberListTestInPage(Page<MemberEntity> page, @Param("record")MemberEntity member);
+
+ IPage<MemberAccountInfoVo> findmemberAccountInfoAloneTestListInPage(Page<MemberEntity> page,
+ @Param("record")MemberEntity memberEntity);
+
+ String selectMemberInfoDetailByInviteId(@Param("inviteId")String inviteId);
+
+ List<MemberEntity> selectMemberDataInfoListSearchs(@Param("inviteId")String inviteId);
+
+ MemberEntity selectMemberByInviteId(@Param("inviteId")String string);
+
+ IPage<MemberEntity> selectDataInfoListSearchs(Page<MemberEntity> page, @Param("record")MemberEntity member);
+
+ IPage<MemberAccountInfoVo> findMemberAccountInfoAloneOneInPage(
+ Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ IPage<MemberAccountInfoVo> findMemberAccountInfoAloneTwoInPage(
+ Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ IPage<MemberAccountInfoVo> findMemberAccountInfoAloneTeeInPage(
+ Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ IPage<MemberAccountInfoVo> findMemberAccountInfoAloneAllInPage(
+ Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ List<MemberAccountInfoVo> selectWalletContractByMemberId(@Param("memberId")Long memberId);
+
+ String selectTotalAmountUsdtBForDataInfoOne();
+ String selectTotalAmountUsdtSForDataInfoOne();
+ String selectTotalAmountUsdtCZForDataInfoOne();
+ String selectTotalAmountUsdtTXForDataInfoOne();
+ String selectReturnMoneyForDataInfoOne();
+ String selectClosingpriceForDataInfoOne();
+ String selectSellClosingpriceForDataInfoOne();
+ String selectRewardratioForDataInfoOne();
+ String selectSFCCForDataInfoOne();
+ String selectBBZHForDataInfoOne();
+ String selectHYZHForDataInfoOne();
+ String selectprepriceForDataInfoOne();
+ String selectBBZCForDataInfoOne();
+ String selectHYZCForDataInfoOne();
+ String selectDLZCForDataInfoOne();
+ IPage<MemberDataInfoVo> findMemberDataInfoOneInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ String selectTotalAmountUsdtBForDataInfoOneReal();
+ String selectTotalAmountUsdtSForDataInfoOneReal();
+ String selectTotalAmountUsdtCZForDataInfoOneReal();
+ String selectTotalAmountUsdtTXForDataInfoOneReal();
+ String selectReturnMoneyForDataInfoOneReal();
+ String selectClosingpriceForDataInfoOneReal();
+ String selectSellClosingpriceForDataInfoOneReal();
+ String selectRewardratioForDataInfoOneReal();
+ String selectSFCCForDataInfoOneReal();
+ String selectBBZHForDataInfoOneReal();
+ String selectHYZHForDataInfoOneReal();
+ String selectprepriceForDataInfoOneReal();
+ String selectBBZCForDataInfoOneReal();
+ String selectHYZCForDataInfoOneReal();
+ String selectDLZCForDataInfoOneReal();
+ IPage<MemberDataInfoVo> findMemberDataInfoOneRealInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ String selectTotalAmountUsdtBForDataInfoTwo();
+ String selectTotalAmountUsdtSForDataInfoTwo();
+ String selectTotalAmountUsdtCZForDataInfoTwo();
+ String selectTotalAmountUsdtTXForDataInfoTwo();
+ String selectReturnMoneyForDataInfoTwo();
+ String selectClosingpriceForDataInfoTwo();
+ String selectSellClosingpriceForDataInfoTwo();
+ String selectRewardratioForDataInfoTwo();
+ String selectSFCCForDataInfoTwo();
+ String selectBBZHForDataInfoTwo();
+ String selectHYZHForDataInfoTwo();
+ String selectprepriceForDataInfoTwo();
+ String selectBBZCForDataInfoTwo();
+ String selectHYZCForDataInfoTwo();
+ String selectDLZCForDataInfoTwo();
+ IPage<MemberDataInfoVo> findMemberDataInfoTwoInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ String selectTotalAmountUsdtBForDataInfoTwoReal();
+ String selectTotalAmountUsdtSForDataInfoTwoReal();
+ String selectTotalAmountUsdtCZForDataInfoTwoReal();
+ String selectTotalAmountUsdtTXForDataInfoTwoReal();
+ String selectReturnMoneyForDataInfoTwoReal();
+ String selectClosingpriceForDataInfoTwoReal();
+ String selectSellClosingpriceForDataInfoTwoReal();
+ String selectRewardratioForDataInfoTwoReal();
+ String selectSFCCForDataInfoTwoReal();
+ String selectBBZHForDataInfoTwoReal();
+ String selectHYZHForDataInfoTwoReal();
+ String selectprepriceForDataInfoTwoReal();
+ String selectBBZCForDataInfoTwoReal();
+ String selectHYZCForDataInfoTwoReal();
+ String selectDLZCForDataInfoTwoReal();
+ IPage<MemberDataInfoVo> findMemberDataInfoTwoRealInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ String selectTotalAmountUsdtBForDataInfoTee();
+ String selectTotalAmountUsdtSForDataInfoTee();
+ String selectTotalAmountUsdtCZForDataInfoTee();
+ String selectTotalAmountUsdtTXForDataInfoTee();
+ String selectReturnMoneyForDataInfoTee();
+ String selectClosingpriceForDataInfoTee();
+ String selectSellClosingpriceForDataInfoTee();
+ String selectRewardratioForDataInfoTee();
+ String selectSFCCForDataInfoTee();
+ String selectBBZHForDataInfoTee();
+ String selectHYZHForDataInfoTee();
+ String selectprepriceForDataInfoTee();
+ String selectBBZCForDataInfoTee();
+ String selectHYZCForDataInfoTee();
+ String selectDLZCForDataInfoTee();
+ IPage<MemberDataInfoVo> findMemberDataInfoTeeInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ String selectTotalAmountUsdtBForDataInfoTeeReal();
+ String selectTotalAmountUsdtSForDataInfoTeeReal();
+ String selectTotalAmountUsdtCZForDataInfoTeeReal();
+ String selectTotalAmountUsdtTXForDataInfoTeeReal();
+ String selectReturnMoneyForDataInfoTeeReal();
+ String selectClosingpriceForDataInfoTeeReal();
+ String selectSellClosingpriceForDataInfoTeeReal();
+ String selectRewardratioForDataInfoTeeReal();
+ String selectSFCCForDataInfoTeeReal();
+ String selectBBZHForDataInfoTeeReal();
+ String selectHYZHForDataInfoTeeReal();
+ String selectprepriceForDataInfoTeeReal();
+ String selectBBZCForDataInfoTeeReal();
+ String selectHYZCForDataInfoTeeReal();
+ String selectDLZCForDataInfoTeeReal();
+ IPage<MemberDataInfoVo> findMemberDataInfoTeeRealInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ String selectTotalAmountUsdtBForDataInfoOneAll();
+ String selectTotalAmountUsdtSForDataInfoOneAll();
+ String selectTotalAmountUsdtCZForDataInfoOneAll();
+ String selectTotalAmountUsdtTXForDataInfoOneAll();
+ String selectReturnMoneyForDataInfoOneAll();
+ String selectClosingpriceForDataInfoOneAll();
+ String selectSellClosingpriceForDataInfoOneAll();
+ String selectRewardratioForDataInfoOneAll();
+ String selectSFCCForDataInfoOneAll();
+ String selectBBZHForDataInfoOneAll();
+ String selectHYZHForDataInfoOneAll();
+ String selectprepriceForDataInfoOneAll();
+ String selectBBZCForDataInfoOneAll();
+ String selectHYZCForDataInfoOneAll();
+ String selectDLZCForDataInfoOneAll();
+ IPage<MemberDataInfoVo> findMemberDataInfoOneAllInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ String selectTotalAmountUsdtBForDataInfoOneAllReal();
+ String selectTotalAmountUsdtSForDataInfoOneAllReal();
+ String selectTotalAmountUsdtCZForDataInfoOneAllReal();
+ String selectTotalAmountUsdtTXForDataInfoOneAllReal();
+ String selectReturnMoneyForDataInfoOneAllReal();
+ String selectClosingpriceForDataInfoOneAllReal();
+ String selectSellClosingpriceForDataInfoOneAllReal();
+ String selectRewardratioForDataInfoOneAllReal();
+ String selectSFCCForDataInfoOneAllReal();
+ String selectBBZHForDataInfoOneAllReal();
+ String selectHYZHForDataInfoOneAllReal();
+ String selectprepriceForDataInfoOneAllReal();
+ String selectBBZCForDataInfoOneAllReal();
+ String selectHYZCForDataInfoOneAllReal();
+ String selectDLZCForDataInfoOneAllReal();
+ IPage<MemberDataInfoVo> findMemberDataInfoOneAllRealInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity);
+
+ String selectWalletAvailableBalanceBymemberId(@Param("memberId")Long memberId);
+
+ String selectWalletTotalBalanceBymemberId(@Param("memberId")Long memberId);
+
+ String selectWalletFrozenBalanceBymemberId(@Param("memberId")Long memberId);
+
+}
--
Gitblit v1.9.1