package incheon.sgp.aat.mapper;

import java.util.List;
import org.egovframe.rte.psl.dataaccess.mapper.Mapper;
import org.apache.ibatis.annotations.Param;

import incheon.com.config.annotation.ExternalDB;
import incheon.sgp.aat.vo.SgpAatVO;

/**
 * @author : HyeonBin, Kang
 * @version 1.3
 * @Class Name : SgpAatMapper.java
 * @Description : 건축상 수상작 조회 Mapper
 * @Modification Information 
 * 개정일자              개정자                  개정내용
 * ------------------ ----------- --------------------------
 * 2025. 10. 14       HyeonBin, Kang         최초생성
 * <p>
 * Copyright 2025. 올포랜드 INC. All rights reserved.
 * @since : 2025.10.14
 */
@org.egovframe.rte.psl.dataaccess.mapper.Mapper @incheon.com.config.annotation.ExternalDB
public interface SgpAatMapper {

  List<SgpAatVO> selectAwardList(@Param("yr") Integer yr, @Param("wnawd_se_se_cd") String wnawd_se_se_cd,
      @Param("keyword") String keyword, @Param("sgg_cd") String sgg_cd, @Param("emd_cd") String emd_cd);

  List<Integer> selectYearList();

  List<SgpAatVO> selectAwardCodeList();

  List<SgpAatVO> selectSggList();

  List<SgpAatVO> selectEmdListBySgg(@Param("sgg_cd") String sgg_cd);

  List<SgpAatVO> selectAllEmdList();
}