egovframework.rfc3.board.service.impl
Class BoardServiceImpl

java.lang.Object
  extended by egovframework.rte.fdl.cmmn.AbstractServiceImpl
      extended by egovframework.rfc3.board.service.impl.BoardServiceImpl
All Implemented Interfaces:
BoardService

@Service(value="BoardService")
public class BoardServiceImpl
extends egovframework.rte.fdl.cmmn.AbstractServiceImpl
implements BoardService

게시판에 대한 ServiceImpl 클래스를 정의한다.

Since:
2011.04.25
Version:
egovframework RFC 3.0
Author:
개발팀 양민욱
See Also:
 << 개정이력(Modification Information) >>
   
       수정일      수정자                   수정내용
  --------------  --------        ---------------------------
  2011.04.25  양민욱         rfc3 iam 참조

 Copyright (C) 2009 by MOPAS  All right reserved.
 

Constructor Summary
BoardServiceImpl()
           
 
Method Summary
 java.util.List<BoardCountVO> boardDataCount(BoardSearchVO boardSearchVO)
           
 java.util.List<BoardCountVO> boardOfficeCount(BoardSearchVO boardSearchVO)
           
 BoardSearchVO boardSearchFilter(BoardSearchVO boardSearchVO)
          BOARD SELECT QUERY 제외, JKH ,20160817
 void deleteBoardAction(BoardActionVO boardActionVO)
           
 void deleteBoardCategory(BoardCategoryVO boardCategoryVO)
           
 void deleteBoardData(BoardDataVO boardDataVO)
          게시물 삭제 상태 변경
 void deleteBoardDataBak(BoardVO boardVO)
           
 void deleteBoardDataLike(BoardDataLikeVO boardDataLikeVO)
           
 void deleteBoardFile(BoardFileVO boardFileVO)
           
 void deleteBoardInfo(BoardVO boardVO)
          게시판 기본정보 수정
 void deleteBoardReplyOffice(BoardReplyVO boardReplyVO)
           
 void deleteComment(CommentVO commentVO)
           
 void deleteDataCommentManager(BoardVO boardVO)
           
 void deleteDataExtManager(BoardVO boardVO)
           
 void deleteDataFileManager(BoardVO boardVO)
           
 void deleteDataListManager(BoardVO boardVO)
           
 void deleteExtensionField(BoardExtensionVO boardExtensionVO)
           
 void deleteRealBoardData(BoardDataVO boardDataVO)
           
 void deleteSkin(BoardSkinVO boardSkinVO)
           
 void deleteSkinEtc(BoardSkinVO boardSkinVO)
           
 void deleteUserBoardData(BoardDataVO boardDataVO)
          게시물 삭제 상태 변경
 BoardActionVO getBoardAction(BoardActionVO boardActionVO)
           
 BoardVO getBoardBasic(BoardVO boardVO)
          게시판의 기본 정보
 BoardVO getBoardBasicInfo(BoardVO boardVO)
           
 BoardVO getBoardBasicInfoId(BoardVO boardVO)
           
 BoardCategoryVO getBoardCategory(BoardCategoryVO boardCategoryVO)
           
 int getBoardCommentAllCnt(BoardSearchVO boardSearchVO)
          만족도 전체리스트 년 월 일 카운트
 int getBoardCommentIdx(BoardSearchVO boardSearchVO)
           
 BoardDataVO getBoardData(BoardDataVO boardDataVO)
           
 BoardDataVO getBoardDataBak(BoardDataVO boardDataVO)
           
 java.util.List<BoardDataVO> getBoardDataBakList(BoardVO boardVO)
           
 int getBoardDataIdx(BoardVO boardVO)
           
 BoardEtcVO getBoardEtc(BoardEtcVO boardEtcVO)
          게시판 기타정보 영역
 BoardFileVO getBoardFile(BoardFileVO boardFileVO)
           
 BoardVO getBoardItem(BoardVO boardVO)
           
 java.util.List<MenuVO> getBoardMenuList(BoardSearchVO boardSearchVO)
           
 BoardDataVO getBoardRecentlyPosted(BoardDataVO boardDataVO)
          관리자 게시판목록 게시판에 따른 최근게시일
 BoardReplyVO getBoardReplyOffice(BoardReplyVO boardReplyVO)
           
 BoardSkinVO getBoardSkin(BoardSkinVO boardSkinVO)
           
 BoardSkinHistoryVO getBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
           
 BoardSkinEtcVO getBoardSkinEtc(BoardSkinEtcVO boardSkinEtcVO)
           
 BoardSkinVO getBoardSkinId(BoardSkinVO boardSkinVO)
           
 CommentVO getComment(CommentVO commentVO)
           
 int getCommentCnt(CommentVO commentVO)
           
 java.util.List<CommentVO> getCommentListAll(BoardSearchVO boardSearchVO)
          만족도 전체리스트 년 월 일 검색 ALL
 java.util.List<CommentVO> getCommentListAllPage(BoardSearchVO boardSearchVO)
          만족도 전체리스트 년 월 일 검색
 java.lang.String getDataContent(BoardDataVO boardDataVO)
           
 BoardExtensionVO getDefaultField(BoardExtensionVO boardExtensionVO)
           
 java.lang.String getExampleEditorSkin(java.lang.String skinType, java.lang.String skinEditor, java.lang.String skinArea)
           
 java.lang.String getExampleSkin(java.lang.String skinType, java.lang.String skinArea)
           
 boolean getExtendedSelectNot(java.lang.String boardId, long dataSid, int officeRegDp, java.lang.String selectProcTime)
           
 java.util.List<BoardFileVO> getMultiFileList(BoardVO boardVO)
           
 int getStarPoint(BoardSearchVO boardSearchVO)
           
 void initBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
           
 void insertBoardAction(BoardActionVO boardActionVO)
           
 void insertBoardCategory(BoardCategoryVO boardCategoryVO)
           
 void insertBoardData(BoardDataVO boardDataVO)
           
 void insertBoardDataBackup(BoardDataVO boardDataVO)
           
 void insertBoardDataLike(BoardDataLikeVO boardDataLikeVO)
          게시판글 좋아요,싫어요,찬성,반대
 void insertBoardEtc(BoardEtcVO boardEtcVO)
          게시판 기타정보 입력
 void insertBoardFile(BoardFileVO boardFileVO)
           
 void insertBoardHistory(long logId, java.lang.String boardId, long boardSid, long dataSid, java.lang.String actionType, java.lang.String dataTitle, java.lang.String userId, java.lang.String userName, java.lang.String userIp, java.lang.String writeID, java.lang.String WriteName)
           
 void insertBoardInfo(BoardVO boardVO)
          게시판 등록
 void insertBoardInfoAll(BoardVO boardVO)
           
 void insertBoardReplyOffice(BoardReplyVO boardReplyVO)
           
 void insertBoardSkin(BoardSkinVO boardSkinVO)
           
 void insertBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
           
 void insertBoardSkinEtc(BoardSkinEtcVO boardSkinEtcVO)
           
 void insertComment(CommentVO commentVO)
           
 void insertCommentDataLike(CommentLikeVO commentLikeVO)
          게시판 댓글 공감 비공감
 void insertDownloadHistory(DownloadHistoryVO downloadHistoryVO)
           
 void insertExtensionData(BoardExtensionDataVO boardExtensionDataVO)
           
 void insertExtensionField(BoardExtensionVO boardExtensionVO)
           
 java.lang.String insertFileId(java.lang.String boardId, java.lang.String dataSid, java.lang.String fileSid, javax.servlet.http.HttpServletRequest request)
           
 java.util.List<BoardReplyVO> listBoardReplyOffice(BoardReplyVO boardReplyVO)
          담당부서 설정
 int passwordValidate(BoardSearchVO boardSearchVO)
           
 void restoreBoardDataBak(BoardVO boardVO)
          삭제 게시물 복구일자 설정
 java.util.List<BoardDataVO> selectBackupHistoryList(BoardDataVO boardDataVO)
           
 int selectBackupHistoryTotal(BoardDataVO boardDataVO)
           
 int selectBoardActionCount(BoardActionVO boardActionVO)
           
 java.util.List<BoardActionVO> selectBoardActionList(BoardActionVO boardActionVO)
           
 java.util.List<BoardActionVO> selectBoardActionListAll(BoardActionVO boardActionVO)
           
 int selectBoardActionTotal(BoardActionVO boardActionVO)
           
 java.util.List<BoardCategoryVO> selectBoardCategory(BoardCategoryVO boardCategoryVO)
           
 int selectBoardCategoryCount(BoardCategoryVO boardCategoryVO)
           
 int selectBoardCommentLikeCnt(CommentLikeVO commentLikeVO)
           
 java.util.List<BoardDataVO> selectBoardDataBackupList(BoardVO boardVO)
           
 int selectBoardDataBackupTotal(BoardVO boardVO)
           
 int selectBoardDataLikeCnt(BoardDataLikeVO boardDataLikeVO)
           
 java.util.List<BoardDataLikeVO> selectBoardDataLikeList(BoardDataLikeVO boardDataLikeVO)
           
 java.util.List<BoardDataVO> selectBoardDataList(BoardSearchVO boardSearchVO)
           
 int selectBoardDataListTotal(BoardSearchVO boardSearchVO)
           
 java.util.List<BoardDataVO> selectBoardDataManagerList(BoardVO boardVO)
           
 java.util.List<BoardDataVO> selectBoardDataManagerStandbyList(BoardVO boardVO)
          게시물 관리 대기 목록
 int selectBoardDataManagerStandbyListCnt(BoardVO boardVO)
          게시물 관리 대기 목록수
 int selectBoardDataManagerTotal(BoardVO boardVO)
           
 java.util.List<BoardDataVO> selectBoardDataOriginal(BoardDataVO boardDataVO)
           
 int selectBoardDataReplyCnt(BoardDataVO boardDataVO)
           
 int selectBoardDataReplyCount(BoardDataVO boardDataVO)
           
 java.util.List<BoardDataVO> selectBoardDataReplyList(BoardDataVO boardDataVO)
           
 int selectBoardExtensionDataCount(BoardExtensionDataVO boardExtensionDataVO)
           
 java.util.List<BoardExtensionDataVO> selectBoardExtensionDataList(BoardDataVO boardDataVO)
           
 java.util.List<BoardFileVO> selectBoardFile(BoardDataVO boardDataVO)
           
 java.util.List<BoardHistoryVO> selectBoardHistoryList(BoardHistoryVO boardHistoryVO)
           
 int selectBoardHistoryListTotal(BoardHistoryVO boardHistoryVO)
           
 int selectBoardIdCount(BoardVO boardVO)
          게시판 기본정보 + 기타정보 중복 검색
 java.util.List<BoardVO> selectBoardList(BoardVO boardVO)
          페이징 처리된 게시판 리스트
 int selectBoardListTotal(BoardVO boardVO)
          게시판 전체 갯수
 java.util.List<BoardDataVO> selectBoardNoticeDataList(BoardSearchVO boardSearchVO)
           
 java.util.List<BoardReplyVO> selectBoardReplyOfficeList(BoardReplyVO boardReplyVO)
           
 BoardSkinVO selectBoardSkinArea(BoardSkinVO boardSkinVO)
           
 java.util.List<BoardSkinHistoryVO> selectBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
           
 int selectBoardSkinEtcCount(BoardSkinEtcVO boardSkinEtcVO)
           
 int selectBoardSkinIdCount(BoardSkinVO boardSkinVO)
           
 java.util.List<BoardSkinVO> selectBoardSkinList(BoardSkinVO boardSkinVO)
           
 int selectBoardSkinListTotal(BoardSkinVO boardSkinVO)
           
 int selectCommentCount(BoardSearchVO boardSearchVO)
           
 java.util.List<CommentVO> selectCommentList(BoardSearchVO boardSearchVO)
           
 java.util.List<CommentVO> selectCommentListAll(BoardDataVO boardDataVO)
           
 java.util.List<BoardExtensionVO> selectDefaultField()
           
 int selectDownloadHistoryTotal(java.lang.String boardId, long dataSid, long fileSid)
           
 int selectDownloadHistoryTotal(java.lang.String boardId, long dataSid, long fileSid, boolean isNow)
           
 java.util.List<BoardExtensionVO> selectExtensionField(BoardExtensionVO boardExtensionVO)
           
 int selectExtensionFieldCount(BoardExtensionVO boardExtensionVO)
           
 java.util.List<BoardExtensionVO> selectExtensionFieldUse(BoardExtensionVO boardExtensionVO)
           
 java.util.List<BoardExtensionVO> selectFieldValidator(java.lang.String boardId, java.lang.String extensionKey)
           
 java.util.List<BoardDataVO> selectNoticeUpdateDataList(BoardSearchVO boardSearchVO)
          공지 지난글 목록 검색
 java.util.List<BoardDataVO> selectPeriodUpdateDataList(BoardSearchVO boardSearchVO)
           
 java.util.List<BoardDataVO> selectScheduleDataList(BoardSearchVO boardSearchVO)
           
 int selectScheduleDataListTotal(BoardSearchVO boardSearchVO)
           
 java.util.List<BoardVO> selectSgroupDomainBoardList(java.lang.String sgroupId, java.lang.String domainId)
           
 java.util.List<BoardSkinVO> selectSgroupDomainSkinList(java.lang.String sgroupId, java.lang.String domainId)
           
 java.util.List<BoardDataVO> selectStandByDataList(BoardSearchVO boardSearchVO)
          승인대기 게시물 목록
 void updateBoardAction(BoardActionVO boardActionVO)
           
 void updateBoardCategory(BoardCategoryVO boardCategoryVO)
           
 void updateBoardData(BoardDataVO boardDataVO)
           
 void updateBoardDataAnswerStatus(BoardDataVO boardDataVO)
           
 void updateBoardDataReplyNotice(BoardDataVO boardDataVO)
           
 void updateBoardDataStatus(BoardDataVO boardDataVO)
          게시물 차단 상태 변경
 void updateBoardEtc(BoardEtcVO boardEtcVO)
          게시판 기타정보 수정
 void updateBoardFile(BoardFileVO boardFileVO)
           
 void updateBoardFileId(BoardFileVO boardFileVO)
           
 void updateBoardInfo(BoardVO boardVO)
          게시판 기본정보 수정
 void updateBoardItemList(BoardVO boardVO)
           
 void updateBoardItemView(BoardVO boardVO)
           
 void updateBoardItemWrite(BoardVO boardVO)
           
 void updateBoardReplyOffice(BoardReplyVO boardReplyVO)
           
 void updateBoardSkin(BoardSkinVO boardSkinVO)
           
 void updateBoardSkinArea(BoardSkinVO boardSkinVO)
           
 void updateBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
           
 void updateBoardSkinEtc(BoardSkinEtcVO boardSkinEtcVO)
           
 void updateBoardSkinList(BoardSkinVO boardSkinVO)
           
 void updateBoardSkinPublic(BoardSkinVO boardSkinVO)
           
 void updateBoardSkinView(BoardSkinVO boardSkinVO)
           
 void updateBoardSkinWrite(BoardSkinVO boardSkinVO)
           
 void updateCommentReplyOrder(CommentVO commentVO)
           
 java.lang.String updateDataRegisterDt(long dataSid, java.lang.String register_dt)
           
 void updateDataReplyOrder(BoardDataVO boardDataVO)
           
 void updateDataStarPoint(BoardDataVO boardDataVO)
           
 int updateDataTmpField(long dataSid, int tmpDp, java.lang.String tmpField)
          게시물 임시필드값 수정 (DWR)
 void updateDataViewCount(BoardDataVO boardDataVO)
           
 void updateExtensionData(BoardExtensionDataVO boardExtensionDataVO)
           
 void updateExtensionField(BoardExtensionVO boardExtensionVO)
           
 void updateFileDeleteStatus(BoardDataVO boardDataVO)
           
 void updateNoticeData(BoardDataVO boardDataVO)
          공지기간 지난글 업데이트
 void updatePeriodData(BoardDataVO boardDataVO)
           
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

