package com.matrix.system.score.dao;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.matrix.system.score.entity.ScoreVipDetail;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
|
/**
|
* @description 客户积分余额
|
* @author jyy
|
* @date 2021-02-26 15:26
|
*/
|
public interface ScoreVipDetailDao extends BaseMapper<ScoreVipDetail> {
|
|
/**
|
* 查询用户总积分
|
* @param openId
|
* @param vipId
|
* @return
|
*/
|
int selectUserTotalScore(@Param("vipId")Long vipId);
|
|
/**
|
* 查询用户有效的积分，按时间顺序排
|
* @param
|
* @return
|
*/
|
List<ScoreVipDetail> selectEffectiveScore(@Param("vipId")Long vipId);
|
|
List<ScoreVipDetail> selectInvalidaVipScore();
|
|
int invalidVipScore();
|
}
|
