From b87c5549fe471167882192944db3f2d6b729476c Mon Sep 17 00:00:00 2001
From: KKSU <15274802129@163.com>
Date: Fri, 15 Mar 2024 14:13:55 +0800
Subject: [PATCH] 抽奖
---
src/main/java/cc/mrbird/febs/mall/mapper/MallAchieveRecordMapper.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallAchieveRecordMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallAchieveRecordMapper.java
index 85e4ca9..d374a96 100644
--- a/src/main/java/cc/mrbird/febs/mall/mapper/MallAchieveRecordMapper.java
+++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallAchieveRecordMapper.java
@@ -2,6 +2,24 @@
import cc.mrbird.febs.mall.entity.MallAchieveRecord;
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);
+
+ List<MallAchieveRecord> selectListByDate(@Param("date")Date profitDate);
+
+ BigDecimal selectSumAchieveByMemberId(@Param("memberId")Long id);
}
--
Gitblit v1.9.1