20210321 后台数据查询修改

xiaoyong931011

2021-03-02 4348e057d9b2894a533ba116e21216610934eef0

 src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java

@@ -3,6 +3,7 @@
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.MemberAccountMoneyChangeEntity;

import com.xcong.excoin.modules.member.entity.MemberEntity;

import com.xcong.excoin.modules.member.vo.MemberDataInfoVo;

import com.xcong.excoin.modules.trademanage.vo.MemberAccountInfoVo;

@@ -64,5 +65,360 @@
   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);

    

}