// 페이징 객체를 설정한다. public void executePagenation(HttpServletRequest request, ModelMap modelMap, Object command) throws Exception { // 페이징 관련 해서 뷰페이지에서 현재 페이지와 페이지 싸이즈 그리고 토탈 카운트 정보만 있으면 페이지징을 처리할수있다. // totalCount 구한다. int totalCount = this.listTotalCount(request, modelMap, command); int pageIndex = Integer.parseInt(BeanUtils.getProperty(command, "pageIndex").toString()); int pageSize = Integer.parseInt(BeanUtils.getProperty(command, "pageSize").toString()); int recordCountPerPage = Integer.parseInt(BeanUtils.getProperty(command, "recordCountPerPage").toString()); // egov pagination 객체 생성 PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(pageIndex); paginationInfo.setRecordCountPerPage(recordCountPerPage); paginationInfo.setPageSize(pageSize); paginationInfo.setTotalRecordCount(totalCount); int lastPageNo = paginationInfo.getLastPageNo(); if (pageIndex > lastPageNo) { paginationInfo.setCurrentPageNo(lastPageNo); } // 검색 리스트 쿼리에서 사용할 페이징 정보를 구한다. BeanUtils.setProperty(command, "firstIndex", paginationInfo.getFirstRecordIndex()); BeanUtils.setProperty(command, "lastIndex", paginationInfo.getLastRecordIndex()); // comDefaultVo 에 pageSize 와 recordCountPerPage 같은 정보인것 같은데 왜 있는지 모르겠다 recordCountPerPage는 // 주석처리한다. // BeanUtils.setProperty(command,"recordCountPerPage",paginationInfo.getRecordCountPerPage()); modelMap.addAttribute("paginationInfo", paginationInfo); }
/** * Q&A답변정보 목록을 조회한다. (pageing) * * @param searchVO * @param model * @return "/uss/olh/qna/EgovQnaAnswerListInqire" * @throws Exception */ @RequestMapping(value = "/uss/olh/qnm/QnaAnswerListInqire.do") public String selectQnaAnswerList( @ModelAttribute("searchVO") QnaManageDefaultVO searchVO, ModelMap model) throws Exception { /** EgovPropertyService.SiteList */ searchVO.setPageUnit(propertiesService.getInt("pageUnit")); searchVO.setPageSize(propertiesService.getInt("pageSize")); /** pageing */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(searchVO.getPageIndex()); paginationInfo.setRecordCountPerPage(searchVO.getPageUnit()); paginationInfo.setPageSize(searchVO.getPageSize()); searchVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); searchVO.setLastIndex(paginationInfo.getLastRecordIndex()); searchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); model.addAttribute("resultList", qnaManageService.selectQnaAnswerList(searchVO)); int totCnt = qnaManageService.selectQnaAnswerListTotCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return "/uss/olh/qna/EgovQnaAnswerListInqire"; }
/** * 등록된 지식맵(지식유형) 정보를 조회 한다. * * @param mapMaterialVO- 지식맵(지식유형) VO * @return String - 리턴 Url * @param MapMaterialVO */ @IncludedInfo( name = "지식맵관리(유형)", listUrl = "/dam/map/mat/EgovComDamMapMaterialList.do", order = 1260, gid = 80) @RequestMapping(value = "/dam/map/mat/EgovComDamMapMaterialList.do") public String selectMapMaterialList( @ModelAttribute("loginVO") LoginVO loginVO, @ModelAttribute("searchVO") MapMaterialVO searchVO, ModelMap model) throws Exception { /** EgovPropertyService.mapMaterial */ searchVO.setPageUnit(propertiesService.getInt("pageUnit")); searchVO.setPageSize(propertiesService.getInt("pageSize")); /** paging */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(searchVO.getPageIndex()); paginationInfo.setRecordCountPerPage(searchVO.getPageUnit()); paginationInfo.setPageSize(searchVO.getPageSize()); searchVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); searchVO.setLastIndex(paginationInfo.getLastRecordIndex()); searchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); List MapMaterialList = mapMaterialService.selectMapMaterialList(searchVO); model.addAttribute("resultList", MapMaterialList); int totCnt = mapMaterialService.selectMapMaterialTotCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return "egovframework/com/dam/map/mat/EgovComDamMapMaterialList"; }
/** * 부서업무함 정보에 대한 목록을 조회한다. * * @param DeptJobBxVO * @return String * @param deptJobBxVO */ @IncludedInfo(name = "부서업무함관리", order = 400, gid = 40) @RequestMapping("/cop/smt/djm/selectDeptJobBxList.do") public String selectDeptJobBxList( @ModelAttribute("searchVO") DeptJobBxVO deptJobBxVO, ModelMap model) throws Exception { // LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); String sLocationUrl = "egovframework/com/cop/smt/djm/EgovDeptJobBxList"; if (deptJobBxVO.getPopupCnd() != null && !deptJobBxVO.getPopupCnd().equals("")) sLocationUrl = "egovframework/com/cop/smt/djm/EgovDeptJobBxListS"; deptJobBxVO.setPageUnit(propertyService.getInt("pageUnit")); deptJobBxVO.setPageSize(propertyService.getInt("pageSize")); PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(deptJobBxVO.getPageIndex()); paginationInfo.setRecordCountPerPage(deptJobBxVO.getPageUnit()); paginationInfo.setPageSize(deptJobBxVO.getPageSize()); deptJobBxVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); deptJobBxVO.setLastIndex(paginationInfo.getLastRecordIndex()); deptJobBxVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); Map<String, Object> map = deptJobService.selectDeptJobBxList(deptJobBxVO); int totCnt = Integer.parseInt((String) map.get("resultCnt")); paginationInfo.setTotalRecordCount(totCnt); List<DeptJobBxVO> list = (List<DeptJobBxVO>) map.get("resultList"); model.addAttribute("resultList", map.get("resultList")); model.addAttribute("resultCnt", map.get("resultCnt")); model.addAttribute("resultNum", list.size()); model.addAttribute("paginationInfo", paginationInfo); return sLocationUrl; }
/** * 커뮤니티, 동호회에 사용되는 게시판 사용정보에 대한 목록을 조회한다. * * @param bdUseVO * @param model * @return * @throws Exception */ @RequestMapping("/cop/com/selectCmyBBSUseInfsByTrget.do") public String selectBBSUseInfsByTrget( @ModelAttribute("searchVO") BoardUseInfVO bdUseVO, ModelMap model) throws Exception { checkAuthority(bdUseVO); // server-side 권한 확인 bdUseVO.setPageUnit(propertyService.getInt("pageUnit")); bdUseVO.setPageSize(propertyService.getInt("pageSize")); PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(bdUseVO.getPageIndex()); paginationInfo.setRecordCountPerPage(bdUseVO.getPageUnit()); paginationInfo.setPageSize(bdUseVO.getPageSize()); bdUseVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); bdUseVO.setLastIndex(paginationInfo.getLastRecordIndex()); bdUseVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); Map<String, Object> map = bbsUseService.selectBBSUseInfsByTrget(bdUseVO); int totCnt = Integer.parseInt((String) map.get("resultCnt")); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("resultList", map.get("resultList")); model.addAttribute("resultCnt", map.get("resultCnt")); model.addAttribute("trgetId", bdUseVO.getTrgetId()); model.addAttribute("trgetType", bdUseVO.getTrgetType()); model.addAttribute("paginationInfo", paginationInfo); return "egovframework/com/cop/com/EgovBdUseInfListByTrget"; }
/** * 게시판 마스터 선택 팝업을 위한 목록을 조회한다. * * @param boardMasterVO * @param model * @return * @throws Exception */ @RequestMapping("/cop/bbs/SelectBBSMasterInfsPop.do") public String selectBBSMasterInfsPop( @ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model) throws Exception { boardMasterVO.setPageUnit(propertyService.getInt("pageUnit")); boardMasterVO.setPageSize(propertyService.getInt("pageSize")); PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(boardMasterVO.getPageIndex()); paginationInfo.setRecordCountPerPage(boardMasterVO.getPageUnit()); paginationInfo.setPageSize(boardMasterVO.getPageSize()); boardMasterVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); boardMasterVO.setLastIndex(paginationInfo.getLastRecordIndex()); boardMasterVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); boardMasterVO.setUseAt("Y"); Map<String, Object> map = bbsAttrbService.selectNotUsedBdMstrList(boardMasterVO); int totCnt = Integer.parseInt((String) map.get("resultCnt")); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("resultList", map.get("resultList")); model.addAttribute("resultCnt", map.get("resultCnt")); model.addAttribute("paginationInfo", paginationInfo); return "cop/bbs/EgovBoardMstrListPop"; }
/** * 등록된 PROCESS모니터링 정보를 조회 한다. * * @param processMonVO- PROCESS모니터링 VO * @return String - 리턴 Url * @param processMonVO */ @IncludedInfo(name = "프로세스모니터링", order = 2110, gid = 90) @RequestMapping("/utl/sys/prm/EgovComUtlProcessMonList.do") public String selectProcessMonList( @ModelAttribute("searchVO") ProcessMonVO processMonVO, ModelMap model) throws Exception { // 로그인 객체 선언 LoginVO loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser(); processMonVO.setPageUnit(propertyService.getInt("pageUnit")); processMonVO.setPageSize(propertyService.getInt("pageSize")); PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(processMonVO.getPageIndex()); paginationInfo.setRecordCountPerPage(processMonVO.getPageUnit()); paginationInfo.setPageSize(processMonVO.getPageSize()); processMonVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); processMonVO.setLastIndex(paginationInfo.getLastRecordIndex()); processMonVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); List ProcessMonList = processMonService.selectProcessMonList(processMonVO); model.addAttribute("resultList", ProcessMonList); int totCnt = processMonService.selectProcessMonTotCnt(processMonVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return "egovframework/com/utl/sys/prm/EgovComUtlProcessMonList"; }
/** * 공통분류코드 목록을 조회한다. * * @param loginVO * @param searchVO * @param model * @return "egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeList" * @throws Exception */ @IncludedInfo( name = "공통분류코드", listUrl = "/sym/ccm/ccc/EgovCcmCmmnClCodeList.do", order = 960, gid = 60) @RequestMapping(value = "/sym/ccm/ccc/EgovCcmCmmnClCodeList.do") public String selectCmmnClCodeList( @ModelAttribute("loginVO") LoginVO loginVO, @ModelAttribute("searchVO") CmmnClCodeVO searchVO, ModelMap model) throws Exception { /** EgovPropertyService.sample */ searchVO.setPageUnit(propertiesService.getInt("pageUnit")); searchVO.setPageSize(propertiesService.getInt("pageSize")); /** pageing */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(searchVO.getPageIndex()); paginationInfo.setRecordCountPerPage(searchVO.getPageUnit()); paginationInfo.setPageSize(searchVO.getPageSize()); searchVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); searchVO.setLastIndex(paginationInfo.getLastRecordIndex()); searchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); List<?> CmmnCodeList = cmmnClCodeManageService.selectCmmnClCodeList(searchVO); model.addAttribute("resultList", CmmnCodeList); int totCnt = cmmnClCodeManageService.selectCmmnClCodeListTotCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return "egovframework/com/sym/ccm/ccc/EgovCcmCmmnClCodeList"; }
/** * 부서 정보에 대한 목록을 조회한다. * * @param DeptVO * @return String * @param deptVO */ @RequestMapping("/cop/smt/djm/selectDeptList.do") public String selectDeptList(@ModelAttribute("searchVO") DeptVO deptVO, ModelMap model) throws Exception { // LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); deptVO.setPageUnit(propertyService.getInt("pageUnit")); deptVO.setPageSize(propertyService.getInt("pageSize")); PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(deptVO.getPageIndex()); paginationInfo.setRecordCountPerPage(deptVO.getPageUnit()); paginationInfo.setPageSize(deptVO.getPageSize()); deptVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); deptVO.setLastIndex(paginationInfo.getLastRecordIndex()); deptVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); Map<String, Object> map = deptJobService.selectDeptList(deptVO); int totCnt = Integer.parseInt((String) map.get("resultCnt")); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("resultList", map.get("resultList")); model.addAttribute("resultCnt", map.get("resultCnt")); model.addAttribute("paginationInfo", paginationInfo); return "egovframework/com/cop/smt/djm/EgovDeptList"; }
/** * 처리 내용 : 차주정보 리스트를 화면에 출력 처리 날짜 : 2015.01.08 * * @param searchVO * @param model * @param request * @param response * @return * @throws Exception */ @RequestMapping("/hist.do") public String carOwnHistForm( @ModelAttribute("pageVO") BasePageVO pageVO, ModelMap model, HttpServletRequest request, HttpServletResponse response) throws Exception { BaseSessInfo info = SessionUtility.getLoginForAdmin(request); if (info == null) { return "redirect:/cms/login.do"; } pageVO.setPageUnit(propertiesService.getInt("pageUnit")); pageVO.setPageSize(propertiesService.getInt("pageSize")); PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(pageVO.getPageIndex()); paginationInfo.setRecordCountPerPage(pageVO.getPageUnit()); paginationInfo.setPageSize(pageVO.getPageSize()); pageVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); pageVO.setLastIndex(paginationInfo.getLastRecordIndex()); pageVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); List<?> lstData = carOwnerService.selectHistData(pageVO); model.addAttribute("resultList", lstData); model.addAttribute("searchData", pageVO); int totCnt = carOwnerService.selectHistCount(pageVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return "cms/carown/hist"; }
/** * 승인(탈퇴)요청에 대한 목록을 조회한다. * * @param historyvO * @param sessionVO * @param status * @param model * @return * @throws Exception */ @RequestMapping("/cop/com/selectConfirmRequest.do") public String selectConfirmRequest( @ModelAttribute("searchVO") ConfirmHistoryVO historyVO, SessionStatus status, ModelMap model) throws Exception { LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser(); @SuppressWarnings("unused") Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated(); historyVO.setPageUnit(propertyService.getInt("pageUnit")); historyVO.setPageSize(propertyService.getInt("pageSize")); PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(historyVO.getPageIndex()); paginationInfo.setRecordCountPerPage(historyVO.getPageUnit()); paginationInfo.setPageSize(historyVO.getPageSize()); historyVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); historyVO.setLastIndex(paginationInfo.getLastRecordIndex()); historyVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); historyVO.setConfmerId(user.getUniqId()); Map<String, Object> map = confmService.selectConfirmRequest(historyVO); int totCnt = Integer.parseInt((String) map.get("resultCnt")); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("resultList", map.get("resultList")); model.addAttribute("resultCnt", map.get("resultCnt")); model.addAttribute("paginationInfo", paginationInfo); return "egovframework/com/cop/com/EgovConfirmList"; }
/** * 로그인정책 목록을 조회한다. * * @param loginPolicyVO - 로그인정책 VO * @return String - 리턴 Url */ @IncludedInfo(name = "로그인정책관리", order = 30, gid = 10) @RequestMapping("/uat/uap/selectLoginPolicyList.do") public String selectLoginPolicyList( @ModelAttribute("loginPolicyVO") LoginPolicyVO loginPolicyVO, ModelMap model) throws Exception { /** paging */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(loginPolicyVO.getPageIndex()); paginationInfo.setRecordCountPerPage(loginPolicyVO.getPageUnit()); paginationInfo.setPageSize(loginPolicyVO.getPageSize()); loginPolicyVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); loginPolicyVO.setLastIndex(paginationInfo.getLastRecordIndex()); loginPolicyVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); loginPolicyVO.setLoginPolicyList(egovLoginPolicyService.selectLoginPolicyList(loginPolicyVO)); model.addAttribute("loginPolicyList", loginPolicyVO.getLoginPolicyList()); int totCnt = egovLoginPolicyService.selectLoginPolicyListTotCnt(loginPolicyVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); model.addAttribute("message", egovMessageSource.getMessage("success.common.select")); return "egovframework/com/uat/uap/EgovLoginPolicyList"; }
/** * 권한별 할당된 롤 목록 조회 * * @param authorRoleManageVO AuthorRoleManageVO * @return String * @exception Exception */ @RequestMapping(value = "/sec/ram/EgovAuthorRoleList.do") public String selectAuthorRoleList( @ModelAttribute("authorRoleManageVO") AuthorRoleManageVO authorRoleManageVO, ModelMap model) throws Exception { /** paging */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(authorRoleManageVO.getPageIndex()); paginationInfo.setRecordCountPerPage(authorRoleManageVO.getPageUnit()); paginationInfo.setPageSize(authorRoleManageVO.getPageSize()); authorRoleManageVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); authorRoleManageVO.setLastIndex(paginationInfo.getLastRecordIndex()); authorRoleManageVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); authorRoleManageVO.setAuthorRoleList( egovAuthorRoleManageService.selectAuthorRoleList(authorRoleManageVO)); model.addAttribute("authorRoleList", authorRoleManageVO.getAuthorRoleList()); int totCnt = egovAuthorRoleManageService.selectAuthorRoleListTotCnt(authorRoleManageVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); model.addAttribute("message", egovMessageSource.getMessage("success.common.select")); return "egovframework/com/sec/ram/EgovAuthorRoleManage"; }
/** * 글 목록을 조회한다. (pageing) * * @param searchVO - 조회할 정보가 담긴 SampleDefaultVO * @param model * @return "/sample/egovSampleList" * @exception Exception */ @RequestMapping(value = "/sample/egovSampleList.do") public String selectSampleList( @ModelAttribute("searchVO") SampleDefaultVO searchVO, ModelMap model) throws Exception { /** EgovPropertyService.sample */ searchVO.setPageUnit(propertiesService.getInt("pageUnit")); searchVO.setPageSize(propertiesService.getInt("pageSize")); /** pageing setting */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(searchVO.getPageIndex()); paginationInfo.setRecordCountPerPage(searchVO.getPageUnit()); paginationInfo.setPageSize(searchVO.getPageSize()); searchVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); searchVO.setLastIndex(paginationInfo.getLastRecordIndex()); searchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); List sampleList = sampleService.selectSampleList(searchVO); model.addAttribute("resultList", sampleList); int totCnt = sampleService.selectSampleListTotCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return "/sample/egovSampleList"; }
/** * 기업회원목록을 조회한다. (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 groupVO */ @RequestMapping("/sec/grp/listGroupPopup.do") public String listGroupSearch(@ModelAttribute GroupVO groupVO, ModelMap model) { PaginationInfo paginationInfo = new PaginationInfo(); groupVO.getSearchVO().fillPageInfo(paginationInfo); model.addAttribute("resultList", groupService.selectGroupList(groupVO)); int totCnt = groupService.selectGroupListCnt(groupVO); groupVO.getSearchVO().setTotalRecordCount(totCnt); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute(paginationInfo); return WebUtil.adjustViewName("/sec/grp/GroupSearchPopup"); }
/** * 결재자 정보에 대한 팝업 목록을 조회한다. * * @param sanctnerVO */ @RequestMapping("/uss/ion/ism/listSanctnerPopup.do") public String selectSanctnerList(@ModelAttribute SanctnerVO sanctnerVO, ModelMap model) { PaginationInfo paginationInfo = new PaginationInfo(); sanctnerVO.fillPageInfo(paginationInfo); model.addAttribute("resultList", infrmlSanctnService.selectSanctnerList(sanctnerVO)); int totCnt = infrmlSanctnService.selectSanctnerListCnt(sanctnerVO); sanctnerVO.setTotalRecordCount(totCnt); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return WebUtil.adjustViewName("/uss/ion/ism/SanctnerListPopup"); }
/** * 설문문항 목록을 조회한다. * * @param searchVO * @param qustnrQestnManageVO * @param commandMap * @param model * @return "egovframework/com/uss/olp/qqm/EgovQustnrQestnManageList" * @throws Exception */ @IncludedInfo(name = "질문관리", order = 630, gid = 50) @RequestMapping(value = "/uss/olp/qqm/EgovQustnrQestnManageList.do") public String egovQustnrQestnManageList( @ModelAttribute("searchVO") ComDefaultVO searchVO, @ModelAttribute("qustnrQestnManageVO") QustnrQestnManageVO qustnrQestnManageVO, Map commandMap, 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 sCmd = commandMap.get("cmd") == null ? "" : (String) commandMap.get("cmd"); String sSearchMode = commandMap.get("searchMode") == null ? "" : (String) commandMap.get("searchMode"); if (sCmd.equals("del")) { egovQustnrQestnManageService.deleteQustnrQestnManage(qustnrQestnManageVO); } // 설문지정보에서 넘어오면 자동검색 설정 if (sSearchMode.equals("Y")) { searchVO.setSearchCondition("QESTNR_ID"); searchVO.setSearchKeyword(qustnrQestnManageVO.getQestnrId()); } /** EgovPropertyService.sample */ searchVO.setPageUnit(propertiesService.getInt("pageUnit")); searchVO.setPageSize(propertiesService.getInt("pageSize")); /** pageing */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(searchVO.getPageIndex()); paginationInfo.setRecordCountPerPage(searchVO.getPageUnit()); paginationInfo.setPageSize(searchVO.getPageSize()); searchVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); searchVO.setLastIndex(paginationInfo.getLastRecordIndex()); searchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); List sampleList = egovQustnrQestnManageService.selectQustnrQestnManageList(searchVO); model.addAttribute("resultList", sampleList); int totCnt = (Integer) egovQustnrQestnManageService.selectQustnrQestnManageListCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return "egovframework/com/uss/olp/qqm/EgovQustnrQestnManageList"; }
/** * 약관정보 목록을 조회한다. * * @param stplatManageVO */ @IncludedInfo(name = "약관관리", order = 5040, gid = 50) @RequestMapping(value = "/uss/sam/stp/listStplat.do") @Secured("ROLE_ADMIN") public String listStplat(@ModelAttribute StplatManageVO stplatManageVO, ModelMap model) { PaginationInfo paginationInfo = new PaginationInfo(); stplatManageVO.fillPageInfo(paginationInfo); model.addAttribute("resultList", stplatManageService.selectStplatList(stplatManageVO)); int totCnt = stplatManageService.selectStplatListCnt(stplatManageVO); stplatManageVO.setTotalRecordCount(totCnt); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return WebUtil.adjustViewName("/uss/sam/stp/StplatList"); }
/** * 시스템사용 목적별 그룹 목록 조회 * * @param groupVO */ @IncludedInfo(name = "그룹관리", order = 2030, gid = 20) @RequestMapping(value = "/sec/grp/listGroup.do") @Secured("ROLE_ADMIN") public String listGroup(@ModelAttribute GroupVO groupVO, ModelMap model) { PaginationInfo paginationInfo = new PaginationInfo(); groupVO.getSearchVO().fillPageInfo(paginationInfo); model.addAttribute("resultList", groupService.selectGroupList(groupVO)); int totCnt = groupService.selectGroupListCnt(groupVO); groupVO.getSearchVO().setTotalRecordCount(totCnt); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute(paginationInfo); return WebUtil.adjustViewName("/sec/grp/GroupList"); }
/** * 도움말내용 목록을 조회한다. (pageing) * * @param hpcmManageVO */ @RequestMapping(value = "/uss/olh/hpc/listHpcmJson.mdo") public ModelAndView listHpcmJson(@ModelAttribute HpcmManageVO hpcmManageVO) { ModelAndView modelAndView = new ModelAndView("jsonView"); /** pageing */ PaginationInfo paginationInfo = new PaginationInfo(); hpcmManageVO.getSearchVO().fillPageInfo(paginationInfo); modelAndView.addObject("reusltList", hpcmManageService.selectHpcmList(hpcmManageVO)); int totCnt = hpcmManageService.selectHpcmListCnt(hpcmManageVO); hpcmManageVO.getSearchVO().setTotalRecordCount(totCnt); paginationInfo.setTotalRecordCount(totCnt); modelAndView.addObject(paginationInfo); return modelAndView; }
/** * 처리 내용 : 차주정보 리스트를 화면에 출력 처리 날짜 : 2015.01.08 * * @param searchVO * @param model * @param request * @param response * @return * @throws Exception */ @RequestMapping("/list.do") public String carOwnListForm( @ModelAttribute("pageVO") BasePageVO pageVO, ModelMap model, HttpServletRequest request, HttpServletResponse response) throws Exception { BaseSessInfo info = SessionUtility.getLoginForAdmin(request); if (info == null) { return "redirect:/cms/login.do"; } pageVO.setPageUnit(propertiesService.getInt("pageUnit")); pageVO.setPageSize(propertiesService.getInt("pageSize")); PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(pageVO.getPageIndex()); paginationInfo.setRecordCountPerPage(pageVO.getPageUnit()); paginationInfo.setPageSize(pageVO.getPageSize()); pageVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); pageVO.setLastIndex(paginationInfo.getLastRecordIndex()); pageVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); List<CarOwnerVO> lstData = null; try { lstData = carOwnerService.selectListData(pageVO, info.getUserId()); for (int i = 0; i < lstData.size(); i++) { CarOwnerVO vo = new CarOwnerVO(); vo = lstData.get(i); vo.setTel_no(ComCrypto.decode(cryptoService, lstData.get(i).getTel_no())); lstData.set(i, vo); int totCnt = carOwnerService.selectListCount(pageVO); paginationInfo.setTotalRecordCount(totCnt); } } catch (DataAccessException e) { logger.error("/cms/sms/list.do, selectListData | selectListCount Error..."); } catch (Exception e) { logger.error("/cms/sms/list.do, selectListData | selectListCount Error..."); } if (lstData == null) lstData = new ArrayList<CarOwnerVO>(); model.addAttribute("resultList", lstData); model.addAttribute("pageVO", pageVO); model.addAttribute("paginationInfo", paginationInfo); return "cms/carown/list"; }
/** * 모바일 기기 목록 조회 Service interface 호출 및 결과를 반환한다. * * @param deviceIdentVO */ @IncludedInfo(name = "모바일 기기 정보", order = 10020, gid = 100) @RequestMapping(value = "/mbl/com/mdi/listDeviceIdent.do") @Secured("ROLE_ADMIN") public String listDeviceIdent(@ModelAttribute DeviceIdentVO deviceIdentVO, ModelMap model) { PaginationInfo paginationInfo = new PaginationInfo(); deviceIdentVO.fillPageInfo(paginationInfo); model.addAttribute("resultList", deviceIdentService.selectDeviceIdentList(deviceIdentVO)); int totCnt = deviceIdentService.selectDeviceIdentListCnt(deviceIdentVO); deviceIdentVO.setTotalRecordCount(totCnt); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); RequestContextHolder.getRequestAttributes() .setAttribute("jspPrefix", "aramframework/mbl", RequestAttributes.SCOPE_REQUEST); return WebUtil.adjustViewName("/com/mdi/DeviceIdentList"); }
/** * 우편번호 찾기 목록을 조회한다. * * @param searchVO * @param model * @return "egovframework/com/sym/ccm/zip/EgovCcmZipSearchList" * @throws Exception */ @RequestMapping(value = "/sym/ccm/zip/EgovCcmZipSearchList.do") public String selectZipSearchList(@ModelAttribute("searchVO") ZipVO searchVO, ModelMap model) throws Exception { /** EgovPropertyService.sample */ searchVO.setPageUnit(propertiesService.getInt("pageUnit")); searchVO.setPageSize(propertiesService.getInt("pageSize")); /** pageing */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(searchVO.getPageIndex()); paginationInfo.setRecordCountPerPage(searchVO.getPageUnit()); paginationInfo.setPageSize(searchVO.getPageSize()); searchVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); searchVO.setLastIndex(paginationInfo.getLastRecordIndex()); searchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); String sList = ""; if (searchVO.getSearchList() != null && searchVO.getSearchList() != "") { sList = searchVO.getSearchList().substring(0, 1); } model.addAttribute("searchList", sList); if (sList.equals("1")) { List<?> CmmnCodeList = zipManageService.selectZipList(searchVO); model.addAttribute("resultList", CmmnCodeList); int totCnt = zipManageService.selectZipListTotCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); } else { List<?> CmmnCodeList = rdnmadZipService.selectZipList(searchVO); model.addAttribute("resultList", CmmnCodeList); int totCnt = rdnmadZipService.selectZipListTotCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); } return "egovframework/com/sym/ccm/zip/EgovCcmZipSearchList"; }
/** * 설문템플릿 목록을 조회한다. * * @param searchVO * @param commandMap * @param qustnrTmplatManageVO * @param model * @return "/uss/olp/qtm/EgovQustnrTmplatManageList" * @throws Exception */ @RequestMapping(value = "/uss/olp/qtm/EgovQustnrTmplatManageList.do") public String EgovQustnrTmplatManageList( @ModelAttribute("searchVO") ComDefaultVO searchVO, Map commandMap, QustnrTmplatManageVO qustnrTmplatManageVO, ModelMap model) throws Exception { String sCmd = commandMap.get("cmd") == null ? "" : (String) commandMap.get("cmd"); if (sCmd.equals("del")) { egovQustnrTmplatManageService.deleteQustnrTmplatManage(qustnrTmplatManageVO); } /** EgovPropertyService.sample */ searchVO.setPageUnit(propertiesService.getInt("pageUnit")); searchVO.setPageSize(propertiesService.getInt("pageSize")); /** pageing */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(searchVO.getPageIndex()); paginationInfo.setRecordCountPerPage(searchVO.getPageUnit()); paginationInfo.setPageSize(searchVO.getPageSize()); searchVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); searchVO.setLastIndex(paginationInfo.getLastRecordIndex()); searchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); // List sampleList = egovQustnrTmplatManageService.selectQustnrTmplatManageList(searchVO); model.addAttribute( "resultList", egovQustnrTmplatManageService.selectQustnrTmplatManageList(searchVO)); model.addAttribute( "searchKeyword", commandMap.get("searchKeyword") == null ? "" : (String) commandMap.get("searchKeyword")); model.addAttribute( "searchCondition", commandMap.get("searchCondition") == null ? "" : (String) commandMap.get("searchCondition")); int totCnt = (Integer) egovQustnrTmplatManageService.selectQustnrTmplatManageListCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return "/uss/olp/qtm/EgovQustnrTmplatManageList"; }
/** * 프로세스 모니터링로그 정보에 대한 목록을 조회한다. * * @param ProcessMonVO - 프로세스 모니터링로그 VO * @return String - 리턴 URL * @param processMonVO */ @RequestMapping("/utl/sys/prm/EgovComUtlProcessMonLogList.do") public String selectProcessMonLogList( @ModelAttribute("searchVO") ProcessMonLogVO processMonLogVO, ModelMap model) throws Exception { // 로그인 객체 선언 LoginVO loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser(); processMonLogVO.setPageUnit(propertyService.getInt("pageUnit")); processMonLogVO.setPageSize(propertyService.getInt("pageSize")); PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(processMonLogVO.getPageIndex()); paginationInfo.setRecordCountPerPage(processMonLogVO.getPageUnit()); paginationInfo.setPageSize(processMonLogVO.getPageSize()); processMonLogVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); processMonLogVO.setLastIndex(paginationInfo.getLastRecordIndex()); processMonLogVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); // 조회기간설정 if (processMonLogVO.getSearchBgnDe() != null && processMonLogVO.getSearchEndDe() != null) { if (!processMonLogVO.getSearchBgnDe().equals("") && !processMonLogVO.getSearchEndDe().equals("")) { processMonLogVO.setSearchBgnDt( processMonLogVO.getSearchBgnDe() + " " + processMonLogVO.getSearchBgnHour()); processMonLogVO.setSearchEndDt( processMonLogVO.getSearchEndDe() + " " + processMonLogVO.getSearchEndHour()); } } Map<String, Object> map = processMonService.selectProcessMonLogList(processMonLogVO); int totCnt = Integer.parseInt((String) map.get("resultCnt")); paginationInfo.setTotalRecordCount(totCnt); // 조회시작시 model.addAttribute("searchBgnHour", (List<ComDefaultCodeVO>) getTimeHH()); // 조회종료시 model.addAttribute("searchEndHour", (List<ComDefaultCodeVO>) getTimeHH()); model.addAttribute("resultList", map.get("resultList")); model.addAttribute("resultCnt", map.get("resultCnt")); model.addAttribute("paginationInfo", paginationInfo); return "egovframework/com/utl/sys/prm/EgovComUtlProcessMonLogList"; }
/** * 우편번호 목록을 조회한다. * * @param loginVO * @param searchVO * @param model * @return "egovframework/com/sym/ccm/zip/EgovCcmZipList" * @throws Exception */ @IncludedInfo(name = "우편번호관리", listUrl = "/sym/ccm/zip/EgovCcmZipList.do", order = 1000, gid = 60) @RequestMapping(value = "/sym/ccm/zip/EgovCcmZipList.do") public String selectZipList( @ModelAttribute("loginVO") LoginVO loginVO, @ModelAttribute("searchVO") ZipVO searchVO, ModelMap model) throws Exception { /** EgovPropertyService.sample */ searchVO.setPageUnit(propertiesService.getInt("pageUnit")); searchVO.setPageSize(propertiesService.getInt("pageSize")); /** pageing */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(searchVO.getPageIndex()); paginationInfo.setRecordCountPerPage(searchVO.getPageUnit()); paginationInfo.setPageSize(searchVO.getPageSize()); searchVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); searchVO.setLastIndex(paginationInfo.getLastRecordIndex()); searchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); if (!searchVO.getSearchList().equals("2")) { List<?> CmmnCodeList = zipManageService.selectZipList(searchVO); model.addAttribute("resultList", CmmnCodeList); int totCnt = zipManageService.selectZipListTotCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); } else { List<?> CmmnCodeList = rdnmadZipService.selectZipList(searchVO); model.addAttribute("resultList", CmmnCodeList); int totCnt = rdnmadZipService.selectZipListTotCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); } return "egovframework/com/sym/ccm/zip/EgovCcmZipList"; }
/** * 등록된 지식정보평가 정보를 조회 한다. * * @param KnoAppraisalVO -app 지식정보평가 VO * @return String - 리턴 Url * @param KnoAppraisalVO */ @IncludedInfo( name = "지식평가관리", listUrl = "/dam/app/EgovComDamAppraisalList.do", order = 1290, gid = 80) @RequestMapping(value = "/dam/app/EgovComDamAppraisalList.do") public String selectKnoAppraisalList( @ModelAttribute("searchVO") KnoAppraisalVO searchVO, ModelMap model) throws Exception { // 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(); /** EgovPropertyService.mapMaterial */ searchVO.setPageUnit(propertiesService.getInt("pageUnit")); searchVO.setPageSize(propertiesService.getInt("pageSize")); /** paging */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(searchVO.getPageIndex()); paginationInfo.setRecordCountPerPage(searchVO.getPageUnit()); paginationInfo.setPageSize(searchVO.getPageSize()); searchVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); searchVO.setLastIndex(paginationInfo.getLastRecordIndex()); searchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); searchVO.setEmplyrId((String) loginVO.getUniqId()); List KnoAppraisalList = knoAppraisalService.selectKnoAppraisalList(searchVO); model.addAttribute("resultList", KnoAppraisalList); int totCnt = knoAppraisalService.selectKnoAppraisalTotCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return "egovframework/com/dam/app/EgovComDamAppraisalList"; }
/** * 설문문항 팝업 록을 조회한다. * * @param searchVO * @param qustnrQestnManageVO * @param commandMap * @param model * @return "egovframework/com/uss/olp/qqm/EgovQustnrQestnManageListPopup" * @throws Exception */ @RequestMapping(value = "/uss/olp/qqm/EgovQustnrQestnManageListPopup.do") public String egovQustnrQestnManageListPopup( @ModelAttribute("searchVO") ComDefaultVO searchVO, @ModelAttribute("qustnrQestnManageVO") QustnrQestnManageVO qustnrQestnManageVO, Map commandMap, ModelMap model) throws Exception { String sSearchMode = commandMap.get("searchMode") == null ? "" : (String) commandMap.get("searchMode"); // 설문지정보에서 넘어오면 자동검색 설정 if (sSearchMode.equals("Y")) { searchVO.setSearchCondition("QESTNR_ID"); searchVO.setSearchKeyword(qustnrQestnManageVO.getQestnrId()); } /** EgovPropertyService.sample */ searchVO.setPageUnit(propertiesService.getInt("pageUnit")); searchVO.setPageSize(propertiesService.getInt("pageSize")); /** pageing */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(searchVO.getPageIndex()); paginationInfo.setRecordCountPerPage(searchVO.getPageUnit()); paginationInfo.setPageSize(searchVO.getPageSize()); searchVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); searchVO.setLastIndex(paginationInfo.getLastRecordIndex()); searchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); List resultList = egovQustnrQestnManageService.selectQustnrQestnManageList(searchVO); model.addAttribute("resultList", resultList); int totCnt = (Integer) egovQustnrQestnManageService.selectQustnrQestnManageListCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return "egovframework/com/uss/olp/qqm/EgovQustnrQestnManageListPopup"; }
/** * Q&A정보 목록을 조회한다. (pageing) * * @param searchVO * @param model * @return "/uss/olh/qna/EgovQnaListInqire" * @throws Exception */ @RequestMapping(value = "/uss/olh/qna/QnaListInqire.do") public String selectQnaList( @ModelAttribute("searchVO") QnaManageDefaultVO searchVO, ModelMap model) throws Exception { /** EgovPropertyService.SiteList */ searchVO.setPageUnit(propertiesService.getInt("pageUnit")); searchVO.setPageSize(propertiesService.getInt("pageSize")); /** pageing */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(searchVO.getPageIndex()); paginationInfo.setRecordCountPerPage(searchVO.getPageUnit()); paginationInfo.setPageSize(searchVO.getPageSize()); searchVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); searchVO.setLastIndex(paginationInfo.getLastRecordIndex()); searchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); model.addAttribute("resultList", qnaManageService.selectQnaList(searchVO)); // 인증여부 체크 Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated(); // isAuthenticated = false; if (!isAuthenticated) { model.addAttribute("certificationAt", "N"); } else { model.addAttribute("certificationAt", "Y"); } int totCnt = qnaManageService.selectQnaListTotCnt(searchVO); paginationInfo.setTotalRecordCount(totCnt); model.addAttribute("paginationInfo", paginationInfo); return "/uss/olh/qna/EgovQnaListInqire"; }