/**
   * 신규 게시판 마스터 등록을 위한 등록페이지로 이동한다.
   *
   * @param boardMasterVO
   * @param model
   * @return
   * @throws Exception
   */
  @RequestMapping("/cop/bbs/addBBSMaster.do")
  public String addBBSMaster(
      @ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model) throws Exception {
    BoardMaster boardMaster = new BoardMaster();

    ComDefaultCodeVO vo = new ComDefaultCodeVO();

    vo.setCodeId("COM004");

    List<?> codeResult = cmmUseService.selectCmmCodeDetail(vo);

    model.addAttribute("typeList", codeResult);

    vo.setCodeId("COM009");

    codeResult = cmmUseService.selectCmmCodeDetail(vo);

    model.addAttribute("attrbList", codeResult);
    model.addAttribute("boardMaster", boardMaster);

    String flag = propertyService.getString("Globals.addedOptions");
    if (flag != null && flag.trim().equalsIgnoreCase("true")) {
      model.addAttribute("addedOptions", "true");
    }

    return "cop/bbs/EgovBoardMstrRegist";
  }
  /**
   * 부서 정보에 대한 목록을 조회한다.
   *
   * @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";
  }
  /**
   * 승인(탈퇴)요청에 대한 목록을 조회한다.
   *
   * @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 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";
  }
  /**
   * 게시판 마스터 정보를 수정한다.
   *
   * @param boardMasterVO
   * @param boardMaster
   * @param model
   * @return
   * @throws Exception
   */
  @RequestMapping("/cop/bbs/UpdateBBSMasterInf.do")
  public String updateBBSMasterInf(
      @ModelAttribute("searchVO") BoardMasterVO boardMasterVO,
      @ModelAttribute("boardMaster") BoardMaster boardMaster,
      BindingResult bindingResult,
      ModelMap model)
      throws Exception {

    LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
    Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();

    beanValidator.validate(boardMaster, bindingResult);
    if (bindingResult.hasErrors()) {
      BoardMasterVO vo = bbsAttrbService.selectBBSMasterInf(boardMasterVO);

      model.addAttribute("result", vo);

      return "cop/bbs/EgovBoardMstrUpdt";
    }

    if (isAuthenticated) {
      boardMaster.setLastUpdusrId(user.getUniqId());
      boardMaster.setPosblAtchFileSize(propertyService.getString("posblAtchFileSize"));
      bbsAttrbService.updateBBSMasterInf(boardMaster);
    }

    return "forward:/cop/bbs/SelectBBSMasterInfs.do";
  }
  /**
   * 부서업무함 정보에 대한 목록을 조회한다.
   *
   * @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;
  }
  /**
   * 등록된 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";
  }
  /**
   * 기업회원목록을 조회한다. (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";
  }
Пример #9
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 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 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";
  }
Пример #12
0
  /**
   * 글 목록을 조회한다. (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";
  }
  /**
   * 등록된 지식맵(지식유형) 정보를 조회 한다.
   *
   * @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";
  }
Пример #14
0
  /**
   * 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 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";
  }
Пример #16
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";
  }
  /**
   * 게시판 마스터 상세내용을 조회한다.
   *
   * @param boardMasterVO
   * @param model
   * @return
   * @throws Exception
   */
  @RequestMapping("/cop/bbs/SelectBBSMasterInf.do")
  public String selectBBSMasterInf(
      @ModelAttribute("searchVO") BoardMasterVO searchVO, ModelMap model) throws Exception {
    BoardMasterVO vo = bbsAttrbService.selectBBSMasterInf(searchVO);

    model.addAttribute("result", vo);

    String flag = propertyService.getString("Globals.addedOptions");
    if (flag != null && flag.trim().equalsIgnoreCase("true")) {
      model.addAttribute("addedOptions", "true");
    }

    return "cop/bbs/EgovBoardMstrUpdt";
  }
  /**
   * 설문템플릿 목록을 조회한다.
   *
   * @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 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 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 boardMasterVO
   * @param boardMaster
   * @param status
   * @return
   * @throws Exception
   */
  @RequestMapping("/cop/bbs/insertBBSMasterInf.do")
  public String insertBBSMasterInf(
      @ModelAttribute("searchVO") BoardMasterVO boardMasterVO,
      @ModelAttribute("boardMaster") BoardMaster boardMaster,
      BindingResult bindingResult,
      SessionStatus status,
      ModelMap model)
      throws Exception {
    LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
    Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();

    beanValidator.validate(boardMaster, bindingResult);
    if (bindingResult.hasErrors()) {

      ComDefaultCodeVO vo = new ComDefaultCodeVO();

      vo.setCodeId("COM004");

      List<?> codeResult = cmmUseService.selectCmmCodeDetail(vo);

      model.addAttribute("typeList", codeResult);

      vo.setCodeId("COM009");

      codeResult = cmmUseService.selectCmmCodeDetail(vo);

      model.addAttribute("attrbList", codeResult);

      return "cop/bbs/EgovBoardMstrRegist";
    }

    if (isAuthenticated) {
      boardMaster.setFrstRegisterId(user.getUniqId());
      boardMaster.setUseAt("Y");
      boardMaster.setTrgetId("SYSTEMDEFAULT_REGIST");
      boardMaster.setPosblAtchFileSize(propertyService.getString("posblAtchFileSize"));

      bbsAttrbService.insertBBSMastetInf(boardMaster);
    }

    return "forward:/cop/bbs/SelectBBSMasterInfs.do";
  }
