Code - rosewiper/itsm

package egovframework.com.cmm.web; import java.io.BufferedInputStream; import java.io.BufferedOutputStream; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.PrintWriter; import java.net.URLEncoder; import java.util.ArrayList; import java.util.Collections; import java.util.List; import java.util.Map; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.apache.commons.compress.archivers.zip.ZipArchiveEntry; import org.apache.commons.compress.archivers.zip.ZipArchiveOutputStream; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.stereotype.Controller; import org.springframework.util.FileCopyUtils; 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.servlet.ModelAndView; import egovframework.com.cmm.service.EgovFileMngService; import egovframework.com.cmm.service.FileVO; import egovframework.let.itsm.asset.service.AssetVO; import egovframework.let.itsm.audit.service.AuditItemVO; import egovframework.let.itsm.audit.service.AuditManageService; import egovframework.let.itsm.audit.service.AuditVO; import egovframework.let.itsm.bizCntrt.service.BizCntrtVO; import egovframework.let.itsm.bizCntrt.service.BizItemVO; import egovframework.let.itsm.edu.service.EduVO; import egovframework.let.itsm.ip.service.IpVO; import egovframework.let.itsm.per.service.PeriFile; import egovframework.let.itsm.per.service.PerispVO; import egovframework.let.itsm.per.service.PeritemVO; import egovframework.let.itsm.security.service.SecVO; import egovframework.let.itsm.sla.service.SlaAutItemVO; import egovframework.let.itsm.sla.service.SlaAutscitecVO; /** * 파일 다운로드를 위한 컨트롤러 클래스 * @author 공통서비스개발팀 이삼섭 * @since 2009.06.01 * @version 1.0 * @see * * <pre> * << 개정이력(Modification Information) >> * * 수정일 수정자 수정내용 * ------- -------- --------------------------- * 2009.3.25 이삼섭 최초 생성 * * Copyright (C) 2009 by MOPAS All right reserved. * </pre> */ @Controller public class EgovFileDownloadController { @Resource(name = "EgovFileMngService") private EgovFileMngService fileService; @Resource(name = "auditManageService") private AuditManageService auditManageService; private static final Logger LOGGER = LoggerFactory.getLogger(EgovFileDownloadController.class); /** * 브라우저 구분 얻기. * * @param request * @return */ private String getBrowser(HttpServletRequest request) { String header = request.getHeader("User-Agent"); if (header.indexOf("MSIE") > -1) { return "MSIE"; } else if (header.indexOf("Trident") > -1) { // IE11 문자열 깨짐 방지 return "Trident"; } else if (header.indexOf("Chrome") > -1) { return "Chrome"; } else if (header.indexOf("Opera") > -1) { return "Opera"; } return "Firefox"; } /** * Disposition 지정하기. * * @param filename * @param request * @param response * @throws Exception */ private void setDisposition(String filename, HttpServletRequest request, HttpServletResponse response) throws Exception { String browser = getBrowser(request); String dispositionPrefix = "attachment; filename="; String encodedFilename = URLEncoder.encode(filename, "UTF-8").replaceAll("\\+", "%20"); if (browser.equals("MSIE")) { encodedFilename = URLEncoder.encode(filename, "UTF-8").replaceAll("\\+", "%20"); } else if (browser.equals("Trident")) { // IE11 문자열 깨짐 방지 encodedFilename = URLEncoder.encode(filename, "UTF-8").replaceAll("\\+", "%20"); } else if (browser.equals("Firefox")) { encodedFilename = "\"" + new String(filename.getBytes("UTF-8"), "8859_1") + "\""; } else if (browser.equals("Opera")) { encodedFilename = "\"" + new String(filename.getBytes("UTF-8"), "8859_1") + "\""; } else if (browser.equals("Chrome")) { StringBuffer sb = new StringBuffer(); for (int i = 0; i < filename.length(); i++) { char c = filename.charAt(i); if (c > '~') { sb.append(URLEncoder.encode("" + c, "UTF-8")); } else { sb.append(c); } } encodedFilename = sb.toString(); } else { //throw new RuntimeException("Not supported browser"); throw new IOException("Not supported browser"); } response.setHeader("Content-Disposition", "attachment; filename=\"" + encodedFilename + "\"; filename*=UTF-8''" + encodedFilename); if ("Opera".equals(browser)) { response.setContentType("application/octet-stream;charset=UTF-8"); } } /** * 첨부파일로 등록된 파일에 대하여 다운로드를 제공한다. * * @param commandMap * @param response * @throws Exception */ @RequestMapping(value = "/cmm/fms/FileDown.do") public void cvplFileDownload(@RequestParam Map<String, Object> commandMap , HttpServletRequest request , HttpServletResponse response , HttpSession session ) throws Exception { String atchFileId = (String) commandMap.get("atchFileId"); String fileSn = (String) commandMap.get("fileSn"); String sessionFileId = (String)session.getAttribute("atchFileId"); if(sessionFileId != null) { if(!sessionFileId.equals(atchFileId)) { response.setCharacterEncoding("utf-8"); response.setContentType("text/html; charset=utf-8"); PrintWriter printwriter = response.getWriter(); printwriter.println("<script>"); printwriter.println("alert('허가되지 않은 서비스 입니다.')"); printwriter.println("self.close();"); printwriter.println("</script>"); printwriter.flush(); printwriter.close(); return ; } } /*Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();*/ /*if (isAuthenticated) {*/ FileVO fileVO = new FileVO(); fileVO.setAtchFileId(atchFileId); fileVO.setFileSn(fileSn); FileVO fvo = fileService.selectFileInf(fileVO); if(fvo == null){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } File uFile = new File(fvo.getFileStreCours(), fvo.getStreFileNm()); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(fvo.getOrignlFileNm(), request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + fvo.getOrignlFileNm() + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } /*}*/ } /** * 첨부파일로 등록된 PDF파일을 미리보기 한다. * * @param commandMap * @param response * @throws Exception */ @RequestMapping(value = "/cmm/fms/pdfView.do") public void pdfView(@RequestParam Map<String, Object> commandMap, HttpServletRequest request, HttpServletResponse response) throws Exception { String atchFileId = (String) commandMap.get("atchFileId"); String fileSn = (String) commandMap.get("fileSn"); FileVO fileVO = new FileVO(); fileVO.setAtchFileId(atchFileId); fileVO.setFileSn(fileSn); FileVO fvo = fileService.selectFileInf(fileVO); if(fvo == null){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } FileInputStream fis = null; BufferedOutputStream bos = null; try{ /* String pdfFileName = "C:/upload/TEST.pdf"; File pdfFile = new File(pdfFileName);*/ File pdfFile = new File(fvo.getFileStreCours(), fvo.getStreFileNm()); //클라이언트 브라우져에서 바로 보는 방법(헤더 변경) response.setContentType("application/pdf"); //★ 이 구문이 있으면 [다운로드], 이 구문이 없다면 바로 target 지정된 곳에 view 해줍니다. //response.addHeader("Content-Disposition", "attachment; filename="+pdfFile.getName()+".pdf"); //파일 읽고 쓰는 건 일반적인 Write방식이랑 동일합니다. 다만 reponse 출력 스트림 객체에 write. fis = new FileInputStream(pdfFile); int size = fis.available(); //지정 파일에서 읽을 수 있는 바이트 수를 반환 byte[] buf = new byte[size]; //버퍼설정 int readCount = fis.read(buf); response.flushBuffer(); bos = new BufferedOutputStream(response.getOutputStream()); bos.write(buf, 0, readCount); bos.flush(); } catch(Exception e) { e.printStackTrace(); } finally { try{ if (fis != null) fis.close(); //close는 꼭! 반드시! if (bos != null) bos.close(); } catch (IOException e) { e.printStackTrace(); } } } /*감사/담당자 명함 다운로드*/ @RequestMapping(value = "/cmm/fms/ItsmFileDown.do") public void itsmFileDown(@RequestParam Map<String, Object> commandMap, HttpServletRequest request, HttpServletResponse response) throws Exception { String atchFileId = (String) commandMap.get("atchFileId"); String fileSn = (String) commandMap.get("fileSn"); FileVO fileVO = new FileVO(); fileVO.setAtchFileId(atchFileId); fileVO.setFileSn(fileSn); FileVO fvo = fileService.selectItsmFileInf(fileVO); if(fvo == null){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } File uFile = new File(fvo.getFileStreCours(), fvo.getStreFileNm()); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(fvo.getOrignlFileNm(), request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + fvo.getOrignlFileNm() + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } /*정기점검 첨부파일 다운로드*/ @RequestMapping(value = "/cmm/fms/perFileDown.do") public void perFileDown(@RequestParam Map<String, Object> commandMap, HttpServletRequest request, HttpServletResponse response) throws Exception { String atchFileId = (String) commandMap.get("atchFileId"); String fileSn = (String) commandMap.get("fileSn"); FileVO fileVO = new FileVO(); fileVO.setAtchFileId(atchFileId); fileVO.setFileSn(fileSn); FileVO fvo = new FileVO(); if(null != commandMap.get("dbType")){ if("ipFile".equals((String) commandMap.get("dbType"))) { fvo = fileService.selectItsmIpFileInf(fileVO); } }else { fvo = fileService.selectItsmperFileInf(fileVO); } if(fvo == null){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } File uFile = new File(fvo.getFileStreCours(), fvo.getStreFileNm()); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(fvo.getOrignlFileNm(), request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + fvo.getOrignlFileNm() + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } /* 파일 다운로드 - 일괄 zip 압축(기본)*/ @RequestMapping(value = "/cmm/fms/fileDownZipTest.do") public void fileDownZipTest(@RequestParam Map<String, Object> commandMap, HttpServletRequest request, HttpServletResponse response) throws Exception { // String atchFileId = (String) commandMap.get("atchFileId"); String orgnZipNm = "test.zip"; // 압축 파일명 필요.. String atchFileId = "FILE_000000000015459"; FileVO fileVO = new FileVO(); fileVO.setAtchFileId(atchFileId); List<FileVO> fvoList = fileService.selectFileInfs(fileVO); // 해당 기능에 맞게 파일 조회 if(fvoList.size() == 0){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } // buffer size int size = 1024; byte[] buf = new byte[size]; String outZipNm = fvoList.get(0).getFileStreCours()+File.separator + orgnZipNm; FileInputStream fis = null; ZipArchiveOutputStream zos = null; BufferedInputStream bis = null; try { // Zip 파일생성 zos = new ZipArchiveOutputStream(new BufferedOutputStream(new FileOutputStream(outZipNm))); for ( FileVO vo : fvoList ){ zos.setEncoding("UTF-8"); //buffer에 해당파일의 stream을 입력한다. fis = new FileInputStream(vo.getFileStreCours() + "/" + vo.getStreFileNm()); bis = new BufferedInputStream(fis,size); //zip에 넣을 다음 entry 를 가져온다. zos.putArchiveEntry(new ZipArchiveEntry(vo.getOrignlFileNm())); //준비된 버퍼에서 집출력스트림으로 write 한다. int len; while((len = bis.read(buf,0,size)) != -1) zos.write(buf,0,len); bis.close(); fis.close(); zos.closeArchiveEntry(); } zos.close(); } catch (FileNotFoundException e) { e.printStackTrace(); }finally{ if( zos != null ) zos.close(); if( fis != null ) fis.close(); if( bis != null ) bis.close(); } File uFile = new File(fvoList.get(0).getFileStreCours(), orgnZipNm); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(orgnZipNm, request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } //파일 다운로드 후 파일 삭제 File delFile = new File(outZipNm); delFile.delete(); } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + orgnZipNm + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } /* 파일 다운로드 - 일괄 zip 압축(보안관리)*/ @RequestMapping(value = "/cmm/fms/secFileDownZip.do") public void secFileDownZip(@RequestParam Map<String, Object> commandMap, @ModelAttribute("sec") SecVO secVO, HttpServletRequest request, HttpServletResponse response) throws Exception { //파일ID를 리스트에 담기 List<String> atchFileIdList = new ArrayList<String>(); //split을 이용해 아이디를 각자 배열에 담기 String[] splitStr =((String) commandMap.get("atchFileId")).split(","); //리스트에 아이디 담기 for(int i=0; i<splitStr.length; i++) { atchFileIdList.add(splitStr[i]); } //zip파일 이름 (메뉴명+글 제목명 +날짜) String menuNm = ""; if(secVO.getSecCd().equals("02")) { menuNm = "보안정책"; }else if(secVO.getSecCd().equals("03")) { menuNm = "보안서약서"; }else if(secVO.getSecCd().equals("04")){ menuNm = "모의훈련"; } String orgnZipNm = menuNm+"_"+secVO.getSecSj()+"_"+secVO.getFrstRegistPnttm().substring(0,10)+".zip"; // 압축 파일명 필요.. FileVO fileVO = new FileVO(); fileVO.setAtchFileIdList(atchFileIdList); List<FileVO> fvoList = fileService.selectSecFileInfs(fileVO); // 해당 기능에 맞게 파일 조회 if(fvoList.size() == 0){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } // buffer size int size = 1024; byte[] buf = new byte[size]; String outZipNm = fvoList.get(0).getFileStreCours()+File.separator + orgnZipNm; FileInputStream fis = null; ZipArchiveOutputStream zos = null; BufferedInputStream bis = null; try { // Zip 파일생성 zos = new ZipArchiveOutputStream(new BufferedOutputStream(new FileOutputStream(outZipNm))); for ( FileVO vo : fvoList ){ zos.setEncoding("UTF-8"); //buffer에 해당파일의 stream을 입력한다. fis = new FileInputStream(vo.getFileStreCours() + "/" + vo.getStreFileNm()); bis = new BufferedInputStream(fis,size); //zip에 넣을 다음 entry 를 가져온다. zos.putArchiveEntry(new ZipArchiveEntry(vo.getOrignlFileNm())); //준비된 버퍼에서 집출력스트림으로 write 한다. int len; while((len = bis.read(buf,0,size)) != -1) zos.write(buf,0,len); bis.close(); fis.close(); zos.closeArchiveEntry(); } zos.close(); } catch (FileNotFoundException e) { e.printStackTrace(); }finally{ if( zos != null ) zos.close(); if( fis != null ) fis.close(); if( bis != null ) bis.close(); } File uFile = new File(fvoList.get(0).getFileStreCours(), orgnZipNm); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(orgnZipNm, request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } //파일 다운로드 후 파일 삭제 File delFile = new File(outZipNm); delFile.delete(); } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + orgnZipNm + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } /* 파일 다운로드 - 일괄 zip 압축(사업관리)*/ @RequestMapping(value = "/cmm/fms/bizFileDownZip.do") public void bizFileDownZip(@RequestParam Map<String, Object> commandMap, @ModelAttribute("bizCntrtVO") BizCntrtVO bizCntrtVO, BizItemVO bizItemVO, HttpServletRequest request, HttpServletResponse response) throws Exception { List<String> atchFileIdList = new ArrayList<>(); if (bizItemVO.getAtchFileId() != null && !bizItemVO.getAtchFileId().trim().isEmpty()) { String[] splitStr = bizItemVO.getAtchFileId().split(","); for (String id : splitStr) { if (id != null && !id.trim().isEmpty()) { atchFileIdList.add(id.trim()); } } } FileVO fileVO = new FileVO(); fileVO.setAtchFileIdList(!atchFileIdList.isEmpty() ? atchFileIdList : null); List<FileVO> fvoList = fileService.selectBizFileInfs(fileVO); if (fvoList == null || fvoList.isEmpty()) { response.sendError(HttpServletResponse.SC_NOT_FOUND, "파일이 존재하지 않습니다."); return; } String menuNm = "사업관리"; String orgnZipNm = menuNm + "_" + bizCntrtVO.getBizNm() + "_" + bizCntrtVO.getFrstRegistPnttm() + ".zip"; response.reset(); response.setContentType("application/zip"); String encodedFileName = URLEncoder.encode(orgnZipNm, "UTF-8").replaceAll("\\+", "%20"); response.setHeader("Content-Disposition", "attachment; filename=\"" + encodedFileName + "\"; filename*=UTF-8''" + encodedFileName); byte[] buffer = new byte[1024]; try (ZipArchiveOutputStream zos = new ZipArchiveOutputStream(response.getOutputStream())) { zos.setEncoding("UTF-8"); for (FileVO vo : fvoList) { File file = new File(vo.getFileStreCours(), vo.getStreFileNm()); if (!file.exists()) continue; try (BufferedInputStream bis = new BufferedInputStream(new FileInputStream(file))) { zos.putArchiveEntry(new ZipArchiveEntry(vo.getOrignlFileNm())); int len; while ((len = bis.read(buffer)) != -1) { zos.write(buffer, 0, len); } zos.closeArchiveEntry(); } } zos.finish(); } } /* 파일 다운로드 - 일괄 zip 압축(개인정보실태평가,국정원실태평가,외부감사)*/ @RequestMapping(value = "/cmm/fms/evalFileDownZip.do") public void evalFileDownZip(@RequestParam Map<String, Object> commandMap , @ModelAttribute("auditVO") AuditVO auditVO, @ModelAttribute("auditItemVO") AuditItemVO auditItemVO , EduVO eduVO, HttpServletRequest request, HttpServletResponse response) throws Exception { //파일ID를 리스트에 담기 List<String> atchFileIdList = new ArrayList<String>(); //split을 이용해 아이디를 각자 배열에 담기 String[] splitStr =auditItemVO.getAtchFileIdDown().split(","); //리스트에 아이디 담기 for(int i=0; i<splitStr.length; i++) { atchFileIdList.add(splitStr[i]); } //zip파일 이름 (메뉴명+글 제목명 +날짜) String menuNm = ""; if(auditVO.getAutCd().equals("21 ")) { menuNm = "개인정보실태평가"; }else if(auditVO.getAutCd().equals("03")) { menuNm = "국정원실태평가"; }else if(auditVO.getAutCd().equals("01")) { menuNm = "외부감사"; }else if(eduVO.getAutCd().equals("02")) { if(eduVO.getAutConFlag().equals("01")) { menuNm = "교육계획"; }else if(eduVO.getAutConFlag().equals("02")) { menuNm = "회의계획"; }else if(eduVO.getAutConFlag().equals("03")) { menuNm = "연간교육계획"; } } String orgnZipNm = menuNm+"_"+auditVO.getAutSj()+"_"+auditVO.getFrstRegistPnttm().substring(0,10)+".zip"; // 압축 파일명 필요.. FileVO fileVO = new FileVO(); fileVO.setAtchFileIdList(atchFileIdList); List<FileVO> fvoList = fileService.selectEvalFileInfs(fileVO); // 해당 기능에 맞게 파일 조회 if(fvoList.size() == 0){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } // buffer size int size = 1024; byte[] buf = new byte[size]; String outZipNm = fvoList.get(0).getFileStreCours()+File.separator + orgnZipNm; FileInputStream fis = null; ZipArchiveOutputStream zos = null; BufferedInputStream bis = null; try { // Zip 파일생성 zos = new ZipArchiveOutputStream(new BufferedOutputStream(new FileOutputStream(outZipNm))); for ( FileVO vo : fvoList ){ zos.setEncoding("UTF-8"); //buffer에 해당파일의 stream을 입력한다. fis = new FileInputStream(vo.getFileStreCours() + "/" + vo.getStreFileNm()); bis = new BufferedInputStream(fis,size); //zip에 넣을 다음 entry 를 가져온다. zos.putArchiveEntry(new ZipArchiveEntry(vo.getOrignlFileNm())); //준비된 버퍼에서 집출력스트림으로 write 한다. int len; while((len = bis.read(buf,0,size)) != -1) zos.write(buf,0,len); bis.close(); fis.close(); zos.closeArchiveEntry(); } zos.close(); } catch (FileNotFoundException e) { e.printStackTrace(); }finally{ if( zos != null ) zos.close(); if( fis != null ) fis.close(); if( bis != null ) bis.close(); } File uFile = new File(fvoList.get(0).getFileStreCours(), orgnZipNm); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(orgnZipNm, request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } //파일 다운로드 후 파일 삭제 File delFile = new File(outZipNm); delFile.delete(); } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + orgnZipNm + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } /* 파일 다운로드 - 일괄 zip 압축(교육회의관리)*/ @RequestMapping(value = "/cmm/fms/eduFileDownZip.do") public void eduFileDownZip(@RequestParam Map<String, Object> commandMap , @ModelAttribute("auditVO") AuditVO auditVO, @ModelAttribute("auditItemVO") AuditItemVO auditItemVO , EduVO eduVO, HttpServletRequest request, HttpServletResponse response) throws Exception { //파일ID를 리스트에 담기 List<String> atchFileIdList = new ArrayList<String>(); //split을 이용해 아이디를 각자 배열에 담기 String[] splitStr =auditItemVO.getAtchFileId().split(","); //리스트에 아이디 담기 for(int i=0; i<splitStr.length; i++) { atchFileIdList.add(splitStr[i]); } //zip파일 이름 (메뉴명+글 제목명 +날짜) String menuNm = ""; if(auditVO.getAutCd().equals("21 ")) { menuNm = "개인정보실태평가"; }else if(auditVO.getAutCd().equals("03")) { menuNm = "국정원실태평가"; }else if(auditVO.getAutCd().equals("01")) { menuNm = "외부감사"; }else if(eduVO.getAutCd().equals("02")) { if(eduVO.getAutConFlag().equals("01")) { menuNm = "교육계획"; }else if(eduVO.getAutConFlag().equals("02")) { menuNm = "회의계획"; }else if(eduVO.getAutConFlag().equals("03")) { menuNm = "연간교육계획"; } } String orgnZipNm = menuNm+"_"+auditVO.getAutSj()+"_"+auditVO.getFrstRegistPnttm().substring(0,10)+".zip"; // 압축 파일명 필요.. FileVO fileVO = new FileVO(); fileVO.setAtchFileIdList(atchFileIdList); List<FileVO> fvoList = fileService.selectEvalFileInfs(fileVO); // 해당 기능에 맞게 파일 조회 if(fvoList.size() == 0){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } // buffer size int size = 1024; byte[] buf = new byte[size]; String outZipNm = fvoList.get(0).getFileStreCours()+File.separator + orgnZipNm; FileInputStream fis = null; ZipArchiveOutputStream zos = null; BufferedInputStream bis = null; try { // Zip 파일생성 zos = new ZipArchiveOutputStream(new BufferedOutputStream(new FileOutputStream(outZipNm))); for ( FileVO vo : fvoList ){ zos.setEncoding("UTF-8"); //buffer에 해당파일의 stream을 입력한다. fis = new FileInputStream(vo.getFileStreCours() + "/" + vo.getStreFileNm()); bis = new BufferedInputStream(fis,size); //zip에 넣을 다음 entry 를 가져온다. zos.putArchiveEntry(new ZipArchiveEntry(vo.getOrignlFileNm())); //준비된 버퍼에서 집출력스트림으로 write 한다. int len; while((len = bis.read(buf,0,size)) != -1) zos.write(buf,0,len); bis.close(); fis.close(); zos.closeArchiveEntry(); } zos.close(); } catch (FileNotFoundException e) { e.printStackTrace(); }finally{ if( zos != null ) zos.close(); if( fis != null ) fis.close(); if( bis != null ) bis.close(); } File uFile = new File(fvoList.get(0).getFileStreCours(), orgnZipNm); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(orgnZipNm, request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } //파일 다운로드 후 파일 삭제 File delFile = new File(outZipNm); delFile.delete(); } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + orgnZipNm + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } /* 파일 다운로드 - 일괄 zip 압축(국정원실태평가 - 세부 평가지표 및 결과[파일디테일이 없어서 따로 만듬])*/ @RequestMapping(value = "/cmm/fms/evalFileDownZip2.do") public void evalFileDownZip2(@RequestParam Map<String, Object> commandMap , @ModelAttribute("auditVO") AuditVO auditVO, @ModelAttribute("auditItemVO") AuditItemVO auditItemVO , EduVO eduVO, HttpServletRequest request, HttpServletResponse response) throws Exception { //파일ID를 리스트에 담기 List<String> atchFileIdList = new ArrayList<String>(); //split을 이용해 아이디를 각자 배열에 담기 String[] splitStr =auditItemVO.getAtchFileIdDown().split(","); //리스트에 아이디 담기 for(int i=0; i<splitStr.length; i++) { atchFileIdList.add(splitStr[i]); } //zip파일 이름 (메뉴명+글 제목명 +날짜) String menuNm = ""; if(auditVO.getAutCd().equals("21 ")) { menuNm = "개인정보실태평가"; }else if(auditVO.getAutCd().equals("03")) { menuNm = "국정원실태평가"; }else if(auditVO.getAutCd().equals("01")) { menuNm = "외부감사"; }else if(eduVO.getAutCd().equals("02")) { if(eduVO.getAutConFlag().equals("01")) { menuNm = "교육계획"; }else if(eduVO.getAutConFlag().equals("02")) { menuNm = "회의계획"; }else if(eduVO.getAutConFlag().equals("03")) { menuNm = "연간교육계획"; } } String orgnZipNm = menuNm+"_"+auditVO.getAutSj()+"_"+auditVO.getFrstRegistPnttm().substring(0,10)+".zip"; // 압축 파일명 필요.. FileVO fileVO = new FileVO(); fileVO.setAtchFileIdList(atchFileIdList); List<FileVO> fvoList = fileService.selectNisEvalFileInfs(fileVO); // 해당 기능에 맞게 파일 조회 if(fvoList.size() == 0){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } // buffer size int size = 1024; byte[] buf = new byte[size]; String outZipNm = fvoList.get(0).getFileStreCours()+File.separator + orgnZipNm; FileInputStream fis = null; ZipArchiveOutputStream zos = null; BufferedInputStream bis = null; try { // Zip 파일생성 zos = new ZipArchiveOutputStream(new BufferedOutputStream(new FileOutputStream(outZipNm))); for ( FileVO vo : fvoList ){ zos.setEncoding("UTF-8"); //buffer에 해당파일의 stream을 입력한다. fis = new FileInputStream(vo.getFileStreCours() + "/" + vo.getStreFileNm()); bis = new BufferedInputStream(fis,size); //zip에 넣을 다음 entry 를 가져온다. zos.putArchiveEntry(new ZipArchiveEntry(vo.getOrignlFileNm())); //준비된 버퍼에서 집출력스트림으로 write 한다. int len; while((len = bis.read(buf,0,size)) != -1) zos.write(buf,0,len); bis.close(); fis.close(); zos.closeArchiveEntry(); } zos.close(); } catch (FileNotFoundException e) { e.printStackTrace(); }finally{ if( zos != null ) zos.close(); if( fis != null ) fis.close(); if( bis != null ) bis.close(); } File uFile = new File(fvoList.get(0).getFileStreCours(), orgnZipNm); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(orgnZipNm, request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } //파일 다운로드 후 파일 삭제 File delFile = new File(outZipNm); delFile.delete(); } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + orgnZipNm + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } /* 파일 다운로드 - 일괄 zip 압축(SLA관리)*/ @RequestMapping(value = "/cmm/fms/slaFileDownZip.do") public void slaFileDownZip(@RequestParam Map<String, Object> commandMap, @ModelAttribute("slaAutscitecVO") SlaAutscitecVO slaAutscitecVO, @ModelAttribute("slaAutItemVO") SlaAutItemVO slaAutItemVO, HttpServletRequest request, HttpServletResponse response) throws Exception { //파일ID를 리스트에 담기 List<String> atchFileIdList = new ArrayList<String>(); //split을 이용해 아이디를 각자 배열에 담기 String[] splitStr =slaAutItemVO.getAtchFileId().split(","); //리스트에 아이디 담기 for(int i=0; i<splitStr.length; i++) { atchFileIdList.add(splitStr[i]); } //zip파일 이름 (메뉴명+글 제목명 +날짜) String menuNm = "SLA관리"; String orgnZipNm = menuNm+"_"+slaAutscitecVO.getSlaSj()+"_"+slaAutscitecVO.getFrstRegistPnttm().substring(0,10)+".zip"; // 압축 파일명 필요.. FileVO fileVO = new FileVO(); fileVO.setAtchFileIdList(atchFileIdList); List<FileVO> fvoList = fileService.selectSLAFileInfs(fileVO); // 해당 기능에 맞게 파일 조회 if(fvoList.size() == 0){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } // buffer size int size = 1024; byte[] buf = new byte[size]; String outZipNm = fvoList.get(0).getFileStreCours()+File.separator + orgnZipNm; FileInputStream fis = null; ZipArchiveOutputStream zos = null; BufferedInputStream bis = null; try { // Zip 파일생성 zos = new ZipArchiveOutputStream(new BufferedOutputStream(new FileOutputStream(outZipNm))); for ( FileVO vo : fvoList ){ zos.setEncoding("UTF-8"); //buffer에 해당파일의 stream을 입력한다. fis = new FileInputStream(vo.getFileStreCours() + "/" + vo.getStreFileNm()); bis = new BufferedInputStream(fis,size); //zip에 넣을 다음 entry 를 가져온다. zos.putArchiveEntry(new ZipArchiveEntry(vo.getOrignlFileNm())); //준비된 버퍼에서 집출력스트림으로 write 한다. int len; while((len = bis.read(buf,0,size)) != -1) zos.write(buf,0,len); bis.close(); fis.close(); zos.closeArchiveEntry(); } zos.close(); } catch (FileNotFoundException e) { e.printStackTrace(); }finally{ if( zos != null ) zos.close(); if( fis != null ) fis.close(); if( bis != null ) bis.close(); } File uFile = new File(fvoList.get(0).getFileStreCours(), orgnZipNm); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(orgnZipNm, request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } //파일 다운로드 후 파일 삭제 File delFile = new File(outZipNm); delFile.delete(); } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + orgnZipNm + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } /* 파일 다운로드 - 일괄 zip 압축(정기점검)*/ @RequestMapping(value = "/cmm/fms/perFileDownZip.do") public void perFileDownZip(@RequestParam Map<String, Object> commandMap, PeriFile periFileVO, PeritemVO peritemVO, PerispVO perispVO, HttpServletRequest request, HttpServletResponse response) throws Exception { //파일ID를 리스트에 담기 List<String> atchFileIdList = new ArrayList<String>(); //split을 이용해 아이디를 각자 배열에 담기 String[] splitStr =periFileVO.getAtchFileId().split(","); //리스트에 아이디 담기 for(int i=0; i<splitStr.length; i++) { atchFileIdList.add(splitStr[i]); } //zip파일 이름 (메뉴명+글 제목명 +날짜) String menuNm = "정기점검"; String orgnZipNm = menuNm+"_"+perispVO.getPeriSj()+"_"+perispVO.getFrstRegistPnttm().substring(0,10)+".zip"; // 압축 파일명 필요.. FileVO fileVO = new FileVO(); fileVO.setAtchFileIdList(atchFileIdList); List<FileVO> fvoList = fileService.selectPerFileInfs(fileVO); // 해당 기능에 맞게 파일 조회 if(fvoList.size() == 0){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } // buffer size int size = 1024; byte[] buf = new byte[size]; String outZipNm = fvoList.get(0).getFileStreCours()+File.separator + orgnZipNm; FileInputStream fis = null; ZipArchiveOutputStream zos = null; BufferedInputStream bis = null; try { // Zip 파일생성 zos = new ZipArchiveOutputStream(new BufferedOutputStream(new FileOutputStream(outZipNm))); for ( FileVO vo : fvoList ){ zos.setEncoding("UTF-8"); //buffer에 해당파일의 stream을 입력한다. fis = new FileInputStream(vo.getFileStreCours() + "/" + vo.getStreFileNm()); bis = new BufferedInputStream(fis,size); //zip에 넣을 다음 entry 를 가져온다. zos.putArchiveEntry(new ZipArchiveEntry(vo.getOrignlFileNm())); //준비된 버퍼에서 집출력스트림으로 write 한다. int len; while((len = bis.read(buf,0,size)) != -1) zos.write(buf,0,len); bis.close(); fis.close(); zos.closeArchiveEntry(); } zos.close(); } catch (FileNotFoundException e) { e.printStackTrace(); }finally{ if( zos != null ) zos.close(); if( fis != null ) fis.close(); if( bis != null ) bis.close(); } File uFile = new File(fvoList.get(0).getFileStreCours(), orgnZipNm); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(orgnZipNm, request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } //파일 다운로드 후 파일 삭제 File delFile = new File(outZipNm); delFile.delete(); } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + orgnZipNm + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } /*감사 첨부파일 다운로드 */ @RequestMapping(value = "/uss/itsm/audit/SciTecAuditItemFileDown.do") public void fileDownSciTecAuditAjax(@RequestParam Map<?, ?> commandMap, AuditVO auditVO, AuditItemVO auditItemVO, @RequestParam("atchFileId") String[] atchFileId, HttpServletRequest request, HttpServletResponse response ) throws Exception { String fileSn = "0"; for(String id:atchFileId) { FileVO fileVO = new FileVO(); fileVO.setAtchFileId(id); fileVO.setFileSn(fileSn); FileVO fvo = fileService.selectItsmFileInf(fileVO); if(fvo == null){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; }else { File uFile = new File(fvo.getFileStreCours(), fvo.getStreFileNm()); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(fvo.getOrignlFileNm(), request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + fvo.getOrignlFileNm() + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } } } /*첨부파일 다운로드 */ @RequestMapping(value = "/uss/itsm/nis/NisEvalItemFileDown.do") public void fileDownNisEvalItemAjax(@RequestParam Map<?, ?> commandMap, AuditVO auditVO, AuditItemVO auditItemVO, @RequestParam("atchFileId") String[] atchFileId, HttpServletRequest request, HttpServletResponse response ) throws Exception { String fileSn = "0"; for(String id:atchFileId) { FileVO fileVO = new FileVO(); fileVO.setAtchFileId(id); fileVO.setFileSn(fileSn); FileVO fvo = fileService.selectNisEvalItemFileInfo(fileVO); if(fvo == null){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; }else { File uFile = new File(fvo.getFileStreCours(), fvo.getStreFileNm()); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(fvo.getOrignlFileNm(), request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + fvo.getOrignlFileNm() + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } } } /* 파일 다운로드 - 일괄 zip 압축(IP관리 등)*/ @RequestMapping(value = "/cmm/fms/fileDownZip.do") public void fileDownZip(@RequestParam Map<String, Object> commandMap, PeriFile periFileVO, IpVO ipVO , AssetVO assetVO , HttpServletRequest request, HttpServletResponse response) throws Exception { //파일ID를 리스트에 담기 List<String> atchFileIdList = new ArrayList<String>(); String menuNm = "IP관리"; String orgnZipNm = "IP관리.zip"; List<FileVO> fvoList = new ArrayList<>(); if(null != commandMap.get("dbType")){ if("ipFile".equals((String) commandMap.get("dbType"))) { //IP관리 페이지 for(String IpId : ipVO.getIpIds()) { atchFileIdList.add(IpId); } FileVO fileVO = new FileVO(); fileVO.setAtchFileIdList(atchFileIdList); fvoList = fileService.selectIpFileList(fileVO); menuNm = "IP관리" ; orgnZipNm = "IP관리.zip"; }else if("assetFile".equals((String) commandMap.get("dbType"))) { //IP관리 페이지 for(String astId : assetVO.getAstIds()) { atchFileIdList.add(astId); } FileVO fileVO = new FileVO(); fileVO.setAtchFileIdList(atchFileIdList); fvoList = fileService.selectAssertFileList(fileVO); menuNm = "자산관리" ; orgnZipNm = "자산관리.zip"; } }else { //fvoList = fileService.selectItsmperFileInf(fileVO); } if(fvoList.size() == 0){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } // buffer size int size = 1024; byte[] buf = new byte[size]; String outZipNm = fvoList.get(0).getFileStreCours()+File.separator + orgnZipNm; FileInputStream fis = null; ZipArchiveOutputStream zos = null; BufferedInputStream bis = null; try { // Zip 파일생성 zos = new ZipArchiveOutputStream(new BufferedOutputStream(new FileOutputStream(outZipNm))); for ( FileVO vo : fvoList ){ zos.setEncoding("UTF-8"); //buffer에 해당파일의 stream을 입력한다. fis = new FileInputStream(vo.getFileStreCours() + "/" + vo.getStreFileNm()); bis = new BufferedInputStream(fis,size); //zip에 넣을 다음 entry 를 가져온다. zos.putArchiveEntry(new ZipArchiveEntry(vo.getOrignlFileNm())); //준비된 버퍼에서 집출력스트림으로 write 한다. int len; while((len = bis.read(buf,0,size)) != -1) zos.write(buf,0,len); bis.close(); fis.close(); zos.closeArchiveEntry(); } zos.close(); } catch (FileNotFoundException e) { e.printStackTrace(); }finally{ if( zos != null ) zos.close(); if( fis != null ) fis.close(); if( bis != null ) bis.close(); } File uFile = new File(fvoList.get(0).getFileStreCours(), orgnZipNm); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(orgnZipNm, request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } //파일 다운로드 후 파일 삭제 File delFile = new File(outZipNm); delFile.delete(); } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + orgnZipNm + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } /* 파일 다운로드 체크(IP관리 등)*/ @RequestMapping(value = "/uss/itsm/ip/FileDownZipCheckAjax.do") public ModelAndView fileDownZipCheckAjax(@RequestParam Map<String, Object> commandMap, PeriFile periFileVO, IpVO ipVO , AssetVO assetVO ) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); //파일ID를 리스트에 담기 List<String> atchFileIdList = new ArrayList<String>(); List<FileVO> fvoList = new ArrayList<>(); if(null != commandMap.get("dbType")){ if("ipFile".equals((String) commandMap.get("dbType"))) { //IP관리 페이지 for(String IpId : ipVO.getIpIds()){ atchFileIdList.add(IpId); } FileVO fileVO = new FileVO(); fileVO.setAtchFileIdList(atchFileIdList); fvoList = fileService.selectIpFileList(fileVO); }else if("assetFile".equals((String) commandMap.get("dbType"))) { //자산관리 페이지 for(String astId : assetVO.getAstIds()){ atchFileIdList.add(astId); } FileVO fileVO = new FileVO(); fileVO.setAtchFileIdList(atchFileIdList); fvoList = fileService.selectAssertFileList(fileVO); } }else { modelAndView.addObject("result", "fail"); } if(fvoList.size() != 0){ modelAndView.addObject("result", "success"); }else { modelAndView.addObject("result", "fail"); } return modelAndView; } /* 파일 이동(개인정보실태평가,국정원실태평가,외부감사)*/ @RequestMapping(value = "/cmm/fms/EvalFileMoveAjax.do") public ModelAndView evalFileMoveAjax(@RequestParam Map<String, Object> commandMap , @ModelAttribute("auditVO") AuditVO auditVO, @ModelAttribute("auditItemVO") AuditItemVO auditItemVO , EduVO eduVO, HttpServletRequest request, HttpServletResponse response) throws Exception { ModelAndView modelAndView = new ModelAndView(); modelAndView.setViewName("jsonView"); //파일ID를 리스트에 담기 List<String> atchFileIdList = new ArrayList<String>(); //split을 이용해 아이디를 각자 배열에 담기 String[] splitStr =auditItemVO.getAtchFileIdDown().split(","); //리스트에 아이디 담기 for(int i=0; i<splitStr.length; i++) { atchFileIdList.add(splitStr[i]); } //zip파일 이름 (메뉴명+글 제목명 +날짜) String menuNm = ""; if(auditVO.getAutCd().equals("21") || auditVO.getAutCd().equals("03") || auditVO.getAutCd().equals("01")) { menuNm = "개인정보"; //21 menuNm = "국정원실태평가"; //03 menuNm = "외부감사"; //01 AuditItemVO updateAuditItemVO = new AuditItemVO(); for(String atchFileId : atchFileIdList) { updateAuditItemVO.setAtchFileId(atchFileId); updateAuditItemVO.setAutAttfile1dep((String)commandMap.get("upload_list")); updateAuditItemVO.setAutAttfile2dep((String)commandMap.get("upload_list_detail")); auditManageService.moveAutitem(updateAuditItemVO); } modelAndView.addObject("result", "success"); }else if(eduVO.getAutCd().equals("02")) { if(eduVO.getAutConFlag().equals("01")) { menuNm = "교육계획"; AuditItemVO updateAuditItemVO = new AuditItemVO(); for(String atchFileId : atchFileIdList) { updateAuditItemVO.setAtchFileId(atchFileId); updateAuditItemVO.setAutAttfile1dep((String)commandMap.get("upload_list")); updateAuditItemVO.setAutAttfile2dep((String)commandMap.get("upload_list_detail")); auditManageService.moveAutitem(updateAuditItemVO); } modelAndView.addObject("result", "success"); }else if(eduVO.getAutConFlag().equals("02")) { menuNm = "회의계획"; AuditItemVO updateAuditItemVO = new AuditItemVO(); for(String atchFileId : atchFileIdList) { updateAuditItemVO.setAtchFileId(atchFileId); updateAuditItemVO.setAutAttfile1dep((String)commandMap.get("upload_list2")); updateAuditItemVO.setAutAttfile2dep((String)commandMap.get("upload_list_detail")); auditManageService.moveAutitem(updateAuditItemVO); } modelAndView.addObject("result", "success"); }else if(eduVO.getAutConFlag().equals("03")) { menuNm = "연간교육계획"; } } return modelAndView; } /*감사/담당자 명함 다운로드*/ @RequestMapping(value = "/cmm/fms/itsmCompanyFileDown.do") public void itsmCompanyFileDown(@RequestParam Map<String, Object> commandMap, HttpServletRequest request, HttpServletResponse response) throws Exception { String atchFileId = (String) commandMap.get("atchFileId"); String fileSn = (String) commandMap.get("fileSn"); FileVO fileVO = new FileVO(); fileVO.setAtchFileId(atchFileId); fileVO.setFileSn(fileSn); FileVO fvo = fileService.selectItsmFileInf(fileVO); if(fvo == null){ response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br></h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); return ; } File uFile = new File(fvo.getFileStreCours(), fvo.getStreFileNm()); long fSize = uFile.length(); if (fSize > 0) { String mimetype = "application/x-msdownload"; response.setContentType(mimetype); setDisposition(fvo.getOrignlFileNm(), request, response); //response.setContentLength(fSize); BufferedInputStream in = null; BufferedOutputStream out = null; try { in = new BufferedInputStream(new FileInputStream(uFile)); out = new BufferedOutputStream(response.getOutputStream()); FileCopyUtils.copy(in, out); out.flush(); } catch (Exception ex) { LOGGER.debug("IGNORED: {}", ex.getMessage()); } finally { if (in != null) { try { in.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } if (out != null) { try { out.close(); } catch (Exception ignore) { LOGGER.debug("IGNORED: {}", ignore.getMessage()); } } } } else { response.setContentType("application/x-msdownload"); PrintWriter printwriter = response.getWriter(); printwriter.println("<html>"); printwriter.println("<br><br><br><h2>Could not get file name:<br>" + fvo.getOrignlFileNm() + "</h2>"); printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>"); printwriter.println("<br><br><br>© webAccess"); printwriter.println("</html>"); printwriter.flush(); printwriter.close(); } } }