From a38d3fcc9ddf27353700f351736e172c1eece74c Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Tue, 18 May 2021 18:07:58 +0800 Subject: [PATCH] 20210518 --- src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java | 346 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 345 insertions(+), 1 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 9f69fe7..786f977 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 @@ -3,7 +3,10 @@ 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.ActivityReceiveRecord; +import com.xcong.excoin.modules.member.entity.MemberAccountMoneyChangeEntity; import com.xcong.excoin.modules.member.entity.MemberEntity; +import com.xcong.excoin.modules.member.vo.MemberActivityReceiveVo; import com.xcong.excoin.modules.member.vo.MemberDataInfoVo; import com.xcong.excoin.modules.trademanage.vo.MemberAccountInfoVo; @@ -88,5 +91,346 @@ 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(); + + String selectWalletAvailableBalanceBymemberId(@Param("memberId")Long memberId); + + String selectWalletTotalBalanceBymemberId(@Param("memberId")Long memberId); + + String selectWalletFrozenBalanceBymemberId(@Param("memberId")Long memberId); + + IPage<MemberAccountMoneyChangeEntity> memberBoBiList(Page<MemberAccountMoneyChangeEntity> page, + @Param("record")MemberAccountMoneyChangeEntity memberAccountMoneyChangeEntity); + + MemberEntity selectMemberByAccount(@Param("account")String account); + IPage<MemberDataInfoVo> findMemberDataInfoOneAllRealInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity); + String selectClosingpriceForAllDataInfo(@Param("record")MemberEntity memberEntity); + String selectTotalAmountUsdtBForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectTotalAmountUsdtSForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectTotalAmountUsdtCZForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectTotalAmountUsdtTXForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectReturnMoneyForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectRewardratioForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectSFCCForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectBBZHForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectHYZHForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectprepriceForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectBBZCForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectHYZCForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectDLZCForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectSellClosingpriceForForAllDataInfo(@Param("record")MemberEntity memberEntity); + + String selectMemberWalletContractByMemberId(@Param("memberId")long memberId); + + + MemberEntity selectMemberInfoByQueryKey(@Param("queryKey") String queryKey); + + IPage<MemberActivityReceiveVo> memberActivityReceive(Page<ActivityReceiveRecord> page, + @Param("record")ActivityReceiveRecord activityReceiveRecord); + + IPage<ActivityReceiveRecord> seeReceiveInfo(Page<ActivityReceiveRecord> page, + @Param("record")ActivityReceiveRecord activityReceiveRecord); } -- Gitblit v1.9.1