20221227 充值归集

xiaoyong931011

2023-01-09 615b4cba39cc01756d7c0299204cc6ecaf172be5

 src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWalletMapper.java

@@ -4,11 +4,27 @@
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);

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

    void updateBlockBalanceById(@Param("id")Long id, @Param("balance")BigDecimal amount);
}