From 5b1a5025c72a80f58fe6bdbaf90eeaf487d71076 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Mon, 17 Apr 2023 16:35:08 +0800
Subject: [PATCH] 只针对一星会员做修改： 按购买业绩（不按权益积分）每天静态释0.6%~1.2%
---
src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java | 26 ++++++++++++++++++++++++++
1 files changed, 26 insertions(+), 0 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java
index cea3a64..67bc322 100644
--- a/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java
+++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java
@@ -5,6 +5,8 @@
import org.apache.ibatis.annotations.Param;
import java.math.BigDecimal;
+import java.util.List;
+import java.util.Map;
public interface MallMemberWalletMapper extends BaseMapper<MallMemberWallet> {
@@ -25,4 +27,28 @@
BigDecimal selectSumPrizeScore();
BigDecimal selectSumCommission();
+
+ List<MallMemberWallet> selectMemberWalletsByIds(@Param("list")List<Long> ids);
+
+ int updateStarByList(@Param("list")List<Map<String, Object>> result);
+
+ int updateTotalScoreByList(@Param("list")List<Map<String, Object>> resultReduce);
+
+ void reduceTotalScoreById(@Param("totalScore")BigDecimal sharePerkAmount, @Param("id")Long id);
+
+ void addBalanceById(@Param("balance")BigDecimal sharePerkAmount, @Param("id")Long id);
+
+ void addStarByMemberId(@Param("star")Integer starSum, @Param("memberId")Long memberId);
+
+ void reduceStarByMemberId(@Param("star")int i, @Param("memberId")Long memberId);
+
+ void addVorCherCntByMemberId(@Param("voucherCnt")BigDecimal voucherCnt, @Param("memberId")Long memberId);
+
+ BigDecimal selectSumStar();
+
+ List<MallMemberWallet> selectStar();
+
+ void addVorCherAmountAndCntById(@Param("voucherAmount")BigDecimal voucherAmountAdd,@Param("voucherCnt")BigDecimal voucherCnt, @Param("id")Long id);
+
+ void addVorCherFireCntByMemberId(@Param("voucherFireCnt")BigDecimal voucherFireCnt, @Param("memberId")Long memberId);
}
--
Gitblit v1.9.1