BoardServiceImpl

public BoardServiceImpl()
Method Detail

selectBoardListTotal

public int selectBoardListTotal(BoardVO boardVO)
                         throws java.lang.Exception
게시판 전체 갯수

Specified by:
selectBoardListTotal in interface BoardService
Parameters:
boardVO -
Returns:
Throws:
java.lang.Exception

selectBoardList

public java.util.List<BoardVO> selectBoardList(BoardVO boardVO)
                                        throws java.lang.Exception
페이징 처리된 게시판 리스트

Specified by:
selectBoardList in interface BoardService
Parameters:
boardVO -
Returns:
Throws:
java.lang.Exception

selectSgroupDomainBoardList

public java.util.List<BoardVO> selectSgroupDomainBoardList(java.lang.String sgroupId,
                                                           java.lang.String domainId)
                                                    throws java.lang.Exception
Specified by:
selectSgroupDomainBoardList in interface BoardService
Throws:
java.lang.Exception

selectSgroupDomainSkinList

public java.util.List<BoardSkinVO> selectSgroupDomainSkinList(java.lang.String sgroupId,
                                                              java.lang.String domainId)
                                                       throws java.lang.Exception
Specified by:
selectSgroupDomainSkinList in interface BoardService
Throws:
java.lang.Exception

getBoardBasic

