From cf200a1f92c01ba22c326c49391f748ffb006910 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Mon, 05 Jul 2021 17:28:35 +0800 Subject: [PATCH] 20210617 开售开关 --- src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java | 254 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 253 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 baceed8..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; @@ -90,10 +93,17 @@ 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(); @@ -124,32 +134,60 @@ 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(); @@ -180,5 +218,219 @@ 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