update

liujie

2026-09-14 15defa991fcd30b9fa60bab17d2230b5929bf2a2

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

@@ -10,11 +10,16 @@
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);

    @Select("SELECT * FROM guide_withdrawal WHERE deleted = 0 " +
            "AND (cash_req_seq_id = #{requestSequence} OR withdrawal_no = #{requestSequence}) " +
            "AND (cash_req_seq_id = #{requestSequence} OR withdrawal_no = #{requestSequence} " +
            "OR cash_hf_seq_id = #{requestSequence}) " +
            "LIMIT 1 FOR UPDATE")
    GuideWithdrawal selectByPayoutSequenceForUpdate(@Param("requestSequence") String requestSequence);