From 799622ea4d37aa6bb9fee457967532aa93d18594 Mon Sep 17 00:00:00 2001 From: 935090232@qq.com <ak473600000> Date: Sun, 21 Mar 2021 20:17:05 +0800 Subject: [PATCH] 扣除用户积分 --- zq-erp/src/main/java/com/matrix/system/score/dao/ScoreVipDetailDao.java | 20 ++++++++++++++++---- 1 files changed, 16 insertions(+), 4 deletions(-) diff --git a/zq-erp/src/main/java/com/matrix/system/score/dao/ScoreVipDetailDao.java b/zq-erp/src/main/java/com/matrix/system/score/dao/ScoreVipDetailDao.java index dc820d5..6558a8d 100644 --- a/zq-erp/src/main/java/com/matrix/system/score/dao/ScoreVipDetailDao.java +++ b/zq-erp/src/main/java/com/matrix/system/score/dao/ScoreVipDetailDao.java @@ -1,11 +1,9 @@ package com.matrix.system.score.dao; import com.baomidou.mybatisplus.core.mapper.BaseMapper; -import org.apache.ibatis.annotations.Param; -import java.util.List; -import java.util.Map; -import com.matrix.core.pojo.PaginationVO; import com.matrix.system.score.entity.ScoreVipDetail; + +import java.util.List; /** * @description 客户积分余额 @@ -14,4 +12,18 @@ */ public interface ScoreVipDetailDao extends BaseMapper<ScoreVipDetail> { + /** + * 查询用户总积分 + * @param openId + * @param vipId + * @return + */ + int selectUserTotalScore(String openId, Long vipId); + + /** + * 查询用户有效的积分,按时间顺序排 + * @param userId + * @return + */ + List<ScoreVipDetail> selectEffectiveScore(String openId); } \ No newline at end of file -- Gitblit v1.9.1