package cc.mrbird.febs.dapp.mapper; import cc.mrbird.febs.dapp.dto.MallGoodsQueryDto; import cc.mrbird.febs.dapp.dto.MallOrderQueryDto; import cc.mrbird.febs.dapp.entity.DappMemberEntity; import cc.mrbird.febs.dapp.entity.MallAddressInfo; import cc.mrbird.febs.dapp.vo.*; 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.List; /** * @author * @date 2022-03-17 **/ public interface DappMemberDao extends BaseMapper { DappMemberEntity selectByAddress(@Param("address") String address, @Param("chain") String chain); DappMemberEntity selectMemberInfoByInviteId(@Param("inviteId") String inviteId); IPage selectInPage(@Param("record") DappMemberEntity member, Page page); List selectAllMemberForInCome(); List selectAgentMemberList(@Param("list") List inviteIds, @Param("size") Integer size); List selectParentsList(@Param("list") List inviteIds, @Param("size") Integer size); BigDecimal selectAllBalance(@Param("accountType") String accountType); List selectMemberByAccountType(@Param("accountType") String accountType); List selectChildMemberDirectOrNot(@Param("inviteId") String inviteId, @Param("type") Integer type, @Param("status") Integer status); BigDecimal selectChildHoldAmount(@Param("inviteId") String inviteId); List selectMakerAddress(); int updateMemberActive(); DappMemberEntity selectNewestDirectMember(@Param("inviteId") String inviteId); List selectMemberListNeedProfit(); void updateMemberAccountType(@Param("accountType")String code, @Param("id")Long id); void updateMemberActiveStatus(@Param("accountStatus")int i, @Param("id")Long id); List selectMemberInfoByRefererId(@Param("refererId")String inviteId); List selectAllMemberInfoByRefererId(@Param("inviteId")String inviteId); Integer selectCountByAccountTypeAndRefererId(@Param("accountType")String code, @Param("refererId")String inviteId); IPage findTeamInfoListInPage(Page page, @Param("record")DappMemberEntity dappMemberEntity); DappMemberInfoVo selectByMemberId(@Param("id")Long id); List selectByInviteIds(@Param("list")List referrerIdList); /** * 获取级别为Type,且直推中有type级别的用户信息 * @param type * @return */ List selectMemberByAccountTypeAnd(@Param("accountType")String type); List selectChildAgentListByAccountType(@Param("inviteId") String inviteId, @Param("accountType")String accountType); BigDecimal selectAllAchieveByInviteId(@Param("inviteId")String inviteId); List selectMemberByNotAccountType(@Param("accountType")String type); List selectByNodetype(); List selectAddress(); IPage selectMallGoodsListQueryInPage( @Param("record")MallGoodsQueryDto queryDto, Page page); IPage selectMallOrderListQueryInPage( @Param("record")MallOrderQueryDto queryDto, Page page); MallOrderListVo selectMallOrderListVoById(@Param("orderId")Long id); List selectMallOrderItemVoByOrderId(@Param("orderId")Long id); MallGoodsListVo selectMallGoodsListVoById(@Param("goodsId")Long id); DappMemberEntity selectInviteLeft(@Param("inviteId")String inviteId); DappMemberEntity selectInviteRight(@Param("inviteId")String inviteId); List selectMemberByActiveStatus(); BigDecimal selectAchieveRecordByInviteId(@Param("inviteId")String inviteId); List selectChildAgentList(@Param("inviteId")String inviteId, @Param("accountType")String accountType); DappMemberInfoVo selectDappMemberInfoVoByMemberId(@Param("memberId")long id); IPage selectAddressListInPage(@Param("record")MallGoodsQueryDto queryDto, Page page); }