package itn.let.lett.service.impl;

import java.io.File;
import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import egovframework.rte.fdl.cmmn.EgovAbstractServiceImpl;
import egovframework.rte.fdl.idgnr.EgovIdGnrService;
import itn.com.cmm.service.FileVO;
import itn.com.cmm.service.impl.FileManageDAO;
import itn.let.lett.service.CateConfVO;
import itn.let.lett.service.HashConfVO;
import itn.let.lett.service.LetterService;
import itn.let.lett.service.LetterVO;
import itn.let.sym.ccm.cde.service.CateCode;
import itn.let.uss.umt.service.UserDefaultVO;

@Service("LetterService")
public class LetterServiceImpl extends EgovAbstractServiceImpl implements LetterService {

    @Resource(name="LetterDAO")
    private LetterDAO letterDAO;
    
	@Resource(name = "FileManageDAO")
	private FileManageDAO fileMngDAO;

    @Resource(name = "egovLetterInfoIdGnrService")
	private EgovIdGnrService idgenService;
    
    public List<CateCode> selectLetterMessageCategoryList() throws Exception{
    	
    	return letterDAO.selectLetterMessageCategoryList();
    }
    
    public String insertLetterMessages(LetterVO letterVO) throws Exception{
    	
    	// 문자등록 고유 아이디 생성하기
    	String letterId = idgenService.getNextStringId();
    	letterVO.setLetterId(letterId);
    	letterDAO.insertLetterMessages(letterVO);
    	
    	return letterId;
    }
    
    public List<?> selectLetterMessageList(UserDefaultVO userSearchVO) throws Exception{
    	
    	return letterDAO.selectLetterMessageList(userSearchVO);
    }
    
    public void deleteLetterMessage(String checkedIdForDel) throws Exception{
    	
    	String [] delId = checkedIdForDel.split(",");
		for (int i=0; i<delId.length ; i++){
		    
			letterDAO.deleteLetterMessage(delId[i]);

		}
    	
    }
    
    public LetterVO letterMessagesDetail(LetterVO letterVO) throws Exception{
    	
    	return letterDAO.letterMessagesDetail(letterVO);
    }
    
    public int updateLetterMessages(LetterVO letterVO) throws Exception{
    	
    	return letterDAO.updateLetterMessages(letterVO);
    }
    
    public List<CateCode> selectCateCodeTwoDptWithList(CateCode cateCode) throws Exception{
    	
    	return letterDAO.selectCateCodeTwoDptWithList(cateCode);
    }
    
    public List<CateCode> selectCateCodeThrDptWithList(CateCode cateCode) throws Exception{
    	
    	return letterDAO.selectCateCodeThrDptWithList(cateCode);
    }
    
    public List<CateCode> selectPhotoCateCodeWithList(CateCode cateCode) throws Exception{
    	
    	return letterDAO.selectPhotoCateCodeWithList(cateCode);
    }
    
    public List<CateCode> selectCateConfWithList(String categoryType) throws Exception{
    	
    	return letterDAO.selectCateConfWithList(categoryType);
    }
    
    public List<CateCode> selectCateConfWithList4Main(String categoryType) throws Exception{
    	
    	return letterDAO.selectCateConfWithList4Main(categoryType);
    }

    public List<CateCode> selectCateConfTwoDepthWithList(String categoryType) throws Exception{
    	
    	return letterDAO.selectCateConfTwoDepthWithList(categoryType);
    }
    
    public List<CateCode> selectCateConfThreeDepthWithList(CateCode cateCode) throws Exception{
    	
    	return letterDAO.selectCateConfThreeDepthWithList(cateCode);
    }
    
    public List<HashConfVO> selectHashTagWithList(String msgType) throws Exception{
    	
    	return letterDAO.selectHashTagWithList(msgType);
    }
    
    public String insertletterPhotosInfo(LetterVO letterVO) throws Exception{
    	
    	// 문자등록 고유 아이디 생성하기
    	String letterId = idgenService.getNextStringId();
    	letterVO.setLetterId(letterId);
    	letterDAO.insertletterPhotosInfo(letterVO);
    	
    	return letterId;
    }
    
    public List<?> selectLetterPhotosList(UserDefaultVO userSearchVO) throws Exception{
    	
    	return letterDAO.selectLetterPhotosList(userSearchVO);
    }
    
