package incheon.cmm.g2f.TaskLayer.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.g2f.TaskLayer.vo.G2TaskLayerVO;

@Mapper
@MainDB
public interface G2FTaskLayerMapper {
    G2TaskLayerVO findById(Integer taskLyrId);
    List<G2TaskLayerVO> findAllWithPaging(String searchKeyword, String searchType, int limit, int offset);
    int count(String searchKeyword, String searchType);
    void insert(G2TaskLayerVO taskLayer);
    void update(G2TaskLayerVO taskLayer);
    void delete(Integer taskLyrId);
    List<G2TaskLayerVO> findAll();
    List<Map<String, Object>> selectGroupCodes();
    
    //테이블 검증 
    List<Map<String, Object>> verifyGeometryTable(@Param("schema") String schema,
            @Param("tableNm") String tableNm);
    Integer verifyTaskPhyTable(Map<String, Object> params);
    Integer verifyTaskSrvTable(Map<String, Object> params);
}