后台修改

xiaoyong931011

2023-04-11 b6d1603cb25dfca500e4257b446e454c3e694669

 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);
@@ -15,4 +19,36 @@
    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);
}