package itn.let.cop.bbs.web;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLEncoder;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Locale;
import java.util.Map;
import java.util.Map.Entry;
import java.util.Random;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.commons.lang3.ArrayUtils;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.jsoup.Jsoup;
import org.jsoup.nodes.Document;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.ui.ModelMap;
import org.springframework.validation.BindingResult;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.support.SessionStatus;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.HandlerMapping;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.support.RedirectAttributes;
import org.springmodules.validation.commons.DefaultBeanValidator;

import com.penta.scpdb.ScpDbAgent;
import com.sci.v2.pcc.secu.SciSecuManager;
import com.sci.v2.pcc.secu.hmac.SciHmac;

import NiceID.Check.CPClient;
import egovframework.rte.fdl.property.EgovPropertyService;
import egovframework.rte.fdl.security.userdetails.util.EgovUserDetailsHelper;
import egovframework.rte.psl.dataaccess.util.EgovMap;
import egovframework.rte.ptl.mvc.tags.ui.pagination.PaginationInfo;
import itn.com.cmm.ComDefaultCodeVO;
import itn.com.cmm.EgovMessageSource;
import itn.com.cmm.EgovMultiPartEmail;
import itn.com.cmm.LoginVO;
import itn.com.cmm.ReadVO;
import itn.com.cmm.UserVO;
import itn.com.cmm.service.EgovCmmUseService;
import itn.com.cmm.service.EgovFileMngService;
import itn.com.cmm.service.EgovFileMngUtil;
import itn.com.cmm.service.FileVO;
import itn.com.cmm.service.ReadService;
import itn.com.cmm.util.EgovDoubleSubmitHelper;
import itn.com.cmm.util.StringUtil;
import itn.com.cmm.util.WebUtil;
import itn.com.uss.ion.cnf.service.ProhibitMngService;
import itn.com.uss.ion.cnf.service.WordFilterService;
import itn.com.uss.ion.cnf.service.WordFilterVO;
import itn.com.utl.fcc.service.EgovStringUtil;
import itn.let.cop.bbs.service.Board;
import itn.let.cop.bbs.service.BoardChgHst;
import itn.let.cop.bbs.service.BoardMaster;
import itn.let.cop.bbs.service.BoardMasterVO;
import itn.let.cop.bbs.service.BoardVO;
import itn.let.cop.bbs.service.EgovBBSAttributeManageService;
import itn.let.cop.bbs.service.EgovBBSManageService;
import itn.let.cop.cmt.service.CommentVO;
import itn.let.cop.cmt.service.EgovArticleCommentService;
import itn.let.mjo.mjocommon.MjonCommon;
import itn.let.mjo.msgdata.service.MjonMsgDataService;
import itn.let.sym.mnu.mpm.service.EgovMenuManageService;
import itn.let.sym.mnu.mpm.service.MenuManageVO;
import itn.let.sym.site.service.EgovSiteManagerService;
import itn.let.sym.site.service.JoinSettingVO;
import itn.let.sym.site.service.SiteManagerVO;
import itn.let.sym.site.service.TermsVO;
import itn.let.uss.umt.service.EgovUserManageService;
import itn.let.uss.umt.service.MberManageVO;
import itn.let.utl.sim.service.EgovClntInfo;
import itn.let.utl.user.service.MjonNoticeSendUtil;

/**
 * 게시물 관리를 위한 컨트롤러 클래스
 * @author 공통 서비스 개발팀 이삼섭
 * @since 2009.03.19
 * @version 1.0
 * @see
 *
 * <pre>
 * << 개정이력(Modification Information) >>
 *
 *   수정일      수정자          수정내용
 *  -------    --------    ---------------------------
 *  2009.03.19  이삼섭          최초 생성
 *  2009.06.29  한성곤	       2단계 기능 추가 (댓글관리, 만족도조사)
 *  2011.08.31  JJY            경량환경 템플릿 커스터마이징버전 생성
 *
 *  </pre>
 */
@Controller
public class EgovBBSManageController {

	@Resource(name = "EgovBBSManageService")
	private EgovBBSManageService bbsMngService;

	@Resource(name = "EgovBBSAttributeManageService")
	private EgovBBSAttributeManageService bbsAttrbService;

	@Resource(name = "EgovFileMngService")
	private EgovFileMngService fileMngService;

	@Resource(name = "EgovFileMngUtil")
	private EgovFileMngUtil fileUtil;

	@Resource(name = "propertiesService")
	protected EgovPropertyService propertyService;

	@Resource(name = "egovMessageSource")
	EgovMessageSource egovMessageSource;

	@Resource(name = "egovMultiPartEmail")
	private EgovMultiPartEmail egovMultiPartEmail;

	//문자발송 서비스
	@Resource(name = "MjonMsgDataService")
	private MjonMsgDataService mjonMsgDataService;
		
	@Autowired
	private DefaultBeanValidator beanValidator;
	
	@Value("#{globalSettings['Globals.Site.URL']}")
	private String SITE_URL;
	
	@Resource(name = "EgovCmmUseService")
	private EgovCmmUseService cmmUseService;
	
	/** WordFilterService 필터링 */
	@Resource(name = "wordFilterService")
	private WordFilterService wordFilterService;
	
	@Resource(name = "egovSiteManagerService")
	private EgovSiteManagerService egovSiteManagerService;
	
	@Resource(name = "readService")
	private ReadService readService;
	
	/** scriptMngService 금지어 */
	@Resource(name = "prohibitMngService")
	private ProhibitMngService prohibitMngService;
	
	@Resource(name = "EgovFileMngService")
	private EgovFileMngService fileService;
	
	/** EgovMenuManageService */
	@Resource(name = "meunManageService")
	private EgovMenuManageService menuManageService;
	
	/** 댓글 */
	@Resource(name = "EgovArticleCommentService")
    protected EgovArticleCommentService egovArticleCommentService;
	
	/** userManageService */
	@Resource(name = "userManageService")
	private EgovUserManageService userManageService;
	
	
	/** 알림전송 Util */
	@Resource(name = "mjonNoticeSendUtil")
	private MjonNoticeSendUtil mjonNoticeSendUtil;
	
	@Resource(name="MjonCommon")
	private MjonCommon mjonCommon;
	
	private static final Logger LOGGER = LoggerFactory.getLogger(EgovBBSManageController.class);

	//배열 정의{"컬럼순차번호, 컬럼이름, 컬럼내용, 컬럼이름에 붙여야할 내용(엑셀코드양식다운로드시 필요)"}
	private String[][] bbsExcelValue ={
	    {"0" ,"번호" , "1" , "" },
	    {"1", "제목" , "글쓰기 테스트" , "[코드]"}, 
	    {"2", "첨부파일유무" , "유", ""}, 
	    {"3", "공개여부" , "공개", ""}, 
	    {"4", "작성자" , "홍길동", "[코드]"},
	    {"5", "조회수" , "2", ""},
	    {"6", "작성일" , "2019-10-29", ""} 
	} ;
	/**
	 * XSS 방지 처리.
	 *
	 * @param data
	 * @return
	 */
	protected String unscript(String data) {
		if (data == null || data.trim().equals("")) {
			return "";
		}

		String ret = data;

		ret = ret.replaceAll("<(S|s)(C|c)(R|r)(I|i)(P|p)(T|t)", "&lt;script");
		ret = ret.replaceAll("</(S|s)(C|c)(R|r)(I|i)(P|p)(T|t)", "&lt;/script");

		ret = ret.replaceAll("<(O|o)(B|b)(J|j)(E|e)(C|c)(T|t)", "&lt;object");
		ret = ret.replaceAll("</(O|o)(B|b)(J|j)(E|e)(C|c)(T|t)", "&lt;/object");

		ret = ret.replaceAll("<(A|a)(P|p)(P|p)(L|l)(E|e)(T|t)", "&lt;applet");
		ret = ret.replaceAll("</(A|a)(P|p)(P|p)(L|l)(E|e)(T|t)", "&lt;/applet");

		ret = ret.replaceAll("<(E|e)(M|m)(B|b)(E|e)(D|d)", "&lt;embed");
		ret = ret.replaceAll("</(E|e)(M|m)(B|b)(E|e)(D|d)", "&lt;embed");

		ret = ret.replaceAll("<(F|f)(O|o)(R|r)(M|m)", "&lt;form");
		ret = ret.replaceAll("</(F|f)(O|o)(R|r)(M|m)", "&lt;form");

		ret = ret.replaceAll("<", "&lt;");
		ret = ret.replaceAll(">", "&gt;");
		ret = ret.replaceAll("alert", "");
		//ret = ret.replaceAll("iframe", "");
		
		return ret;
	}

