From b6d1603cb25dfca500e4257b446e454c3e694669 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Tue, 11 Apr 2023 17:12:20 +0800
Subject: [PATCH] 后台修改
---
src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java | 38 ++++++++++++++++++++++++++++++++++++++
1 files changed, 38 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 50b5cd5..67bc322 100644
--- a/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java
+++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java
@@ -4,6 +4,10 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
+import java.math.BigDecimal;
+import java.util.List;
+import java.util.Map;
+
public interface MallMemberWalletMapper extends BaseMapper<MallMemberWallet> {
MallMemberWallet selectWalletByMemberId(@Param("memberId") Long memberId);
@@ -12,5 +16,39 @@
int updateCommissionWithVersion(@Param("record") MallMemberWallet wallet);
+ int updateAmountWithVersion(@Param("record") MallMemberWallet wallet);
+
void updateBalanceWithId(@Param("record")MallMemberWallet mallMemberWallet);
+
+ BigDecimal selectSumBalance();
+
+ BigDecimal selectSumScore();
+
+ 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