public BoardVO getBoardBasic(BoardVO boardVO)
                      throws java.lang.Exception
게시판의 기본 정보

Specified by:
getBoardBasic in interface BoardService
Parameters:
boardVO -
Returns:
Throws:
java.lang.Exception

getBoardBasicInfo

public BoardVO getBoardBasicInfo(BoardVO boardVO)
                          throws java.lang.Exception
Specified by:
getBoardBasicInfo in interface BoardService
Throws:
java.lang.Exception

getBoardBasicInfoId

public BoardVO getBoardBasicInfoId(BoardVO boardVO)
                            throws java.lang.Exception
Specified by:
getBoardBasicInfoId in interface BoardService
Throws:
java.lang.Exception

insertBoardInfo

public void insertBoardInfo(BoardVO boardVO)
                     throws java.lang.Exception
게시판 등록

Specified by:
insertBoardInfo in interface BoardService
Parameters:
boardVO -
Throws:
java.lang.Exception

insertBoardInfoAll

public void insertBoardInfoAll(BoardVO boardVO)
                        throws java.lang.Exception
Specified by:
insertBoardInfoAll in interface BoardService
Throws:
java.lang.Exception

selectBoardIdCount

public int selectBoardIdCount(BoardVO boardVO)
                       throws java.lang.Exception
게시판 기본정보 + 기타정보 중복 검색

Specified by:
selectBoardIdCount in interface BoardService
Returns:
Throws:
java.lang.Exception

updateBoardInfo

public void updateBoardInfo(BoardVO boardVO)
                     throws java.lang.Exception
게시판 기본정보 수정

Specified by:
updateBoardInfo in interface BoardService
Parameters:
boardVO -
Throws:
java.lang.Exception

deleteBoardInfo

public void deleteBoardInfo(BoardVO boardVO)
                     throws java.lang.Exception
Description copied from interface: BoardService
게시판 기본정보 수정

Specified by:
deleteBoardInfo in interface BoardService
Throws:
java.lang.Exception

getBoardEtc

public BoardEtcVO getBoardEtc(BoardEtcVO boardEtcVO)
                       throws java.lang.Exception
게시판 기타정보 영역

Specified by:
getBoardEtc in interface BoardService
Throws:
java.lang.Exception

insertBoardEtc

public void insertBoardEtc(BoardEtcVO boardEtcVO)
                    throws java.lang.Exception
Description copied from interface: BoardService
게시판 기타정보 입력

Specified by:
insertBoardEtc in interface BoardService
Throws:
java.lang.Exception

updateBoardEtc

public void updateBoardEtc(BoardEtcVO boardEtcVO)
                    throws java.lang.Exception
Description copied from interface: BoardService
게시판 기타정보 수정

Specified by:
updateBoardEtc in interface BoardService
Throws:
java.lang.Exception

selectDefaultField

public java.util.List<BoardExtensionVO> selectDefaultField()
                                                    throws java.lang.Exception
Specified by:
selectDefaultField in interface BoardService
Throws:
java.lang.Exception

selectExtensionFieldCount

public int selectExtensionFieldCount(BoardExtensionVO boardExtensionVO)
                              throws java.lang.Exception
Specified by:
selectExtensionFieldCount in interface BoardService
Throws:
java.lang.Exception

selectFieldValidator

public java.util.List<BoardExtensionVO> selectFieldValidator(java.lang.String boardId,
                                                             java.lang.String extensionKey)
                                                      throws java.lang.Exception
Specified by:
selectFieldValidator in interface BoardService
Throws:
java.lang.Exception

selectExtensionField

public java.util.List<BoardExtensionVO> selectExtensionField(BoardExtensionVO boardExtensionVO)
                                                      throws java.lang.Exception
Specified by:
selectExtensionField in interface BoardService
Throws:
java.lang.Exception

selectExtensionFieldUse

