마카로닉스

206 No

스프링 PDF 샘플 2

2017-09-03 18:46:12 By 머나먼나라 0 1341 댓글수 4 포스트 하기

5월 2024
일	월	화	수	목	금	토
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31


<!-- PDF 라이브러리  5개-->
<!-- https://mvnrepository.com/artifact/com.itextpdf/itextpdf -->
<dependency>
    <groupId>com.itextpdf</groupId>
    <artifactId>itextpdf</artifactId>
    <version>5.5.9</version>
</dependency>

<!-- https://mvnrepository.com/artifact/com.itextpdf/itext-pdfa -->
<dependency>
    <groupId>com.itextpdf</groupId>
    <artifactId>itext-pdfa</artifactId>
    <version>5.5.9</version>
</dependency>

<!-- https://mvnrepository.com/artifact/com.itextpdf/itext-xtra -->
<dependency>
    <groupId>com.itextpdf</groupId>
    <artifactId>itext-xtra</artifactId>
    <version>5.5.9</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.itextpdf.tool/xmlworker -->
<dependency>
    <groupId>com.itextpdf.tool</groupId>
    <artifactId>xmlworker</artifactId>
    <version>5.5.9</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.itextpdf/itext-asian -->
<dependency>
    <groupId>com.itextpdf</groupId>
    <artifactId>itext-asian</artifactId>
    <version>5.2.0</version>
</dependency>

<!-- PDF 라이브러리 끝 -->

@Controller
@RequestMapping("/admin/pdf")
public class AdminPDFController {

	private static final Logger logger =LoggerFactory.getLogger(AdminPDFController.class);
	
	private final String JSP_PAGE="/admin/pdf/";
	
	private final String FONT_PATH="/resources/font/malgun.ttf";
	
	private final String PDF_CSS="/resources/admin/dist/css/AdminLTE.css";
	
	@Inject
	private BoardService boardService;
	
	@RequestMapping(value="/board", method=RequestMethod.GET)
	public String pdfboardList(PageAndSearch pas , Model model){
	 
		int count =boardService.countArticle(pas.getSearch_option(), pas.getKeyword());
		
		//페이지 나누기 관련 처리
		if(pas.getCurPage()==null){pas.setCurPage(1);}
		

		Pager pager =new Pager(count, pas.getCurPage());
		int start =pager.getPageBegin();
		int end=pager.getPageEnd();
		
		List<BoardVO> list=boardService.boardList(start, end, pas.getSearch_option(), pas.getKeyword());
		
		Map<String, Object> map =new HashMap<>();
		map.put("countList", count);
		map.put("list", list);
		map.put("pager", pager);
			
		model.addAttribute("map", map);
		model.addAttribute("pageAndSearch", pas);
		
				
		return JSP_PAGE +"boardpdf"; 
	}
	
	
	@RequestMapping(value="/boardWrite/{bno}", method=RequestMethod.GET)
	public ResponseEntity<String> boardOutput(@PathVariable("bno") Integer bno   ,HttpServletRequest request) throws Exception{
		ResponseEntity<String> entity=null;
	
		//logger.info("bno  : " + bno);
		UploadPath.attach_path=FONT_PATH;
		String uploadPath =UploadPath.path(request);
		
		UploadPath.attach_path=PDF_CSS;
		String pdf_css_uploadpath =UploadPath.path(request);
		
		BoardVO vo =boardService.getBoard(bno);
		try {
				//com.itextpdf.text.Document
				Document document=new Document();//pdf 문서 객체 생성
				//pdf wirter 객체
				PdfWriter writer =PdfWriter.getInstance(document, 
						new FileOutputStream("D:\\"+vo.getTitle()+".pdf"));
				document.open(); // pdf 문서 열기
				BaseFont baseFont=BaseFont.createFont(
						uploadPath,
						BaseFont.IDENTITY_H, BaseFont.EMBEDDED );
			
				
				Font font=new Font(baseFont, 12);//폰트 설정
				PdfPTable table=new PdfPTable(5);//5 컬럼의 테이블
				Chunk chunk =new Chunk("게시판", font);// 출력할 내용
				
				Paragraph ph =new Paragraph(chunk);//문단
				ph.setAlignment(Element.ALIGN_CENTER);//가운데 정렬
				document.add(ph);
				
				//줄바꿈
				document.add(Chunk.NEWLINE);
				document.add(Chunk.NEWLINE);
				
				//테이블의 타이틀 행 생성
				PdfPCell cell1 =new PdfPCell(new Phrase("번호", font));
				cell1.setHorizontalAlignment(Element.ALIGN_CENTER);
				table.addCell(cell1);
				PdfPCell cell2 =new PdfPCell(new Phrase("제목", font));
				cell2.setHorizontalAlignment(Element.ALIGN_CENTER);
				table.addCell(cell2);
				PdfPCell cell3 =new PdfPCell(new Phrase("이름", font));
				cell3.setHorizontalAlignment(Element.ALIGN_CENTER);
				table.addCell(cell3);
				PdfPCell cell4 =new PdfPCell(new Phrase("날짜", font));
				cell4.setHorizontalAlignment(Element.ALIGN_CENTER);
				table.addCell(cell4);
				PdfPCell cell5 =new PdfPCell(new Phrase("조회수", font));
				cell5.setHorizontalAlignment(Element.ALIGN_CENTER);
				table.addCell(cell5);
				
				
				PdfPCell cellBno=new PdfPCell(new Phrase(""+vo.getBno(), font));
				cellBno.setHorizontalAlignment(Element.ALIGN_CENTER);
				table.addCell(cellBno); //번호
				PdfPCell cellName=new PdfPCell(new Phrase(vo.getWriter(), font));
				cellName.setHorizontalAlignment(Element.ALIGN_CENTER);
				table.addCell(cellName);// 유저이름
				PdfPCell cellTitle =new PdfPCell(new Phrase(vo.getTitle(), font));
				cellTitle.setHorizontalAlignment(Element.ALIGN_CENTER);
				table.addCell(cellTitle); //제목
				
				Date date =vo.getRegdate();
				SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
				String srtDate =sdf.format(date);
				PdfPCell cellDate =new PdfPCell(new Phrase(srtDate, font));
				cellDate.setHorizontalAlignment(Element.ALIGN_CENTER);
				table.addCell(cellDate); //날짜
				
				PdfPCell cellCount=new PdfPCell(new Phrase(""+vo.getViewcnt(), font));
				cellCount.setHorizontalAlignment(Element.ALIGN_CENTER);
				table.addCell(cellCount);//조회수
				
				
				PdfPTable table2=new PdfPTable(1);//2 테이블
				PdfPCell table2_cell1 =new PdfPCell(new Phrase("내용", font));
				table2_cell1.setHorizontalAlignment(Element.ALIGN_CENTER);
				table2.addCell(table2_cell1);
				PdfPCell table2_content =new PdfPCell(new Phrase(vo.getContent(), font));
				table2.addCell(table2_content);
				
				
				 //document.newPage(); //페이지 나누기
		/*		
				///여기서 부터  Html 변화 작업
				XMLWorkerHelper helper = XMLWorkerHelper.getInstance();
				// CSS
				CSSResolver cssResolver = new StyleAttrCSSResolver();
				CssFile cssFile = helper.getCSS(new FileInputStream(pdf_css_uploadpath));
				cssResolver.addCss(cssFile);
				
				// HTML, 폰트 설정
				XMLWorkerFontProvider fontProvider = new XMLWorkerFontProvider(XMLWorkerFontProvider.DONTLOOKFORFONTS);
				fontProvider.register(uploadPath, "MalgunGothic"); // MalgunGothic은 alias,
				CssAppliers cssAppliers = new CssAppliersImpl(fontProvider);
				
				
				HtmlPipelineContext htmlContext = new HtmlPipelineContext(cssAppliers);
				htmlContext.setTagFactory(Tags.getHtmlTagProcessorFactory());
				 
				
				// Pipelines
				PdfWriterPipeline pdf = new PdfWriterPipeline(document, writer);
				HtmlPipeline html = new HtmlPipeline(htmlContext, pdf);
				CssResolverPipeline css = new CssResolverPipeline(cssResolver, html);
				 
				XMLWorker worker = new XMLWorker(css, true);
				XMLParser xmlParser = new XMLParser(worker, Charset.forName("UTF-8"));
				 
				// 폰트 설정에서 별칭으로 줬던 "MalgunGothic"을 html 안에 폰트로 지정한다.
				String htmlStr =vo.getContent() ;
				 
				StringReader strReader = new StringReader(htmlStr);
				xmlParser.parse(strReader);
				
				
				PdfPCell cellCountent=new PdfPCell(xmlParser.parse(strReader));
				table2.addCell(cellCountent);//내용
				
				*/
				document.add(table);
				document.add(table2);//두번째 "내용 테이블"  
				document.close();//pdf 문서 닫기
				
				entity=new ResponseEntity<String>("SUCCESS", HttpStatus.OK);
		}catch(Exception e){
			e.printStackTrace();
			entity=new ResponseEntity<String>(HttpStatus.BAD_REQUEST);
		}
		
		return entity; //views/pdf/list.jsp 로 포워딩
	}
	
	
	
	
	
	
}

<script src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.4/jquery.js"></script> 
      
      
<script type="text/javascript" src="https://www.google.com/jsapi"></script>

                <tr>
                  <td>${row.bno }</td>
                 
                  <td class="rowTitle">          
        <a href="/board/view.do${pageAndSearch.searchQuery(param.curPage) }&bno=${row.bno }">${row.title } 
			  <c:if test="${row.cnt  > 0}">
				<span class="label label-danger">[ ${row.cnt }]</span>
			  </c:if>
 			     </a>
 			     </td>
 			     
 			     
                  <td>${ row.writer }</td>
                  <td><span class="label label-success">
                  <fmt:formatDate value="${ row.regdate }"  pattern="yyyy-MM-dd hh:mm"/></span>
                  </td>
                  <td class="pdfHref"><a href="/admin/pdf/boardWrite/${row.bno }" data-name="${row.title }" ><span class="badge bg-red">PDF 출력</span></a></td>
              </tr>



<script>
  
$(document).ready(function(){

	
	
	
	$(".pdfHref").on("click" , "a" , function(event){
		
		event.preventDefault();
		var pdfUrl =$(this).attr("href");
		var title =$(this).attr("data-name");
		
		$.ajax({
			
			url :pdfUrl,
			type:"get",
			success:function(result){
				
				if(result=="SUCCESS"){
					alert("D:\\" + title+ ".pdf  로 PDF 파일이 출력 되었습니다.");	
				}
				
			}
		});
		
	});

	
});