package incheon.cmm.ahm.flight.mapper;

import incheon.com.config.annotation.MainDB;
import org.apache.ibatis.annotations.Param;
import org.egovframe.rte.psl.dataaccess.mapper.Mapper;
import java.util.List;
import java.util.Map;

import incheon.cmm.ahm.flight.vo.G2fFlightVO;

@Mapper
@MainDB
public interface G2fFlightMapper {
    G2fFlightVO findById(Integer flightPhotoLyrId);
    List<G2fFlightVO> findAllWithPaging(String searchKeyword, String searchType, int limit, int offset);
    int count(String searchKeyword, String searchType);
    void insert(G2fFlightVO poi);
    void update(G2fFlightVO poi);
    void delete(Integer nfId);
    List<G2fFlightVO> findAll();
    int countByUniqueKey(@Param("excludeId") Integer excludeId, @Param("lyrSrvcPrefix") String lyrSrvcPrefix, @Param("lyrSrvcNm") String lyrSrvcNm, @Param("lyrSrvcMatrixNm") String lyrSrvcMatrixNm,
                         @Param("extn") String extn);
    
    G2fFlightVO findByUniqueKey(@Param("excludeId") Integer excludeId,@Param("lyrSrvcPrefix") String lyrSrvcPrefix, @Param("lyrSrvcNm") String lyrSrvcNm,@Param("lyrSrvcMatrixNm") String lyrSrvcMatrixNm,
                                @Param("extn") String extn);
}