package incheon.ags.ias.myAuthrtAply.mapper;

import incheon.ags.ias.myAuthrtAply.vo.MyAuthrtAplyVO;
import incheon.ags.ias.role.vo.RoleVO;
import incheon.com.config.annotation.MainDB;
import org.egovframe.rte.psl.dataaccess.mapper.Mapper;

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

@org.egovframe.rte.psl.dataaccess.mapper.Mapper @incheon.com.config.annotation.MainDB
public interface MyAuthrtAplyMapper {
    List<Map<String, Object>> selectSysListWithRoleCnt(MyAuthrtAplyVO myAuthrtAplyVO) throws Exception;
    int aplyUserRoleMst(MyAuthrtAplyVO myAuthrtAplyVO) throws Exception;
    int aplyUserRoleDtl(MyAuthrtAplyVO myAuthrtAplyVO) throws Exception;

    // 사용자+시스템별 가장 최근 신청 정보 조회 (프리셋용)
    Map<String, Object> selectLatestAply(MyAuthrtAplyVO myAuthrtAplyVO) throws Exception;
}