update

liujie

2026-09-14 15defa991fcd30b9fa60bab17d2230b5929bf2a2

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
package com.tourguide.modules.operation.mapper;
 
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tourguide.modules.operation.entity.ScenicMeetingPoint;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;
 
@Mapper
public interface ScenicMeetingPointMapper extends BaseMapper<ScenicMeetingPoint> {
    @Update("UPDATE operation_scenic_meeting_point SET deleted = 1 WHERE scenic_spot_id = #{scenicSpotId} AND deleted = 0")
    int markDeletedByScenicSpotId(Long scenicSpotId);
 
    @Insert("INSERT INTO operation_scenic_meeting_point " +
            "(scenic_spot_id, point_name, address, longitude, latitude, status, is_default, sort_order, deleted) " +
            "VALUES (#{scenicSpotId}, #{pointName}, #{address}, #{longitude}, #{latitude}, #{status}, #{isDefault}, #{sortOrder}, 0) " +
            "ON DUPLICATE KEY UPDATE address = VALUES(address), longitude = VALUES(longitude), latitude = VALUES(latitude), status = VALUES(status), " +
            "is_default = VALUES(is_default), sort_order = VALUES(sort_order), deleted = 0")
    int upsert(ScenicMeetingPoint point);
}