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.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;

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);
}