    public void deleteLetterPhotos(String checkedIdForDel) throws Exception{
    	
    	// 장/단문 문자 삭제와 동일한 프로세스 처리
    	String [] delId = checkedIdForDel.split(",");
    	LetterVO letterVO = new LetterVO();
    	
		for (int i=0; i<delId.length ; i++){
		    
			//첨부파일 삭제
			letterVO.setLetterId(delId[i]);
			
			// 그림문자 첨부파일 아이디 정보 받아오기
			LetterVO result = letterDAO.selectPhotosDetail(letterVO); 
			String attachFileId = result.getAttachFileId();
			
			// 첨부파일 시퀀스번호 때문에 불러옴.
			LetterVO resultFile = letterDAO.selectPhotoFileList(attachFileId);
			
			if(resultFile != null) { // 등록된 첨부파일이 있는 경우만 삭제처리
				
				//첨부파일 데이터 삭제
				FileVO returnFileVO = new FileVO();
				FileVO fileVO = new FileVO();
				fileVO.setAtchFileId(attachFileId);
				fileVO.setFileSn(resultFile.getFileSn());	//첨부파일을 하나만 등록하기 때문에 0으로 셋팅해줌
				returnFileVO = fileMngDAO.selectFileInf(fileVO);
				if(returnFileVO !=null) {
					File delFile = new File(returnFileVO.getFileStreCours()+returnFileVO.getStreFileNm());
					delFile.delete(); //실제파일  deletePerFile 삭제
				}

				// 첨부파일 테이블에서 첨부파일 내용 삭제
				fileMngDAO.deleteFileInf(fileVO); //DB삭제
				
			}
			
			// 그림 문자 내용 삭제처리 - Flag Update
			letterDAO.deleteLetterMessage(delId[i]);

		}
    }
    
    public List<CateCode> selectPhotoCateCodeListWithId(String cateCode) throws Exception{

    	return letterDAO.selectPhotoCateCodeListWithId(cateCode);
    }
    
    public LetterVO selectPhotosDetail(LetterVO letterVO) throws Exception{
    	
    	return letterDAO.selectPhotosDetail(letterVO); 
    }
    
    public LetterVO selectPhotoFileList(String attchFileId) throws Exception{
    	
    	return letterDAO.selectPhotoFileList(attchFileId);
    }
    
    public int updateLetterPhotosInfo(LetterVO letterVO) throws Exception{
    	
    	return letterDAO.updateLetterPhotosInfo(letterVO);
    }
    
    
    // 문자 발송 카테고리 관리
    
    // 문자 발송 카테고리 정보 저장하기
    public int insertCategoryConf(CateConfVO cateConfVO) throws Exception{
    	
    	return letterDAO.insertCategoryConf(cateConfVO);
    }
    
    public List<?> selectCategoryConfList(UserDefaultVO userSearchVO) throws Exception{
    	
    	return letterDAO.selectCategoryConfList(userSearchVO);
    }
    
    public CateConfVO categoryConfDetail(CateConfVO cateConfVO) throws Exception{
    	
    	return letterDAO.categoryConfDetail(cateConfVO);
    }
    
    public void deleteCategoryConf(String checkedIdForDel) throws Exception{
    	
    	String [] delId = checkedIdForDel.split(",");
		for (int i=0; i<delId.length ; i++){
		    
			letterDAO.deleteCategoryConf(delId[i]);

		}
    	
    }
    
    public int updateCategoryConf(CateConfVO cateConfVO) throws Exception{
    	
    	return letterDAO.updateCategoryConf(cateConfVO);
    }
    
    
    public int insertHashTagConf(HashConfVO hashConfVO) throws Exception{
    	
    	return letterDAO.insertHashTagConf(hashConfVO);
    }
    
    public List<?> selectHashTagConfList(UserDefaultVO userSearchVO) throws Exception{
    	
    	return letterDAO.selectHashTagConfList(userSearchVO);
    }
    
    public HashConfVO hashTagConfDetail(HashConfVO hashConfVO) throws Exception{
    	
    	return letterDAO.hashTagConfDetail(hashConfVO); 
    }
    
    public int updateHashTagConf(HashConfVO hashConfVO) throws Exception{
    	
    	return letterDAO.updateHashTagConf(hashConfVO);
    }
    
    public void deleteHashTagConf(String checkedIdForDel) throws Exception{
    	
    	String [] delId = checkedIdForDel.split(",");
		for (int i=0; i<delId.length ; i++){
		    
			letterDAO.deleteHashTagConf(delId[i]);

		}
		
    	
    }
    
	 // 맞춤제작 그림문자 리스트 불러오기
	 public List<?> selectLetterPhotosCustomList(UserDefaultVO userSearchVO) throws Exception{
		 
		 return letterDAO.selectLetterPhotosCustomList(userSearchVO);
	 }
    
	 
	// 문자 템플릿 사용 계
    public int updateTemplateUseCount(String attachFileId) throws Exception{
    	
    	return letterDAO.updateTemplateUseCount(attachFileId);
    }