public java.util.List<BoardExtensionVO> selectExtensionFieldUse(BoardExtensionVO boardExtensionVO)
                                                         throws java.lang.Exception
Specified by:
selectExtensionFieldUse in interface BoardService
Throws:
java.lang.Exception

getDefaultField

public BoardExtensionVO getDefaultField(BoardExtensionVO boardExtensionVO)
                                 throws java.lang.Exception
Specified by:
getDefaultField in interface BoardService
Throws:
java.lang.Exception

insertExtensionField

public void insertExtensionField(BoardExtensionVO boardExtensionVO)
                          throws java.lang.Exception
Specified by:
insertExtensionField in interface BoardService
Throws:
java.lang.Exception

updateExtensionField

public void updateExtensionField(BoardExtensionVO boardExtensionVO)
                          throws java.lang.Exception
Specified by:
updateExtensionField in interface BoardService
Throws:
java.lang.Exception

deleteExtensionField

public void deleteExtensionField(BoardExtensionVO boardExtensionVO)
                          throws java.lang.Exception
Specified by:
deleteExtensionField in interface BoardService
Throws:
java.lang.Exception

selectBoardCategory

public java.util.List<BoardCategoryVO> selectBoardCategory(BoardCategoryVO boardCategoryVO)
                                                    throws java.lang.Exception
Specified by:
selectBoardCategory in interface BoardService
Throws:
java.lang.Exception

getBoardCategory

public BoardCategoryVO getBoardCategory(BoardCategoryVO boardCategoryVO)
                                 throws java.lang.Exception
Specified by:
getBoardCategory in interface BoardService
Throws:
java.lang.Exception

selectBoardCategoryCount

public int selectBoardCategoryCount(BoardCategoryVO boardCategoryVO)
                             throws java.lang.Exception
Specified by:
selectBoardCategoryCount in interface BoardService
Throws:
java.lang.Exception

insertBoardCategory

public void insertBoardCategory(BoardCategoryVO boardCategoryVO)
                         throws java.lang.Exception
Specified by:
insertBoardCategory in interface BoardService
Throws:
java.lang.Exception

updateBoardCategory

public void updateBoardCategory(BoardCategoryVO boardCategoryVO)
                         throws java.lang.Exception
Specified by:
updateBoardCategory in interface BoardService
Throws:
java.lang.Exception

deleteBoardCategory

public void deleteBoardCategory(BoardCategoryVO boardCategoryVO)
                         throws java.lang.Exception
Specified by:
deleteBoardCategory in interface BoardService
Throws:
java.lang.Exception

getBoardItem

public BoardVO getBoardItem(BoardVO boardVO)
                     throws java.lang.Exception
Specified by:
getBoardItem in interface BoardService
Throws:
java.lang.Exception

updateBoardItemList

public void updateBoardItemList(BoardVO boardVO)
                         throws java.lang.Exception
Specified by:
updateBoardItemList in interface BoardService
Throws:
java.lang.Exception

updateBoardItemView

public void updateBoardItemView(BoardVO boardVO)
                         throws java.lang.Exception
Specified by:
updateBoardItemView in interface BoardService
Throws:
java.lang.Exception

updateBoardItemWrite

public void updateBoardItemWrite(BoardVO boardVO)
                          throws java.lang.Exception
Specified by:
updateBoardItemWrite in interface BoardService
Throws:
java.lang.Exception

selectBoardSkinListTotal

public int selectBoardSkinListTotal(BoardSkinVO boardSkinVO)
                             throws java.lang.Exception
Specified by:
selectBoardSkinListTotal in interface BoardService
Throws:
java.lang.Exception

selectBoardSkinList

public java.util.List<BoardSkinVO> selectBoardSkinList(BoardSkinVO boardSkinVO)
                                                throws java.lang.Exception
Specified by:
selectBoardSkinList in interface BoardService
Throws:
java.lang.Exception

getBoardSkin

public BoardSkinVO getBoardSkin(BoardSkinVO boardSkinVO)
                         throws java.lang.Exception
Specified by:
getBoardSkin in interface BoardService
Throws:
java.lang.Exception

getBoardSkinId

public BoardSkinVO getBoardSkinId(BoardSkinVO boardSkinVO)
                           throws java.lang.Exception
Specified by:
getBoardSkinId in interface BoardService
Throws:
java.lang.Exception

selectBoardSkinIdCount

public int selectBoardSkinIdCount(BoardSkinVO boardSkinVO)
                           throws java.lang.Exception
Specified by:
selectBoardSkinIdCount in interface BoardService
Throws:
java.lang.Exception

insertBoardSkin

public void insertBoardSkin(BoardSkinVO boardSkinVO)
                     throws java.lang.Exception
Specified by:
insertBoardSkin in interface BoardService
Throws:
java.lang.Exception

updateBoardSkin

public void updateBoardSkin(BoardSkinVO boardSkinVO)
                     throws java.lang.Exception
Specified by:
updateBoardSkin in interface BoardService
Throws:
java.lang.Exception

selectBoardSkinArea

public BoardSkinVO selectBoardSkinArea(BoardSkinVO boardSkinVO)
                                throws java.lang.Exception
Specified by:
selectBoardSkinArea in interface BoardService
Throws:
java.lang.Exception

updateBoardSkinArea

public void updateBoardSkinArea(BoardSkinVO boardSkinVO)
                         throws java.lang.Exception
Specified by:
updateBoardSkinArea in interface BoardService
Throws:
java.lang.Exception

deleteSkin

public void deleteSkin(BoardSkinVO boardSkinVO)
                throws java.lang.Exception
Specified by:
deleteSkin in interface BoardService
Throws:
java.lang.Exception

deleteSkinEtc

public void deleteSkinEtc(BoardSkinVO boardSkinVO)
                   throws java.lang.Exception
Specified by:
deleteSkinEtc in interface BoardService
Throws:
java.lang.Exception

insertBoardSkinEtc

public void insertBoardSkinEtc(BoardSkinEtcVO boardSkinEtcVO)
                        throws java.lang.Exception
Specified by:
insertBoardSkinEtc in interface BoardService
Throws:
java.lang.Exception

updateBoardSkinEtc

public void updateBoardSkinEtc(BoardSkinEtcVO boardSkinEtcVO)
                        throws java.lang.Exception
Specified by:
updateBoardSkinEtc in interface BoardService
Throws:
java.lang.Exception

selectBoardSkinEtcCount

public int selectBoardSkinEtcCount(BoardSkinEtcVO boardSkinEtcVO)
                            throws java.lang.Exception
Specified by:
selectBoardSkinEtcCount in interface BoardService
Throws:
java.lang.Exception

getBoardSkinEtc

public BoardSkinEtcVO getBoardSkinEtc(BoardSkinEtcVO boardSkinEtcVO)
                               throws java.lang.Exception
Specified by:
getBoardSkinEtc in interface BoardService
Throws:
java.lang.Exception

updateBoardSkinPublic

public void updateBoardSkinPublic(BoardSkinVO boardSkinVO)
                           throws java.lang.Exception
Specified by:
updateBoardSkinPublic in interface BoardService
Throws:
java.lang.Exception

updateBoardSkinList

