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);
}