package incheon.sgp.sea.mapper;

import java.util.List;
import java.util.Map;

import incheon.sgp.sea.vo.SgpSeaFilterVO;
import incheon.sgp.sea.vo.SgpSeaVO;
import incheon.sgp.sea.vo.AddressVO;
import incheon.sgp.sea.vo.SgpSeaFcltyVO;

@org.egovframe.rte.psl.dataaccess.mapper.Mapper @incheon.com.config.annotation.ExternalDB
public interface SgpSeaMapper {
    List<SgpSeaVO> seaList(SgpSeaFilterVO filterVO); 
    
    List<Map<String, Object>> selectPieChartData(SgpSeaFilterVO filter);
    List<Map<String, Object>> selectPipeChartData(SgpSeaFilterVO filter);
    List<Map<String, Object>> selectPipeChart2Data(SgpSeaFilterVO filter);
    
    List<SgpSeaVO> seaTypeList() throws Exception;
    List<SgpSeaVO> seaTypeDetailList(String parentCode) throws Exception;

    List<AddressVO> selectAddrByPoint(SgpSeaFilterVO filterVO);
    int insertFclty(SgpSeaFcltyVO vo);
    int updateFclty(SgpSeaFcltyVO vo);
    int deleteFclty(SgpSeaFcltyVO vo);
}