Code - chominsoo4245/mjon

package itn.let.org.web; import java.io.OutputStreamWriter; import java.io.PrintWriter; import java.util.ArrayList; import java.util.Arrays; import java.util.List; import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; import org.springframework.stereotype.Controller; import org.springframework.transaction.annotation.Transactional; import org.springframework.ui.ModelMap; import org.springframework.web.bind.annotation.ModelAttribute; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.servlet.ModelAndView; import com.fasterxml.jackson.databind.ObjectMapper; import egovframework.rte.fdl.idgnr.EgovIdGnrService; import egovframework.rte.fdl.security.userdetails.util.EgovUserDetailsHelper; import itn.com.cmm.LoginVO; import itn.let.org.service.LocVO; import itn.let.org.service.OrgCharVO; import itn.let.org.service.OrgChartManageService; import itn.let.sec.ram.service.AuthorManageVO; import itn.let.sec.ram.service.EgovAuthorManageService; import itn.let.sec.rgm.service.EgovAuthorGroupService; import itn.let.sym.ccm.cde.service.CmmnDetailCodeVO; import itn.let.sym.mnu.mpm.service.MenuManageJTreeVO; import itn.let.uss.umt.service.EgovUserManageService; import itn.let.uss.umt.service.UserManageVO; @Controller public class OrgChartManageController { /** userManageService */ @Resource(name = "userManageService") private EgovUserManageService userManageService; @Resource(name = "orgChartManageService") private OrgChartManageService orgChartManageService; @Resource(name = "egovLocInfoIdGnrService") private EgovIdGnrService idgenLocInfoId; @Resource(name = "egovAuthorManageService") private EgovAuthorManageService egovAuthorManageService; @Resource(name = "egovAuthorGroupService") private EgovAuthorGroupService egovAuthorGroupService; private String topLocNo = "1000000" ; //전역 최상위 매뉴번호 // 조직도 화면 @RequestMapping("/uss/orgChart/OrgChartManage.do") public String selectOrgChartInfo(LocVO locVO, ModelMap model, HttpServletResponse response) throws Exception { //권한조회 AuthorManageVO authorManageVO = new AuthorManageVO(); authorManageVO.setFirstIndex(0); authorManageVO.setLastIndex(10); authorManageVO.setRecordCountPerPage(10); authorManageVO.setAuthorManageList(egovAuthorManageService.selectAuthorList(authorManageVO)); model.addAttribute("authorList", authorManageVO.getAuthorManageList()); //selectbox 미리 만들기 locVO.setTopLocNo(topLocNo); //최상위 매뉴번호 List<LocVO> orgHiddenList = orgChartManageService.selectOrgChartListAjax(locVO); model.addAttribute("orgHiddenList", orgHiddenList); return "/uss/orgchart/OrgChartManage"; } /*부서 최초 트리 리스트 */ @RequestMapping(value="/uss/orgChart/orgChartInitAjax.do") public void orgChartInitAjax( @ModelAttribute("menuManageVO") MenuManageJTreeVO menuManageVO , LocVO locVO , ModelMap model, HttpServletResponse response) throws Exception { ObjectMapper mapper = new ObjectMapper(); response.setContentType("application/json"); PrintWriter out = new PrintWriter(new OutputStreamWriter(response.getOutputStream(), "UTF-8")); locVO.setTopLocNo(topLocNo); //최상위 매뉴번호 List<LocVO> resultList = orgChartManageService.selectOrgChartListAjax(locVO); LocVO rootNode = new LocVO(); rootNode.setParent("#"); rootNode.setId(topLocNo); rootNode.setText("전체"); resultList.add(0, rootNode); mapper.writeValue(out, resultList); out.flush(); } @RequestMapping(value= {"/uss/orgChart/getOrgChartInitAjax_01.do" , "/uss/orgChart/getOrgChartInit01Ajax.do"}) public ModelAndView getOrgChartInitAjax_01( @ModelAttribute("menuManageVO") MenuManageJTreeVO menuManageVO , @ModelAttribute("searchVO") CmmnDetailCodeVO searchVO , ModelMap model, HttpServletResponse response) throws Exception{ ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); OrgCharVO orgCharVO = new OrgCharVO(); orgCharVO.setLocDepth(2); List<OrgCharVO> resultList = orgChartManageService.selectOrgChartDepthListAjax(orgCharVO); modelAndView.addObject("resultList", resultList); return modelAndView; } /*검색 select 02 리스트 */ @RequestMapping(value= {"/uss/orgChart/getOrgChartInitAjax_02.do" , "/uss/orgChart/getOrgChartInit02Ajax.do"}) public ModelAndView getOrgChartInitAjax_02(@ModelAttribute("menuManageVO") MenuManageJTreeVO menuManageVO, @ModelAttribute("searchVO") CmmnDetailCodeVO searchVO, ModelMap model, HttpServletResponse response) throws Exception{ ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); OrgCharVO orgCharVO = new OrgCharVO(); orgCharVO.setLocDepth(3); //뎁스3인것만 if(!searchVO.getSearchCondition_01().equals("")) { orgCharVO.setUpperLocNo(Integer.parseInt(searchVO.getSearchCondition_01())); } List<OrgCharVO> resultList = orgChartManageService.selectOrgChartDepthListAjax(orgCharVO); modelAndView.addObject("resultList", resultList); return modelAndView; } /*검색 select 03 리스트 */ @RequestMapping(value= {"/uss/orgChart/getOrgChartInitAjax_03.do" , "/uss/orgChart/getOrgChartInit03Ajax.do"}) public ModelAndView getOrgChartInitAjax_03(@ModelAttribute("menuManageVO") MenuManageJTreeVO menuManageVO, @ModelAttribute("searchVO") CmmnDetailCodeVO searchVO, ModelMap model, HttpServletResponse response) throws Exception{ ModelAndView modelAndView = new ModelAndView(); //부서별만 조회 가능 modelAndView.setViewName("jsonView"); OrgCharVO orgCharVO = new OrgCharVO(); orgCharVO.setLocDepth(4); //뎁스3인것만 if(!searchVO.getSearchCondition_02().equals("")) { orgCharVO.setUpperLocNo(Integer.parseInt(searchVO.getSearchCondition_02())); } List<OrgCharVO> resultList = orgChartManageService.selectOrgChartDepthListAjax(orgCharVO); modelAndView.addObject("resultList", resultList); return modelAndView; } // 부서별 직원 정보 보기 @RequestMapping("/cop/selectUserListAjax.do") public ModelAndView selectStaffListAjax( @ModelAttribute("userManageVO") UserManageVO userManageVO , @ModelAttribute("orgCharVO") OrgCharVO orgCharVO, ModelMap model) throws Exception { ModelAndView modelAndView = new ModelAndView(); if ((userManageVO.getPartIdx() != null) && (userManageVO.getPartIdx().equals("DEPT"))) { LoginVO loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser(); userManageVO.setPartIdx(loginVO.getOrgnztNo()); } modelAndView.setViewName("jsonView"); List<UserManageVO> userList = orgChartManageService.selectUserListAjax(userManageVO); model.addAttribute("userList", userList); LocVO locVO = new LocVO(); locVO.setLocNo(userManageVO.getPartIdx()); locVO = orgChartManageService.selectLocCnVO(locVO); modelAndView.addObject("locVO", locVO); modelAndView.addObject("status", "success"); return modelAndView; } // 직원 정보 조회하기 @RequestMapping("/cop/selectUserInfoAjax.do") public ModelAndView selectUserInfoAjax( @ModelAttribute("userManageVO") UserManageVO userManageVO , ModelMap model) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); try{ UserManageVO userInfo = orgChartManageService.selectUserInfoAjax(userManageVO); //UserManageVO userInfo = orgChartManageService.selectUserLocInfoAjax(userManageVO); modelAndView.addObject("userInfo", userInfo); modelAndView.addObject("result", "success"); }catch(Exception e){ modelAndView.addObject("result", "fail"); } return modelAndView; } // 부서별 직원 수정하기 @RequestMapping("/uss/orgChart/updateUserInfoAjax.do") public ModelAndView updateUserInfoAjax( @ModelAttribute("userManageVO") UserManageVO userManageVO , ModelMap model) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); try{ //업무사용자 수정시 히스토리 정보를 등록한다. //userManageService.insertUserHistory(userManageVO); //userManageService.updateUser(userManageVO); if(null== userManageVO.getLocInfoId() || "".equals(userManageVO.getLocInfoId())){ String locInfoId = idgenLocInfoId.getNextStringId(); userManageVO.setLocInfoId(locInfoId); userManageVO.setUserNm(userManageVO.getEmplyrNm()); userManageService.insertLocInfo(userManageVO); modelAndView.addObject("I", "flag"); }else { userManageService.updateLocInfo(userManageVO); modelAndView.addObject("U", "flag"); } modelAndView.addObject("result", "success"); }catch(Exception e){ modelAndView.addObject("result", "fail"); } return modelAndView; } //부서별 직원 등록하기 @RequestMapping("/cop/insertUserInfoAjax.do") public ModelAndView insertUserInfoAjax( @ModelAttribute("userManageVO") UserManageVO userManageVO , ModelMap model) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); try{ userManageService.insertUser(userManageVO); modelAndView.addObject("result", "success"); }catch(Exception e){ modelAndView.addObject("result", "fail"); } return modelAndView; } // 부서별 직원 삭제하기 @RequestMapping("/cop/deleteUserInfoAjax.do") public ModelAndView deleteStaffInfoAjax( @ModelAttribute("userManageVO") UserManageVO userManageVO , @RequestParam("del") String[] del, ModelMap model) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); for(String id:del) { try{ orgChartManageService.deleteUserInfoAjax(id); modelAndView.addObject("result", "success"); }catch(Exception e){ modelAndView.addObject("result", "fail"); } } return modelAndView; } // 조직도 화면 @RequestMapping("/uss/orgChart/OrgChartPopup.do") public String orgChartPopup(@ModelAttribute("locVO") LocVO locVO, ModelMap model, HttpServletResponse response) throws Exception { return "/uss/orgChart/OrgChartPopup"; } /** * 조직도 정보를 등록 * * @param partInfVO * @param model * @return * @throws Exception */ @SuppressWarnings({ "rawtypes", "unchecked" }) @RequestMapping("/uss/orgChart/orgChartInsertAjax.do") public ModelAndView orgChartInsertAjax(@ModelAttribute("menuManageVO") MenuManageJTreeVO menuManageVO, @ModelAttribute("cmmnDetailCodeVO") CmmnDetailCodeVO cmmnDetailCodeVO, ModelMap model, LocVO locVO , @RequestParam("nodeIds") String[] nodeIds) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); try { String compareStr = ""; for(int i=1 ; i < 100 ; i++) { if(i<10) { compareStr = "0"+i; } if(!Arrays.asList(nodeIds).contains(compareStr)) { break; } } locVO.setLocNm("NEW DATA"); //임시 locVO.setLocNo("9999999"); //임시 String equiLevel = (locVO.getUpperMenuId()+"").replaceFirst("0" , "%"); //List<LocVO> equiLocList = assetManageService.selectEquiLevelLocList(equiLevel); List<LocVO> equiLocList = orgChartManageService.selectEquiLevelLocList(equiLevel); ArrayList existLocNo = new ArrayList() ; for(LocVO tempLocVO : equiLocList) { existLocNo.add(tempLocVO.getLocNo()) ; } int insertMenNo ; if(equiLocList.size() != 0){ for(int i = 1 ; i < 100 ; i++){ //0~100까지 임의의 매뉴번호 생성후 이전 매뉴가 없는것을 조회 insertMenNo = Integer.parseInt((locVO.getUpperMenuId()+"").replaceFirst("0" , i+"")) ; if(!existLocNo.contains(insertMenNo+"")){ //매뉴번호가 없으면 locVO.setLocNo(insertMenNo+""); break ; } } }else{ insertMenNo = Integer.parseInt((locVO.getUpperMenuId()+"").replaceFirst("0" , "1")); locVO.setLocNo(insertMenNo+""); } locVO.setUpperLocNo(locVO.getUpperMenuId()+""); locVO.setUseYn("Y"); locVO.setFrstRegisterId(user.getId()); locVO.setLocOrdr(nodeIds.length+1); locVO.setLocDepth(Integer.parseInt(locVO.getNodeDepth())); orgChartManageService.insertOrgChart(locVO); modelAndView.addObject("newMenuNo", locVO.getLocNo()); modelAndView.addObject("status", "success"); }catch (Exception e) { modelAndView.addObject("status", "fail"); model.addAttribute("menuManageVO", cmmnDetailCodeVO); } return modelAndView; } /** * 조직도 정보 이름 변경 * * @param partInfVO * @param model * @return * @throws Exception */ @RequestMapping("/uss/orgChart/orgChartNmUpdateAjax.do") public ModelAndView updateassetSubNmUpdateAjax( @ModelAttribute("menuManageVO") MenuManageJTreeVO menuManageVO, @ModelAttribute("searchVO") CmmnDetailCodeVO searchVO, ModelMap model) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); try{ LocVO locVO = new LocVO(); locVO.setLocNm(menuManageVO.getMenuNm()); locVO.setLocNo(menuManageVO.getMenuNo()); //assetManageService.updateAssetLocNm(locVO); orgChartManageService.updateOrgChartNm(locVO); modelAndView.addObject("status", "success"); }catch (Exception e) { modelAndView.addObject("status", "fail"); } return modelAndView; } /** * 부서 정보를 삭제한다.(트리구조에서) * * @param partInfVO * @param model * @return * @throws Exception */ @Transactional(rollbackFor = Exception.class) @RequestMapping(value = "/uss/orgChart/orgChartDeleteAjax.do") public ModelAndView orgChartDeleteAjax(@ModelAttribute("menuManageVO") MenuManageJTreeVO menuManageVO, @ModelAttribute("cmmnDetailCodeVO") CmmnDetailCodeVO cmmnDetailCodeVO, LocVO locVO , ModelMap model) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); try { locVO.setLocNo(menuManageVO.getMenuNo()); orgChartManageService.deleteOrgChart(locVO); modelAndView.addObject("status", "success"); }catch(Exception e) { modelAndView.addObject("status", "fail"); } return modelAndView; } /** * 부서 이동 한다.(트리구조에서) */ @Transactional(rollbackFor = Exception.class) @RequestMapping("/uss/itsm/asset/AssetMoveAjax.do") public ModelAndView asetMoveAjax( @ModelAttribute("menuManageVO") MenuManageJTreeVO menuManageVO, @ModelAttribute("cmmnDetailCodeVO") CmmnDetailCodeVO cmmnDetailCodeVO, LocVO locVO , ModelMap model) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); try{ locVO.setLocNo(menuManageVO.getMenuNo()); locVO.setUpperLocNo(menuManageVO.getUpperMenuId()); locVO.setLocOrdr(locVO.getSort()); orgChartManageService.updateLocDate(locVO); orgChartManageService.resortLoc(locVO); modelAndView.addObject("status", "success"); }catch (Exception e) { modelAndView.addObject("status", "fail"); } return modelAndView; } // 조직도 화면 (사용자) @RequestMapping("/web/cop/org/selectOrgList.do") public String selectOrgList(LocVO locVO, ModelMap model, HttpServletResponse response) throws Exception { //selectbox 미리 만들기 locVO.setTopLocNo(topLocNo); //최상위 매뉴번호 List<LocVO> orgList = orgChartManageService.selectOrgChartListAjax(locVO); List<LocVO> headOrgList = new ArrayList<>(); { headOrgList.add(orgList.get(0)) ; headOrgList.add(orgList.get(1)) ; headOrgList.add(orgList.get(2)) ; } model.addAttribute("headOrgList", headOrgList); { orgList.remove(0); orgList.remove(0); orgList.remove(0); } model.addAttribute("orgSubList", orgList); return "/web/cop/org/selectOrgList"; } // 조직도 상세 (사용자) @RequestMapping("/web/cop/org/selectOrgDetail.do") public String selectOrgDetail(LocVO locVO, ModelMap model, UserManageVO userManageVO, HttpServletResponse response) throws Exception { List<UserManageVO> userList = orgChartManageService.selectUserListAjax(userManageVO); locVO.setLocNo(userManageVO.getPartIdx()); LocVO resultLocVO = orgChartManageService.selectLocCnVO(locVO); model.addAttribute("userList", userList); model.addAttribute("locVO", resultLocVO); List<LocVO> locPathList = orgChartManageService.selectLocPath(locVO); model.addAttribute("locPathList", locPathList); /*OrgCharVO orgCharVO = new OrgCharVO(); orgCharVO.setLocDepth(2); List<OrgCharVO> resultList = orgChartManageService.selectOrgChartDepthListAjax(orgCharVO);*/ return "/web/cop/org/selectOrgDetail"; } // 부서 업무 저장하기 @RequestMapping("/uss/orgChart/updateLocCnSaveAjax.do") public ModelAndView updateLocCnSaveAjax( @ModelAttribute("userManageVO") UserManageVO userManageVO, LocVO locVO , ModelMap model) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); try{ //업무사용자 수정시 히스토리 정보를 등록한다. /*userManageService.insertUserHistory(userManageVO); userManageService.updateUser(userManageVO);*/ //orgChartManageService.selectOrgChartListAjax(locVO); orgChartManageService.updateLocCnSaveAjax(locVO); modelAndView.addObject("result", "success"); }catch(Exception e){ modelAndView.addObject("result", "fail"); } return modelAndView; } // 직원 삭제하기 @RequestMapping("/cop/deleteUserInfoLocAjax.do") public ModelAndView deleteUserInfoLocAjax( @ModelAttribute("userManageVO") UserManageVO userManageVO, ModelMap model) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); try{ orgChartManageService.deleteUserInfoLocAjax(userManageVO.getEmplyrId()); modelAndView.addObject("result", "success"); }catch(Exception e){ modelAndView.addObject("result", "fail"); } return modelAndView; } }