Commit @30 - jhleem/egov

Files
Commit

임종호 2022-02-14 @30

게시판 블로그 삭제

Index: base3.10/src/main/java/egovframework/com/cop/bbs/web/EgovArticleController.java =================================================================== --- base3.10/src/main/java/egovframework/com/cop/bbs/web/EgovArticleController.java (revision 29) +++ base3.10/src/main/java/egovframework/com/cop/bbs/web/EgovArticleController.java (revision 30) @@ -997,230 +997,7 @@ return "forward:/cop/bbs/selectGuestArticleList.do"; } - /********************* - * 블로그관련 - * ********************/ - - /** - * 블로그 게시판에 대한 목록을 조회한다. - * - * @param boardVO - * @param sessionVO - * @param model - * @return - * @throws Exception - */ - @RequestMapping("/cop/bbs/selectArticleBlogList.do") - public String selectArticleBlogList(@ModelAttribute("searchVO") BoardVO boardVO, ModelMap model) throws Exception { - - LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); - - Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated(); //KISA 보안취약점 조치 (2018-12-10, 이정은) - - if(!isAuthenticated) { - return "egovframework/com/uat/uia/EgovLoginUsr"; - } - - BlogVO blogVo = new BlogVO(); - blogVo.setFrstRegisterId((user == null || user.getUniqId() == null) ? "" : user.getUniqId()); - blogVo.setBbsId(boardVO.getBbsId()); - blogVo.setBlogId(boardVO.getBlogId()); - BlogVO master = egovBBSMasterService.selectBlogDetail(blogVo); - - boardVO.setFrstRegisterId((user == null || user.getUniqId() == null) ? "" : user.getUniqId()); - - //블로그 카테고리관리 권한(로그인 한 사용자만 가능) - int loginUserCnt = egovArticleService.selectLoginUser(boardVO); - - //블로그 게시판 제목 추출 - List<BoardVO> blogNameList = egovArticleService.selectBlogNmList(boardVO); - - if(user != null) { - model.addAttribute("sessionUniqId", (user == null || user.getUniqId() == null) ? "" : user.getUniqId()); - } - - model.addAttribute("articleVO", boardVO); - model.addAttribute("boardMasterVO", master); - model.addAttribute("blogNameList", blogNameList); - model.addAttribute("loginUserCnt", loginUserCnt); - - return "egovframework/com/cop/bbs/EgovArticleBlogList"; - } - - /** - * 블로그 게시물에 대한 상세 타이틀을 조회한다. - * - * @param boardVO - * @param sessionVO - * @param model - * @return - * @throws Exception - */ - @RequestMapping("/cop/bbs/selectArticleBlogDetail.do") - public ModelAndView selectArticleBlogDetail(@ModelAttribute("searchVO") BoardVO boardVO, ModelMap model) throws Exception { - LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); - - Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated(); //KISA 보안취약점 조치 (2018-12-10, 이정은) - - if(!isAuthenticated) { - throw new IllegalAccessException("Login Required!"); - } - - BoardVO vo = new BoardVO(); - - boardVO.setLastUpdusrId((user == null || user.getUniqId() == null) ? "" : user.getUniqId()); - - boardVO.setPageUnit(propertyService.getInt("pageUnit")); - boardVO.setPageSize(propertyService.getInt("pageSize")); - - PaginationInfo paginationInfo = new PaginationInfo(); - - paginationInfo.setCurrentPageNo(boardVO.getPageIndex()); - paginationInfo.setRecordCountPerPage(boardVO.getPageUnit()); - paginationInfo.setPageSize(boardVO.getPageSize()); - - boardVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); - boardVO.setLastIndex(paginationInfo.getLastRecordIndex()); - boardVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); - - List<BoardVO> blogSubJectList = egovArticleService.selectArticleDetailDefault(boardVO); - vo = egovArticleService.selectArticleCnOne(boardVO); - - int totCnt = egovArticleService.selectArticleDetailDefaultCnt(boardVO); - paginationInfo.setTotalRecordCount(totCnt); - - ModelAndView mav = new ModelAndView("jsonView"); - mav.addObject("blogSubJectList", blogSubJectList); - mav.addObject("paginationInfo", paginationInfo); - - if(vo.getNttCn() != null){ - mav.addObject("blogCnOne", vo); - } - - //비밀글은 작성자만 볼수 있음 - if(!EgovStringUtil.isEmpty(vo.getSecretAt()) && vo.getSecretAt().equals("Y") && !((user == null || user.getUniqId() == null) ? "" : user.getUniqId()).equals(vo.getFrstRegisterId())) - mav.setViewName("forward:/cop/bbs/selectArticleList.do"); - return mav; - } - - /** - * 블로그 게시물에 대한 상세 내용을 조회한다. - * - * @param boardVO - * @param sessionVO - * @param model - * @return - * @throws Exception - */ - @RequestMapping("/cop/bbs/selectArticleBlogDetailCn.do") - public ModelAndView selectArticleBlogDetailCn(@ModelAttribute("searchVO") BoardVO boardVO, @ModelAttribute("commentVO") CommentVO commentVO, ModelMap model) throws Exception { - LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); - - boardVO.setLastUpdusrId((user == null || user.getUniqId() == null) ? "" : user.getUniqId()); - - Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated(); //KISA 보안취약점 조치 (2018-12-10, 이정은) - - if(!isAuthenticated) { - throw new IllegalAccessException("Login Required!"); - } - - BoardVO vo = egovArticleService.selectArticleDetail(boardVO); - - //---------------------------- - // 댓글 처리 - //---------------------------- - CommentVO articleCommentVO = new CommentVO(); - commentVO.setWrterNm((user == null || user.getName() == null) ? "" : user.getName()); - - PaginationInfo paginationInfo = new PaginationInfo(); - paginationInfo.setCurrentPageNo(commentVO.getSubPageIndex()); - paginationInfo.setRecordCountPerPage(commentVO.getSubPageUnit()); - paginationInfo.setPageSize(commentVO.getSubPageSize()); - - commentVO.setSubFirstIndex(paginationInfo.getFirstRecordIndex()); - commentVO.setSubLastIndex(paginationInfo.getLastRecordIndex()); - commentVO.setSubRecordCountPerPage(paginationInfo.getRecordCountPerPage()); - - Map<String, Object> map = egovArticleCommentService.selectArticleCommentList(commentVO); - int totCnt = Integer.parseInt((String)map.get("resultCnt")); - - paginationInfo.setTotalRecordCount(totCnt); - - //댓글 처리 END - //---------------------------- - - List<BoardVO> blogCnList = egovArticleService.selectArticleDetailCn(boardVO); - ModelAndView mav = new ModelAndView("jsonView"); - - // 수정 처리된 후 댓글 등록 화면으로 처리되기 위한 구현 - if (commentVO.isModified()) { - commentVO.setCommentNo(""); - commentVO.setCommentCn(""); - } - - // 수정을 위한 처리 - if (!commentVO.getCommentNo().equals("")) { - mav.setViewName ("forward:/cop/cmt/updateArticleCommentView.do"); - } - - mav.addObject("blogCnList", blogCnList); - mav.addObject("resultUnder", vo); - mav.addObject("paginationInfo", paginationInfo); - mav.addObject("resultList", map.get("resultList")); - mav.addObject("resultCnt", map.get("resultCnt")); - mav.addObject("articleCommentVO", articleCommentVO); // validator 용도 - - commentVO.setCommentCn(""); // 등록 후 댓글 내용 처리 - - //비밀글은 작성자만 볼수 있음 - if(!EgovStringUtil.isEmpty(vo.getSecretAt()) && vo.getSecretAt().equals("Y") && !((user == null || user.getUniqId() == null) ? "" : user.getUniqId()).equals(vo.getFrstRegisterId())) - mav.setViewName("forward:/cop/bbs/selectArticleList.do"); - return mav; - - } - /** - * 개인블로그 관리 - * - * @param boardVO - * @param sessionVO - * @param model - * @return - * @throws Exception - */ - @RequestMapping("/cop/bbs/selectBlogListManager.do") - public String selectBlogMasterList(@ModelAttribute("searchVO") BoardVO boardVO, ModelMap model) throws Exception { - - LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); - - - boardVO.setPageUnit(propertyService.getInt("pageUnit")); - boardVO.setPageSize(propertyService.getInt("pageSize")); - - PaginationInfo paginationInfo = new PaginationInfo(); - - paginationInfo.setCurrentPageNo(boardVO.getPageIndex()); - paginationInfo.setRecordCountPerPage(boardVO.getPageUnit()); - paginationInfo.setPageSize(boardVO.getPageSize()); - - boardVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); - boardVO.setLastIndex(paginationInfo.getLastRecordIndex()); - boardVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); - boardVO.setFrstRegisterId((user == null || user.getUniqId() == null) ? "" : user.getUniqId()); - - Map<String, Object> map = egovArticleService.selectBlogListManager(boardVO); - 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/bbs/EgovBlogListManager"; - } - - /** * 템플릿에 대한 미리보기용 게시물 목록을 조회한다. * * @param boardVO @@ -1303,58 +1080,4 @@ return "egovframework/com/cop/bbs/EgovArticleList"; } - - /** - * 미리보기 커뮤니티 메인페이지를 조회한다. - * - * @param cmmntyVO - * @param sessionVO - * @param model - * @return - * @throws Exception - */ - @RequestMapping("/cop/bbs/previewBlogMainPage.do") - public String previewBlogMainPage(@ModelAttribute("searchVO") BoardVO boardVO, ModelMap model) throws Exception { - - LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); - Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated(); //KISA 보안취약점 조치 (2018-12-10, 이정은) - - String tmplatCours = boardVO.getSearchWrd(); - - BlogVO master = new BlogVO(); - master.setBlogNm("미리보기 블로그"); - master.setBlogIntrcn("미리보기를 위한 블로그입니다."); - master.setUseAt("Y"); - master.setFrstRegisterId((user == null || user.getUniqId() == null) ? "" : user.getUniqId()); - - boardVO.setFrstRegisterId((user == null || user.getUniqId() == null) ? "" : user.getUniqId()); - - //블로그 카테고리관리 권한(로그인 한 사용자만 가능) - int loginUserCnt = egovArticleService.selectLoginUser(boardVO); - - //블로그 게시판 제목 추출 - List<BoardVO> blogNameList = new ArrayList<BoardVO>(); - - BoardVO target = null; - target = new BoardVO(); - target.setBbsNm("블로그게시판#1"); - - blogNameList.add(target); - - - if(user != null) { - model.addAttribute("sessionUniqId", user.getUniqId()); - } - - model.addAttribute("articleVO", boardVO); - model.addAttribute("boardMasterVO", master); - model.addAttribute("blogNameList", blogNameList); - model.addAttribute("loginUserCnt", 1); - - model.addAttribute("preview", "true"); - - return "egovframework/com/cmm/egovError"; - } - - } Index: base3.10/src/main/java/egovframework/com/cop/bbs/web/EgovBBSMasterController.java =================================================================== --- base3.10/src/main/java/egovframework/com/cop/bbs/web/EgovBBSMasterController.java (revision 29) +++ base3.10/src/main/java/egovframework/com/cop/bbs/web/EgovBBSMasterController.java (revision 30) @@ -206,156 +206,6 @@ } /** - * 블로그에 대한 목록을 조회한다. - * - * @param blogVO - * @param model - * @return - * @throws Exception - */ - @IncludedInfo(name="블로그관리", order = 170 ,gid = 40) - @RequestMapping("/cop/bbs/selectBlogList.do") - public String selectBlogMasterList(@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model) throws Exception { - - LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); - //KISA 보안취약점 조치 (2018-12-10, 신용호) - Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated(); - - if(!isAuthenticated) { - return "egovframework/com/uat/uia/EgovLoginUsr"; - } - - 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.setFrstRegisterId(user == null ? "" : EgovStringUtil.isNullToString(user.getUniqId())); - - Map<String, Object> map = egovBBSMasterService.selectBlogMasterInfs(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 "egovframework/com/cop/bbs/EgovBlogList"; - } - - /** - * 블로그 등록을 위한 등록페이지로 이동한다. - * - * @param blogVO - * @param model - * @return - * @throws Exception - */ - @RequestMapping("/cop/bbs/insertBlogMasterView.do") - public String insertBlogMasterView(@ModelAttribute("searchVO") BlogVO blogVO, ModelMap model) throws Exception { - model.addAttribute("blogMasterVO", new BlogVO()); - return "egovframework/com/cop/bbs/EgovBlogRegist"; - } - - /** - * 블로그 생성 유무를 판단한다. - * - * @param blogVO - * @param model - * @return - * @throws Exception - */ - @RequestMapping("/cop/bbs/selectChkBloguser.do") - public ModelAndView chkBlogUser(@ModelAttribute("searchVO") BlogVO blogVO, ModelMap model) throws Exception { - LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); - // KISA 보안취약점 조치 (2018-12-10, 신용호) - Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated(); - - if(!isAuthenticated) { - throw new IllegalAccessException("Login Required!"); - } - - model.addAttribute("blogMasterVO", new BlogVO()); - - String userVal=""; - blogVO.setFrstRegisterId(user == null ? "" : EgovStringUtil.isNullToString(user.getUniqId())); - userVal = egovBBSMasterService.checkBlogUser(blogVO); - - ModelAndView mav = new ModelAndView("jsonView"); - mav.addObject("userChk", userVal); - return mav; - } - - /** - * 블로그 정보를 등록한다. - * - * @param blogVO - * @param blog - * @param status - * @param model - * @return - * @throws Exception - */ - @RequestMapping("/cop/bbs/insertBlogMaster.do") - public String insertBlogMaster(@ModelAttribute("searchVO") BlogVO blogVO, @ModelAttribute("blogMaster") Blog blog, - BindingResult bindingResult, ModelMap model) throws Exception { - - LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); - Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated(); - - if(!isAuthenticated) { //KISA 보안약점 조치 (2018-12-10, 신용호) - return "egovframework/com/uat/uia/EgovLoginUsr"; - } - - blogVO.setFrstRegisterId(user == null ? "" : EgovStringUtil.isNullToString(user.getUniqId())); - BlogVO vo = egovBBSMasterService.checkBlogUser2(blogVO); - - if(vo != null) { - model.addAttribute("blogMasterVO", new BlogVO()); - model.addAttribute("message", egovMessageSource.getMessage("comCopBlog.validate.blogUserCheck")); - return "egovframework/com/cop/bbs/EgovBlogRegist"; - } - - beanValidator.validate(blog, bindingResult); - - if (bindingResult.hasErrors()) { - return "egovframework/com/cop/bbs/EgovBlogRegist"; - } - - String blogId = idgenServiceBlog.getNextStringId(); //블로그 아이디 채번 - String bbsId = idgenServiceBbs.getNextStringId(); //게시판 아이디 채번 - - blog.setRegistSeCode("REGC02"); - blog.setFrstRegisterId(user == null ? "" : EgovStringUtil.isNullToString(user.getUniqId())); - blog.setBbsId(bbsId); - blog.setBlogId(blogId); - blog.setBlogAt("Y"); - egovBBSMasterService.insertBlogMaster(blog); - - if (isAuthenticated) { - //블로그 개설자의 정보를 등록한다. - BlogUserVO blogUserVO = new BlogUserVO(); - blogUserVO.setBlogId(blogId); - blogUserVO.setEmplyrId(user == null ? "" : EgovStringUtil.isNullToString(user.getUniqId())); - blogUserVO.setMngrAt("Y"); - blogUserVO.setMberSttus("P"); - blogUserVO.setUseAt("Y"); - blogUserVO.setFrstRegisterId(user == null ? "" : EgovStringUtil.isNullToString(user.getUniqId())); - - egovBBSMasterService.insertBoardBlogUserRqst(blogUserVO); - } - return "forward:/cop/bbs/selectBlogList.do"; - } - - /** * 게시판 마스터 상세내용을 조회한다. * * @param boardMasterVO @@ -489,40 +339,4 @@ // status.setComplete(); return "redirect:/cop/bbs/selectBBSMasterInfs.do?" + boardMasterVO.searchParam(3); } - - /** - * 포트릿을 위한 블로그 목록 정보를 조회한다. - * - * @param blogVO - * @param model - * @return - * @throws Exception - */ - @RequestMapping("/cop/bbs/selectBlogListPortlet.do") - public String selectBlogListPortlet(@ModelAttribute("searchVO") BlogVO blogVO, ModelMap model) throws Exception { - List<BlogVO> result = egovBBSMasterService.selectBlogListPortlet(blogVO); - - model.addAttribute("resultList", result); - - return "egovframework/com/cop/bbs/EgovBlogListPortlet"; - } - - /** - * 포트릿을 위한 게시판 목록 정보를 조회한다. - * - * @param blogVO - * @param model - * @return - * @throws Exception - */ - @RequestMapping("/cop/bbs/selectBBSListPortlet.do") - public String selectBBSListPortlet(@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model) throws Exception { - List<BoardMasterVO> result = egovBBSMasterService.selectBBSListPortlet(boardMasterVO); - - model.addAttribute("resultList", result); - - return "egovframework/com/cop/bbs/EgovBBSListPortlet"; - } - - -} +} \ No newline at end of file Index: base3.10/src/main/java/egovframework/com/cop/bbs/service/impl/EgovArticleServiceImpl.java =================================================================== --- base3.10/src/main/java/egovframework/com/cop/bbs/service/impl/EgovArticleServiceImpl.java (revision 29) +++ base3.10/src/main/java/egovframework/com/cop/bbs/service/impl/EgovArticleServiceImpl.java (revision 30) @@ -115,11 +115,6 @@ public List<BoardVO> selectNoticeArticleList(BoardVO boardVO) { return egovArticleDao.selectNoticeArticleList(boardVO); } - - @Override - public List<BoardVO> selectBlogNmList(BoardVO boardVO) { - return egovArticleDao.selectBlogNmList(boardVO); - } @Override public Map<String, Object> selectGuestArticleList(BoardVO vo) { @@ -135,23 +130,5 @@ return map; } - - @Override - public int selectLoginUser(BoardVO boardVO){ - return egovArticleDao.selectLoginUser(boardVO); - } - - @Override - public Map<String, Object> selectBlogListManager(BoardVO vo) { - List<?> result = egovArticleDao.selectBlogListManager(vo); - int cnt = egovArticleDao.selectBlogListManagerCnt(vo); - - Map<String, Object> map = new HashMap<String, Object>(); - - map.put("resultList", result); - map.put("resultCnt", Integer.toString(cnt)); - - return map; - } } Index: base3.10/src/main/java/egovframework/com/cop/bbs/service/impl/EgovArticleDAO.java =================================================================== --- base3.10/src/main/java/egovframework/com/cop/bbs/service/impl/EgovArticleDAO.java (revision 29) +++ base3.10/src/main/java/egovframework/com/cop/bbs/service/impl/EgovArticleDAO.java (revision 30) @@ -68,18 +68,6 @@ return (BoardVO) selectOne("BBSArticle.selectArticleCnOne", boardVO); } - public List<BoardVO> selectBlogNmList(BoardVO boardVO) { - return (List<BoardVO>) list("BBSArticle.selectBlogNmList", boardVO); - } - - public List<?> selectBlogListManager(BoardVO vo) { - return list("BBSArticle.selectBlogListManager", vo); - } - - public int selectBlogListManagerCnt(BoardVO vo) { - return (Integer)selectOne("BBSArticle.selectBlogListManagerCnt", vo); - } - public List<BoardVO> selectArticleDetailDefault(BoardVO boardVO) { return (List<BoardVO>) list("BBSArticle.selectArticleDetailDefault", boardVO); } @@ -92,9 +80,5 @@ return (List<BoardVO>) list("BBSArticle.selectArticleDetailCn", boardVO); } - public int selectLoginUser(BoardVO boardVO) { - return (Integer)selectOne("BBSArticle.selectLoginUser", boardVO); - } - } Index: base3.10/src/main/java/egovframework/com/cop/bbs/service/EgovArticleService.java =================================================================== --- base3.10/src/main/java/egovframework/com/cop/bbs/service/EgovArticleService.java (revision 29) +++ base3.10/src/main/java/egovframework/com/cop/bbs/service/EgovArticleService.java (revision 30) @@ -26,15 +26,9 @@ */ BoardVO selectArticleCnOne(BoardVO boardVO); - List<BoardVO> selectBlogNmList(BoardVO boardVO); - - Map<String, Object> selectBlogListManager(BoardVO boardVO); - List<BoardVO> selectArticleDetailDefault(BoardVO boardVO); int selectArticleDetailDefaultCnt(BoardVO boardVO); List<BoardVO> selectArticleDetailCn(BoardVO boardVO); - - int selectLoginUser(BoardVO boardVO); } Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_tibero.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_tibero.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_tibero.xml (revision 30) @@ -507,75 +507,6 @@ </select> - <select id="selectBlogNmList" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardMasterList"> - SELECT * FROM ( SELECT rownum rn, TB.* FROM ( - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - ORDER BY A.FRST_REGIST_PNTTM DESC - ) TB ) WHERE rn BETWEEN 1 AND 7 - - </select> - - <select id="selectLoginUser" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE - FRST_REGISTER_ID = #{frstRegisterId} - AND - BLOG_ID = #{blogId} - - </select> - - <select id="selectBlogListManager" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardBlogManager"> - - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM, C.USER_NM AS FRST_REGISTER_NM, - TO_CHAR(a.FRST_REGIST_PNTTM, 'YYYY-MM-DD') as FRST_REGIST_PNTTM, - A.USE_AT - FROM - COMTNBBSMASTER A - LEFT OUTER JOIN - COMTNBLOG B - ON A.BLOG_ID = B.BLOG_ID - LEFT OUTER JOIN - (SELECT ESNTL_ID, USER_ID, USER_NM FROM COMVNUSERMASTER) C - ON A.FRST_REGISTER_ID = C.ESNTL_ID - WHERE A.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE '%' || #{searchWrd} || '%' - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE '%' || #{searchWrd} || '%' - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - - <select id="selectBlogListManagerCnt" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(1) - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE '%' || #{searchWrd} || '%' - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE '%' || #{searchWrd} || '%' - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - <select id="selectArticleDetailDefaultCnt" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> SELECT Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_postgres.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_postgres.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_postgres.xml (revision 30) @@ -465,61 +465,6 @@ </select> - <select id="selectLoginUser" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE - FRST_REGISTER_ID = #{frstRegisterId} - AND - BLOG_ID = #{blogId} - - </select> - - <select id="selectBlogListManager" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardBlogManager"> - - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM, C.USER_NM AS FRST_REGISTER_NM, - TO_CHAR(A.FRST_REGIST_PNTTM, 'YYYY-mm-dd') as FRST_REGIST_PNTTM, - A.USE_AT - FROM - COMTNBBSMASTER A - LEFT OUTER JOIN - COMTNBLOG B - ON A.BLOG_ID = B.BLOG_ID - LEFT OUTER JOIN - (SELECT ESNTL_ID, USER_ID, USER_NM FROM COMVNUSERMASTER) C - ON A.FRST_REGISTER_ID = C.ESNTL_ID - WHERE A.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE CONCAT ('%', #{searchWrd},'%') - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - - <select id="selectBlogListManagerCnt" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(1) - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE CONCAT ('%', #{searchWrd},'%') - </if> - - </select> - <select id="selectArticleCnOne" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardCnOne"> SELECT @@ -541,19 +486,6 @@ </select> - <select id="selectBlogNmList" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardMasterList"> - - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - ORDER BY A.FRST_REGIST_PNTTM DESC - LIMIT 7 OFFSET 0 - - </select> - <select id="selectArticleDetailDefault" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardSubJectList"> SELECT Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_mysql.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_mysql.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_mysql.xml (revision 30) @@ -204,116 +204,6 @@ </update> - <select id="selectBlogMasterList" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogList"> - - SELECT - a.BLOG_ID, a.BLOG_NM, a.USE_AT, a.REGIST_SE_CODE, - c.CODE_NM as REGIST_SE_CODE_NM, - DATE_FORMAT(a.FRST_REGIST_PNTTM, '%Y-%m-%d') as FRST_REGIST_PNTTM, - a.FRST_REGISTER_ID, - b.USER_NM as FRST_REGISTER_NM, - a.BBS_ID, d.AUTHOR_CODE - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCnd == 0">AND - a.BLOG_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - - ORDER BY a.FRST_REGIST_PNTTM DESC - LIMIT #{recordCountPerPage} OFFSET #{firstIndex} - - </select> - - <select id="selectBlogMasterListTotCnt" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultType="java.lang.Integer"> - - SELECT - COUNT(*) - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCnd == 0">AND - a.BLOG_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - - </select> - - <select id="selectBlogDetail" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogDetail"> - - SELECT - BLOG_ID, BBS_ID, BLOG_NM, BLOG_INTRCN - FROM - COMTNBLOG - WHERE BLOG_ID = #{blogId} - - </select> - - <select id="checkExistUser" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultType="java.lang.Integer"> - - SELECT - COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <select id="checkExistUser2" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogUser"> - - SELECT - FRST_REGISTER_ID - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <insert id="insertBoardBlogUserRqst" parameterType="egovframework.com.cop.bbs.service.BlogUser"> - - INSERT INTO COMTNBLOGUSER - (BLOG_ID, EMPLYR_ID, MNGR_AT, SBSCRB_DE, - MBER_STTUS, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID) - VALUES (#{blogId}, #{emplyrId}, #{mngrAt}, SYSDATE(), - #{mberSttus}, #{useAt}, SYSDATE(), #{frstRegisterId}) - - </insert> - - <insert id="insertBlogMaster" parameterType="egovframework.com.cop.bbs.service.BlogVO"> - - INSERT INTO COMTNBLOG - (BLOG_ID, BLOG_NM, BLOG_INTRCN, REGIST_SE_CODE, - TMPLAT_ID, USE_AT, FRST_REGISTER_ID, FRST_REGIST_PNTTM, BBS_ID, BLOG_AT) - VALUES - (#{blogId}, #{blogNm}, #{blogIntrcn}, #{registSeCode}, - #{tmplatId}, #{useAt}, #{frstRegisterId}, SYSDATE(), #{bbsId}, #{blogAt}) - - </insert> - - <select id="selectBlogListPortlet" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogListPortlet"> - - SELECT - BLOG_ID, BBS_ID, BLOG_NM, FRST_REGIST_PNTTM - FROM - COMTNBLOG - WHERE USE_AT = 'Y' - ORDER BY FRST_REGIST_PNTTM DESC - - </select> - <select id="selectBBSListPortlet" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultMap="BBSListPortlet"> SELECT Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_mysql.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_mysql.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_mysql.xml (revision 30) @@ -437,62 +437,6 @@ </select> - <select id="selectLoginUser" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE - FRST_REGISTER_ID = #{frstRegisterId} - AND - BLOG_ID = #{blogId} - - </select> - - <select id="selectBlogListManager" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardBlogManager"> - - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM, C.USER_NM AS FRST_REGISTER_NM, - DATE_FORMAT(A.FRST_REGIST_PNTTM, '%Y-%m-%d') as FRST_REGIST_PNTTM, - A.USE_AT - FROM - COMTNBBSMASTER A - LEFT OUTER JOIN - COMTNBLOG B - ON A.BLOG_ID = B.BLOG_ID - LEFT OUTER JOIN - (SELECT ESNTL_ID, USER_ID, USER_NM FROM COMVNUSERMASTER) C - ON A.FRST_REGISTER_ID = C.ESNTL_ID - WHERE A.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE CONCAT ('%', #{searchWrd},'%') - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - - <select id="selectBlogListManagerCnt" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(1) - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE CONCAT ('%', #{searchWrd},'%') - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - <select id="selectArticleCnOne" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardCnOne"> SELECT @@ -514,19 +458,6 @@ </select> - <select id="selectBlogNmList" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardMasterList"> - - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - ORDER BY A.FRST_REGIST_PNTTM DESC - LIMIT 7 OFFSET 0 - - </select> - <select id="selectArticleDetailDefault" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardSubJectList"> SELECT Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_oracle.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_oracle.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_oracle.xml (revision 30) @@ -508,74 +508,6 @@ </select> - <select id="selectBlogNmList" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardMasterList"> - SELECT * FROM ( SELECT rownum rn, TB.* FROM ( - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - ORDER BY A.FRST_REGIST_PNTTM DESC - ) TB ) WHERE rn BETWEEN 1 AND 7 - </select> - - <select id="selectLoginUser" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE - FRST_REGISTER_ID = #{frstRegisterId} - AND - BLOG_ID = #{blogId} - - </select> - - <select id="selectBlogListManager" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardBlogManager"> - - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM, C.USER_NM AS FRST_REGISTER_NM, - TO_CHAR(a.FRST_REGIST_PNTTM, 'YYYY-MM-DD') as FRST_REGIST_PNTTM, - A.USE_AT - FROM - COMTNBBSMASTER A - LEFT OUTER JOIN - COMTNBLOG B - ON A.BLOG_ID = B.BLOG_ID - LEFT OUTER JOIN - (SELECT ESNTL_ID, USER_ID, USER_NM FROM COMVNUSERMASTER) C - ON A.FRST_REGISTER_ID = C.ESNTL_ID - WHERE A.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE '%' || #{searchWrd} || '%' - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE '%' || #{searchWrd} || '%' - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - - <select id="selectBlogListManagerCnt" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(1) - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE CONCAT ('%', #{searchWrd},'%') - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - <select id="selectArticleDetailDefaultCnt" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> SELECT Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_cubrid.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_cubrid.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_cubrid.xml (revision 30) @@ -203,113 +203,6 @@ </update> - <select id="selectBlogMasterList" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogList"> - SELECT * FROM ( SELECT rownum rn, TB.* FROM ( - SELECT - a.BLOG_ID, a.BLOG_NM, a.USE_AT, a.REGIST_SE_CODE, - c.CODE_NM as REGIST_SE_CODE_NM, - TO_CHAR(a.FRST_REGIST_PNTTM, 'YYYY-MM-DD') as FRST_REGIST_PNTTM, - a.FRST_REGISTER_ID, - b.USER_NM as FRST_REGISTER_NM, - a.BBS_ID, d.AUTHOR_CODE - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCnd == 0">AND - a.BLOG_NM LIKE '%' || #{searchWrd} || '%' - </if> - - ORDER BY a.FRST_REGIST_PNTTM DESC - ) TB ) WHERE rn BETWEEN #{firstIndex} + 1 AND #{firstIndex} + #{recordCountPerPage} - - </select> - - <select id="selectBlogMasterListTotCnt" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultType="java.lang.Integer"> - - SELECT - COUNT(*) - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCnd == 0">AND - a.BLOG_NM LIKE '%' || #{searchWrd} || '%' - </if> - - </select> - - <select id="selectBlogDetail" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogDetail"> - SELECT - BLOG_ID, BBS_ID, BLOG_NM, BLOG_INTRCN - FROM - COMTNBLOG - WHERE BLOG_ID = #{blogId} - </select> - - <select id="checkExistUser" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultType="java.lang.Integer"> - - SELECT COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <select id="checkExistUser2" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogUser"> - - SELECT - FRST_REGISTER_ID - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <insert id="insertBoardBlogUserRqst" parameterType="egovframework.com.cop.bbs.service.BlogUser"> - - INSERT INTO COMTNBLOGUSER - (BLOG_ID, EMPLYR_ID, MNGR_AT, SBSCRB_DE, - MBER_STTUS, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID) - VALUES (#{blogId}, #{emplyrId}, #{mngrAt}, SYSDATE, - #{mberSttus}, #{useAt}, SYSDATE, #{frstRegisterId}) - - </insert> - - <insert id="insertBlogMaster" parameterType="egovframework.com.cop.bbs.service.BlogVO"> - - INSERT INTO COMTNBLOG - (BLOG_ID, BLOG_NM, BLOG_INTRCN, REGIST_SE_CODE, - TMPLAT_ID, USE_AT, FRST_REGISTER_ID, FRST_REGIST_PNTTM, BBS_ID, BLOG_AT) - VALUES - (#{blogId}, #{blogNm}, #{blogIntrcn}, #{registSeCode}, - #{tmplatId}, #{useAt}, #{frstRegisterId}, SYSDATE, #{bbsId}, #{blogAt}) - - </insert> - - <select id="selectBlogListPortlet" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogListPortlet"> - - SELECT - BLOG_ID, BBS_ID, BLOG_NM, FRST_REGIST_PNTTM - FROM - COMTNBLOG - WHERE USE_AT = 'Y' - ORDER BY FRST_REGIST_PNTTM DESC - - </select> - <select id="selectBBSListPortlet" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultMap="BBSListPortlet"> SELECT Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_maria.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_maria.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_maria.xml (revision 30) @@ -437,62 +437,6 @@ </select> - <select id="selectLoginUser" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE - FRST_REGISTER_ID = #{frstRegisterId} - AND - BLOG_ID = #{blogId} - - </select> - - <select id="selectBlogListManager" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardBlogManager"> - - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM, C.USER_NM AS FRST_REGISTER_NM, - DATE_FORMAT(A.FRST_REGIST_PNTTM, '%Y-%m-%d') as FRST_REGIST_PNTTM, - A.USE_AT - FROM - COMTNBBSMASTER A - LEFT OUTER JOIN - COMTNBLOG B - ON A.BLOG_ID = B.BLOG_ID - LEFT OUTER JOIN - (SELECT ESNTL_ID, USER_ID, USER_NM FROM COMVNUSERMASTER) C - ON A.FRST_REGISTER_ID = C.ESNTL_ID - WHERE A.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE CONCAT ('%', #{searchWrd},'%') - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - - <select id="selectBlogListManagerCnt" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(1) - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE CONCAT ('%', #{searchWrd},'%') - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - <select id="selectArticleCnOne" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardCnOne"> SELECT @@ -514,19 +458,6 @@ </select> - <select id="selectBlogNmList" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardMasterList"> - - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - ORDER BY A.FRST_REGIST_PNTTM DESC - LIMIT 7 OFFSET 0 - - </select> - <select id="selectArticleDetailDefault" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardSubJectList"> SELECT Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_altibase.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_altibase.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_altibase.xml (revision 30) @@ -202,116 +202,6 @@ WHERE BBS_ID = #{bbsId} </update> - - <select id="selectBlogMasterList" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogList"> - SELECT * FROM ( SELECT rownum rn, TB.* FROM ( - SELECT - a.BLOG_ID, a.BLOG_NM, a.USE_AT, a.REGIST_SE_CODE, - c.CODE_NM as REGIST_SE_CODE_NM, - TO_CHAR(a.FRST_REGIST_PNTTM, 'YYYY-MM-DD') as FRST_REGIST_PNTTM, - a.FRST_REGISTER_ID, - b.USER_NM as FRST_REGISTER_NM, - a.BBS_ID, d.AUTHOR_CODE - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCnd == 0">AND - a.BLOG_NM LIKE '%' || #{searchWrd} || '%' - </if> - - ORDER BY a.FRST_REGIST_PNTTM DESC - ) TB ) WHERE rn BETWEEN #{firstIndex} + 1 AND #{firstIndex} + #{recordCountPerPage} - - </select> - - <select id="selectBlogMasterListTotCnt" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultType="java.lang.Integer"> - - SELECT - COUNT(*) - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCnd == 0">AND - a.BLOG_NM LIKE '%' || #{searchWrd} || '%' - </if> - - </select> - - <select id="selectBlogDetail" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogDetail"> - - SELECT - BLOG_ID, BBS_ID, BLOG_NM, BLOG_INTRCN - FROM - COMTNBLOG - WHERE BLOG_ID = #{blogId} - - </select> - - <select id="checkExistUser" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultType="java.lang.Integer"> - - SELECT - COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <select id="checkExistUser2" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogUser"> - - SELECT - FRST_REGISTER_ID - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <insert id="insertBoardBlogUserRqst" parameterType="egovframework.com.cop.bbs.service.BlogUser"> - - INSERT INTO COMTNBLOGUSER - (BLOG_ID, EMPLYR_ID, MNGR_AT, SBSCRB_DE, - MBER_STTUS, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID) - VALUES (#{blogId}, #{emplyrId}, #{mngrAt}, SYSDATE, - #{mberSttus}, #{useAt}, SYSDATE, #{frstRegisterId}) - - </insert> - - <insert id="insertBlogMaster" parameterType="egovframework.com.cop.bbs.service.BlogVO"> - - INSERT INTO COMTNBLOG - (BLOG_ID, BLOG_NM, BLOG_INTRCN, REGIST_SE_CODE, - TMPLAT_ID, USE_AT, FRST_REGISTER_ID, FRST_REGIST_PNTTM, BBS_ID, BLOG_AT) - VALUES - (#{blogId}, #{blogNm}, #{blogIntrcn}, #{registSeCode}, - #{tmplatId}, #{useAt}, #{frstRegisterId}, SYSDATE, #{bbsId}, #{blogAt}) - - </insert> - - <select id="selectBlogListPortlet" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogListPortlet"> - - SELECT - BLOG_ID, BBS_ID, BLOG_NM, FRST_REGIST_PNTTM - FROM - COMTNBLOG - WHERE USE_AT = 'Y' - ORDER BY FRST_REGIST_PNTTM DESC - - </select> <select id="selectBBSListPortlet" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultMap="BBSListPortlet"> Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_maria.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_maria.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_maria.xml (revision 30) @@ -203,116 +203,6 @@ WHERE BBS_ID = #{bbsId} </update> - - <select id="selectBlogMasterList" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogList"> - - SELECT - a.BLOG_ID, a.BLOG_NM, a.USE_AT, a.REGIST_SE_CODE, - c.CODE_NM as REGIST_SE_CODE_NM, - DATE_FORMAT(a.FRST_REGIST_PNTTM, '%Y-%m-%d') as FRST_REGIST_PNTTM, - a.FRST_REGISTER_ID, - b.USER_NM as FRST_REGISTER_NM, - a.BBS_ID, d.AUTHOR_CODE - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCnd == 0">AND - a.BLOG_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - - ORDER BY a.FRST_REGIST_PNTTM DESC - LIMIT #{recordCountPerPage} OFFSET #{firstIndex} - - </select> - - <select id="selectBlogMasterListTotCnt" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultType="java.lang.Integer"> - - SELECT - COUNT(*) - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCnd == 0">AND - a.BLOG_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - - </select> - - <select id="selectBlogDetail" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogDetail"> - - SELECT - BLOG_ID, BBS_ID, BLOG_NM, BLOG_INTRCN - FROM - COMTNBLOG - WHERE BLOG_ID = #{blogId} - - </select> - - <select id="checkExistUser" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultType="java.lang.Integer"> - - SELECT - COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <select id="checkExistUser2" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogUser"> - - SELECT - FRST_REGISTER_ID - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <insert id="insertBoardBlogUserRqst" parameterType="egovframework.com.cop.bbs.service.BlogUser"> - - INSERT INTO COMTNBLOGUSER - (BLOG_ID, EMPLYR_ID, MNGR_AT, SBSCRB_DE, - MBER_STTUS, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID) - VALUES (#{blogId}, #{emplyrId}, #{mngrAt}, SYSDATE(), - #{mberSttus}, #{useAt}, SYSDATE(), #{frstRegisterId}) - - </insert> - - <insert id="insertBlogMaster" parameterType="egovframework.com.cop.bbs.service.BlogVO"> - - INSERT INTO COMTNBLOG - (BLOG_ID, BLOG_NM, BLOG_INTRCN, REGIST_SE_CODE, - TMPLAT_ID, USE_AT, FRST_REGISTER_ID, FRST_REGIST_PNTTM, BBS_ID, BLOG_AT) - VALUES - (#{blogId}, #{blogNm}, #{blogIntrcn}, #{registSeCode}, - #{tmplatId}, #{useAt}, #{frstRegisterId}, SYSDATE(), #{bbsId}, #{blogAt}) - - </insert> - - <select id="selectBlogListPortlet" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogListPortlet"> - - SELECT - BLOG_ID, BBS_ID, BLOG_NM, FRST_REGIST_PNTTM - FROM - COMTNBLOG - WHERE USE_AT = 'Y' - ORDER BY FRST_REGIST_PNTTM DESC - - </select> <select id="selectBBSListPortlet" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultMap="BBSListPortlet"> Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_tibero.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_tibero.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_tibero.xml (revision 30) @@ -202,113 +202,6 @@ WHERE BBS_ID = #{bbsId} </update> - - <select id="selectBlogMasterList" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogList"> - SELECT * FROM ( SELECT rownum rn, TB.* FROM ( - SELECT - a.BLOG_ID, a.BLOG_NM, a.USE_AT, a.REGIST_SE_CODE, - c.CODE_NM as REGIST_SE_CODE_NM, - TO_CHAR(a.FRST_REGIST_PNTTM, 'YYYY-MM-DD') as FRST_REGIST_PNTTM, - a.FRST_REGISTER_ID, - b.USER_NM as FRST_REGISTER_NM, - a.BBS_ID, d.AUTHOR_CODE - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCnd == 0">AND - a.BLOG_NM LIKE '%' || #{searchWrd} || '%' - </if> - - ORDER BY a.FRST_REGIST_PNTTM DESC - ) TB ) WHERE rn BETWEEN #{firstIndex} + 1 AND #{firstIndex} + #{recordCountPerPage} - - </select> - - <select id="selectBlogMasterListTotCnt" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultType="java.lang.Integer"> - - SELECT - COUNT(*) - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCnd == 0">AND - a.BLOG_NM LIKE '%' || #{searchWrd} || '%' - </if> - - </select> - - <select id="selectBlogDetail" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogDetail"> - SELECT - BLOG_ID, BBS_ID, BLOG_NM, BLOG_INTRCN - FROM - COMTNBLOG - WHERE BLOG_ID = #{blogId} - </select> - - <select id="checkExistUser" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultType="java.lang.Integer"> - - SELECT COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <select id="checkExistUser2" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogUser"> - - SELECT - FRST_REGISTER_ID - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <insert id="insertBoardBlogUserRqst" parameterType="egovframework.com.cop.bbs.service.BlogUser"> - - INSERT INTO COMTNBLOGUSER - (BLOG_ID, EMPLYR_ID, MNGR_AT, SBSCRB_DE, - MBER_STTUS, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID) - VALUES (#{blogId}, #{emplyrId}, #{mngrAt}, SYSDATE, - #{mberSttus}, #{useAt}, SYSDATE, #{frstRegisterId}) - - </insert> - - <insert id="insertBlogMaster" parameterType="egovframework.com.cop.bbs.service.BlogVO"> - - INSERT INTO COMTNBLOG - (BLOG_ID, BLOG_NM, BLOG_INTRCN, REGIST_SE_CODE, - TMPLAT_ID, USE_AT, FRST_REGISTER_ID, FRST_REGIST_PNTTM, BBS_ID, BLOG_AT) - VALUES - (#{blogId}, #{blogNm}, #{blogIntrcn}, #{registSeCode}, - #{tmplatId}, #{useAt}, #{frstRegisterId}, SYSDATE, #{bbsId}, #{blogAt}) - - </insert> - - <select id="selectBlogListPortlet" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogListPortlet"> - - SELECT - BLOG_ID, BBS_ID, BLOG_NM, FRST_REGIST_PNTTM - FROM - COMTNBLOG - WHERE USE_AT = 'Y' - ORDER BY FRST_REGIST_PNTTM DESC - - </select> <select id="selectBBSListPortlet" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultMap="BBSListPortlet"> Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_postgres.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_postgres.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_postgres.xml (revision 30) @@ -217,116 +217,6 @@ WHERE BBS_ID = #{bbsId} </update> - <select id="selectBlogMasterList" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogList"> - - SELECT - a.BLOG_ID, a.BLOG_NM, a.USE_AT, a.REGIST_SE_CODE, - c.CODE_NM as REGIST_SE_CODE_NM, - TO_CHAR(a.FRST_REGIST_PNTTM, 'YYYYmmdd') as FRST_REGIST_PNTTM, - a.FRST_REGISTER_ID, - b.USER_NM as FRST_REGISTER_NM, - a.BBS_ID, d.AUTHOR_CODE - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCondition == 0">AND - a.BLOG_NM LIKE CONCAT ('%', #{searchKeyword},'%') - </if> - - ORDER BY a.FRST_REGIST_PNTTM DESC - LIMIT #{recordCountPerPage} OFFSET #{firstIndex} - - </select> - - <select id="selectBlogMasterListTotCnt" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultType="java.lang.Integer"> - - SELECT - COUNT(*) - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCondition == 0">AND - a.BLOG_NM LIKE CONCAT ('%', #{searchKeyword},'%') - </if> - - </select> - - <select id="selectBlogDetail" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogDetail"> - - SELECT - BLOG_ID, BBS_ID, BLOG_NM, BLOG_INTRCN - FROM - COMTNBLOG - WHERE BLOG_ID = #{blogId} - - </select> - - <select id="checkExistUser" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultType="java.lang.Integer"> - - SELECT - COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <select id="checkExistUser2" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogUser"> - - SELECT - FRST_REGISTER_ID - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <insert id="insertBoardBlogUserRqst" parameterType="egovframework.com.cop.bbs.service.BlogUser"> - - INSERT INTO COMTNBLOGUSER - (BLOG_ID, EMPLYR_ID, MNGR_AT, SBSCRB_DE, - MBER_STTUS, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID) - VALUES (#{blogId}, #{emplyrId}, #{mngrAt}, NOW(), - #{mberSttus}, #{useAt}, NOW(), #{frstRegisterId}) - - </insert> - - <insert id="insertBlogMaster" parameterType="egovframework.com.cop.bbs.service.BlogVO"> - - INSERT INTO COMTNBLOG - (BLOG_ID, BLOG_NM, BLOG_INTRCN, REGIST_SE_CODE, - USE_AT, FRST_REGISTER_ID, FRST_REGIST_PNTTM, BBS_ID, BLOG_AT) - VALUES - (#{blogId}, #{blogNm}, #{blogIntrcn}, #{registSeCode}, - #{useAt}, #{frstRegisterId}, NOW(), #{bbsId}, #{blogAt}) - - </insert> - - <select id="selectBlogListPortlet" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogListPortlet"> - - SELECT - BLOG_ID, BBS_ID, BLOG_NM, FRST_REGIST_PNTTM - FROM - COMTNBLOG - WHERE USE_AT = 'Y' - ORDER BY FRST_REGIST_PNTTM DESC - - </select> - <select id="selectBBSListPortlet" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultMap="BBSListPortlet"> SELECT Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_cubrid.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_cubrid.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_cubrid.xml (revision 30) @@ -508,74 +508,6 @@ </select> - <select id="selectBlogNmList" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardMasterList"> - SELECT * FROM ( SELECT rownum rn, TB.* FROM ( - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - ORDER BY A.FRST_REGIST_PNTTM DESC - ) TB ) WHERE rn BETWEEN 1 AND 7 - </select> - - <select id="selectLoginUser" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE - FRST_REGISTER_ID = #{frstRegisterId} - AND - BLOG_ID = #{blogId} - - </select> - - <select id="selectBlogListManager" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardBlogManager"> - - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM, C.USER_NM AS FRST_REGISTER_NM, - TO_CHAR(a.FRST_REGIST_PNTTM, 'YYYY-MM-DD') as FRST_REGIST_PNTTM, - A.USE_AT - FROM - COMTNBBSMASTER A - LEFT OUTER JOIN - COMTNBLOG B - ON A.BLOG_ID = B.BLOG_ID - LEFT OUTER JOIN - (SELECT ESNTL_ID, USER_ID, USER_NM FROM COMVNUSERMASTER) C - ON A.FRST_REGISTER_ID = C.ESNTL_ID - WHERE A.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE '%' || #{searchWrd} || '%' - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE '%' || #{searchWrd} || '%' - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - - <select id="selectBlogListManagerCnt" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(1) - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE CONCAT ('%', #{searchWrd},'%') - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - <select id="selectArticleDetailDefaultCnt" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> SELECT Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_oracle.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_oracle.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovBBSMaster_SQL_oracle.xml (revision 30) @@ -203,113 +203,6 @@ </update> - <select id="selectBlogMasterList" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogList"> - SELECT * FROM ( SELECT rownum rn, TB.* FROM ( - SELECT - a.BLOG_ID, a.BLOG_NM, a.USE_AT, a.REGIST_SE_CODE, - c.CODE_NM as REGIST_SE_CODE_NM, - TO_CHAR(a.FRST_REGIST_PNTTM, 'YYYY-MM-DD') as FRST_REGIST_PNTTM, - a.FRST_REGISTER_ID, - b.USER_NM as FRST_REGISTER_NM, - a.BBS_ID, d.AUTHOR_CODE - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCnd == 0">AND - a.BLOG_NM LIKE '%' || #{searchWrd} || '%' - </if> - - ORDER BY a.FRST_REGIST_PNTTM DESC - ) TB ) WHERE rn BETWEEN #{firstIndex} + 1 AND #{firstIndex} + #{recordCountPerPage} - - </select> - - <select id="selectBlogMasterListTotCnt" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultType="java.lang.Integer"> - - SELECT - COUNT(*) - FROM - COMTNBLOG a - LEFT OUTER JOIN COMVNUSERMASTER b - ON a.FRST_REGISTER_ID = b.ESNTL_ID - LEFT OUTER JOIN COMTCCMMNDETAILCODE c - ON a.REGIST_SE_CODE = c.CODE - LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS d - ON a.FRST_REGISTER_ID = d.SCRTY_DTRMN_TRGET_ID - WHERE c.CODE_ID = 'COM001' - - <if test="searchCnd == 0">AND - a.BLOG_NM LIKE '%' || #{searchWrd} || '%' - </if> - - </select> - - <select id="selectBlogDetail" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogDetail"> - SELECT - BLOG_ID, BBS_ID, BLOG_NM, BLOG_INTRCN - FROM - COMTNBLOG - WHERE BLOG_ID = #{blogId} - </select> - - <select id="checkExistUser" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultType="java.lang.Integer"> - - SELECT COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <select id="checkExistUser2" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="selectBlogUser"> - - SELECT - FRST_REGISTER_ID - FROM - COMTNBLOG - WHERE FRST_REGISTER_ID = #{frstRegisterId} - - </select> - - <insert id="insertBoardBlogUserRqst" parameterType="egovframework.com.cop.bbs.service.BlogUser"> - - INSERT INTO COMTNBLOGUSER - (BLOG_ID, EMPLYR_ID, MNGR_AT, SBSCRB_DE, - MBER_STTUS, USE_AT, FRST_REGIST_PNTTM, FRST_REGISTER_ID) - VALUES (#{blogId}, #{emplyrId}, #{mngrAt}, SYSDATE, - #{mberSttus}, #{useAt}, SYSDATE, #{frstRegisterId}) - - </insert> - - <insert id="insertBlogMaster" parameterType="egovframework.com.cop.bbs.service.BlogVO"> - - INSERT INTO COMTNBLOG - (BLOG_ID, BLOG_NM, BLOG_INTRCN, REGIST_SE_CODE, - TMPLAT_ID, USE_AT, FRST_REGISTER_ID, FRST_REGIST_PNTTM, BBS_ID, BLOG_AT) - VALUES - (#{blogId}, #{blogNm}, #{blogIntrcn}, #{registSeCode}, - #{tmplatId}, #{useAt}, #{frstRegisterId}, SYSDATE, #{bbsId}, #{blogAt}) - - </insert> - - <select id="selectBlogListPortlet" parameterType="egovframework.com.cop.bbs.service.BlogVO" resultMap="BlogListPortlet"> - - SELECT - BLOG_ID, BBS_ID, BLOG_NM, FRST_REGIST_PNTTM - FROM - COMTNBLOG - WHERE USE_AT = 'Y' - ORDER BY FRST_REGIST_PNTTM DESC - - </select> - <select id="selectBBSListPortlet" parameterType="egovframework.com.cop.bbs.service.BoardMasterVO" resultMap="BBSListPortlet"> SELECT Index: base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_altibase.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_altibase.xml (revision 29) +++ base3.10/src/main/resources/egovframework/mapper/com/cop/bbs/EgovArticle_SQL_altibase.xml (revision 30) @@ -442,62 +442,6 @@ </select> - <select id="selectLoginUser" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(FRST_REGISTER_ID) - FROM - COMTNBLOG - WHERE - FRST_REGISTER_ID = #{frstRegisterId} - AND - BLOG_ID = #{blogId} - - </select> - - <select id="selectBlogListManager" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardBlogManager"> - - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM, C.USER_NM AS FRST_REGISTER_NM, - DATE_FORMAT(A.FRST_REGIST_PNTTM, '%Y-%m-%d') as FRST_REGIST_PNTTM, - A.USE_AT - FROM - COMTNBBSMASTER A - LEFT OUTER JOIN - COMTNBLOG B - ON A.BLOG_ID = B.BLOG_ID - LEFT OUTER JOIN - (SELECT ESNTL_ID, USER_ID, USER_NM FROM COMVNUSERMASTER) C - ON A.FRST_REGISTER_ID = C.ESNTL_ID - WHERE A.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE CONCAT ('%', #{searchWrd},'%') - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - - <select id="selectBlogListManagerCnt" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultType="java.lang.Integer"> - - SELECT - COUNT(1) - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - <if test="searchCnd == 0">AND - A.BBS_NM LIKE CONCAT ('%', #{searchWrd},'%') - </if> - <if test="searchCnd == 1">AND - A.BBS_INTRCN LIKE CONCAT ('%', #{searchWrd},'%') - </if> - ORDER BY A.FRST_REGIST_PNTTM DESC - - </select> - <select id="selectArticleCnOne" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardCnOne"> SELECT @@ -519,19 +463,6 @@ </select> - <select id="selectBlogNmList" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardMasterList"> - SELECT * FROM ( SELECT rownum rn, TB.* FROM ( - SELECT - A.BBS_ID, A.BLOG_ID, A.BBS_NM - FROM - COMTNBBSMASTER A, COMTNBLOG B - WHERE A.BLOG_ID = B.BLOG_ID - AND B.BLOG_ID = #{blogId} - ORDER BY A.FRST_REGIST_PNTTM DESC - ) TB ) WHERE rn BETWEEN 1 AND 7 - - </select> - <select id="selectArticleDetailDefault" parameterType="egovframework.com.cop.bbs.service.BoardVO" resultMap="boardSubJectList"> SELECT * FROM ( SELECT rownum rn, TB.* FROM ( SELECT Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovBlogList.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovBlogList.jsp (revision 29) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovBlogList.jsp (nonexistent) @@ -1,164 +0,0 @@ -<% - /** - * @Class Name : EgovBlogMasterList.jsp - * @Description : EgovBlogMasterList 화면 - * @Modification Information - * @ - * @ 수정일 수정자 수정내용 - * @ ------- -------- --------------------------- - * @ 2009.02.01 박정규 최초 생성 - * 2016.06.13 김연호 표준프레임워크 v3.6 개선 - * @author 공통서비스팀 - * @since 2009.02.01 - * @version 1.0 - * @see - * - */ -%> -<%@ page language="java" contentType="text/html; charset=UTF-8" %> -<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> -<%@ taglib prefix="ui" uri="http://egovframework.gov/ctl/ui"%> -<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> -<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> -<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %> -<c:set var="pageTitle"><spring:message code="comCopBlog.blogMasterVO.title"/></c:set> -<!DOCTYPE html> -<html> -<head> -<title>${pageTitle} <spring:message code="title.list" /></title> -<meta http-equiv="content-type" content="text/html; charset=utf-8"> -<script src="<c:url value='/js/egovframework/com/cmm/jquery-1.12.4.min.js' />"></script> -<link type="text/css" rel="stylesheet" href="<c:url value='/css/egovframework/com/com.css' />"> -<script type="text/javascript"> -/********************************************************* - * 초기화 - ******************************************************** */ -function fn_egov_init(){ - // 첫 입력란에 포커스.. - document.BlogMasterForm.searchCnd.focus(); -} - -/********************************************************* - * 페이징 처리 함수 - ******************************************************** */ -function fn_egov_select_linkPage(pageNo){ - document.BlogMasterForm.pageIndex.value = pageNo; - document.BlogMasterForm.action = "<c:url value='/cop/bbs/selectBlogMasterList.do'/>"; - document.BlogMasterForm.submit(); -} -/********************************************************* - * 조회 처리 함수 - ******************************************************** */ -function fn_egov_search_blog(){ - document.BlogMasterForm.pageIndex.value = 1; - document.BlogMasterForm.submit(); -} - -function fn_insert_Blog() { - document.BlogMasterForm.action = "<c:url value='/cop/bbs/insertBlogMasterView.do'/>"; - document.BlogMasterForm.submit(); -} - -function fn_userChk(userId) { - $.ajax({ - url :"<c:url value='/cop/bbs/selectChkBloguser.do'/>" - ,type: "POST" - ,dataType: 'json' - ,success : function(data){ - if(data['userChk'] == "EXIST") { - alert("블로그가 이미 생성되어 있습니다.\n하나의 계정으로 하나의 블로그만 생성 가능합니다.") - }else{ - fn_insert_Blog(); - } - } - ,error: function(){ - alert("장애가 발생했습니다. 관리자에게 문의 하세요."); - } - }); -} - -</script> -</head> -<body onload="fn_egov_init()"> - -<noscript class="noScriptTitle"><spring:message code="common.noScriptTitle.msg" /></noscript> - -<form name="BlogMasterForm" action="<c:url value='/cop/bbs/selectBlogList.do'/>" method="post" onSubmit="fn_egov_search_blog(); return false;"> -<div class="board"> - <h1>${pageTitle} <spring:message code="title.list" /></h1> -  - <div class="search_box" title="<spring:message code="common.searchCondition.msg" />"> - <ul> - <li> - <select name="searchCnd" title="<spring:message code="title.searchCondition" /> <spring:message code="input.cSelect" />"> - <option value="0" <c:if test="${searchVO.searchCnd == '0'}">selected="selected"</c:if> ><spring:message code="comCopBlog.blogMasterVO.list.blogNm" /></option> - </select> - </li> -  - <li> - <input class="s_input" name="searchWrd" type="text" size="35" title="<spring:message code="title.search" /> <spring:message code="input.input" />" value='<c:out value="${searchVO.searchWrd}"/>' maxlength="155" > - <input type="submit" class="s_btn" value="<spring:message code="button.inquire" />" title="<spring:message code="title.inquire" /> <spring:message code="input.button" />" /> - <span class="btn_b"><a href="#" onClick="fn_userChk('<c:out value="${searchVO.frstRegisterId}"/>')" title="<spring:message code="button.create" /> <spring:message code="input.button" />"><spring:message code="button.create" /></a></span> - </li> - </ul> - </div> - -  - <table class="board_list" summary="<spring:message code="common.summary.list" arguments="${pageTitle}" />"> - <caption>${pageTitle}<spring:message code="title.list" /></caption> - <colgroup> - <col style="width: 9%;"> - <col style="width: 40%;"> - <col style="width: 13%;"> - <col style="width: 13%;"> - <col style="width: 13%;"> - </colgroup> - <thead> - <tr> - <th><spring:message code="table.num" /></th> - <th class="board_th_link"><spring:message code="comCopBlog.blogMasterVO.list.blogNm" /></th> - <th><spring:message code="table.reger" /></th> - <th><spring:message code="table.regdate" /></th> - <th><spring:message code="comCopBlog.blogMasterVO.list.useAt" /></th> - </tr> - </thead> - <tbody class="ov"> - <c:if test="${fn:length(resultList) == 0}"> - <tr> - <td colspan="5"><spring:message code="common.nodata.msg" /></td> - </tr> - </c:if> - <c:forEach items="${resultList}" var="resultInfo" varStatus="status"> - <tr> - <td><c:out value="${(searchVO.pageIndex-1) * searchVO.pageSize + status.count}"/></td> - <td class="left"><a href="<c:url value='/cop/bbs/selectArticleBlogList.do'/>?blogId=${resultInfo.blogId}&bbsId=${resultInfo.bbsId}"><c:out value='${fn:substring(resultInfo.blogNm, 0, 40)}'/></a></td> - <td><c:out value='${resultInfo.frstRegisterNm}'/></td> - <td><c:out value='${resultInfo.frstRegisterPnttm}'/></td> - <td><c:out value='${resultInfo.useAt}'/></td> - </tr> - </c:forEach> - </tbody> - </table> - -  - <div class="pagination"> - <ul> - <ui:pagination paginationInfo="${paginationInfo}" type="image" jsFunction="fn_egov_select_linkPage"/> - </ul> - </div> - -  -  - -</div> - -<input name="blogId" type="hidden" value=""> -<input name="pageIndex" type="hidden" value="<c:out value='${searchVO.pageIndex}'/>"> -</form> - -</body> -</html> \ No newline at end of file Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovArticleBlogDetail.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovArticleBlogDetail.jsp (revision 29) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovArticleBlogDetail.jsp (nonexistent) @@ -1,217 +0,0 @@ -<% - /** - * @Class Name : EgovArticleDetail.jsp - * @Description : EgovArticleDetail 화면 - * @Modification Information - * @ - * @ 수정일 수정자 수정내용 - * @ ------- -------- --------------------------- - * @ 2009.02.01 박정규 최초 생성 - * 2016.06.13 김연호 표준프레임워크 v3.6 개선 - 2017.09.06 양희훈 표준프레임워크 v3.7 개선 - * @author 공통서비스팀 - * @since 2009.02.01 - * @version 1.0 - * @see - * - */ -%> -<%@ page language="java" contentType="text/html; charset=UTF-8" %> -<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> -<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> -<%@ taglib prefix="ui" uri="http://egovframework.gov/ctl/ui" %> -<%@ taglib prefix="spring" uri="http://www.springframework.org/tags"%> -<%@ taglib prefix="validator" uri="http://www.springmodules.org/tags/commons-validator" %> -<%pageContext.setAttribute("crlf", "\r\n"); %> -<c:set var="pageTitle"><spring:message code="comCopBbs.articleVO.title"/></c:set> -<!DOCTYPE html> -<html> -<head> -<title>${pageTitle} <spring:message code="title.detail" /></title> -<meta http-equiv="content-type" content="text/html; charset=utf-8"> -<link type="text/css" rel="stylesheet" href="<c:url value='/css/egovframework/com/com.css' />"> -<script type="text/javascript"> -/* ******************************************************** - * 삭제처리 - ******************************************************** */ - function fn_egov_delete_article(form){ - if(confirm("<spring:message code="common.delete.msg" />")){ - // Delete하기 위한 키값을 셋팅 - form.submit(); - } -} - -/* ******************************************************** - * 답글작성 - ******************************************************** */ - function fn_egov_reply_article() { - document.articleForm.action = "<c:url value='/cop/bbs/replyArticleView.do'/>"; - document.articleForm.submit(); - } - -</script> - -<script type="text/javascript" src="<c:url value="/validator.do"/>"></script> -<validator:javascript formName="articleCommentVO" staticJavascript="false" xhtml="true" cdata="false"/> -<script type="text/javascript"> -function fn_egov_insert_commentList() { - - var form = document.getElementById("articleCommentVO"); - - if (!validateArticleCommentVO(form)){ - return; - } - if (confirm('<spring:message code="common.regist.msg" />')) { - form.submit(); - } -} - -function fn_egov_updt_commentList() { - - var form = document.getElementById("articleCommentVO"); - - if (!validateArticleCommentVO(form)){ - return; - } - - if (confirm('<spring:message code="common.update.msg" />')) { - form.modified.value = "true"; - form.action = "<c:url value='/cop/cmt/updateArticleComment.do'/>"; - form.submit(); - } -} - -function fn_egov_selectCommentForupdt(commentNo) { - - var form = document.getElementById("articleCommentVO"); - - form.commentNo.value = commentNo; - form.action = "<c:url value='/cop/bbs/selectArticleDetail.do'/>"; - form.submit(); -} - -function fn_egov_deleteCommentList(commentNo) { - - var form = document.getElementById("articleCommentVO"); - - if (confirm('<spring:message code="common.delete.msg" />')) { - form.modified.value = "true"; - form.commentNo.value = commentNo; - form.action = "<c:url value='/cop/cmt/deleteArticleComment.do'/>"; - form.submit(); - } -} - -/* 댓글페이징 */ -function fn_egov_select_commentList(pageNo) { - - var form = document.getElementById("articleCommentVO"); - - form.subPageIndex.value = pageNo; - form.commentNo.value = ''; - form.action = "<c:url value='/cop/bbs/selectArticleDetail.do'/>"; - form.submit(); -} -</script> -</head> -<body> - -<noscript class="noScriptTitle"><spring:message code="common.noScriptTitle.msg" /></noscript> - -<div class="wTableFrm"> -  - <%-- <h2>${pageTitle} <spring:message code="title.detail" /></h2> --%> - -  - <table class="" summary="<spring:message code="common.summary.inqire" arguments="${pageTitle}" />"> - <caption>${pageTitle} <spring:message code="title.detail" /></caption> - <colgroup> - <col style="width: ;"> - <col style="width: ;"> - <col style="width: ;"> - <col style="width: ;"> - <col style="width: ;"> - <col style="width: ;"> - </colgroup> - <tbody> -  - <div class="blog_title"> - <h5><c:out value="${result.nttSj}"/></h5> - <span><a href="">맛스타그램</a></span> - <p>2017.08.22 10:23</p> - </div> -  - <c:if test="${result.nttSj == null}"> - <tr> - <td colspan="5"><spring:message code="common.nodata.msg" /></td> - </tr> - </c:if> - <tr> - <%-- <th class="vtop"><spring:message code="comCopBbs.articleVO.detail.nttCn" /></th> --%> - <td colspan="5" class="cnt"> - <c:out value="${fn:replace(result.nttCn , crlf , '<br/>')}" escapeXml="false" /> - </td> - </tr> -  - <c:if test="${not empty result.atchFileId}"> - <tr> - <th><spring:message code="comCopBbs.articleVO.detail.atchFile" /></th> - <td colspan="5"> - <c:import url="/cmm/fms/selectFileInfs.do" charEncoding="utf-8"> - <c:param name="param_atchFileId" value="${result.atchFileId}" /> - </c:import> - </td> - </tr> - </c:if> - - </tbody> - </table> -  - <div class="btn"> - <c:if test="${result.ntcrId != 'anonymous'}"> -  - <form name="articleForm" action="<c:url value='/cop/bbs/updateArticleView.do'/>" method="post" style="float:left;"> - <input type="submit" class="s_submit" value="<spring:message code="button.update" />" title="<spring:message code="title.update" /> <spring:message code="input.button" />" /> - <input type="hidden" name="parnts" value="<c:out value='${result.parnts}'/>" > - <input type="hidden" name="sortOrdr" value="<c:out value='${result.sortOrdr}'/>" > - <input type="hidden" name="replyLc" value="<c:out value='${result.replyLc}'/>" > - <input type="hidden" name="nttSj" value="<c:out value='${result.nttSj}'/>" > - <input name="nttId" type="hidden" value="<c:out value="${result.nttId}" />"> - <input name="bbsId" type="hidden" value="<c:out value="${boardMasterVO.bbsId}" />"> - <input name="blogAt" type="hidden" value="chkBlog"> - </form> - <form name="formDelete" action="<c:url value='/cop/bbs/deleteArticle.do'/>" method="post" style="float:left; margin:0 0 0 3px;"> - <input type="submit" class="s_submit" value="<spring:message code="button.delete" />" title="<spring:message code="button.delete" /> <spring:message code="input.button" />" onclick="fn_egov_delete_article(this.form); return false;"> - <input name="nttId" type="hidden" value="<c:out value="${result.nttId}" />"> - <input name="bbsId" type="hidden" value="<c:out value="${boardMasterVO.bbsId}" />"> - <input name="blogAt" type="hidden" value="chkBlog"> - </form> - </c:if> - <c:if test="${boardMasterVO.replyPosblAt == 'Y' }"> - <form name="formReply" action="<c:url value='/cop/bbs/replyArticleView.do'/>" method="post" style="float:left; margin:0 0 0 3px;"> - <input type="submit" class="s_submit" value="<spring:message code="button.reply" />"> - <input name="nttId" type="hidden" value="<c:out value="${result.nttId}" />"> - <input name="bbsId" type="hidden" value="<c:out value="${boardMasterVO.bbsId}" />"> - </form> - </c:if> - <form name="formList" action="<c:url value='/cop/bbs/selectArticleBlogList.do'/>" method="post" style="float:left; margin:0 0 0 3px;"> - <input type="submit" class="s_submit" value="<spring:message code="button.list" />"> - <input name="bbsId" type="hidden" value="<c:out value="${boardMasterVO.bbsId}" />"> - <input name="nttId" type="hidden" value="<c:out value="${result.nttId}" />"> - </form> - <form name="formScrap" action="<c:url value='/cop/scp/insertArticleScrapView.do'/>" method="post" style="float:left; margin:0 0 0 3px;"> - <input type="submit" class="s_submit" value="<spring:message code="button.scrap" />"> - <input name="nttId" type="hidden" value="<c:out value="${result.nttId}" />"> - <input name="bbsId" type="hidden" value="<c:out value="${boardMasterVO.bbsId}" />"> - </form> - - </div><div style="clear:both;"></div> - -</div> - - -<c:import url="/cop/cmt/selectArticleCommentList.do" charEncoding="utf-8"> -</c:import> - -</body> -</html> Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovBlogRegist.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovBlogRegist.jsp (revision 29) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovBlogRegist.jsp (nonexistent) @@ -1,137 +0,0 @@ -<% - /** - * @Class Name : EgovBlogMasterRegist.jsp - * @Description : EgovBlogMasterRegist 화면 - * @Modification Information - * @ - * @ 수정일 수정자 수정내용 - * @ ------- -------- --------------------------- - * @ 2009.02.01 박정규 최초 생성 - * 2016.06.13 김연호 표준프레임워크 v3.6 개선 - * - * @author 공통서비스팀 - * @since 2009.02.01 - * @version 1.0 - * @see - * - */ -%> -<%@ page language="java" contentType="text/html; charset=UTF-8" %> -<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> -<%@ taglib prefix="ui" uri="http://egovframework.gov/ctl/ui" %> -<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> -<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> -<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %> -<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %> -<%@ taglib prefix="validator" uri="http://www.springmodules.org/tags/commons-validator" %> -<c:set var="pageTitle"><spring:message code="comCopBlog.blogMasterVO.title"/></c:set> -<!DOCTYPE html> -<html> -<head> -<title>${pageTitle} <spring:message code="title.create" /></title> -<meta http-equiv="content-type" content="text/html; charset=utf-8"> -<link type="text/css" rel="stylesheet" href="<c:url value='/css/egovframework/com/com.css' />"> -<script type="text/javascript" src="<c:url value="/validator.do"/>"></script> -<validator:javascript formName="blogMasterVO" staticJavascript="false" xhtml="true" cdata="false"/> -<script type="text/javascript"> -/* ******************************************************** - * 초기화 - ******************************************************** */ -function fn_egov_init(){ - - // 첫 입력란에 포커스 - document.getElementById("blogMasterVO").blogNm.focus(); - -} -/* ******************************************************** - * 저장처리화면 - ******************************************************** */ -function fn_egov_regist_blog(form){ - //input item Client-Side validate - if (!validateBlogMasterVO(form)) { - return false; - } else { - if(confirm("<spring:message code="common.regist.msg" />")){ - form.submit(); - } - } -} - -/* ******************************************************** -* 서버 처리 후 메세지 화면에 보여주기 -******************************************************** */ -function fncShowMessg(){ - if("<c:out value='${message}'/>" != ''){ - alert("<c:out value='${message}'/>"); - } -} -</script> - -</head> -<body onLoad="fn_egov_init(); fncShowMessg();"> - - -<noscript class="noScriptTitle"><spring:message code="common.noScriptTitle.msg" /></noscript> - -<form:form commandName="blogMasterVO" action="${pageContext.request.contextPath}/cop/bbs/insertBlogMaster.do" method="post" onSubmit="fn_egov_regist_blog(document.forms[0]); return false;"> -<div class="wTableFrm"> -  - <h2>${pageTitle} <spring:message code="title.create" /></h2> - -  - <table class="wTable" summary="<spring:message code="common.summary.list" arguments="${pageTitle}" />"> - <caption>${pageTitle } <spring:message code="title.create" /></caption> - <colgroup> - <col style="width: 20%;"><col style="width: ;"> - </colgroup> - <tbody> -  - <c:set var="inputTxt"><spring:message code="input.input" /></c:set> -  - <c:set var="title"><spring:message code="comCopBlog.blogMasterVO.regist.blogNm"/> </c:set> - <tr> - <th><label for="blogNm">${title} <span class="pilsu">*</span></label></th> - <td class="left"> - <form:input path="blogNm" title="${title} ${inputTxt}" size="70" maxlength="70" /> - <div><form:errors path="blogNm" cssClass="error" /></div> - </td> - </tr> -  - <c:set var="title"><spring:message code="comCopBlog.blogMasterVO.regist.blogIntrcn"/> </c:set> - <tr> - <th><label for="blogIntrcn">${title } <span class="pilsu">*</span></label></th> - <td class="nopd"> - <form:textarea path="blogIntrcn" title="${title} ${inputTxt}" cols="300" rows="20" /> - <div><form:errors path="blogIntrcn" cssClass="error" /></div> - </td> - </tr> - -  - <c:set var="title"><spring:message code="comCopBlog.blogMasterVO.regist.useAt"/> </c:set> - <tr> - <th><label for="useAt">${title } <span class="pilsu">*</span></label></th> - <td class="left"> - <form:select path="useAt" title="${title} ${inputTxt }" cssClass="txt"> - <form:option value="Y" label="예" /> - <form:option value='N'>아니오</form:option> - </form:select> - <div><form:errors path="useAt" cssClass="error" /></div> - </td> - </tr> - - </tbody> - </table> - -  - <div class="btn"> - <input type="submit" class="s_submit" value="<spring:message code="button.create" />" title="<spring:message code="button.create" /> <spring:message code="input.button" />" /> - <span class="btn_s"><a href="<c:url value='/cop/bbs/selectBlogList.do' />" title="<spring:message code="button.list" /> <spring:message code="input.button" />"><spring:message code="button.list" /></a></span> - </div><div style="clear:both;"></div> - -</div> - -<input name="cmd" type="hidden" value="<c:out value='save'/>"> -</form:form> - -</body> -</html> Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovBlogListManager.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovBlogListManager.jsp (revision 29) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovBlogListManager.jsp (nonexistent) @@ -1,132 +0,0 @@ -<% - /** - * @Class Name : EgovBlogMasterList.jsp - * @Description : EgovBlogMasterList 화면 - * @Modification Information - * @ - * @ 수정일 수정자 수정내용 - * @ ------- -------- --------------------------- - * @ 2009.02.01 박정규 최초 생성 - * 2016.06.13 김연호 표준프레임워크 v3.6 개선 - * @author 공통서비스팀 - * @since 2009.02.01 - * @version 1.0 - * @see - * - */ -%> -<%@ page language="java" contentType="text/html; charset=UTF-8" %> -<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> -<%@ taglib prefix="ui" uri="http://egovframework.gov/ctl/ui"%> -<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> -<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> -<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %> -<c:set var="pageTitle"><spring:message code="comCopBlog.blogMasterVO.title"/></c:set> -<!DOCTYPE html> -<html> -<head> -<title>${pageTitle} <spring:message code="title.list" /></title> -<meta http-equiv="content-type" content="text/html; charset=utf-8"> -<script src="<c:url value='/js/egovframework/com/cmm/jquery-1.12.4.min.js' />"></script> -<link type="text/css" rel="stylesheet" href="<c:url value='/css/egovframework/com/com.css' />"> -<script type="text/javascript"> -/********************************************************* - * 초기화 - ******************************************************** */ -function fn_egov_init(){ - // 첫 입력란에 포커스.. - document.BlogMasterForm.searchCnd.focus(); -} - -/********************************************************* - * 페이징 처리 함수 - ******************************************************** */ -function fn_egov_select_linkPage(pageNo){ - document.BlogMasterForm.pageIndex.value = pageNo; - document.BlogMasterForm.action = "<c:url value='/cop/bbs/selectBlogMasterList.do'/>"; - document.BlogMasterForm.submit(); -} -/********************************************************* - * 조회 처리 함수 - ******************************************************** */ -function fn_egov_search_blog(){ - document.BlogMasterForm.pageIndex.value = 1; - document.BlogMasterForm.submit(); -} - -</script> -</head> -<body> - -<noscript class="noScriptTitle"><spring:message code="common.noScriptTitle.msg" /></noscript> - -<form name="BlogMasterForm" action="<c:url value='/cop/bbs/selectBlogListManager.do' />" method="post" onSubmit="fn_egov_search_blog(); return false;"> -<div class="board"> - <h1>${pageTitle} <spring:message code="title.list" /></h1> -  - <div class="search_box" title="<spring:message code="common.searchCondition.msg" />"> - <ul> - <li> - <select name="searchCnd" title="<spring:message code="title.searchCondition" /> <spring:message code="input.cSelect" />"> - <option value="0" <c:if test="${searchVO.searchCnd == '0'}">selected="selected"</c:if> ><spring:message code="comCopBlog.blogMasterVO.list.blogNm" /></option> - </select> - </li> -  - <li> - <input class="s_input" name="searchWrd" type="text" size="35" title="<spring:message code="title.search" /> <spring:message code="input.input" />" value='<c:out value="${searchVO.searchWrd}"/>' maxlength="155" > - <input type="submit" class="s_btn" value="<spring:message code="button.inquire" />" title="<spring:message code="title.inquire" /> <spring:message code="input.button" />" /> - </li> - </ul> - </div> - -  - <table class="board_list" summary="<spring:message code="common.summary.list" arguments="${pageTitle}" />"> - <caption>${pageTitle}<spring:message code="title.list" /></caption> - <colgroup> - <col style="width: 9%;"> - <col style="width: 40%;"> - <col style="width: 13%;"> - <col style="width: 13%;"> - <col style="width: 13%;"> - </colgroup> - <thead> - <tr> - <th><spring:message code="table.num" /></th> - <th class="board_th_link"><spring:message code="comCopBlog.blogMasterVO.list.blogNm" /></th> - <th><spring:message code="table.reger" /></th> - <th><spring:message code="table.regdate" /></th> - <th><spring:message code="comCopBlog.blogMasterVO.list.useAt" /></th> - </tr> - </thead> - <tbody class="ov"> - <c:if test="${fn:length(resultList) == 0}"> - <tr> - <td colspan="5"><spring:message code="common.nodata.msg" /></td> - </tr> - </c:if> - <c:forEach items="${resultList}" var="resultInfo" varStatus="status"> - <tr> - <td><c:out value="${(searchVO.pageIndex-1) * searchVO.pageSize + status.count}"/></td> - <td class="left"><a href="<c:url value='/cop/bbs/selectBBSMasterDetail.do'/>?bbsId=${resultInfo.bbsId}&blogId=${resultInfo.blogId}" return false;"><c:out value='${fn:substring(resultInfo.bbsNm, 0, 40)}'/></a></td> - <td><c:out value='${resultInfo.frstRegisterNm}'/></td> - <td><c:out value='${resultInfo.frstRegisterPnttm}'/></td> - <td><c:out value='${resultInfo.useAt}'/></td> - </tr> - </c:forEach> - </tbody> - </table> - -  - <div class="pagination"> - <ul> - <ui:pagination paginationInfo="${paginationInfo}" type="image" jsFunction="fn_egov_select_linkPage"/> - </ul> - </div> -</div> - -<input name="blogId" type="hidden" value="<c:out value='${searchVO.blogId}'/>"> -<input name="pageIndex" type="hidden" value="<c:out value='${searchVO.pageIndex}'/>"> -</form> - -</body> -</html> \ No newline at end of file Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovArticleBlogUpdt.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovArticleBlogUpdt.jsp (revision 29) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovArticleBlogUpdt.jsp (nonexistent) @@ -1,314 +0,0 @@ - -<% - /** - * @Class Name : EgovArticleUpdt.jsp - * @Description : EgovArticleUpdt 화면 - * @Modification Information - * @ - * @ 수정일 수정자 수정내용 - * @ ------- -------- --------------------------- - * @ 2009.02.01 박정규 최초 생성 - * 2016.06.13 김연호 표준프레임워크 v3.6 개선 - * @author 공통서비스팀 - * @since 2009.02.01 - * @version 1.0 - * @see - * - */ -%> -<%@ page language="java" contentType="text/html; charset=UTF-8"%> -<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> -<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%> -<%@ taglib prefix="spring" uri="http://www.springframework.org/tags"%> -<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form"%> -<%@ taglib prefix="validator" uri="http://www.springmodules.org/tags/commons-validator"%> -<%@ taglib prefix="ckeditor" uri="http://ckeditor.com" %> -<c:set var="pageTitle"> - <spring:message code="comCopBbs.articleVO.title" /> -</c:set> -<!DOCTYPE html> -<html> -<head> -<title>${pageTitle }<spring:message code="title.update" /></title> -<meta http-equiv="content-type" content="text/html; charset=utf-8"> -<link type="text/css" rel="stylesheet" href="<c:url value='/css/egovframework/com/com.css' />"> -<link type="text/css" rel="stylesheet" href="<c:url value='/css/egovframework/com/cmm/jqueryui.css' />"> -<%-- <script type="text/javascript" src="<c:url value='/js/egovframework/com/cmm/fms/EgovMultiFile.js'/>" ></script> --%> -<script type="text/javascript" src="<c:url value='/js/egovframework/com/cmm/fms/EgovMultiFiles.js'/>" ></script> -<script type="text/javascript" src="<c:url value='/js/egovframework/com/cmm/utl/EgovCmmUtl.js'/>" ></script> -<script type="text/javascript" src="<c:url value='/html/egovframework/com/cmm/utl/ckeditor/ckeditor.js?t=B37D54V'/>" ></script> -<script type="text/javascript" src="<c:url value="/validator.do"/>"></script> -<script src="<c:url value='/js/egovframework/com/cmm/jquery.js' />"></script> -<script src="<c:url value='/js/egovframework/com/cmm/jqueryui.js' />"></script> -<validator:javascript formName="articleVO" staticJavascript="false" xhtml="true" cdata="false" /> -<script type="text/javascript"> -$(function() { - $("#ntceBgnde").datepicker( - {dateFormat:'yy-mm-dd' - , showOn: 'button' - , buttonImage: '<c:url value='/images/egovframework/com/cmm/icon/bu_icon_carlendar.gif'/>' - , buttonImageOnly: true - - , showMonthAfterYear: true - , showOtherMonths: true - , selectOtherMonths: true - - , changeMonth: true // 월선택 select box 표시 (기본은 false) - , changeYear: true // 년선택 selectbox 표시 (기본은 false) - , showButtonPanel: true // 하단 today, done 버튼기능 추가 표시 (기본은 false) - }); - $("#ntceEndde").datepicker( - {dateFormat:'yy-mm-dd' - , showOn: 'button' - , buttonImage: '<c:url value='/images/egovframework/com/cmm/icon/bu_icon_carlendar.gif'/>' - , buttonImageOnly: true - - , showMonthAfterYear: true - , showOtherMonths: true - , selectOtherMonths: true - - , changeMonth: true // 월선택 select box 표시 (기본은 false) - , changeYear: true // 년선택 selectbox 표시 (기본은 false) - , showButtonPanel: true // 하단 today, done 버튼기능 추가 표시 (기본은 false) - }); -}); - - - -/* ******************************************************** - * 초기화 - ******************************************************** */ -function fn_egov_init() { - - var ckeditor_config = { - filebrowserImageUploadUrl: '${pageContext.request.contextPath}/utl/wed/insertImageCk.do', // 파일 업로드를 처리 할 경로 설정. - }; - - CKEDITOR.replace('nttCn',ckeditor_config); - - <c:if test="${boardMasterVO.fileAtchPosblAt == 'Y'}"> - - //------------------------------------------ - //------------------------- 첨부파일 수정 Start - //------------------------------------------- - var existFileNum = document.getElementById("articleVO").fileListCnt.value; - var maxFileNum = document.getElementById("articleVO").atchPosblFileNumber.value; - - if (existFileNum == "undefined" || existFileNum == null) { - existFileNum = 0; - } - if (maxFileNum == "undefined" || maxFileNum == null) { - maxFileNum = 0; - } - - var uploadableFileNum = maxFileNum - existFileNum; - if (uploadableFileNum < 1) { - uploadableFileNum = 1; - } - var multi_selector = new MultiSelector( document.getElementById( 'egovComFileList' ), uploadableFileNum, 'file_label'); - multi_selector.addElement( document.getElementById( 'egovfile_1' ) ); - fn_egov_multi_selector_update_setting(multi_selector); - //------------------------- 첨부파일 수정 End - </c:if> - - // 첫 입력란에 포커스.. - document.getElementById("articleVO").nttSj.focus(); -} -/* ******************************************************** - * 저장처리화면 - ******************************************************** */ -function fn_egov_updt_article(form) { - - CKEDITOR.instances.nttCn.updateElement(); - - if (!validateArticleVO(form)) { - return false; - } else { - - var validateForm = document.getElementById("articleVO"); - - //비밀글은 제목 진하게 할 수 없음. - //비밀글은 공지게시 불가. - if(validateForm.secretAt.checked) { - if(validateForm.sjBoldAt.checked) { - alert("<spring:message code="comCopBbs.articleVO.secretBold" />"); - return; - } - if(validateForm.noticeAt.checked) { - alert("<spring:message code="comCopBbs.articleVO.secretNotice" />"); - return; - } - } - - //게시기간 - var ntceBgnde = getRemoveFormat(validateForm.ntceBgnde.value); - var ntceEndde = getRemoveFormat(validateForm.ntceEndde.value); - - if(ntceBgnde == '' && ntceEndde != '') { - validateForm.ntceBgnde.value = '1900-01-01'; - } - if(ntceBgnde != '' && ntceEndde == '') { - validateForm.ntceEndde.value = '9999-12-31'; - } - if(ntceBgnde == '' && ntceEndde == '') { - validateForm.ntceBgnde.value = '1900-01-01'; - validateForm.ntceEndde.value = '9999-12-31'; - } - - ntceBgnde = getRemoveFormat(validateForm.ntceBgnde.value); - ntceEndde = getRemoveFormat(validateForm.ntceEndde.value); - - if(ntceBgnde > ntceEndde){ - alert("<spring:message code="comCopBbs.articleVO.ntceDeError" />"); - return; - } - - if (confirm("<spring:message code="common.update.msg" />")) { - form.submit(); - } - } -} -/* ******************************************************** - * 목록 으로 가기 - ******************************************************** */ -function fn_egov_inqire_articlelist() { - articleVO.action = "<c:url value='/cop/bbs/selectArticleList.do'/>"; - articleVO.submit(); -} - -</script> -</head> -<body onLoad="fn_egov_init();"> - -  - <noscript class="noScriptTitle"> <spring:message code="common.noScriptTitle.msg" /> </noscript> - -  - <form:form commandName="articleVO" action="${pageContext.request.contextPath}/cop/bbs/updateArticle.do" method="post" onSubmit="fn_egov_updt_article(document.forms[0]); return false;" enctype="multipart/form-data"> - <div class="wTableFrm"> - <h2>${pageTitle} <spring:message code="title.update" /></h2> - -  - <table class="wTable" summary="<spring:message code="common.summary.update" arguments="${pageTitle}" />"> - <caption>${pageTitle} <spring:message code="title.update" /></caption> - <colgroup> - <col style="width: 20%;"> - <col style="width:;"> - <col style="width:;"> - <col style="width:;"> - </colgroup> - <tbody> -  - <c:set var="inputTxt"><spring:message code="input.input" /></c:set> -  - <c:set var="title"><spring:message code="comCopBbs.articleVO.updt.nttSj" /></c:set> - <tr> - <th><label for="nttSj">${title}<span class="pilsu">*</span></label></th> - <td class="left"> - <form:input path="nttSj" title="${title} ${inputTxt }" size="70" maxlength="70" /> - <div> <form:errors path="nttSj" cssClass="error" /></div> - </td> - <c:set var="title"><spring:message code="comCopBbs.articleVO.updt.sjBoldAt" /></c:set> - <th><label for="sjBoldAt">${title}</label></th> - <td class="left"> - <form:checkbox path="sjBoldAt" value="Y" /> - <div> <form:errors path="sjBoldAt" cssClass="error" /></div> - </td> - </tr> - -  - <c:set var="title"><spring:message code="comCopBbs.articleVO.updt.nttCn" /></c:set> - <tr> - <th><label for="nttCn">${title}<span class="pilsu">*</span></label></th> - <td class="nopd" colspan="3"> - <form:textarea path="nttCn" title="${title} ${inputTxt}" cols="300" rows="20" /> - - <div> <form:errors path="nttCn" cssClass="error" /></div> - </td> - </tr> - -  - <c:set var="title"><spring:message code="comCopBbs.articleVO.updt.noticeAt" /></c:set> - <tr> - <th><label for="noticeAt">${title}</label></th> - <td class="left" colspan="3"> - <form:checkbox path="noticeAt" value="Y" /> - <div> <form:errors path="noticeAt" cssClass="error" /></div> - </td> - </tr> - -  - <c:set var="title"><spring:message code="comCopBbs.articleVO.updt.secretAt" /></c:set> - <tr> - <th><label for="secretAt">${title}</label></th> - <td class="left" colspan="3"> - <form:checkbox path="secretAt" value="Y" /> - <div> <form:errors path="secretAt" cssClass="error" /></div> - </td> - </tr> - -  - <c:set var="title"><spring:message code="comCopBbs.articleVO.updt.ntceDe"/> </c:set> - <tr> - <th><label for="ntceBgnde">${title}</label></th> - <td class="left" colspan="3"> - <form:input path="ntceBgnde" title="${title} ${inputTxt}" size="70" maxlength="70" style="width:70px;"/> -  ~ <form:input path="ntceEndde" title="${title} ${inputTxt}" size="70" maxlength="70" style="width:70px;"/> - <div><form:errors path="ntceBgnde" cssClass="error" /></div> - <div><form:errors path="ntceEndde" cssClass="error" /></div> - </td> - </tr> - - <c:if test="${boardMasterVO.fileAtchPosblAt == 'Y'}"> -  - <c:set var="title"><spring:message code="comUssIonNws.newsVO.atchFile"/></c:set> - <tr> - <th><label for="file_1">${title}</label> </th> - <td class="nopd" colspan="3"> -  - <c:if test="${not empty articleVO.atchFileId}"> - <c:import charEncoding="utf-8" url="/cmm/fms/selectFileInfsForUpdate.do" > - <c:param name="param_atchFileId" value="${articleVO.atchFileId}" /> - </c:import> - </c:if> - <c:if test="${articleVO.atchFileId == ''}"> - <input type="hidden" name="fileListCnt" value="0" /> - </c:if> -  - <div> - <div class="egov_file_box"> - <label for="egovfile_1" id="file_label"><spring:message code="title.attachedFileSelect" /></label> - <input type="file" name="file_1" id="egovfile_1" multiple> - </div> - <div id="egovComFileList"></div> - </div> -  - - </td> - </tr> - </tbody> - </table> - - </c:if> - -  - <div class="btn"> - <input type="submit" class="s_submit" value="<spring:message code="button.update" />" title="<spring:message code="button.update" /> <spring:message code="input.button" />" /> - <span class="btn_s"><a href="<c:url value='/cop/bbs/selectArticleBlogList.do' />?bbsId=${boardMasterVO.bbsId}" title="<spring:message code="button.list" /> <spring:message code="input.button" />"><spring:message code="button.list" /></a></span> - </div> - <div style="clear: both;"></div> - - </div> - - <input name="pageIndex" type="hidden" value="<c:out value='${searchVO.pageIndex}'/>" /> - <input type="hidden" name="bbsTyCode" value="<c:out value='${boardMasterVO.bbsTyCode}'/>" /> - <input type="hidden" name="replyPosblAt" value="<c:out value='${boardMasterVO.replyPosblAt}'/>" /> - <input type="hidden" name="fileAtchPosblAt" value="<c:out value='${boardMasterVO.fileAtchPosblAt}'/>" /> - <input type="hidden" name="atchPosblFileNumber" value="<c:out value='${boardMasterVO.atchPosblFileNumber}'/>" /> - <input type="hidden" name="atchPosblFileSize" value="<c:out value='${boardMasterVO.atchPosblFileSize}'/>" /> - <input name="nttId" type="hidden" value="${articleVO.nttId}"> - <input name="bbsId" type="hidden" value="${boardMasterVO.bbsId}"> - </form:form> - -</body> -</html> Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovArticleBlogReply.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovArticleBlogReply.jsp (revision 29) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovArticleBlogReply.jsp (nonexistent) @@ -1,274 +0,0 @@ -<% - /** - * @Class Name : EgovArticleReply.jsp - * @Description : EgovArticleReply 화면 - * @Modification Information - * @ - * @ 수정일 수정자 수정내용 - * @ ---------- -------- --------------------------- - * 2009.02.01 박정규 최초 생성 - * 2016.06.13 김연호 표준프레임워크 v3.6 개선 - * 2020.10.27 신용호 파일 업로드 수정 - * - * @author 공통서비스팀 - * @since 2009.02.01 - * @version 1.0 - * @see - * - */ -%> -<%@ page language="java" contentType="text/html; charset=UTF-8" %> -<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> -<%@ taglib prefix="ui" uri="http://egovframework.gov/ctl/ui" %> -<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> -<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> -<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %> -<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %> -<%@ taglib prefix="validator" uri="http://www.springmodules.org/tags/commons-validator" %> -<%@ taglib prefix="ckeditor" uri="http://ckeditor.com" %> -<c:set var="pageTitle"><spring:message code="comCopBbs.articleVO.title"/></c:set> -<!DOCTYPE html> -<html> -<head> -<title>${pageTitle} <spring:message code="title.create" /></title> -<meta http-equiv="content-type" content="text/html; charset=utf-8"> -<link type="text/css" rel="stylesheet" href="<c:url value='/css/egovframework/com/com.css' />"> -<link type="text/css" rel="stylesheet" href="<c:url value='/css/egovframework/com/cmm/jqueryui.css' />"> -<%-- <script type="text/javascript" src="<c:url value='/js/egovframework/com/cmm/fms/EgovMultiFile.js'/>" ></script> --%> -<script type="text/javascript" src="<c:url value='/js/egovframework/com/cmm/fms/EgovMultiFiles.js'/>" ></script> -<script type="text/javascript" src="<c:url value='/js/egovframework/com/cmm/utl/EgovCmmUtl.js'/>" ></script> -<script type="text/javascript" src="<c:url value="/validator.do"/>"></script> -<script src="<c:url value='/js/egovframework/com/cmm/jquery.js' />"></script> -<script src="<c:url value='/js/egovframework/com/cmm/jqueryui.js' />"></script> -<validator:javascript formName="articleVO" staticJavascript="false" xhtml="true" cdata="false"/> -<script type="text/javascript"> - -$(function() { - $("#ntceBgnde").datepicker( - {dateFormat:'yy-mm-dd' - , showOn: 'button' - , buttonImage: '<c:url value='/images/egovframework/com/cmm/icon/bu_icon_carlendar.gif'/>' - , buttonImageOnly: true - - , showMonthAfterYear: true - , showOtherMonths: true - , selectOtherMonths: true - - , changeMonth: true // 월선택 select box 표시 (기본은 false) - , changeYear: true // 년선택 selectbox 표시 (기본은 false) - , showButtonPanel: true // 하단 today, done 버튼기능 추가 표시 (기본은 false) - }); - $("#ntceEndde").datepicker( - {dateFormat:'yy-mm-dd' - , showOn: 'button' - , buttonImage: '<c:url value='/images/egovframework/com/cmm/icon/bu_icon_carlendar.gif'/>' - , buttonImageOnly: true - - , showMonthAfterYear: true - , showOtherMonths: true - , selectOtherMonths: true - - , changeMonth: true // 월선택 select box 표시 (기본은 false) - , changeYear: true // 년선택 selectbox 표시 (기본은 false) - , showButtonPanel: true // 하단 today, done 버튼기능 추가 표시 (기본은 false) - }); -}); - -/* ******************************************************** - * 초기화 - ******************************************************** */ -function fn_egov_init(){ - - // 첫 입력란에 포커스 - document.getElementById("articleVO").nttSj.focus(); - -} -/* ******************************************************** - * 답글저장처리화면 - ******************************************************** */ -function fn_egov_reply_article(form){ - - CKEDITOR.instances.nttCn.updateElement(); - - //input item Client-Side validate - if (!validateArticleVO(form)) { - return false; - } else { - - var validateForm = document.getElementById("articleVO"); - - - //익명글은 공지게시 불가. - if(validateForm.anonymousAt.checked) { - if(validateForm.noticeAt.checked) { - alert("<spring:message code="comCopBbs.articleVO.anonymousNotice" />"); - return; - } - } - - //게시기간 - var ntceBgnde = getRemoveFormat(validateForm.ntceBgnde.value); - var ntceEndde = getRemoveFormat(validateForm.ntceEndde.value); - - if(ntceBgnde == '' && ntceEndde != '') { - validateForm.ntceBgnde.value = '1900-01-01'; - } - if(ntceBgnde != '' && ntceEndde == '') { - validateForm.ntceEndde.value = '9999-12-31'; - } - if(ntceBgnde == '' && ntceEndde == '') { - validateForm.ntceBgnde.value = '1900-01-01'; - validateForm.ntceEndde.value = '9999-12-31'; - } - - ntceBgnde = getRemoveFormat(validateForm.ntceBgnde.value); - ntceEndde = getRemoveFormat(validateForm.ntceEndde.value); - - if(ntceBgnde > ntceEndde){ - alert("<spring:message code="comCopBbs.articleVO.ntceDeError" />"); - return; - } - - - - - if(confirm("<spring:message code="common.regist.msg" />")){ - form.submit(); - } - } -} -</script> - -</head> -<body onLoad="fn_egov_init();"> - - -<noscript class="noScriptTitle"><spring:message code="common.noScriptTitle.msg" /></noscript> - -<form:form commandName="articleVO" action="${pageContext.request.contextPath}/cop/bbs/replyArticle.do" method="post" onSubmit="fn_egov_reply_article(document.forms[0]); return false;" enctype="multipart/form-data"> -<div class="wTableFrm"> -  - <h2>${pageTitle} <spring:message code="title.create" /></h2> - -  - <table class="wTable" summary="<spring:message code="common.summary.list" arguments="${pageTitle}" />"> - <caption>${pageTitle } <spring:message code="title.create" /></caption> - <colgroup> - <col style="width: 20%;"> - <col style="width: ;"> - <col style="width: ;"> - <col style="width: ;"> - </colgroup> - <tbody> -  - <c:set var="inputTxt"><spring:message code="input.input" /></c:set> -  - <c:set var="title"><spring:message code="comCopBbs.articleVO.reply.nttSj"/> </c:set> - <tr> - <th><label for="nttSj">${title} <span class="pilsu">*</span></label></th> - <td class="left"> - <input name="nttSj" type="text" size="70" maxlength="70" title="${title} ${inputTxt}" value="RE: <c:out value='${result.nttSj}'/>"> - <div><form:errors path="nttSj" cssClass="error" /></div> - </td> - <c:set var="title"><spring:message code="comCopBbs.articleVO.reply.sjBoldAt"/> </c:set> - <th><label for="sjBoldAt">${title}</label></th> - <td class="left"> - <form:checkbox path="sjBoldAt" value="Y"/> - <div><form:errors path="sjBoldAt" cssClass="error" /></div> - </td> - </tr> -  - <c:set var="title"><spring:message code="comCopBbs.articleVO.reply.nttCn"/> </c:set> - <tr> - <th><label for="nttCn">${title } <span class="pilsu">*</span></label></th> - <td class="nopd" colspan="3"> - <form:textarea path="nttCn" title="${title} ${inputTxt}" cols="300" rows="20" /> - <ckeditor:replace replace="nttCn" basePath="${pageContext.request.contextPath}/html/egovframework/com/cmm/utl/ckeditor/" /> - <div><form:errors path="nttCn" cssClass="error" /></div> - </td> - </tr> - -  - <c:set var="title"><spring:message code="comCopBbs.articleVO.reply.noticeAt"/> </c:set> - <tr> - <th><label for="noticeAt">${title}</label></th> - <td class="left" colspan="3"> - <form:checkbox path="noticeAt" value="Y"/> - <div><form:errors path="noticeAt" cssClass="error" /></div> - </td> - </tr> - -  - <c:set var="title"><spring:message code="comCopBbs.articleVO.reply.anonymousAt"/> </c:set> - <tr> - <th><label for="anonymousAt">${title}</label></th> - <td class="left" colspan="3"> - <form:checkbox path="anonymousAt" value="Y"/> - <div><form:errors path="anonymousAt" cssClass="error" /></div> - </td> - </tr> - -  - <c:set var="title"><spring:message code="comCopBbs.articleVO.reply.ntceDe"/> </c:set> - <tr> - <th><label for="ntceBgnde">${title} </label></th> - <td class="left" colspan="3"> - <form:input path="ntceBgnde" title="${title} ${inputTxt}" size="70" maxlength="70" style="width:70px;"/> -  ~ <form:input path="ntceEndde" title="${title} ${inputTxt}" size="70" maxlength="70" style="width:70px;"/> - <div><form:errors path="ntceBgnde" cssClass="error" /></div> - <div><form:errors path="ntceEndde" cssClass="error" /></div> - </td> - </tr> - - <c:if test="${boardMasterVO.fileAtchPosblAt == 'Y'}"> -  - <c:set var="title"><spring:message code="comCopBbs.articleVO.regist.atchFile"/></c:set> - <tr> - <th><label for="file_1">${title}</label> </th> - <td class="nopd" colspan="3"> - <input name="file_1" id="egovComFileUploader" type="file" title="<spring:message code="comCopBbs.articleVO.regist.atchFile"/>" multiple/> - <div id="egovComFileList"></div> - </td> - </tr> - </c:if> - - </tbody> - </table> - -  - <div class="btn"> - <input type="submit" class="s_submit" value="<spring:message code="button.create" />" title="<spring:message code="button.create" /> <spring:message code="input.button" />" /> - <span class="btn_s"><a href="<c:url value='/cop/bbs/selectArticleBlogList.do' />?bbsId=${boardMasterVO.bbsId}" title="<spring:message code="button.list" /> <spring:message code="input.button" />"><spring:message code="button.list" /></a></span> - </div><div style="clear:both;"></div> - -</div> - -<input name="pageIndex" type="hidden" value="<c:out value='${searchVO.pageIndex}'/>"/> -<input type="hidden" name="bbsTyCode" value="<c:out value='${boardMasterVO.bbsTyCode}'/>" /> -<input type="hidden" name="replyPosblAt" value="<c:out value='${boardMasterVO.replyPosblAt}'/>" /> -<input type="hidden" name="fileAtchPosblAt" value="<c:out value='${boardMasterVO.fileAtchPosblAt}'/>" /> -<input type="hidden" id="atchPosblFileNumber" name="atchPosblFileNumber" value="<c:out value='${boardMasterVO.atchPosblFileNumber}'/>" /> -<input type="hidden" name="atchPosblFileSize" value="<c:out value='${boardMasterVO.atchPosblFileSize}'/>" /> - -<input type="hidden" name="parnts" value="<c:out value='${result.parnts}'/>" /> -<input type="hidden" name="sortOrdr" value="<c:out value='${result.sortOrdr}'/>" /> -<input type="hidden" name="replyLc" value="<c:out value='${result.replyLc}'/>" /> - -<input name="nttId" type="hidden" value="${result.nttId}"> -<input name="bbsId" type="hidden" value="${boardMasterVO.bbsId}"> -<input name="cmd" type="hidden" value="<c:out value='save'/>"> -</form:form> - - -<script type="text/javascript"> -var maxFileNum = document.getElementById('atchPosblFileNumber').value; -if(maxFileNum==null || maxFileNum==""){ - maxFileNum = 3; -} -var multi_selector = new MultiSelector( document.getElementById( 'egovComFileList' ), maxFileNum ); -multi_selector.addElement( document.getElementById( 'egovComFileUploader' ) ); -</script> - - -</body> -</html> Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovArticleBlogList.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovArticleBlogList.jsp (revision 29) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovArticleBlogList.jsp (nonexistent) @@ -1,295 +0,0 @@ -<%@ page language="java" contentType="text/html; charset=UTF-8" %> -<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> -<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> -<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %> -<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %> -<%@ taglib prefix="validator" uri="http://www.springmodules.org/tags/commons-validator" %> -<%-- <%@ taglib prefix="ui" uri="http://egovframework.gov/ctl/ui"%> --%> -<c:set var="pageTitle"><spring:message code="comCopBbs.articleVO.title"/></c:set> -<!DOCTYPE html> -<html> -<head> -<meta http-equiv="content-type" content="text/html; charset=utf-8"> -<title>${pageTitle} <spring:message code="title.list" /></title> - -<link type="text/css" rel="stylesheet" href="<c:url value='/css/egovframework/com/cop/bbs/style.css' />"> -<script src="<c:url value='/js/egovframework/com/cmm/jquery-1.12.4.min.js' />"></script> - - -<script type="text/javascript" src="<c:url value="/validator.do"/>"></script> -<validator:javascript formName="formComment" staticJavascript="false" xhtml="true" cdata="false"/> - -<script> - -/********************************************************* - * 페이징 처리 함수 - ******************************************************** */ -function fn_egov_select_linkPage(pageNo){ - document.articleForm.pageIndex.value = pageNo; - document.articleForm.action = "<c:url value='/cop/bbs/selectArticleBlogList.do'/>"; - document.articleForm.submit(); -} - -function layer_toggle(ma) { - if (ma.style.display == 'none') { - ma.style.display = 'block'; - document.getElementById('blog_cnt').style.display = 'none'; - }else{ - ma.style.display = 'none'; - document.getElementById('blog_cnt').style.display = 'block'; - } - } - -function fn_egov_loadBdList(bbsId,blogNm,cnt){ - document.blogfrm.bbsId.value = bbsId; - var searchCnd = document.postCnt.searchCnd.value; - $('#sub').text(blogNm); - $(".comm_List").empty(); - $.ajax({ - url :"<c:url value='/cop/bbs/selectArticleBlogDetail.do'/>" - ,type: "POST" - ,data : {"bbsId":bbsId, "searchCnd":searchCnd} - ,dataType: 'json' - ,success : function(data){ - var innerHtml = ""; - var innerReply = ""; - var innerPaging = ""; - var length = data['blogSubJectList'].length; - if(length > 0) { - $.each(data['blogSubJectList'], function(i) { - innerHtml += '<tr>'; - innerHtml += '<td id="target" onclick="fn_clickComm(\'' + bbsId + '\', \''+data['blogSubJectList'][i].nttId+'\', \''+data['blogSubJectList'][i].ntcrId+'\', \''+data['blogSubJectList'][i].replyPosblAt+'\', \''+data['blogSubJectList'][i].blogId+'\', \''+cnt+'\')"; style="cursor:pointer">'; - if(data['blogSubJectList'][i].commentCo != "") { - innerHtml += data['blogSubJectList'][i].nttSj+"["+data['blogSubJectList'][i].commentCo+"]"; - }else{ - innerHtml += data['blogSubJectList'][i].nttSj; - } - innerHtml += '</td>'; - innerHtml += '<td>'; - innerHtml += data['blogSubJectList'][i].frstRegisterPnttm; - innerHtml += '</td>'; - innerHtml += '</tr>'; - - }); - - innerPaging += '<ul>'; - innerPaging += '<ui:pagination paginationInfo="${paginationInfo}" type="image" jsFunction="fn_egov_select_linkPage"/>'; - innerPaging += '</ul>'; - - $("#subtitle").html(innerHtml); - $("#paging").html(innerPaging); - $("#target").click(); //댓글표시 - if(data['blogCnOne'].nttCn != null){ - $(".cnt").html(data['blogCnOne'].nttCn); - } - } - } - ,error: function(){ - alert("<spring:message code="comCopBlog.articleBlogList.validate.noResult" />");//게시글이 없습니다!\n게시글을 등록해 주세요. - } - }); -} - -function fn_blog_cn(blogId){ - var bbsId = document.blogfrm.bbsId.value; - if (bbsId == '' || bbsId == null) { - alert('<spring:message code="comCopBlog.articleBlogList.validate.noBoard" />'); //등록된 게시판이 없습니다.\n카테고리등록을 통해 게시판을 생성해주세요. - return; - } - - location.href="<c:url value='/cop/bbs/insertArticleView.do' />?bbsId="+bbsId+"&blogAt=Y&blogId="+blogId; -} - -function fn_clickComm(bbsId, nttId, ntcrId, replyPosblAt, blogId, cnt){ - $.ajax({ - url :"<c:url value='/cop/bbs/selectArticleBlogDetailCn.do'/>" - ,type: "POST" - ,data : {"bbsId":bbsId, "nttId":nttId} - ,dataType: 'json' - ,success : function(data){ - var length = data['blogCnList'].length; - var innerHtml = ""; - var innerReply = ""; - if(length > 0) { - $.each(data['blogCnList'], function(i) { - innerHtml += data['blogCnList'][i].nttCn; - }); - $(".cnt").html(innerHtml); - - $('input[name=bbsId]').attr('value',bbsId); - $('input[name=nttId]').attr('value',nttId); - $('input[name=blogId]').attr('value',blogId); - - $.each(data['resultList'], function(i) { - innerReply += "<dl>"; - innerReply += "<dt>"; - innerReply += "<strong>"; - innerReply += data['resultList'][i].wrterNm; - innerReply += "</strong>"; - innerReply += "<span>" - innerReply += data['resultList'][i].frstRegisterPnttm; - innerReply += "</span>" - - if(cnt == 1) { - innerReply += "<div align='right'>"; - innerReply += '<a href="javascript:fn_egov_deleteCommentList(\''+data['resultList'][i].commentNo+'\', \''+bbsId+'\', \''+nttId+'\', \''+blogId+'\')" ><spring:message code="button.delete" /></a>';//삭제 - innerReply += "</div>"; - } - - innerReply += "</dt>"; - innerReply += "<dd>"; - innerReply += data['resultList'][i].commentCn; - innerReply += "</dd>"; - innerReply += "</dl>"; - }); - innerReply += "<dl>"; - innerReply += "<dd>"; - innerReply += "<form id='formComment' name='formComment' method='post'>"; - innerReply += "<textarea name='commentCn' placeholder='<spring:message code="comCopBlog.articleBlogList.validate.limitSize" />'/>";//댓글은 500byte 까지 작성할 수 있습니다. - innerReply += "<button type='button' onclick='fn_egov_insert_commentList(\""+bbsId+"\", \""+nttId+"\", \""+blogId+"\");'><spring:message code="title.create"/></button>";//등록 - innerReply += "<input name='bbsId' type='hidden' value=''>"; - innerReply += "<input name='nttId' type='hidden' value=''>"; - innerReply += "<input name='blogId' type='hidden' value=''>"; - innerReply += "<input name='modified' type='hidden' value=''>"; - innerReply += "<input name='commentNo' type='hidden' value=''>"; - innerReply += "<input name='blogAt' type='hidden' value='Y'>"; - innerReply += "</form>"; - innerReply += "</dd>"; - innerReply += "</dl>"; - $(".comm_List").html(innerReply); - }else{ - innerHtml += "<spring:message code="comCopBlog.articleBlogList.validate.noContent" />";//본문 내용이 존재하지 않습니다! - $(".cnt").html(innerHtml); - } - } - ,error: function(){ - alert("<spring:message code="comCopBlog.articleBlogList.validate.occurError" />");//에러가 발생했습니다. - } - }); -} - -function fn_egov_deleteCommentList(commentNo, bbsId, nttId, blogId) { - - var form = document.getElementById("formComment"); - - if (confirm('<spring:message code="common.delete.msg" />')) { - form.modified.value = "true"; - form.commentNo.value = commentNo; - form.bbsId.value = bbsId; - form.nttId.value = nttId; - form.blogId.value = blogId; - form.action = "<c:url value='/cop/cmt/deleteArticleComment.do'/>"; - form.submit(); - } -} - -function fn_egov_insert_commentList(bbsId, nttId, blogId) { - document.formComment.bbsId.value = bbsId; - document.formComment.nttId.value = nttId; - document.formComment.blogId.value = blogId; - document.formComment.modified.value = false; - document.formComment.action = "<c:url value='/cop/cmt/insertArticleComment.do'/>"; - - - if (!validateFormComment(document.formComment)){ - return; - } - if (confirm('<spring:message code="common.regist.msg" />')) { - document.formComment.submit(); - } - - -} - -$(document).ready(function() { - $("#titleck").click(); -}); - -</script> -</head> -<body> - -<div class="blog_wrap"> -  - <div class="blog_header"> - <div class="visual_default"> - <h1>${boardMasterVO.blogNm}</h1> - <p>${boardMasterVO.blogIntrcn}</p> - </div> - <div class="h_menu"> - <ul class="gnb"> - <c:forEach items="${blogNameList}" var="resultInfo" varStatus="status"> - <li><a id="titleck" onclick="fn_egov_loadBdList('<c:out value="${resultInfo.bbsId}"/>','<c:out value="${resultInfo.bbsNm}" />','<c:out value="${loginUserCnt}"/>');"><c:out value="${resultInfo.bbsNm}" /></a></li> - </c:forEach> - </ul> - - <ul class="gnb r"> - <c:choose> - <c:when test="${loginUserCnt == 1}"> - <li><a href="<c:url value='/cop/bbs/insertBBSMasterView.do?blogId=${boardMasterVO.blogId}&blogAt=Y' />" onclick="fn_egov_ls()"><spring:message code="comCopBlog.articleBlogList.regCategory" /></a></li> - <li><a href="<c:url value='/cop/bbs/selectBlogListManager.do?blogId=${boardMasterVO.blogId}' />" ><spring:message code="comCopBlog.blogUseMgrMain.btnBoard" /></a></li>  - </ul> - <button class="write" onclick="fn_blog_cn('${boardMasterVO.blogId}')"><spring:message code="button.create" /></button> - </c:when> - </c:choose> - </div> - </div> -  - -  - <div class="post"> - <div class="post_title"> - <p id="sub"></p> - </div> - - <div class="listBox"> - <table class="tbl_list"> - <caption>${pageTitle} <spring:message code="title.list" /></caption> - <colgroup> - <col style="width: ;" /> - <col style="width:10%" /> - </colgroup> - <tbody id=subtitle> - </tbody> - </table> - <form name="postCnt" method="post" onChange="$('#titleck').click();"> - <div class="post_opt"> - <label for="" class="blind"><spring:message code="comCopBlog.articleBlogList.setListNumbers" /></label> - <select name="searchCnd" id="searchCnd"> - <option value="5" <c:if test="${searchVO.searchCnd == '5'}">selected="selected"</c:if>><spring:message code="comCopBlog.articleBlogList.listNumber5" /></option> - <option value="10" <c:if test="${searchVO.searchCnd == '10'}">selected="selected"</c:if>><spring:message code="comCopBlog.articleBlogList.listNumber10" /></option> - <option value="15" <c:if test="${searchVO.searchCnd == '15'}">selected="selected"</c:if>><spring:message code="comCopBlog.articleBlogList.listNumber15" /></option> - <option value="20" <c:if test="${searchVO.searchCnd == '20'}">selected="selected"</c:if>><spring:message code="comCopBlog.articleBlogList.listNumber20" /></option> - <option value="30" <c:if test="${searchVO.searchCnd == '30'}">selected="selected"</c:if>><spring:message code="comCopBlog.articleBlogList.listNumber30" /></option> - </select> - </div> - </form> - <div id="paging" class="paging"> - </div> - </div> - </div> -  - -  - <div id="blog_cnt" class="blog_cnt" style="display:block;"> - <div class="blog_title"> -  - </div> - <div class="cnt"> -  - </div> -  - <div class="comm_List" > - </div> - </div> -  -</div> - - -<form name="blogfrm"> -<input name="blogCn" type="hidden" value=""> -<input name="blogName" type="hidden" value=""> -<input name="bbsId" type="hidden" value=""> -</form> -</body> -</html> \ No newline at end of file Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovBlogListPortlet.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovBlogListPortlet.jsp (revision 29) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/cop/bbs/EgovBlogListPortlet.jsp (nonexistent) @@ -1,34 +0,0 @@ -<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> -<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> -<%@ taglib prefix="ui" uri="http://egovframework.gov/ctl/ui"%> -<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn" %> -<%@ taglib prefix="spring" uri="http://www.springframework.org/tags"%> -<% -/** - * @Class Name : EgovBlogListPortlet.jsp - * @Description : 블로그 목록 조회 포틀릿화면 - * @Modification Information - * @ - * @ 수정일 수정자 수정내용 - * @ ------- -------- --------------------------- - * @ 2009.04.07 이삼섭 최초 생성 - * @ 2018.10.11 이정은 포털 메인화면 - 블로그 목록 조회 포틀릿추가 - * - * @author 공통서비스 개발팀 이삼섭 - * @since 2009.04.07 - * @version 1.0 - * @see - * - */ -%> -<ul> -<c:forEach var="result" items="${resultList}" varStatus="status"> - <li style="padding-top:5px"> - <form name="blogForm" method="post" action="<c:url value='/cop/bbs/selectArticleBlogList.do'/>" > - <input type="hidden" name="blogId" value="<c:out value='${result.blogId}'/>"/> - <input type="hidden" name="blogNm" value="<c:out value='${result.blogNm}'/>"/> - <input type="submit" value="<c:out value="${result.blogNm}"/>"/> - </form> - </li> -</c:forEach> -</ul>

Add a comment

List

Delete comment