From f7c7a1d550444e88c8f7033a8a586211ab8c3ce7 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Tue, 17 Jan 2023 21:04:02 +0800 Subject: [PATCH] 1 --- src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java | 12 ++++++++++++ 1 files changed, 12 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 3473eab..05b67bd 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,8 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import org.apache.ibatis.annotations.Param; +import java.math.BigDecimal; + public interface MallMemberWalletMapper extends BaseMapper<MallMemberWallet> { MallMemberWallet selectWalletByMemberId(@Param("memberId") Long memberId); @@ -15,4 +17,14 @@ int updateAmountWithVersion(@Param("record") MallMemberWallet wallet); void updateBalanceWithId(@Param("record")MallMemberWallet mallMemberWallet); + + BigDecimal selectSumBalance(); + + BigDecimal selectSumScore(); + + BigDecimal selectSumPrizeScore(); + + BigDecimal selectSumCommission(); + + void updateBlockBalanceById(@Param("id")Long id, @Param("balance")BigDecimal amount); } -- Gitblit v1.9.1