/**
* 등록된 휴가관리의 상세정보를 조회한다.
*
* @param vcatnManageVO - 휴가관리 VO
* @return String - 리턴 Url
*/
@RequestMapping(value = "/uss/ion/vct/EgovVcatnManageDetail.do")
public String selectVcatnManage(
@ModelAttribute("vcatnManageVO") VcatnManageVO vcatnManageVO,
@ModelAttribute("vcatnManage") VcatnManage vcatnManage,
@RequestParam Map<?, ?> commandMap,
ModelMap model)
throws Exception {
List<?> vcatnSeCodeList = null;
String sCmd = commandMap.get("cmd") == null ? "" : (String) commandMap.get("cmd"); // 상세정보 구분
vcatnManageVO.setBgnde(EgovStringUtil.removeMinusChar(vcatnManageVO.getBgnde()));
vcatnManageVO.setEndde(EgovStringUtil.removeMinusChar(vcatnManageVO.getEndde()));
// 등록 상세정보
VcatnManageVO vcatnManageVOTemp = egovVcatnManageService.selectVcatnManage(vcatnManageVO);
model.addAttribute("vcatnManageVO", vcatnManageVOTemp);
model.addAttribute("message", egovMessageSource.getMessage("success.common.select"));
if (sCmd.equals("updt")) {
ComDefaultCodeVO vo = new ComDefaultCodeVO();
vo.setCodeId("COM056");
vcatnSeCodeList = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("vcatnSeCode", vcatnSeCodeList);
model.addAttribute("vcatnManage", vcatnManageVOTemp);
return "egovframework/com/uss/ion/vct/EgovVcatnUpdt";
} else {
return "egovframework/com/uss/ion/vct/EgovVcatnDetail";
}
}
/**
* 신규 게시판 마스터 등록을 위한 등록페이지로 이동한다.
*
* @param boardMasterVO
* @param model
* @return
* @throws Exception
*/
@RequestMapping("/cop/bbs/addBBSMaster.do")
public String addBBSMaster(
@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model) throws Exception {
BoardMaster boardMaster = new BoardMaster();
ComDefaultCodeVO vo = new ComDefaultCodeVO();
vo.setCodeId("COM004");
List<?> codeResult = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("typeList", codeResult);
vo.setCodeId("COM009");
codeResult = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("attrbList", codeResult);
model.addAttribute("boardMaster", boardMaster);
String flag = propertyService.getString("Globals.addedOptions");
if (flag != null && flag.trim().equalsIgnoreCase("true")) {
model.addAttribute("addedOptions", "true");
}
return "cop/bbs/EgovBoardMstrRegist";
}
/**
* JDBC 테이블 목록을조회한다.
*
* @return List -조회한목록이담긴List
* @throws Exception
*/
@SuppressWarnings("deprecation")
public List<ComDefaultCodeVO> selectRssTagManageTableList() throws Exception {
String TABLE_NAME = "TABLE_NAME";
String TABLE_SCHEMA = "TABLE_SCHEM";
String[] TABLE_AND_VIEW_TYPES = {"TABLE", "VIEW"};
ArrayList<ComDefaultCodeVO> arrListResult = new ArrayList<ComDefaultCodeVO>();
Connection conn = null;
DatabaseMetaData dbmd = null;
ResultSet tables = null;
try {
conn = getSqlMapClientTemplate().getDataSource().getConnection();
dbmd = conn.getMetaData();
tables = dbmd.getTables(null, null, null, TABLE_AND_VIEW_TYPES);
while (tables.next()) {
ComDefaultCodeVO codeVO = new ComDefaultCodeVO();
codeVO.setCode(tables.getString(TABLE_NAME));
codeVO.setCodeNm(tables.getString(TABLE_SCHEMA));
arrListResult.add((ComDefaultCodeVO) codeVO);
}
} finally {
EgovResourceCloseHelper.closeDBObjects(tables, conn);
}
return arrListResult;
}
/**
* 승인(탈퇴)요청 확인 처리를 위해 수정페이지로 이동한다.
*
* @param historyVO
* @param status
* @param model
* @return
* @throws Exception
*/
@SuppressWarnings("unchecked")
@RequestMapping("/cop/com/forUpdateConfirmRequest.do")
public String forUpdateConfirmRequest(
@ModelAttribute("searchVO") ConfirmHistoryVO historyVO, SessionStatus status, ModelMap model)
throws Exception {
LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
historyVO.setConfmerId(user.getUniqId());
if (isAuthenticated) {
ConfirmHistoryVO vo = confmService.selectSingleConfirmRequest(historyVO);
model.addAttribute("historyVO", vo);
}
ComDefaultCodeVO vo = new ComDefaultCodeVO();
vo.setCodeId("COM007");
List codeResult = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("typeList", codeResult);
return "egovframework/com/cop/com/EgovConfmInfUpdt";
}
/**
* 설문문항 목록을 상세조회 조회한다.
*
* @param searchVO
* @param qustnrQestnManageVO
* @param commandMap
* @param model
* @return "egovframework/com/uss/olp/qqm/EgovQustnrQestnManageDetail"
* @throws Exception
*/
@RequestMapping(value = "/uss/olp/qqm/EgovQustnrQestnManageDetail.do")
public String egovQustnrQestnManageDetail(
@ModelAttribute("searchVO") ComDefaultVO searchVO,
@ModelAttribute("qustnrQestnManageVO") QustnrQestnManageVO qustnrQestnManageVO,
Map commandMap,
ModelMap model)
throws Exception {
String sLocationUrl = "egovframework/com/uss/olp/qqm/EgovQustnrQestnManageDetail";
String sCmd = commandMap.get("cmd") == null ? "" : (String) commandMap.get("cmd");
if (sCmd.equals("del")) {
egovQustnrQestnManageService.deleteQustnrQestnManage(qustnrQestnManageVO);
/** 목록으로갈때 검색조건 유지 */
sLocationUrl = "redirect:/uss/olp/qqm/EgovQustnrQestnManageList.do?";
sLocationUrl = sLocationUrl + "searchMode=" + qustnrQestnManageVO.getSearchMode();
sLocationUrl = sLocationUrl + "&qestnrId=" + qustnrQestnManageVO.getQestnrId();
sLocationUrl = sLocationUrl + "&qestnrTmplatId=" + qustnrQestnManageVO.getQestnrTmplatId();
} else {
// 공통코드 질문유형 조회
ComDefaultCodeVO voComCode = new ComDefaultCodeVO();
voComCode.setCodeId("COM018");
List listComCode = cmmUseService.selectCmmCodeDetail(voComCode);
model.addAttribute("cmmCode018", listComCode);
List sampleList =
egovQustnrQestnManageService.selectQustnrQestnManageDetail(qustnrQestnManageVO);
model.addAttribute("resultList", sampleList);
}
return sLocationUrl;
}
/**
* 설문관리 목록을 상세조회 조회한다.
*
* @param searchVO
* @param qustnrManageVO
* @param commandMap
* @param model
* @return "egovframework/com/uss/olp/qmc/EgovQustnrManageDetail";
* @throws Exception
*/
@RequestMapping(value = "/uss/olp/qmc/EgovQustnrManageDetail.do")
public String egovQustnrManageDetail(
@ModelAttribute("searchVO") ComDefaultVO searchVO,
QustnrManageVO qustnrManageVO,
@CommandMap Map commandMap,
ModelMap model)
throws Exception {
String sLocationUrl = "egovframework/com/uss/olp/qmc/EgovQustnrManageDetail";
String sCmd = commandMap.get("cmd") == null ? "" : (String) commandMap.get("cmd");
if (sCmd.equals("del")) {
egovQustnrManageService.deleteQustnrManage(qustnrManageVO);
sLocationUrl = "redirect:/uss/olp/qmc/EgovQustnrManageList.do";
} else {
// 공통코드 직업유형 조회
ComDefaultCodeVO voComCode = new ComDefaultCodeVO();
voComCode.setCodeId("COM034");
List listComCode = cmmUseService.selectCmmCodeDetail(voComCode);
model.addAttribute("comCode034", listComCode);
List sampleList = egovQustnrManageService.selectQustnrManageDetail(qustnrManageVO);
model.addAttribute("resultList", sampleList);
}
return sLocationUrl;
}
/**
* 기업회원목록을 조회한다. (pageing)
*
* @param userSearchVO 검색조건정보
* @param model 화면모델
* @return uss/umt/EgovEntrprsMberManage
* @throws Exception
*/
@IncludedInfo(name = "기업회원관리", order = 450, gid = 50)
@RequestMapping(value = "/uss/umt/EgovEntrprsMberManage.do")
public String selectEntrprsMberList(
@ModelAttribute("userSearchVO") UserDefaultVO userSearchVO, ModelMap model) throws Exception {
/** EgovPropertyService.sample */
userSearchVO.setPageUnit(propertiesService.getInt("pageUnit"));
userSearchVO.setPageSize(propertiesService.getInt("pageSize"));
/** pageing */
PaginationInfo paginationInfo = new PaginationInfo();
paginationInfo.setCurrentPageNo(userSearchVO.getPageIndex());
paginationInfo.setRecordCountPerPage(userSearchVO.getPageUnit());
paginationInfo.setPageSize(userSearchVO.getPageSize());
userSearchVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
userSearchVO.setLastIndex(paginationInfo.getLastRecordIndex());
userSearchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
List entrprsList = entrprsManageService.selectEntrprsMberList(userSearchVO);
model.addAttribute("resultList", entrprsList);
int totCnt = entrprsManageService.selectEntrprsMberListTotCnt(userSearchVO);
paginationInfo.setTotalRecordCount(totCnt);
model.addAttribute("paginationInfo", paginationInfo);
// 사용자상태코드를 코드정보로부터 조회
ComDefaultCodeVO vo = new ComDefaultCodeVO();
vo.setCodeId("COM013");
List entrprsMberSttus_result = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("entrprsMberSttus_result", entrprsMberSttus_result); // 기업회원상태코드목록
return "egovframework/com/uss/umt/EgovEntrprsMberManage";
}
/**
* 설문관리를 등록한다.
*
* @param searchVO
* @param commandMap
* @param qustnrManageVO
* @param bindingResult
* @param model
* @return "egovframework/com/uss/olp/qmc/EgovQustnrManageRegist"
* @throws Exception
*/
@RequestMapping(value = "/uss/olp/qmc/EgovQustnrManageRegist.do")
public String qustnrManageRegist(
@ModelAttribute("searchVO") ComDefaultVO searchVO,
@CommandMap Map commandMap,
@ModelAttribute("qustnrManageVO") QustnrManageVO qustnrManageVO,
BindingResult bindingResult,
ModelMap model)
throws Exception {
// 0. Spring Security 사용자권한 처리
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if (!isAuthenticated) {
model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
return "egovframework/com/uat/uia/EgovLoginUsr";
}
// 로그인 객체 선언
LoginVO loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
String sLocationUrl = "egovframework/com/uss/olp/qmc/EgovQustnrManageRegist";
String sCmd = commandMap.get("cmd") == null ? "" : (String) commandMap.get("cmd");
LOGGER.info("cmd => {}", sCmd);
// 공통코드 직업유형 조회
ComDefaultCodeVO voComCode = new ComDefaultCodeVO();
voComCode.setCodeId("COM034");
List listComCode = cmmUseService.selectCmmCodeDetail(voComCode);
model.addAttribute("comCode034", listComCode);
if (sCmd.equals("save")) {
beanValidator.validate(qustnrManageVO, bindingResult);
if (bindingResult.hasErrors()) {
// 설문템플릿 정보 불러오기
List listQustnrTmplat =
egovQustnrManageService.selectQustnrTmplatManageList(qustnrManageVO);
model.addAttribute("listQustnrTmplat", listQustnrTmplat);
return sLocationUrl;
}
// 아이디 설정
qustnrManageVO.setFrstRegisterId((String) loginVO.getUniqId());
qustnrManageVO.setLastUpdusrId((String) loginVO.getUniqId());
egovQustnrManageService.insertQustnrManage(qustnrManageVO);
sLocationUrl = "redirect:/uss/olp/qmc/EgovQustnrManageList.do";
} else {
// 설문템플릿 정보 불러오기
List listQustnrTmplat = egovQustnrManageService.selectQustnrTmplatManageList(qustnrManageVO);
model.addAttribute("listQustnrTmplat", listQustnrTmplat);
}
return sLocationUrl;
}
/**
* 게시판 사용을 위한 신규 게시판 속성정보를 생성한다.
*
* @param boardMasterVO
* @param boardMaster
* @param bindingResult
* @param status
* @param model
* @return
* @throws Exception
*/
@RequestMapping("/cop/bbs/insertBdMstrByTrget.do")
public String insertBdMstrByTrget(
@ModelAttribute("searchVO") BoardMasterVO boardMasterVO,
@ModelAttribute("boardMaster") BoardMaster boardMaster,
BindingResult bindingResult,
SessionStatus status,
ModelMap model)
throws Exception {
checkAuthority(boardMasterVO); // server-side 권한 확인
LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
beanValidator.validate(boardMaster, bindingResult);
if (bindingResult.hasErrors()) {
ComDefaultCodeVO vo = new ComDefaultCodeVO();
vo.setCodeId("COM004");
List<?> codeResult = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("typeList", codeResult);
vo.setCodeId("COM009");
codeResult = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("attrbList", codeResult);
return "cop/bbs/EgovBdMstrRegistByTrget";
}
boardMaster.setFrstRegisterId(user.getUniqId());
boardMaster.setUseAt("Y");
boardMaster.setBbsUseFlag("Y");
String registSeCode = "REGC06";
if ("CLB".equals(EgovStringUtil.cutString(boardMaster.getTrgetId(), 3))) {
registSeCode = "REGC05";
}
boardMaster.setRegistSeCode(registSeCode);
if (isAuthenticated) {
bbsAttrbService.insertBBSMastetInf(boardMaster);
model.addAttribute("S_FLAG", "S");
}
return "forward:/cop/bbs/selectBdMstrListByTrget.do";
}
/**
* 부서업무 정보를 조회한다.
*
* @param DeptJobVO
* @return String
* @param deptJobVO
*/
@RequestMapping("/cop/smt/djm/selectDeptJob.do")
public String selectDeptJob(@ModelAttribute("deptJobVO") DeptJobVO deptJobVO, ModelMap model)
throws Exception {
DeptJob deptJob = deptJobService.selectDeptJob(deptJobVO);
model.addAttribute("deptJob", deptJob);
/*
* 공통코드
* 우선순위 조회
*/
ComDefaultCodeVO voComCode = new ComDefaultCodeVO();
voComCode.setCodeId("COM059");
List<CmmnDetailCode> listComCode = cmmUseService.selectCmmCodeDetail(voComCode);
model.addAttribute("priort", listComCode);
return "egovframework/com/cop/smt/djm/EgovDeptJobDetail";
}
/**
* Q&A답변정보를 수정하기 위한 전 처리(공통코드 처리)
*
* @param qnaManageVO
* @param searchVO
* @param model
* @return "/uss/olh/qna/EgovQnaCnAnswerUpdt"
* @throws Exception
*/
@RequestMapping("/uss/olh/qnm/QnaCnAnswerUpdtView.do")
public String updateQnaCnAnswerView(
QnaManageVO qnaManageVO,
@ModelAttribute("searchVO") QnaManageDefaultVO searchVO,
ModelMap model)
throws Exception {
// 공통코드를 가져오기 위한 Vo
ComDefaultCodeVO vo = new ComDefaultCodeVO();
vo.setCodeId("COM028");
model.addAttribute("resultList", cmmUseService.selectCmmCodeDetail(vo));
// 변수명은 CoC 에 따라
model.addAttribute(selectQnaAnswerListDetail(qnaManageVO, searchVO, model));
return "/uss/olh/qna/EgovQnaCnAnswerUpdt";
}
/**
* 신규 게시판 마스터 정보를 등록한다.
*
* @param boardMasterVO
* @param boardMaster
* @param status
* @return
* @throws Exception
*/
@RequestMapping("/cop/bbs/insertBBSMasterInf.do")
public String insertBBSMasterInf(
@ModelAttribute("searchVO") BoardMasterVO boardMasterVO,
@ModelAttribute("boardMaster") BoardMaster boardMaster,
BindingResult bindingResult,
SessionStatus status,
ModelMap model)
throws Exception {
LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
beanValidator.validate(boardMaster, bindingResult);
if (bindingResult.hasErrors()) {
ComDefaultCodeVO vo = new ComDefaultCodeVO();
vo.setCodeId("COM004");
List<?> codeResult = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("typeList", codeResult);
vo.setCodeId("COM009");
codeResult = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("attrbList", codeResult);
return "cop/bbs/EgovBoardMstrRegist";
}
if (isAuthenticated) {
boardMaster.setFrstRegisterId(user.getUniqId());
boardMaster.setUseAt("Y");
boardMaster.setTrgetId("SYSTEMDEFAULT_REGIST");
boardMaster.setPosblAtchFileSize(propertyService.getString("posblAtchFileSize"));
bbsAttrbService.insertBBSMastetInf(boardMaster);
}
return "forward:/cop/bbs/SelectBBSMasterInfs.do";
}
/**
* 시간의 LIST를 반환한다.
*
* @return List
* @throws
*/
private List<ComDefaultCodeVO> getTimeHH() {
ArrayList<ComDefaultCodeVO> listHH = new ArrayList<ComDefaultCodeVO>();
// HashMap hmHHMM;
for (int i = 0; i < 24; i++) {
String sHH = "";
String strI = String.valueOf(i);
if (i < 10) {
sHH = "0" + strI;
} else {
sHH = strI;
}
ComDefaultCodeVO codeVO = new ComDefaultCodeVO();
codeVO.setCode(sHH);
codeVO.setCodeNm(sHH + ":00");
listHH.add(codeVO);
}
return listHH;
}
/**
* 기업회원가입신청 등록화면으로 이동한다.
*
* @param userSearchVO 검색조건정보
* @param entrprsManageVO 기업회원초기화정보
* @param commandMap 파라메터전송 commandMap
* @param model 화면모델
* @return uss/umt/EgovEntrprsMberSbscrb
* @throws Exception
*/
@RequestMapping("/uss/umt/EgovEntrprsMberSbscrbView.do")
public String sbscrbEntrprsMberView(
@ModelAttribute("userSearchVO") UserDefaultVO userSearchVO,
@ModelAttribute("entrprsManageVO") EntrprsManageVO entrprsManageVO,
Map<String, Object> commandMap,
Model model)
throws Exception {
ComDefaultCodeVO vo = new ComDefaultCodeVO();
// 패스워드힌트목록을 코드정보로부터 조회
vo.setCodeId("COM022");
List passwordHint_result = cmmUseService.selectCmmCodeDetail(vo);
// 성별구분코드를 코드정보로부터 조회
vo.setCodeId("COM014");
List sexdstnCode_result = cmmUseService.selectCmmCodeDetail(vo);
// 기업구분코드를 코드정보로부터 조회 - COM026
vo.setCodeId("COM026");
List entrprsSeCode_result = cmmUseService.selectCmmCodeDetail(vo);
// 업종코드를 코드정보로부터 조회 - COM027
vo.setCodeId("COM027");
List indutyCode_result = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("passwordHint_result", passwordHint_result); // 패스워트힌트목록
model.addAttribute("sexdstnCode_result", sexdstnCode_result); // 성별구분코드목록
model.addAttribute("entrprsSeCode_result", entrprsSeCode_result); // 기업구분코드 목록
model.addAttribute("indutyCode_result", indutyCode_result); // 업종코드목록
if (!"".equals((String) commandMap.get("realname"))) {
model.addAttribute("applcntNm", (String) commandMap.get("realname")); // 실명인증된 이름 - 주민번호인증
model.addAttribute(
"applcntIhidnum", (String) commandMap.get("ihidnum")); // 실명인증된 주민등록번호 - 주민번호 인증
}
if (!"".equals((String) commandMap.get("realName"))) {
model.addAttribute("applcntNm", (String) commandMap.get("realName")); // 실명인증된 이름 - ipin인증
}
// entrprsManageVO.setGroupId("DEFAULT");
entrprsManageVO.setEntrprsMberSttus("DEFAULT");
return "egovframework/com/uss/umt/EgovEntrprsMberSbscrb";
}
/**
* 휴가관리 등록 화면으로 이동한다.
*
* @return String - 리턴 Url
*/
@RequestMapping(value = "/uss/ion/vct/EgovVcatnRegist.do")
public String insertViewVcatnManage(
@ModelAttribute("vcatnManage") VcatnManage vcatnManage,
@ModelAttribute("vcatnManageVO") VcatnManageVO vcatnManageVO,
ModelMap model)
throws Exception {
List<?> vcatnSeCodeList = null;
LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
VcatnManageVO vcatnManageVO1 = egovVcatnManageService.selectIndvdlYrycManage(user.getUniqId());
vcatnManageVO1.setApplcntId(user.getUniqId());
vcatnManageVO1.setApplcntNm(user.getName());
vcatnManageVO1.setOrgnztNm(user.getOrgnztNm());
ComDefaultCodeVO vo = new ComDefaultCodeVO();
vo.setCodeId("COM056");
vcatnSeCodeList = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("vcatnSeCode", vcatnSeCodeList);
model.addAttribute("vcatnManageVO", vcatnManageVO1);
return "egovframework/com/uss/ion/vct/EgovVcatnRegist";
}
/**
* 기업회원정보 수정을 위해기업회원정보를 상세조회한다.
*
* @param entrprsmberId 상세조회 대상 기업회원아이디
* @param userSearchVO 조회조건정보
* @param model 화면모델
* @return uss/umt/EgovEntrprsMberSelectUpdt
* @throws Exception
*/
@RequestMapping("/uss/umt/EgovEntrprsMberSelectUpdtView.do")
public String updateEntrprsMberView(
@RequestParam("selectedId") String entrprsmberId,
@ModelAttribute("searchVO") UserDefaultVO userSearchVO,
Model model)
throws Exception {
EntrprsManageVO entrprsManageVO = new EntrprsManageVO();
entrprsManageVO = entrprsManageService.selectEntrprsmber(entrprsmberId);
model.addAttribute("entrprsManageVO", entrprsManageVO);
model.addAttribute("userSearchVO", userSearchVO);
ComDefaultCodeVO vo = new ComDefaultCodeVO();
// 패스워드힌트목록을 코드정보로부터 조회
vo.setCodeId("COM022");
List passwordHint_result = cmmUseService.selectCmmCodeDetail(vo);
// 성별구분코드를 코드정보로부터 조회
vo.setCodeId("COM014");
List sexdstnCode_result = cmmUseService.selectCmmCodeDetail(vo);
// 사용자상태코드를 코드정보로부터 조회
vo.setCodeId("COM013");
List entrprsMberSttus_result = cmmUseService.selectCmmCodeDetail(vo);
// 그룹정보를 조회 - GROUP_ID정보
vo.setTableNm("COMTNORGNZTINFO");
List groupId_result = cmmUseService.selectGroupIdDetail(vo);
// 기업구분코드를 코드정보로부터 조회 - COM026
vo.setCodeId("COM026");
List entrprsSeCode_result = cmmUseService.selectCmmCodeDetail(vo);
// 업종코드를 코드정보로부터 조회 - COM027
vo.setCodeId("COM027");
List indutyCode_result = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("passwordHint_result", passwordHint_result); // 패스워트힌트목록
model.addAttribute("sexdstnCode_result", sexdstnCode_result); // 성별구분코드목록
model.addAttribute("entrprsMberSttus_result", entrprsMberSttus_result); // 사용자상태코드목록
model.addAttribute("groupId_result", groupId_result); // 그룹정보 목록
model.addAttribute("entrprsSeCode_result", entrprsSeCode_result); // 기업구분코드 목록
model.addAttribute("indutyCode_result", indutyCode_result); // 업종코드목록
return "egovframework/com/uss/umt/EgovEntrprsMberSelectUpdt";
}
/**
* 설문문항를 등록한다.
*
* @param searchVO
* @param commandMap
* @param qustnrQestnManageVO
* @param bindingResult
* @param model
* @return "egovframework/com/uss/olp/qqm/EgovQustnrQestnManageRegist"
* @throws Exception
*/
@RequestMapping(value = "/uss/olp/qqm/EgovQustnrQestnManageRegist.do")
public String qustnrQestnManageRegist(
@ModelAttribute("searchVO") ComDefaultVO searchVO,
Map commandMap,
@ModelAttribute("qustnrQestnManageVO") QustnrQestnManageVO qustnrQestnManageVO,
BindingResult bindingResult,
ModelMap model)
throws Exception {
// 0. Spring Security 사용자권한 처리
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if (!isAuthenticated) {
model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
return "egovframework/com/uat/uia/EgovLoginUsr";
}
// 로그인 객체 선언
LoginVO loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
String sLocationUrl = "egovframework/com/uss/olp/qqm/EgovQustnrQestnManageRegist";
String sCmd = commandMap.get("cmd") == null ? "" : (String) commandMap.get("cmd");
log.info("cmd =>" + sCmd);
// 공통코드 질문유형 조회
ComDefaultCodeVO voComCode = new ComDefaultCodeVO();
voComCode.setCodeId("COM018");
List listComCode = cmmUseService.selectCmmCodeDetail(voComCode);
model.addAttribute("cmmCode018", listComCode);
if (sCmd.equals("save")) {
// 서버 validate 체크
beanValidator.validate(qustnrQestnManageVO, bindingResult);
if (bindingResult.hasErrors()) {
// 설문제목가져오기
String sQestnrId =
commandMap.get("qestnrId") == null ? "" : (String) commandMap.get("qestnrId");
String sQestnrTmplatId =
commandMap.get("qestnrTmplatId") == null
? ""
: (String) commandMap.get("qestnrTmplatId");
log.info("sQestnrId =>" + sQestnrId);
log.info("sQestnrTmplatId =>" + sQestnrTmplatId);
if (!sQestnrId.equals("") && !sQestnrTmplatId.equals("")) {
Map mapQustnrManage = new HashMap();
mapQustnrManage.put("qestnrId", sQestnrId);
mapQustnrManage.put("qestnrTmplatId", sQestnrTmplatId);
model.addAttribute(
"qestnrInfo",
(Map) egovQustnrQestnManageService.selectQustnrManageQestnrSj(mapQustnrManage));
}
return "egovframework/com/uss/olp/qqm/EgovQustnrQestnManageRegist";
}
// 아이디 설정
qustnrQestnManageVO.setFrstRegisterId((String) loginVO.getUniqId());
qustnrQestnManageVO.setLastUpdusrId((String) loginVO.getUniqId());
/** 목록으로갈때 검색조건 유지 */
egovQustnrQestnManageService.insertQustnrQestnManage(qustnrQestnManageVO);
sLocationUrl = "redirect:/uss/olp/qqm/EgovQustnrQestnManageList.do?";
sLocationUrl = sLocationUrl + "searchMode=" + qustnrQestnManageVO.getSearchMode();
sLocationUrl = sLocationUrl + "&qestnrId=" + qustnrQestnManageVO.getQestnrId();
sLocationUrl = sLocationUrl + "&qestnrTmplatId=" + qustnrQestnManageVO.getQestnrTmplatId();
} else {
// 설문제목가져오기
String sQestnrId =
commandMap.get("qestnrId") == null ? "" : (String) commandMap.get("qestnrId");
String sQestnrTmplatId =
commandMap.get("qestnrTmplatId") == null ? "" : (String) commandMap.get("qestnrTmplatId");
log.info("sQestnrId =>" + sQestnrId);
log.info("sQestnrTmplatId =>" + sQestnrTmplatId);
if (!sQestnrId.equals("") && !sQestnrTmplatId.equals("")) {
Map mapQustnrManage = new HashMap();
mapQustnrManage.put("qestnrId", sQestnrId);
mapQustnrManage.put("qestnrTmplatId", sQestnrTmplatId);
model.addAttribute(
"qestnrInfo",
(Map) egovQustnrQestnManageService.selectQustnrManageQestnrSj(mapQustnrManage));
}
}
return sLocationUrl;
}
/**
* 기 등록된 휴가관리정보를 수정한다.
*
* @param vcatnManage - 휴가관리 model
* @return String - 리턴 Url
*/
@RequestMapping(value = "/uss/ion/vct/updtVcatnManage.do")
public String updtVcatnManage(
@ModelAttribute("vcatnManage") VcatnManage vcatnManage,
@ModelAttribute("vcatnManageVO") VcatnManageVO vcatnManageVO,
BindingResult bindingResult,
SessionStatus status,
ModelMap model)
throws Exception {
String sTemp = null;
String sTempMessage = null;
int iTemp = 0;
/*
beanValidator.validate(vcatnManage, bindingResult); //validation 수행
if (bindingResult.hasErrors()) {
model.addAttribute("vcatnManageVO", vcatnManageVO);
return "egovframework/com/uss/ion/vct/EgovVcatnUpdt";
} else {
vcatnManage.setBgnde(EgovStringUtil.removeMinusChar(vcatnManage.getBgnde()));
vcatnManage.setEndde(EgovStringUtil.removeMinusChar(vcatnManage.getEndde()));
sTempMessage = egovVcatnManageService.updtVcatnManage(vcatnManage, vcatnManageVO);
return "forward:/uss/ion/vct/EgovVcatnManageList.do";
}
*/
LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
vcatnManage.setFrstRegisterId(user.getUniqId());
sTemp = egovVcatnManageService.updtVcatnManage(vcatnManage, vcatnManageVO);
if (iTemp != 10) {
status.setComplete();
// sTemp = egovVcatnManageService.insertVcatnManage(vcatnManage, vcatnManageVO);
if (sTemp.equals("01")) {
sTempMessage = "입력성공";
model.addAttribute("message", sTempMessage);
return "forward:/uss/ion/vct/EgovVcatnManageList.do";
} else {
if (sTemp.equals("99")) sTempMessage = "휴가일자 지정 오류 - 휴가시작일자/종료일자를 확인하세요.";
if (sTemp.equals("09")) sTempMessage = "연차사용시 휴가는 당해연도만 가능합니다.";
if (sTemp.equals("02")) sTempMessage = "연차휴가 등록실패(잔여연차 부족)";
if (sTemp.equals("03")) sTempMessage = "반차휴가 등록실패(잔여연차 부족)";
model.addAttribute("errorMessage", sTempMessage);
VcatnManageVO vcatnManageVO1 =
egovVcatnManageService.selectIndvdlYrycManage(user.getUniqId());
vcatnManageVO1.setApplcntId(user.getUniqId());
vcatnManageVO1.setApplcntNm(user.getName());
vcatnManageVO1.setOrgnztNm(user.getOrgnztNm());
vcatnManageVO1.setTempBgnde(EgovDateUtil.formatDate(vcatnManage.getBgnde(), "-"));
vcatnManageVO1.setTempEndde(EgovDateUtil.formatDate(vcatnManage.getEndde(), "-"));
model.addAttribute("vcatnManageVO", vcatnManageVO1);
ComDefaultCodeVO vo = new ComDefaultCodeVO();
vo.setCodeId("COM056");
List<?> vcatnSeCodeList = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("vcatnSeCode", vcatnSeCodeList);
return "egovframework/com/uss/ion/vct/EgovVcatnUpdt";
}
} else {
sTempMessage = "휴가일자가 중복되었습니다. 휴가일자를 확인해 주세요.";
model.addAttribute("errorMessage", sTempMessage);
VcatnManageVO vcatnManageVO1 =
egovVcatnManageService.selectIndvdlYrycManage(user.getUniqId());
vcatnManageVO1.setApplcntId(user.getUniqId());
vcatnManageVO1.setApplcntNm(user.getName());
vcatnManageVO1.setOrgnztNm(user.getOrgnztNm());
model.addAttribute("vcatnManageVO", vcatnManageVO1);
ComDefaultCodeVO vo = new ComDefaultCodeVO();
vo.setCodeId("COM056");
List<?> vcatnSeCodeList = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("vcatnSeCode", vcatnSeCodeList);
return "egovframework/com/uss/ion/vct/EgovVcatnUpdt";
}
}
/**
* 휴가관리정보를 신규로 등록한다.
*
* @param vcatnManage - 휴가관리 model
* @return String - 리턴 Url
*/
@RequestMapping(value = "/uss/ion/vct/insertVcatnManage.do")
public String insertVcatnManage(
@ModelAttribute("vcatnManage") VcatnManage vcatnManage,
@ModelAttribute("vcatnManageVO") VcatnManageVO vcatnManageVO,
BindingResult bindingResult,
SessionStatus status,
@RequestParam Map<?, ?> commandMap,
ModelMap model)
throws Exception {
// 승인권자 소속명, 성명 유지
model.addAttribute(
"infSanctnDtNm",
commandMap.get("sanctnDtNm") == null ? "" : (String) commandMap.get("sanctnDtNm"));
model.addAttribute(
"infOrgnztNm",
commandMap.get("orgnztNm") == null ? "" : (String) commandMap.get("orgnztNm"));
String sEnddeView =
commandMap.get("enddeView") == null ? "" : (String) commandMap.get("enddeView"); // 종료일자 구분
if (!sEnddeView.equals("")) vcatnManage.setEndde(sEnddeView);
String sTemp = null;
String sTempMessage = null;
int iTemp = 0;
beanValidator.validate(vcatnManage, bindingResult); // validation 수행
if (bindingResult.hasErrors()) {
model.addAttribute("vcatnManageVO", vcatnManageVO);
return "egovframework/com/uss/ion/vct/EgovVcatnRegist";
} else {
LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
if (vcatnManage.getSanctnerId() != null) vcatnManage.setConfmAt("A");
vcatnManage.setApplcntId(user.getUniqId());
vcatnManage.setFrstRegisterId(user.getUniqId());
vcatnManageVO.setApplcntId(user.getUniqId());
vcatnManageVO.setSearchKeyword(EgovStringUtil.removeMinusChar(vcatnManage.getBgnde()));
// 시작일자 포함여부
iTemp = egovVcatnManageService.selectVcatnManageDplctAt(vcatnManageVO);
vcatnManageVO.setSearchKeyword(EgovStringUtil.removeMinusChar(vcatnManage.getEndde()));
// 종료일자 포함여부
iTemp += egovVcatnManageService.selectVcatnManageDplctAt(vcatnManageVO);
if (iTemp == 0) {
status.setComplete();
sTemp = egovVcatnManageService.insertVcatnManage(vcatnManage, vcatnManageVO);
if (sTemp.equals("01")) {
sTempMessage = "입력성공";
model.addAttribute("message", sTempMessage);
return "forward:/uss/ion/vct/EgovVcatnManageList.do";
} else {
if (sTemp.equals("99")) sTempMessage = "휴가일자 지정 오류 - 휴가시작일자/종료일자를 확인하세요.";
if (sTemp.equals("09")) sTempMessage = "연차사용시 휴가는 당해연도만 가능합니다.";
if (sTemp.equals("02")) sTempMessage = "연차휴가 등록실패(잔여연차 부족)";
if (sTemp.equals("03")) sTempMessage = "반차휴가 등록실패(잔여연차 부족)";
model.addAttribute("errorMessage", sTempMessage);
VcatnManageVO vcatnManageVO1 =
egovVcatnManageService.selectIndvdlYrycManage(user.getUniqId());
vcatnManageVO1.setApplcntId(user.getUniqId());
vcatnManageVO1.setApplcntNm(user.getName());
vcatnManageVO1.setOrgnztNm(user.getOrgnztNm());
vcatnManageVO1.setTempBgnde(EgovDateUtil.formatDate(vcatnManage.getBgnde(), "-"));
vcatnManageVO1.setTempEndde(EgovDateUtil.formatDate(vcatnManage.getEndde(), "-"));
model.addAttribute("vcatnManageVO", vcatnManageVO1);
ComDefaultCodeVO vo = new ComDefaultCodeVO();
vo.setCodeId("COM056");
List<?> vcatnSeCodeList = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("vcatnSeCode", vcatnSeCodeList);
return "egovframework/com/uss/ion/vct/EgovVcatnRegist";
}
} else {
sTempMessage = "휴가일자가 중복되었습니다. 휴가일자를 확인해 주세요.";
model.addAttribute("errorMessage", sTempMessage);
VcatnManageVO vcatnManageVO1 =
egovVcatnManageService.selectIndvdlYrycManage(user.getUniqId());
vcatnManageVO1.setApplcntId(user.getUniqId());
vcatnManageVO1.setApplcntNm(user.getName());
vcatnManageVO1.setOrgnztNm(user.getOrgnztNm());
model.addAttribute("vcatnManageVO", vcatnManageVO1);
ComDefaultCodeVO vo = new ComDefaultCodeVO();
vo.setCodeId("COM056");
List<?> vcatnSeCodeList = cmmUseService.selectCmmCodeDetail(vo);
model.addAttribute("vcatnSeCode", vcatnSeCodeList);
return "egovframework/com/uss/ion/vct/EgovVcatnRegist";
}
}
}