egovframework.rfc3.iam.dao
Class OpenApiDAO

java.lang.Object
  extended by org.springframework.dao.support.DaoSupport
      extended by org.springframework.orm.ibatis.support.SqlMapClientDaoSupport
          extended by egovframework.rte.psl.dataaccess.EgovAbstractDAO
              extended by egovframework.rfc3.common.dao.RfcIAMAbstractDAO
                  extended by egovframework.rfc3.iam.dao.OpenApiDAO
All Implemented Interfaces:
org.springframework.beans.factory.InitializingBean

@Repository(value="OpenApiDAO")
public class OpenApiDAO
extends RfcIAMAbstractDAO


Constructor Summary
OpenApiDAO()
           
 
Method Summary
 void deleteAuthKey(long keySid)
          인증키 삭제
 void deleteOpenApiStatics(OpenApiStatiscVO openApiStatiscVO)
          특정날짜 통계 지우기
 void deleteSmsCertiNum(SmsCertiVO smsCertiVO)
          휴대전화 로그인 인증 번호 삭제
 OpenApiAuthKeyVO getAuthKeyInfo(long keySid)
          인증키 정보(시퀀스정보로)
 OpenApiAuthKeyVO getAuthKeyUserInfo(java.lang.String userId)
          인증키 정보(인증키 정보로)
 void insertAuthKey(OpenApiAuthKeyVO openApiAuthKeyVO)
          인증키 저장
 void insertOpenApiStatics(OpenApiStatiscVO openApiStatiscVO)
          통계 요약본 저장
 void insertQos(OpenApiQosVO openApiQosVO)
          품질 저장
 void insertSmsCertiNum(SmsCertiVO smsCertiVO)
          휴대전화 로그인 인증 번호 저장
 java.util.List<OpenApiAuthKeyVO> selectAuthKeyList(OpenApiAuthKeyVO openApiAuthKeyVO)
          인증키 목록
 int selectAuthKeyListTotCnt(OpenApiAuthKeyVO openApiAuthKeyVO)
          인증키 전체 갯수
 java.util.List<OpenApiStatiscVO> selectOpenApiServicesAllStaticsList(OpenApiStatiscVO openApiStatiscVO)
          서비스별 전체 통계
 java.util.List<OpenApiStatusVO> selectOpenApiStatusList(OpenApiStatusVO openApiStatusVO)
          open api 전체 목록
 java.util.List<OpenApiStatiscVO> selectOpenApiUserAllStaticsList(OpenApiStatiscVO openApiStatiscVO)
          사용자별 전체 통계
 java.util.List<OpenApiStatiscVO> selectOpenApiUserStaticsList(OpenApiStatiscVO openApiStatiscVO)
          시용자별 각각 서비스별 통계
 float selectQosAvgTime(OpenApiQosVO openApiQosVO)
          해당일에 평균 시간
 int selectQosFailtotCnt(OpenApiQosVO openApiQosVO)
          해당일에 실패 호출수
 java.util.List<OpenApiQosVO> selectQosList(OpenApiQosVO openApiQosVO)
          품질 전체 목록
 int selectQosListTotCnt(OpenApiQosVO openApiQosVO)
          품질 로그 전체 갯수
 int selectQosMaxTime(OpenApiQosVO openApiQosVO)
          해당일에 최대 시간
 int selectQosOktotCnt(OpenApiQosVO openApiQosVO)
          해당일에 정상 호출수
 SmsCertiVO selectSmsCertiNum(SmsCertiVO smsCertiVO)
          휴대전화 로그인 인증 번호 조회
 OpenApiAuthKeyVO selectVaildAuthKey(OpenApiAuthKeyVO openApiAuthKeyVO)
          authkey 검사
 void updateAuthKey(OpenApiAuthKeyVO openApiAuthKeyVO)
          인증키 수정
 void updateDelayApplyAuthKey(OpenApiAuthKeyVO openApiAuthKeyVO)
          연장 신청하기
 void updateSmsSendDate(OpenApiAuthKeyVO openApiAuthKeyVO)
          최근 사용자측에게 보낸 인증 sms 메세지
 
