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); }