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/MallMemberWalletMapper.java | 22 +++++++++++++++++++++- 1 files changed, 21 insertions(+), 1 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 2195065..67bc322 100644 --- a/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java +++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java @@ -28,7 +28,27 @@ BigDecimal selectSumCommission(); - List<MallMemberWallet> selectSumStarByIds(@Param("list")List<Long> ids); + 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