Methods inherited from class egovframework.rfc3.common.dao.RfcIAMAbstractDAO
delete, insert, list, listWithPaging, selectByPk, setSuperSqlMapClient, update
 
Methods inherited from class org.springframework.orm.ibatis.support.SqlMapClientDaoSupport
getDataSource, getSqlMapClient, getSqlMapClientTemplate, setDataSource, setSqlMapClient, setSqlMapClientTemplate
 
Methods inherited from class org.springframework.dao.support.DaoSupport
afterPropertiesSet
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

OpenApiDAO

public OpenApiDAO()
Method Detail

selectVaildAuthKey

public OpenApiAuthKeyVO selectVaildAuthKey(OpenApiAuthKeyVO openApiAuthKeyVO)
                                    throws java.lang.Exception
authkey 검사

Parameters:
openApiAuthKeyVO -
Returns:
Throws:
java.lang.Exception

selectAuthKeyListTotCnt

public int selectAuthKeyListTotCnt(OpenApiAuthKeyVO openApiAuthKeyVO)
                            throws java.lang.Exception
인증키 전체 갯수

Parameters:
openApiAuthKeyVO -
Returns:
Throws:
java.lang.Exception

selectAuthKeyList

public java.util.List<OpenApiAuthKeyVO> selectAuthKeyList(OpenApiAuthKeyVO openApiAuthKeyVO)
                                                   throws java.lang.Exception
인증키 목록

Parameters:
openApiAuthKeyVO -
Returns:
Throws:
java.lang.Exception

getAuthKeyInfo

public OpenApiAuthKeyVO getAuthKeyInfo(long keySid)
                                throws java.lang.Exception
인증키 정보(시퀀스정보로)

Parameters:
keySid -
Returns:
Throws:
java.lang.Exception

getAuthKeyUserInfo

public OpenApiAuthKeyVO getAuthKeyUserInfo(java.lang.String userId)
                                    throws java.lang.Exception
인증키 정보(인증키 정보로)

Parameters:
userId -
Returns:
Throws:
java.lang.Exception

insertAuthKey

public void insertAuthKey(OpenApiAuthKeyVO openApiAuthKeyVO)
                   throws java.lang.Exception
인증키 저장

Parameters:
openApiAuthKeyVO -
Throws:
java.lang.Exception

updateAuthKey

public void updateAuthKey(OpenApiAuthKeyVO openApiAuthKeyVO)
                   throws java.lang.Exception
인증키 수정

Parameters:
openApiAuthKeyVO -
Throws:
java.lang.Exception

updateSmsSendDate

public void updateSmsSendDate(OpenApiAuthKeyVO openApiAuthKeyVO)
                       throws java.lang.Exception
최근 사용자측에게 보낸 인증 sms 메세지

Parameters:
openApiAuthKeyVO -
Throws:
java.lang.Exception

updateDelayApplyAuthKey

public void updateDelayApplyAuthKey(OpenApiAuthKeyVO openApiAuthKeyVO)
                             throws java.lang.Exception
연장 신청하기

Parameters:
openApiAuthKeyVO -
Throws:
java.lang.Exception

deleteAuthKey

public void deleteAuthKey(long keySid)
                   throws java.lang.Exception
인증키 삭제

Parameters:
keySid -
Throws:
java.lang.Exception

selectQosListTotCnt

public int selectQosListTotCnt(OpenApiQosVO openApiQosVO)
                        throws java.lang.Exception
품질 로그 전체 갯수

Parameters:
openApiQosVO -
Returns:
Throws:
java.lang.Exception

selectQosList

public java.util.List<OpenApiQosVO> selectQosList(OpenApiQosVO openApiQosVO)
                                           throws java.lang.Exception
품질 전체 목록