public void updateBoardSkinList(BoardSkinVO boardSkinVO)
                         throws java.lang.Exception
Specified by:
updateBoardSkinList in interface BoardService
Throws:
java.lang.Exception

updateBoardSkinWrite

public void updateBoardSkinWrite(BoardSkinVO boardSkinVO)
                          throws java.lang.Exception
Specified by:
updateBoardSkinWrite in interface BoardService
Throws:
java.lang.Exception

updateBoardSkinView

public void updateBoardSkinView(BoardSkinVO boardSkinVO)
                         throws java.lang.Exception
Specified by:
updateBoardSkinView in interface BoardService
Throws:
java.lang.Exception

getExampleSkin

public java.lang.String getExampleSkin(java.lang.String skinType,
                                       java.lang.String skinArea)
                                throws java.lang.Exception
Specified by:
getExampleSkin in interface BoardService
Throws:
java.lang.Exception

getExampleEditorSkin

public java.lang.String getExampleEditorSkin(java.lang.String skinType,
                                             java.lang.String skinEditor,
                                             java.lang.String skinArea)
                                      throws java.lang.Exception
Specified by:
getExampleEditorSkin in interface BoardService
Throws:
java.lang.Exception

selectBoardSkinBackup

public java.util.List<BoardSkinHistoryVO> selectBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
                                                         throws java.lang.Exception
Specified by:
selectBoardSkinBackup in interface BoardService
Throws:
java.lang.Exception

getBoardSkinBackup

public BoardSkinHistoryVO getBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
                                      throws java.lang.Exception
Specified by:
getBoardSkinBackup in interface BoardService
Throws:
java.lang.Exception

insertBoardSkinBackup

public void insertBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
                           throws java.lang.Exception
Specified by:
insertBoardSkinBackup in interface BoardService
Throws:
java.lang.Exception

initBoardSkinBackup

public void initBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
                         throws java.lang.Exception
Specified by:
initBoardSkinBackup in interface BoardService
Throws:
java.lang.Exception

updateBoardSkinBackup

public void updateBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
                           throws java.lang.Exception
Specified by:
updateBoardSkinBackup in interface BoardService
Throws:
java.lang.Exception

selectBoardDataListTotal

public int selectBoardDataListTotal(BoardSearchVO boardSearchVO)
                             throws java.lang.Exception
Specified by:
selectBoardDataListTotal in interface BoardService
Throws:
java.lang.Exception

selectBoardDataList

public java.util.List<BoardDataVO> selectBoardDataList(BoardSearchVO boardSearchVO)
                                                throws java.lang.Exception
Specified by:
selectBoardDataList in interface BoardService
Throws:
java.lang.Exception

boardSearchFilter

public BoardSearchVO boardSearchFilter(BoardSearchVO boardSearchVO)
BOARD SELECT QUERY 제외, JKH ,20160817

Parameters:
boardSearchVO -
Returns:

selectBoardNoticeDataList

public java.util.List<BoardDataVO> selectBoardNoticeDataList(BoardSearchVO boardSearchVO)
                                                      throws java.lang.Exception
Specified by:
selectBoardNoticeDataList in interface BoardService
Throws:
java.lang.Exception

selectStandByDataList

public java.util.List<BoardDataVO> selectStandByDataList(BoardSearchVO boardSearchVO)
                                                  throws java.lang.Exception
승인대기 게시물 목록

Specified by:
selectStandByDataList in interface BoardService
Parameters:
boardSearchVO -
Returns:
Throws:
java.lang.Exception

getBoardData

public BoardDataVO getBoardData(BoardDataVO boardDataVO)
                         throws java.lang.Exception
Specified by:
getBoardData in interface BoardService
Throws:
java.lang.Exception

getBoardDataIdx

public int getBoardDataIdx(BoardVO boardVO)
                    throws java.lang.Exception
Specified by:
getBoardDataIdx in interface BoardService
Throws:
java.lang.Exception

passwordValidate

public int passwordValidate(BoardSearchVO boardSearchVO)
                     throws java.lang.Exception
Specified by:
passwordValidate in interface BoardService
Throws:
java.lang.Exception

insertBoardData

public void insertBoardData(BoardDataVO boardDataVO)
                     throws java.lang.Exception
Specified by:
insertBoardData in interface BoardService
Throws:
java.lang.Exception

updateBoardData

public void updateBoardData(BoardDataVO boardDataVO)
                     throws java.lang.Exception
Specified by:
updateBoardData in interface BoardService
Throws:
java.lang.Exception

deleteBoardData

public void deleteBoardData(BoardDataVO boardDataVO)
                     throws java.lang.Exception
게시물 삭제 상태 변경

Specified by:
deleteBoardData in interface BoardService
Throws:
java.lang.Exception

updateBoardDataStatus

public void updateBoardDataStatus(BoardDataVO boardDataVO)
                           throws java.lang.Exception
게시물 차단 상태 변경

Specified by:
updateBoardDataStatus in interface BoardService
Parameters:
boardDataVO -
Throws:
java.lang.Exception

updateBoardDataAnswerStatus

public void updateBoardDataAnswerStatus(BoardDataVO boardDataVO)
                                 throws java.lang.Exception
Specified by:
updateBoardDataAnswerStatus in interface BoardService
Throws:
java.lang.Exception

updateBoardDataReplyNotice

public void updateBoardDataReplyNotice(BoardDataVO boardDataVO)
                                throws java.lang.Exception
Specified by:
updateBoardDataReplyNotice in interface BoardService
Throws:
java.lang.Exception

selectBoardExtensionDataCount

public int selectBoardExtensionDataCount(BoardExtensionDataVO boardExtensionDataVO)
                                  throws java.lang.Exception
Specified by:
selectBoardExtensionDataCount in interface BoardService
Throws:
java.lang.Exception

insertExtensionData

public void insertExtensionData(BoardExtensionDataVO boardExtensionDataVO)
                         throws java.lang.Exception
Specified by:
insertExtensionData in interface BoardService
Throws:
java.lang.Exception

updateExtensionData

public void updateExtensionData(BoardExtensionDataVO boardExtensionDataVO)
                         throws java.lang.Exception
Specified by:
updateExtensionData in interface BoardService
Throws:
java.lang.Exception

selectBoardExtensionDataList

public java.util.List<BoardExtensionDataVO> selectBoardExtensionDataList(BoardDataVO boardDataVO)
                                                                  throws java.lang.Exception
Specified by:
selectBoardExtensionDataList in interface BoardService
Throws:
java.lang.Exception

updateDataReplyOrder

public void updateDataReplyOrder(BoardDataVO boardDataVO)
                          throws java.lang.Exception
Specified by:
updateDataReplyOrder in interface BoardService
Throws:
java.lang.Exception

updateDataViewCount

public void updateDataViewCount(BoardDataVO boardDataVO)
                         throws java.lang.Exception
Specified by:
updateDataViewCount in interface BoardService
Throws:
java.lang.Exception

updateDataStarPoint

public void updateDataStarPoint(BoardDataVO boardDataVO)
                         throws java.lang.Exception
Specified by:
updateDataStarPoint in interface BoardService
Throws:
java.lang.Exception

