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