From 39f6fca28e3f78abe48f08e474ec011abb990b36 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期三, 09 九月 2026 10:39:21 +0800
Subject: [PATCH] update
---
backend/src/main/java/com/tourguide/modules/finance/mapper/GuideWithdrawalAccountMapper.java | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/backend/src/main/java/com/tourguide/modules/finance/mapper/GuideWithdrawalAccountMapper.java b/backend/src/main/java/com/tourguide/modules/finance/mapper/GuideWithdrawalAccountMapper.java
index 9e2a3dd..a64c8f9 100644
--- a/backend/src/main/java/com/tourguide/modules/finance/mapper/GuideWithdrawalAccountMapper.java
+++ b/backend/src/main/java/com/tourguide/modules/finance/mapper/GuideWithdrawalAccountMapper.java
@@ -2,6 +2,11 @@
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);
}
--
Gitblit v1.7.1