From e6667c792be898c41cda7d850dda02a403ef79c2 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Thu, 06 Apr 2023 10:35:20 +0800
Subject: [PATCH] 关于积分凭证
---
src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java | 24 ++++++++++++++++++++++++
1 files changed, 24 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..54108b4 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,26 @@
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);
}
--
Gitblit v1.9.1