updateDataRegisterDt

public java.lang.String updateDataRegisterDt(long dataSid,
                                             java.lang.String register_dt)
Specified by:
updateDataRegisterDt in interface BoardService

selectBoardFile

public java.util.List<BoardFileVO> selectBoardFile(BoardDataVO boardDataVO)
                                            throws java.lang.Exception
Specified by:
selectBoardFile in interface BoardService
Throws:
java.lang.Exception

getBoardFile

public BoardFileVO getBoardFile(BoardFileVO boardFileVO)
                         throws java.lang.Exception
Specified by:
getBoardFile in interface BoardService
Throws:
java.lang.Exception

insertBoardFile

public void insertBoardFile(BoardFileVO boardFileVO)
                     throws java.lang.Exception
Specified by:
insertBoardFile in interface BoardService
Throws:
java.lang.Exception

updateBoardFile

public void updateBoardFile(BoardFileVO boardFileVO)
                     throws java.lang.Exception
Specified by:
updateBoardFile in interface BoardService
Throws:
java.lang.Exception

updateBoardFileId

public void updateBoardFileId(BoardFileVO boardFileVO)
                       throws java.lang.Exception
Specified by:
updateBoardFileId in interface BoardService
Throws:
java.lang.Exception

deleteBoardFile

public void deleteBoardFile(BoardFileVO boardFileVO)
                     throws java.lang.Exception
Specified by:
deleteBoardFile in interface BoardService
Throws:
java.lang.Exception

updateFileDeleteStatus

public void updateFileDeleteStatus(BoardDataVO boardDataVO)
                            throws java.lang.Exception
Specified by:
updateFileDeleteStatus in interface BoardService
Throws:
java.lang.Exception

getDataContent

public java.lang.String getDataContent(BoardDataVO boardDataVO)
                                throws java.lang.Exception
Specified by:
getDataContent in interface BoardService
Throws:
java.lang.Exception

selectBoardDataReplyCount

public int selectBoardDataReplyCount(BoardDataVO boardDataVO)
                              throws java.lang.Exception
Specified by:
selectBoardDataReplyCount in interface BoardService
Throws:
java.lang.Exception

selectBoardDataOriginal

public java.util.List<BoardDataVO> selectBoardDataOriginal(BoardDataVO boardDataVO)
                                                    throws java.lang.Exception
Specified by:
selectBoardDataOriginal in interface BoardService
Throws:
java.lang.Exception

selectBoardDataReplyList

public java.util.List<BoardDataVO> selectBoardDataReplyList(BoardDataVO boardDataVO)
                                                     throws java.lang.Exception
Specified by:
selectBoardDataReplyList in interface BoardService
Throws:
java.lang.Exception

getBoardCommentIdx

public int getBoardCommentIdx(BoardSearchVO boardSearchVO)
                       throws java.lang.Exception
Specified by:
getBoardCommentIdx in interface BoardService
Throws:
java.lang.Exception

selectCommentCount

public int selectCommentCount(BoardSearchVO boardSearchVO)
                       throws java.lang.Exception
Specified by:
selectCommentCount in interface BoardService
Throws:
java.lang.Exception

selectCommentList

public java.util.List<CommentVO> selectCommentList(BoardSearchVO boardSearchVO)
                                            throws java.lang.Exception
Specified by:
selectCommentList in interface BoardService
Throws:
java.lang.Exception

getComment

public CommentVO getComment(CommentVO commentVO)
                     throws java.lang.Exception
Specified by:
getComment in interface BoardService
Throws:
java.lang.Exception

updateCommentReplyOrder

public void updateCommentReplyOrder(CommentVO commentVO)
                             throws java.lang.Exception
Specified by:
updateCommentReplyOrder in interface BoardService
Throws:
java.lang.Exception

insertComment

public void insertComment(CommentVO commentVO)
                   throws java.lang.Exception
Specified by:
insertComment in interface BoardService
Throws:
java.lang.Exception

deleteComment

public void deleteComment(CommentVO commentVO)
                   throws java.lang.Exception
Specified by:
deleteComment in interface BoardService
Throws:
java.lang.Exception

getStarPoint

public int getStarPoint(BoardSearchVO boardSearchVO)
                 throws java.lang.Exception
Specified by:
getStarPoint in interface BoardService
Throws:
java.lang.Exception

selectBoardActionTotal

public int selectBoardActionTotal(BoardActionVO boardActionVO)
                           throws java.lang.Exception
Specified by:
selectBoardActionTotal in interface BoardService
Throws:
java.lang.Exception

selectBoardActionCount

public int selectBoardActionCount(BoardActionVO boardActionVO)
                           throws java.lang.Exception
Specified by:
selectBoardActionCount in interface BoardService
Throws:
java.lang.Exception

selectBoardActionList

public java.util.List<BoardActionVO> selectBoardActionList(BoardActionVO boardActionVO)
                                                    throws java.lang.Exception
Specified by:
selectBoardActionList in interface BoardService
Throws:
java.lang.Exception

selectBoardActionListAll

public java.util.List<BoardActionVO> selectBoardActionListAll(BoardActionVO boardActionVO)
                                                       throws java.lang.Exception
Specified by:
selectBoardActionListAll in interface BoardService
Throws:
java.lang.Exception

getBoardAction

public BoardActionVO getBoardAction(BoardActionVO boardActionVO)
                             throws java.lang.Exception
Specified by:
getBoardAction in interface BoardService
Throws:
java.lang.Exception

insertBoardAction

public void insertBoardAction(BoardActionVO boardActionVO)
                       throws java.lang.Exception
Specified by:
insertBoardAction in interface BoardService
Throws:
java.lang.Exception

updateBoardAction

public void updateBoardAction(BoardActionVO boardActionVO)
                       throws java.lang.Exception
Specified by:
updateBoardAction in interface BoardService
Throws:
java.lang.Exception

deleteBoardAction

public void deleteBoardAction(BoardActionVO boardActionVO)
                       throws java.lang.Exception
Specified by:
deleteBoardAction in interface BoardService
Throws:
java.lang.Exception

selectBoardHistoryListTotal

public int selectBoardHistoryListTotal(BoardHistoryVO boardHistoryVO)
                                throws java.lang.Exception
Specified by:
selectBoardHistoryListTotal in interface BoardService
Throws:
java.lang.Exception

selectBoardHistoryList

public java.util.List<BoardHistoryVO> selectBoardHistoryList(BoardHistoryVO boardHistoryVO)
                                                      throws java.lang.Exception
Specified by:
selectBoardHistoryList in interface BoardService
Throws:
java.lang.Exception

insertBoardHistory

public void insertBoardHistory(long logId,
                               java.lang.String boardId,
                               long boardSid,
                               long dataSid,
                               java.lang.String actionType,
                               java.lang.String dataTitle,
                               java.lang.String userId,
                               java.lang.String userName,
                               java.lang.String userIp,
                               java.lang.String writeID,
                               java.lang.String WriteName)
                        throws java.lang.Exception
Specified by:
insertBoardHistory in interface BoardService
Throws:
java.lang.Exception

selectDownloadHistoryTotal

