update

liujie

2026-09-11 4f6f15b818704079ff2e4e4719b798f48d68a335

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
package com.tourguide.modules.order.mapper;
 
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tourguide.modules.order.entity.TourOrderRefund;
import org.apache.ibatis.annotations.Select;
 
import java.util.List;
 
public interface TourOrderRefundMapper extends BaseMapper<TourOrderRefund> {
    @Select("SELECT * FROM tour_order_refund WHERE order_id = #{orderId} AND deleted = 0 " +
            "ORDER BY COALESCE(refund_time, created_at) DESC, id DESC")
    List<TourOrderRefund> selectByOrderId(Long orderId);
 
    @Select("SELECT * FROM tour_order_refund WHERE refund_order_no = #{refundOrderNo} " +
            "AND deleted = 0 LIMIT 1 FOR UPDATE")
    TourOrderRefund selectByRefundOrderNoForUpdate(String refundOrderNo);
}