package com.doumee.dao.business;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.doumee.dao.business.model.Member;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.math.BigDecimal;
|
|
/**
|
* @author 江蹄蹄
|
* @date 2023/03/21 15:48
|
*/
|
public interface MemberMapper extends BaseMapper<Member> {
|
|
|
/**
|
* 添加积分
|
* @param memberId
|
* @param integral
|
*/
|
@Select(" update member set INTEGRAL = ifNull( INTEGRAL,0) + #{integral} , TOTAL_INTEGRAL = ifNull(TOTAL_INTEGRAL,0) + #{titleIntegral} , EDIT_DATE = now() , EDITOR = #{memberId} where id = #{memberId} ")
|
void addIntegral(@Param("memberId") Integer memberId , @Param("integral")BigDecimal integral , @Param("titleIntegral")BigDecimal titleIntegral);
|
|
/**
|
* 减少积分
|
* @param memberId
|
* @param integral
|
*/
|
@Select(" update member set INTEGRAL = ifNull( INTEGRAL,0) - #{integral} , EDIT_DATE = now() , EDITOR = #{memberId} where id = #{memberId} ")
|
void subtractIntegral(@Param("memberId") Integer memberId , @Param("integral")BigDecimal integral);
|
|
}
|
