|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.springframework.dao.support.DaoSupport org.springframework.orm.ibatis.support.SqlMapClientDaoSupport egovframework.rte.psl.dataaccess.EgovAbstractDAO egovframework.rfc3.common.dao.RfcCMSAbstractDAO egovframework.rfc3.education.dao.EduCationDAO
@Repository(value="EduCationDAO") public class EduCationDAO
Constructor Summary | |
---|---|
EduCationDAO()
|
Method Summary | |
---|---|
void |
addlectureDate(EduCationVO eduCationVO)
출석부 일정 추가등록 |
void |
attenddingUpdate1(EduReportVO eduReportVO)
수강신청 상태 변경 => 수료 / 미수료 (강의 종료) |
void |
attenddingUpdate2(EduReportVO eduReportVO)
수강신청 상태 변경 => 수료 / 미수료 (강의 종료) |
void |
attenddingUpdate3(EduReportVO eduReportVO)
수강신청 상태 변경 => 수강중으로 변경(수강이전상태) |
void |
AttendingCancelModify(EduCationApplyVO eduCationApplyVO)
수강신청 취소 - 사용자가 취소 |
void |
attendingStatusModify(EduCationApplyVO eduCationApplyVO)
수강신청 대기자 끌어 올리기 |
void |
AttendingStatusModify(EduCationApplyVO eduCationApplyVO)
수강신청 지정된 대기자 상태값 변경 |
void |
attendingStatusModify2(EduCationApplyVO eduCationApplyVO)
특정과목 수강신청 중 일부 상태를 특정 상태를 변경 |
void |
AttendingStatusUpdate(EduCationApplyVO eduCationApplyVO)
수강상태가 대기(0)이고 수강 시작일이 5일 이상 지났으면 원하는 상태로 변경 status : 변경하고자 하는 상태값 studentidx : 회원 번호 str : 불가일 경우 변경사유 ipaddr : 변경지 IP |
void |
batchModify(EduAttendanceVO eduAttendanceVO)
|
void |
deleteApplyer(long idx)
수강 신청자 삭제 |
void |
deleteAttendance(long idx)
출석부 삭제 |
void |
deleteAttendanceDate(EduReportVO eduReportVO)
개인별 출석부 삭제 |
void |
deleteEduCation(long idx)
교육 삭제 |
void |
deleteEduReport(long idx)
리포트 삭제 |
void |
deleteEduSubject(long idx)
과목 삭제 |
void |
eduAfterInsert(EduAfterVO eduAfterVO)
소감문 등록 |
void |
eduCationIsWrite(EduCationApplyVO eduCationApplyVO)
|
java.util.List<EduCationApplyVO> |
firstWait(EduCationApplyVO eduCationApplyVO)
남는 인원만큼 대기자에서 가져오기 |
EduCationApplyVO |
getApplyerInfo(long idx)
수강 신청 상세정보 |
int |
getAttCount(EduCationApplyVO eduCationApplyVO)
강의과목 수강신청인원 (0:대기 1:승인 2:불가 3:수강 4:취소 5:수료 6:미수료) |
java.util.List<EduAttendanceVO> |
getAttData(EduAttendanceVO eduAttendanceVO)
개인 강의출석부 가져오기 |
java.lang.String |
getAttDate(EduAttendanceVO eduAttendanceVO)
자신이 신청한 교육의 접수일자를 조회 |
int |
getAttDuplicateCount(EduCationApplyVO eduCationApplyVO)
해당 교육에 중복 신청여부 |
EduCationVO |
getAttInDate(EduCationVO eduCationVO)
해당교육장소에서 접수중인 교육건 조회(1건만) |
int |
getAttIngCount(long studentIdx)
수강시작일+5일이 지나지 않은 수강 진행중인 과목 횟수(강의 종료일이 지나지 않은 과목 count) |
EduCationVO |
getAttIngLecture(long studentIdx)
수강시작일+5일이 지나지 않은 수강 진행중인 과목 정보 가져오기 |
EduCationVO |
getAttNextDate(EduCationVO eduCationVO)
다음 강의정보 가져오기 |
int |
getAttStatus(EduAttendanceVO eduAttendanceVO)
현재 출석상태 |
int |
getAttStatusCount(EduCationApplyVO eduCationApplyVO)
수강신청 내 앞으로 몇명 있는지 여부 |
java.util.List<EduCationApplyVO> |
getAttStudentIdx(EduCationApplyVO eduCationApplyVO)
승인된 신청자 목록 |
int |
getCountAllSubject(EduCationApplyVO eduCationApplyVO)
수강횟수(전체 수강정보에 대해서 수강 count) |
int |
getCountSubject(EduCationApplyVO eduCationApplyVO)
수강횟수(동일 과목에 대해서 2년 이내의 수강 count) |
int |
getDuplicateCount(EduCationApplyVO eduCationApplyVO)
수강횟수(수강일정이 중복된 신청 count) |
EduCationVO |
getEduCationInfo(long idx)
교육 정보 |
java.util.List<EduCationVO> |
getEduLectureList(EduCationVO eduCationVO)
홈페이지 메인에서 일부 목록 뿌리기 |
EduPlaceVO |
getEduPlaceInfo(long idx)
강의실 정보 |
EduSubjectVO |
getEduSubjectInfo(long idx)
과목 정보 |
int |
getLectureReportData(EduReportVO eduReportVO)
강의출석부 해당날짜 자료의 존재여부 |
java.util.List<MberManageVO> |
getMemberEtcInfo(MberManageVO mberManageVO)
회원정보 목록 |
int |
getMemberInfoCnt(MberManageVO mberManageVO)
회원정보 카운트 |
java.lang.String |
getMemInfo(java.lang.String userEtc1)
회원정보 |
int |
getSearchTotalCount(EduCationApplyVO eduCationApplyVO)
수강신청 검색 총갯수 |
EduCationApplyVO |
getStatAttend0(EduAttendanceVO eduAttendanceVO)
대기자순번 알아오기 |
EduCationApplyVO |
getStatAttend2(EduAttendanceVO eduAttendanceVO)
수강신청불가일 경우 사유출력 |
java.util.List<EduCationVO> |
getStatistics(EduCationVO eduCationVO)
수강통계 |
java.util.List<EduCationVO> |
getYearList(EduCationVO eduCationVO)
해당 교육장소에서 해당년에 하는 교육정보 |
void |
insertApplyer(EduCationApplyVO eduCationApplyVO)
수강신청 저장 |
void |
insertEduCation(EduCationVO eduCationVO)
교육 등록 |
void |
insertEduSubject(EduSubjectVO eduSubjectVO)
과목 등록 |
void |
isDelete(EduCationApplyVO eduCationApplyVO)
자신의 수강신청내역 삭제 |
void |
isModify(EduReportVO eduReportVO)
출석부(일자별) 업데이트(관리자) |
void |
isWrite(EduReportVO eduReportVO)
출석부(일자별) 등록 |
void |
lectureAttendanceDatesModify(EduAttendanceVO eduAttendanceVO)
교육정보에서 해당교육 출석정보 수정 |
void |
lectureAttendanceResetModify(EduAttendanceVO eduAttendanceVO)
수강신청 정보에서 해당교육을 수강중인 학생들의 상태값을 승인중 으로 변경시킨다. |
void |
lectureAttendanceStudentModify(EduAttendanceVO eduAttendanceVO)
수강신청 정보에서 해당교육을 듣고있는 선택된 학생들에대해 상태값을 수정한다(수강중으로) |
int |
selectAfterCount(EduAfterVO eduAfterVO)
해당 강의에 소감문을 등록햇는지 여부 |
int |
selectAfterDistinctCount(EduAfterVO eduAfterVO)
해당 강의의 소감문등록한 사람수 |
java.util.List<EduAfterVO> |
selectAfterQuestionAnswer(EduAfterVO eduAfterVO)
해당 강의의 각 문항별 답변목록 |
java.util.List<EduCationApplyVO> |
selectApplyerList(EduCationApplyVO eduCationApplyVO)
신청자 목록 |
int |
selectApplyerListTotal(EduCationApplyVO eduCationApplyVO)
신청자 목록 카운트 |
int |
selectApplyerListTotal2(EduCationApplyVO eduCationApplyVO)
신청자 목록 카운트 |
int |
selectCertificateNumMaxNum(EduCationApplyVO eduCationApplyVO)
해당 과목의 올해 수료번호 가장큰값 구하기 |
int |
selectCertificateValue(EduCationApplyVO eduCationApplyVO)
해당 과목의 해당학생 수료번호가 있는지 유무 |
java.util.List<EduCationVO> |
selectEduCationList(EduCationVO eduCationVO)
교육 전체 목록 |
int |
selectEduCationListTotal(EduCationVO eduCationVO)
교육전체리스트 카운트 |
java.util.List<EduPlaceVO> |
selectEduPlaceList(EduPlaceVO eduPlaceVO)
강의실 전체 목록 |
int |
selectEduPlaceListTotal(EduPlaceVO eduPlaceVO)
강의실전체리스트 카운트 |
java.util.List<EduSubjectVO> |
selectEduSubjectList(EduSubjectVO eduSubjectVO)
과목 전체 목록 |
int |
selectEduSubjectListTotal(EduSubjectVO eduSubjectVO)
과목전체리스트 카운트 |
java.util.List<UserManageVO> |
selectMberTeacherList(UserManageVO userManageVO)
강사 전체 목록 |
java.util.List<EduCationApplyVO> |
selectMyApplyList1(EduCationApplyVO eduCationApplyVO)
내가 수강신청한 강의 |
java.util.List<EduCationApplyVO> |
selectMyApplyList2(EduCationApplyVO eduCationApplyVO)
내가 수강중인 강의 |
java.util.List<EduCationApplyVO> |
selectMyApplyList3(EduCationApplyVO eduCationApplyVO)
내가 수강한 강의 |
java.util.List<EduSubjectVO> |
selectSubjectList(EduSubjectVO eduSubjectVO)
과목 전체 목록 |
void |
updateApplyer(EduCationApplyVO eduCationApplyVO)
수강 신청자 수정 |
void |
updateApplyerFinishStatus(EduCationApplyVO eduCationApplyVO)
교육이수 상태 수정 |
void |
updateAttendingCertificateNum(EduCationApplyVO eduCationApplyVO)
해당 수강정보 수료번호 업데이트 |
void |
updateEduCation(EduCationVO eduCationVO)
교육 수정 |
void |
updateEduPlace(EduPlaceVO eduPlaceVO)
강의실 수정 |
void |
updateEduSubject(EduSubjectVO eduSubjectVO)
과목 수정 |
void |
updateRejectApplyer(EduCationApplyVO eduCationApplyVO)
교육이수 불가 사유 수정 |
Methods inherited from class egovframework.rfc3.common.dao.RfcCMSAbstractDAO |
---|
delete, desDecoding, desDecoding2, desDecodingList, desDecodingList2, desEncoding, desEncoding2, 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 |
---|
public EduCationDAO()
Method Detail |
---|
public int selectEduCationListTotal(EduCationVO eduCationVO) throws java.lang.Exception
eduCationVO
-
java.lang.Exception
public java.util.List<EduCationVO> selectEduCationList(EduCationVO eduCationVO) throws java.lang.Exception
eduCationVO
-
java.lang.Exception
public EduCationVO getEduCationInfo(long idx) throws java.lang.Exception
idx
-
java.lang.Exception
public void insertEduCation(EduCationVO eduCationVO) throws java.lang.Exception
eduCationVO
-
java.lang.Exception
public void updateEduCation(EduCationVO eduCationVO) throws java.lang.Exception
eduCationVO
-
java.lang.Exception
public void deleteEduCation(long idx) throws java.lang.Exception
idx
-
java.lang.Exception
public void deleteApplyer(long idx) throws java.lang.Exception
idx
-
java.lang.Exception
public void deleteAttendance(long idx) throws java.lang.Exception
idx
-
java.lang.Exception
public void deleteEduReport(long idx) throws java.lang.Exception
idx
-
java.lang.Exception
public int selectApplyerListTotal(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public int selectApplyerListTotal2(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public java.util.List<EduCationApplyVO> selectApplyerList(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public java.util.List<EduCationApplyVO> getAttStudentIdx(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public EduCationApplyVO getApplyerInfo(long idx) throws java.lang.Exception
EduCationApplyVO
-
java.lang.Exception
public java.util.List<EduCationApplyVO> firstWait(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
EduCationApplyVO
-
java.lang.Exception
public void insertApplyer(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
EduCationApplyVO
-
java.lang.Exception
public void updateApplyer(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public void updateApplyerFinishStatus(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public void updateRejectApplyer(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public java.util.List<UserManageVO> selectMberTeacherList(UserManageVO userManageVO) throws java.lang.Exception
UserManageVO
-
java.lang.Exception
public java.util.List<MberManageVO> getMemberEtcInfo(MberManageVO mberManageVO) throws java.lang.Exception
MberManageVO
-
java.lang.Exception
public int getMemberInfoCnt(MberManageVO mberManageVO) throws java.lang.Exception
mberManageVO
-
java.lang.Exception
public int getSearchTotalCount(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public void attendingStatusModify(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public void attendingStatusModify2(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public void AttendingStatusModify(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public void AttendingCancelModify(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public int selectEduPlaceListTotal(EduPlaceVO eduPlaceVO) throws java.lang.Exception
eduPlaceVO
-
java.lang.Exception
public java.util.List<EduPlaceVO> selectEduPlaceList(EduPlaceVO eduPlaceVO) throws java.lang.Exception
eduPlaceVO
-
java.lang.Exception
public EduPlaceVO getEduPlaceInfo(long idx) throws java.lang.Exception
idx
-
java.lang.Exception
public void updateEduPlace(EduPlaceVO eduPlaceVO) throws java.lang.Exception
eduPlaceVO
-
java.lang.Exception
public int selectEduSubjectListTotal(EduSubjectVO eduSubjectVO) throws java.lang.Exception
eduSubjectVO
-
java.lang.Exception
public java.util.List<EduSubjectVO> selectEduSubjectList(EduSubjectVO eduSubjectVO) throws java.lang.Exception
eduSubjectVO
-
java.lang.Exception
public EduSubjectVO getEduSubjectInfo(long idx) throws java.lang.Exception
idx
-
java.lang.Exception
public void insertEduSubject(EduSubjectVO eduSubjectVO) throws java.lang.Exception
eduSubjectVO
-
java.lang.Exception
public void updateEduSubject(EduSubjectVO eduSubjectVO) throws java.lang.Exception
eduSubjectVO
-
java.lang.Exception
public void deleteEduSubject(long idx) throws java.lang.Exception
idx
-
java.lang.Exception
public java.util.List<EduSubjectVO> selectSubjectList(EduSubjectVO eduSubjectVO) throws java.lang.Exception
eduSubjectVO
-
java.lang.Exception
public void lectureAttendanceDatesModify(EduAttendanceVO eduAttendanceVO) throws java.lang.Exception
eduAttendanceVO
-
java.lang.Exception
public void lectureAttendanceStudentModify(EduAttendanceVO eduAttendanceVO) throws java.lang.Exception
eduAttendanceVO
-
java.lang.Exception
public void lectureAttendanceResetModify(EduAttendanceVO eduAttendanceVO) throws java.lang.Exception
eduAttendanceVO
-
java.lang.Exception
public java.util.List<EduAttendanceVO> getAttData(EduAttendanceVO eduAttendanceVO) throws java.lang.Exception
eduAttendanceVO
-
java.lang.Exception
public int getAttStatus(EduAttendanceVO eduAttendanceVO) throws java.lang.Exception
eduAttendanceVO
-
java.lang.Exception
public java.lang.String getMemInfo(java.lang.String userEtc1) throws java.lang.Exception
String
-
java.lang.Exception
public int getLectureReportData(EduReportVO eduReportVO) throws java.lang.Exception
eduAttendanceVO
-
java.lang.Exception
public void isModify(EduReportVO eduReportVO) throws java.lang.Exception
eduReportVO
-
java.lang.Exception
public void isWrite(EduReportVO eduReportVO) throws java.lang.Exception
eduReportVO
-
java.lang.Exception
public void batchModify(EduAttendanceVO eduAttendanceVO) throws java.lang.Exception
eduAttendanceVO
-
java.lang.Exception
public void deleteAttendanceDate(EduReportVO eduReportVO) throws java.lang.Exception
eduReportVO
-
java.lang.Exception
public void attenddingUpdate1(EduReportVO eduReportVO) throws java.lang.Exception
eduReportVO
-
java.lang.Exception
public void attenddingUpdate2(EduReportVO eduReportVO) throws java.lang.Exception
eduReportVO
-
java.lang.Exception
public void attenddingUpdate3(EduReportVO eduReportVO) throws java.lang.Exception
eduReportVO
-
java.lang.Exception
public java.util.List<EduCationVO> getEduLectureList(EduCationVO eduCationVO) throws java.lang.Exception
eduCationVO
-
java.lang.Exception
public java.util.List<EduCationVO> getYearList(EduCationVO eduCationVO) throws java.lang.Exception
eduCationVO
-
java.lang.Exception
public int getAttDuplicateCount(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public EduCationVO getAttInDate(EduCationVO eduCationVO) throws java.lang.Exception
eduCationVO
-
java.lang.Exception
public EduCationVO getAttNextDate(EduCationVO eduCationVO) throws java.lang.Exception
eduCationVO
-
java.lang.Exception
public int getAttCount(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public int getAttStatusCount(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public int getAttIngCount(long studentIdx) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public EduCationVO getAttIngLecture(long studentIdx) throws java.lang.Exception
eduCationVO
-
java.lang.Exception
public int getDuplicateCount(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public void AttendingStatusUpdate(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduReportVO
-
java.lang.Exception
public int getCountSubject(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public int getCountAllSubject(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
studentIdx
-
java.lang.Exception
public void eduCationIsWrite(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
java.lang.Exception
public java.lang.String getAttDate(EduAttendanceVO eduAttendanceVO) throws java.lang.Exception
eduAttendanceVO
-
java.lang.Exception
public void isDelete(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public java.util.List<EduCationApplyVO> selectMyApplyList1(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public java.util.List<EduCationApplyVO> selectMyApplyList2(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public java.util.List<EduCationApplyVO> selectMyApplyList3(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public EduCationApplyVO getStatAttend0(EduAttendanceVO eduAttendanceVO) throws java.lang.Exception
eduAttendanceVO
-
java.lang.Exception
public EduCationApplyVO getStatAttend2(EduAttendanceVO eduAttendanceVO) throws java.lang.Exception
eduAttendanceVO
-
java.lang.Exception
public java.util.List<EduCationVO> getStatistics(EduCationVO eduCationVO) throws java.lang.Exception
eduCationVO
-
java.lang.Exception
public void addlectureDate(EduCationVO eduCationVO) throws java.lang.Exception
eduCationVO
-
java.lang.Exception
public void eduAfterInsert(EduAfterVO eduAfterVO) throws java.lang.Exception
eduAfterVO
-
java.lang.Exception
public int selectAfterCount(EduAfterVO eduAfterVO) throws java.lang.Exception
eduAfterVO
-
java.lang.Exception
public int selectAfterDistinctCount(EduAfterVO eduAfterVO) throws java.lang.Exception
eduAfterVO
-
java.lang.Exception
public java.util.List<EduAfterVO> selectAfterQuestionAnswer(EduAfterVO eduAfterVO) throws java.lang.Exception
eduCationVO
-
java.lang.Exception
public int selectCertificateNumMaxNum(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public void updateAttendingCertificateNum(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
public int selectCertificateValue(EduCationApplyVO eduCationApplyVO) throws java.lang.Exception
eduCationApplyVO
-
java.lang.Exception
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |