File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
2024-11-14
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
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]);
}
}
// 문자 우선순위 랜덤 업데이트 All
public void updateLetterPriorityAll() throws Exception{
letterDAO.updateLetterPriorityAll();
}
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);
}
// 베스트태그(메인) 목록 조회
@Override
public List<LetterVO> selectMainMsgTagWebList(LetterVO letterVO) throws Exception{
return letterDAO.selectMainMsgTagWebList(letterVO);
}
@Override
public List<LetterVO> selectBastMsgTagList(LetterVO letterVO) throws Exception {
return letterDAO.selectBastMsgTagList(letterVO);
}
@Override
public LetterVO selectBastMsgTagInfo(LetterVO letterVO) throws Exception {
return letterDAO.selectBastMsgTagInfo(letterVO);
}
@Override
public void insertBastMsgTag(LetterVO letterVO) throws Exception {
letterDAO.insertBastMsgTag(letterVO);
}
@Override
public void updateBastMsgTag(LetterVO letterVO) throws Exception {
letterDAO.updateBastMsgTag(letterVO);
}
@Override
public int updateChkBastMsgTagAfterSortPlus(LetterVO letterVO) throws Exception {
return letterDAO.updateChkBastMsgTagAfterSortPlus(letterVO);
}
@Override
public int updateChkBastMsgTagListSort(LetterVO letterVO) throws Exception {
return letterDAO.updateChkBastMsgTagListSort(letterVO);
}
@Override
public int updateBastMsgTagOrderBySort(LetterVO letterVO) throws Exception {
return letterDAO.updateBastMsgTagOrderBySort(letterVO);
}
@Override
public int updateBastMsgTagNullSort(LetterVO letterVO) throws Exception {
return letterDAO.updateBastMsgTagNullSort(letterVO);
}
}