	/**
	 * 게시물에 대한 목록을 조회한다.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/cop/bbs/selectBoardList.do")
	public String selectBoardArticles(@ModelAttribute("searchVO") BoardVO boardVO, ModelMap model
			, HttpServletRequest request, HttpServletResponse response, RedirectAttributes redirectAttributes) throws Exception {

		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		BoardMasterVO vo = new BoardMasterVO();
		vo.setBbsId(boardVO.getBbsId());
		BoardMasterVO master = bbsAttrbService.selectBBSMasterInf(vo);
		String listNum = "";
		if (("BBST05").equals(master.getBbsTyCode())) {
			listNum = "12"; // 포토형
		} else {
			listNum = master.getListNum();
		}
		
		boardVO.setPageUnit(Integer.parseInt(listNum));
		boardVO.setPageSize(Integer.parseInt(master.getPageNum()));

		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.setLoginId(user.getId());
		
		if("".equals(master.getSearchSortCnd())){ //최초조회시 최신것 조회List
			if("BBSMSTR_000000000528".equals(master.getBbsId())) { //묻고답하기 제외
				
			}else {
				boardVO.setSearchSortCnd("FRST_REGIST_PNTTM desc, NTT_ID");
				boardVO.setSearchSortOrd("desc");	
			}

		}
		
		// 공지사항
		if (("Y").equals(master.getNoticeYn()) && ("").equals(boardVO.getSearchWrd())) {
			List<BoardVO> notifyList = bbsMngService.selectBoardNotifyArticles(boardVO, vo.getBbsAttrbCode());
			model.addAttribute("notifyList", notifyList);
			boardVO.setNoticeAt("N"); //다음에 공지사항 아닌것만 검색
		}
		
		if (("BBST05").equals(master.getBbsTyCode())) { //재단소식이면 
			boardVO.setSearchSortCnd("FRST_REGIST_PNTTM desc, NTT_ID");
			boardVO.setSearchSortOrd("desc");
		}
		Map<String, Object> map = bbsMngService.selectBoardArticles(boardVO, vo.getBbsAttrbCode());
		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("boardVO", boardVO);
		model.addAttribute("brdMstrVO", master);
		model.addAttribute("paginationInfo", paginationInfo);

		//임시 데이터 이관용
		/*String ip = request.getHeader("X-Forwarded-For") == null ? request.getHeader("X-Forwarded-For") : request.getHeader("X-Forwarded-For").replaceAll("10.12.107.11", "").replaceAll(",", "").trim();
		if (ip == null) ip = request.getRemoteAddr();
		
		String ddd = "";
		if("219.240.88.15".equals(ip) || "0:0:0:0:0:0:0:1".equals(ip)) {
			model.addAttribute("Transfer", true );
		}
		System.out.println("---ip----"+ip);*/
		return "cop/bbs/EgovNoticeList";
	}

	/**
	 * 게시물을 등록한다.
	 *
	 * @param boardVO
	 * @param board
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value= {"/cop/bbs/insertBoardArticle.do" , "/cop/bbs/insertBoardArticleAjax.do"})
	public ModelAndView insertBoardArticle(final MultipartHttpServletRequest multiRequest
			, @ModelAttribute("searchVO") BoardVO boardVO
			, @ModelAttribute("bdMstr") BoardMasterVO bdMstr
			, @ModelAttribute("board") Board board
			, BindingResult bindingResult
			, ModelMap model
			, SessionStatus status
			, RedirectAttributes redirectAttributes
			, @RequestParam Map<String, Object> commandMap ) throws Exception {

		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		
		BoardMasterVO bmvo = new BoardMasterVO();
		bmvo.setBbsId(board.getBbsId());
		bmvo = bbsAttrbService.selectBBSMasterInf(bmvo);

		ModelAndView modelAndView = new ModelAndView();
		modelAndView.setViewName("jsonView");
		
		// 관리권한, 사용여부
		/*if (bmvo == null || !isBBSAuthFlag(bmvo.getManageAuth(), bmvo.getBbsId(), null)) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			modelAndView.addObject("result", "no_auth");
			return modelAndView;
		}*/
		
		beanValidator.validate(board, bindingResult);
		if (bindingResult.hasErrors()) {
			model.addAttribute("bdMstr", bmvo);
			modelAndView.addObject("result", "no_validate");
			return modelAndView;
		}
		
		String atchFileId = "";
		String isThumbFile = "";
		if (("BBST05").equals(bmvo.getBbsTyCode()) || ("BBST06").equals(bmvo.getBbsTyCode())) isThumbFile = "thumbFile";
		
		final Map<String, MultipartFile> files = multiRequest.getFileMap();
		if (!files.isEmpty()) {
			
			List<FileVO> result = fileUtil.parseFileInf(files, "BBS_", 0, atchFileId, "", isThumbFile);
			
			if(!isPosblAtchFile(result, bmvo, model, 0)) {
				modelAndView.addObject("result", "no_atchFile");
				return modelAndView;
			}

			atchFileId = fileMngService.insertFileInfs(result);
			board.setAtchFileId(atchFileId);
		}
		
		
		board.setFrstRegisterId(user.getUniqId());
		
		//데이터 이관용
		if(null ==board.getNtcrNm() || "".equals(board.getNtcrNm())) {
			board.setNtcrNm(user.getName());
		}
		
		board.setBbsId(board.getBbsId());
		board.setNttCn(unscript(board.getNttCn())); // XSS 방지
		board.setNttCn(board.getNttCn().replace("\r\n", ""));
		String userIp = EgovClntInfo.getClntIP(multiRequest);
		board.setNtcrIp(userIp);
		
		if(null !=board.getFrstRegisterPnttm() && !"".equals(board.getFrstRegisterPnttm()) ) {
			board.getFrstRegisterPnttm();
			String tempDete = board.getFrstRegisterPnttm().split("-")[0]+board.getFrstRegisterPnttm().split("-")[1]+board.getFrstRegisterPnttm().split("-")[2];
			board.setFrstRegisterPnttm(tempDete);
		}
		
		bbsMngService.insertBoardArticle(board);
		
		redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
		redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
		redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.insert"));
		modelAndView.addObject("result", "success");
		return modelAndView;
	}

	/**
	 * 게시물을 등록 미리보기
	 *
	 * @param boardVO
	 * @param board
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/cop/bbs/bbsPreview.do")
	public String insertBoardArticle(@ModelAttribute("board") Board board, @ModelAttribute("bdMstr") BoardMaster bdMstr,
			SessionStatus status, ModelMap model, RedirectAttributes redirectAttributes) throws Exception {
		
		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		
        Calendar today = Calendar.getInstance();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        String day = sdf.format(today.getTime());
		
		board.setFrstRegisterPnttm(day);
		
		model.addAttribute("board", board);
		model.addAttribute("bdMstr", bdMstr);
		return "cop/bbs/bbsPreview";
	}
	
	/**
	 * 공지사항, 채용공고 데이터 과기부 연동
	 *
	 * @param boardVO
	 * @return
	 * @throws Exception
	 */
	public String msitShareIn(Board board, String workType) throws Exception {
		if (1 == 1 ) return "asdf";
		
		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		String userId = user.getId();
		
		// yu3145 test s
		if (userId.equals("yu3145")) {
			
		
//		if (1 == 1 ) return "asdf";
		
		URL url;
		HttpURLConnection conn = null;
		Date today = new Date();
		SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		
		String dTime = dateFormat.format(today); // ex)"2014-11-19 17:01:05"; // 요청 시간 (서버의 현재 시간을 입력 해 주세요.)
		String sPassword = "2fd1cf70fca385b36c6e4296a1afcd2b";  // 암호키 ( 미래창조과학부에서 제공 하는 기관의 암호키로 변경 하세요) : 10자이상
		String organCd = "POLAORKR";  // 기관코드 (  미래창조과학부에서 제공 하는 기관코드 )
		String timeKey =""; // 시간키(요청시간)
		String certKey =""; // 인증키 =  MD5(기관코드  + timeKey + 암호키)
		
		String bbsId = board.getBbsId();
		long nttId = board.getNttId();
		String linkUrl = SITE_URL+"/web/cop/bbsWeb/selectBoardArticle.do?bbsId="+bbsId+"&nttId="+nttId;
		String contentType;
		 
		timeKey = dTime.replace("-","");
		timeKey = timeKey.replace(":","");
		timeKey = timeKey.replace(" ","");    // 현재 시간에서 숫자를 제외한 모든 문자를 제거함 (14자리 문자열)
		
		long timeKeyInt = ( Long.parseLong(timeKey) + 222222 ) * 2 ;    // 제거된 시간을 숫자로 치환수 더하고 곱함
		timeKey = Long.toString(timeKeyInt);	// 다시 문자열로 치환 : param_01
		 
		 // MD5 인증키 생성
		WebUtil webutil = new WebUtil();   
		certKey = webutil.MD5(organCd + timeKey + sPassword); // 인증키  ( 기관코드 + 변형된시간 + 암호키) : param_02
		 
		// 과기부 컨텐츠 타입
		if (("BBSMSTR_000000000018").equals(bbsId)) { // 공지사항
			contentType = "NT";
		} else if (("BBSMSTR_000000000029").equals(bbsId)) { // 채용공고
			contentType = "RE";
		} else {
			contentType = "";
			linkUrl = "";
		}
		
		System.out.println("### msit shareIn: param_01: " + timeKey);
		System.out.println("### msit shareIn: param_02: " + certKey);
		System.out.println("### msit shareIn: organCd: " + organCd);
		System.out.println("### msit shareIn: workType: " + workType);
		System.out.println("### msit shareIn: contentType: " + contentType);
		System.out.println("### msit shareIn: board_type: " + bbsId);
		System.out.println("### msit shareIn: board_cd: " + nttId);
		System.out.println("### msit shareIn: board_subject: " + board.getNttSj());
		System.out.println("### msit shareIn: board_reg_date: " + dTime);
		System.out.println("### msit shareIn: board_link_url: " + linkUrl);
		
		if (1 == 1 ) return "asdf";
		
		try {
		    Map<String,Object> params = new LinkedHashMap<>(); // 파라미터 세팅
		    params.put("param_01", timeKey);
		    params.put("param_02", certKey);
		    params.put("organ_cd", organCd);
		    params.put("work_type", workType); // I, U, D
		    params.put("content_type", contentType);
		    params.put("board_type", bbsId);
		    params.put("board_cd", nttId);
		    params.put("board_subject", board.getNttSj());
		    params.put("board_reg_date", dTime);
		    params.put("board_link_url", linkUrl);
			
		    StringBuilder postData = new StringBuilder();
		    for(Map.Entry<String,Object> param : params.entrySet()) {
		        if(postData.length() != 0) postData.append('&');
		        postData.append(URLEncoder.encode(param.getKey(), "UTF-8"));
		        postData.append('=');
		        postData.append(URLEncoder.encode(String.valueOf(param.getValue()), "UTF-8"));
		    }
		    byte[] postDataBytes = postData.toString().getBytes("UTF-8");
		
		    url = new URL("https://www.msit.go.kr/web/shareData/shareIn.do");
		
		    conn = (HttpURLConnection)url.openConnection();
		    conn.setRequestMethod("POST");
		    conn.setRequestProperty("Content-Type", "application/x-www-form-urlencoded");
		    conn.setRequestProperty("Content-Length", String.valueOf(postDataBytes.length));
		    conn.setDoOutput(true);
		    conn.getOutputStream().write(postDataBytes);
		
		    BufferedReader in = new BufferedReader(new InputStreamReader(conn.getInputStream(), "UTF-8"));
		    
		    String inputLine;
		    while((inputLine = in.readLine()) != null) { // response 출력
		    	System.out.println("### msit shareIn: " + inputLine);
		    }
		    // 처리결과 Y : 처리완료 , E : 에러 , M : 데이터 누락, O : 시간초과 ,A : 인증실패
		    
		    in.close();
		} catch (Exception e) {
			System.out.println("과기부연동에러. msit shareIn error");
		} finally {
			if (conn != null) conn.disconnect();
		}
		
		} 		// yu3145 test e
		
		return "";
	}
	
	/**
	 * 게시물에 대한 답변 등록을 위한 등록페이지로 이동한다.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/cop/bbs/addReplyBoardArticle.do")
	public String addReplyBoardArticle(@ModelAttribute("searchVO") BoardVO boardVO, ModelMap model, RedirectAttributes redirectAttributes) throws Exception {

		BoardMasterVO bdMstr = new BoardMasterVO();
		bdMstr.setBbsId(boardVO.getBbsId());
		bdMstr = bbsAttrbService.selectBBSMasterInf(bdMstr);

		// 관리권한, 사용여부
		/*if (bdMstr == null || ("N").equals(bdMstr.getUseAt()) 
				|| !isBBSAuthFlag(bdMstr.getManageAuth(), bdMstr.getBbsId(), null)) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/cop/bbs/SelectBBSMasterInfs.do";
		}*/
		
		//boardVO.setNttSj("[답변]" + boardVO.getNttSj());
		boardVO.setNttSj(boardVO.getNttSj());
		model.addAttribute("board", boardVO);
		model.addAttribute("bdMstr", bdMstr);

		return "cop/bbs/EgovNoticeReply";
	}

	/**
	 * 게시물에 대한 답변을 등록한다.
	 *
	 * @param boardVO
	 * @param board
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/cop/bbs/replyBoardArticleAjax.do")
	public ModelAndView replyBoardArticle(final MultipartHttpServletRequest multiRequest, @ModelAttribute("searchVO") BoardVO boardVO, @ModelAttribute("bdMstr") BoardMaster bdMstr,
			@ModelAttribute("board") Board board, BindingResult bindingResult, ModelMap model, SessionStatus status, RedirectAttributes redirectAttributes) throws Exception {

		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		
		BoardMasterVO bmvo = new BoardMasterVO();
		bmvo.setBbsId(boardVO.getBbsId());
		bmvo = bbsAttrbService.selectBBSMasterInf(bmvo);

		ModelAndView modelAndView = new ModelAndView();
		modelAndView.setViewName("jsonView");
		// 관리권한, 사용여부
		/*if (bmvo == null || !isBBSAuthFlag(bmvo.getManageAuth(), bmvo.getBbsId(), null)) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/cop/bbs/SelectBBSMasterInfs.do";
		}*/
		
		beanValidator.validate(board, bindingResult);
		if (bindingResult.hasErrors()) {
			model.addAttribute("bdMstr", bmvo);
			modelAndView.addObject("result", "no_validate");
			return modelAndView;
		}

		final Map<String, MultipartFile> files = multiRequest.getFileMap();
		String atchFileId = "";

		if (!files.isEmpty()) {
			List<FileVO> result = fileUtil.parseFileInf(files, "BBS_", 0, "", "", "");
			// 파일 사이즈, 개수, 확장자 체크. model에 체크 오류 메세지 set
			if(!isPosblAtchFile(result, bmvo, model, 0)) {
				modelAndView.addObject("result", "no_atchFile");
				return modelAndView;
			}

			atchFileId = fileMngService.insertFileInfs(result);
		}

		// 사용자 본인인증값 조회
		boardVO.setPlusCount(false);
		BoardVO vo = bbsMngService.selectBoardArticle(boardVO);
		
		board.setMblDn(vo.getMblDn());
		
		board.setAtchFileId(atchFileId);
		board.setReplyAt("Y");
		board.setFrstRegisterId(user.getUniqId());
		board.setNtcrNm(user.getName());
		board.setNttCn(unscript(board.getNttCn())); // XSS 방지
		board.setParnts(Long.toString(boardVO.getNttId()));
		board.setReplyLc(Integer.toString(Integer.parseInt(boardVO.getReplyLc()) + 1));
		board.setNttCn(board.getNttCn().replace("\r\n", ""));
		String userIp = EgovClntInfo.getClntIP(multiRequest);
		board.setNtcrIp(userIp);
		
		bbsMngService.insertBoardArticle(board);

		redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
		redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
		redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.insert"));
		//return "redirect:/cop/bbs/selectBoardList.do";
		modelAndView.addObject("result", "success");
		return modelAndView;
	}

	/**
	 * 게시물에 대한 내용을 삭제한다.
	 *
	 * @param boardVO
	 * @param board
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/cop/bbs/deleteBoardArticle.do")
	public String deleteBoardArticle(HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, @ModelAttribute("board") Board board,
			@ModelAttribute("bdMstr") BoardMaster bdMstr, ModelMap model, RedirectAttributes redirectAttributes)throws Exception {

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

		board.setLastUpdusrId(user.getUniqId());
		board.setLastUpdusrNm(user.getName());	// 변경이력에 사용
		String userIp = EgovClntInfo.getClntIP(request);
		board.setNtcrIp(userIp);

		bbsMngService.deleteBoardArticle(board);
		boardVO.setPageIndex(1); //삭제후 첫페이지로 로딩
		
		redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
		redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
		redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.useN"));
		return "redirect:/cop/bbs/selectBoardList.do";
	}
	
	/**
	 * 게시물에 대한 내용을 사용처리한다.
	 *
	 * @param boardVO
	 * @param board
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/cop/bbs/updateBoardArticleUseY.do")
	public String updateBoardArticleUseY(HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, @ModelAttribute("board") Board board,
			@ModelAttribute("bdMstr") BoardMaster bdMstr, ModelMap model, RedirectAttributes redirectAttributes)throws Exception {

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

		board.setLastUpdusrId(user.getUniqId());
		board.setLastUpdusrNm(user.getName());	// 변경이력에 사용
		String userIp = EgovClntInfo.getClntIP(request);
		board.setNtcrIp(userIp);

		bbsMngService.updateBoardArticleUseY(board);
		boardVO.setPageIndex(1); //삭제후 첫페이지로 로딩
		
		redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
		redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
		redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.useY"));
		return "redirect:/cop/bbs/selectBoardList.do";
	}
	

	/**
	 * 템플릿에 대한 미리보기용 게시물 목록을 조회한다.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/cop/bbs/bbsTmplatPreview.do")
	public String previewBoardArticles(@ModelAttribute("searchVO") BoardVO boardVO, @ModelAttribute("brdMstrVO") BoardMasterVO brdMstrVO, ModelMap model) throws Exception {

		String template = boardVO.getSearchWrd(); // 템플릿 URL
		String viewCnd = boardVO.getSearchCnd(); // 미리보기 목록/상세 구분

		brdMstrVO.setTmplatCours(template);
		model.addAttribute("brdMstrVO", brdMstrVO);

		if (brdMstrVO.getSearchCnd().equals("detail")) {
			return "cop/bbs/EgovPreviewTmplatBBSInqire";
		} else {
			return "cop/bbs/EgovPreviewTmplatBBSList";
		}
	}
	
	/**
	 * 게시물 등록을 위한 등록페이지로 이동한다.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/cop/bbs/addBoardArticle.do")
	public String addBoardArticle(@ModelAttribute("searchVO") BoardVO boardVO, ModelMap model ,HttpServletRequest request, RedirectAttributes redirectAttributes) throws Exception {
		
		BoardMasterVO bdMstr = new BoardMasterVO();
		bdMstr.setBbsId(boardVO.getBbsId());
		bdMstr = bbsAttrbService.selectBBSMasterInf(bdMstr);

		// 관리권한, 사용여부
		
		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		if(!"ROLE_ADMIN".equals(user.getAuthority())){ //관리자 제외
			if (bdMstr == null || ("N").equals(bdMstr.getUseAt()) 
					|| !isBBSAuthFlag(bdMstr.getManageAuth(), bdMstr.getBbsId(), null)) {
				redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
				return "redirect:/cop/bbs/SelectBBSMasterInfs.do";
			}
		}
		
		
		//권한조회 하여 flag 값에 세팅ddd
		bdMstr.setAuthorities(EgovUserDetailsHelper.getAuthorities());
		model.addAttribute("bdMstr", bdMstr);
		model.addAttribute("board", boardVO);
		
		//팝업창시작일자(시)
		model.addAttribute("ntceBgndeHH", getTimeHH());
		//팝업창시작일자(분)
		model.addAttribute("ntceBgndeMM", getTimeMM());
		//팝업창종료일자(시)
		model.addAttribute("ntceEnddeHH", getTimeHH());
		//팝업창정료일자(분)
		model.addAttribute("ntceEnddeMM", getTimeMM());	
		ComDefaultCodeVO vo = new ComDefaultCodeVO();  //모집상태
		vo.setCodeId("ITN015");
		model.addAttribute("codeList", cmmUseService.selectCmmCodeDetail(vo));
		//임시 데이터 이관용
		/*String ip = request.getHeader("X-Forwarded-For") == null ? request.getHeader("X-Forwarded-For") : request.getHeader("X-Forwarded-For").replaceAll("10.12.107.11", "").replaceAll(",", "").trim();
		if (ip == null) ip = request.getRemoteAddr();
		
		String ddd = "";
		if("219.240.88.15".equals(ip) || "0:0:0:0:0:0:0:1".equals(ip)) {
			model.addAttribute("Transfer", true );
		}*/
				
		return "cop/bbs/EgovNoticeRegist";
	}
	
	/**
	 * 게시물에 대한 상세 정보를 조회한다.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/cop/bbs/selectBoardArticle.do")
	public String selectBoardArticle(@ModelAttribute("searchVO") BoardVO boardVO
			, ModelMap model
			, HttpServletRequest request
			, RedirectAttributes redirectAttributes) throws Exception {
		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();

		BoardMasterVO master = new BoardMasterVO();
		master.setBbsId(boardVO.getBbsId());
		BoardMasterVO masterVo = bbsAttrbService.selectBBSMasterInf(master);
		
		// 조회수 증가 여부 지정
		boardVO.setPlusCount(true);
		BoardVO vo = bbsMngService.selectBoardArticle(boardVO);
		
		//읽음처리 Insert
		ReadVO readVO = new ReadVO();
		readVO.setReadId(String.valueOf(boardVO.getNttId()));
		readVO.setLoginId(user.getId());
		readVO.setMenuNo("2400000");
		
		// 삭제 및 노 데이터 조회 시
		if (vo == null) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("info.nodata.msg"));
			redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
			redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
			redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
			redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
			return "redirect:/cop/bbs/selectBoardList.do";
		}
		
		// 위/아래 게시글 번호, 제목 조회
		EgovMap upDownNttid =  bbsMngService.getUpDownNttIdNSj(boardVO);
		if(null != upDownNttid) {
			model.addAttribute("nextNttIdNSj", upDownNttid.get("nextNttIdNSj"));
			model.addAttribute("prevNttIdNSj", upDownNttid.get("prevNttIdNSj"));
		}else {
			model.addAttribute("nextNttIdNSj", null);
			model.addAttribute("prevNttIdNSj", null);
		}
		
		model.addAttribute("result", vo);
		model.addAttribute("brdMstrVO", masterVo);

		String isTotalPage = request.getParameter("isTotalPage");
		if (StringUtil.isEmpty(isTotalPage)) {
			isTotalPage = "N";
		}
		model.addAttribute("isTotalPage", isTotalPage);
				
		return "cop/bbs/EgovNoticeInqire";
	}

	/**
	 * 게시물에 대한 내용을 수정한다.
	 *
	 * @param boardVO
	 * @param board
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value= {"/cop/bbs/updateBoardArticle.do" , "/cop/bbs/updateBoardArticleAjax.do"})
	public ModelAndView updateBoardArticle(final MultipartHttpServletRequest multiRequest, 
			@ModelAttribute("searchVO") BoardVO boardVO, 
			@ModelAttribute("bdMstr") BoardMaster bdMstr,
			@ModelAttribute("board") Board board, 
			BindingResult bindingResult, 
			ModelMap model, 
			SessionStatus status, 
			RedirectAttributes redirectAttributes) throws Exception {

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

		BoardMasterVO bmvo = new BoardMasterVO();
		bmvo.setBbsId(board.getBbsId());
		bmvo = bbsAttrbService.selectBBSMasterInf(bmvo);
		
		ModelAndView modelAndView = new ModelAndView();
		modelAndView.setViewName("jsonView");
		// 관리권한, 사용여부
		/*if (bmvo == null || !isBBSAuthFlag(bmvo.getManageAuth(), bmvo.getBbsId(), null)) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			modelAndView.addObject("result", "no_auth");
			return modelAndView;
		}*/

		String atchFileId = boardVO.getAtchFileId();

		beanValidator.validate(board, bindingResult);
		if (bindingResult.hasErrors()) {
			model.addAttribute("bdMstr", bmvo);
			modelAndView.addObject("result", "no_validate");
			return modelAndView;
		}

		String isThumbFile = "";
		if (("BBST05").equals(bmvo.getBbsTyCode()) || ("BBST06").equals(bmvo.getBbsTyCode())) isThumbFile = "thumbFile";

		final Map<String, MultipartFile> files = multiRequest.getFileMap();
		if (!files.isEmpty()) {
			if ("".equals(atchFileId)) {
				List<FileVO> result = fileUtil.parseFileInf(files, "BBS_", 0, atchFileId, "", isThumbFile);
				
				if(!isPosblAtchFile(result, bmvo, model, 0)) {
					modelAndView.addObject("result", "no_atchFile");
					return modelAndView;
				}
				
				atchFileId = fileMngService.insertFileInfs(result);
				board.setAtchFileId(atchFileId);
			} else {
				FileVO fvo = new FileVO();
				fvo.setAtchFileId(atchFileId);
				int cnt = fileMngService.getMaxFileSN(fvo);
				List<FileVO> result = fileUtil.parseFileInf(files, "BBS_", cnt, atchFileId, "", isThumbFile);
				
				/*if(!isPosblAtchFile(result, bmvo, model, board.getAtchFileCnt())) {
					if(multiRequest.getServletPath().equals("/cop/bbs/updateBoardArticleAjax.do")) {
						modelAndView.addObject("result", "fail");
						modelAndView.addObject("failMessage", model.get("message"));
						return modelAndView;
					}
					
					model.addAttribute("bdMstr", bmvo);
					modelAndView.addObject("result", "no_atchFile");
					return modelAndView;
				}*/
				
				fileMngService.updateFileInfs(result);
			}
		}

		board.setLastUpdusrId(user.getUniqId());
		board.setNttCn(unscript(board.getNttCn())); // XSS 방지
		board.setLastUpdusrNm(user.getName());	// 변경이력에 사용
		board.setNttCn(board.getNttCn().replace("\r\n", ""));
		String userIp = EgovClntInfo.getClntIP(multiRequest);
		board.setNtcrIp(userIp);
		if(null !=board.getFrstRegisterPnttm() && !"".equals(board.getFrstRegisterPnttm()) ) {
			board.getFrstRegisterPnttm();
			String tempDete = board.getFrstRegisterPnttm().split("-")[0]+board.getFrstRegisterPnttm().split("-")[1]+board.getFrstRegisterPnttm().split("-")[2];
			board.setFrstRegisterPnttm(tempDete);
		}
		
		bbsMngService.updateBoardArticle(board);

		// 공지사항, 채용공고 과기부 연동
		if (("BBSMSTR_000000000018").equals(board.getBbsId()) || ("BBSMSTR_000000000029").equals(board.getBbsId())) {
			 msitShareIn(board, "U"); // 실서버에서만 테스트
		}
		
		redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
		redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
		redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.update"));
		modelAndView.addObject("result", "success");
		return modelAndView;
	}
	
	/**
	 * 게시물 수정을 위한 수정페이지로 이동한다.
	 *
	 * @param boardVO
	 * @param vo
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/cop/bbs/forUpdateBoardArticle.do")
	public String forUpdateBoardArticle(@ModelAttribute("searchVO") BoardVO boardVO, ModelMap model , HttpServletRequest request, RedirectAttributes redirectAttributes) throws Exception {

		BoardMasterVO masterVO = new BoardMasterVO();
		masterVO.setBbsId(boardVO.getBbsId());

		BoardMasterVO bmvo = bbsAttrbService.selectBBSMasterInf(masterVO);
		bmvo.setAuthorities(EgovUserDetailsHelper.getAuthorities());
		
		BoardVO bdvo = bbsMngService.selectBoardArticle(boardVO);
		if(null == bdvo.getPubLinkTxt() || "".equals(bdvo.getPubLinkTxt())){ //게시판명이 없으면 
			bdvo.setPubLinkTxt(bdvo.getPubLink());
		}
		
		if(bdvo.getAtchFileId() !=null) {
			FileVO fileVO = new FileVO();
			fileVO.setAtchFileId(bdvo.getAtchFileId());
			List<FileVO> fileList = fileService.selectFileInfs(fileVO);
			model.addAttribute("fileList", fileList);	
		}
		
		model.addAttribute("board", bdvo);
		model.addAttribute("bdMstr", bmvo);
		
		//팝업창시작일자(시)
		model.addAttribute("ntceBgndeHH", getTimeHH());
		//팝업창시작일자(분)
		model.addAttribute("ntceBgndeMM", getTimeMM());
		//팝업창종료일자(시)
		model.addAttribute("ntceEnddeHH", getTimeHH());
		//팝업창정료일자(분)
		model.addAttribute("ntceEnddeMM", getTimeMM());	
		ComDefaultCodeVO vo = new ComDefaultCodeVO();  //모집상태
		vo.setCodeId("ITN015");
		model.addAttribute("codeList", cmmUseService.selectCmmCodeDetail(vo));
		
		//임시 데이터 이관용
		String ip = request.getHeader("X-Forwarded-For") == null ? request.getHeader("X-Forwarded-For") : request.getHeader("X-Forwarded-For").replaceAll("10.12.107.11", "").replaceAll(",", "").trim();
		if (ip == null) ip = request.getRemoteAddr();
		if("219.240.88.15".equals(ip) || "0:0:0:0:0:0:0:1".equals(ip)) {
			model.addAttribute("Transfer", true );
		}
		
		return "cop/bbs/EgovNoticeUpdt";
	}
	
	/**
	 * 게시판 관리 권한 여부 체크
	 * @param manageAuth 게시판 관리권한
	 * @param bbsId 게시판ID
	 * @return boolean
	 * @throws Exception 
	 */
	private boolean isBBSAuthFlag(String manageAuth, String bbsId, List<EgovMap> mngIdList) throws Exception {
		boolean authFlag = false;
		List<String> authorities = EgovUserDetailsHelper.getAuthorities();
		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		
		// 게시판 관리권한 체크
		for (String authority : authorities) {
			if (authority.equals(manageAuth)) authFlag = true;
		}
		
		// 게시판 관리자 체크
		if (!authFlag) {
			BoardMaster vo = new BoardMaster();
			vo.setBbsId(bbsId);
			if (mngIdList == null) mngIdList = (List<EgovMap>)bbsAttrbService.selectBBSMngIdList(vo);
			
			int mngYn = 0;
			for(int i = 0; i < mngIdList.size(); i++) {
				String emplyrId = (String) mngIdList.get(i).get("emplyrId");
				if (emplyrId.equals(user.getId())) mngYn++;
			}
			
			if (mngYn != 0) authFlag = true;
			if(mngIdList.size() == 0 ) { //관리자 등록 안 되어 있으면 모두 사용가능
				authFlag = true;
			}
		}
		
		return authFlag;
	}
	
	/**
	 * 첨부파일 개수, 사이즈, 확장자 체크
	 * @param fileList 파일리스트
	 * @param boardMasterVO 게시판마스터
	 * @param atchFileCnt 업로드된 파일 수
	 * @return boolean
	 * @return 체크 오류 메세지 model 'flashMessage' 에 set
	 * @throws Exception 
	 */
	private boolean isPosblAtchFile(List<FileVO> fileList, BoardMaster boardMaster, ModelMap model, int atchFileCnt) throws Exception {
		int fileCnt = 0;
		long posblAtchFileSize = Long.parseLong(boardMaster.getPosblAtchFileSize()) * 1024 * 1024 ;
		int posblAtchFileNumber = Integer.parseInt(boardMaster.getPosblAtchFileNumber());
		String bbsTyCode = boardMaster.getBbsTyCode();
		String flashMessage = "";
		boolean posblAtchFileFlag = true;
		boolean posblAtchFileSizeFlag = true; 
		boolean posblAtchFileExtFlag = true; 
		
		Iterator<?> iter = fileList.iterator();
		while (iter.hasNext()) {
			FileVO vo = (FileVO) iter.next();
			long fileMg = Long.parseLong(vo.getFileMg());
			String fileExt = vo.getFileExtsn();
			
			if (fileMg > posblAtchFileSize) posblAtchFileSizeFlag = false;
			
			if (("BBST05").equals(bbsTyCode) || ("BBST06").equals(bbsTyCode)) {
				String[] imgExts = {"gif", "jpg", "bmp", "jpeg", "png"};
				if (ArrayUtils.indexOf(imgExts, fileExt.toLowerCase()) == -1) posblAtchFileExtFlag = false;
			}
			
			fileCnt++;
		}
		
		if (!posblAtchFileExtFlag) {
			flashMessage += "이미지 형식의 확장자만 업로드 가능합니다." + "\\n";
			posblAtchFileFlag = false;
		}
		if(!posblAtchFileSizeFlag) {
			flashMessage += "파일사이즈가 초과되었습니다. 최대크기 " + posblAtchFileSize + "mb" + "\\n";
			posblAtchFileFlag = false;
		}
		if ((fileCnt+atchFileCnt) > posblAtchFileNumber) {
			flashMessage += "파일 개수가 초과되었습니다. 최대개수 " + posblAtchFileNumber + "개" + "\\n";
			posblAtchFileFlag = false;
		}
		
		if (!posblAtchFileFlag) model.addAttribute("message", flashMessage);

		return posblAtchFileFlag;
	}
		
	/**
	 * 게시물 변경 이력에 대한 목록을 조회한다.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@SuppressWarnings("unchecked")
	@RequestMapping("/cop/bbs/selectBoardChgHstList.do")
	public String selectBoardChgHstList(@ModelAttribute("boardChgHst") BoardChgHst boardChgHst, ModelMap model) throws Exception {
		boardChgHst.setPageUnit(propertyService.getInt("pageUnit"));
		boardChgHst.setPageSize(propertyService.getInt("pageSize"));
		
		PaginationInfo paginationInfo = new PaginationInfo();

		paginationInfo.setCurrentPageNo(boardChgHst.getPageIndex());
		paginationInfo.setRecordCountPerPage(boardChgHst.getPageUnit());
		paginationInfo.setPageSize(boardChgHst.getPageSize());

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

		Map<String, Object> map = bbsMngService.selectBoardChgHsts(boardChgHst);
		int totCnt = Integer.parseInt((String) map.get("resultCnt"));
		paginationInfo.setTotalRecordCount(totCnt);

		// 내용에 html 제거
		List<BoardChgHst> list = (List<BoardChgHst>) map.get("resultList");
		for (BoardChgHst vo : list) {
			vo.setNttCn(StringUtil.stripTag(vo.getNttCn()));
		}
		
		model.addAttribute("resultList", map.get("resultList"));
		model.addAttribute("resultCnt", map.get("resultCnt"));
		model.addAttribute("paginationInfo", paginationInfo);

		return "cop/bbs/EgovNoticeChgHstList";
	}
	
	/**
	 * 게시물 변경이력에 대한 상세 정보를 조회한다.
	 *
	 * @param boardChgHst
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/cop/bbs/selectBoardChgHst.do")
	public String selectBoardChgHst(@ModelAttribute("boardChgHst") BoardChgHst boardChgHst, ModelMap model , RedirectAttributes redirectAttributes) throws Exception {
		BoardChgHst vo = bbsMngService.selectBoardChgHst(boardChgHst);
		model.addAttribute("result", vo);

		return "cop/bbs/EgovNoticeChgHstInqire";
	}
	
	/**
	 * 선택된 게시물에 대한 내용을 삭제한다.
	 * @param nttIds String
	 * @param boardVO BoardVO
	 * @return String
	 * @exception Exception
	 */
	@RequestMapping(value = "/cop/bbs/deleteBoardArticles.do")
	public String deleteBoardArticles(HttpServletRequest request, @RequestParam("nttIds") String nttIds, @ModelAttribute("BoardVO") BoardVO boardVO, RedirectAttributes redirectAttributes)
			throws Exception {
		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();

		boardVO.setLastUpdusrId(user.getUniqId());
		boardVO.setLastUpdusrNm(user.getName());	// 변경이력에 사용
		String userIp = EgovClntInfo.getClntIP(request);
		boardVO.setNtcrIp(userIp);

		String[] strNttIds = nttIds.split(";");
		for (int i = 0; i < strNttIds.length; i++) {
			String[] strNttIdNAtchFileId = strNttIds[i].split("\\|");
			boardVO.setNttId(Integer.parseInt(strNttIdNAtchFileId[0]));
			if (strNttIdNAtchFileId.length > 1) boardVO.setAtchFileId(strNttIdNAtchFileId[1]);
			
			bbsMngService.deleteBoardArticle(boardVO);
		}
		
		// 공지사항, 채용공고 과기부 연동
		if (("BBSMSTR_000000000018").equals(boardVO.getBbsId()) || ("BBSMSTR_000000000029").equals(boardVO.getBbsId())) {
			 msitShareIn(boardVO, "D"); // 실서버에서만 테스트
		}
		
		boardVO.setPageIndex(1); //삭제후 첫페이지로 로딩
		redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
		redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
		redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.delete"));
		return "redirect:/cop/bbs/selectBoardList.do";
	}

	/**
	 * 선택된 게시물 메인화면 폴라스토리 첫번째 게시물 등록
	 * @param nttIds String
	 * @param boardVO BoardVO
	 * @return String
	 * @exception Exception
	 */
	@RequestMapping(value = "/cop/bbs/mainPolaImgUpdate.do")
	public String mainPolaImgUpdate(HttpServletRequest request, @RequestParam("nttIds") String nttIds, @ModelAttribute("BoardVO") BoardVO boardVO, RedirectAttributes redirectAttributes)
			throws Exception {
		
		String[] strNttIdNAtchFileId = nttIds.split("\\|");
		boardVO.setNttId(Integer.parseInt(strNttIdNAtchFileId[0]));
		
		bbsMngService.updateMainPolaImg(boardVO);
		
		redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
		redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
		redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.update"));
		return "redirect:/cop/bbs/selectBoardList.do";
	}
	
	/**
	 * 사용자 게시글 등록 시 해당 게시판 관리자에게 메일 전송
	 * @param mailAddres 메일 주소
	 * @param bbsId 게시판ID
	 * @param nttId 게시글ID
	 * @param bbsNm 게시판 명
	 * @return boolean
	 * @throws Exception 
	 */
	private void sendBBSInsertMail(String mailAddres, String bbsId, long nttId, String bbsNm, String nttSj) throws Exception {
		try {
			String mailSj = "우체국물류지원단 홈페이지 \'" + bbsNm + "\' 게시판에 사용자 게시글이 등록되었습니다.";
			
			String htmlMsg = "<html>";
			htmlMsg += "\'" + bbsNm + "\' 게시판에 사용자 게시글이 등록되었습니다.";
			htmlMsg += "<br/><br/>제목: " + nttSj;
			htmlMsg += "<br/>링크: <a href='"+SITE_URL+"/cop/bbs/selectBoardArticle.do?bbsId="+bbsId+"&nttId="+nttId+"' target='_blank'>게시물</a>";
			htmlMsg += "<br/><br/>우체국물류지원단 시스템관리자";
			htmlMsg += "</html>";
			
			// test
			/*mailAddres = "yu3145@iten.co.kr";
			mailAddres = "kerinet@iten.co.kr" ;
			mailAddres = "fruit@pola.or.kr" ;*/
			
			
			egovMultiPartEmail.send(mailAddres, mailSj, "", htmlMsg);
//			egovMultiPartEmail.send(mailAddres, mailSj", mgs); // Simple Text Mail method
		} catch (Exception ex) {
			LOGGER.error("Sending Mail Exception : {} [unknown Exception]", ex.getCause());
			LOGGER.debug(ex.getMessage());
		}
	}
	
	/**
	 *  @@@@@@@@@@@@@@@@@@@@@@@@@@@@사용자
	 */

	/**
	 * (사용자)본인 인증 처리 Test
	 *
	 * @param boardVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/cop/bbs/authenticationResult.do")
	public String authenticationResult(HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, ModelMap model
			,RedirectAttributes redirectAttributes) throws Exception {
		UserVO userVO = new UserVO();
		String nameEn =  (String)request.getParameter("nameEn");

		switch (nameEn) {
			case "yu1" :
				userVO.setName("홍현준"); userVO.setMblDn("1111"); break;
			case "yu2" :
				userVO.setName("김현준"); userVO.setMblDn("2222"); break;
			case "yu3" :
				userVO.setName("박현준"); userVO.setMblDn("3333"); break;
		}
		
		request.getSession().setAttribute("userVO", userVO);
		
		String url = (String)request.getSession().getAttribute("url");
		BoardVO searchVO = (BoardVO)request.getSession().getAttribute("searchVO");
		redirectAttributes.addAttribute("pageIndex", searchVO.getPageIndex());
		redirectAttributes.addAttribute("searchCnd", searchVO.getSearchCnd());
		redirectAttributes.addAttribute("searchWrd", searchVO.getSearchWrd());
		redirectAttributes.addAttribute("bbsId", searchVO.getBbsId());
		redirectAttributes.addAttribute("nttId", searchVO.getNttId());

		return "redirect:" + url;
	}

	
	/**
	 * (사용자)게시물에 대한 목록을 조회한다.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value= {"/web/cop/bbsWeb/selectBoardList.do" , "/web/cop/bbsWeb/selectMoreListAjax.do"})
	public String selectBoardArticlesWeb(HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, ModelMap model
			,RedirectAttributes redirectAttributes) throws Exception {

		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
		UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
		
		if (bmVO == null || ("N").equals(bmVO.getUseAt())) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/web/main/mainPage.do";
		}

		// 신고게시판 여부
		if (("BBST02").equals(bmVO.getBbsTyCode()) || ("BBST03").equals(bmVO.getBbsTyCode())) {
			// 신고게시판 인트로 화면 구분
			if (("Y").equals(boardVO.getReportIntroYn())) {
				
				redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
				return "redirect:/web/cop/selfauth/reportIntro.do";
			}
			
			if (userVO != null) { // 사용자 인증
				 boardVO.setMblDn(userVO.getMblDn()); // 사용자 인증 키. 본인글만 조회
			} else { // 인증 필요
				request.getSession().setAttribute("searchVO", boardVO);
				request.getSession().setAttribute("url", "/web/cop/bbsWeb/selectBoardList.do");
				return "redirect:/web/cop/selfauth/authentication.do";
			}
		}
		
		boardVO.setPageUnit(Integer.parseInt(bmVO.getListNum()));
		boardVO.setPageSize(Integer.parseInt(bmVO.getPageNum()));

		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());
		if (("BBST05").equals(bmVO.getBbsTyCode())){ //사진게시판 8개씩 9개조회후 9개면 더보기
			boardVO.setRecordCountPerPage(8); //리스트 수 
			boardVO.setFirstIndex( (boardVO.getPageIndex()-1)*8); //offset
			paginationInfo.setRecordCountPerPage(boardVO.getRecordCountPerPage()); //웹 접근성 획득 후 롤백
		}	
		
		if(!"9410000".equals(bmVO.getMenuNo())) {
			boardVO.setParntScttNo("0"); //질문글만 가져오기(데이터 이관 숫자 틀려서 질문도 가져옴:공지사항)
		}
		 
		// 공지사항
		if (("Y").equals(bmVO.getNoticeYn())) {
			List<BoardVO> notifyList = bbsMngService.selectBoardNotifyArticles(boardVO, null);
			model.addAttribute("notifyList", notifyList);
			boardVO.setNoticeAt("N"); //다음에 공지사항 아닌것만 검색
		}
		
		if("BBST05".equals(bmVO.getBbsTyCode())){ //재단소식
			boardVO.setSearchSortCnd("FRST_REGIST_PNTTM");
			boardVO.setSearchSortOrd("desc");
		}
		Map<String, Object> map = bbsMngService.selectBoardArticlesWeb(boardVO, null);
		int totCnt = Integer.parseInt((String) map.get("resultCnt"));
		paginationInfo.setTotalRecordCount(totCnt);
		

		List<BoardVO> resultList = (List<BoardVO>)map.get("resultList");
		Calendar cal = Calendar.getInstance();
		int year = cal.get(Calendar.YEAR);
		int month = cal.get(Calendar.MONTH) + 1;
		int day = cal.get(Calendar.DAY_OF_MONTH);
		
		SimpleDateFormat t1 = new SimpleDateFormat("yyyyMMdd");
		String nowTime = t1.format(cal.getTime());
		
		for (BoardVO bvo: resultList) {
			Document doc = Jsoup.parse(bvo.getNttCn());
			String text = doc.text();
			bvo.setNttCn2(text);
			if("9470000".equals(bmVO.getMenuNo())){ //인재채용시
				String tempYmd = "";
				if(null != bvo.getNtceBgnde() && !"".equals(bvo.getNtceBgnde())) { //모집기간 요일 추가하여 txt로 변환
					tempYmd = bvo.getNtceBgnde().substring(0,4)+"-"+ bvo.getNtceBgnde().substring(4,6)+"-"+ bvo.getNtceBgnde().substring(6,8);
					tempYmd = tempYmd+"("+getDateDay(tempYmd , "yyyy-MM-dd")+")" ;
					tempYmd = tempYmd + " "+bvo.getNtceBgnde().substring(8,10) +":"+bvo.getNtceBgnde().substring(10,12) ;
					bvo.setNtceBgndeView(tempYmd);
					if(Integer.parseInt(nowTime) >  Integer.parseInt(bvo.getNtceEndde().substring(0,8)) ) {
						bvo.setSeCd("09");
					}
			}
			if(null != bvo.getNtceEndde() && !"".equals(bvo.getNtceEndde())) {
					tempYmd = bvo.getNtceEndde().substring(0,4)+"-"+ bvo.getNtceEndde().substring(4,6)+"-"+ bvo.getNtceEndde().substring(6,8);
					tempYmd = tempYmd+"("+getDateDay(tempYmd , "yyyy-MM-dd")+")" ;
					tempYmd = tempYmd + " "+bvo.getNtceEndde().substring(8,10) +":"+bvo.getNtceEndde().substring(10,12) ;
					bvo.setNtceEnddeView(tempYmd);
				}
			}
		}
		PaginationInfo paginationInfoMobile = new PaginationInfo();
		paginationInfoMobile.setCurrentPageNo(paginationInfo.getCurrentPageNo());
		paginationInfoMobile.setTotalRecordCount(paginationInfo.getTotalRecordCount());
		paginationInfoMobile.setPageSize(5);
		paginationInfoMobile.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
		
		model.addAttribute("resultList", resultList);
		model.addAttribute("resultCnt", map.get("resultCnt"));
		model.addAttribute("boardVO", boardVO);
		model.addAttribute("brdMstrVO", bmVO);
		model.addAttribute("paginationInfo", paginationInfo);
		model.addAttribute("paginationInfoMobile", paginationInfoMobile);
		
		if("BBST08".equals(bmVO.getBbsTyCode())){ //인재채용 게시판경우
			ComDefaultCodeVO vo = new ComDefaultCodeVO();  //모집상태
    		vo.setCodeId("ITN015");
    		model.addAttribute("codeList", cmmUseService.selectCmmCodeDetail(vo));
		}
		
		if("BBST05".equals(bmVO.getBbsTyCode())){ //재단소식 포토게시판
			if(resultList.size()>8) { //더보기 더튼 추가
				model.addAttribute("more", true);
			}else {
				model.addAttribute("more", false);
			}
			if("/web/cop/bbsWeb/selectMoreListAjax.do".equals(request.getRequestURI())) { //더보기
				return "web/cop/bbs/EgovNoticePhotoListAjax";	 			
			}
			return "web/cop/bbs/EgovNoticePhotoList"; //메인
		}
		
		if("9540000".equals(bmVO.getMenuNo())){ //개인정보처리방침의 경우 자세히 보기 pdf 파일과 제목가져오기
			if(resultList.size() > 0 ){
				model.addAttribute("pdfFileId", ((BoardVO)resultList.get(0)).getAtchFileId());
				model.addAttribute("pdfSj", ((BoardVO)resultList.get(0)).getNttSj());
			}
		}
		
		return "web/cop/bbs/EgovNoticeList";
	}

	/*nice체크 오프너로 이용*/
	@RequestMapping("/web/cop/bbs/niceCheckAjax.do")
	public String niceCheckWeb(HttpServletRequest request, 
			@RequestParam Map<String, Object> commandMap,
			@ModelAttribute("searchVO") BoardVO boardVO, 
			ModelMap model , HttpSession session
			 ) throws Exception {
		
		String niceMessage = niceCheck(request, session, boardVO).getNiceMessage();
		
		System.out.println("niceMessage --- " + niceMessage) ;
		if("".equals(niceMessage)) { //정상의 경우 세션 생성 후 오프너 close
			UserVO tempVO = new UserVO();
			tempVO.setMblDn(damoEnc(boardVO.getMblDn(), request)); //DI암호화  
			tempVO.setName(boardVO.getNiceNm());
			request.getSession().setAttribute("userVO", tempVO);
		}
		
		
		return "web/cop/selfauth/niceCheckAjax";
	}
	
	
	/**
	 * (사용자)게시물 등록을 위한 등록페이지로 이동한다.
	 *
	 * @param boardVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value={"/web/cop/bbs/addQnaBoardArticle.do","/web/cop/bbs/addSuggestBoardArticle.do"})
	public String addQnaBoardArticleWeb(HttpServletRequest request, 
			@RequestParam Map<String, Object> commandMap,
			@ModelAttribute("searchVO") BoardVO boardVO, 
			ModelMap model , HttpSession session,
			RedirectAttributes redirectAttributes ) throws Exception {
		
		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		String userId = user == null ? "" : EgovStringUtil.isNullToString(user.getId());
		
		if("".equals(userId)) {
			return "redirect:/web/user/login/login.do";
		}
		
		MberManageVO mberManageVO = new MberManageVO();
		mberManageVO.setMberId(user.getId());
		
		mberManageVO = bbsMngService.selectboardArticleWebQnaMberInfo(mberManageVO);
		
		
		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setUrl("/web/cop/bbs/SuggestList.do");
		List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(bmVO);
		
		bmVO.setBbsId(boardMenuList.get(0).getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
		/*UserVO userVO = new UserVO();
		if(null != request.getSession().getAttribute("userVO")) { //세션체크
			userVO = ((UserVO)request.getSession().getAttribute("userVO"));
			boardVO.setMblDn(userVO.getMblDn());
			boardVO.setNtcrNm(userVO.getName());
		}else {
			if("9530000".equals(bmVO.getMenuNo())) { //묻고답하기
				return "redirect:/web/cop/selfauth/authentication.do?bbsId="+boardVO.getBbsId();
			}
		}*/
		
		/*if (bmVO == null || ("N").equals(bmVO.getUseAt())) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/web/main/mainPage.do";
		}*/
		
		// 공통코드 Set
		/*setBBSCommCd(model, bmVO);*/
		model.addAttribute("mberManageVO", mberManageVO);
		model.addAttribute("brdMstrVO", bmVO);
		model.addAttribute("board", boardVO);
		model.addAttribute("suggestBbsId", boardMenuList.get(0).getBbsId());
		//최대 첨부파일 갯수 지정
		//model.addAttribute("posAtchFileNum", "1");
		
		String pattern = (String) request.getAttribute(HandlerMapping.BEST_MATCHING_PATTERN_ATTRIBUTE) ;
		if(pattern.equals("/web/cop/bbs/addSuggestBoardArticle.do")){ // 불편신고
			model.addAttribute("boardType", "suggest");
    	}

		// NEW
		// 공통
		List<TermsVO> resultList = new ArrayList<TermsVO>();			
		
		// 이용약관, 개인정보보호방침 최신버전 List
		TermsVO termsVO3 = new TermsVO();
		termsVO3.setFirstIndex(0);
		termsVO3.setRecordCountPerPage(1);
		termsVO3.setSearchDiv("03");
		termsVO3.setSearchUseYn("Y");			
		termsVO3.setSearchSortCnd("effectDate");
		termsVO3.setSearchSortOrd("desc");
		List<TermsVO> termsMastList2 = egovSiteManagerService.selectTermsMastMngList(termsVO3);
		if (termsMastList2.size() > 0) {
			TermsVO termsVO4 = new TermsVO();
			termsVO4.setFirstIndex(0);
			termsVO4.setRecordCountPerPage(20);				
			termsVO4.setTermsMastNo(termsMastList2.get(0).getTermsMastNo());
			termsVO4.setSearchUseYn("Y");
			termsVO4.setSearchSortCnd("sort");
			termsVO4.setSearchSortOrd("ASC");		
			resultList = egovSiteManagerService.selectTermsSubMngList(termsVO4);				
		}
		
		model.addAttribute("resultList", resultList);
		
		return "web/cop/bbs/EgovNoticeRegist";
	}
	
	
	/**
	 * (사용자)게시물 등록을 위한 등록페이지로 이동한다.(문자온 묻고답하기)
	 *
	 * @param boardVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/cop/bbs/addBoardArticle.do")
	public String addBoardArticleWeb(HttpServletRequest request, 
			@RequestParam Map<String, Object> commandMap,
			@ModelAttribute("searchVO") BoardVO boardVO, 
			ModelMap model , HttpSession session,
			BoardMasterVO brdMstrVO ,
			RedirectAttributes redirectAttributes ) throws Exception {
		
		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		String userId = user == null ? "" : EgovStringUtil.isNullToString(user.getId());
		
		if("".equals(userId)) {
			return "redirect:/web/user/login/login.do";
		}
		
		MberManageVO mberManageVO = new MberManageVO();
		mberManageVO.setMberId(user.getId());
		
		mberManageVO = bbsMngService.selectboardArticleWebQnaMberInfo(mberManageVO);
		
		/*if(null != request.getSession().getAttribute("userVO")) { //세션체크
			userVO = ((UserVO)request.getSession().getAttribute("userVO")) ;
			boardVO.setMblDn(userVO.getMblDn());
			boardVO.setNtcrNm(userVO.getName());
		}else {
			return "redirect:/web/cop/bbs/QnaList.do";
		}*/
		/*LoginVO loginvo = new LoginVO();
		if(null != request.getSession().getAttribute("LoginVO")) {
		loginvo = ((LoginVO)request.getSession().getAttribute("LoginVO"));
		System.out.println(loginvo.getName());
		boardVO.setNtcrNm(loginvo.getName());
		}*/
		
		//묻고답하기의 게시판들 가져오기
		BoardMasterVO tempBoardMasterVO = new BoardMasterVO();
		tempBoardMasterVO.setUrl("/web/cop/bbs/QnaList.do");
		List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(tempBoardMasterVO);
		List<BoardMasterVO>  viewBoardMenuList =  bbsAttrbService.selectBBSMenuByUrl(tempBoardMasterVO);
		for(BoardMasterVO tempVO : viewBoardMenuList) {
			if("N".equals(tempVO.getViewsYn())){
			tempBoardMasterVO.setViewsYn("N");
				break ;
			}
		}
		
		model.addAttribute("mberManageVO", mberManageVO);
		model.addAttribute("boardMenuList", boardMenuList);
		model.addAttribute("brdMstrVO", brdMstrVO);
		/*for(BoardMasterVO tempMasterVO : boardMenuList ) {
			tempMasterVO.setBbsNm(tempMasterVO.getBbsNm().split("\\(")[1].split("\\)")[0]) ;
		}*/
		
		model.addAttribute("board", boardVO);
		//최대 첨부파일 갯수 지정
		
		// NEW
		// 공통
		List<TermsVO> resultList = new ArrayList<TermsVO>();			
		
		// 이용약관, 개인정보보호방침 최신버전 List
		TermsVO termsVO3 = new TermsVO();
		termsVO3.setFirstIndex(0);
		termsVO3.setRecordCountPerPage(1);
		termsVO3.setSearchDiv("03");
		termsVO3.setSearchUseYn("Y");			
		termsVO3.setSearchSortCnd("effectDate");
		termsVO3.setSearchSortOrd("desc");
		List<TermsVO> termsMastList2 = egovSiteManagerService.selectTermsMastMngList(termsVO3);
		if (termsMastList2.size() > 0) {
			TermsVO termsVO4 = new TermsVO();
			termsVO4.setFirstIndex(0);
			termsVO4.setRecordCountPerPage(20);				
			termsVO4.setTermsMastNo(termsMastList2.get(0).getTermsMastNo());
			termsVO4.setSearchUseYn("Y");
			termsVO4.setSearchSortCnd("sort");
			termsVO4.setSearchSortOrd("ASC");		
			resultList = egovSiteManagerService.selectTermsSubMngList(termsVO4);				
		}
		
		model.addAttribute("resultList", resultList);
		
		return "web/cop/bbs/EgovNoticeRegist";
	}
	
	/**
	 * (사용자)본인인증 안내 화면
	 *
	 * @param 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/cop/selfauth/authentication.do")
	public String authentication(HttpServletRequest request, 
			ModelMap model , @RequestParam Map<String, Object> commandMap, 
			@ModelAttribute("searchVO") BoardVO boardVO) throws Exception {
		boardVO.setNiceSuccUrl(request.getRequestURL().toString().split("selfauth")[0]+"bbs/niceCheckAjax.do");
		boardVO.setNiceFailUrl(request.getRequestURL().toString());
		model.addAttribute("boardVO", boardVO);
		return "web/cop/selfauth/authentication";
	}
	
	/**
	 * (사용자)신고게시판 안내 화면
	 *
	 * @param 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/cop/selfauth/reportIntro.do")
	public String reportIntro(@ModelAttribute("searchVO") BoardVO boardVO, ModelMap model, RedirectAttributes redirectAttributes) throws Exception {
		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
		
		if (bmVO == null || ("N").equals(bmVO.getUseAt())) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/web/main/mainPage.do";
		}
		
		model.addAttribute("brdMstrVO", bmVO);
		return "web/cop/selfauth/reportIntro";
	}
	
	
	/**
	 * (사용자)글쓰기 권한 없으면 비번 입력란 보이게...
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value= {"/web/cop/bbsWeb/selectBoardChkDetailAjax"} )
	public ModelAndView selectBoardChkDetailAjax(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardVO boardVO, 
			ModelMap model) throws Exception {

		ModelAndView modelAndView = new ModelAndView();
		modelAndView.setViewName("jsonView");
		
		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		
		LoginVO loginVO  =  new LoginVO();
		if(!"anonymousUser".equals(EgovUserDetailsHelper.getAuthenticatedUser() )) { //최고 관리자면 바로수정
         	loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
         	if("ROLE_ADMIN".equals(loginVO.getAuthority())){ 
         		model.addAttribute("mblDnFlag", true);
         		return modelAndView;
         	}else { //일반관리자
         		bmVO.setBbsMngId(loginVO.getId());
         		if( bbsAttrbService.selectBBSMngInfCnt(bmVO) > 0 ) { //게시판 관리자 조회
             		model.addAttribute("mblDnFlag", true);
             		return modelAndView;
        		}
         	}
        }
		 
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
		BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
		UserVO userVO = new UserVO();
		if(request.getSession().getAttribute("userVO") != null){
			userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
			if(userVO.getMblDn().equals(bdVO.getMblDn())){
				model.addAttribute("mblDnFlag", true);
			}else {
				model.addAttribute("mblDnFlag", false);
			}
		}else {
			model.addAttribute("mblDnFlag", false);
		}
		return modelAndView;
	}
	
	
	/**
	 * (사용자)게시물에 대한 상세 정보를 조회한다.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value= {"/web/cop/bbsWeb/selectBoardArticle.do" , 
				"/web/cop/bbsWeb/selectBoardDetail.do",
				"/web/cop/bbs/NewsDetail.do",
				"/web/cop/bbs/LibDetail.do",
				"/web/cop/bbs/BussRealDetail.do",
				"/web/cop/bbs/QnaDetail.do",
				"/web/cop/bbs/SuggestDetail.do",
				"/web/cop/bbs/PubOperDetail.do",
				"/web/contentBbsDetail.do"
				
				//"/web/cop/bbs/EventDetail.do"
				} )
	public String selectBoardArticleWeb(HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, 
			BoardMasterVO masterVO,
			ModelMap model,
			@RequestParam Map<String, Object> commandMap,
			RedirectAttributes redirectAttributes) throws Exception {
		
		//XSS 태그 필터링 처리
		boardVO.setBbsId(unscript(boardVO.getBbsId()));
		boardVO.setSeCmmnCdId(unscript(boardVO.getSeCmmnCdId()));
		boardVO.setFrstRegisterId(unscript(boardVO.getFrstRegisterId()));
		boardVO.setSearchBgnDe(unscript(boardVO.getSearchBgnDe()));
		boardVO.setSearchEndDe(unscript(boardVO.getSearchEndDe()));
		boardVO.setSearchSortCnd(unscript(boardVO.getSearchSortCnd()));
		boardVO.setSearchSortOrd(unscript(boardVO.getSearchSortOrd()));
		boardVO.setSearchCnd(unscript(boardVO.getSearchCnd()));
		boardVO.setSearchWrd(unscript(boardVO.getSearchWrd()));
		
		
		BoardMasterVO bmVO = new BoardMasterVO();
		if("".equals(boardVO.getBbsId())) { //검색에서 조회시 nttid로 마스터 조회
			bmVO = bbsAttrbService.selectBbsIdByNttId(boardVO);
			if (bmVO == null) {
				redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
				return "redirect:/web/main/mainPage.do";
			}
			boardVO.setBbsId(bmVO.getBbsId());
		}else {
			bmVO.setBbsId(boardVO.getBbsId());
		}
			
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
		if("/web/cop/bbs/NewsDetail.do".equals(request.getRequestURI()) || "/web/contentBbsDetail.do".equals(request.getRequestURI())) { //원자력소식 수정삭제등록 없음.
			bmVO.setWebChgYn("N");
			model.addAttribute("masterVO", masterVO);
		}
		
		BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
		if (bmVO == null || ("N").equals(bmVO.getUseAt())) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/web/main/mainPage.do";
		}
		
		{//묻고답하기 권한체크
			boolean passChk = false; 
			if("9530000".equals(bmVO.getMenuNo())) {
				LoginVO loginVO  =  new LoginVO();
				if(!"anonymousUser".equals(EgovUserDetailsHelper.getAuthenticatedUser() )) { //최고 관리자면 바로수정
		         	loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		         	if("ROLE_ADMIN".equals(loginVO.getAuthority())){
		         		passChk = true;
		         	}else { //일반관리자
		         		bmVO.setBbsMngId(loginVO.getId());
		         		if( bbsAttrbService.selectBBSMngInfCnt(bmVO) > 0 ) { //게시판 관리자 조회
		         			passChk = true;
		        		}
		         	}
		        }else{//방문자 세션있는방문자
		        	UserVO userVO = new UserVO();
		    		if(request.getSession().getAttribute("userVO") != null) {
		    			userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
		    			if(userVO.getMblDn().equals(bdVO.getMblDn())) {
		    				passChk = true;
		    			}
		    		}	
		        }
				if(!"T".equals(bdVO.getSecretAt())){
					if(!passChk){
						if("".equals(boardVO.getPassword())) {
							redirectAttributes.addFlashAttribute("message", "패스워드를 넣어주세요");
							return "redirect:/web/cop/bbs/QnaList.do";
						}else {
							if(!damoDec(bdVO.getPassword(), request).equals(boardVO.getPassword())) {
								redirectAttributes.addFlashAttribute("message", "패스워드가 맞지 않습니다.");
								if("9530000".equals(bmVO.getMenuNo())) {
									return "redirect:/web/cop/bbs/QnaList.do";
								}else {
									return "redirect:/web/cop/bbsWeb/selectBoardList.do?bbsId="+boardVO.getBbsId();
								}
							}
						}
					}
				}
				
			}
		}
		
		// 조회수 증가 여부 지정
		boardVO.setPlusCount(true);
		bbsMngService.updateBoardArticleInqireCo(boardVO);
		
		boardVO.setMblDn(bdVO.getMblDn());
		
		// 위/아래 게시글 번호, 제목 조회
		if("/web/cop/bbs/QnaDetail.do".equals(request.getRequestURI())){
			LoginVO user = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null;
			String userUniqId = user == null ? "" : EgovStringUtil.isNullToString(user.getUniqId());
			boardVO.setFrstRegisterId(userUniqId);
		}
		EgovMap upDownNttid =  bbsMngService.getUpDownNttIdNSj(boardVO);
		
		//게시판 마스터 옵션 정보
		BoardMasterVO searchVO = new BoardMasterVO();
		searchVO.setBbsId(boardVO.getBbsId());
		BoardMasterVO resultBbsMsInfo = bbsAttrbService.selectBBSMasterInf(searchVO);
		
		//답변글 리스트
		if(bdVO.getAnswerCnt() > 0) {
			List<BoardVO> answerList = bbsMngService.selectBoardAnswerList(bdVO);
			model.addAttribute("answerList", answerList);
		}
		model.addAttribute("nextNttIdNSj", upDownNttid.get("nextNttIdNSj"));
		model.addAttribute("prevNttIdNSj", upDownNttid.get("prevNttIdNSj"));
		model.addAttribute("result", bdVO);
		model.addAttribute("brdMstrVO", bmVO);
		model.addAttribute("resultBbsMsInfo", resultBbsMsInfo);
		
		CommentVO commentVO = new CommentVO();
		commentVO.setBbsId(boardVO.getBbsId());		//게시판ID
		commentVO.setNttId(boardVO.getNttId());		//게시글ID
		
		//댓글 조회
		List<?> resultList = egovArticleCommentService.selectArticleCommentListAll(commentVO);
		int totCnt = resultList.size();
		
		model.addAttribute("resultCnt", totCnt);
		model.addAttribute("resultList", resultList);
		
		if("BBST05".equals(bmVO.getBbsTyCode())){ //이벤트 포토게시판
			if(bdVO.getAtchFileCnt() > 0 ) {
				FileVO fileVO = new FileVO();
				fileVO.setAtchFileId(bdVO.getAtchFileId());
				List<FileVO> result = fileService.selectImageFileList(fileVO);
				model.addAttribute("fileList", result);
			}
			return "web/cop/bbs/EgovNoticePhotoInqire";
		}
		
		if("Y".equals(masterVO.getTabBbsId())){
			model.addAttribute("PubDetail", true);
		}
		System.out.println("boardVO.toString()");
		System.out.println(boardVO.toString());
		return "web/cop/bbs/EgovNoticeInqire";
	}


	/**
	 * (사용자)게시물에 대한 상세 정보를 조회한다.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value= { "/web/cop/bbs/NoticeDetail.do" } )
	public String selectBoardNoticeDetailWeb(HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, 
			BoardMasterVO masterVO,
			ModelMap model,
			@RequestParam Map<String, Object> commandMap,
			RedirectAttributes redirectAttributes) throws Exception {
		
		//XSS 태그 필터링 처리
		boardVO.setBbsId(unscript(boardVO.getBbsId()));
		boardVO.setSeCmmnCdId(unscript(boardVO.getSeCmmnCdId()));
		boardVO.setFrstRegisterId(unscript(boardVO.getFrstRegisterId()));
		boardVO.setSearchBgnDe(unscript(boardVO.getSearchBgnDe()));
		boardVO.setSearchEndDe(unscript(boardVO.getSearchEndDe()));
		boardVO.setSearchSortCnd(unscript(boardVO.getSearchSortCnd()));
		boardVO.setSearchSortOrd(unscript(boardVO.getSearchSortOrd()));
		boardVO.setSearchCnd(unscript(boardVO.getSearchCnd()));
		boardVO.setSearchWrd(unscript(boardVO.getSearchWrd()));
		
		BoardMasterVO bmVO = new BoardMasterVO();
		
		//선택된 카테고리가 없는 경우
		if("".equals(boardVO.getBbsId())) { //검색에서 조회시 nttid로 마스터 조회
			bmVO = bbsAttrbService.selectBbsIdByNttId(boardVO);
			if (bmVO == null) {
				redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
				return "redirect:/web/main/mainPage.do";
			}
			boardVO.setBbsId(bmVO.getBbsId());
			
		}else {
			bmVO.setBbsId(boardVO.getBbsId());
		}
			
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
		if("/web/cop/bbs/NewsDetail.do".equals(request.getRequestURI()) || "/web/contentBbsDetail.do".equals(request.getRequestURI())) { //원자력소식 수정삭제등록 없음.
			bmVO.setWebChgYn("N");
			model.addAttribute("masterVO", masterVO);
		}
		
		BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
		if (bmVO == null || ("N").equals(bmVO.getUseAt())) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/web/main/mainPage.do";
		}
		
		{//묻고답하기 권한체크
			boolean passChk = false; 
			if("9530000".equals(bmVO.getMenuNo())) {
				LoginVO loginVO  =  new LoginVO();
				if(!"anonymousUser".equals(EgovUserDetailsHelper.getAuthenticatedUser() )) { //최고 관리자면 바로수정
		         	loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		         	if("ROLE_ADMIN".equals(loginVO.getAuthority())){
		         		passChk = true;
		         	}else { //일반관리자
		         		bmVO.setBbsMngId(loginVO.getId());
		         		if( bbsAttrbService.selectBBSMngInfCnt(bmVO) > 0 ) { //게시판 관리자 조회
		         			passChk = true;
		        		}
		         	}
		        }else{//방문자 세션있는방문자
		        	UserVO userVO = new UserVO();
		    		if(request.getSession().getAttribute("userVO") != null) {
		    			userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
		    			if(userVO.getMblDn().equals(bdVO.getMblDn())) {
		    				passChk = true;
		    			}
		    		}	
		        }
				if(!"T".equals(bdVO.getSecretAt())){
					if(!passChk){
						if("".equals(boardVO.getPassword())) {
							redirectAttributes.addFlashAttribute("message", "패스워드를 넣어주세요");
							return "redirect:/web/cop/bbs/QnaList.do";
						}else {
							if(!damoDec(bdVO.getPassword(), request).equals(boardVO.getPassword())) {
								redirectAttributes.addFlashAttribute("message", "패스워드가 맞지 않습니다.");
								if("9530000".equals(bmVO.getMenuNo())) {
									return "redirect:/web/cop/bbs/QnaList.do";
								}else {
									return "redirect:/web/cop/bbsWeb/selectBoardList.do?bbsId="+boardVO.getBbsId();
								}
							}
						}
					}
				}
				
			}
		}
		
		// 조회수 증가 여부 지정
		boardVO.setPlusCount(true);
		bbsMngService.updateBoardArticleInqireCo(boardVO);
		
		boardVO.setMblDn(bdVO.getMblDn());
		
		// 위/아래 게시글 번호, 제목 조회
		EgovMap upDownNttid =  bbsMngService.getUpDownNttIdNSj(boardVO);
		
		//게시판 마스터 옵션 정보
		BoardMasterVO searchVO = new BoardMasterVO();
		searchVO.setBbsId(boardVO.getBbsId());
		BoardMasterVO resultBbsMsInfo = bbsAttrbService.selectBBSMasterInf(searchVO);
		
		//답변글 리스트
		if(bdVO.getAnswerCnt() > 0) {
			List<BoardVO> answerList = bbsMngService.selectBoardAnswerList(bdVO);
			model.addAttribute("answerList", answerList);
		}
		model.addAttribute("nextNttIdNSj", upDownNttid.get("nextNttIdNSj"));
		model.addAttribute("prevNttIdNSj", upDownNttid.get("prevNttIdNSj"));
		model.addAttribute("result", bdVO);
		bmVO.setUrl(request.getRequestURI()); //url 넘겨주기 - 게시판 상세 jsp는 공용으로 사용하는데, 공지사항 상세는 작성자를 '운영자'로 고정하기 위해 url을 넘겨 메뉴 구분
		model.addAttribute("brdMstrVO", bmVO);
		model.addAttribute("resultBbsMsInfo", resultBbsMsInfo);
		
		CommentVO commentVO = new CommentVO();
		commentVO.setBbsId(boardVO.getBbsId());		//게시판ID
		commentVO.setNttId(boardVO.getNttId());		//게시글ID
		
		//댓글 조회
		List<?> resultList = egovArticleCommentService.selectArticleCommentListAll(commentVO);
		int totCnt = resultList.size();
		
		model.addAttribute("resultCnt", totCnt);
		model.addAttribute("resultList", resultList);
		
		if("BBST05".equals(bmVO.getBbsTyCode())){ //이벤트 포토게시판
			if(bdVO.getAtchFileCnt() > 0 ) {
				FileVO fileVO = new FileVO();
				fileVO.setAtchFileId(bdVO.getAtchFileId());
				List<FileVO> result = fileService.selectImageFileList(fileVO);
				model.addAttribute("fileList", result);
			}
			return "web/cop/bbs/EgovNoticePhotoInqire";
		}
		
		if("Y".equals(masterVO.getTabBbsId())){
			model.addAttribute("PubDetail", true);
		}
		System.out.println("boardVO.toString()");
		System.out.println(boardVO.toString());
		return "web/cop/bbs/EgovNoticeInqire";
	}
	
	/**
	 * (사용자)게시물에 대한 상세 정보를 조회한다.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value= {"/web/cop/bbsWeb/selectBoardChkDetailAjax.do"} )
	public ModelAndView selectBoardChkDetailAjax(HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, 
			BoardMasterVO masterVO,
			ModelMap model , 
			RedirectAttributes redirectAttributes) throws Exception {

		ModelAndView modelAndView = new ModelAndView();
		modelAndView.setViewName("jsonView");
		
		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
		
		
		BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
		if (bmVO == null || ("N").equals(bmVO.getUseAt())) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return modelAndView;
		}
		
		{//묻고답하기 권한체크
			boolean passChk = false; 
			if("9530000".equals(bmVO.getMenuNo())) {
				LoginVO loginVO  =  new LoginVO();
				if(!"anonymousUser".equals(EgovUserDetailsHelper.getAuthenticatedUser() )) { //최고 관리자면 바로수정
		         	loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		         	if("ROLE_ADMIN".equals(loginVO.getAuthority())){
		         		passChk = true;
		         	}else { //일반관리자
		         		bmVO.setBbsMngId(loginVO.getId());
		         		if( bbsAttrbService.selectBBSMngInfCnt(bmVO) > 0 ) { //게시판 관리자 조회
		         			passChk = true;
		        		}
		         	}
		        }else{//방문자 세션있는방문자
		        	UserVO userVO = new UserVO();
		    		if(request.getSession().getAttribute("userVO") != null) {
		    			userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
		    			if(userVO.getMblDn().equals(bdVO.getMblDn())) {
		    				passChk = true;
		    			}
		    		}	
		        }
				if(!"T".equals(bdVO.getSecretAt())){
					if(!passChk){
						if("".equals(boardVO.getPassword())) {
							model.addAttribute("passChk", "01"); //패스워드 필요
							return modelAndView;
						}else {
							//패스워드 복구화
							if(!damoDec(bdVO.getPassword(), request).equals(boardVO.getPassword())) {
								model.addAttribute("passChk", "02"); //패스워드가 틀림
								return modelAndView;
							}
						}
					}
				}
			}
		}
		
		boardVO.setMblDn(bdVO.getMblDn());
		model.addAttribute("boardVO", boardVO);
		return modelAndView;
	}
	
	
	/**
	 * (사용자)게시물 수정을 위한 수정페이지로 이동한다.
	 *
	 * @param boardVO
	 * @param vo
	 * @param model
	 * @throws Exception
	 */
	@RequestMapping("/web/cop/bbs/forUpdateBoardArticle.do")
	public String forUpdateBoardArticleWeb(HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, ModelMap model , RedirectAttributes redirectAttributes, BoardMasterVO brdMstrVO) throws Exception {
		
		/*BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
		//게시글 불러오기
		BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
		
		if(bdVO.getAtchFileId() !=null) {
			FileVO fileVO = new FileVO();
			fileVO.setAtchFileId(bdVO.getAtchFileId());
			List<FileVO> fileList = fileService.selectFileInfs(fileVO);
			model.addAttribute("fileList", fileList);	
		}
		UserVO userVO = new UserVO();
		//게시글 본인인증 번호 변수 저장
		String mblDn = bdVO.getMblDn();
		
		// 공통코드 Set
		setBBSCommCd(model, bmVO);
		model.addAttribute("board", bdVO);
		model.addAttribute("brdMstrVO", bmVO);
		//최대 첨부파일 갯수 지정
		model.addAttribute("posAtchFileNum", bmVO.getPosblAtchFileNumber());
		if("9530000".equals(bmVO.getMenuNo())){ //묻고답하기
			//묻고답하기의 게시판들 가져오기
			BoardMasterVO boardMasterVO = new BoardMasterVO();
			boardMasterVO.setUrl("/web/cop/bbs/QnaList.do");
			List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
			List<BoardMasterVO>  viewBoardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
			for(BoardMasterVO tempVO : viewBoardMenuList) {
				if("N".equals(tempVO.getViewsYn())){;
					boardMasterVO.setViewsYn("N");
					break ;
				}
			}
			for(BoardMasterVO tempMasterVO : boardMenuList ) {
				tempMasterVO.setBbsNm(tempMasterVO.getBbsNm().split("\\(")[1].split("\\)")[0]) ;
			}
			model.addAttribute("boardMenuList", boardMenuList);
		}*/
		
		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		String userId = user == null ? "" : EgovStringUtil.isNullToString(user.getId());
		
		if("".equals(userId)) {
			return "redirect:/web/user/login/login.do";
		}
		
		MberManageVO mberManageVO = new MberManageVO();
		mberManageVO.setMberId(user.getId());
		
		mberManageVO = bbsMngService.selectboardArticleWebQnaMberInfo(mberManageVO);
		
		/*if(null != request.getSession().getAttribute("userVO")) { //세션체크
			userVO = ((UserVO)request.getSession().getAttribute("userVO")) ;
			boardVO.setMblDn(userVO.getMblDn());
			boardVO.setNtcrNm(userVO.getName());
		}else {
			return "redirect:/web/cop/bbs/QnaList.do";
		}*/
		/*LoginVO loginvo = new LoginVO();
		if(null != request.getSession().getAttribute("LoginVO")) {
		loginvo = ((LoginVO)request.getSession().getAttribute("LoginVO"));
		System.out.println(loginvo.getName());
		boardVO.setNtcrNm(loginvo.getName());
		}*/
		
		BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
		
		if(bdVO.getAtchFileId() !=null) {
			FileVO fileVO = new FileVO();
			fileVO.setAtchFileId(bdVO.getAtchFileId());
			List<FileVO> fileList = fileService.selectFileInfs(fileVO);
			model.addAttribute("fileList", fileList);	
		}
		
		//묻고답하기의 게시판들 가져오기
		BoardMasterVO tempBoardMasterVO = new BoardMasterVO();
		tempBoardMasterVO.setUrl("/web/cop/bbs/QnaList.do");
		List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(tempBoardMasterVO);
		List<BoardMasterVO>  viewBoardMenuList =  bbsAttrbService.selectBBSMenuByUrl(tempBoardMasterVO);
		for(BoardMasterVO tempVO : viewBoardMenuList) {
			if("N".equals(tempVO.getViewsYn())){
			tempBoardMasterVO.setViewsYn("N");
				break ;
			}
		}
		
		model.addAttribute("mberManageVO", mberManageVO);
		model.addAttribute("boardMenuList", boardMenuList);
		model.addAttribute("brdMstrVO", brdMstrVO);
		/*for(BoardMasterVO tempMasterVO : boardMenuList ) {
			tempMasterVO.setBbsNm(tempMasterVO.getBbsNm().split("\\(")[1].split("\\)")[0]) ;
		}*/
		
		model.addAttribute("board", bdVO);
		//최대 첨부파일 갯수 지정
		
		
		return "web/cop/bbs/EgovNoticeUpdt";
	}

	/**
	 * (사용자)게시물에 대한 내용을 수정한다.
	 *
	 * @param boardVO
	 * @param board
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	
	@RequestMapping(value= {"/web/cop/bbs/updateBoardArticle.do" , "/web/cop/bbs/updateBoardArticleAjax.do"})
	public ModelAndView updateBoardArticleWeb(HttpServletRequest request, final MultipartHttpServletRequest multiRequest, @ModelAttribute("searchVO") BoardVO boardVO, @ModelAttribute("bdMstr") BoardMaster bdMstr,
			@ModelAttribute("board") Board board, BindingResult bindingResult, ModelMap model, SessionStatus status, RedirectAttributes redirectAttributes) throws Exception {

		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
		
		ModelAndView modelAndView = new ModelAndView();
		modelAndView.setViewName("jsonView");

		// Start => bbsId를 변조해서 공지사항에 글 등록 방지 처리
		//boardVO.setBbsId("BBSMSTR_000000000651");	// 공지사항
		List<BoardVO> userBbsWriteList = bbsMngService.selectUserBbsWriteList(boardVO);
		System.out.println("boardVO.getBbsId : " + boardVO.getBbsId());
		System.out.println("userBbsWriteList.size() : " + userBbsWriteList.size());
		
		if (userBbsWriteList.size() == 0) {
			// 1:1문의, 불편사항 등 고객이 등록할수있는 게시판 목록이 아닐경우 
			modelAndView.addObject("message", "잘못된 접근입니다.\n관리자에게 문의하세요.");
			modelAndView.addObject("result", "fail");
			return modelAndView;			
		}
		// End		
		
		if (bmVO == null || ("N").equals(bmVO.getUseAt())) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			//return "redirect:/web/main/mainPage.do";
			modelAndView.addObject("result", "no_imposbl");
			return modelAndView;
		}
		
//		if (userVO == null) { // 인증 필요
//			multiRequest.getSession().setAttribute("searchVO", boardVO);
//			multiRequest.getSession().setAttribute("url", "/web/cop/bbs/forUpdateBoardArticle.do");
//			return "redirect:/web/cop/selfauth/authentication.do";
//		}

		BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
//		String frstRegisterId = bdVO.getFrstRegisterId(); // 관리자 유무
		
		//230801 이지우 - 본인글 외에 nttId 변조를 통하여 다른 게시글 수정 가능한 취약점 방지
		LoginVO loginVO = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null;
		String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getUniqId());
		if(!bdVO.getFrstRegisterId().equals(userId)) {
			modelAndView.addObject("message", "잘못된 접근입니다.\n관리자에게 문의하세요.");
			modelAndView.addObject("result", "fail");
			return modelAndView;			
		}
		
		UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
		
		//게시글 본인인증 번호 변수 저장
		//String mblDn = bdVO.getMblDn();
		
		// 본인글 체크
		/*if (!mblDn.equals(userVO.getMblDn())) {
			redirectAttributes.addFlashAttribute("message", "본인글 외에는 수정할 수 없습니다.");
			redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
			redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
			redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
			redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
			redirectAttributes.addAttribute("nttId", boardVO.getNttId());
			modelAndView.addObject("result", "no_imposbl");
			return modelAndView;
		}*/
		
		String atchFileId = boardVO.getAtchFileId();

		beanValidator.validate(board, bindingResult);
		if (bindingResult.hasErrors()) {
			// 공통코드 Set
			setBBSCommCd(model, bmVO);
			model.addAttribute("brdMstrVO", bmVO);
			modelAndView.addObject("result", "no_Validator");
			return modelAndView;
		}

		String isThumbFile = "";
		if (("BBST05").equals(bmVO.getBbsTyCode()) || ("BBST06").equals(bmVO.getBbsTyCode())) isThumbFile = "thumbFile";

		final Map<String, MultipartFile> files = multiRequest.getFileMap();
		if (!files.isEmpty()) {
			
			if ("".equals(atchFileId)) {
				List<FileVO> result = fileUtil.parseFileInf(files, "BBS_", 0, atchFileId, "", isThumbFile);
				
				if(!isPosblAtchFile(result, bmVO, model, 0)) {
					// 공통코드 Set
					setBBSCommCd(model, bmVO);
					model.addAttribute("brdMstrVO", bmVO);
					modelAndView.addObject("result", "no_fileupdate");
					return modelAndView;
				}
				
				atchFileId = fileMngService.insertFileInfs(result);
				board.setAtchFileId(atchFileId);
			} else {
				FileVO fvo = new FileVO();
				fvo.setAtchFileId(atchFileId);
				int cnt = fileMngService.getMaxFileSN(fvo);
				List<FileVO> result = fileUtil.parseFileInf(files, "BBS_", cnt, atchFileId, "", isThumbFile);
				
				/*
				 * 파일 확장자 및 사이즈 등을 체크해주는 부분
				 * if(!isPosblAtchFile(result, bmVO, model, board.getAtchFileCnt())) {
					// 공통코드 Set
					setBBSCommCd(model, bmVO);
					model.addAttribute("brdMstrVO", bmVO);
					//return "web/cop/bbs/EgovNoticeUpdt";
					modelAndView.addObject("result", "no_fileupdate");
					return modelAndView;
				}*/
				
				fileMngService.updateFileInfs(result);
			}
		}

		board.setNttCn(unscript(board.getNttCn())); // XSS 방지
		//board.setLastUpdusrNm(userVO.getName());	// 변경이력에 사용
		String userIp = EgovClntInfo.getClntIP(multiRequest);
		board.setNtcrIp(userIp);

		bbsMngService.updateBoardArticle(board);

		redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
		redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
		redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.update"));
		modelAndView.addObject("result", "success");
		return modelAndView;
	}

	/**
	 * (사용자)게시물에 대한 내용을 삭제한다.
	 *
	 * @param boardVO
	 * @param board
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/cop/bbs/deleteBoardArticle.do")
	public String deleteBoardArticleWeb(HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, @ModelAttribute("board") Board board,
			@ModelAttribute("bdMstr") BoardMaster bdMstr, ModelMap model, RedirectAttributes redirectAttributes)throws Exception {

		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);

		
		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		String userUniqId = user == null ? "" : EgovStringUtil.isNullToString(user.getUniqId());
		
		BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
		//String frstRegisterId = bdVO.getFrstRegisterId(); // 관리자 유무
		String frstRegisterId = bdVO.getFrstRegisterId();
		//bdVO.setMblDn(""); // 화면단으로 모바일키 인증 방지
		
		// 본인글 체크
		if (!frstRegisterId.equals(userUniqId)) {
			redirectAttributes.addFlashAttribute("message", "본인글 외에는 삭제할 수 없습니다.");
			redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
			redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
			redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
			redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
			redirectAttributes.addAttribute("nttId", boardVO.getNttId());
			return "redirect:/web/cop/bbsWeb/selectBoardArticle.do";
		}
		
		
		board.setLastUpdusrNm(user.getName());	// 변경이력에 사용
		String userIp = EgovClntInfo.getClntIP(request);
		board.setNtcrIp(userIp);

		bbsMngService.deleteBoardArticle(board);
		boardVO.setPageIndex(1); //삭제후 첫페이지로 로딩

		redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
		redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
		redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.delete"));
		return "redirect:/web/cop/bbs/QnaList.do";
	}

	/**
	 * (사용자)본인인증 요청 입력 Sample
	 *
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/cop/bbs/pccInput.do")
	public String pccInput(HttpServletRequest request, ModelMap model, RedirectAttributes redirectAttributes)throws Exception {
		
		return "web/cop/selfauth/pcc_V3_input_seed";
	}
	
	/**
	 * (사용자)본인인증 요청 팝업 Sample
	 *
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/cop/bbs/selfauth.do")
	public String selfauthTest(HttpServletRequest request, ModelMap model, RedirectAttributes redirectAttributes)throws Exception {
		
		return "web/cop/selfauth/pcc_V3_sample_seed";
	}
	
	@Value("#{globalSettings['Globals.selfauth.siteId']}")
	private String SELFAUTH_SITE_ID;
	@Value("#{globalSettings['Globals.selfauth.srvNo']}")
	private String SELFAUTH_SRV_NO;
	
	/**
	 * (사용자)본인인증 요청
	 *
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/cop/selfauth/selfauth.do")
	public String selfauth(HttpServletRequest request, ModelMap model, RedirectAttributes redirectAttributes)throws Exception {
		
        //날짜 생성
        Calendar today = Calendar.getInstance();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
        String day = sdf.format(today.getTime());

        java.util.Random ran = new Random();
        //랜덤 문자 길이
        int numLength = 6;
        String randomStr = "";

        for (int i = 0; i < numLength; i++) {
            //0 ~ 9 랜덤 숫자 생성
            randomStr += ran.nextInt(10);
        }

		String certGb = "H";
		String addVar = "";
        String reqNum = day + randomStr; // //reqNum은 최대 40byte 까지 사용 가능
		String certDate=day;
		String exVar = "0000000000000000"; // 복호화용 임시필드

		request.getSession().setAttribute("reqNum", reqNum); // 결과값 복호화시 필요
		
	    //01. 암호화 모듈 선언
		SciSecuManager seed  = new SciSecuManager();

		//02. 1차 암호화
		String encStr = "";
		String reqInfo      = SELFAUTH_SITE_ID+"^"+SELFAUTH_SRV_NO+"^"+reqNum+"^"+certDate+"^"+certGb+"^"+addVar+"^"+exVar;  // 데이터 암호화
		encStr              = seed.getEncPublic(reqInfo);
		
		//03. 위변조 검증 값 생성
		String hmacMsg = SciHmac.HMacEncriptPublic(encStr);

		//03. 2차 암호화
		reqInfo  = seed.getEncPublic(encStr + "^" + hmacMsg + "^" + "0000000000000000");  //2차암호화
		
		request.getSession().setAttribute("reqInfo", reqInfo); // 본인확인 요청 정보
		request.getSession().setAttribute("SITE_URL", SITE_URL); // 사이트 URL
		
		return "web/cop/selfauth/selfauth";
	}
	
	/**
	 * (사용자)본인인증 결과 리턴
	 *
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/cop/selfauth/resultSeed.do")
	public String resultSeed(HttpServletRequest request, ModelMap model, RedirectAttributes redirectAttributes)throws Exception {
		
		String retInfo   = request.getParameter("retInfo").trim();
		String cookiereqNum = (String)request.getSession().getAttribute("reqNum");
		
		//복화화용 변수
		String encPara		= "";
		String encMsg		= "";
		String msgChk       = "N";  
		
        // 1. 암호화 모듈 (jar) Loading
		SciSecuManager sciSecuMg  = new SciSecuManager();
        //쿠키에서 생성한 값을 Key로 생성 한다.
        retInfo  = sciSecuMg.getDec(retInfo, cookiereqNum);

        // 2.1차 파싱---------------------------------------------------------------
        String[] aRetInfo1 = retInfo.split("\\^");

		encPara  = aRetInfo1[0];         //암호화된 통합 파라미터
        encMsg   = aRetInfo1[1];    //암호화된 통합 파라미터의 Hash값
		
		String  encMsg2   = sciSecuMg.getMsg(encPara);
		// 3.위/변조 검증 ---------------------------------------------------------------
        if(encMsg2.equals(encMsg)) msgChk="Y";

        if(msgChk.equals("N")) {
        	// 비정상 접근 처리
        }
		
		retInfo  = sciSecuMg.getDec(encPara, cookiereqNum);

        String[] aRetInfo = retInfo.split("\\^");
    	String name		= aRetInfo[0];                                                               //성명
//    	String birYMD		= aRetInfo[1];																//생년월일
//    	String sex			= aRetInfo[2];																//성별
//    	String fgnGbn	= aRetInfo[3];																//내외국인 구분값
        String di			= aRetInfo[4];																//DI
//        String ci1			= aRetInfo[5];																//CI
//        String ci2			= aRetInfo[6];																//CI
//        String civersion  = aRetInfo[7];                                                               //CI Version
//        String reqNum	= aRetInfo[8];                                                               // 본인확인 요청번호
//        String result		= aRetInfo[9];                                                               // 본인확인결과 (Y/N)
//        String certGb		= aRetInfo[10];                                                               // 인증수단
//        String cellNo		= aRetInfo[11];																// 핸드폰 번호
//    	String cellCorp	= aRetInfo[12];																// 이동통신사
//    	String certDate	= aRetInfo[13];                                                               // 검증시간
//    	String addVar		= aRetInfo[14];

    	// 사용자 세션생성
		UserVO userVO = new UserVO();
		userVO.setName(name);
		userVO.setMblDn(di);
		request.getSession().setAttribute("userVO", userVO);
		
		String url = (String)request.getSession().getAttribute("url");
		BoardVO searchVO = (BoardVO)request.getSession().getAttribute("searchVO");
		model.addAttribute("searchVO", searchVO);
		model.addAttribute("url", url);
    	
		return "web/cop/selfauth/resultSeed";
	}
	
	/**
	 * (사용자)본인인증 결과 리턴 Sample
	 *
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/cop/bbs/pccPopSeed.do")
	public String pccPopSeed(HttpServletRequest request, ModelMap model, RedirectAttributes redirectAttributes)throws Exception {
		
		return "web/cop/selfauth/pcc_V3_popup_seed";
	}
	
	/**
	 * (사용자)본인인증 결과 Sample
	 *
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/cop/bbs/pccResult.do")
	public String pccResult(HttpServletRequest request, ModelMap model, RedirectAttributes redirectAttributes)throws Exception {
		
		return "web/cop/selfauth/pcc_V3_result_seed";
	}
	
	/**
	 * 게시판 공통코드
	 * @param model
	 * @throws Exception 
	 */
	private void setBBSCommCd(ModelMap model, BoardMasterVO bmVO) throws Exception {
		ComDefaultCodeVO comDefaultCodeVO = new ComDefaultCodeVO();
		// 폴라스토리. 사용자 유형
		if (("BBSMSTR_000000000153").equals(bmVO.getBbsId())) {
			comDefaultCodeVO.setCodeId("ITN003");
			List<?> userTypeList = cmmUseService.selectCmmCodeDetail(comDefaultCodeVO);
			model.addAttribute("userTypeList", userTypeList);
		}
		// 통합신고게시판. 게시판 유형
		if (("BBST03").equals(bmVO.getBbsTyCode())) {
			comDefaultCodeVO.setCodeId("ITN004");
			List<?> reportTyList = cmmUseService.selectCmmCodeDetail(comDefaultCodeVO);
			model.addAttribute("reportTyList", reportTyList);
		}
	}
	
	
	/**
	 * (사용자)게시물을 등록한다.
	 *
	 * @param boardVO
	 * @param board
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value= {"/web/cop/bbs/insertBoardArticle.do" , "/web/cop/bbs/insertBoardArticleAjax.do"})
	public ModelAndView insertBoardArticleWeb(HttpServletRequest request, 
			final MultipartHttpServletRequest multiRequest, 
			@ModelAttribute("searchVO") BoardVO boardVO, 
			@ModelAttribute("bdMstr") BoardMasterVO bdMstr,
			@ModelAttribute("board") Board board, 
			BindingResult bindingResult, 
			SessionStatus status, 
			ModelMap model, 
			RedirectAttributes redirectAttributes,
			@RequestParam Map<String, Object> commandMap ) throws Exception {

		ModelAndView modelAndView = new ModelAndView();
		modelAndView.setViewName("jsonView");
		
		
		if (!EgovDoubleSubmitHelper.checkAndSaveToken("someKey", multiRequest)) {  
			modelAndView.addObject("message", "너무많은 글쓰기가 시도되었습니다.");
			modelAndView.addObject("result", "fail");
			return modelAndView;
		}
		// Start => bbsId를 변조해서 공지사항에 글 등록 방지 처리
		//boardVO.setBbsId("BBSMSTR_000000000651");	// 공지사항
		List<BoardVO> userBbsWriteList = bbsMngService.selectUserBbsWriteList(boardVO);
		System.out.println("boardVO.getBbsId : " + boardVO.getBbsId());
		System.out.println("userBbsWriteList.size() : " + userBbsWriteList.size());
		
		if (userBbsWriteList.size() == 0) {
			// 1:1문의, 불편사항 등 고객이 등록할수있는 게시판 목록이 아닐경우 
			modelAndView.addObject("message", "잘못된 접근입니다.\n관리자에게 문의하세요.");
			modelAndView.addObject("result", "fail");
			return modelAndView;			
		}
		// End
		
		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);

		if (bmVO == null || ("N").equals(bmVO.getUseAt())) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			//return "redirect:/web/main/mainPage.do";
			modelAndView.addObject("result", "no_imposbl");
			return modelAndView;
		}
		
		beanValidator.validate(board, bindingResult);
		if (bindingResult.hasErrors()) {
			// 공통코드 Set
			setBBSCommCd(model, bmVO);
			model.addAttribute("bdMstr", bmVO);
			//return "web/cop/bbs/EgovNoticeRegist";
			modelAndView.addObject("result", "no_validate");
			return modelAndView;
		}
		
		List<FileVO> result = null;
		String atchFileId = "";
		String isThumbFile = "";
		if (("BBST05").equals(bmVO.getBbsTyCode()) || ("BBST06").equals(bmVO.getBbsTyCode())) isThumbFile = "thumbFile";
		final Map<String, MultipartFile> files = multiRequest.getFileMap();
		if (!files.isEmpty()) {
			result = fileUtil.parseFileInf(files, "BBS_", 0, "", "", isThumbFile);
			// 파일 사이즈, 개수, 확장자 체크. model에 체크 오류 메세지 set
			if(!isPosblAtchFile(result, bmVO, model, 0)) {
				// 공통코드 Set
				setBBSCommCd(model, bmVO);
				model.addAttribute("bdMstr", bmVO);
				//return "web/cop/bbs/EgovNoticeRegist";
				modelAndView.addObject("result", "no_atchFile");
				return modelAndView;
			}
			atchFileId = fileMngService.insertFileInfs(result);
		}
		
		board.setAtchFileId(atchFileId);
		board.setBbsId(board.getBbsId());
		board.setNttCn(unscript(board.getNttCn())); // XSS 방지
		String userIp = EgovClntInfo.getClntIP(multiRequest);
		board.setNtcrIp(userIp);
		//게시판 정보 입력
		/*board.setPassword(damoEnc(board.getPassword(), request)); *///비번암호화
		board.setPassword(board.getPassword());
		bbsMngService.insertBoardArticle(board);
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.insert"));
		modelAndView.addObject("result", "success");
		
		
		// 법인폰 알람여부 체크
		JoinSettingVO joinSettingVO = new JoinSettingVO();
		joinSettingVO = egovSiteManagerService.selectAdminNotiDetail();
		// 이메일 체크
		if (joinSettingVO != null && joinSettingVO.getEmailNoti().equals("Y")) {
			// 알림 모듈 추가(게시판 id, 게시판 제목, 게시판 내용)
			mjonNoticeSendUtil.mjonInquiryNoticeSend(board.getBbsId(), board.getNttSj(), board.getNttCn());
		}

		// SMS 체크
		if (joinSettingVO != null && joinSettingVO.getSmsNoti().equals("Y")) {
			String smsTitle = bmVO.getBbsNm()+" 문의";
			// CS관리자 SMS 알림전송
			mjonNoticeSendUtil.csAdminSmsNoticeSend(board.getNttSj(), smsTitle);
		}

		// SLACK 체크
		if (joinSettingVO != null && joinSettingVO.getSlackNoti().equals("Y")) {		
			// Slack 메시지 발송(단순본문)
			String msg = "[문자온] "+ bmVO.getBbsNm() + "- " + board.getNttSj();
			mjonCommon.sendSimpleSlackMsg(msg);
		}
		
		return modelAndView;
	}
	
	
	/**
	 * (사용자)게시물 등록을 위한 등록페이지로 이동한다.
	 *
	 * @param boardVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/member/cop/bbs/addBoardArticle.do")
	public String siteMemberAddBoardArticleWeb(HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, ModelMap model , RedirectAttributes redirectAttributes ) throws Exception {
		
		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);

		boolean authFlag = false;
		List<String> authorities = EgovUserDetailsHelper.getAuthorities();
		// 게시판 쓰기 권한  체크
		for (String authority : authorities) {
			if (authority.equals(bmVO.getWriteAuth())) authFlag = true;
		}
		
		/*model.addAttribute("siteId", siteId);
		String siteFolder = "site/"+siteId ; 
		
		if (bmVO == null || ("N").equals(bmVO.getUseAt()) || !authFlag) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/"+siteId+"/web/main/mainPage.do";
		}*/

		// 공통코드 Set
		setBBSCommCd(model, bmVO);
		
		model.addAttribute("brdMstrVO", bmVO);
		model.addAttribute("board", boardVO);
		/*if(!("linc".equals(siteId) || "klc".equals(siteId)) ){
			SiteManagerVO siteManagerVO = new SiteManagerVO();
			siteManagerVO.setSiteId(siteId);
			setSiteinfo(siteManagerVO, model , request );
			return "web/site/"+siteId+"/"+siteManagerVO.getIsMobile()+"/cop/bbs/EgovNoticeRegist";
		}*/
		
		return "web/cop/bbs/EgovNoticeRegist";
	}
	
	
	/**
	 * (사용자)게시물을 등록한다.
	 *
	 * @param boardVO
	 * @param board
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/web/member/cop/bbs/insertBoardArticle.do")
	public String siteMemberInsertBoardArticleWeb(HttpServletRequest request , final MultipartHttpServletRequest multiRequest, @ModelAttribute("searchVO") BoardVO boardVO, @ModelAttribute("bdMstr") BoardMasterVO bdMstr,
			@ModelAttribute("board") Board board, BindingResult bindingResult, SessionStatus status, ModelMap model, RedirectAttributes redirectAttributes,
			@RequestParam Map<String, Object> commandMap, WordFilterVO wordFilterVO ) throws Exception {

		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);

		/*model.addAttribute("siteId", siteId);
		String siteFolder = "site/"+siteId ; */
		
		boolean authFlag = false;
		List<String> authorities = EgovUserDetailsHelper.getAuthorities();
		// 게시판 쓰기 권한  체크
		for (String authority : authorities) {
			if (authority.equals(bmVO.getWriteAuth())) authFlag = true;
		}
		
		/*if (bmVO == null || ("N").equals(bmVO.getUseAt()) || !authFlag) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/"+siteId+"/web/main/mainPage.do";
		}*/
		
		LoginVO loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		beanValidator.validate(board, bindingResult);
		if (bindingResult.hasErrors()) {
			// 공통코드 Set
			setBBSCommCd(model, bmVO);
			model.addAttribute("bdMstr", bmVO);
			/*if(!("linc".equals(siteId) || "klc".equals(siteId)) ){
				SiteManagerVO siteManagerVO = new SiteManagerVO();
				siteManagerVO.setSiteId(siteId);
				setSiteinfo(siteManagerVO, model , request );
				return "web/site/"+siteId+"/"+siteManagerVO.getIsMobile()+"/cop/bbs/EgovNoticeRegist";
			}*/
			
			return "web/cop/bbs/EgovNoticeRegist";
		}
		
		//필터체크
		//wordFilterVO.setSiteId(siteId);
		wordFilterVO = wordFilterService.selectWordFilterVO(wordFilterVO);
		if(wordFilterVO !=null){
			wordFilterVO.getFilterCn() ;
			board.getNttCn();
		}
		
		List<FileVO> result = null;
		String atchFileId = "";
		String isThumbFile = "";
		if (("BBST05").equals(bmVO.getBbsTyCode()) || ("BBST06").equals(bmVO.getBbsTyCode())) isThumbFile = "thumbFile";
		final Map<String, MultipartFile> files = multiRequest.getFileMap();
		if (!files.isEmpty()) {
			result = fileUtil.parseFileInf(files, "BBS_", 0, "", "", isThumbFile);
			// 파일 사이즈, 개수, 확장자 체크. model에 체크 오류 메세지 set
			if(!isPosblAtchFile(result, bmVO, model, 0)) {
				// 공통코드 Set
				setBBSCommCd(model, bmVO);
				model.addAttribute("bdMstr", bmVO);
				/*if(!("linc".equals(siteId) || "klc".equals(siteId)) ){
					SiteManagerVO siteManagerVO = new SiteManagerVO();
					siteManagerVO.setSiteId(siteId);
					setSiteinfo(siteManagerVO, model , request );
					return "web/site/"+siteId+"/"+siteManagerVO.getIsMobile()+"/cop/bbs/EgovNoticeRegist";
				}*/
				return "web/cop/bbs/EgovNoticeRegist";
			}
			atchFileId = fileMngService.insertFileInfs(result);
		}
		
		if(loginVO == null){ //테스트
			UserVO tempUserVO = new UserVO();
			tempUserVO.setName("testName");
			tempUserVO.setMblDn("testMblDn");
			board.setNtcrNm(tempUserVO.getName());
			board.setMblDn(tempUserVO.getMblDn());
		}else{
			board.setNtcrNm(loginVO.getName());
			board.setFrstRegisterId(loginVO.getUniqId());
		}
		
		
		board.setAtchFileId(atchFileId);
		board.setBbsId(board.getBbsId());
		board.setNttCn(unscript(board.getNttCn())); // XSS 방지
		String userIp = EgovClntInfo.getClntIP(multiRequest);
		board.setNtcrIp(userIp);
		Board resultVO = bbsMngService.insertBoardArticle(board);
		List<EgovMap> mngIdList = bbsAttrbService.selectBBSMngIdList(bmVO); // 게시판 관리자ID 조회
		
		// 사용자 게시글 등록 시 메일 전송
		/*if (userVO != null) {
			for (EgovMap mngId : mngIdList) {
				String mailAdres = (String)mngId.get("emailAdres");
				if (mailAdres != null && !("").equals(mailAdres))
					sendBBSInsertMail((String)mngId.get("emailAdres"), board.getBbsId(), resultVO.getNttId(), bmVO.getBbsNm(), board.getNttSj());
			}
		}*/
		
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.insert"));
		return "redirect:/web/cop/bbsWeb/selectBoardList.do";
	}
	
	/**
	 * (사용자)게시물 수정을 위한 수정페이지로 이동한다.
	 *
	 * @param boardVO
	 * @param vo
	 * @param model
	 * @throws Exception
	 */
	@RequestMapping("/{siteId}/web/member/cop/bbs/forUpdateBoardArticle.do")
	public String siteForUpdateBoardArticleWeb(@PathVariable("siteId") String siteId , HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, ModelMap model , RedirectAttributes redirectAttributes) throws Exception {

		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
		//UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
		
		boolean authFlag = false;
		List<String> authorities = EgovUserDetailsHelper.getAuthorities();
		// 게시판 쓰기 권한  체크
		for (String authority : authorities) {
			if (authority.equals(bmVO.getWriteAuth())) authFlag = true;
		}
		
		model.addAttribute("siteId", siteId);
		String siteFolder = "site/"+siteId ; 
		
		if (bmVO == null || ("N").equals(bmVO.getUseAt()) || !authFlag) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/"+siteId+"/web/main/mainPage.do";
		}
		
		LoginVO loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
		String frstRegisterId = bdVO.getFrstRegisterId(); // 관리자 유무
		bdVO.setMblDn(""); // 화면단으로 모바일키 인증 방지
		
		// 본인글 체크
		if (!frstRegisterId.equals(loginVO.getUniqId())) {
			redirectAttributes.addFlashAttribute("message", "본인글 외에는 수정할 수 없습니다.");
			redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
			redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
			redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
			redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
			redirectAttributes.addAttribute("nttId", boardVO.getNttId());
			return "redirect:/"+siteId+"/web/cop/bbsWeb/selectBoardArticle.do";
		}
		
		// 공통코드 Set
		setBBSCommCd(model, bmVO);

		model.addAttribute("board", bdVO);
		model.addAttribute("brdMstrVO", bmVO);
		/*if(!("linc".equals(siteId) || "klc".equals(siteId)) ){
			SiteManagerVO siteManagerVO = new SiteManagerVO();
			siteManagerVO.setSiteId(siteId);
			setSiteinfo(siteManagerVO, model , request );
			return "web/site/"+siteId+"/"+siteManagerVO.getIsMobile()+"/cop/bbs/EgovNoticeUpdt";
		}*/
		return "web/"+siteFolder+"/cop/bbs/EgovNoticeUpdt";
	}
	
	
	/**
	 * (사용자)게시물에 대한 내용을 수정한다.
	 *
	 * @param boardVO
	 * @param board
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/{siteId}/web/member/cop/bbs/updateBoardArticle.do")
	public String siteUpdateBoardArticleWeb(@PathVariable("siteId") String siteId ,HttpServletRequest request , final MultipartHttpServletRequest multiRequest, @ModelAttribute("searchVO") BoardVO boardVO, @ModelAttribute("bdMstr") BoardMaster bdMstr,
			@ModelAttribute("board") Board board, BindingResult bindingResult, ModelMap model, SessionStatus status, RedirectAttributes redirectAttributes) throws Exception {

		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);

		//UserVO userVO = (UserVO)multiRequest.getSession().getAttribute("userVO"); // 사용자 정보
		LoginVO loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		boolean authFlag = false;
		List<String> authorities = EgovUserDetailsHelper.getAuthorities();
		// 게시판 쓰기 권한  체크
		for (String authority : authorities) {
			if (authority.equals(bmVO.getWriteAuth())) authFlag = true;
		}
		
		
		if (bmVO == null || ("N").equals(bmVO.getUseAt()) || !authFlag) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/"+siteId+"/web/main/mainPage.do";
		}
		
		/*if (userVO == null) { // 인증 필요
			multiRequest.getSession().setAttribute("searchVO", boardVO);
			multiRequest.getSession().setAttribute("url", "/web/cop/bbs/forUpdateBoardArticle.do");
			return "redirect:/web/cop/selfauth/authentication.do";
		}*/

		BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
		String frstRegisterId = bdVO.getFrstRegisterId(); // 글쓴이 아이디
		String mblDn = bdVO.getMblDn();
		bdVO.setMblDn(""); // 화면단으로 모바일키 인증 방지
		
		// 본인글 체크
		if (!bdVO.getFrstRegisterId().equals(loginVO.getUniqId())) {
			redirectAttributes.addFlashAttribute("message", "본인글 외에는 수정할 수 없습니다.");
			redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
			redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
			redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
			redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
			redirectAttributes.addAttribute("nttId", boardVO.getNttId());
			return "redirect:/"+siteId+"/web/cop/bbsWeb/selectBoardArticle.do";
		}
		
		String atchFileId = boardVO.getAtchFileId();

		beanValidator.validate(board, bindingResult);
		if (bindingResult.hasErrors()) {
			// 공통코드 Set
			setBBSCommCd(model, bmVO);
			model.addAttribute("brdMstrVO", bmVO);
			String siteFolder = "site/"+siteId ; 
			if(!("linc".equals(siteId) || "klc".equals(siteId)) ){
				SiteManagerVO siteManagerVO = new SiteManagerVO();
				siteManagerVO.setSiteId(siteId);
				setSiteinfo(siteManagerVO, model , request );
				//return "web/site/theme_"+siteManagerVO.getTheme()+"/"+siteManagerVO.getIsMobile()+"/cop/bbs/EgovNoticeUpdt";
				return "web/site/"+siteId+"/"+siteManagerVO.getIsMobile()+"/cop/bbs/EgovNoticeUpdt";
			}
			return "web/"+siteFolder+"/cop/bbs/EgovNoticeUpdt";
		}

		String isThumbFile = "";
		if (("BBST05").equals(bmVO.getBbsTyCode()) || ("BBST06").equals(bmVO.getBbsTyCode())) isThumbFile = "thumbFile";

		final Map<String, MultipartFile> files = multiRequest.getFileMap();
		if (!files.isEmpty()) {
			if ("".equals(atchFileId)) {
				List<FileVO> result = fileUtil.parseFileInf(files, "BBS_", 0, atchFileId, "", isThumbFile);
				
				if(!isPosblAtchFile(result, bmVO, model, 0)) {
					// 공통코드 Set
					setBBSCommCd(model, bmVO);
					model.addAttribute("brdMstrVO", bmVO);
					String siteFolder = "site/"+siteId ; 
					/*if(!("linc".equals(siteId) || "klc".equals(siteId)) ){
						SiteManagerVO siteManagerVO = new SiteManagerVO();
						siteManagerVO.setSiteId(siteId);
						setSiteinfo(siteManagerVO, model , request );
						return "web/site/"+siteId+"/"+siteManagerVO.getIsMobile()+"/cop/bbs/EgovNoticeUpdt";
						
					}*/
					return "web/"+siteFolder+"/cop/bbs/EgovNoticeUpdt";
				}
				
				atchFileId = fileMngService.insertFileInfs(result);
				board.setAtchFileId(atchFileId);
			} else {
				FileVO fvo = new FileVO();
				fvo.setAtchFileId(atchFileId);
				int cnt = fileMngService.getMaxFileSN(fvo);
				List<FileVO> result = fileUtil.parseFileInf(files, "BBS_", cnt, atchFileId, "", isThumbFile);
				
				if(!isPosblAtchFile(result, bmVO, model, board.getAtchFileCnt())) {
					// 공통코드 Set
					setBBSCommCd(model, bmVO);
					model.addAttribute("brdMstrVO", bmVO);
					String siteFolder = "site/"+siteId ; 
					/*if(!("linc".equals(siteId) || "klc".equals(siteId)) ){
						SiteManagerVO siteManagerVO = new SiteManagerVO();
						siteManagerVO.setSiteId(siteId);
						setSiteinfo(siteManagerVO, model , request );
						return "web/site/"+siteId+"/"+siteManagerVO.getIsMobile()+"/cop/bbs/EgovNoticeUpdt";
					}*/
					return "web/"+siteFolder+"/cop/bbs/EgovNoticeUpdt";
				}
				
				fileMngService.updateFileInfs(result);
			}
		}

		board.setNttCn(unscript(board.getNttCn())); // XSS 방지
		board.setLastUpdusrNm(loginVO.getName());	// 변경이력에 사용
		String userIp = EgovClntInfo.getClntIP(multiRequest);
		board.setNtcrIp(userIp);

		bbsMngService.updateBoardArticle(board);

		redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
		redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
		redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.update"));
		return "redirect:/"+siteId+"/web/cop/bbsWeb/selectBoardList.do";
	}
	
	
	/**
	 * (사용자)게시물에 대한 내용을 삭제한다.
	 *
	 * @param boardVO
	 * @param board
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/{siteId}/web/member/cop/bbs/deleteBoardArticle.do")
	public String siteDeleteBoardArticleWeb(@PathVariable("siteId") String siteId , HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, @ModelAttribute("board") Board board,
			@ModelAttribute("bdMstr") BoardMaster bdMstr, ModelMap model, RedirectAttributes redirectAttributes)throws Exception {

		BoardMasterVO bmVO = new BoardMasterVO();
		bmVO.setBbsId(boardVO.getBbsId());
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);

		//UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
		LoginVO loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		List<String> authorities = EgovUserDetailsHelper.getAuthorities();
		boolean authFlag = false;
		// 게시판 쓰기 권한  체크
		for (String authority : authorities) {
			if (authority.equals(bmVO.getWriteAuth())) authFlag = true;
		}
		
		if (bmVO == null || ("N").equals(bmVO.getUseAt()) || !authFlag) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/"+siteId+"/web/main/mainPage.do";
		}
		
		/*if (loginVO == null) { // 인증 필요
			request.getSession().setAttribute("searchVO", boardVO);
			request.getSession().setAttribute("url", "/web/cop/bbsWeb/selectBoardArticle.do");
			return "redirect:/web/cop/selfauth/authentication.do";
		}
		*/
		BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
		String frstRegisterId = bdVO.getFrstRegisterId(); // 글쓴이
		String mblDn = bdVO.getMblDn();
		bdVO.setMblDn(""); // 화면단으로 모바일키 인증 방지
		
		// 본인글 체크
		if (frstRegisterId.equals("") || !frstRegisterId.equals(loginVO.getUniqId())) {
			redirectAttributes.addFlashAttribute("message", "본인글 외에는 삭제할 수 없습니다.");
			redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
			redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
			redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
			redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
			redirectAttributes.addAttribute("nttId", boardVO.getNttId());
			return "redirect:/"+siteId+"/web/cop/bbsWeb/selectBoardArticle.do";
		}
		
		board.setLastUpdusrNm(loginVO.getName());	// 변경이력에 사용
		String userIp = EgovClntInfo.getClntIP(request);
		board.setNtcrIp(userIp);

		bbsMngService.deleteBoardArticle(board);
		boardVO.setPageIndex(1); //삭제후 첫페이지로 로딩

		redirectAttributes.addAttribute("pageIndex", boardVO.getPageIndex());
		redirectAttributes.addAttribute("searchCnd", boardVO.getSearchCnd());
		redirectAttributes.addAttribute("searchWrd", boardVO.getSearchWrd());
		redirectAttributes.addAttribute("bbsId", boardVO.getBbsId());
		redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.delete"));
		return "redirect:/"+siteId+"/web/cop/bbsWeb/selectBoardList.do";
	}

	private void setSiteinfo(SiteManagerVO siteManagerVO , ModelMap model , HttpServletRequest request) throws Exception{
    	SiteManagerVO tempSiteManagerVO = egovSiteManagerService.selectSiteManagerVO(siteManagerVO) ;
		if(tempSiteManagerVO !=null){
			siteManagerVO.setIsMobile("pc") ;
			siteManagerVO.setTheme(tempSiteManagerVO.getTheme());
		}else{
			siteManagerVO.setTheme("01");
		}
    	WebUtil util = new WebUtil();
		if(util.isMobile(request)){
			siteManagerVO.setIsMobile("mobile");
		}
		model.addAttribute("siteId", siteManagerVO.getSiteId());
		//model.addAttribute("site_path" , "/site/theme_"+siteManagerVO.getTheme()+"/"+siteManagerVO.getIsMobile());
		model.addAttribute("site_path" , "/site/"+siteManagerVO.getSiteId()+"/"+siteManagerVO.getIsMobile());
	}
	
	
	/**
	 * 첨부파일 개수, 사이즈, 확장자 체크
	 * 썸네일, 모델, 기개수, 종류
	 * @param fileList 파일리스트
	 * @param boardMaster
	 * @param model 
	 * @param atchFileCnt 업로드된 파일 수
	 * @param fileSe 파일 구분
	 * @return boolean
	 * @return 체크 오류 메세지 model 'flashMessage' 에 set
	 * @throws Exception 
	 */
	private boolean isPosblAtchFile_tobe(Map<String, MultipartFile> fileList, BoardMaster boardMaster, 
			ModelMap model, int atchFileCnt, String fileSe) throws Exception {
		long posblAtchFileSize = Long.parseLong(boardMaster.getPosblAtchFileSize()) * 1024 * 1024 ;
		int posblAtchFileNumber = Integer.parseInt(boardMaster.getPosblAtchFileNumber());
		String bbsTyCode = boardMaster.getBbsTyCode();
		String flashMessage = "";
		String fileSeMsg = "첨부파일: ";
		String fileExtMsg = "";
		boolean posblAtchFileFlag = true;
		boolean posblAtchFileSizeFlag = true; 
		boolean posblAtchFileExtFlag = true;
		boolean isImg = false;
		
		// 썸네일 시
		if (fileSe.equals("thumb")) {
			posblAtchFileNumber = 1;
			isImg = true;
			fileSeMsg = "썸네일: ";
		}
		
		Iterator<Entry<String, MultipartFile>> itr = fileList.entrySet().iterator();
		MultipartFile file;
		
		int fileCnt = 0;
		while (itr.hasNext()) {
		    Entry<String, MultipartFile> entry = itr.next();
		    file = entry.getValue();
			
			long fileMg = file.getSize();
			String orginFileName = file.getOriginalFilename();
		    int index = orginFileName.lastIndexOf(".");
		    String fileExt = orginFileName.substring(index + 1);
			
			if (fileMg > posblAtchFileSize) posblAtchFileSizeFlag = false;
			
			// 이미지 형식 확인
//			if (("BBST05").equals(bbsTyCode) || ("BBST06").equals(bbsTyCode) || isImg) {
			if (isImg) {
				String[] imgExts = {"gif", "jpg", "bmp", "jpeg", "png"};
				if (ArrayUtils.indexOf(imgExts, fileExt.toLowerCase()) == -1) {
					posblAtchFileExtFlag = false;
					fileExtMsg = "이미지";
				}
			}
			
			// 포토형2 pdf 예외처리 필요
//			if (("ㅁㄴㅇㄹ").equals(bbsTyCode)) {
//				String[] imgExts = {"pdf"};
//				if (ArrayUtils.indexOf(imgExts, fileExt.toLowerCase()) == -1) {
//					posblAtchFileExtFlag = false;
//					fileExtMsg = "PDF";
//				}
//			}
			
			fileCnt++;
		}
		
		if (!posblAtchFileExtFlag) {
			flashMessage += fileSeMsg + fileExtMsg + " 형식의 확장자만 업로드 가능합니다." + "\\n";
			posblAtchFileFlag = false;
		}
		if(!posblAtchFileSizeFlag) {
			flashMessage += fileSeMsg + "파일사이즈가 초과되었습니다. 최대크기 " + posblAtchFileSize + "mb" + "\\n";
			posblAtchFileFlag = false;
		}
		if ((fileCnt+atchFileCnt) > posblAtchFileNumber) {
			flashMessage += fileSeMsg + "파일 개수가 초과되었습니다. 최대개수 " + posblAtchFileNumber + "개" + "\\n";
			posblAtchFileFlag = false;
		}
		
		if (!posblAtchFileFlag) model.addAttribute("message", flashMessage);
		
		return posblAtchFileFlag;
	}
	
	
	//게시판 리스트 엑셀 다운로드
  	@RequestMapping(value="/cop/bbs/bbsExcelDownload.do")
  	public void bbsExcelDownload( BoardVO boardVO, 
  			HttpServletRequest request, 
  			HttpServletResponse response , 
  			ModelMap model) throws Exception {
  		
  		BoardMasterVO vo = new BoardMasterVO();
		vo.setBbsId(boardVO.getBbsId());
		BoardMasterVO master = bbsAttrbService.selectBBSMasterInf(vo);
		
		boardVO.setRecordCountPerPage(100000);
		boardVO.setFirstIndex(0);
  		LoginVO loginVO = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser();
	
  		// 메모리에 100개의 행을 유지합니다. 행의 수가 넘으면 디스크에 적습니다.
  		SXSSFWorkbook wb = new SXSSFWorkbook(100);
  		CellStyle style = wb.createCellStyle();
  		style.setBorderBottom(CellStyle.BORDER_THIN); //테두리 두껍게 
   		style.setBorderLeft(CellStyle.BORDER_THIN);
   		style.setBorderRight(CellStyle.BORDER_THIN);
   		style.setBorderTop(CellStyle.BORDER_THIN);
   		Font font = wb.createFont();
   		font.setBoldweight(Font.BOLDWEIGHT_BOLD);  //글씨 bold
  		Cell cell = null;
  		Row row = null;
  		String fileName ="게시판 리스트";
  		String sheetTitle = ""; 
  		try{
  			Map<String, Object> bbsList = bbsMngService.selectBoardArticles(boardVO, vo.getBbsAttrbCode());
  			{ //화면 리스트
  				sheetTitle = "게시판 리스트(화면)" ; //제목
  				Sheet sheet = wb.createSheet(sheetTitle);
  				row = sheet.createRow(0);
  		        for(int i=0 ; i < bbsExcelValue.length ; i++) {
  	 		       cell = row.createCell(i);
  	 		       cell.setCellStyle(style);
  		 	       cell.setCellValue(bbsExcelValue[i][1]);
  	 		    }
  			    
  		        List<BoardVO> bbsCastList =  (List<BoardVO>)bbsList.get("resultList") ;
  		        for(int i=0; i <  bbsCastList.size(); i++){
  			    	row = sheet.createRow(i+1);
  			    	for(int j=0 ; j < bbsExcelValue.length ; j++) {
  			        	cell = row.createCell(j);
  			        	cell.setCellStyle(style);
  			        	if(j==0) cell.setCellValue(i+1); //번호
  			        	if(j==1) cell.setCellValue(((BoardVO)bbsCastList.get(i)).getNttSj()); //제목
  			        	if(j==2) cell.setCellValue( ((BoardVO)bbsCastList.get(i)).getAtchFileCnt() > 0 ? "있음" : "없음"); //첨부파일유무
  			        	if(j==3) cell.setCellValue( "Y".equals( ((BoardVO)bbsCastList.get(i)).getSecretAt() ) ? "비공개" : "공개" ); //공개여부
  			        	if(j==4) cell.setCellValue(((BoardVO)bbsCastList.get(i)).getFrstRegisterNm()); //작성자
  			        	if(j==5) cell.setCellValue(((BoardVO)bbsCastList.get(i)).getInqireCo()); //조회수
  			        	if(j==6) cell.setCellValue(((BoardVO)bbsCastList.get(i)).getFrstRegisterPnttm()); //작성일
  				 	}
  		        }
  			}
  	    response.setHeader("Set-Cookie", "fileDownload=true; path=/");
  		SimpleDateFormat mSimpleDateFormat = new SimpleDateFormat ( "yyyy_MM_dd_HH_mm_ss", Locale.KOREA );
  		Date currentTime = new Date ();
  		String mTime = mSimpleDateFormat.format ( currentTime );
  		fileName = fileName+"("+mTime+")";
  		
  		response.setHeader("Content-Disposition", String.format("attachment; filename=\""+new String((fileName).getBytes("KSC5601"),"8859_1")+".xlsx"));
  		wb.write(response.getOutputStream());
  	    
  		}catch(Exception e) {
  			response.setHeader("Set-Cookie", "fileDownload=false; path=/");
  			response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate");
  			response.setHeader("Content-Type","text/html; charset=utf-8");
  			OutputStream out = null;
  			try {
  				out = response.getOutputStream();
  				byte[] data = new String("fail..").getBytes();
  				out.write(data, 0, data.length);
  			} catch(Exception ignore) {
  				ignore.printStackTrace();
  			} finally {
  				if(out != null) try { out.close(); } catch(Exception ignore) {}
  			}
  		}finally {
  			// 디스크 적었던 임시파일을 제거합니다.
  			wb.dispose();
  			try { wb.close(); } catch(Exception ignore) {}
  		}
  	}
  	
	//읽음 처리 (버튼 클릭)
	@RequestMapping("/cop/bbs/insertReadYn.do")
    public ModelAndView insertReadYn(@RequestParam("checkList") String[] checkList,
    		RedirectAttributes redirectAttributes , ReadVO readVO,  
    		HttpServletRequest request,
    		@RequestParam Map<String, Object> commandMap,
    		Model model) throws Exception {
		LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
    	ModelAndView modelAndView = new ModelAndView();
    	modelAndView.setViewName("jsonView");
    	for(String id:checkList) {
 		    try{
 		    	String[] idSplit = id.split("\\|");
 		    	id = idSplit[0];
 		    	readVO.setMenuNo("2400000");
 		    	readVO.setReadId(id);
 		    	readVO.setLoginId(user.getId());
 		    	ReadVO readYn = readService.selectReadYn(readVO);
 		    	if(readYn == null) {
 		    		readService.insertReadYn(readVO);
 		    	}
 		    	modelAndView.addObject("result", "success");
 		    }catch(Exception e){
 		    	modelAndView.addObject("result", "fail");
 		    }
 	   }
    	return modelAndView;
    }
		
	
	/**
	 * (사용자)자주하는 질문.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 * TotMngListAjax (통합경영공시)
	 */
	@RequestMapping(value= {"/web/cop/bbs/FaqList.do" , 
			"/web/cop/bbs/FaqDetail.do",
			"/web/cop/bbs/FaqListAjax.do"
			} )
	public String selectFaqListWeb(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model , BoardVO boardVO ,
			RedirectAttributes redirectAttributes) throws Exception {
		
		if("/web/cop/bbs/FaqDetail.do".equals(request.getRequestURI())) { //통합검색시
			boardMasterVO.setUrl("/web/cop/bbs/FaqList.do");
			List<BoardMasterVO>  boardMenuList = bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
			model.addAttribute("boardMenuList", boardMenuList);
			
			if("".equals(boardVO.getBbsId())) { //검색에서 조회시 nttid로 마스터 조회
				BoardMasterVO bmVO = bbsAttrbService.selectBbsIdByNttId(boardVO);
				if (bmVO == null) {
					redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
					return "redirect:/web/main/mainPage.do";
				}
				
				BoardVO searchTotalVO = new BoardVO();
				searchTotalVO.setSearchNttId(boardVO.getNttId());
				searchTotalVO.setBbsId(bmVO.getBbsId());
				model.addAttribute("searchTotalVO", searchTotalVO);
				return "web/cop/bbs/FaqList";
			}	
		}
		
		boardMasterVO.setUrl(request.getRequestURI());
		//메뉴에 등록된 url에 등록된 게시판 조회
		if("/web/cop/bbs/FaqList.do".equals(request.getRequestURI())) { //최초로딩
			List<BoardMasterVO>  boardMenuList = bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
			model.addAttribute("boardMenuList", boardMenuList);
			
			if(0!=boardMenuList.size()) { //원자력 소식은 전체 매뉴 없음.
				BoardMasterVO totalBoardMasterVO = new BoardMasterVO();
				totalBoardMasterVO.setBbsNm("전체");
				boardMenuList.add(0,totalBoardMasterVO) ;
			}
		}
		if("/web/cop/bbs/FaqListAjax.do".equals(request.getRequestURI())) { //게시판 조회
			BoardMasterVO bmVO = new BoardMasterVO();
			PaginationInfo paginationInfo = new PaginationInfo();
			//전체 게시글 불러오기
			Map<String, Object> map = new HashMap<String, Object>();
			if("".equals(boardVO.getBbsId())){ //전체 게시글 불러오기
				if(boardMasterVO.getPageUnit() != 10) {
					bmVO.setPageUnit(boardMasterVO.getPageUnit());
				}
				boardVO.setPageUnit(bmVO.getPageUnit());
				boardVO.setPageSize(bmVO.getPageSize());
				
				paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
				paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
				paginationInfo.setPageSize(boardVO.getPageSize());

				boardMasterVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
				boardMasterVO.setLastIndex(paginationInfo.getLastRecordIndex());
				boardMasterVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
				
				String temp = boardMasterVO.getUrl(); //Url 패턴에 Ajax 구문 삭제처리
				boardMasterVO.setUrl(temp.replace("Ajax", ""));
				map = bbsMngService.selectBoardArticlesWebUrl(boardMasterVO, null);
			}else {
				bmVO.setBbsId(boardVO.getBbsId());
				bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
				//UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
				
				if(boardMasterVO.getPageUnit() != 10) {
					bmVO.setPageUnit(boardMasterVO.getPageUnit());
				}
				
				boardVO.setPageUnit(Integer.parseInt(bmVO.getListNum()));
				boardVO.setPageSize(Integer.parseInt(bmVO.getPageNum()));
				
				paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
				paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
				paginationInfo.setPageSize(boardVO.getPageSize());

				boardVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
				boardVO.setLastIndex(paginationInfo.getLastRecordIndex());
				boardVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
								
				map = bbsMngService.selectBoardArticlesWeb(boardVO, null);
			}
				
			int totCnt = Integer.parseInt((String) map.get("resultCnt"));

			paginationInfo.setTotalRecordCount(totCnt);
			List<BoardVO> resultList = (List<BoardVO>)map.get("resultList");
			for (BoardVO bvo: resultList) {
				Document doc = Jsoup.parse(bvo.getNttCn());
				String text = doc.text();
				bvo.setNttCn2(text);
				
				if(bvo.getAtchFileCnt() > 0) {
					FileVO fileVO = new FileVO();
					fileVO.setAtchFileId(bvo.getAtchFileId());
					List<FileVO> fileList = fileService.selectFileInfs(fileVO);
					bvo.setFileList(fileList);
				}
			}
			
			
			//게시판 마스터 옵션 정보
			BoardMasterVO searchVO = new BoardMasterVO();
			searchVO.setBbsId(boardVO.getBbsId());
			BoardMasterVO bbsMasterInfo = bbsAttrbService.selectBBSMasterInf(searchVO);
			
			model.addAttribute("bbsMasterInfo", bbsMasterInfo);
			model.addAttribute("resultList", resultList);
			model.addAttribute("resultCnt", map.get("resultCnt"));
			model.addAttribute("paginationInfo", paginationInfo);
			return "web/cop/bbs/FaqListAjax";
		}else {
			model.addAttribute("bbsId", "");
		}
		
		return "web/cop/bbs/FaqList";
	}
	
	/**
	 * (사용자) 탭 게시판 통합
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 * 
	 * 
	 * URL 
	 *  /web/cop/bbs/NewsList.do (원자력소식)
	 *  /web/cop/bbs/selectLibList.do (자료실)
	 *  /web/cop/bbs/bussRealList.do (사업실명제)
	 */
	@RequestMapping(value= {"/web/cop/bbs/NewsList.do" 
							, "/web/cop/bbs/NewsListAjax.do"
							, "/web/cop/bbs/LibList.do"
							, "/web/cop/bbs/LibListAjax.do"
							, "/web/cop/bbs/BussRealList.do"
							, "/web/cop/bbs/BussRealListAjax.do"
							, "/web/cop/bbs/TotMngListAjax.do"
							})
	public String selectTabBbsListWeb(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model , BoardVO boardVO ,
			RedirectAttributes redirectAttributes) throws Exception {
		
		//메뉴에 등록된 url 조회
		boardMasterVO.setUrl(request.getRequestURI());
		List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		List<BoardMasterVO>  viewBoardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		for(BoardMasterVO tempVO : viewBoardMenuList) {
			if("N".equals(tempVO.getViewsYn())){;
				boardMasterVO.setViewsYn("N");
				break ;
			}
		}
		
		if(0!=boardMenuList.size()) { //원자력 소식은 전체 매뉴 없음.
			if(!"9420000".equals(((BoardMasterVO)boardMenuList.get(0)).getMenuNo())) { 
				BoardMasterVO totalBoardMasterVO = new BoardMasterVO();
				totalBoardMasterVO.setBbsNm("전체");
				boardMenuList.add(0,totalBoardMasterVO) ;
			}
		}
		
		if(request.getRequestURI().contains("List.do")){ //최초 로딩 매뉴이름가져오기
			MenuManageVO tempMenuManageVO = new MenuManageVO();
			tempMenuManageVO.setUrl(request.getRequestURI());
			MenuManageVO menuManageVO = menuManageService.selectMenuManageUrl(tempMenuManageVO);
			model.addAttribute("menuManageVO", menuManageVO);
		}
		
		if(request.getRequestURI().contains("ListAjax.do") //하단 리스트
			) { //상세 하단 리스트
			BoardMasterVO bmVO = new BoardMasterVO();
			PaginationInfo paginationInfo = new PaginationInfo();
			//전체 게시글 불러오기
			Map<String, Object> map = new HashMap<String, Object>();
			if("".equals(boardVO.getBbsId())){ //전체 게시글 불러오기
				boardVO.setPageUnit(bmVO.getPageUnit());
				boardVO.setPageSize(bmVO.getPageSize());
				
				paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
				paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
				paginationInfo.setPageSize(boardVO.getPageSize());

				boardMasterVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
				boardMasterVO.setLastIndex(paginationInfo.getLastRecordIndex());
				boardMasterVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
				
				String temp = boardMasterVO.getUrl(); //Url 패턴에 Ajax 구문 삭제처리
				boardMasterVO.setUrl(temp.replace("Ajax", ""));
				//전체 게시글 불러오기
				map = bbsMngService.selectBoardArticlesWebUrl(boardMasterVO, null);
			}else {
				bmVO.setBbsId(boardVO.getBbsId());
				bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
				//UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
				
				boardVO.setPageUnit(Integer.parseInt(bmVO.getListNum()));
				boardVO.setPageSize(Integer.parseInt(bmVO.getPageNum()));
				
				paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
				paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
				paginationInfo.setPageSize(boardVO.getPageSize());

				boardVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
				boardVO.setLastIndex(paginationInfo.getLastRecordIndex());
				boardVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
				//메뉴별 게시글 불러오기
				map = bbsMngService.selectBoardArticlesWeb(boardVO, null);
			}
			int totCnt = Integer.parseInt((String) map.get("resultCnt"));

			paginationInfo.setTotalRecordCount(totCnt);
			
			/*모바일 페이지 5개씩 나오게 하기*/
			PaginationInfo paginationInfoMobile = new PaginationInfo();
				paginationInfoMobile.setCurrentPageNo(paginationInfo.getCurrentPageNo());
				paginationInfoMobile.setTotalRecordCount(paginationInfo.getTotalRecordCount());
				paginationInfoMobile.setPageSize(5);
				paginationInfoMobile.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
				model.addAttribute("paginationInfoMobile", paginationInfoMobile);


					
			List<BoardVO> resultList = (List<BoardVO>)map.get("resultList");
			for (BoardVO bvo: resultList) {
				Document doc = Jsoup.parse(bvo.getNttCn());
				String text = doc.text();
				bvo.setNttCn2(text);
			}
			model.addAttribute("resultList", resultList);
			model.addAttribute("resultCnt", map.get("resultCnt"));
			model.addAttribute("paginationInfo", paginationInfo);
			if(request.getRequestURI().contains("/web/cop/bbs/QnaListAjax.do")){ //묻고 답하기
				return "web/cop/bbs/QnaListAjax";
			}
			if(request.getRequestURI().contains("/web/cop/bbs/TotMngListAjax.do")){ //통합경영공시
				model.addAttribute("bmVO", bmVO);
				return "web/cop/bbs/TotMngListAjax";
			}
			
			return "web/cop/bbs/CntBbsListAjax";
		}
		model.addAttribute("boardMenuList", boardMenuList);
		model.addAttribute("detailPage", request.getRequestURI().replace("List", "Detail"));
		return "web/cop/bbs/CntBbsList";
	}
	
	

	
	/**
	 * 
	 * URL 
	 *  /web/cop/bbs/QnaList.do (묻고답하기)
	 */
	@RequestMapping(value= {
			"/web/cop/bbs/QnaListAjax.do"
							})
	public String selectQnaListAjaxWeb(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model , BoardVO boardVO ,
			RedirectAttributes redirectAttributes) throws Exception {
		
		
		LoginVO user = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null;
		String userUniqId = user == null ? "" : EgovStringUtil.isNullToString(user.getUniqId());
		
		if("".equals(userUniqId)) {
			redirectAttributes.addFlashAttribute("message", "로그인 후 이용해 주세요.");
			return "redirect:/web/user/login/login.do";
		}
		
		boardMasterVO.setFrstRegisterId(userUniqId);
		boardVO.setFrstRegisterId(userUniqId);
		
		boardMasterVO.setUrl(request.getRequestURI());
		
		/*
		//메뉴에 등록된 url 조회
		
		List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		List<BoardMasterVO>  viewBoardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		for(BoardMasterVO tempVO : viewBoardMenuList) {
			if("N".equals(tempVO.getViewsYn())){;
				boardMasterVO.setViewsYn("N");
				break ;
			}
		}
		
		if(0!=boardMenuList.size()) { //묻고답하기
			BoardMasterVO totalBoardMasterVO = new BoardMasterVO();
			totalBoardMasterVO.setBbsNm("전체");
			boardMenuList.add(0,totalBoardMasterVO) ;
		}
		*/
		//상세 하단 리스트
		BoardMasterVO bmVO = new BoardMasterVO();
		PaginationInfo paginationInfo = new PaginationInfo();
		
		if("".equals(boardMasterVO.getSearchSortCnd())){ //최초조회시 최신것 조회List
			boardMasterVO.setSearchSortCnd("nttId");
			boardMasterVO.setSearchSortOrd("desc");
		}
		//전체 게시글 불러오기
		Map<String, Object> map = new HashMap<String, Object>();
		//if("".equals(boardVO.getBbsId())){ //전체 게시글 불러오기
		if("".equals(boardVO.getSeCmmnCdId())){ //전체 게시글 불러오기
			if(boardMasterVO.getPageUnit() != 10) {
				bmVO.setPageUnit(boardMasterVO.getPageUnit());
			}
			boardVO.setPageUnit(bmVO.getPageUnit());
			boardVO.setPageSize(bmVO.getPageSize());
			
			paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
			paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
			paginationInfo.setPageSize(boardVO.getPageSize());

			boardMasterVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
			boardMasterVO.setLastIndex(paginationInfo.getLastRecordIndex());
			boardMasterVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
			
			String temp = boardMasterVO.getUrl(); //Url 패턴에 Ajax 구문 삭제처리
			boardMasterVO.setUrl(temp.replace("Ajax", ""));
			
			//답변 조회
			CommentVO commentVO = new CommentVO();
			commentVO.setBbsId(boardVO.getBbsId());
			List<?> commentList = egovArticleCommentService.selectArticleCommentListAllList(commentVO);
			
			int commentCnt = commentList.size();
			model.addAttribute("commentCnt", commentCnt);
			model.addAttribute("commentList", commentList);
			
			//전체 게시글 불러오기
			map = bbsMngService.selectBoardArticlesWebUrl(boardMasterVO, null);
		}else {
			//bmVO.setBbsId(boardVO.getBbsId());
			bmVO.setBbsId(boardVO.getSeCmmnCdId());
			boardVO.setBbsId(boardVO.getSeCmmnCdId());
			
			bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
			//UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
			
			if(boardMasterVO.getPageUnit() != 10) {
				bmVO.setPageUnit(boardMasterVO.getPageUnit());
			}
			
			boardVO.setPageUnit(Integer.parseInt(bmVO.getListNum()));
			boardVO.setPageSize(Integer.parseInt(bmVO.getPageNum()));
			
			paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
			paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
			paginationInfo.setPageSize(boardVO.getPageSize());

			boardVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
			boardVO.setLastIndex(paginationInfo.getLastRecordIndex());
			boardVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
			
			//답변 조회
			CommentVO commentVO = new CommentVO();
			commentVO.setBbsId(boardVO.getBbsId());
			List<CommentVO> commentList = egovArticleCommentService.selectArticleCommentListAllList(commentVO);
			
			int commentCnt = commentList.size();
			model.addAttribute("commentCnt", commentCnt);
			model.addAttribute("commentList", commentList);
			
			//메뉴별 게시글 불러오기
			map = bbsMngService.selectBoardArticlesWeb(boardVO, null);
		}
		int totCnt = Integer.parseInt((String) map.get("resultCnt"));

		paginationInfo.setTotalRecordCount(totCnt);
		
		List<BoardVO> resultList = (List<BoardVO>)map.get("resultList");
		for (BoardVO bvo: resultList) {
			Document doc = Jsoup.parse(bvo.getNttCn());
			String text = doc.text();
			bvo.setNttCn2(text);
		}
		model.addAttribute("resultList", resultList);
		model.addAttribute("resultCnt", totCnt);
		model.addAttribute("paginationInfo", paginationInfo);
		if(request.getRequestURI().contains("/web/cop/bbs/QnaListAjax.do")){ //묻고 답하기
			return "web/cop/bbs/QnaListAjax";
		}
		
		return "web/cop/bbs/QnaListAjax";
	}
	
	/**
	 * 
	 * URL 
	 *  /web/cop/bbs/NoticeList.do (공지사항)
	 */
	@RequestMapping(value= {"web/cop/bbs/NoticeList.do"})
	public String selectNoticeListWeb(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model , BoardVO boardVO ,
			RedirectAttributes redirectAttributes) throws Exception {
		
		//메뉴에 등록된 url 조회
		boardMasterVO.setUrl(request.getRequestURI());
		List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		//List<BoardMasterVO>  viewBoardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		for(BoardMasterVO tempVO : boardMenuList) {
			if("N".equals(tempVO.getViewsYn())){;
				boardMasterVO.setViewsYn("N");
				break ;
			}
		}
		
		//게시판 메뉴 리스트
		if(0!=boardMenuList.size()) { //공지사항
			BoardMasterVO totalBoardMasterVO = new BoardMasterVO();
			totalBoardMasterVO.setBbsNm("전체");
			boardMenuList.add(0,totalBoardMasterVO) ;
		}		
			
		model.addAttribute("boardMenuList", boardMenuList);
		model.addAttribute("detailPage", request.getRequestURI().replace("List", "Detail"));		
		
		return "web/cop/bbs/NoticeList";
	}
	
	/**
	 * 
	 * URL 
	 *  /web/cop/bbs/SuggestList.do (불편신고)
	 */
	@RequestMapping(value= {"web/cop/bbs/SuggestList.do"})
	public String selectSuggestListWeb(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model , BoardVO boardVO ,
			RedirectAttributes redirectAttributes) throws Exception {
		
		LoginVO user = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null;
		String userUniqId = user == null ? "" : EgovStringUtil.isNullToString(user.getUniqId());
		
		if("".equals(userUniqId)) {
			redirectAttributes.addFlashAttribute("message", "로그인 후 이용해 주세요.");
			return "redirect:/web/user/login/login.do";
		}
		
		//메뉴에 등록된 url 조회
		boardMasterVO.setUrl(request.getRequestURI());
		List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		//List<BoardMasterVO>  viewBoardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		for(BoardMasterVO tempVO : boardMenuList) {
			if("N".equals(tempVO.getViewsYn())){;
				boardMasterVO.setViewsYn("N");
				break ;
			}
		}
		
		//게시판 메뉴 리스트
		if(0!=boardMenuList.size()) { //공지사항
			BoardMasterVO totalBoardMasterVO = new BoardMasterVO();
			totalBoardMasterVO.setBbsNm("전체");
			boardMenuList.add(0,totalBoardMasterVO) ;
		}		
			
		model.addAttribute("boardMenuList", boardMenuList);
		model.addAttribute("detailPage", request.getRequestURI().replace("List", "Detail"));		
		
		return "web/cop/bbs/SuggestList";
	}
	
	/**
	 * 
	 * URL 
	 *  /web/cop/bbs/SuggestList.do (불편신고)
	 */
	@RequestMapping(value= {
			"/web/cop/bbs/SuggestListAjax.do"
							})
	public String selectSuggestListAjaxWeb(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model , BoardVO boardVO ,
			RedirectAttributes redirectAttributes) throws Exception {
		
		
		LoginVO user = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null;
		String userUniqId = user == null ? "" : EgovStringUtil.isNullToString(user.getUniqId());
		
		if("".equals(userUniqId)) {
			redirectAttributes.addFlashAttribute("message", "로그인 후 이용해 주세요.");
			return "redirect:/web/user/login/login.do";
		}
		
		boardMasterVO.setFrstRegisterId(userUniqId);
		boardVO.setFrstRegisterId(userUniqId);
		
		boardMasterVO.setUrl(request.getRequestURI());
		
		/*
		//메뉴에 등록된 url 조회
		
		List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		List<BoardMasterVO>  viewBoardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		for(BoardMasterVO tempVO : viewBoardMenuList) {
			if("N".equals(tempVO.getViewsYn())){;
				boardMasterVO.setViewsYn("N");
				break ;
			}
		}
		
		if(0!=boardMenuList.size()) { //묻고답하기
			BoardMasterVO totalBoardMasterVO = new BoardMasterVO();
			totalBoardMasterVO.setBbsNm("전체");
			boardMenuList.add(0,totalBoardMasterVO) ;
		}
		*/
		//상세 하단 리스트
		BoardMasterVO bmVO = new BoardMasterVO();
		PaginationInfo paginationInfo = new PaginationInfo();
		
		if("".equals(boardMasterVO.getSearchSortCnd())){ //최초조회시 최신것 조회List
			boardMasterVO.setSearchSortCnd("nttId");
			boardMasterVO.setSearchSortOrd("desc");
		}
		//전체 게시글 불러오기
		Map<String, Object> map = new HashMap<String, Object>();
		//if("".equals(boardVO.getBbsId())){ //전체 게시글 불러오기
		if("".equals(boardVO.getSeCmmnCdId())){ //전체 게시글 불러오기
			if(boardMasterVO.getPageUnit() != 10) {
				bmVO.setPageUnit(boardMasterVO.getPageUnit());
			}
			boardVO.setPageUnit(bmVO.getPageUnit());
			boardVO.setPageSize(bmVO.getPageSize());
			
			paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
			paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
			paginationInfo.setPageSize(boardVO.getPageSize());

			boardMasterVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
			boardMasterVO.setLastIndex(paginationInfo.getLastRecordIndex());
			boardMasterVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
			
			String temp = boardMasterVO.getUrl(); //Url 패턴에 Ajax 구문 삭제처리
			boardMasterVO.setUrl(temp.replace("Ajax", ""));
			
			//답변 조회
			CommentVO commentVO = new CommentVO();
			commentVO.setBbsId(boardVO.getBbsId());
			List<?> commentList = egovArticleCommentService.selectArticleCommentListAllList(commentVO);
			
			int commentCnt = commentList.size();
			model.addAttribute("commentCnt", commentCnt);
			model.addAttribute("commentList", commentList);
			
			//전체 게시글 불러오기
			map = bbsMngService.selectBoardArticlesWebUrl(boardMasterVO, null);
		}else {
			//bmVO.setBbsId(boardVO.getBbsId());
			bmVO.setBbsId(boardVO.getSeCmmnCdId());
			boardVO.setBbsId(boardVO.getSeCmmnCdId());
			
			bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
			//UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
			
			if(boardMasterVO.getPageUnit() != 10) {
				bmVO.setPageUnit(boardMasterVO.getPageUnit());
			}
			
			boardVO.setPageUnit(Integer.parseInt(bmVO.getListNum()));
			boardVO.setPageSize(Integer.parseInt(bmVO.getPageNum()));
			
			paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
			paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
			paginationInfo.setPageSize(boardVO.getPageSize());

			boardVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
			boardVO.setLastIndex(paginationInfo.getLastRecordIndex());
			boardVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
			
			//답변 조회
			CommentVO commentVO = new CommentVO();
			commentVO.setBbsId(boardVO.getBbsId());
			List<CommentVO> commentList = egovArticleCommentService.selectArticleCommentListAllList(commentVO);
			
			int commentCnt = commentList.size();
			model.addAttribute("commentCnt", commentCnt);
			model.addAttribute("commentList", commentList);
			
			//메뉴별 게시글 불러오기
			map = bbsMngService.selectBoardArticlesWeb(boardVO, null);
		}
		int totCnt = Integer.parseInt((String) map.get("resultCnt"));

		paginationInfo.setTotalRecordCount(totCnt);
		
		List<BoardVO> resultList = (List<BoardVO>)map.get("resultList");
		for (BoardVO bvo: resultList) {
			Document doc = Jsoup.parse(bvo.getNttCn());
			String text = doc.text();
			bvo.setNttCn2(text);
		}
		model.addAttribute("resultList", resultList);
		model.addAttribute("resultCnt", totCnt);
		model.addAttribute("paginationInfo", paginationInfo);
		
		return "web/cop/bbs/SuggestListAjax";
	}
	
	
	/**
	 * 
	 * URL 
	 *  /web/cop/bbs/QnaList.do (묻고답하기)
	 */
	@RequestMapping(value= {
			"web/cop/bbs/QnaList.do"
			
							})
	public String selectQnaListWeb(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model , BoardVO boardVO ,
			RedirectAttributes redirectAttributes) throws Exception {
		
		LoginVO user = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null;
		String userUniqId = user == null ? "" : EgovStringUtil.isNullToString(user.getUniqId());
		
		if("".equals(userUniqId)) {
			//redirectAttributes.addFlashAttribute("message", "문자온 서비스는 로그인 후 이용 가능합니다.");
			return "redirect:/web/user/login/login.do";
		}
		
		boardMasterVO.setFrstRegisterId(userUniqId);
		boardVO.setFrstRegisterId(userUniqId);
		
		//메뉴에 등록된 url 조회
		boardMasterVO.setUrl(request.getRequestURI());
		List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		//List<BoardMasterVO>  viewBoardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		for(BoardMasterVO tempVO : boardMenuList) {
			if("N".equals(tempVO.getViewsYn())){;
				boardMasterVO.setViewsYn("N");
				break ;
			}
		}
		
		if(0!=boardMenuList.size()) { //묻고답하기
			BoardMasterVO totalBoardMasterVO = new BoardMasterVO();
			totalBoardMasterVO.setBbsNm("전체");
			boardMenuList.add(0,totalBoardMasterVO) ;
		}
			
		model.addAttribute("boardMenuList", boardMenuList);
		model.addAttribute("detailPage", request.getRequestURI().replace("List", "Detail"));
		
		return "web/cop/bbs/QnaList";
	}
	
	/**
	 * 
	 * URL 
	 *  /web/cop/bbs/NoticeListAjax.do (공지사항 - 내용)
	 */
	@RequestMapping(value= {			
							"/web/cop/bbs/NoticeListAjax.do"
							})
	public String selectNoticeListAjaxWeb(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model , BoardVO boardVO
			) throws Exception {
		
		//step1.현재 url을 저장한다.(?)
		//step2.현재 url의 게시판 리스트 정보를 가져온다.
		//step3.현재 url의 게시판 리스트 정보를 가져온다.
		
		boardMasterVO.setUrl(request.getRequestURI());
		
		//메뉴에 등록된 url 조회
		/*
		boardMasterVO.setUrl(request.getRequestURI());
		List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		List<BoardMasterVO>  viewBoardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		for(BoardMasterVO tempVO : viewBoardMenuList) {
			if("N".equals(tempVO.getViewsYn())){;
				boardMasterVO.setViewsYn("N");
				break ;
			}
		}
		
		//게시판 메뉴 리스트
		if(0!=boardMenuList.size()) { //공지사항
			BoardMasterVO totalBoardMasterVO = new BoardMasterVO();
			totalBoardMasterVO.setBbsNm("전체");
			boardMenuList.add(0,totalBoardMasterVO) ;
		}
		*/
		
		
		BoardMasterVO bmVO = new BoardMasterVO();
		PaginationInfo paginationInfo = new PaginationInfo();
		
		if("".equals(boardMasterVO.getSearchSortCnd())){ //최초조회시 최신것 조회List
			boardMasterVO.setSearchSortCnd("nttId");
			boardMasterVO.setSearchSortOrd("desc");
		}
		
		
		//전체 게시글 불러오기
		Map<String, Object> map = new HashMap<String, Object>();
		if("".equals(boardVO.getSeCmmnCdId())){ //전체 게시글 불러오기
		//if("".equals(boardVO.getBbsId())){ //전체 게시글 불러오기
			if(boardMasterVO.getPageUnit() != 10) {
				bmVO.setPageUnit(boardMasterVO.getPageUnit());
			}
			boardVO.setPageUnit(bmVO.getPageUnit());
			boardVO.setPageSize(bmVO.getPageSize());
			
			paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
			paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
			paginationInfo.setPageSize(boardVO.getPageSize());

			boardMasterVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
			boardMasterVO.setLastIndex(paginationInfo.getLastRecordIndex());
			boardMasterVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
			
			String temp = boardMasterVO.getUrl(); //Url 패턴에 Ajax 구문 삭제처리
			boardMasterVO.setUrl(temp.replace("Ajax", ""));
			
			//전체 게시글 불러오기
			map = bbsMngService.selectBoardArticlesWebUrl(boardMasterVO, null);
		}else {
			
			System.out.println("boardVO.getSeCmmnCdId()");
			System.out.println(boardVO.getSeCmmnCdId());
			
			//bmVO.setBbsId(boardVO.getBbsId());
			bmVO.setBbsId(boardVO.getSeCmmnCdId());
			boardVO.setBbsId(boardVO.getSeCmmnCdId());
			
			bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
			//UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
			
			if(boardMasterVO.getPageUnit() != 10) {
				bmVO.setPageUnit(boardMasterVO.getPageUnit());
			}
			
			boardVO.setPageUnit(Integer.parseInt(bmVO.getListNum()));
			boardVO.setPageSize(Integer.parseInt(bmVO.getPageNum()));
			
			paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
			paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
			paginationInfo.setPageSize(boardVO.getPageSize());

			boardVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
			boardVO.setLastIndex(paginationInfo.getLastRecordIndex());
			boardVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
			
			//메뉴별 게시글 불러오기
			map = bbsMngService.selectBoardArticlesWeb(boardVO, null);
		}
		int totCnt = Integer.parseInt((String) map.get("resultCnt"));

		paginationInfo.setTotalRecordCount(totCnt);
		
		List<BoardVO> resultList = (List<BoardVO>)map.get("resultList");
		for (BoardVO bvo: resultList) {
			Document doc = Jsoup.parse(bvo.getNttCn());
			String text = doc.text();
			bvo.setNttCn2(text);
		}
		model.addAttribute("resultList", resultList);
		model.addAttribute("resultCnt", map.get("resultCnt"));
		model.addAttribute("paginationInfo", paginationInfo);
		
		return "web/cop/bbs/NoticeListAjax";
	}
	
	/**
	 * (사용자)이벤트 게시판(포토형 탭게시판).
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 * 
	 */
	@RequestMapping(value= {
			"/web/cop/bbs/EventList.do" 
			} )
	public String selectEventListWeb(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model , BoardVO boardVO ,
			RedirectAttributes redirectAttributes) throws Exception {
		
		boardMasterVO.setUrl(request.getRequestURI());
		//메뉴에 등록된 url에 등록된 게시판 조회
		if("/web/cop/bbs/EventList.do".equals(request.getRequestURI())) { //최초로딩
			List<BoardMasterVO>  boardMenuList = bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
			model.addAttribute("boardMenuList", boardMenuList);

			if(0!=boardMenuList.size()) {
				//BoardMasterVO totalBoardMasterVO1 = new BoardMasterVO();
				//totalBoardMasterVO1.setBbsNm("전체");
				//totalBoardMasterVO1.setBbsId(boardMenuList.get(0).getBbsId());
				//boardMenuList.add(0,totalBoardMasterVO1) ;
			
				BoardMasterVO totalBoardMasterVO2 = new BoardMasterVO();
				totalBoardMasterVO2.setBbsNm("종료된 이벤트");
				totalBoardMasterVO2.setBbsId(boardMenuList.get(0).getBbsId());
				boardMenuList.add(boardMenuList.size(),totalBoardMasterVO2) ;
				
			}			
		}
		
		//model.addAttribute("bbsId", "");
		model.addAttribute("detailPage", request.getRequestURI().replace("List", "Detail"));
		
		return "web/cop/bbs/EventList";
	}
	

	/**
	 * (사용자)이벤트 게시판(포토형 탭게시판).
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 * 
	 */
	@RequestMapping(value= { 
			"/web/cop/bbs/EventListAjax.do"
			} )
	public String selectEventListAjaxWeb(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model , BoardVO boardVO
			) throws Exception {
		
		
		boardMasterVO.setUrl(request.getRequestURI());

		

		BoardMasterVO bmVO = new BoardMasterVO();
		PaginationInfo paginationInfo = new PaginationInfo();
		//전체 게시글 불러오기
		Map<String, Object> map = new HashMap<String, Object>();
		
		//종료
		if("End".equals(boardVO.getBbsId())) {
			//}else if("End".equals(boardVO.getSeCmmnCdId())) {
				//boardVO.setBbsId("BBSMSTR_000000000731");
				//bmVO.setBbsId(boardVO.getBbsId());
				
				boardVO.setBbsId(boardVO.getSeCmmnCdId());
				bmVO.setBbsId(boardVO.getSeCmmnCdId());
				
				bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
				//UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
				
				if(boardMasterVO.getPageUnit() != 10) {
					bmVO.setPageUnit(boardMasterVO.getPageUnit());
				}
				
				boardVO.setPageUnit(Integer.parseInt(bmVO.getListNum()));
				boardVO.setPageSize(Integer.parseInt(bmVO.getPageNum()));
				
				paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
				paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
				paginationInfo.setPageSize(boardVO.getPageSize());

				boardVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
				boardVO.setLastIndex(paginationInfo.getLastRecordIndex());
				boardVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
								
				/*map = bbsMngService.selectBoardArticlesWeb(boardVO, null);*/
				map = bbsMngService.selectBoardArticlesWebEventEnd(boardVO, null);
				
			}else if("Ing".equals(boardVO.getBbsId())) {
				//bmVO.setBbsId(boardVO.getBbsId());
				boardVO.setBbsId(boardVO.getSeCmmnCdId());
				bmVO.setBbsId(boardVO.getSeCmmnCdId());
				
				bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
				//UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
				
				if(boardMasterVO.getPageUnit() != 10) {
					bmVO.setPageUnit(boardMasterVO.getPageUnit());
				}
				
				boardVO.setPageUnit(Integer.parseInt(bmVO.getListNum()));
				boardVO.setPageSize(Integer.parseInt(bmVO.getPageNum()));
				
				paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
				paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
				paginationInfo.setPageSize(boardVO.getPageSize());

				boardVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
				boardVO.setLastIndex(paginationInfo.getLastRecordIndex());
				boardVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
								
				map = bbsMngService.selectBoardArticlesWebEvent(boardVO, null);
				
			}else {	//전체
				//if("".equals(boardVO.getBbsId())){ //전체 게시글 불러오기
				if(boardMasterVO.getPageUnit() != 10) {
					bmVO.setPageUnit(boardMasterVO.getPageUnit());
				}
				boardVO.setPageUnit(bmVO.getPageUnit());
				boardVO.setPageSize(bmVO.getPageSize());
				
				paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
				paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
				paginationInfo.setPageSize(boardVO.getPageSize());

				boardMasterVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
				boardMasterVO.setLastIndex(paginationInfo.getLastRecordIndex());
				boardMasterVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
				
				String temp = boardMasterVO.getUrl(); //Url 패턴에 Ajax 구문 삭제처리
				boardMasterVO.setUrl(temp.replace("Ajax", ""));
				/*map = bbsMngService.selectBoardArticlesWebUrl(boardMasterVO, null);*/
				map = bbsMngService.selectBoardArticlesWebUrlEventAll(boardMasterVO, null);
				
			}
			
		int totCnt = Integer.parseInt((String) map.get("resultCnt"));

		paginationInfo.setTotalRecordCount(totCnt);
		List<BoardVO> resultList = (List<BoardVO>)map.get("resultList");
		for (BoardVO bvo: resultList) {
			Document doc = Jsoup.parse(bvo.getNttCn());
			String text = doc.text();
			bvo.setNttCn2(text);
			
			if(bvo.getAtchFileCnt() > 0) {
				FileVO fileVO = new FileVO();
				fileVO.setAtchFileId(bvo.getAtchFileId());
				List<FileVO> fileList = fileService.selectFileInfs(fileVO);
				bvo.setFileList(fileList);
			}
		}
		
		if (("BBST05").equals(bmVO.getBbsTyCode())){ //사진게시판 8개씩 9개조회후 9개면 더보기
			if(boardMasterVO.getPageUnit() != 9) {
				bmVO.setPageUnit(boardMasterVO.getPageUnit());
			}
			boardVO.setRecordCountPerPage(9); //리스트 수 
			boardVO.setFirstIndex( (boardVO.getPageIndex()-1)*9); //offset
			paginationInfo.setRecordCountPerPage(boardVO.getRecordCountPerPage()); //웹 접근성 획득 후 롤백
		}
		
		if("BBST05".equals(bmVO.getBbsTyCode())){
			boardVO.setSearchSortCnd("FRST_REGIST_PNTTM");
			boardVO.setSearchSortOrd("desc");
		}
		
		//게시판 마스터 옵션 정보
		BoardMasterVO searchVO = new BoardMasterVO();
		searchVO.setBbsId(boardVO.getBbsId());
		BoardMasterVO bbsMasterInfo = bbsAttrbService.selectBBSMasterInf(searchVO);
		
		model.addAttribute("bbsMasterInfo", bbsMasterInfo);
		model.addAttribute("resultList", resultList);
		model.addAttribute("resultCnt", totCnt);
		model.addAttribute("paginationInfo", paginationInfo);
		return "web/cop/bbs/EventListAjax";
		
		
		//model.addAttribute("detailPage", request.getRequestURI().replace("List", "Detail"));
		
		//return "web/cop/bbs/EventList";
	}
	
	/**
	 * (사용자)게시물에 대한 상세 정보를 조회한다.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value= {
				"/web/cop/bbs/EventDetail.do"
				} )
	public String selectBoardEventDetailWeb(HttpServletRequest request, @ModelAttribute("searchVO") BoardVO boardVO, 
			BoardMasterVO masterVO,
			ModelMap model,
			@RequestParam Map<String, Object> commandMap,
			RedirectAttributes redirectAttributes) throws Exception {
		
		
		//XSS 태그 필터링 처리
		boardVO.setBbsId(unscript(boardVO.getBbsId()));
		boardVO.setSeCmmnCdId(unscript(boardVO.getSeCmmnCdId()));
		boardVO.setFrstRegisterId(unscript(boardVO.getFrstRegisterId()));
		boardVO.setSearchBgnDe(unscript(boardVO.getSearchBgnDe()));
		boardVO.setSearchEndDe(unscript(boardVO.getSearchEndDe()));
		boardVO.setSearchSortCnd(unscript(boardVO.getSearchSortCnd()));
		boardVO.setSearchSortOrd(unscript(boardVO.getSearchSortOrd()));
		boardVO.setSearchCnd(unscript(boardVO.getSearchCnd()));
		boardVO.setSearchWrd(unscript(boardVO.getSearchWrd()));
		
		
		BoardMasterVO bmVO = new BoardMasterVO();
		if("".equals(boardVO.getBbsId())) { //검색에서 조회시 nttid로 마스터 조회
			bmVO = bbsAttrbService.selectBbsIdByNttId(boardVO);
			if (bmVO == null) {
				redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
				return "redirect:/web/main/mainPage.do";
			}
			boardVO.setBbsId(bmVO.getBbsId());
		}else {
			bmVO.setBbsId(boardVO.getBbsId());
		}
			
		bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
		if("/web/cop/bbs/NewsDetail.do".equals(request.getRequestURI()) || "/web/contentBbsDetail.do".equals(request.getRequestURI())) { //원자력소식 수정삭제등록 없음.
			bmVO.setWebChgYn("N");
			model.addAttribute("masterVO", masterVO);
		}
		
		BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
		if (bmVO == null || ("N").equals(bmVO.getUseAt())) {
			redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.imposbl"));
			return "redirect:/web/main/mainPage.do";
		}
		
		{//묻고답하기 권한체크
			boolean passChk = false; 
			if("9530000".equals(bmVO.getMenuNo())) {
				LoginVO loginVO  =  new LoginVO();
				if(!"anonymousUser".equals(EgovUserDetailsHelper.getAuthenticatedUser() )) { //최고 관리자면 바로수정
		         	loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser();
		         	if("ROLE_ADMIN".equals(loginVO.getAuthority())){
		         		passChk = true;
		         	}else { //일반관리자
		         		bmVO.setBbsMngId(loginVO.getId());
		         		if( bbsAttrbService.selectBBSMngInfCnt(bmVO) > 0 ) { //게시판 관리자 조회
		         			passChk = true;
		        		}
		         	}
		        }else{//방문자 세션있는방문자
		        	UserVO userVO = new UserVO();
		    		if(request.getSession().getAttribute("userVO") != null) {
		    			userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
		    			if(userVO.getMblDn().equals(bdVO.getMblDn())) {
		    				passChk = true;
		    			}
		    		}	
		        }
				if(!"T".equals(bdVO.getSecretAt())){
					if(!passChk){
						if("".equals(boardVO.getPassword())) {
							redirectAttributes.addFlashAttribute("message", "패스워드를 넣어주세요");
							return "redirect:/web/cop/bbs/QnaList.do";
						}else {
							if(!damoDec(bdVO.getPassword(), request).equals(boardVO.getPassword())) {
								redirectAttributes.addFlashAttribute("message", "패스워드가 맞지 않습니다.");
								if("9530000".equals(bmVO.getMenuNo())) {
									return "redirect:/web/cop/bbs/QnaList.do";
								}else {
									return "redirect:/web/cop/bbsWeb/selectBoardList.do?bbsId="+boardVO.getBbsId();
								}
							}
						}
					}
				}
				
			}
		}
		
		// 조회수 증가 여부 지정
		boardVO.setPlusCount(true);
		bbsMngService.updateBoardArticleInqireCo(boardVO);
		
		boardVO.setMblDn(bdVO.getMblDn());
		
		// 위/아래 게시글 번호, 제목 조회
		EgovMap upDownNttid =  bbsMngService.getUpDownNttIdNSj(boardVO);
		
		//게시판 마스터 옵션 정보
		BoardMasterVO searchVO = new BoardMasterVO();
		searchVO.setBbsId(boardVO.getBbsId());
		BoardMasterVO resultBbsMsInfo = bbsAttrbService.selectBBSMasterInf(searchVO);
		
		//답변글 리스트
		if(bdVO.getAnswerCnt() > 0) {
			List<BoardVO> answerList = bbsMngService.selectBoardAnswerList(bdVO);
			model.addAttribute("answerList", answerList);
		}
		
		System.out.println("boardVO.toString()");
		System.out.println("getNtceBgnde");
		System.out.println(bdVO.getNiceFailUrl());
		System.out.println(bdVO.getNiceSuccUrl());
		
		if ("1".equals(bdVO.getNiceFailUrl()) 			//s-date
				&& "1".equals(bdVO.getNiceSuccUrl())	//e-date
				) {
			bmVO.setBbsNm("진행전");
		}else if ("-1".equals(bdVO.getNiceFailUrl()) 			//s-date
				&& "-1".equals(bdVO.getNiceSuccUrl())	//e-date
				) {
			bmVO.setBbsNm("종료");
		}else {
			bmVO.setBbsNm("진행중");
		}
		
		
		model.addAttribute("nextNttIdNSj", upDownNttid.get("nextNttIdNSj"));
		model.addAttribute("prevNttIdNSj", upDownNttid.get("prevNttIdNSj"));
		model.addAttribute("result", bdVO);
		model.addAttribute("brdMstrVO", bmVO);
		model.addAttribute("resultBbsMsInfo", resultBbsMsInfo);
		
		CommentVO commentVO = new CommentVO();
		commentVO.setBbsId(boardVO.getBbsId());		//게시판ID
		commentVO.setNttId(boardVO.getNttId());		//게시글ID
		
		//댓글 조회
		List<?> resultList = egovArticleCommentService.selectArticleCommentListAll(commentVO);
		int totCnt = resultList.size();
		
		model.addAttribute("resultCnt", totCnt);
		model.addAttribute("resultList", resultList);
		
		if("BBST05".equals(bmVO.getBbsTyCode())){ //이벤트 포토게시판
			if(bdVO.getAtchFileCnt() > 0 ) {
				FileVO fileVO = new FileVO();
				fileVO.setAtchFileId(bdVO.getAtchFileId());
				List<FileVO> result = fileService.selectImageFileList(fileVO);
				model.addAttribute("fileList", result);
			}
			

			

			
			
			
			//masterVO.setBbsNm(bbsNm);
			
			
			return "web/cop/bbs/EgovNoticePhotoInqire";
		}
		
		if("Y".equals(masterVO.getTabBbsId())){
			model.addAttribute("PubDetail", true);
		}

		return "web/cop/bbs/EgovNoticeInqire";
	}
	
	/**
	 * 
	 * URL 
	 *  /web/cop/bbs/TermsList.do (공지사항)
	 */
	@RequestMapping(value= {"web/cop/bbs/TermsList.do"
							, "/web/cop/bbs/TermsListAjax.do"
							})
	public String selectNoticeListWeb(HttpServletRequest request, 
		@ModelAttribute("searchVO") TermsVO termsVO, ModelMap model , 
		RedirectAttributes redirectAttributes) throws Exception {
		
		
		//상세 하단 리스트
		if(request.getRequestURI().contains("ListAjax.do")) { 

			// 공통
			List<TermsVO> resultList = new ArrayList<TermsVO>();			
			
			// 이용약관, 개인정보보호방침 이전버전 List
			TermsVO termsVO2 = new TermsVO();
			termsVO2.setFirstIndex(0);
			termsVO2.setRecordCountPerPage(20);
			termsVO2.setSearchDiv(termsVO.getMenuNm());
			termsVO2.setSearchUseYn("N");			
			termsVO2.setSearchSortCnd("effectDate");
			termsVO2.setSearchSortOrd("desc");
			List<TermsVO> termsMastList = egovSiteManagerService.selectTermsMastMngBeforeList(termsVO2);
			model.addAttribute("termsMastList", termsMastList);
			
			// NEW
			// 이용약관, 개인정보보호방침 최신버전 List
			TermsVO termsVO3 = new TermsVO();
			termsVO3.setFirstIndex(0);
			termsVO3.setRecordCountPerPage(1);
			termsVO3.setSearchDiv(termsVO.getMenuNm());
			termsVO3.setSearchUseYn("Y");			
			termsVO3.setSearchSortCnd("effectDate");
			termsVO3.setSearchSortOrd("desc");
			List<TermsVO> termsMastList2 = egovSiteManagerService.selectTermsMastMngList(termsVO3);
			if (termsMastList2.size() > 0) {
				TermsVO termsVO4 = new TermsVO();
				termsVO4.setFirstIndex(0);
				termsVO4.setRecordCountPerPage(20);				
				termsVO4.setTermsMastNo(termsMastList2.get(0).getTermsMastNo());
				termsVO4.setSearchUseYn("Y");
				termsVO4.setSearchSortCnd("sort");
				termsVO4.setSearchSortOrd("ASC");		
				resultList = egovSiteManagerService.selectTermsSubMngList(termsVO4);				
			}
			
			// 불법스팸방지안내
			if (termsVO.getMenuNm().equals("04")) {
				termsVO.setSearchSortCnd("TERMS_ID");
				termsVO.setSearchSortOrd("ASC");
				resultList = egovSiteManagerService.selectTermsMenu(termsVO);
			}
			
			model.addAttribute("resultList", resultList);
			
			return "web/cop/bbs/TermsListAjax";
		}
		else {
			String effectDate_02 = "";
			String effectDate_03 = "";
			TermsVO termsVO7 = new TermsVO();
			termsVO7.setFirstIndex(0);
			termsVO7.setRecordCountPerPage(2);
			termsVO7.setSearchUseYn("Y");			
			termsVO7.setSearchSortCnd("effectDate");
			termsVO7.setSearchSortOrd("desc");
			List<TermsVO> termsMastList7 = egovSiteManagerService.selectTermsMastMngList(termsVO7);
			for(TermsVO item : termsMastList7) {
				if (item.getTermsDivCode().equals("02")) {
					effectDate_02 = "(" + item.getEffectDate() + ")";
				}
				if (item.getTermsDivCode().equals("03")) {
					effectDate_03 = "(" + item.getEffectDate() + ")";					
				}
			}
			
			model.addAttribute("effectDate_02", effectDate_02);
			model.addAttribute("effectDate_03", effectDate_03);
		}
		
		return "web/cop/bbs/TermsList";
	}
	
	

	@RequestMapping(value= {"/web/cop/bbs/TermsHistPopAjax.do"})
	public String TermsHistPop(HttpServletRequest request, 
		@ModelAttribute("searchVO") TermsVO termsVO, ModelMap model) throws Exception {
		
		List<TermsVO> resultList = new ArrayList<TermsVO>();

		termsVO.setSearchSortCnd("TERMS_ID");
		termsVO.setSearchSortOrd("ASC");
		resultList = egovSiteManagerService.selectTermsMenu(termsVO);
		
		// New
		/*
		termsVO.setSearchSortCnd("sort");
		termsVO.setSearchSortOrd("ASC");		
		resultList = egovSiteManagerService.selectTermsSubMngList(termsVO);
		*/		
		
		model.addAttribute("resultList", resultList);
		
		return "web/cop/bbs/TermsHistPopAjax";
	}	
	
	// 이용약관 메일 발송 테스트
	@RequestMapping(value = "/web/cop/bbs/TermsHistSendEmailAjax.do")
	public ModelAndView ignoreIpCntAjax(
			@ModelAttribute("searchVO") TermsVO termsVO
			, HttpServletRequest request) throws Exception {

		ModelAndView modelAndView = new ModelAndView();
		modelAndView.setViewName("jsonView");

		boolean isSuccess = true;
		String msg = "";

        try {
        	// 이용약관 회원 전체발송
        	//mjonNoticeSendUtil.userAllTermsEmailSend();
		}
		catch(Exception e) {
			isSuccess = false;
			msg = e.getMessage();
		}		

		modelAndView.addObject("isSuccess", isSuccess);
		modelAndView.addObject("msg", msg);
		
		return modelAndView;
	}	    		
	
	
	/**
	 * (사용자)사전정보공표.
	 *
	 * @param boardVO
	 * @param sessionVO
	 * @param model
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value= {"/web/cop/bbs/PubOperList.do" 
			,"/web/cop/bbs/PubOperMainAjax.do"
			,"/web/cop/bbs/PubOperListAjax.do"
			,"/web/cop/bbs/PubOperSubListAjax.do"
			,"/web/cop/bbs/PubOperSubDetailListAjax.do"
			})
	public String selectPubOperList(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model , BoardVO boardVO ,
			RedirectAttributes redirectAttributes) throws Exception {

		//메뉴에 등록된 url 조회
		boardMasterVO.setUrl(request.getRequestURI());
		List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		
		if("/web/cop/bbs/PubOperMainAjax.do".equals(request.getRequestURI())){ //사전정보공표 최초 로딩
			BoardMasterVO mainMasterVO = new BoardMasterVO();
			mainMasterVO.setFirstIndex(0);
			mainMasterVO.setLastIndex(20);
			mainMasterVO.setRecordCountPerPage(30);
			
			mainMasterVO.setBbsTyCode("BBST07");
			mainMasterVO.setUseAt("Y"); //사용만
			
			mainMasterVO.setSearchSortCnd("BBS_SORT");
			mainMasterVO.setSearchSortOrd("ASC");
			mainMasterVO.setSeCmmnCdId("01"); //기관운영관련정보
			Map<String, Object> map01 = bbsAttrbService.selectBBSMasterInfs(mainMasterVO);
			model.addAttribute("resultList01", map01.get("resultList"));
			
			mainMasterVO.setSeCmmnCdId("02"); //주요사업정보
			Map<String, Object> map02 = bbsAttrbService.selectBBSMasterInfs(mainMasterVO);
			model.addAttribute("resultList01", map01.get("resultList"));
			model.addAttribute("resultList02", map02.get("resultList"));
			return "web/cop/bbs/PubOperMainAjax";
		}
		
		if("/web/cop/bbs/PubOperListAjax.do".equals(request.getRequestURI())){ //사전정보공표 리스트
			BoardMasterVO mainMasterVO = new BoardMasterVO();
			mainMasterVO.setFirstIndex(0);
			mainMasterVO.setLastIndex(20);
			mainMasterVO.setRecordCountPerPage(30);
			mainMasterVO.setBbsTyCode("BBST07");
			mainMasterVO.setUseAt("Y"); //사용만
			Map<String, Object> mapMain = bbsAttrbService.selectBBSMasterInfs(mainMasterVO);
			
			
			BoardMasterVO bmVO = new BoardMasterVO();
			bmVO.setBbsId(boardVO.getBbsId());
			bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
			UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
			
			if(bmVO != null) {
				boardVO.setPageUnit(Integer.parseInt(bmVO.getListNum()));
				boardVO.setPageSize(Integer.parseInt(bmVO.getPageNum()));
			}
			
			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());

			//전체 게시글 불러오기
			Map<String, Object> map = bbsMngService.selectBoardArticlesWeb(boardVO, null);
			int totCnt = Integer.parseInt((String) map.get("resultCnt"));

			paginationInfo.setTotalRecordCount(totCnt);
			List<BoardVO> resultList = (List<BoardVO>)map.get("resultList");
			for (BoardVO bvo: resultList) {
				Document doc = Jsoup.parse(bvo.getNttCn());
				String text = doc.text();
				bvo.setNttCn2(text);
			}
			
			//게시판 마스터 옵션 정보
			BoardMasterVO searchVO = new BoardMasterVO();
			searchVO.setBbsId(boardVO.getBbsId());
			BoardMasterVO bbsMasterInfo = bbsAttrbService.selectBBSMasterInf(searchVO);
			
			List<BoardMasterVO> mapMainList = new ArrayList<BoardMasterVO>();
			mapMainList = (List<BoardMasterVO>)mapMain.get("resultList") ;
			for(BoardMasterVO tempVO : mapMainList ) {
				if(tempVO.getBbsId().equals(bbsMasterInfo.getBbsId())) {
					tempVO.setSelectedFlag(true);
				}
			}
			model.addAttribute("resultMainList", mapMain.get("resultList"));
			
			model.addAttribute("bbsMasterInfo", bbsMasterInfo);
			model.addAttribute("resultList", resultList);
			model.addAttribute("resultCnt", map.get("resultCnt"));
			model.addAttribute("paginationInfo", paginationInfo);
			return "web/cop/bbs/PubOperListAjax";
		}
		
		if("/web/cop/bbs/PubOperSubListAjax.do".equals(request.getRequestURI())){ //사전정보공표 바로가기
			BoardMasterVO mainMasterVO = new BoardMasterVO();
			mainMasterVO.setFirstIndex(0);
			mainMasterVO.setLastIndex(20);
			mainMasterVO.setRecordCountPerPage(30);
			mainMasterVO.setBbsTyCode("BBST07");
			mainMasterVO.setUseAt("Y"); //사용만
			Map<String, Object> mapMain = bbsAttrbService.selectBBSMasterInfs(mainMasterVO);
			
			
			BoardMasterVO bmVO = new BoardMasterVO();
			bmVO.setBbsId(boardVO.getBbsId());
			bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
			UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
			
			if(bmVO != null) {
				boardVO.setPageUnit(Integer.parseInt(bmVO.getListNum()));
				boardVO.setPageSize(Integer.parseInt(bmVO.getPageNum()));
			}
			
			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());

			//전체 게시글 불러오기
			Map<String, Object> map = bbsMngService.selectBoardArticlesWeb(boardVO, null);
			int totCnt = Integer.parseInt((String) map.get("resultCnt"));

			paginationInfo.setTotalRecordCount(totCnt);
			List<BoardVO> resultList = (List<BoardVO>)map.get("resultList");
			for (BoardVO bvo: resultList) {
				Document doc = Jsoup.parse(bvo.getNttCn());
				String text = doc.text();
				bvo.setNttCn2(text);
			}
			
			//게시판 마스터 옵션 정보
			BoardMasterVO searchVO = new BoardMasterVO();
			searchVO.setBbsId(boardVO.getBbsId());
			BoardMasterVO bbsMasterInfo = bbsAttrbService.selectBBSMasterInf(searchVO);
			
			List<BoardMasterVO> mapMainList = new ArrayList<BoardMasterVO>();
			mapMainList = (List<BoardMasterVO>)mapMain.get("resultList") ;
			for(BoardMasterVO tempVO : mapMainList ) {
				if(tempVO.getBbsId().equals(boardMasterVO.getTabBbsId())) { //탭에서 가져온 상단 tabBbsId
					tempVO.setSelectedFlag(true);
				}
			}
			model.addAttribute("resultMainList", mapMain.get("resultList"));
			
			model.addAttribute("bbsMasterInfo", bbsMasterInfo);
			model.addAttribute("subBbsNm", bbsMasterInfo.getBbsNm());
			model.addAttribute("resultList", resultList);
			model.addAttribute("resultCnt", map.get("resultCnt"));
			model.addAttribute("paginationInfo", paginationInfo);
			//return "web/cop/bbs/PubOperListAjax";
			
			BoardVO boardTabVO =  bbsMngService.selectBbsTabIdByPubUrl(boardVO);
			model.addAttribute("boardTabVO", boardTabVO);
			return "web/cop/bbs/PubOperSubListAjax";
		}
		
		if("/web/cop/bbs/PubOperSubDetailListAjax.do".equals(request.getRequestURI())){ //사전정보공표 바로가기
			// 조회수 증가 여부 지정
			boardVO.setPlusCount(true);
			bbsMngService.updateBoardArticleInqireCo(boardVO);
			
			// 위/아래 게시글 번호, 제목 조회
			EgovMap upDownNttid =  bbsMngService.getUpDownNttIdNSj(boardVO);
			
			//게시판 마스터 옵션 정보
			BoardMasterVO searchVO = new BoardMasterVO();
			searchVO.setBbsId(boardVO.getBbsId());
			BoardMasterVO resultBbsMsInfo = bbsAttrbService.selectBBSMasterInf(searchVO);
			
			
			BoardVO bdVO = bbsMngService.selectBoardArticleWeb(boardVO);
			
			model.addAttribute("nextNttIdNSj", upDownNttid.get("nextNttIdNSj"));
			model.addAttribute("prevNttIdNSj", upDownNttid.get("prevNttIdNSj"));
			model.addAttribute("brdMstrVO", resultBbsMsInfo);
			model.addAttribute("result", bdVO);
			return "web/cop/bbs/PubOperSubDetailListAjax";
		}
		
		if("Y".equals(boardVO.getPubDetail())){
			model.addAttribute("pubDetail", true);
			return "web/cop/bbs/PubOperList";
		}
		
		if(null !=boardVO.getBbsId() && !"".equals(boardVO.getBbsId() )) {
			return "web/cop/bbs/PubOperSubList";
		}
		return "web/cop/bbs/PubOperList";
	}
	
	/**
	 * 시간을 LIST를 반환한다.
	 * @return  List
	 * @throws
	 */
	@SuppressWarnings("unused")
	private List<ComDefaultCodeVO> getTimeHH() {
		ArrayList<ComDefaultCodeVO> listHH = new ArrayList<ComDefaultCodeVO>();
		HashMap<?, ?> hmHHMM;
		for (int i = 0; i <= 24; i++) {
			String sHH = "";
			String strI = String.valueOf(i);
			if (i < 10) {
				sHH = "0" + strI;
			} else {
				sHH = strI;
			}

			ComDefaultCodeVO codeVO = new ComDefaultCodeVO();
			codeVO.setCode(sHH);
			codeVO.setCodeNm(sHH);

			listHH.add(codeVO);
		}

		return listHH;
	}

	/**
	 * 분을 LIST를 반환한다.
	 * @return  List
	 * @throws
	 */
	@SuppressWarnings("unused")
	private List<ComDefaultCodeVO> getTimeMM() {
		ArrayList<ComDefaultCodeVO> listMM = new ArrayList<ComDefaultCodeVO>();
		HashMap<?, ?> hmHHMM;
		for (int i = 0; i <= 60; i++) {

			String sMM = "";
			String strI = String.valueOf(i);
			if (i < 10) {
				sMM = "0" + strI;
			} else {
				sMM = strI;
			}

			ComDefaultCodeVO codeVO = new ComDefaultCodeVO();
			codeVO.setCode(sMM);
			codeVO.setCodeNm(sMM);

			listMM.add(codeVO);
		}
		return listMM;
	}

	
	/**
	 * (사용자) 컨텐츠 게시판 통합
	 *
	 * URL 
	 *  /web/cop/bbs/CntBbsListAjax (상단 검색부분 없는 리스트)
	 *  /web/cop/bbs/CntBbs01ListAjax.do(상단 검색부분 있는 리스트) 01타입
	 */
	@RequestMapping(value= {"/web/cop/bbs/CntBbsList.do" 
							, "/web/cop/bbs/CntBbsListAjax.do"
							, "/web/cop/bbs/CntBbs01ListAjax.do"
							})
	public String selectCntBbsListWeb(HttpServletRequest request, 
			@ModelAttribute("searchVO") BoardMasterVO boardMasterVO, ModelMap model , BoardVO boardVO ,
			RedirectAttributes redirectAttributes) throws Exception {
		
		//메뉴에 등록된 url 조회
		boardMasterVO.setUrl("/web/content.do?proFn?="+boardMasterVO.getMenuNm());
		List<BoardMasterVO>  boardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		List<BoardMasterVO>  viewBoardMenuList =  bbsAttrbService.selectBBSMenuByUrl(boardMasterVO);
		for(BoardMasterVO tempVO : viewBoardMenuList) {
			if("N".equals(tempVO.getViewsYn())){;
				boardMasterVO.setViewsYn("N");
				break ;
			}
		}
		
		if(0!=boardMenuList.size()) { //원자력 소식은 전체 매뉴 없음.
			if(!"9420000".equals(((BoardMasterVO)boardMenuList.get(0)).getMenuNo())) { 
				BoardMasterVO totalBoardMasterVO = new BoardMasterVO();
				totalBoardMasterVO.setBbsNm("전체");
				boardMenuList.add(0,totalBoardMasterVO) ;
			}
		}
		
		if(request.getRequestURI().contains("List.do")){ //최초 로딩 매뉴이름가져오기
			MenuManageVO tempMenuManageVO = new MenuManageVO();
			tempMenuManageVO.setUrl(request.getRequestURI());
			MenuManageVO menuManageVO = menuManageService.selectMenuManageUrl(tempMenuManageVO);
			model.addAttribute("menuManageVO", menuManageVO);
		}
		
		if(request.getRequestURI().contains("ListAjax.do") //하단 리스트
			) { //상세 하단 리스트
			BoardMasterVO bmVO = new BoardMasterVO();
			PaginationInfo paginationInfo = new PaginationInfo();
			//전체 게시글 불러오기
			Map<String, Object> map = new HashMap<String, Object>();
			if("".equals(boardVO.getBbsId())){ //전체 게시글 불러오기
				boardVO.setPageUnit(bmVO.getPageUnit());
				boardVO.setPageSize(bmVO.getPageSize());
				
				paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
				paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
				paginationInfo.setPageSize(boardVO.getPageSize());

				boardMasterVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
				boardMasterVO.setLastIndex(paginationInfo.getLastRecordIndex());
				boardMasterVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
				
				String temp = boardMasterVO.getUrl(); //Url 패턴에 Ajax 구문 삭제처리
				boardMasterVO.setUrl(temp.replace("Ajax", ""));
				//전체 게시글 불러오기
				map = bbsMngService.selectBoardArticlesWebUrl(boardMasterVO, null);
			}else {
				bmVO.setBbsId(boardVO.getBbsId());
				bmVO = bbsAttrbService.selectBBSMasterInf(bmVO);
				//UserVO userVO = (UserVO)request.getSession().getAttribute("userVO"); // 사용자 정보
				
				boardVO.setPageUnit(Integer.parseInt(bmVO.getListNum()));
				boardVO.setPageSize(Integer.parseInt(bmVO.getPageNum()));
				
				paginationInfo.setCurrentPageNo(boardVO.getPageIndex());
				paginationInfo.setRecordCountPerPage(boardVO.getPageUnit());
				paginationInfo.setPageSize(boardVO.getPageSize());

				boardVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
				boardVO.setLastIndex(paginationInfo.getLastRecordIndex());
				boardVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
				//메뉴별 게시글 불러오기
				map = bbsMngService.selectBoardArticlesWeb(boardVO, null);
			}
			int totCnt = Integer.parseInt((String) map.get("resultCnt"));

			paginationInfo.setTotalRecordCount(totCnt);
			List<BoardVO> resultList = (List<BoardVO>)map.get("resultList");
			for (BoardVO bvo: resultList) {
				Document doc = Jsoup.parse(bvo.getNttCn());
				String text = doc.text();
				bvo.setNttCn2(text);
			}
			model.addAttribute("resultList", resultList);
			model.addAttribute("resultCnt", map.get("resultCnt"));
			model.addAttribute("paginationInfo", paginationInfo);
			
			
			if(request.getRequestURI().contains("CntBbs01ListAjax")){ //01타입
				model.addAttribute("boardVO", boardVO);
				return "web/cop/bbs/CntBbs01ListAjax";
			}
			return "web/cop/bbs/CntBbsListAjax";
		}
		model.addAttribute("boardMenuList", boardMenuList);
		return "web/cop/bbs/CntBbsList";
	}
	
	
	public String getDateDay(String date, String dateType) throws Exception {
	    String day = "" ;
	    SimpleDateFormat dateFormat = new SimpleDateFormat(dateType) ;
	    Date nDate = dateFormat.parse(date) ;
	    Calendar cal = Calendar.getInstance() ;
	    cal.setTime(nDate);
	    int dayNum = cal.get(Calendar.DAY_OF_WEEK) ;
	    switch(dayNum){
	        case 1:
	            day = "일";
	            break ;
	        case 2:
	            day = "월";
	            break ;
	        case 3:
	            day = "화";
	            break ;
	        case 4:
	            day = "수";
	            break ;
	        case 5:
	            day = "목";
	            break ;
	        case 6:
	            day = "금";
	            break ;
	        case 7:
	            day = "토";
	            break ;
	    }
	    return day ;
	}
	
	public BoardVO niceCheck(HttpServletRequest request, HttpSession session, BoardVO boardVO) {
		
		CPClient niceCheck = new  CPClient();
		String sEncodeData = requestReplace(request.getParameter("EncodeData"), "encodeData");
		String sSiteCode = "BS933";				// NICE로부터 부여받은 사이트 코드
		String sSitePassword = "2CU5kY9wpppk";			// NICE로부터 부여받은 사이트 패스워드
		 
		String sCipherTime = "";			// 복호화한 시간
	    String sRequestNumber = "";			// 요청 번호
	    String sResponseNumber = "";		// 인증 고유번호
	    String sAuthType = "";				// 인증 수단
	    String sName = "";					// 성명
	    String sDupInfo = "";				// 중복가입 확인값 (DI_64 byte)
	    String sConnInfo = "";				// 연계정보 확인값 (CI_88 byte)
	    String sBirthDate = "";				// 생년월일(YYYYMMDD)
	    String sGender = "";				// 성별
	    String sNationalInfo = "";			// 내/외국인정보 (개발가이드 참조)
		String sMobileNo = "";				// 휴대폰번호
		String sMobileCo = "";				// 통신사
	    String sMessage = "";
	    String sPlainData = "";
	    
		int iReturn = niceCheck.fnDecode(sSiteCode, sSitePassword, sEncodeData);
		if( iReturn == 0 )
	    {
	        sPlainData = niceCheck.getPlainData();
	        sCipherTime = niceCheck.getCipherDateTime();
	        
	        // 데이타를 추출합니다.
	        java.util.HashMap mapresult = niceCheck.fnParse(sPlainData);
	        
	        sRequestNumber  = (String)mapresult.get("REQ_SEQ");
	        sResponseNumber = (String)mapresult.get("RES_SEQ");
	        sAuthType		= (String)mapresult.get("AUTH_TYPE");
	        sName			= (String)mapresult.get("NAME");
			//sName			= (String)mapresult.get("UTF8_NAME"); //charset utf8 사용시 주석 해제 후 사용
	        sBirthDate		= (String)mapresult.get("BIRTHDATE");
	        sGender			= (String)mapresult.get("GENDER");
	        sNationalInfo  	= (String)mapresult.get("NATIONALINFO");
	        sDupInfo		= (String)mapresult.get("DI");
	        sConnInfo		= (String)mapresult.get("CI");
	        sMobileNo		= (String)mapresult.get("MOBILE_NO");
	        sMobileCo		= (String)mapresult.get("MOBILE_CO");
	        
	        String session_sRequestNumber = (String)session.getAttribute("REQ_SEQ");
	        if(!sRequestNumber.equals(session_sRequestNumber))
	        {
	            sMessage = "세션값 불일치 오류입니다.";
	            sResponseNumber = "";
	            sAuthType = "";
	        }
	    }
	    else if( iReturn == -1)
	    {
	        sMessage = "복호화 시스템 오류입니다.";
	    }    
	    else if( iReturn == -4)
	    {
	        sMessage = "복호화 처리 오류입니다.";
	    }    
	    else if( iReturn == -5)
	    {
	        sMessage = "복호화 해쉬 오류입니다.";
	    }    
	    else if( iReturn == -6)
	    {
	        sMessage = "복호화 데이터 오류입니다.";
	    }    
	    else if( iReturn == -9)
	    {
	        sMessage = "입력 데이터 오류입니다.";
	    }    
	    else if( iReturn == -12)
	    {
	        sMessage = "사이트 패스워드 오류입니다.";
	    }    
	    else
	    {
	        sMessage = "알수 없는 에러 입니다. iReturn : " + iReturn;
	    }
		
		try {
		boardVO.setNiceMessage(sMessage);
		boardVO.setNiceNm(sName);
		boardVO.setMblDn(sDupInfo);
		}catch(Exception e) {
			e.printStackTrace();
		}
		return boardVO;
		
	}
	
	//나이스 인증
	public String requestReplace (String paramValue, String gubun) {

        String result = "";
        
        if (paramValue != null) {
        	
        	paramValue = paramValue.replaceAll("<", "&lt;").replaceAll(">", "&gt;");

        	paramValue = paramValue.replaceAll("\\*", "");
        	paramValue = paramValue.replaceAll("\\?", "");
        	paramValue = paramValue.replaceAll("\\[", "");
        	paramValue = paramValue.replaceAll("\\{", "");
        	paramValue = paramValue.replaceAll("\\(", "");
        	paramValue = paramValue.replaceAll("\\)", "");
        	paramValue = paramValue.replaceAll("\\^", "");
        	paramValue = paramValue.replaceAll("\\$", "");
        	paramValue = paramValue.replaceAll("'", "");
        	paramValue = paramValue.replaceAll("@", "");
        	paramValue = paramValue.replaceAll("%", "");
        	paramValue = paramValue.replaceAll(";", "");
        	paramValue = paramValue.replaceAll(":", "");
        	paramValue = paramValue.replaceAll("-", "");
        	paramValue = paramValue.replaceAll("#", "");
        	paramValue = paramValue.replaceAll("--", "");
        	paramValue = paramValue.replaceAll("-", "");
        	paramValue = paramValue.replaceAll(",", "");
        	
        	if(gubun != "encodeData"){
        		paramValue = paramValue.replaceAll("\\+", "");
        		paramValue = paramValue.replaceAll("/", "");
            paramValue = paramValue.replaceAll("=", "");
        	}
        	
        	result = paramValue;
            
        }
        return result;
	}
	
	public String damoDec(String strEnc, HttpServletRequest request) {
		//DI 복구화
		
		System.out.println("-----damoDec---request.getRequestURL().toString()-----------" + request.getRequestURL().toString()+"-----") ;
		
		String iniFilePath     = "/usr/local/tomcat/damo/scpdb_agent.ini"; //실서버
		if(request.getRequestURL().toString().contains("test.kofons.or.kr")){ //로컬
			iniFilePath = "C:\\damo\\scpdb_agent.ini";
		}else if(request.getRequestURL().toString().contains("219.240.88.15")) { //테스트
			iniFilePath = "/usr/local/tomcat_kofons/damo/scpdb_agent.ini";
		}
		System.out.println("iniFilePath --" + iniFilePath + "---"); 
		ScpDbAgent agt = new ScpDbAgent();
		String strDec = "";
		try {
			strDec = agt.ScpDecB64( iniFilePath, "KEY1", strEnc);
		}catch(Exception e) {
			
		}
		return  strDec ;
	}
	
	public String damoEnc(String strDec, HttpServletRequest request) {
		//DI 암호화
		System.out.println("-----damoEnc---request.getRequestURL().toString()-----------" + request.getRequestURL().toString()+"-----") ;
		
		String iniFilePath     = "/usr/local/tomcat/damo/scpdb_agent.ini"; //실서버
		if(request.getRequestURL().toString().contains("test.kofons.or.kr")){ //로컬
			iniFilePath = "C:\\damo\\scpdb_agent.ini";
		}else if(request.getRequestURL().toString().contains("219.240.88.15")) { //테스트
			iniFilePath = "/usr/local/tomcat_kofons/damo/scpdb_agent.ini";
		}
		System.out.println("iniFilePath --" + iniFilePath + "---");
		ScpDbAgent agt = new ScpDbAgent();
		String strEnc = "";
		try {
			strEnc =  agt.ScpEncB64( iniFilePath, "KEY1", strDec);
		}catch(Exception e) {
			
		}
		return  strEnc ;
	}
	
}