package incheon.sgp.prs.mapper;

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

import org.egovframe.rte.psl.dataaccess.mapper.Mapper;

import incheon.com.config.annotation.ExternalDB;
import incheon.sgp.prs.vo.FacilitySearchFilterVO;
import incheon.sgp.prs.vo.FacilityVO;

@org.egovframe.rte.psl.dataaccess.mapper.Mapper @incheon.com.config.annotation.ExternalDB
public interface FacilitySearchMapper {
    List<FacilityVO> selectFacilityList(FacilitySearchFilterVO filterVO); 
    
    List<Map<String, Object>> selectPieChartData(FacilitySearchFilterVO filter);
    List<Map<String, Object>> selectPipeChartData(FacilitySearchFilterVO filter);
    List<Map<String, Object>> selectPipeChart2Data(FacilitySearchFilterVO filter);
    
    List<FacilityVO> selectFacilityTypeList() throws Exception;
    List<FacilityVO> selectFacilityTypeDetailList(String parentCode) throws Exception;
}