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