update

liujie

2026-09-09 39f6fca28e3f78abe48f08e474ec011abb990b36

 backend/src/main/java/com/tourguide/modules/finance/mapper/GuideWithdrawalMapper.java

@@ -10,6 +10,10 @@
import java.util.List;

public interface GuideWithdrawalMapper extends BaseMapper<GuideWithdrawal> {
    @Select("SELECT COUNT(*) FROM guide_withdrawal WHERE guide_id = #{guideId} AND deleted = 0 " +
            "AND status NOT IN ('APPROVED', 'REJECTED')")
    long countActiveByGuideId(@Param("guideId") Long guideId);

    @Select("SELECT * FROM guide_withdrawal WHERE id = #{id} AND deleted = 0 FOR UPDATE")
    GuideWithdrawal selectForUpdate(@Param("id") Long id);