package incheon.sgp.rst.mapper;

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

import org.apache.ibatis.annotations.Param;

import incheon.sgp.rst.vo.RstAdmResultVO;

@org.egovframe.rte.psl.dataaccess.mapper.Mapper @incheon.com.config.annotation.MainDB
public interface RstLcadstMapper {
	
	Map<String, Object> selectLandSummary(@Param("sggCd") String sggCd, @Param("emdCd") String emdCd, @Param("liCd") String liCd, @Param("year") String year) throws Exception;
    List<Map<String, Object>> selectLandGroupStats(@Param("sggCd") String sggCd, @Param("emdCd") String emdCd, @Param("liCd") String liCd, @Param("year") String year) throws Exception;
    
    Map<String, Object> selectOwnSummary(@Param("sggCd") String sggCd, @Param("emdCd") String emdCd, @Param("liCd") String liCd, @Param("year") String year) throws Exception;
    List<Map<String, Object>> selectOwnGroupStats(@Param("sggCd") String sggCd, @Param("emdCd") String emdCd, @Param("liCd") String liCd, @Param("year") String year) throws Exception;
    
    List<RstAdmResultVO> selectCtpList() throws Exception;
    List<RstAdmResultVO> selectSigList(String ctpCd) throws Exception;
    List<RstAdmResultVO> selectEmdList(String sigCd) throws Exception;
    List<RstAdmResultVO> selectLiList(String emdCd) throws Exception;
    
    Map<String, Object> getAdmCenter(String admCd) throws Exception;
    
    List<String> selectCrtrYrList() throws Exception;
}