Parameters:
openApiQosVO -
Returns:
Throws:
java.lang.Exception

insertQos

public void insertQos(OpenApiQosVO openApiQosVO)
               throws java.lang.Exception
품질 저장

Parameters:
openApiQosVO -
Throws:
java.lang.Exception

insertSmsCertiNum

public void insertSmsCertiNum(SmsCertiVO smsCertiVO)
                       throws java.lang.Exception
휴대전화 로그인 인증 번호 저장

Parameters:
smsCertiVO -
Throws:
java.lang.Exception

deleteSmsCertiNum

public void deleteSmsCertiNum(SmsCertiVO smsCertiVO)
                       throws java.lang.Exception
휴대전화 로그인 인증 번호 삭제

Parameters:
smsCertiVO -
Throws:
java.lang.Exception

selectSmsCertiNum

public SmsCertiVO selectSmsCertiNum(SmsCertiVO smsCertiVO)
                             throws java.lang.Exception
휴대전화 로그인 인증 번호 조회

Parameters:
smsCertiVO -
Throws:
java.lang.Exception

selectOpenApiStatusList

public java.util.List<OpenApiStatusVO> selectOpenApiStatusList(OpenApiStatusVO openApiStatusVO)
                                                        throws java.lang.Exception
open api 전체 목록

Parameters:
openApiStatusVO -
Returns:
Throws:
java.lang.Exception

insertOpenApiStatics

public void insertOpenApiStatics(OpenApiStatiscVO openApiStatiscVO)
                          throws java.lang.Exception
통계 요약본 저장

Parameters:
openApiStatiscVO -
Throws:
java.lang.Exception

selectQosOktotCnt

public int selectQosOktotCnt(OpenApiQosVO openApiQosVO)
                      throws java.lang.Exception
해당일에 정상 호출수

Parameters:
openApiQosVO -
Returns:
Throws:
java.lang.Exception

selectQosFailtotCnt

public int selectQosFailtotCnt(OpenApiQosVO openApiQosVO)
                        throws java.lang.Exception
해당일에 실패 호출수

Parameters:
openApiQosVO -
Returns:
Throws:
java.lang.Exception

selectQosAvgTime

public float selectQosAvgTime(OpenApiQosVO openApiQosVO)
                       throws java.lang.Exception
해당일에 평균 시간

Parameters:
openApiQosVO -
Returns:
Throws:
java.lang.Exception

selectQosMaxTime

public int selectQosMaxTime(OpenApiQosVO openApiQosVO)
                     throws java.lang.Exception
해당일에 최대 시간

Parameters:
openApiQosVO -
Returns:
Throws:
java.lang.Exception

selectOpenApiServicesAllStaticsList

public java.util.List<OpenApiStatiscVO> selectOpenApiServicesAllStaticsList(OpenApiStatiscVO openApiStatiscVO)
                                                                     throws java.lang.Exception
서비스별 전체 통계

Parameters:
openApiStatiscVO -
Returns:
Throws:
java.lang.Exception

selectOpenApiUserAllStaticsList

public java.util.List<OpenApiStatiscVO> selectOpenApiUserAllStaticsList(OpenApiStatiscVO openApiStatiscVO)
                                                                 throws java.lang.Exception
사용자별 전체 통계

Parameters:
openApiStatiscVO -
Returns:
Throws:
java.lang.Exception

selectOpenApiUserStaticsList

public java.util.List<OpenApiStatiscVO> selectOpenApiUserStaticsList(OpenApiStatiscVO openApiStatiscVO)
                                                              throws java.lang.Exception
시용자별 각각 서비스별 통계

Parameters:
openApiStatiscVO -
Returns:
Throws:
java.lang.Exception

deleteOpenApiStatics

public void deleteOpenApiStatics(OpenApiStatiscVO openApiStatiscVO)
                          throws java.lang.Exception
특정날짜 통계 지우기

Parameters:
openApiStatiscVO -
Throws:
java.lang.Exception