package cc.mrbird.febs.dapp.mapper;
|
|
import cc.mrbird.febs.dapp.entity.MallAchieveRecord;
|
import cc.mrbird.febs.dapp.vo.TeamChildListVo;
|
import cc.mrbird.febs.dapp.vo.TeamListVo;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.math.BigDecimal;
|
import java.util.Date;
|
import java.util.List;
|
|
public interface MallAchieveRecordMapper extends BaseMapper<MallAchieveRecord> {
|
/**
|
* 根据日期获取总业绩
|
* @param type D：某一天；M：某一月
|
* @param date
|
* @return
|
*/
|
BigDecimal selectAchieveTotal(@Param("type") String type, @Param("date") Date date);
|
|
BigDecimal selectSumAchieveByMemberIds(@Param("list")List<Long> mallMembersOffLinePerkIds, @Param("date") Date date);
|
|
BigDecimal selectSumAchieveByMemberIdList(@Param("list")List<Long> mallMembersOffLinePerkIds);
|
|
List<MallAchieveRecord> selectListByDate(@Param("date")Date profitDate);
|
|
List<MallAchieveRecord> selectListByMemberId(@Param("memberId")Long memberId);
|
|
List<MallAchieveRecord> selectListCostAmountByMemberId(@Param("memberId")Long memberId);
|
|
BigDecimal selectAchieveTotalByMemberIdAndCreateTime(@Param("memberId")Long id, @Param("date")Date createTime);
|
|
BigDecimal selectAchieveTotalByCreateTime(@Param("date")Date createTime);
|
|
BigDecimal selectAchieveByMemberId(@Param("inviteId") String inviteId, @Param("type") Integer type);
|
|
List<TeamChildListVo> selectTeamListByInviteId(@Param("inviteId")String inviteId);
|
|
List<MallAchieveRecord> selectCountByInvitedId(@Param("inviteId") String inviteId, @Param("type") Integer type);
|
}
|
