Example #1
0
  // 페이징 객체를 설정한다.
  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";
  }
Example #10
0
  /**
   * 처리 내용 : 차주정보 리스트를 화면에 출력 처리 날짜 : 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";
  }
Example #16
0
  /**
   * 그룹팝업 화면
   *
   * @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");
  }
Example #20
0
  /**
   * 시스템사용 목적별 그룹 목록 조회
   *
   * @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;
  }
Example #22
0
  /**
   * 처리 내용 : 차주정보 리스트를 화면에 출력 처리 날짜 : 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";
  }