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