package cc.mrbird.febs.dapp.mapper;

import cc.mrbird.febs.dapp.entity.DappMemberEntity;
import cn.hutool.core.date.DateTime;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

/**
 * @author 
 * @date 2022-03-17
 **/
public interface DappMemberDao extends BaseMapper<DappMemberEntity> {

    DappMemberEntity selectByAddress(@Param("address") String address, @Param("chain") String chain);

    DappMemberEntity selectMemberInfoByInviteId(@Param("inviteId") String inviteId);

    IPage<DappMemberEntity> selectInPage(@Param("record") DappMemberEntity member, Page<DappMemberEntity> page);

    List<DappMemberEntity> selectAllMemberForInCome();

    List<DappMemberEntity> selectAgentMemberList(@Param("list") List<String> inviteIds, @Param("size") Integer size);

    List<DappMemberEntity> selectParentsList(@Param("list") List<String> inviteIds, @Param("size") Integer size);

    BigDecimal selectAllBalance(@Param("accountType") String accountType);

    List<DappMemberEntity> selectMemberByAccountType(@Param("accountType") String accountType);

    List<DappMemberEntity> selectChildMemberDirectOrNot(@Param("inviteId") String inviteId, @Param("type") Integer type, @Param("status") Integer status);

    BigDecimal selectChildHoldAmount(@Param("inviteId") String inviteId);

    List<DappMemberEntity> selectMakerAddress();

    int updateMemberActive();
    int updateMemberActiveV2(@Param("memberId") Long memberId);

    DappMemberEntity selectNewestDirectMember(@Param("inviteId") String inviteId);

    List<DappMemberEntity> selectMemberListNeedProfit();

    List<DappMemberEntity> selectListByDate(@Param("date") Date date);

    List<DappMemberEntity> selectListByDateFiveToFiver(@Param("startTime")DateTime startTime);
}