	@Override
	public void updateLetterIdgen(int count) throws Exception {
		for(int i = 0 ; i < count ; i++) {
			idgenService.getNextStringId();
		}
	}

	@Override
	public int updateChkAfterPriorityPlus(LetterVO letterVO) throws Exception {
		return letterDAO.updateChkAfterPriorityPlus(letterVO);
	}

	@Override
	public int updateChkListPriority(LetterVO letterVO) throws Exception {
		return letterDAO.updateChkListPriority(letterVO);
	}

	@Override
	public int updateOrderByPriority(LetterVO letterVO) throws Exception {
		return letterDAO.updateOrderByPriority(letterVO);
	}
	
	@Override
	public int updateNullPriority(LetterVO letterVO) throws Exception {
		return letterDAO.updateNullPriority(letterVO);
	}
	
	
	@Override
	public int updateChkCateAfterSortPlus(LetterVO letterVO) throws Exception {
		return letterDAO.updateChkCateAfterSortPlus(letterVO);
	}
	
	@Override
	public int updateChkCateListSort(LetterVO letterVO) throws Exception {
		return letterDAO.updateChkCateListSort(letterVO);
	}
	
	@Override
	public int updateCateOrderBySort(LetterVO letterVO) throws Exception {
		return letterDAO.updateCateOrderBySort(letterVO);
	}
	
	@Override
	public int updateCateNullSort(LetterVO letterVO) throws Exception {
		return letterDAO.updateCateNullSort(letterVO);
	}
	
	@Override
	public int updateChkTagAfterSortPlus(LetterVO letterVO) throws Exception {
		return letterDAO.updateChkTagAfterSortPlus(letterVO);
	}
	
	@Override
	public int updateChkTagListSort(LetterVO letterVO) throws Exception {
		return letterDAO.updateChkTagListSort(letterVO);
	}
	
	@Override
	public int updateTagOrderBySort(LetterVO letterVO) throws Exception {
		return letterDAO.updateTagOrderBySort(letterVO);
	}
	
	@Override
	public int updateTagNullSort(LetterVO letterVO) throws Exception {
		return letterDAO.updateTagNullSort(letterVO);
	}
	
	//검색어 욕설 및 금지 단어 검색
	@Override
	public int selectSwearWordSearchCnt(String searchKeyWord) throws Exception{
		return letterDAO.selectSwearWordSearchCnt(searchKeyWord);
	}

	@Override
	public int updateSmsTemplateViewCount(String letterId) throws Exception {
		return letterDAO.updateSmsTemplateViewCount(letterId);
	}
	
	// 제목, 해쉬태그 일괄변경
	@Override
	public int updateHashTagList(LetterVO letterVO) throws Exception {
		int updateCnt = 0;
	    for(int i = 0; i < letterVO.getLetterIds().size(); i++){
	    	System.out.println(letterVO.getLetterIds().get(i));

	    	letterVO.setLetterId(letterVO.getLetterIds().get(i));
	    	letterVO.setLetterSj(letterVO.getLetterSjs().get(i));
	    	letterVO.setHashTag(letterVO.getHashTags().get(i));
	        letterDAO.updateHashTagList(letterVO);
	        
	        updateCnt++;
	    }

		return updateCnt; 
	}	
	
	// 메인태그 관리
	@Override
	public List<LetterVO> selectMainTagList(LetterVO letterVO) throws Exception{
		return letterDAO.selectMainTagList(letterVO);
	}
	

	// 메인태그 상세
	@Override
	public LetterVO selectMainTagDetail(LetterVO letterVO) throws Exception {
		return letterDAO.selectMainTagDetail(letterVO);
	}	
	
	// 메인태그 등록
	@Override
	public void insertMainTag(LetterVO letterVO) throws Exception {
		letterDAO.insertMainTag(letterVO);
	}
	
	// 메인태그 수정
	@Override
	public void updateMainTag(LetterVO letterVO) throws Exception {
		letterDAO.updateMainTag(letterVO);
	}	
	
	@Override
	public List<LetterVO> selectMainTagWebList(LetterVO letterVO) throws Exception{
		return letterDAO.selectMainTagWebList(letterVO);
	}
	
	@Override
	public LetterVO selectFrsKeyword(LetterVO letterVO) throws Exception {
		return letterDAO.selectFrsKeyword(letterVO);
	}	
}