Code - chominsoo4245/mjon

package itn.let.mjo.msgCustom.web; import java.math.BigDecimal; import java.math.RoundingMode; import java.text.SimpleDateFormat; import java.time.LocalDate; import java.time.format.DateTimeFormatter; import java.time.temporal.ChronoUnit; import java.util.Date; import java.util.List; import java.util.Map; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Controller; import org.springframework.ui.ModelMap; import org.springframework.web.bind.annotation.ModelAttribute; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.multipart.MultipartHttpServletRequest; import org.springframework.web.servlet.ModelAndView; import org.springframework.web.servlet.mvc.support.RedirectAttributes; import com.ibm.icu.text.DecimalFormat; 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.LoginVO; 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.util.DateUtils; import itn.com.utl.fcc.service.EgovStringUtil; import itn.let.lett.service.HashConfVO; import itn.let.lett.service.LetterService; import itn.let.mjo.mjocommon.MjonCommon; import itn.let.mjo.msg.service.MjonMsgVO; import itn.let.mjo.msgCustom.service.MjonMsgCustomService; import itn.let.mjo.msgCustom.service.MjonMsgCustomVO; import itn.let.mjo.msgdata.service.MjonMsgDataService; import itn.let.sym.ccm.cde.service.CateCode; import itn.let.sym.site.service.EgovSiteManagerService; import itn.let.sym.site.service.JoinSettingVO; import itn.let.uss.umt.service.MberManageVO; import itn.let.utl.user.service.MjonNoticeSendUtil; @Controller public class MjonMsgCustomWebController { @Resource(name = "mjonMsgCustomService") private MjonMsgCustomService mjonMsgCustomService; @Resource(name = "MjonMsgDataService") private MjonMsgDataService mjonMsgDataService; @Resource(name = "LetterService") private LetterService letterService; @Resource(name = "EgovCmmUseService") private EgovCmmUseService cmmUseService; @Resource(name = "EgovFileMngUtil") private EgovFileMngUtil fileUtil; @Resource(name = "EgovFileMngService") private EgovFileMngService fileMngService; /** 첨부파일 저장경로 */ @Value("#{globalSettings['Globals.file.saveDir']}") private String fileSaveDir; /** 알림전송 Util */ @Resource(name = "mjonNoticeSendUtil") private MjonNoticeSendUtil mjonNoticeSendUtil; @Resource(name="MjonCommon") private MjonCommon mjonCommon; /** 사이트 설정 */ @Resource(name = "egovSiteManagerService") EgovSiteManagerService egovSiteManagerService; /** 사용자 맞춤제작 화면*/ @RequestMapping(value= {"/web/mjon/custom/selectMsgCustomView.do"}) public String selectMsgCustomView(@ModelAttribute("searchVO") MjonMsgCustomVO mjonMsgCustomVO , HttpServletRequest request , ModelMap model) throws Exception{ String url = request.getHeader("REFERER"); if(url != null) { if(url.contains("web/mjon/msgcampain/selectMsgDataView.do")) { model.addAttribute("msgcampain", request.getParameter("pageType")); } } //로그인 권한정보 불러오기 LoginVO loginVO = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null; // 맞춤문자 설정 mjonMsgCustomVO.setLetterType("C"); String categoryType = "C"; // 문자 카테고리 리스트 불러오기 List<CateCode> cateConfList = letterService.selectCateConfWithList(categoryType); model.addAttribute("cateCodeList", cateConfList); // 문자 해쉬태그 리스트 불러오기 String msgType = "C"; List<HashConfVO> hashTagList = letterService.selectHashTagWithList(msgType); model.addAttribute("hashTagList", hashTagList); model.addAttribute("mjonMsgCustomVO", mjonMsgCustomVO); model.addAttribute("loginVO", loginVO); for(int i=0 ; i < cateConfList.size(); i++) { if("선거".equals(cateConfList.get(i).getCateNm())) { mjonMsgCustomVO.setCategoryCode(cateConfList.get(i).getCateCode()); } } //1.시스템 기본 단가 정보 불러오기 JoinSettingVO sysJoinSetVO = mjonMsgDataService.selectJoinSettingInfo(); String customSamplePrice = "0"; // 문자온 샘플 수정(글자, 색상, 폰트 등) String customEditPrice = "0"; // 이미지 편집(첨부이미지 1장) String customEdit3Price = "0"; // 이미지 편집(첨부이미지 3장이하) String customTextPrice = "0"; // 텍스트 단순수정 DecimalFormat df = new DecimalFormat("###,###"); customSamplePrice = df.format(sysJoinSetVO.getCustomSamplePrice()); customEditPrice = df.format(sysJoinSetVO.getCustomEditPrice()); customEdit3Price = df.format(sysJoinSetVO.getCustomEdit3Price()); customTextPrice = df.format(sysJoinSetVO.getCustomTextPrice()); model.addAttribute("customSamplePrice", customSamplePrice); model.addAttribute("customEditPrice", customEditPrice); model.addAttribute("customEdit3Price", customEdit3Price); model.addAttribute("customTextPrice", customTextPrice); // 내 보관함 - 기본 날짜 검색 셋팅 // 오늘 날짜에서 365일 날짜 가져와서 // 검색날짜에 입력 model.addAttribute("myStartDate", DateUtils.getDateMonthsAgo(12)); model.addAttribute("myEndDate", DateUtils.getCurrentDate()); return "/web/custom/MsgCustomView"; } /** 사용자 맞춤제작 샘플 이미지 리스트*/ @RequestMapping(value= {"/web/mjon/custom/selectMsgCustomSampleListAjax.do"}) public String selectMsgCustomSampleListAjax(@ModelAttribute("searchVO") MjonMsgCustomVO mjonMsgCustomVO , ModelMap model) throws Exception{ //그림 문자 리스트 불러오기 //LetterVO letterVO = new LetterVO(); if(mjonMsgCustomVO.getPageUnit() != 10) { mjonMsgCustomVO.setPageUnit(mjonMsgCustomVO.getPageUnit()); } if ("best".equals(mjonMsgCustomVO.getCategoryCode())) { mjonMsgCustomVO.setBestCategory("Y"); mjonMsgCustomVO.setCategoryCode(""); } /** pageing */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(mjonMsgCustomVO.getPageIndex()); paginationInfo.setRecordCountPerPage(mjonMsgCustomVO.getPageUnit()); paginationInfo.setPageSize(mjonMsgCustomVO.getPageSize()); mjonMsgCustomVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); mjonMsgCustomVO.setLastIndex(paginationInfo.getLastRecordIndex()); mjonMsgCustomVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); // 문자 종류 정보가 없으면 단문문자로 셋팅 mjonMsgCustomVO.setLetterType("C"); // 그림 문자 리스트 List<?> resultCustomList = mjonMsgDataService.selectPhotoLetterList(mjonMsgCustomVO); model.addAttribute("resultCustomList", resultCustomList); paginationInfo.setTotalRecordCount( resultCustomList.size()> 0 ? ((Long)((EgovMap)resultCustomList.get(0)).get("totCnt")).intValue() : 0); model.addAttribute("paginationInfo", paginationInfo); model.addAttribute("mjonMsgCustomVO", mjonMsgCustomVO); return "/web/custom/MsgCustomListAjax"; } /** 사용자 맞춤제작 내보관함 리스트*/ @RequestMapping(value= {"/web/mjon/custom/selectMsgMyCustomListAjax.do"}) public String selectMsgMyCustomListAjax(@ModelAttribute("searchVO") MjonMsgCustomVO mjonMsgCustomVO , RedirectAttributes redirectAttributes , ModelMap model) throws Exception{ LoginVO loginVO = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null; String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId()); if(userId == "") { redirectAttributes.addFlashAttribute("message", "맞춤제작 내보관함 서비스는 로그인 후 이용 가능합니다."); return "redirect:/web/user/login/login.do"; } if(mjonMsgCustomVO.getPageUnit() != 10) { mjonMsgCustomVO.setPageUnit(mjonMsgCustomVO.getPageUnit()); } /** pageing */ PaginationInfo paginationInfo = new PaginationInfo(); paginationInfo.setCurrentPageNo(mjonMsgCustomVO.getPageIndex()); paginationInfo.setRecordCountPerPage(mjonMsgCustomVO.getPageUnit()); paginationInfo.setPageSize(mjonMsgCustomVO.getPageSize()); mjonMsgCustomVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); mjonMsgCustomVO.setLastIndex(paginationInfo.getLastRecordIndex()); mjonMsgCustomVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); // 문자 종류 정보가 없으면 단문문자로 셋팅 mjonMsgCustomVO.setLetterType("C"); // 검색 데이터가 없거나 // 시작일자가 종료일자보다 이후이거나 // 총 기간이 365일이 넘으면 현재일부터 365일 전 날짜를 넣어서 검색 if(!DateUtils.dateChkAndValueChk(mjonMsgCustomVO.getSearchStartDate(),mjonMsgCustomVO.getSearchEndDate(), 12 )) { mjonMsgCustomVO.setSearchStartDate(DateUtils.getDateMonthsAgo(12)); mjonMsgCustomVO.setSearchEndDate(DateUtils.getCurrentDate()); }; // 내 보관함 이미지 목록 조회 mjonMsgCustomVO.setUserId(userId); List<MjonMsgCustomVO> resultCustomImgList = mjonMsgCustomService.selectMjonMsgMyCustomImgList(mjonMsgCustomVO); model.addAttribute("resultCustomList", resultCustomImgList); paginationInfo.setTotalRecordCount( resultCustomImgList.size()> 0 ? resultCustomImgList.get(0).getTotCnt() : 0); model.addAttribute("paginationInfo", paginationInfo); model.addAttribute("mjonMsgCustomVO", mjonMsgCustomVO); return "/web/custom/MsgMyCustomListAjax"; } /** 사용자 맞춤제작 내보관함 삭제 - LETTNFILEDETAIL 테이블 FILE_DELETE_YN 컬럼 업데이트*/ @RequestMapping(value= {"/web/mjon/custom/deleteMsgMyCustomAjax.do"}) public ModelAndView deleteMsgMyCustomAjax(@RequestParam("chk") String[] chk, @ModelAttribute("searchVO") MjonMsgCustomVO mjonMsgCustomVO , ModelMap model) throws Exception{ ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); //최종수정 ID - 로그인 ID LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser(); mjonMsgCustomVO.setLastUpdusrId(user.getId()); try { for(String target : chk) { mjonMsgCustomVO.setAttachFileId(target.split("\\|")[0]); mjonMsgCustomVO.setFileSn(target.split("\\|")[1]); mjonMsgCustomService.deleteMsgMyCustomAjax(mjonMsgCustomVO); } modelAndView.addObject("result", "success"); }catch (Exception e) { modelAndView.addObject("message", "다시 시도 부탁드립니다."); modelAndView.addObject("result", "fail"); } return modelAndView; } /** 사용자 맞춤제작 팝업*/ @RequestMapping(value= {"/web/mjon/custom/selectMsgCustomPopupAjax.do"}) public String selectMsgCustomPopupAjax(@ModelAttribute("searchVO") MjonMsgCustomVO mjonMsgCustomVO , ModelMap model) throws Exception{ //로그인 권한정보 불러오기 LoginVO loginVO = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null; String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId()); String author = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getAuthority()); if(!userId.equals("") && !author.equals("ROLE_ADMIN")) { //2.사용자 개인 단가 정보 불러오기 MberManageVO mberManageVO = new MberManageVO(); mberManageVO = mjonMsgDataService.selectMberManageInfo(userId); double money = mberManageVO.getUserMoney(); BigDecimal userMoney = new BigDecimal(money).setScale(0, RoundingMode.HALF_DOWN); model.addAttribute("userMoney", userMoney); } String categoryType = "C"; // 문자 카테고리 리스트 불러오기 List<CateCode> cateConfList = letterService.selectCateConfWithList(categoryType); model.addAttribute("cateConfList", cateConfList); ComDefaultCodeVO comDefaultCodeVO = new ComDefaultCodeVO(); //제작형태 코드 조회 comDefaultCodeVO.setCodeId("ITN030"); List<?> codeResult = cmmUseService.selectCmmCodeDetail(comDefaultCodeVO); model.addAttribute("codeResult", codeResult); return "/web/custom/MsgCustomPopupAjax"; } /** 사용자 맞춤제작 팝업 이미지 리스트*/ @RequestMapping(value= {"/web/mjon/custom/selectCustomPopupImgListAjax.do"}) public ModelAndView selectgCustomPopupImgListAjax(@ModelAttribute("searchVO") MjonMsgCustomVO mjonMsgCustomVO , ModelMap model) throws Exception{ ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); if ("best".equals(mjonMsgCustomVO.getCategoryCode())) { mjonMsgCustomVO.setBestCategory("Y"); mjonMsgCustomVO.setCategoryCode(""); } // 샘플그림 리스트 조회 List<?> resultCustomList = mjonMsgDataService.selectCustomPopupImgList(mjonMsgCustomVO); model.addAttribute("resultCustomList", resultCustomList); modelAndView.addObject("status", "success"); return modelAndView; } /** 첨부파일 포함하여 맞춤제작요청 등록*/ @RequestMapping(value = {"/web/mjon/custom/insertCustomImgInfoAjax.do"}) public ModelAndView insertCustomImgInfoAjax(final MultipartHttpServletRequest multiRequest , MjonMsgCustomVO mjonMsgCustomVO , HttpServletRequest request) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); LoginVO loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser(); String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId()); MjonMsgVO mjonMsgVO = new MjonMsgVO(); mjonMsgVO.setUserId(userId); // 조회 아이디 등록 String userMoney = mjonMsgDataService.selectBeforeCashData(mjonMsgVO); // 현재 보유금액 조회 BigDecimal befCash = new BigDecimal(userMoney).setScale(0, RoundingMode.HALF_EVEN); // 현재 보유금액 변환 BigDecimal totMsgPrice = new BigDecimal(mjonMsgCustomVO.getCustomAmount()).setScale(0, RoundingMode.HALF_EVEN); // 맞춤문자 결제 예상 금액 // befCash(현재 보유금액) 값이 totMsgPrice(맞춤문자전송 금액) 보다 많으면 문자 전송 //if(befCash.compareTo(totMsgPrice) < 0 || befCash.compareTo(totMsgPrice) == 0) { if(befCash.compareTo(totMsgPrice) < 0) { modelAndView.addObject("result", "notMoney"); return modelAndView; } // 맞춤문자 첨부 이미지 업로드 String customSampleImg = ""; String customSampleImgFileSn = ""; /*if(!mjonMsgCustomVO.getTempImg1().equals("")) { customSampleImg = mjonMsgCustomVO.getTempImg1(); customSampleImgFileSn= mjonMsgCustomVO.getTempImg1FileSn(); } if(!mjonMsgCustomVO.getTempImg2().equals("")) { if(customSampleImg != "" ) { customSampleImg += "/"+mjonMsgCustomVO.getTempImg2(); customSampleImgFileSn += "/"+mjonMsgCustomVO.getTempImg2FileSn(); }else { customSampleImg += mjonMsgCustomVO.getTempImg2(); customSampleImgFileSn += "/"+mjonMsgCustomVO.getTempImg2FileSn(); } } if(!mjonMsgCustomVO.getTempImg3().equals("")) { if(customSampleImg != "" ) { customSampleImg += "/"+mjonMsgCustomVO.getTempImg3(); customSampleImgFileSn += "/"+mjonMsgCustomVO.getTempImg3FileSn(); }else { customSampleImg += mjonMsgCustomVO.getTempImg3(); customSampleImgFileSn += "/"+mjonMsgCustomVO.getTempImg3FileSn(); } }*/ // 첨부파일 ID 생성 및 구분자 등록 String atchFileId = ""; final Map<String, MultipartFile> files = multiRequest.getFileMap(); if (!files.isEmpty()) { String imagePath = ""; Date now = new Date(); SimpleDateFormat formatDate = new SimpleDateFormat("yyyyMMdd"); String fdlDate = formatDate.format(now); //로컬 과 개발서버의 이미지 저장 경로 분기처리 if(request.getServerName().equals("localhost")) { imagePath = fileSaveDir+"src/main/webapp/MMS/" + fdlDate; }else{ /*imagePath = "/usr/local/tomcat_mjon/webapps/mjon/MMS/" + fdlDate;*/ imagePath = fileSaveDir+"/file/MMS/" + fdlDate; } List<FileVO> result = fileUtil.parseImageFileInf(files, "CUSTOM_", 0, "", imagePath, ""); atchFileId = fileMngService.insertFileInfs(result); for(int i=0; i < result.size(); i++) { if(customSampleImgFileSn != "" ) { // customSampleImg += "/"+atchFileId; customSampleImgFileSn += "/"+i; }else { // customSampleImg += atchFileId; customSampleImgFileSn += i; } } } mjonMsgCustomVO.setCustomUploadImg(atchFileId); mjonMsgCustomVO.setCustomUploadImgFileSn(customSampleImgFileSn); mjonMsgCustomVO.setUserId(userId); mjonMsgCustomVO.setFrstRegisterId(userId); mjonMsgCustomVO.setLastUpdusrId(userId); mjonMsgCustomService.insertMjonMsgCustomInfo(mjonMsgCustomVO); // 법인폰 알람여부 체크 JoinSettingVO joinSettingVO = new JoinSettingVO(); joinSettingVO = egovSiteManagerService.selectAdminNotiDetail(); // 이메일 체크 if (joinSettingVO != null && joinSettingVO.getEmailNoti().equals("Y")) { String emailTitle = "문자관리 > 문자맞춤제작 요청"; // CS관리자 이메일 알림전송 mjonNoticeSendUtil.csAdminEmailNoticeSend(loginVO.getName(), loginVO.getId(), emailTitle); } // SLACK 체크 if (joinSettingVO != null && joinSettingVO.getSlackNoti().equals("Y")) { // Slack 메시지 발송(단순본문) String msg = "[문자온] 문자맞춤제작 요청 - " + loginVO.getName() +"("+ loginVO.getId() + ")"; mjonCommon.sendSimpleSlackMsg(msg); } modelAndView.addObject("result", "success"); return modelAndView; } /** 첨부파일 없이 맞춤제작요청 등록*/ @RequestMapping(value = {"/web/mjon/custom/insertCustomImgInfoNoFileAjax.do"}) public ModelAndView insertCustomImgInfoNoFileAjax( MjonMsgCustomVO mjonMsgCustomVO , HttpServletRequest request) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); LoginVO loginVO = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser(); String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId()); MjonMsgVO mjonMsgVO = new MjonMsgVO(); mjonMsgVO.setUserId(userId); // 조회 아이디 등록 String userMoney = mjonMsgDataService.selectBeforeCashData(mjonMsgVO); // 현재 보유금액 조회 BigDecimal befCash = new BigDecimal(userMoney).setScale(0, RoundingMode.HALF_EVEN); // 현재 보유금액 변환 BigDecimal totMsgPrice = new BigDecimal(mjonMsgCustomVO.getCustomAmount()).setScale(0, RoundingMode.HALF_EVEN); // 맞춤문자 결제 예상 금액 // befCash(현재 보유금액) 값이 totMsgPrice(맞춤문자전송 금액) 보다 많으면 문자 전송 //if(befCash.compareTo(totMsgPrice) < 0 || befCash.compareTo(totMsgPrice) == 0) { if(befCash.compareTo(totMsgPrice) < 0) { modelAndView.addObject("result", "notMoney"); return modelAndView; } mjonMsgCustomVO.setUserId(userId); mjonMsgCustomVO.setFrstRegisterId(userId); mjonMsgCustomVO.setLastUpdusrId(userId); mjonMsgCustomService.insertMjonMsgCustomInfo(mjonMsgCustomVO); // 법인폰 알람여부 체크 JoinSettingVO joinSettingVO = new JoinSettingVO(); joinSettingVO = egovSiteManagerService.selectAdminNotiDetail(); // 이메일 체크 if (joinSettingVO != null && joinSettingVO.getEmailNoti().equals("Y")) { String emailTitle = "문자관리 > 문자맞춤제작 요청"; // CS관리자 이메일 알림전송 mjonNoticeSendUtil.csAdminEmailNoticeSend(loginVO.getName(), loginVO.getId(), emailTitle); } // SLACK 체크 if (joinSettingVO != null && joinSettingVO.getSlackNoti().equals("Y")) { // Slack 메시지 발송(단순본문) String msg = "[문자온] 문자맞춤제작 요청 - " + loginVO.getName() +"("+ loginVO.getId() + ")"; mjonCommon.sendSimpleSlackMsg(msg); } modelAndView.addObject("result", "success"); return modelAndView; } /** 사용자 맞춤제작 팝업*/ @RequestMapping(value= {"/web/mjon/custom/MsgCustomVeiwPopupAjax.do"}) public String selectMsgCustomPopupDetailAjax(@ModelAttribute("searchVO") MjonMsgCustomVO mjonMsgCustomVO , ModelMap model) throws Exception{ //로그인 권한정보 불러오기 LoginVO loginVO = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null; String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId()); String author = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getAuthority()); return "/web/custom/MsgCustomVeiwPopupAjax"; } /** 맞춤제작 상세보기 팝업 리스트 조회*/ @RequestMapping(value= {"/web/mjon/custom/selectMyCustomImgRequestListAjax.do"}) public ModelAndView selectMyCustomImgRequestListAjax(@ModelAttribute("searchVO") MjonMsgCustomVO mjonMsgCustomVO , ModelMap model) throws Exception{ ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); try { List<MjonMsgCustomVO> customList = mjonMsgCustomService.selectMyCustomImgRequestList(mjonMsgCustomVO); for(int i=0; i < customList.size(); i++) { if("Y".equals(customList.get(i).getCustomUploadYn())) { String sampleFileSn[] = customList.get(i).getCustomUploadImgFileSn().split("/"); FileVO fileVO = new FileVO(); String fileName = ""; for(int j=0; j< sampleFileSn.length; j++) { fileVO.setAtchFileId(customList.get(i).getCustomUploadImg()); fileVO.setFileSn(sampleFileSn[j]); FileVO result = fileMngService.selectFileInf(fileVO); // JSPark 2023.03.07 => 널 체크 추가 if (result != null) { if(j != 0 ) { fileName = fileName +", "; } fileName = fileName + result.getOrignlFileNm(); } } customList.get(i).setTempImg1(fileName); } } modelAndView.addObject("customList", customList); modelAndView.addObject("result", "success"); }catch (Exception e) { modelAndView.addObject("message", "다시 시도 부탁드립니다."); modelAndView.addObject("result", "fail"); } return modelAndView; } }