public int selectDownloadHistoryTotal(java.lang.String boardId,
                                      long dataSid,
                                      long fileSid)
                               throws java.lang.Exception
Specified by:
selectDownloadHistoryTotal in interface BoardService
Throws:
java.lang.Exception

selectDownloadHistoryTotal

public int selectDownloadHistoryTotal(java.lang.String boardId,
                                      long dataSid,
                                      long fileSid,
                                      boolean isNow)
                               throws java.lang.Exception
Specified by:
selectDownloadHistoryTotal in interface BoardService
Throws:
java.lang.Exception

insertBoardDataBackup

public void insertBoardDataBackup(BoardDataVO boardDataVO)
                           throws java.lang.Exception
Specified by:
insertBoardDataBackup in interface BoardService
Throws:
java.lang.Exception

selectBoardDataBackupTotal

public int selectBoardDataBackupTotal(BoardVO boardVO)
                               throws java.lang.Exception
Specified by:
selectBoardDataBackupTotal in interface BoardService
Throws:
java.lang.Exception

selectBackupHistoryTotal

public int selectBackupHistoryTotal(BoardDataVO boardDataVO)
                             throws java.lang.Exception
Specified by:
selectBackupHistoryTotal in interface BoardService
Throws:
java.lang.Exception

selectBoardDataBackupList

public java.util.List<BoardDataVO> selectBoardDataBackupList(BoardVO boardVO)
                                                      throws java.lang.Exception
Specified by:
selectBoardDataBackupList in interface BoardService
Throws:
java.lang.Exception

selectBackupHistoryList

public java.util.List<BoardDataVO> selectBackupHistoryList(BoardDataVO boardDataVO)
                                                    throws java.lang.Exception
Specified by:
selectBackupHistoryList in interface BoardService
Throws:
java.lang.Exception

getBoardDataBak

public BoardDataVO getBoardDataBak(BoardDataVO boardDataVO)
                            throws java.lang.Exception
Specified by:
getBoardDataBak in interface BoardService
Throws:
java.lang.Exception

restoreBoardDataBak

public void restoreBoardDataBak(BoardVO boardVO)
                         throws java.lang.Exception
삭제 게시물 복구일자 설정

Specified by:
restoreBoardDataBak in interface BoardService
Parameters:
boardDataVO -
Throws:
java.lang.Exception

getBoardDataBakList

public java.util.List<BoardDataVO> getBoardDataBakList(BoardVO boardVO)
                                                throws java.lang.Exception
Specified by:
getBoardDataBakList in interface BoardService
Throws:
java.lang.Exception

deleteBoardDataBak

public void deleteBoardDataBak(BoardVO boardVO)
                        throws java.lang.Exception
Specified by:
deleteBoardDataBak in interface BoardService
Throws:
java.lang.Exception

selectBoardDataManagerTotal

public int selectBoardDataManagerTotal(BoardVO boardVO)
                                throws java.lang.Exception
Specified by:
selectBoardDataManagerTotal in interface BoardService
Throws:
java.lang.Exception

selectBoardDataManagerList

public java.util.List<BoardDataVO> selectBoardDataManagerList(BoardVO boardVO)
                                                       throws java.lang.Exception
Specified by:
selectBoardDataManagerList in interface BoardService
Throws:
java.lang.Exception

selectBoardDataManagerStandbyListCnt

public int selectBoardDataManagerStandbyListCnt(BoardVO boardVO)
                                         throws java.lang.Exception
게시물 관리 대기 목록수

Specified by:
selectBoardDataManagerStandbyListCnt in interface BoardService
Parameters:
boardVO -
Returns:
Throws:
java.lang.Exception

selectBoardDataManagerStandbyList

public java.util.List<BoardDataVO> selectBoardDataManagerStandbyList(BoardVO boardVO)
                                                              throws java.lang.Exception
게시물 관리 대기 목록

Specified by:
selectBoardDataManagerStandbyList in interface BoardService
Parameters:
boardVO -
Returns:
Throws:
java.lang.Exception

deleteDataListManager

public void deleteDataListManager(BoardVO boardVO)
                           throws java.lang.Exception
Specified by:
deleteDataListManager in interface BoardService
Throws:
java.lang.Exception

deleteDataFileManager

public void deleteDataFileManager(BoardVO boardVO)
                           throws java.lang.Exception
Specified by:
deleteDataFileManager in interface BoardService
Throws:
java.lang.Exception

deleteDataExtManager

public void deleteDataExtManager(BoardVO boardVO)
                          throws java.lang.Exception
Specified by:
deleteDataExtManager in interface BoardService
Throws:
java.lang.Exception

deleteDataCommentManager

public void deleteDataCommentManager(BoardVO boardVO)
                              throws java.lang.Exception
Specified by:
deleteDataCommentManager in interface BoardService
Throws:
java.lang.Exception

getMultiFileList

public java.util.List<BoardFileVO> getMultiFileList(BoardVO boardVO)
                                             throws java.lang.Exception
Specified by:
getMultiFileList in interface BoardService
Throws:
java.lang.Exception

selectCommentListAll

public java.util.List<CommentVO> selectCommentListAll(BoardDataVO boardDataVO)
                                               throws java.lang.Exception
Specified by:
selectCommentListAll in interface BoardService
Throws:
java.lang.Exception

selectBoardReplyOfficeList

public java.util.List<BoardReplyVO> selectBoardReplyOfficeList(BoardReplyVO boardReplyVO)
                                                        throws java.lang.Exception
Specified by:
selectBoardReplyOfficeList in interface BoardService
Throws:
java.lang.Exception

insertBoardReplyOffice

public void insertBoardReplyOffice(BoardReplyVO boardReplyVO)
                            throws java.lang.Exception
Specified by:
insertBoardReplyOffice in interface BoardService
Throws:
java.lang.Exception

updateBoardReplyOffice

public void updateBoardReplyOffice(BoardReplyVO boardReplyVO)
                            throws java.lang.Exception
Specified by:
updateBoardReplyOffice in interface BoardService
Throws:
java.lang.Exception

deleteBoardReplyOffice

public void deleteBoardReplyOffice(BoardReplyVO boardReplyVO)
                            throws java.lang.Exception
Specified by:
deleteBoardReplyOffice in interface BoardService
Throws:
java.lang.Exception

getBoardReplyOffice

public BoardReplyVO getBoardReplyOffice(BoardReplyVO boardReplyVO)
                                 throws java.lang.Exception
Specified by:
getBoardReplyOffice in interface BoardService
Throws:
java.lang.Exception

selectScheduleDataListTotal

public int selectScheduleDataListTotal(BoardSearchVO boardSearchVO)
                                throws java.lang.Exception
Specified by:
selectScheduleDataListTotal in interface BoardService
Throws:
java.lang.Exception

selectScheduleDataList

public java.util.List<BoardDataVO> selectScheduleDataList(BoardSearchVO boardSearchVO)
                                                   throws java.lang.Exception
Specified by:
selectScheduleDataList in interface BoardService
Throws:
java.lang.Exception

insertDownloadHistory

public void insertDownloadHistory(DownloadHistoryVO downloadHistoryVO)
                           throws java.lang.Exception