Пример #23
0
  /**
   * 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";
  }
  /**
   * 설문문항 팝업 록을 조회한다.
   *
   * @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";
  }
  /**
   * 게시판 사용을 위한 게시판 속성정보 한 건을 상세조회한다.
   *
   * @param boardMasterVO
   * @param model
   * @return
   * @throws Exception
   */
  @RequestMapping("/cop/bbs/SelectBBSMasterInfByTrget.do")
  public String selectBBSMasterInfByTrget(
      @ModelAttribute("searchVO") BoardMasterVO boardMasterVO,
      @RequestParam Map<String, Object> commandMap,
      ModelMap model)
      throws Exception {

    checkAuthority(boardMasterVO); // server-side 권한 확인

    BoardMasterVO vo = bbsAttrbService.selectBBSMasterInf(boardMasterVO);

    vo.setTrgetId(boardMasterVO.getTrgetId());

    model.addAttribute("result", vo);

    String flag = propertyService.getString("Globals.addedOptions");
    if (flag != null && flag.trim().equalsIgnoreCase("true")) {
      model.addAttribute("addedOptions", "true");
    }

    return "cop/bbs/EgovBdMstrUpdtByTrget";
  }
  /**
   * 우편번호 목록을 조회한다.
   *
   * @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 DeptJobVO
   * @return String
   * @param deptJobVO
   */
  @IncludedInfo(name = "부서업무정보", order = 401, gid = 40)
  @RequestMapping("/cop/smt/djm/selectDeptJobList.do")
  public String selectDeptJobList(@ModelAttribute("searchVO") DeptJobVO deptJobVO, ModelMap model)
      throws Exception {
    // LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser();

    // 로그인 객체 선언
    LoginVO loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();

    deptJobVO.setPageUnit(propertyService.getInt("pageUnit"));
    deptJobVO.setPageSize(propertyService.getInt("pageSize"));

    PaginationInfo paginationInfo = new PaginationInfo();
    paginationInfo.setCurrentPageNo(deptJobVO.getPageIndex());
    paginationInfo.setRecordCountPerPage(deptJobVO.getPageUnit());
    paginationInfo.setPageSize(deptJobVO.getPageSize());

    deptJobVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
    deptJobVO.setLastIndex(paginationInfo.getLastRecordIndex());
    deptJobVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());

    if (deptJobVO.getSearchDeptId() == null || deptJobVO.getSearchDeptId().equals("")) {
      deptJobVO.setSearchDeptId(loginVO.getOrgnztId());
    }

    Map<String, Object> map = deptJobService.selectDeptJobList(deptJobVO);
    int totCnt = Integer.parseInt((String) map.get("resultCnt"));
    paginationInfo.setTotalRecordCount(totCnt);

    model.addAttribute("resultBxList", deptJobService.selectDeptJobBxListAll());
    // model.addAttribute("deptId", loginVO.getOrgnztId());
    model.addAttribute("resultList", map.get("resultList"));
    model.addAttribute("resultCnt", map.get("resultCnt"));
    model.addAttribute("paginationInfo", paginationInfo);

    return "egovframework/com/cop/smt/djm/EgovDeptJobList";
  }
  /**
   * 게시판 사용정보 목록을 조회한다.
   *
   * @param bdUseVO
   * @param sessionVO
   * @param model
   * @return
   * @throws Exception
   */
  @IncludedInfo(name = "게시판사용정보", order = 190, gid = 40)
  @RequestMapping("/cop/com/selectBBSUseInfs.do")
  public String selectBBSUseInfs(@ModelAttribute("searchVO") BoardUseInfVO bdUseVO, ModelMap model)
      throws Exception {

    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.selectBBSUseInfs(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("paginationInfo", paginationInfo);

    if (EgovComponentChecker.hasComponent("EgovCommunityManageService")) { // 2011.09.15
      model.addAttribute("useCommunity", "true");
    }
    if (EgovComponentChecker.hasComponent("EgovClubManageService")) { // 2011.09.15
      model.addAttribute("useClub", "true");
    }

    return "egovframework/com/cop/com/EgovBoardUseInfList";
  }
  /**
   * 받은쪽지함관리 목록을 조회한다.
   *
   * @param request -HttpServletRequest 객체
   * @param response -HttpServletResponse 객체
   * @param searchVO -검색정보가 담긴 Model
   * @param commandMap -Request Variable
   * @param noteRecptn -받은쪽지함관리 Model
   * @param model -Spring 제공하는 ModelMap
   * @return String -리턴 URL
   * @throws Exception
   */
  @IncludedInfo(name = "받은쪽지함관리", order = 850, gid = 50)
  @RequestMapping(value = "/uss/ion/ntr/listNoteRecptn.do")
  public String EgovNoteRecptnList(
      HttpServletRequest request,
      HttpServletResponse response,
      @ModelAttribute("searchVO") NoteRecptn searchVO,
      Map commandMap,
      @ModelAttribute("noteRecptn") NoteRecptn noteRecptn,
      ModelMap model)
      throws Exception {

    // 변수 설정
    String sCmd = commandMap.get("cmd") == null ? "" : (String) commandMap.get("cmd");

    // 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();

    // 삭제 모드로 실행시
    if (sCmd.equals("del")) {
      // 한개의 값으로 삭제가 넘어올때 처리
      if (commandMap.get("checkList") instanceof String) {
        String sCheckList = (String) commandMap.get("checkList");

        String[] sArrCheckListValue = sCheckList.split(",");

        log.debug("==================================EgovNoteRecptnList");
        log.debug("checkList" + sCheckList);
        log.debug("sArrCheckListValue[0]>" + sArrCheckListValue[0]);
        log.debug("sArrCheckListValue[1]>" + sArrCheckListValue[1]);

        noteRecptn.setFrstRegisterId((String) loginVO.getUniqId());
        noteRecptn.setLastUpdusrId((String) loginVO.getUniqId());
        noteRecptn.setNoteId(sArrCheckListValue[0]);
        noteRecptn.setNoteTrnsmitId(sArrCheckListValue[1]);
        noteRecptn.setNoteRecptnId(sArrCheckListValue[2]);

        egovNoteRecptnService.deleteNoteRecptn(noteRecptn);
      }

      // 여러개의 값으로 삭제가 넘어올때 처리
      if (commandMap.get("checkList") instanceof String[]) {
        String[] sArrCheckList = (String[]) commandMap.get("checkList");
        // log.debug("sArrCheckList" + sArrCheckList);

        for (int i = 0; i < sArrCheckList.length; i++) {
          String[] sArrCheckListValue = sArrCheckList[i].split(",");

          noteRecptn.setFrstRegisterId((String) loginVO.getUniqId());
          noteRecptn.setLastUpdusrId((String) loginVO.getUniqId());
          noteRecptn.setNoteId(sArrCheckListValue[0]);
          noteRecptn.setNoteTrnsmitId(sArrCheckListValue[1]);
          noteRecptn.setNoteRecptnId(sArrCheckListValue[2]);

          egovNoteRecptnService.deleteNoteRecptn(noteRecptn);
        }
      }
      // 삭제후 페이지 인덱스 설정
      searchVO.setPageIndex(1);
    }

    /** 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());
    // 수신자설정
    searchVO.setRcverId((String) loginVO.getUniqId());

    List reusltList = egovNoteRecptnService.selectNoteRecptnList(searchVO);
    model.addAttribute("resultList", reusltList);

    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) egovNoteRecptnService.selectNoteRecptnListCnt(searchVO);
    paginationInfo.setTotalRecordCount(totCnt);
    model.addAttribute("paginationInfo", paginationInfo);

    return "egovframework/com/uss/ion/ntr/EgovNoteRecptnList";
  }