package cc.mrbird.febs.mall.mapper; import cc.mrbird.febs.mall.entity.MallMemberWallet; 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 selectWalletByMemberId(@Param("memberId") Long memberId); int updateBalanceWithVersion(@Param("record") MallMemberWallet wallet); 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 selectMemberWalletsByIds(@Param("list")List ids); int updateStarByList(@Param("list")List> result); int updateTotalScoreByList(@Param("list")List> 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 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); }