package incheon.sgp.tdr.mapper;


import incheon.sgp.tdr.vo.TdrComboVO;
import incheon.ags.aip.vo.AipExtracVO;
import incheon.com.config.annotation.ExternalDB;
import incheon.sgp.tdr.vo.DronePoiVO;
import incheon.sgp.tdr.vo.SgpNatureVO;
import incheon.sgp.tdr.vo.SgpTdrVO;
import incheon.sgp.tdr.vo.TdrRequestVO;

import org.egovframe.rte.psl.dataaccess.mapper.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author : ShinYoung, Kim
 * @version 1.0
 * @Class Name  : SgpTdrMapper.java
 * @Description :
 * @Modification Information
 * 개정일자			     개정자                  개정내용
 * ------------------ ----------- --------------------------
 * 2025. 09. 23        ShinYoung, Kim         최초생성
 * <p>
 * <p>
 * Copyright 2025. 올포랜드 INC.All rights reserved.
 * @since : 2025. 09. 23
 */


@org.egovframe.rte.psl.dataaccess.mapper.Mapper @incheon.com.config.annotation.ExternalDB
public interface SgpTdrMapper {
    List<SgpTdrVO> selectTourMapDreamList(TdrRequestVO tdrRequestVO);


    SgpTdrVO selectTdrById(@Param("id") Long id);
    
    List<TdrComboVO> selectTourCatList();
    
    List<TdrComboVO> selectNatureCatList();

    int insertPlace(SgpTdrVO vo);

    int updatePlace(SgpTdrVO vo);

    int deletePlace(@Param("id") Long id);


	List<SgpNatureVO> selectNatureList(TdrRequestVO tdrRequestVO);
    List<DronePoiVO> selectDronePoiList(TdrRequestVO tdrRequestVO);
}