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 | 498 ++++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 436 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..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 @@ -1,62 +1,436 @@ -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.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; + +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(); + + 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