Specified by:
insertDownloadHistory in interface BoardService
Throws:
java.lang.Exception

getBoardMenuList

public java.util.List<MenuVO> getBoardMenuList(BoardSearchVO boardSearchVO)
                                        throws java.lang.Exception
Specified by:
getBoardMenuList in interface BoardService
Throws:
java.lang.Exception

insertFileId

public java.lang.String insertFileId(java.lang.String boardId,
                                     java.lang.String dataSid,
                                     java.lang.String fileSid,
                                     javax.servlet.http.HttpServletRequest request)
                              throws java.lang.Exception
Specified by:
insertFileId in interface BoardService
Throws:
java.lang.Exception

boardDataCount

public java.util.List<BoardCountVO> boardDataCount(BoardSearchVO boardSearchVO)
                                            throws java.lang.Exception
Specified by:
boardDataCount in interface BoardService
Throws:
java.lang.Exception

boardOfficeCount

public java.util.List<BoardCountVO> boardOfficeCount(BoardSearchVO boardSearchVO)
                                              throws java.lang.Exception
Specified by:
boardOfficeCount in interface BoardService
Throws:
java.lang.Exception

updateDataTmpField

public int updateDataTmpField(long dataSid,
                              int tmpDp,
                              java.lang.String tmpField)
                       throws java.lang.Exception
게시물 임시필드값 수정 (DWR)

Specified by:
updateDataTmpField in interface BoardService
Parameters:
boardEtcVO -
Throws:
java.lang.Exception

listBoardReplyOffice

public java.util.List<BoardReplyVO> listBoardReplyOffice(BoardReplyVO boardReplyVO)
                                                  throws java.lang.Exception
담당부서 설정

Specified by:
listBoardReplyOffice in interface BoardService
Parameters:
boardReplyVO -
Returns:
Throws:
java.lang.Exception

getCommentCnt

public int getCommentCnt(CommentVO commentVO)
                  throws java.lang.Exception
Specified by:
getCommentCnt in interface BoardService
Throws:
java.lang.Exception

deleteUserBoardData

public void deleteUserBoardData(BoardDataVO boardDataVO)
                         throws java.lang.Exception
게시물 삭제 상태 변경

Specified by:
deleteUserBoardData in interface BoardService
Throws:
java.lang.Exception

deleteRealBoardData

public void deleteRealBoardData(BoardDataVO boardDataVO)
                         throws java.lang.Exception
Specified by:
deleteRealBoardData in interface BoardService
Throws:
java.lang.Exception

selectBoardDataReplyCnt

public int selectBoardDataReplyCnt(BoardDataVO boardDataVO)
                            throws java.lang.Exception
Specified by:
selectBoardDataReplyCnt in interface BoardService
Throws:
java.lang.Exception

getBoardCommentAllCnt

public int getBoardCommentAllCnt(BoardSearchVO boardSearchVO)
                          throws java.lang.Exception
만족도 전체리스트 년 월 일 카운트

Specified by:
getBoardCommentAllCnt in interface BoardService
Throws:
java.lang.Exception

getCommentListAllPage

public java.util.List<CommentVO> getCommentListAllPage(BoardSearchVO boardSearchVO)
                                                throws java.lang.Exception
만족도 전체리스트 년 월 일 검색

Specified by:
getCommentListAllPage in interface BoardService
Parameters:
boardSearchVO -
Returns:
Throws:
java.lang.Exception

getCommentListAll

public java.util.List<CommentVO> getCommentListAll(BoardSearchVO boardSearchVO)
                                            throws java.lang.Exception
만족도 전체리스트 년 월 일 검색 ALL

Specified by:
getCommentListAll in interface BoardService
Parameters:
boardSearchVO -
Returns:
Throws:
java.lang.Exception

selectNoticeUpdateDataList

public java.util.List<BoardDataVO> selectNoticeUpdateDataList(BoardSearchVO boardSearchVO)
                                                       throws java.lang.Exception
공지 지난글 목록 검색

Specified by:
selectNoticeUpdateDataList in interface BoardService
Parameters:
boardSearchVO -
Returns:
Throws:
java.lang.Exception

selectPeriodUpdateDataList

public java.util.List<BoardDataVO> selectPeriodUpdateDataList(BoardSearchVO boardSearchVO)
                                                       throws java.lang.Exception
Specified by:
selectPeriodUpdateDataList in interface BoardService
Throws:
java.lang.Exception

updateNoticeData

public void updateNoticeData(BoardDataVO boardDataVO)
                      throws java.lang.Exception
공지기간 지난글 업데이트

Specified by:
updateNoticeData in interface BoardService
Parameters:
boardDataVO -
Throws:
java.lang.Exception

updatePeriodData

public void updatePeriodData(BoardDataVO boardDataVO)
                      throws java.lang.Exception
Specified by:
updatePeriodData in interface BoardService
Throws:
java.lang.Exception

insertBoardDataLike

public void insertBoardDataLike(BoardDataLikeVO boardDataLikeVO)
                         throws java.lang.Exception
게시판글 좋아요,싫어요,찬성,반대

Specified by:
insertBoardDataLike in interface BoardService
Parameters:
boardDataLikeVO -
Throws:
java.lang.Exception

deleteBoardDataLike

public void deleteBoardDataLike(BoardDataLikeVO boardDataLikeVO)
                         throws java.lang.Exception
Specified by:
deleteBoardDataLike in interface BoardService
Throws:
java.lang.Exception

selectBoardDataLikeCnt

public int selectBoardDataLikeCnt(BoardDataLikeVO boardDataLikeVO)
                           throws java.lang.Exception
Specified by:
selectBoardDataLikeCnt in interface BoardService
Throws:
java.lang.Exception

selectBoardDataLikeList

public java.util.List<BoardDataLikeVO> selectBoardDataLikeList(BoardDataLikeVO boardDataLikeVO)
                                                        throws java.lang.Exception
Specified by:
selectBoardDataLikeList in interface BoardService
Throws:
java.lang.Exception

insertCommentDataLike

public void insertCommentDataLike(CommentLikeVO commentLikeVO)
                           throws java.lang.Exception
게시판 댓글 공감 비공감

Specified by:
insertCommentDataLike in interface BoardService
Parameters:
commentLikeVO -
Throws:
java.lang.Exception

selectBoardCommentLikeCnt

public int selectBoardCommentLikeCnt(CommentLikeVO commentLikeVO)
                              throws java.lang.Exception
Specified by:
selectBoardCommentLikeCnt in interface BoardService
Throws:
java.lang.Exception

getExtendedSelectNot

public boolean getExtendedSelectNot(java.lang.String boardId,
                                    long dataSid,
                                    int officeRegDp,
                                    java.lang.String selectProcTime)
                             throws java.lang.Exception
Throws:
java.lang.Exception

getBoardRecentlyPosted

public BoardDataVO getBoardRecentlyPosted(BoardDataVO boardDataVO)
                                   throws java.lang.Exception
관리자 게시판목록 게시판에 따른 최근게시일

Specified by:
getBoardRecentlyPosted in interface BoardService
Throws:
java.lang.Exception