File name
Commit message
Commit date
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-01-03
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);
}
}