package com.tourguide.modules.finance.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.tourguide.modules.finance.entity.GuideWithdrawalAccount;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
public interface GuideWithdrawalAccountMapper extends BaseMapper<GuideWithdrawalAccount> {
|
@Select("SELECT * FROM t_user_withdrawal WHERE userId = #{guideId} AND userType = 2 " +
|
"AND type = 1 AND status = 1 ORDER BY id DESC LIMIT 1 FOR UPDATE")
|
GuideWithdrawalAccount selectCurrentForUpdate(@Param("guideId") int guideId);
|
}
|
