package kr.co.udapsoft.common.commonSign.util; import java.awt.Color; import java.io.IOException; import java.io.OutputStream; import java.sql.Connection; import javax.servlet.http.HttpServletRequest; import com.lowagie.text.Document; import com.lowagie.text.DocumentException; import com.lowagie.text.Element; import com.lowagie.text.Font; import com.lowagie.text.Image; import com.lowagie.text.PageSize; import com.lowagie.text.Paragraph; import com.lowagie.text.Rectangle; import com.lowagie.text.pdf.BaseFont; import com.lowagie.text.pdf.PdfPCell; import com.lowagie.text.pdf.PdfPTable; import com.lowagie.text.pdf.PdfWriter; /* * 외주기성고 계산서 : http://172.17.217.243/lib/dlgReport.screen?&WINDOW_TITLE=%20&REPORT_NAME=%2Fjsp%2Fko_kr%2Fsub%2Freport%2FSUBAcmpBillList.mrd&REPORT_OPTION=%2Frf&HIDE_STATUS_BAR=false&HIDE_TOOL_BAR=false&ZOOM_RATIO=100&HIDE_STATUS_DLG=false&P_0=6250A10401&P_1=200808&P_2='SUBO06110064'%2C'SUBO06110089'%2C'SUBO07010064'%2C'SUBO07030114'%2C'SUBO07030116'%2C'SUBO07050041'%2C'SUBO07070043'%2C'SUBO08040034'%2C'SUBO08040127'%2C'SUBO08050150'%2C'SUBO08070004'%2C'SUBO08070023'%2C'SUBO08070026'%2C'SUBO06110066'%2C'SUBO07010039'%2C'SUBO06110040'%2C'SUBO07020049'%2C'SUBO07090060'%2C'SUBO07110105'%2C'SUBO07110107'%2C'SUBO07120076'%2C'SUBO07120085'%2C'SUBO07120109'%2C'SUBO07120131'%2C'SUBO07120133'%2C'SUBO08010025'%2C'SUBO08010058'%2C'SUBO08020050'%2C'SUBO08030015'%2C'SUBO08040100'%2C'SUBO08040141'%2C'SUBO08060015'%2C'SUBO08060040'%2C'SUBO08060078'%2C'SUBO08070074'%2C'SUBO07010081'%2C'SUBO07030115'%2C'SUBO07060089'%2C'SUBO07070013'%2C'SUBO07070053'%2C'SUBO07070086'%2C'SUBO07070088'%2C'SUBO07070089'%2C'SUBO07100113'%2C'SUBO07100118'%2C'SUBO07100124'%2C'SUBO07110030'%2C'SUBO08030034'%2C'SUBO08030122'%2C'SUBO06120108'%2C'SUBO07020069'%2C'SUBO07020083'%2C'SUBO07030125'%2C'SUBO07050062'%2C'SUBO07060070'%2C'SUBO07070051'%2C'SUBO07070119'%2C'SUBO07070122'%2C'SUBO07100123'%2C'SUBO07120055'%2C'SUBO07120062'%2C'SUBO07120113'%2C'SUBO08030075'%2C'SUBO08060115'%2C'SUBO08060118'%2C'SUBO08070006'%2C'SUBO08070037'%2C'SUBO08070167'%2C'SUBO08070168'%2C'SUBO08080030'%2C'SUBO06120082'%2C'SUBO07030006'%2C'SUBO07030110'%2C'SUBO07040059'%2C'SUBO07040075'%2C'SUBO07090007'%2C'SUBO07110067'%2C'SUBO07120004'%2C'SUBO07120081'%2C'SUBO08010023'%2C'SUBO08010104'%2C'SUBO08010171'%2C'SUBO08030099'%2C'SUBO08040027'%2C'SUBO08040089'%2C'SUBO08060018'%2C'SUBO08090001'&P_SIZE=3 * */ import com.udapsoft.waf.system.HandlerStorage; import kr.co.hsnc.common.base.WAFLogger; import kr.co.hsnc.common.config.WAFConfig; import kr.co.hsnc.common.sql.RowSet; import kr.co.hsnc.common.sql.RowSetImpl; import kr.co.hsnc.common.sql.persistent.Persistent; import kr.co.hsnc.common.sql.persistent.PersistentImpl; import kr.co.hsnc.common.sql.search.Search; import kr.co.hsnc.common.sql.search.SearchImpl; import kr.co.hsnc.common.sql.util.RowSetUtility; import kr.co.hsnc.common.util.ValueObject; import kr.co.udapsoft.common.util.PCMSUtil; public class SACDOCreatePDF4 { public static BaseFont bfKorean = null; /* * private static Font FontKorean = null; */ public static Font FontBold = null; private static String strClassName = (new Throwable()).getStackTrace()[0] .getClassName(); //private static String strFileName = "d:\\temp\\pdf\\" + strClassName +".pdf"; private static String strFileName = WAFConfig.get("waf.repository.path") + "\\" + strClassName + ".pdf"; private static Color borderColor = Color.BLACK; private static String strGubun = null; private static float BorderW = 0.1f; private static Rectangle border = new Rectangle(0f, 0f); private static boolean isGray = false; private static boolean LineisGray = false; //데이터 로 /** * @param args */ public void doBiz(OutputStream outputStream, String tmpslipID, HttpServletRequest request) { WAFLogger.debug("\n\t #################### 구매 대금지급생성 시작"); // step 1 Document document = new Document(PageSize.A4, 25f, 25f, 35f, 10f); try { // step 2 PdfWriter writer = PdfWriter.getInstance(document, outputStream); // step 3 document.open(); BaseFont bfKorean = BaseFont.createFont("HYGoThic-Medium", "UniKS-UCS2-H", BaseFont.NOT_EMBEDDED); Font FontTitle = new Font(bfKorean, 8, Font.NORMAL); FontTitle.setColor(borderColor); Font FontData = new Font(bfKorean, 4.8f, Font.NORMAL); Font FontTitle2 = new Font(bfKorean, 20, Font.BOLD); PdfPTable table = null; PdfPCell cell = null; /* * 정보 검색 시작 --------------------------------------------- */ ValueObject params = new ValueObject(); HandlerStorage storage = new HandlerStorage(); storage.setParams(params); ValueObject listRowSet = null; /* * 정보 검색 시작 --------------------------------------------- */ listRowSet = getPayReqList(tmpslipID); // 정보 검색 끝 --------------------------------------------- /* * =========================================================================================== * 제목 생성 * =========================================================================================== */ if(listRowSet.get("DEPOSIT_CD").equals("1")){ makeTitle_1(document, FontTitle, FontTitle2, request); }else{ makeTitle(document, FontTitle, FontTitle2, request); } //본문생성 setBorder(border, true, true, true, true); //1행 PdfPTable table11 = new PdfPTable(6); table11.setWidthPercentage(100); table11.setSpacingBefore(7f); table11.setSpacingAfter(7f); float[] table11Width = {15f,3f,27f,3f,27f,30f}; table11.setWidths(table11Width); // 1행 PT_addCell(table11, new String [] { "계약번호" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("ORD_DOC_NO"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "작성일자" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REQ_DATE"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "작성자" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("REQ_CHARGE_NAME"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "협조부서" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("COOP_DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "현장코드" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_CD"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f,false); PT_addCell(table11, new String [] { "통화" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CURRENCY_GB"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "현장명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 5, 20f ,false); /*PT_addCell(table11, new String [] { "현장명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "현장코드" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_CD"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false);*/ PT_addCell(table11, new String [] { "계약명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CST_DOC_NAME"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 5, 20f ,false); PT_addCell(table11, new String [] { "계약업체명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CORP_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "대표이사" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REP_NAME"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "총계약금액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("ORD_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "선급금액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("PREPAY_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "지급구분" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPOSIT_GB"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "기선급공제액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("PREPAY_ACMP_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "지급사유" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPOSIT_RESN"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "선급잔액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("PREPAY_RMDR"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "기지불액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("PAYED_AMT")+" ("+listRowSet.get("PAYED_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "전기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("BEF_ACMP_AMT")+" ("+listRowSet.get("BEF_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "금회청구액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_REQ_AMT")+" ("+listRowSet.get("CUR_REQ_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "금회기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_ACMP_AMT")+" ("+listRowSet.get("CUR_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "금회포함지불액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_PAYED_AMT")+" ("+listRowSet.get("CUR_PAYED_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "금회포함기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_BEF_ACMP_AMT")+" ("+listRowSet.get("CUR_BEF_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "잔액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("REMAINDER_AMT")+" ("+listRowSet.get("REMAINDER_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "미기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REMAINDER_ACMP_AMT")+" ("+listRowSet.get("REMAINDER_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "특기사항" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 200f ,true); PT_addCell(table11, listRowSet.get("RE_MARKS"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_TOP, 5, 200f ,false); PT_addCell(table11, new String [] { "첨부서류" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 120f ,true); PdfPTable table21 = new PdfPTable(4); float[] table21Width = {3f,27,3,27f}; table21.setWidths(table21Width); PdfPCell permission = new PdfPCell(table21); PT_addCell(table21, listRowSet.get("DOC_PAYREQ"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "대금청구서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_COMPLETE"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "설치완료확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_GUAR_CONST"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "계약이행 보증보험 증권" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_TESTRUN"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "시운전완료확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_MRR"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "지급이행 보증보험 증권" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_INSPECTION_REPORT"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "Inspection Report" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_GUAR_AS"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "하자이행 보증보험 증권" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_SHIP"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "선적서류(B/L, Packing List)" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_ITEMINPUTCONFIRM"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "원자재입고확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_FINAL_DOCUMENTS"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "Final Documents 제출 확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_CONFIRM"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "MRR" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_CONST_COPY"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "계약서 사본" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_WORKQA"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "거래명세서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_ETC"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "기타" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_MC"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); permission.setColspan(4); table11.addCell(permission); PT_addCell(table11, "", FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 120f,false); document.add(table11); } catch (DocumentException de) { WAFLogger.debug("de.getMessage() = " + de.getMessage()); } catch (IOException ioe) { WAFLogger.debug("ioe.getMessage() = " + ioe.getMessage()); } catch (Exception e) { WAFLogger.debug("[Exception] ... " + e); } // step 5 document.close(); WAFLogger.debug("\n\t #################### "+ strFileName +" 생성완료"); } /* * =========================================================================================== * A. 타이틀 * =========================================================================================== */ public void doBiz1(Connection con, OutputStream outputStream, String tmpslipID, HttpServletRequest request) { WAFLogger.debug("\n\t #################### 구매 대금지급생성 시작"); // step 1 Document document = new Document(PageSize.A4, 25f, 25f, 35f, 10f); try { // step 2 PdfWriter writer = PdfWriter.getInstance(document, outputStream); // step 3 document.open(); BaseFont bfKorean = BaseFont.createFont("HYGoThic-Medium", "UniKS-UCS2-H", BaseFont.NOT_EMBEDDED); Font FontTitle = new Font(bfKorean, 8, Font.NORMAL); FontTitle.setColor(borderColor); Font FontData = new Font(bfKorean, 4.8f, Font.NORMAL); Font FontTitle2 = new Font(bfKorean, 20, Font.BOLD); PdfPTable table = null; PdfPCell cell = null; /* * 정보 검색 시작 --------------------------------------------- */ ValueObject params = new ValueObject(); HandlerStorage storage = new HandlerStorage(); storage.setParams(params); ValueObject listRowSet = null; /* * 정보 검색 시작 --------------------------------------------- */ listRowSet = getPayReqList1(con, tmpslipID); // 정보 검색 끝 --------------------------------------------- /* * =========================================================================================== * 제목 생성 * =========================================================================================== */ makeTitle_2(document, FontTitle, FontTitle2, request); //본문생성 setBorder(border, true, true, true, true); //1행 PdfPTable table11 = new PdfPTable(6); table11.setWidthPercentage(100); table11.setSpacingBefore(7f); table11.setSpacingAfter(7f); float[] table11Width = {15f,3f,27f,3f,27f,30f}; table11.setWidths(table11Width); // 1행 PT_addCell(table11, new String [] { "계약번호" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("ORD_DOC_NO"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "작성일자" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REQ_DATE"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f,false); //2015.10.22 양식변경 PT_addCell(table11, new String [] { "작성자" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("REQ_CHARGE_NAME"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "협조부서" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("COOP_DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "현장코드" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_CD"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f,false); PT_addCell(table11, new String [] { "통화" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CURRENCY_GB"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "현장명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 5, 20f ,false); /*PT_addCell(table11, new String [] { "현장명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "현장코드" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_CD"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false);*/ PT_addCell(table11, new String [] { "계약명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CST_DOC_NAME"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 5, 20f ,false); PT_addCell(table11, new String [] { "계약업체명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CORP_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "사업자번호" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CORP_REG_NO"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "지급조건" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("PAYMENT_TERMS"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "대표이사" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REP_NAME"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "총계약금액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("ORD_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "선급금액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("PREPAY_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "지급구분" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPOSIT_GB"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "지급사유" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("DEPOSIT_RESN"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table11, new String [] { "기지불액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("PAYED_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "기선급공제액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("PREPAY_ACMP_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "금회청구액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_REQ_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "금회선급공제액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_PREPAY_APPLYAMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table11, new String [] { "금회포함지불액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_PAYED_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "선급잔액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("PREPAY_RMDR"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "잔액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("REMAINDER_AMT")+" ("+listRowSet.get("REMAINDER_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "금회선급공제누계" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_PREPAY_APPLYAMT1"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table11, new String [] { "전기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("BEF_ACMP_AMT")+" ("+listRowSet.get("BEF_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f,false); PT_addCell(table11, new String [] { "" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, "", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "금회기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_ACMP_AMT")+" ("+listRowSet.get("CUR_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f,false); PT_addCell(table11, new String [] { "" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, "", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); /*PT_addCell(table11, new String [] { "금회포함기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_BEF_ACMP_AMT")+" ("+listRowSet.get("CUR_BEF_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "미기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REMAINDER_ACMP_AMT")+" ("+listRowSet.get("REMAINDER_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false);*/ PT_addCell(table11, new String [] { "특기사항" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 200f ,true); PT_addCell(table11, listRowSet.get("RE_MARKS"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_TOP, 5, 200f ,false); PT_addCell(table11, new String [] { "첨부서류" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 120f ,true); PdfPTable table21 = new PdfPTable(4); float[] table21Width = {3f,27,3,27f}; table21.setWidths(table21Width); PdfPCell permission = new PdfPCell(table21); PT_addCell(table21, listRowSet.get("DOC_PAYREQ"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "대금청구서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_COMPLETE"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "설치완료확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_GUAR_CONST"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "계약이행 보증보험 증권" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_TESTRUN"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "시운전완료확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_MRR"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "지급이행 보증보험 증권" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_INSPECTION_REPORT"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "Inspection Report" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_GUAR_AS"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "하자이행 보증보험 증권" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_SHIP"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "선적서류(B/L, Packing List)" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_ITEMINPUTCONFIRM"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "원자재입고확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_FINAL_DOCUMENTS"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "Final Documents 제출 확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_CONFIRM"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "MRR" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_CONST_COPY"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "계약서 사본" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_WORKQA"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "거래명세서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_ETC"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "기타" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_MC"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); permission.setColspan(4); table11.addCell(permission); PT_addCell(table11, "", FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 120f,false); document.add(table11); } catch (DocumentException de) { WAFLogger.debug("de.getMessage() = " + de.getMessage()); } catch (IOException ioe) { WAFLogger.debug("ioe.getMessage() = " + ioe.getMessage()); } catch (Exception e) { WAFLogger.debug("[Exception] ... " + e); } // step 5 document.close(); WAFLogger.debug("\n\t #################### "+ strFileName +" 생성완료"); } private static void makeTitle1(Document document, Font FontTitle, Font FontTitle2, HttpServletRequest request) throws Exception { PdfPTable tbl_Title = new PdfPTable(2); tbl_Title.setWidthPercentage(40f); float[] tbl_TitleWidths = {10f,10f}; tbl_Title.setWidths(tbl_TitleWidths); PdfPCell title= new PdfPCell(new Paragraph("대 금 지 급", FontTitle2)); title.setColspan(2); title.setHorizontalAlignment(Element.ALIGN_CENTER); title.setVerticalAlignment(Element.ALIGN_MIDDLE); title.setFixedHeight(40f); title.setBorder(0); title.setBorderWidthBottom(1); tbl_Title.addCell(title); PdfPCell titleB = new PdfPCell(new Paragraph("", FontTitle2)); titleB.setColspan(2); titleB.setFixedHeight(30f); titleB.setBorder(0); tbl_Title.addCell(titleB); //PT_addCell(tbl_Title, "대 금 지 급", FontTitle2, borderTemp, // Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 28f, false); document.add(tbl_Title); Image img = null; if(request == null) { //img = Image.getInstance(new URL("http://edreams21.co.kr/img/invoice/Title_bg1.gif")); } else { //img = Image.getInstance(new URL(request.getScheme(), request.getServerName(), request.getServerPort(), "/img/invoice/Title_bg1.gif")); } // img.scaleToFit(300f, 40f); // img.setAbsolutePosition(310, 554); // img.setAbsolutePosition(203, 246); // img.setAbsolutePosition(180, 310); // document.add(img); } private static void makeTitle_1(Document document, Font FontTitle, Font FontTitle2, HttpServletRequest request) throws Exception { PdfPTable tbl_Title = new PdfPTable(2); tbl_Title.setWidthPercentage(40f); float[] tbl_TitleWidths = {10f,10f}; tbl_Title.setWidths(tbl_TitleWidths); PdfPCell title= new PdfPCell(new Paragraph("선 급 금 지 급", FontTitle2)); title.setColspan(2); title.setHorizontalAlignment(Element.ALIGN_CENTER); title.setVerticalAlignment(Element.ALIGN_MIDDLE); title.setFixedHeight(40f); title.setBorder(0); title.setBorderWidthBottom(1); tbl_Title.addCell(title); PdfPCell titleB = new PdfPCell(new Paragraph("", FontTitle2)); titleB.setColspan(2); titleB.setFixedHeight(30f); titleB.setBorder(0); tbl_Title.addCell(titleB); document.add(tbl_Title); Image img = null; if(request == null) { //img = Image.getInstance(new URL("http://edreams21.co.kr/img/invoice/Title_bg1.gif")); } else { //img = Image.getInstance(new URL(request.getScheme(), request.getServerName(), request.getServerPort(), "/img/invoice/Title_bg1.gif")); } // img.scaleToFit(300f, 40f); // img.setAbsolutePosition(310, 554); // img.setAbsolutePosition(203, 246); // img.setAbsolutePosition(180, 310); // document.add(img); } private static void makeTitle_2(Document document, Font FontTitle, Font FontTitle2, HttpServletRequest request) throws Exception { PdfPTable tbl_Title = new PdfPTable(2); tbl_Title.setWidthPercentage(40f); float[] tbl_TitleWidths = {10f,10f}; tbl_Title.setWidths(tbl_TitleWidths); PdfPCell title= new PdfPCell(new Paragraph("대 금 지 급", FontTitle2)); title.setColspan(2); title.setHorizontalAlignment(Element.ALIGN_CENTER); title.setVerticalAlignment(Element.ALIGN_MIDDLE); title.setFixedHeight(40f); title.setBorder(0); title.setBorderWidthBottom(1); tbl_Title.addCell(title); PdfPCell titleB = new PdfPCell(new Paragraph("", FontTitle2)); titleB.setColspan(2); titleB.setFixedHeight(30f); titleB.setBorder(0); tbl_Title.addCell(titleB); //PT_addCell(tbl_Title, "대 금 지 급", FontTitle2, borderTemp, // Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 28f, false); document.add(tbl_Title); Image img = null; if(request == null) { //img = Image.getInstance(new URL("http://edreams21.co.kr/img/invoice/Title_bg1.gif")); } else { //img = Image.getInstance(new URL(request.getScheme(), request.getServerName(), request.getServerPort(), "/img/invoice/Title_bg1.gif")); } // img.scaleToFit(300f, 40f); // img.setAbsolutePosition(310, 554); // img.setAbsolutePosition(203, 246); // img.setAbsolutePosition(180, 310); // document.add(img); } private static void makeTitle(Document document, Font FontTitle, Font FontTitle2, HttpServletRequest request) throws Exception { PdfPTable tbl_Title = new PdfPTable(2); tbl_Title.setWidthPercentage(40f); float[] tbl_TitleWidths = {10f,10f}; tbl_Title.setWidths(tbl_TitleWidths); PdfPCell title= new PdfPCell(new Paragraph("대 금 지 급", FontTitle2)); title.setColspan(2); title.setHorizontalAlignment(Element.ALIGN_CENTER); title.setVerticalAlignment(Element.ALIGN_MIDDLE); title.setFixedHeight(40f); title.setBorder(0); title.setBorderWidthBottom(1); tbl_Title.addCell(title); PdfPCell titleB = new PdfPCell(new Paragraph("", FontTitle2)); titleB.setColspan(2); titleB.setFixedHeight(30f); titleB.setBorder(0); tbl_Title.addCell(titleB); //PT_addCell(tbl_Title, "대 금 지 급", FontTitle2, borderTemp, // Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 28f, false); document.add(tbl_Title); Image img = null; if(request == null) { //img = Image.getInstance(new URL("http://edreams21.co.kr/img/invoice/Title_bg1.gif")); } else { //img = Image.getInstance(new URL(request.getScheme(), request.getServerName(), request.getServerPort(), "/img/invoice/Title_bg1.gif")); } // img.scaleToFit(300f, 40f); // img.setAbsolutePosition(310, 554); // img.setAbsolutePosition(203, 246); // img.setAbsolutePosition(180, 310); // document.add(img); } /* * =========================================================================================== * B. 데이터 입력 * =========================================================================================== */ /* * =========================================================================================== * 기타 * =========================================================================================== */ // PdfPCell을 리턴하자 private static PdfPCell PC_addCell(String strText, Font FontTitle, Rectangle border, int HA, int VA, int CS) { // 추가할 Cell 생성 PdfPCell cell = new PdfPCell(new Paragraph(strText, FontTitle)); // PdfPCell cell = new PdfPCell(new Paragraph(strText)); // Cell Border 설정 // setBorder(cell, blnLEFT, blnRIGHT, blnTOP, blnBOTTOM); cell.cloneNonPositionParameters(border); // 가로/세로 정렬 cell.setHorizontalAlignment(HA); cell.setVerticalAlignment(VA); // setColspan if (CS > 1) cell.setColspan(CS); // cell.setPadding(0); if( isGray ) cell.setGrayFill(0.8f); //if( LineisGray ) // cell.setGrayFill(0.9f); //cell.setBackgroundColor(arg0) return cell; } // Cell Border 설정 private static void setBorder(Rectangle border, boolean blnLEFT, boolean blnRIGHT, boolean blnTOP, boolean blnBOTTOM) { border.setBorderColor(borderColor); if (blnLEFT) { border.setBorderWidthLeft(BorderW); } else { border.setBorderWidthLeft(0); } if (blnRIGHT) { border.setBorderWidthRight(BorderW); } else { border.setBorderWidthRight(0); } if (blnTOP) { border.setBorderWidthTop(BorderW); } else { border.setBorderWidthTop(0); } if (blnBOTTOM) { border.setBorderWidthBottom(BorderW); } else { border.setBorderWidthBottom(0); } } // PdfPTable에 Cell 을 추가하자 private static void PT_addCell(PdfPTable table, String[] arrText, Font FontTitle, Rectangle border, int HA, int VA, int CS) { for (int i = 0; i < arrText.length; i++) { PT_addCell(table, arrText[i], FontTitle, border, HA, VA, CS); } } private static void PT_addCell(PdfPTable table, String[] arrText, Font FontTitle, Rectangle border, int HA, int VA, int CS, float RH, boolean CL) { for (int i = 0; i < arrText.length; i++) { PT_addCell(table, arrText[i], FontTitle, border, HA, VA, CS, RH, CL); } } private static void PT_addCell(PdfPTable table, String strText, Font FontTitle, Rectangle border, int HA, int VA, int CS) { // 추가할 Cell 생성 PdfPCell cell = PC_addCell(strText, FontTitle, border, HA, VA, CS); table.addCell(cell); } // PdfPTable에 Cell 을 추가하자(행높이 추가) private static void PT_addCell(PdfPTable table, String strText, Font FontTitle, Rectangle border, int HA, int VA, int CS, float RH, boolean CL) { // 추가할 Cell 생성 PdfPCell cell = PC_addCell(strText, FontTitle, border, HA, VA, CS); // 셀 높이 if (RH > 0) cell.setFixedHeight(RH); if (CL) { cell.setBackgroundColor(Color.lightGray); } else { cell.setBackgroundColor(Color.white); } table.addCell(cell); } public ValueObject getPayReqList(String tmpslipID ){ Search search = new SearchImpl(); ValueObject vo = null; RowSet rowSet = new RowSetImpl(); StringBuffer sql = new StringBuffer(); try{ sql.append(" SELECT \n"); sql.append(" DECODE(A.DOC_INSPECTION_REPORT , 'Y', 'V', '') DOC_INSPECTION_REPORT -- 첨부_INSPECTION REPORT \n"); sql.append(" ,DECODE(A.DOC_CONFIRM , 'Y', 'V', '') DOC_CONFIRM -- 첨부_납품확인서 \n"); sql.append(" ,DECODE(A.DOC_FINAL_DOCUMENTS , 'Y', 'V', '') DOC_FINAL_DOCUMENTS -- 첨부_FINAL DOCUMENTS 제출확인서 \n"); sql.append(" ,DECODE(A.DOC_GUAR_CONST , 'Y', 'V', '') DOC_GUAR_CONST -- 첨부_계약이행보증보험증권 \n"); sql.append(" ,DECODE(A.DOC_GUAR_AS, 'Y', 'V', '') DOC_GUAR_AS -- 첨부_하자이행보증보험증권 \n"); sql.append(" ,DECODE(A.DOC_WORKQA, 'Y', 'V', '') DOC_WORKQA -- 첨부_기성검사보고서 \n"); sql.append(" ,DECODE(A.DOC_SHIP, 'Y', 'V', '') DOC_SHIP -- 첨부_선적서류(B/L,PACKING LIST) \n"); sql.append(" ,DECODE(A.DOC_COMPLETE, 'Y', 'V', '') DOC_COMPLETE -- 첨부_준공검사보고서 \n"); sql.append(" ,DECODE(A.DOC_CONST_COPY, 'Y', 'V', '') DOC_CONST_COPY -- 첨부_계약서사본 \n"); sql.append(" ,DECODE(A.DOC_ETC, 'Y', 'V', '') DOC_ETC -- 첨부_기타 \n"); sql.append(" ,DECODE(A.DOC_MC, 'Y', 'V', '') DOC_MC -- M/C 완료확인서 \n"); sql.append(" ,DECODE(A.DOC_TESTRUN, 'Y', 'V', '') DOC_TESTRUN -- 첨부_시운행 \n"); sql.append(" ,A.REQ_STATUS -- 대금신청상태 \n"); sql.append(" ,A.TRANS_CD -- 전표집계여부 \n"); sql.append(" ,A.PUR_CONT_ID -- 발주계약ID \n"); sql.append(" ,A.PAYREQ_ID -- 지급신청ID \n"); sql.append(" ,TO_CHAR(A.REQ_DATE, 'YYYY-MM-DD') REQ_DATE -- 신청서작성일자 \n"); sql.append(" ,A.REQ_CHARGE_ID -- 신청서작성자ID \n"); sql.append(" ,A.COOP_DEPT_CD -- 협조부서코드 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.ORD_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) ORD_AMT -- 총계약금액 \n"); sql.append(" ,F_GET_PUR_STATUS(A.DEPOSIT_CD, 'PUR_PAY_ACMP_GB') || '(' || TO_NUMBER(A.DEPOSIT_SEQ) || '차)' DEPOSIT_GB -- 지급구분이름 \n"); sql.append(" ,A.DEPOSIT_CD -- 지급구분 \n"); sql.append(" ,A.DEPOSIT_SEQ -- 지급차수 \n"); sql.append(" ,A.DEPOSIT_RESN -- 지급사유 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.PAYED_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) PAYED_AMT -- 기지불액 \n"); sql.append(" ,F_GET_D_CURRENCY(A.PAYED_PERCENT, 1) PAYED_PERCENT -- 기지불액비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.CUR_REQ_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) CUR_REQ_AMT -- 금회청구액 \n"); sql.append(" ,F_GET_D_CURRENCY(A.CUR_REQ_PERCENT, 1) CUR_REQ_PERCENT -- 금회청구액비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.CUR_PAYED_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) CUR_PAYED_AMT -- 금회포함지불액 \n"); sql.append(" ,F_GET_D_CURRENCY(A.CUR_PAYED_PERCENT, 1) CUR_PAYED_PERCENT -- 금회포함지불액비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.REMAINDER_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) REMAINDER_AMT -- 잔액 \n"); sql.append(" ,F_GET_D_CURRENCY(A.REMAINDER_PERCENT , 1) REMAINDER_PERCENT -- 잔액비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.BEF_ACMP_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) BEF_ACMP_AMT -- 전기성고 \n"); sql.append(" ,F_GET_D_CURRENCY(A.BEF_ACMP_PERCENT , 1) BEF_ACMP_PERCENT -- 전기성고비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.CUR_ACMP_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) CUR_ACMP_AMT -- 금회기성고 \n"); sql.append(" ,F_GET_D_CURRENCY(A.CUR_ACMP_PERCENT , 1) CUR_ACMP_PERCENT -- 금회기성고비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.CUR_BEF_ACMP_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) CUR_BEF_ACMP_AMT -- 금회포함기성고 \n"); sql.append(" ,F_GET_D_CURRENCY(A.CUR_BEF_ACMP_PERCENT ,1) CUR_BEF_ACMP_PERCENT -- 금회포함기성고비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.REMAINDER_ACMP_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) REMAINDER_ACMP_AMT -- 미기성고 \n"); sql.append(" ,F_GET_D_CURRENCY(A.REMAINDER_ACMP_PERCENT, 1) REMAINDER_ACMP_PERCENT -- 미기성고비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.CUR_PREPAY_DEDUCTAMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) CUR_PREPAY_DEDUCTAMT -- 금회선급금 공제 \n"); sql.append(" ,F_GET_D_CURRENCY(A.ACMP_APPLYRATE ,1) ACMP_APPLYRATE -- 기성고적용 비율 \n"); sql.append(" ,A.RE_MARKS -- 특기사항 \n"); sql.append(" ,DECODE(A.DOC_PAYREQ, 'Y', 'V', '') DOC_PAYREQ -- 첨부_대금청구서 \n"); sql.append(" ,DECODE(A.DOC_MRR, 'Y', 'V', '') DOC_MRR -- 첨부_MRR \n"); sql.append(" ,DECODE(A.DOC_ITEMINPUTCONFIRM, 'Y', 'V', '') DOC_ITEMINPUTCONFIRM -- 첨부_원자재입고확인서 \n"); sql.append(" ,B.ORD_DOC_NO AS ORD_DOC_NO -- 계약번호 \n"); sql.append(" ,F_GET_USER_NM(A.REQ_CHARGE_ID) AS REQ_CHARGE_NAME -- 작성자 \n"); sql.append(" ,GET_ACC_DEPT_NM(A.COOP_DEPT_CD) AS COOP_DEPT_NM -- 협조부서명 \n"); sql.append(" ,B.CST_DOC_NAME AS CST_DOC_NAME -- 계약명 \n"); sql.append(" ,GET_CORP_NM(B.CORP_ID) AS CORP_NM --계약업체명 \n"); sql.append(" ,(SELECT REP_NAME FROM PUR9000T_V D WHERE D.CORP_ID = B.CORP_ID ) REP_NAME -- 업체대표이사 \n"); sql.append(" ,(SELECT CORP_REG_NO FROM PUR9000T_V D WHERE D.CORP_ID = B.CORP_ID ) CORP_REG_NO -- 사업자번호 \n"); sql.append(" ,B.DEPT_NAME AS DEPT_NM -- 현장명 \n"); sql.append(" ,C.DEPT_CD AS DEPT_CD -- 현장코드 \n");//2018.06.25 b sql.append(" ,B.CURRENCY_GB -- 통화구분 \n"); sql.append(" ,F_GET_D_CURRENCY( F_PUR_AMT_SUM(A.PUR_CONT_ID, '1') \n"); sql.append(" , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) AS PREPAY_ACMP_AMT --기선급공제액 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL(B.PREPAY_AMT , 0) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) PREPAY_AMT --선급금액 \n"); sql.append(" ,F_GET_D_CURRENCY( PREPAY_AMT - F_PUR_AMT_SUM(A.PUR_CONT_ID, '1') \n"); sql.append(" , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) PREPAY_RMDR --선급잔액 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.CUR_REQ_VATAMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) CUR_REQ_VATAMT \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.CUR_PAYING_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( B.CURRENCY_GB, 'KRW' ) ) ) CUR_PAYING_AMT \n"); sql.append(" ,(SELECT CHG_CODE10 FROM COM911T WHERE DETAILCD = B.GUA_GB AND BASECD = 'PROOF_CD') VAT_STATUS \n"); sql.append(" FROM PUR1100T A , PUR1000T B , PUR1040T C \n"); sql.append(" WHERE A.PUR_CONT_ID = B.PUR_CONT_ID \n"); sql.append(" AND C.PAYREQ_ID = A.PAYREQ_ID \n"); sql.append(" AND C.TMPSLIP_ID = "+tmpslipID+" \n"); search.setStatement(sql.toString()); rowSet = search.execute(); if(rowSet.size()>0){ vo = RowSetUtility.getValueObject(rowSet.getRow(0)); } }catch(Exception e){ WAFLogger.error("SQL : " + search.getStatement()); WAFLogger.error(e); }finally{ if( vo == null) vo = new ValueObject(); } return vo; } public ValueObject getPayReqList1(Connection con, String tmpslipID ){ Search search = new SearchImpl(); ValueObject vo = null; RowSet rowSet = new RowSetImpl(); StringBuffer sql = new StringBuffer(); Persistent persistent_c = null; try{ persistent_c = new PersistentImpl(con); sql.append(" SELECT \n"); sql.append(" DECODE(B.DOC_INSPECTION_REPORT , 'Y', 'V', '') DOC_INSPECTION_REPORT -- 첨부_INSPECTION REPORT \n"); sql.append(" ,DECODE(B.DOC_PAYREQ , 'Y', 'V', '') DOC_PAYREQ -- 첨부_대금청구서 \n"); sql.append(" ,DECODE(B.DOC_MRR , 'Y', 'V', '') DOC_MRR -- 첨부_MRR \n"); sql.append(" ,DECODE(B.DOC_CONFIRM , 'Y', 'V', '') DOC_CONFIRM -- 첨부_납품확인서 \n"); sql.append(" ,DECODE(B.DOC_FINAL_DOCUMENTS , 'Y', 'V', '') DOC_FINAL_DOCUMENTS -- 첨부_FINAL DOCUMENTS 제출확인서 \n"); sql.append(" ,DECODE(B.DOC_GUAR_CONST , 'Y', 'V', '') DOC_GUAR_CONST -- 첨부_계약이행보증보험증권 \n"); sql.append(" ,DECODE(B.DOC_GUAR_AS, 'Y', 'V', '') DOC_GUAR_AS -- 첨부_하자이행보증보험증권 \n"); sql.append(" ,DECODE(B.DOC_WORKQA, 'Y', 'V', '') DOC_WORKQA -- 첨부_기성검사보고서 \n"); sql.append(" ,DECODE(B.DOC_SHIP, 'Y', 'V', '') DOC_SHIP -- 첨부_선적서류(B/L,PACKING LIST) \n"); sql.append(" ,DECODE(B.DOC_COMPLETE, 'Y', 'V', '') DOC_COMPLETE -- 첨부_준공검사보고서 \n"); sql.append(" ,DECODE(B.DOC_CONST_COPY, 'Y', 'V', '') DOC_CONST_COPY -- 첨부_계약서사본 \n"); sql.append(" ,DECODE(B.DOC_ETC, 'Y', 'V', '') DOC_ETC -- 첨부_기타 \n"); sql.append(" ,DECODE(B.DOC_MC, 'Y', 'V', '') DOC_MC -- M/C 완료확인서 \n"); sql.append(" ,DECODE(B.DOC_TESTRUN, 'Y', 'V', '') DOC_TESTRUN -- 첨부_시운행 \n"); sql.append(" ,B.REQ_STATUS -- 대금신청상태 \n"); sql.append(" ,B.TRANS_CD -- 전표집계여부 \n"); sql.append(" ,B.PUR_CONT_ID -- 발주계약ID \n"); sql.append(" ,B.PAYREQ_ID -- 지급신청ID \n"); sql.append(" ,TO_CHAR(TO_DATE(B.TAX_DY), 'YYYY-MM-DD') REQ_DATE -- 신청서작성일자 \n"); sql.append(" ,B.REQ_CHARGE_ID -- 신청서작성자ID \n"); sql.append(" ,(SELECT USER_NAME FROM PUB0120T WHERE ACCT_ID = B.CRE_BY) AS REQ_CHARGE_NAME -- 작성자 \n"); sql.append(" ,B.COOP_DEPT_CD -- 협조부서코드 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.ORD_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) AS ORD_AMT -- 발주계약금액 \n"); sql.append(" ,F_GET_PUR_STATUS(B.DEPOSIT_CD, 'PUR_PAY_ACMP_GB') || '(' || TO_NUMBER(B.DEPOSIT_SEQ) || '차)' DEPOSIT_GB -- 지급구분이름 \n"); sql.append(" ,B.DEPOSIT_CD -- 지급구분 \n"); sql.append(" ,B.DEPOSIT_SEQ -- 지급차수 \n"); sql.append(" ,B.DEPOSIT_RESN -- 지급사유 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.PAYED_APPLYAMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as PAYED_AMT --기지불액 \n"); sql.append(" ,F_GET_D_CURRENCY(B.PAYED_PERCENT, 1) PAYED_PERCENT -- 기지불액비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.CUR_REQ_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as CUR_REQ_AMT --금회청구액 \n"); sql.append(" ,F_GET_D_CURRENCY(B.CUR_REQ_PERCENT, 1) CUR_REQ_PERCENT -- 금회청구액비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.CUR_PAYED_SUPPLYAMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as CUR_PAYED_AMT --금회포함지불액 \n"); sql.append(" ,F_GET_D_CURRENCY(B.CUR_PAYED_PERCENT, 1) CUR_PAYED_PERCENT -- 금회포함지불액비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.REMAINDER_ACMP_SUPPLYAMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as REMAINDER_AMT -- 잔액 \n"); sql.append(" ,F_GET_D_CURRENCY(B.REMAINDER_ACMP_PERCENT , 1) REMAINDER_PERCENT -- 잔액비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.BEF_ACMP_APPLYAMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as BEF_ACMP_AMT --전기성고 \n"); sql.append(" ,F_GET_D_CURRENCY(B.BEF_ACMP_PERCENT , 1) BEF_ACMP_PERCENT -- 전기성고비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.CUR_ACMP_APPLYAMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as CUR_ACMP_AMT -- 금회기성고 \n"); sql.append(" ,F_GET_D_CURRENCY(B.CUR_ACMP_PERCENT , 1) CUR_ACMP_PERCENT -- 금회기성고비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.CUR_BEF_ACMP_SUPPLYAMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as CUR_BEF_ACMP_AMT -- 금회포함기성고 \n"); sql.append(" ,F_GET_D_CURRENCY(B.CUR_BEF_ACMP_PERCENT ,1) CUR_BEF_ACMP_PERCENT -- 금회포함기성고비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.REMAINDER_ACMP_SUPPLYAMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as REMAINDER_ACMP_AMT -- 미기성고 \n"); sql.append(" ,F_GET_D_CURRENCY(B.REMAINDER_ACMP_PERCENT, 1) REMAINDER_ACMP_PERCENT -- 미기성고비율 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.CUR_PREPAY_DEDUCTAMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ) ) ) AS CUR_PREPAY_DEDUCTAMT -- 금회선급금 공제 \n"); sql.append(" ,F_GET_D_CURRENCY(B.ACMP_APPLYRATE ,1) ACMP_APPLYRATE -- 기성고적용 비율 \n"); sql.append(" ,B.RE_MARKS -- 특기사항 \n"); sql.append(" ,A.ORD_DOC_NO AS ORD_DOC_NO -- 계약번호 \n"); sql.append(" ,GET_ACC_DEPT_NM(B.COOP_DEPT_CD) AS COOP_DEPT_NM -- 협조부서명 \n"); sql.append(" ,A.CST_DOC_NAME AS CST_DOC_NAME -- 계약명 \n"); sql.append(" ,GET_CORP_NM(C.DEALR_CD) AS CORP_NM --계약업체명 \n"); sql.append(" ,(SELECT REP_NAME FROM PUR9000T_V D WHERE D.CORP_ID = C.DEALR_CD ) REP_NAME -- 업체대표이사 \n"); sql.append(" ,(SELECT CORP_REG_NO FROM PUR9000T_V D WHERE D.CORP_ID = C.DEALR_CD ) CORP_REG_NO -- 사업자번호 \n"); sql.append(" ,A.DEPT_NAME AS DEPT_NM -- 현장명 \n"); sql.append(" ,A.DEPT_CD AS DEPT_CD -- 현장코드 \n"); sql.append(" ,A.CURRENCY_GB -- 통화구분 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.BEF_PREPAY_APPLYAMT , 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) AS PREPAY_ACMP_AMT --기선급공제액 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( (SELECT SUM(REQ_PREPAY_SUPPLY_AMT) FROM PUR1030T WHERE PUR_CONT_ID = B.PUR_CONT_ID GROUP BY PUR_CONT_ID), 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) AS PREPAY_AMT --선급금액 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.REMAINDER_PREPAY_SUPPLYAMT , 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) AS PREPAY_RMDR --선급잔액 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.CUR_REQ_VATAMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ) ) ) CUR_REQ_VATAMT \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.CUR_PAYING_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ) ) ) CUR_PAYING_AMT \n"); sql.append(" ,(SELECT CHG_CODE10 FROM EBID_COM911T WHERE DETAILCD = A.GUA_GB AND BASECD = 'PROOF_CD') VAT_STATUS \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.CUR_PREPAY_APPLYAMT , 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) CUR_PREPAY_APPLYAMT --금회선급공제액 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.BEF_PREPAY_APPLYAMT , 0 ) + NVL(B.CUR_PREPAY_APPLYAMT ,0), F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) CUR_PREPAY_APPLYAMT1 --금회선급공제액 \n"); sql.append(" ,(SELECT DETAILSORTNM FROM EBID_COM911T WHERE BASECD = '004' AND DETAILCD = B.PAYMENT_TERMS) PAYMENT_TERMS --지급조건 \n"); sql.append(" FROM PUR2000T A, \n"); sql.append(" PUR1100T B, \n"); sql.append(" PUR1040T C \n"); sql.append(" WHERE 1=1 \n"); sql.append(" AND A.PUR_CONT_MOD_ID = B.PUR_CONT_MOD_ID \n"); sql.append(" AND C.PAYREQ_ID = B.PAYREQ_ID \n"); sql.append(" AND C.TMPSLIP_ID = "+tmpslipID+" \n"); persistent_c.setStatement(sql.toString()); System.out.println(sql.toString()); rowSet = persistent_c.query(); if(rowSet.size()>0){ vo = RowSetUtility.getValueObject(rowSet.getRow(0)); } }catch(Exception e){ WAFLogger.error("SQL : " + search.getStatement()); WAFLogger.error(e); }finally{ if( vo == null) vo = new ValueObject(); } return vo; } /* * =========================================================================================== * A. 구매 선급금 증빙 작성 * =========================================================================================== */ public void doBizBuyPre(Connection con, OutputStream outputStream, String tmpslipID, HttpServletRequest request) { WAFLogger.debug("\n\t #################### 구매 선급금 시작"); // step 1 Document document = new Document(PageSize.A4, 25f, 25f, 35f, 10f); try { // step 2 PdfWriter writer = PdfWriter.getInstance(document, outputStream); // step 3 document.open(); BaseFont bfKorean = BaseFont.createFont("HYGoThic-Medium", "UniKS-UCS2-H", BaseFont.NOT_EMBEDDED); Font FontTitle = new Font(bfKorean, 8, Font.NORMAL); FontTitle.setColor(borderColor); Font FontData = new Font(bfKorean, 4.8f, Font.NORMAL); Font FontTitle2 = new Font(bfKorean, 20, Font.BOLD); PdfPTable table = null; PdfPCell cell = null; /* * 정보 검색 시작 --------------------------------------------- */ ValueObject params = new ValueObject(); HandlerStorage storage = new HandlerStorage(); storage.setParams(params); ValueObject listRowSet = null; /* * 정보 검색 시작 --------------------------------------------- */ listRowSet = getBuyPreList(con, tmpslipID); // 정보 검색 끝 --------------------------------------------- /* * =========================================================================================== * 제목 생성 * =========================================================================================== */ makeTitle_1(document, FontTitle, FontTitle2, request); //본문생성 setBorder(border, true, true, true, true); //1행 PdfPTable table11 = new PdfPTable(6); table11.setWidthPercentage(100); table11.setSpacingBefore(7f); table11.setSpacingAfter(7f); float[] table11Width = {15f,3f,27f,3f,27f,30f}; table11.setWidths(table11Width); // 1행 PT_addCell(table11, new String [] { "계약번호" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("ORD_DOC_NO"), FontTitle, border,Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "작성일자" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REQ_DATE"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "현장코드" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_CD"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f,false); PT_addCell(table11, new String [] { "통화" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CURRENCY_GB"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "현장명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 5, 20f ,false); PT_addCell(table11, new String [] { "계약명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CST_DOC_NAME"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 5, 20f ,false); PT_addCell(table11, new String [] { "계약업체명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CORP_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "대표이사" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REP_NAME"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "총계약금액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("ORD_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "선급금액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("PAYED_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "선급공급가" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_REQ_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "선급부가세" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_PAYED_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "지급구분" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPOSIT_GB"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "신청선급금" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REMAINDER_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "신청선급공급가" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("BEF_ACMP_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "신청선급부가세" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_ACMP_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); document.add(table11); } catch (DocumentException de) { WAFLogger.debug("de.getMessage() = " + de.getMessage()); } catch (IOException ioe) { WAFLogger.debug("ioe.getMessage() = " + ioe.getMessage()); } catch (Exception e) { WAFLogger.debug("[Exception] ... " + e); } // step 5 document.close(); WAFLogger.debug("\n\t #################### "+ strFileName +" 생성완료"); } public void doBizBuyPre1(Connection con, OutputStream outputStream, String tmpslipID, HttpServletRequest request) { WAFLogger.debug("\n\t #################### 구매 대금지급생성 시작"); // step 1 Document document = new Document(PageSize.A4, 25f, 25f, 35f, 10f); try { // step 2 PdfWriter writer = PdfWriter.getInstance(document, outputStream); // step 3 document.open(); BaseFont bfKorean = BaseFont.createFont("HYGoThic-Medium", "UniKS-UCS2-H", BaseFont.NOT_EMBEDDED); Font FontTitle = new Font(bfKorean, 8, Font.NORMAL); FontTitle.setColor(borderColor); Font FontData = new Font(bfKorean, 4.8f, Font.NORMAL); Font FontTitle2 = new Font(bfKorean, 20, Font.BOLD); PdfPTable table = null; PdfPCell cell = null; /* * 정보 검색 시작 --------------------------------------------- */ ValueObject params = new ValueObject(); HandlerStorage storage = new HandlerStorage(); storage.setParams(params); ValueObject listRowSet = null; /* * 정보 검색 시작 --------------------------------------------- */ listRowSet = getPayReqList11(con, tmpslipID); // 정보 검색 끝 --------------------------------------------- /* * =========================================================================================== * 제목 생성 * =========================================================================================== */ makeTitle(document, FontTitle, FontTitle2, request); //본문생성 setBorder(border, true, true, true, true); //1행 PdfPTable table11 = new PdfPTable(4); table11.setWidthPercentage(100); table11.setSpacingBefore(7f); table11.setSpacingAfter(7f); float[] table11Width = {15f,40f,15f,15f}; table11.setWidths(table11Width); // 1행 PT_addCell(table11, new String [] { "현장" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " + "(" + listRowSet.get("DEPT_CD") + ")" + listRowSet.get("DEPT_NM") , FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 3, 30f ,false); PT_addCell(table11, new String [] { "발주처" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " +listRowSet.get("DEALRER_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 3, 30f ,false); PT_addCell(table11, new String [] { "계약번호" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " +listRowSet.get("CON_DOC_NO"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f,false); PT_addCell(table11, new String [] { "계약일자" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " +listRowSet.get("CON_DATE"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f,false); PT_addCell(table11, new String [] { "계약명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " +listRowSet.get("BUILD_NAME"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 3, 30f ,false); PT_addCell(table11, new String [] { "원도급공사명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " +listRowSet.get("UND_CON_NAME"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 3, 30f,false); PT_addCell(table11, new String [] { "하도급공사명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " +listRowSet.get("SUB_UND_CON_NAME"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 3, 30f,false); PT_addCell(table11, new String [] { "공사장소" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " +listRowSet.get("WORK_PLACE"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 3, 30f ,false); PT_addCell(table11, new String [] { "공사기간" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " +listRowSet.get("WORK_DATE"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 3, 30f ,false); PT_addCell(table11, new String [] { "계약금액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 90f ,false); PdfPTable table21 = new PdfPTable(4); float[] table21Width = {13f,25f,5f,25f}; table21.setWidths(table21Width); PdfPCell permission = new PdfPCell(table21); setBorder(border, false, false, false, false); PT_addCell(table21, new String [] { "합 계 :" }, FontTitle, border, Element.ALIGN_MIDDLE, Element.ALIGN_MIDDLE, 1, 30f ,false); if(listRowSet.get("con_amt").equals("0")){ PT_addCell(table21, "일금" + PCMSUtil.toHangule_decimal("0"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("con_amt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); }else{ PT_addCell(table21, "일금" + PCMSUtil.toHangule_decimal(PCMSUtil.convertFloor(listRowSet.getDouble("con_amt"), 0).toString()), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21,"(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("con_amt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); } PT_addCell(table21, new String [] { "공급가 :" }, FontTitle, border, Element.ALIGN_MIDDLE, Element.ALIGN_MIDDLE, 1, 30f ,false); if(listRowSet.get("con_supply_amt").equals("0")){ PT_addCell(table21, "일금" + PCMSUtil.toHangule_decimal("0"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("con_supply_amt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); }else{ PT_addCell(table21, "일금" + PCMSUtil.toHangule_decimal(PCMSUtil.convertFloor(listRowSet.getDouble("con_supply_amt"), 0).toString()), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("con_supply_amt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); } PT_addCell(table21, new String [] { "- 과세 :" }, FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); if(listRowSet.get("con_supply_tamt").equals("0")){ PT_addCell(table21, "일금" + PCMSUtil.toHangule_decimal("0"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("con_supply_tamt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); }else{ PT_addCell(table21, "일금" + PCMSUtil.toHangule_decimal(PCMSUtil.convertFloor(listRowSet.getDouble("con_supply_tamt"), 0).toString()), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("con_supply_tamt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); } PT_addCell(table21, new String [] { "- 면세 :" }, FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); if(listRowSet.get("con_supply_namt").equals("0")){ PT_addCell(table21, "일금" + PCMSUtil.toHangule_decimal("0"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("con_supply_namt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); }else{ PT_addCell(table21, "일금" + PCMSUtil.toHangule_decimal(PCMSUtil.convertFloor(listRowSet.getDouble("con_supply_namt"), 0).toString()), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("con_supply_namt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); } PT_addCell(table21, new String [] { "부가세 :" }, FontTitle, border, Element.ALIGN_MIDDLE, Element.ALIGN_MIDDLE, 1, 30f ,false); if(listRowSet.get("con_surtax_amt").equals("0")){ PT_addCell(table21, "일금" + PCMSUtil.toHangule_decimal("0") + listRowSet.get("con_cur_won"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("con_surtax_amt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); }else{ PT_addCell(table21, "일금" + PCMSUtil.toHangule_decimal(PCMSUtil.convertFloor(listRowSet.getDouble("con_surtax_amt"), 0).toString()) , FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table21, "(" + "￦"+ PCMSUtil.convertFloor(listRowSet.getDouble("con_surtax_amt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); } permission.setColspan(3); table11.addCell(permission); setBorder(border, true, true, true, true); PT_addCell(table11, new String [] { "선급금" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 90f ,false); PdfPTable table31 = new PdfPTable(4); float[] table31Width = {13f,25f,5f,25f}; table31.setWidths(table31Width); PdfPCell permission2 = new PdfPCell(table31); setBorder(border, false, false, false, false); PT_addCell(table31, new String [] { "합 계 :" }, FontTitle, border, Element.ALIGN_MIDDLE, Element.ALIGN_MIDDLE, 1, 30f ,false); if(listRowSet.get("req_amt").equals("0")){ PT_addCell(table31, "일금" + PCMSUtil.toHangule_decimal("0"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table31, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table31, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("req_amt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); }else{ PT_addCell(table31, "일금" + PCMSUtil.toHangule_decimal(PCMSUtil.convertFloor(listRowSet.getDouble("req_amt"), 0).toString()) , FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table31, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table31, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("req_amt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); } PT_addCell(table31, new String [] { "공급가 :" }, FontTitle, border, Element.ALIGN_MIDDLE, Element.ALIGN_MIDDLE, 1, 30f ,false); if(listRowSet.get("supply_amt").equals("0")){ PT_addCell(table31, "일금" + PCMSUtil.toHangule_decimal("0"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table31, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table31, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("supply_amt"), 0)+ "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); }else{ PT_addCell(table31, "일금" + PCMSUtil.toHangule_decimal(PCMSUtil.convertFloor(listRowSet.getDouble("supply_amt"), 0).toString()) , FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table31, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table31, "(" + "￦" +PCMSUtil.convertFloor(listRowSet.getDouble("supply_amt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); } PT_addCell(table31, new String [] { "부가세 :" }, FontTitle, border, Element.ALIGN_MIDDLE, Element.ALIGN_MIDDLE, 1, 30f,false); if(listRowSet.get("surtax_amt").equals("0")){ PT_addCell(table31, "일금" + PCMSUtil.toHangule_decimal("0"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table31, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table31, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("surtax_amt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); }else{ PT_addCell(table31, "일금" + PCMSUtil.toHangule_decimal(PCMSUtil.convertFloor(listRowSet.getDouble("surtax_amt"), 0).toString()), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table31, new String [] { "원정" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table31, "(" + "￦" + PCMSUtil.convertFloor(listRowSet.getDouble("surtax_amt"), 0) + "원정" + ")", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false); } permission2.setColspan(3); table11.addCell(permission2); setBorder(border, true, true, true, true); PT_addCell(table11, new String [] { "지급조건" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " + listRowSet.get("PAY_COND_GB_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 3, 30f ,false); PT_addCell(table11, new String [] { "지급조건기술" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " + listRowSet.get("PAY_CONTENT"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 3, 30f ,false); PT_addCell(table11, new String [] { "지체상금" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " + listRowSet.get("DELAY_RATE"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 3, 30f ,false); PT_addCell(table11, new String [] { "업체명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 30f ,false); PT_addCell(table11, " " + listRowSet.get("CORP_KOR"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 3, 30f ,false); PT_addCell(table11, new String [] { "특이사항" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_TOP, 1, 100f ,false); PT_addCell(table11, " " + listRowSet.get("CON_SPE_TXT"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 3, 100f ,false); /* */ document.add(table11); } catch (DocumentException de) { WAFLogger.debug("de.getMessage() = " + de.getMessage()); } catch (IOException ioe) { WAFLogger.debug("ioe.getMessage() = " + ioe.getMessage()); } catch (Exception e) { WAFLogger.debug("[Exception] ... " + e); } // step 5 document.close(); WAFLogger.debug("\n\t #################### "+ strFileName +" 생성완료"); } /* * 구매 선급금 데이터 조회 */ public ValueObject getBuyPreList(Connection con, String tmpslipID ){ Search search = new SearchImpl(); ValueObject vo = null; RowSet rowSet = new RowSetImpl(); StringBuffer sql = new StringBuffer(); Persistent persistent_c = null; try{ persistent_c = new PersistentImpl(con); sql.append("SELECT B.PREPAY_PROC_GB -- 대금신청상태 \n"); sql.append(" ,B.PUR_CONT_ID -- 발주계약ID \n"); sql.append(" ,B.PREPAY_ID as PAYREQ_ID -- 지급신청ID \n"); sql.append(" ,TO_CHAR(B.PREPAY_DATE, 'YYYY-MM-DD') REQ_DATE -- 신청서작성일자 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( A.ORD_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) AS ORD_AMT -- 발주계약금액 \n"); sql.append(" ,F_GET_PUR_STATUS('1', 'PUR_PAY_ACMP_GB') || '(' || TO_NUMBER(B.PREPAY_NO) || '차)' DEPOSIT_GB -- 지급구분이름 \n"); sql.append(" ,'1' as DEPOSIT_CD -- 지급구분 \n"); sql.append(" ,B.PREPAY_NO as DEPOSIT_SEQ -- 지급차수 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.PREPAY_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as PAYED_AMT --선급금액 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.PREPAY_SUPPLY_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as CUR_REQ_AMT --선급공급가 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.PREPAY_SURTAX_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as CUR_PAYED_AMT --선급부가세 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.REQ_PREPAY_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as REMAINDER_AMT -- 신청선급금합계 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.REQ_PREPAY_SUPPLY_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as BEF_ACMP_AMT --신청 선급금 공급가액 \n"); sql.append(" ,F_GET_D_CURRENCY( NVL( B.REQ_PREPAY_SURTAX_AMT, 0 ) , F_GET_CURRENCY_DIGIT( NVL( A.CURRENCY_GB, 'KRW' ))) as CUR_ACMP_AMT -- 신청 선급금 부가세 \n"); sql.append(" ,A.ORD_DOC_NO AS ORD_DOC_NO -- 발주계약번호 \n"); sql.append(" ,A.CST_DOC_NAME AS CST_DOC_NAME -- 계약명 \n"); sql.append(" ,GET_CORP_NM(C.DEALR_CD) AS CORP_NM --계약업체명 \n"); sql.append(" ,(SELECT REP_NAME FROM PUR9000T_V D WHERE D.CORP_ID = C.DEALR_CD ) REP_NAME -- 업체대표이사 \n"); sql.append(" ,(SELECT CORP_REG_NO FROM PUR9000T_V D WHERE D.CORP_ID = C.DEALR_CD ) CORP_REG_NO -- 사업자번호 \n"); sql.append(" ,A.DEPT_NAME AS DEPT_NM -- 현장명 \n"); sql.append(" ,C.DEPT_CD AS DEPT_CD -- 현장코드 \n"); sql.append(" ,A.CURRENCY_GB -- 통화구분 \n"); sql.append(" ,(SELECT CHG_CODE10 FROM EBID_COM911T WHERE DETAILCD = A.GUA_GB AND BASECD = 'PROOF_CD') VAT_STATUS \n"); sql.append("FROM PUR1000T A \n"); sql.append(" ,PUR1030T B \n"); sql.append(" ,PUR1040T C \n"); sql.append("WHERE 1 = 1 \n"); sql.append("AND A.PUR_CONT_ID = B.PUR_CONT_ID \n"); sql.append("AND B.PREPAY_ID = C.PREPAY_ID \n"); sql.append("AND C.TMPSLIP_ID = "+tmpslipID+" \n"); persistent_c.setStatement(sql.toString()); System.out.println(sql.toString()); rowSet = persistent_c.query(); if(rowSet.size()>0){ vo = RowSetUtility.getValueObject(rowSet.getRow(0)); } }catch(Exception e){ WAFLogger.error("SQL : " + search.getStatement()); WAFLogger.error(e); }finally{ if( vo == null) vo = new ValueObject(); } return vo; } public ValueObject getPayReqList11(Connection con, String tmpslipID ){ ValueObject vo = null; RowSet rowSet = new RowSetImpl(); StringBuffer sql = new StringBuffer(); Persistent pSelect = null; try{ pSelect = new PersistentImpl(con); sql.append(" SELECT MAIN.TMPSLIP_ID \n"); sql.append(" , TO_CHAR(MAIN.ENTER_DT, 'YYYY-MM-DD') PROOFDATE \n"); sql.append(" , MAIN.DEPT_CD \n"); sql.append(" , CONTRACT.DEALER_NM AS DEALRER_NM \n"); sql.append(" , CONTRACT.DEPT_NAME AS DEPT_NM \n"); sql.append(" , CONTRACT.ORD_DOC_NO AS CON_DOC_NO \n"); sql.append(" , TO_CHAR(CONTRACT.CON_IN_DATE,'YYYY-MM-DD') AS CON_DATE \n"); sql.append(" , CONTRACT.CST_DOC_NAME AS BUILD_NAME \n"); sql.append(" , CONTRACT.DEALER_NM AS UND_CON_NAME \n"); sql.append(" , '' AS SUB_UND_CON_NAME \n"); sql.append(" , CONTRACT.LEAD_PLACE AS WORK_PLACE \n"); sql.append(" , CONTRACT.ORD_SUPPLY_AMT AS con_supply_amt \n"); sql.append(" , CONTRACT.ORD_SUPPLY_AMT AS con_supply_tamt \n"); sql.append(" , 0 AS con_supply_namt \n"); sql.append(" , CONTRACT.ORD_SURTAX_AMT AS CON_SURTAX_AMT \n"); sql.append(" , CONTRACT.ORD_AMT AS CON_AMT \n"); sql.append(" , 0 AS LABOR_AMT \n"); sql.append(" , PREPAY.REQ_PREPAY_AMT AS PREPAY_SUPPLY_AMT \n"); sql.append(" , PREPAY.REQ_PREPAY_SUPPLY_AMT AS PREPAY_SUPPLY_TAMT \n"); sql.append(" , 0 AS PREPAY_SUPPLY_NAMT \n"); sql.append(" , PREPAY.REQ_PREPAY_SURTAX_AMT AS PREPAY_SURTAX_AMT \n"); sql.append(" , CONTRACT.PREPAY_AMT AS PREPAY_AMT \n"); sql.append(" , PAY_TYPE.CHG_CODE01 AS PAY_COND_GB_NM \n"); sql.append(" , CONTRACT.PAY_CONTENT AS PAY_CONTENT \n"); sql.append(" , (TO_CHAR(CONTRACT.ORD_START_DATE,'YYYY-MM-DD') || ' ~ ' || TO_CHAR(CONTRACT.ORD_END_DATE,'YYYY-MM-DD') ) WORK_DATE \n"); sql.append(" , CONTRACT.CON_GUAR_AMT_RATE AS CON_EST_GUAR_RATE \n"); sql.append(" , CONTRACT.CON_GUAR_AMT AS CON_EST_GUAR_AMT \n"); sql.append(" , CONTRACT.CON_GUAR_TERM AS CON_GUAR_TERM \n"); sql.append(" , CONTRACT.DEF_GUAR_AMT_RATE AS DEF_EST_GUAR_RATE \n"); sql.append(" , CONTRACT.DEF_GUAR_AMT \n"); sql.append(" , CONTRACT.DEF_GUAR_TERMS AS DEF_EST_TERM \n"); sql.append(" , '' AS LABOR_GUAR_JOIN_AMT_GB \n"); sql.append(" , CONTRACT.CON_DISPLAY_TXT AS CON_SPE_TXT \n"); sql.append(" , CONTRACT.DEL_RATE_GB AS DELAY_RATE \n"); sql.append(" , CUR_CD.CHG_CODE02 as CON_CUR_NAME \n"); sql.append(" , CUR_CD.CHG_CODE06 as CON_CUR_WON \n"); sql.append(" , CUR_CD.CHG_CODE01 as CON_CUR_DIGIT \n"); sql.append(" , MAIN.DCERTI_NO \n"); sql.append(" , SUBVENDOR.MEMBER_NAME AS CORP_KOR \n"); sql.append(" , SUBVENDOR.CORP_ID \n"); sql.append(" , 'PREPAY' AS PREREQTFLG \n"); sql.append(" , 0 AS ACMP_NO \n"); sql.append(" , MAIN.PROOF_CD AS PROOF_CLASS \n"); sql.append(" , MAIN.ORD_DESC AS ORDACCDESC \n"); sql.append(" , MAIN.CURRENCY_GB AS CON_CUR_CD \n"); sql.append(" , MAIN.MAT_SUPPLY_AMT SUPPLY_AMT \n"); sql.append(" , MAIN.MAT_SURTAX_AMT SURTAX_AMT \n"); sql.append(" , MAIN.MAT_SUPPLY_AMT + MAIN.MAT_SURTAX_AMT REQ_AMT \n"); sql.append(" , CONTRACT.CON_CHARGE_ID \n"); sql.append(" , CONTRACT.CON_CHARGE_NAME \n"); sql.append(" , MAIN.DEALR_CD \n"); sql.append(" , MAIN.PAYITEM \n"); sql.append(" , MAIN.COSTCODE \n"); sql.append(" , MAIN.COSTTYPE \n"); sql.append(" , MAIN.TMPNATFLG AS ACC_CLASS \n"); sql.append(" , MAIN.PAY_GROUP \n"); sql.append(" , MAIN.PAYMENT_TERMS \n"); sql.append(" , MAIN.TMPSLIP_DEPT \n"); sql.append(" , MAIN.TMPSLIP_DT \n"); sql.append(" , MAIN.TMPSLIP_NO \n"); sql.append(" , MAIN.TMPSLIP_YN \n"); sql.append(" , MAIN.SLIP_YN \n"); sql.append(" , NULL AS ACMP_ID \n"); sql.append(" , MAIN.PREPAY_ID \n"); sql.append(" , PREPAY.CORP_ID AS CON_CORP_ID \n"); sql.append(" , CONTRACT.PUR_CONT_ID AS SUB_CONT_ID \n"); sql.append(" FROM PUR1040T MAIN \n"); sql.append(" LEFT OUTER JOIN PUR1030T PREPAY \n"); sql.append(" ON MAIN.PAYREQ_ID = PREPAY.PREPAY_ID \n"); sql.append(" LEFT OUTER JOIN CONT_PUR_SUPP SUBVENDOR \n"); sql.append(" --ON SUBVENDOR.MAIN_CORP = 'Y' \n"); sql.append(" ON PREPAY.CORP_ID = SUBVENDOR.CORP_ID \n"); sql.append(" AND PREPAY.PUR_CONT_MOD_ID = SUBVENDOR.PUR_CONT_MOD_ID \n"); sql.append(" LEFT OUTER JOIN PUR2000T CONTRACT \n"); sql.append(" ON PREPAY.PUR_CONT_MOD_ID = CONTRACT.PUR_CONT_MOD_ID \n"); sql.append(" LEFT OUTER JOIN EBID_COM911T CON_KIND \n"); sql.append(" ON CON_KIND.BASECD = 'SUB_CON_KIND' \n"); sql.append(" AND CONTRACT.CON_GB = CON_KIND.DETAILCD \n"); sql.append(" LEFT OUTER JOIN EBID_COM911T PAY_TYPE \n"); sql.append(" ON PAY_TYPE.BASECD = 'SUB_ACMP_PAY_TYPE' \n"); sql.append(" AND CONTRACT.PAY_COND_GB = PAY_TYPE.DETAILCD \n"); sql.append(" LEFT OUTER JOIN EBID_COM911T CUR_CD \n"); sql.append(" ON CUR_CD.BASECD = '911' \n"); sql.append(" AND CONTRACT.CURRENCY_GB = CUR_CD.DETAILCD \n"); sql.append(" WHERE PREPAY_GB = '1' \n"); sql.append(" AND TMPSLIP_ID = "+tmpslipID+" \n"); sql.append(" ORDER BY PROOFDATE desc, DEPT_NAME, CON_DOC_NO, CORP_KOR \n"); System.out.println(sql.toString()); pSelect.setStatement(sql.toString()); rowSet = pSelect.query(); if(rowSet.size()>0){ vo = RowSetUtility.getValueObject(rowSet.getRow(0)); } }catch(Exception e){ WAFLogger.error("SQL : " + sql.toString()); WAFLogger.error(e); }finally{ if( vo == null) vo = new ValueObject(); } return vo; } //구매 대금 반려처리 public void doBizPayReqRtn(Connection con, OutputStream outputStream, String tmpslipID, HttpServletRequest request) { WAFLogger.debug("\n\t #################### 구매 대금지급 반려 처리 시작"); // step 1 Document document = new Document(PageSize.A4, 25f, 25f, 35f, 10f); try { // step 2 PdfWriter writer = PdfWriter.getInstance(document, outputStream); // step 3 document.open(); BaseFont bfKorean = BaseFont.createFont("HYGoThic-Medium", "UniKS-UCS2-H", BaseFont.NOT_EMBEDDED); Font FontTitle = new Font(bfKorean, 8, Font.NORMAL); FontTitle.setColor(borderColor); Font FontData = new Font(bfKorean, 4.8f, Font.NORMAL); Font FontTitle2 = new Font(bfKorean, 20, Font.BOLD); PdfPTable table = null; PdfPCell cell = null; /* * 정보 검색 시작 --------------------------------------------- */ ValueObject params = new ValueObject(); HandlerStorage storage = new HandlerStorage(); storage.setParams(params); ValueObject listRowSet = null; /* * 정보 검색 시작 --------------------------------------------- */ listRowSet = getPayReqList1(con, tmpslipID); // 정보 검색 끝 --------------------------------------------- /* * =========================================================================================== * 제목 생성 * =========================================================================================== */ makeTitle_2(document, FontTitle, FontTitle2, request); //본문생성 setBorder(border, true, true, true, true); //1행 PdfPTable table11 = new PdfPTable(6); table11.setWidthPercentage(100); table11.setSpacingBefore(7f); table11.setSpacingAfter(7f); float[] table11Width = {15f,3f,27f,3f,27f,30f}; table11.setWidths(table11Width); // 1행 PT_addCell(table11, new String [] { "계약번호" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("ORD_DOC_NO"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "작성일자" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REQ_DATE"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f,false); /* PT_addCell(table11, new String [] { "작성자" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("REQ_CHARGE_NAME"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "협조부서" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("COOP_DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f,false);*/ PT_addCell(table11, new String [] { "현장코드" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_CD"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f,false); PT_addCell(table11, new String [] { "통화" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CURRENCY_GB"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "현장명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 5, 20f ,false); /*PT_addCell(table11, new String [] { "현장명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "현장코드" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_CD"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false);*/ PT_addCell(table11, new String [] { "계약명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CST_DOC_NAME"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 5, 20f ,false); PT_addCell(table11, new String [] { "계약업체명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CORP_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "대표이사" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REP_NAME"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "총계약금액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("ORD_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "선급금액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("PREPAY_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "지급구분" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPOSIT_GB"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "기선급공제액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("PREPAY_ACMP_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "지급사유" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPOSIT_RESN"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "선급잔액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("PREPAY_RMDR"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "기지불액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); //PT_addCell(table11, listRowSet.get("PAYED_AMT")+" ("+listRowSet.get("PAYED_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, listRowSet.get("PAYED_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "전기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("BEF_ACMP_AMT")+" ("+listRowSet.get("BEF_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "금회청구액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); //PT_addCell(table11, listRowSet.get("CUR_REQ_AMT")+" ("+listRowSet.get("CUR_REQ_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, listRowSet.get("CUR_REQ_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "금회기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_ACMP_AMT")+" ("+listRowSet.get("CUR_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "금회포함지불액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); //PT_addCell(table11, listRowSet.get("CUR_PAYED_AMT")+" ("+listRowSet.get("CUR_PAYED_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, listRowSet.get("CUR_PAYED_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "금회포함기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_BEF_ACMP_AMT")+" ("+listRowSet.get("CUR_BEF_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "잔액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("REMAINDER_AMT")+" ("+listRowSet.get("REMAINDER_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "미기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REMAINDER_ACMP_AMT")+" ("+listRowSet.get("REMAINDER_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "특기사항" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 200f ,true); PT_addCell(table11, listRowSet.get("RE_MARKS"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_TOP, 5, 200f ,false); PT_addCell(table11, new String [] { "첨부서류" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 120f ,true); PdfPTable table21 = new PdfPTable(4); float[] table21Width = {3f,27,3,27f}; table21.setWidths(table21Width); PdfPCell permission = new PdfPCell(table21); PT_addCell(table21, listRowSet.get("DOC_PAYREQ"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "대금청구서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_COMPLETE"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "설치완료확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_GUAR_CONST"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "계약이행 보증보험 증권" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_TESTRUN"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "시운전완료확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_MRR"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "지급이행 보증보험 증권" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_INSPECTION_REPORT"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "Inspection Report" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_GUAR_AS"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "하자이행 보증보험 증권" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_SHIP"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "선적서류(B/L, Packing List)" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_ITEMINPUTCONFIRM"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "원자재입고확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_FINAL_DOCUMENTS"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "Final Documents 제출 확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_CONFIRM"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "MRR" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_CONST_COPY"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "계약서 사본" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_WORKQA"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "거래명세서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_ETC"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "기타" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_MC"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); permission.setColspan(4); table11.addCell(permission); PT_addCell(table11, "", FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 120f,false); document.add(table11); } catch (DocumentException de) { WAFLogger.debug("de.getMessage() = " + de.getMessage()); } catch (IOException ioe) { WAFLogger.debug("ioe.getMessage() = " + ioe.getMessage()); } catch (Exception e) { WAFLogger.debug("[Exception] ... " + e); } // step 5 document.close(); WAFLogger.debug("\n\t #################### "+ strFileName +" 생성완료"); } public void doBizBuyPreRtn(Connection con, OutputStream outputStream, String tmpslipID, HttpServletRequest request) { WAFLogger.debug("\n\t #################### 구매 선급금 시작"); // step 1 Document document = new Document(PageSize.A4, 25f, 25f, 35f, 10f); try { // step 2 PdfWriter writer = PdfWriter.getInstance(document, outputStream); // step 3 document.open(); BaseFont bfKorean = BaseFont.createFont("HYGoThic-Medium", "UniKS-UCS2-H", BaseFont.NOT_EMBEDDED); Font FontTitle = new Font(bfKorean, 8, Font.NORMAL); FontTitle.setColor(borderColor); Font FontData = new Font(bfKorean, 4.8f, Font.NORMAL); Font FontTitle2 = new Font(bfKorean, 20, Font.BOLD); PdfPTable table = null; PdfPCell cell = null; /* * 정보 검색 시작 --------------------------------------------- */ ValueObject params = new ValueObject(); HandlerStorage storage = new HandlerStorage(); storage.setParams(params); ValueObject listRowSet = null; /* * 정보 검색 시작 --------------------------------------------- */ listRowSet = getBuyPreList(con, tmpslipID); // 정보 검색 끝 --------------------------------------------- /* * =========================================================================================== * 제목 생성 * =========================================================================================== */ makeTitle_1(document, FontTitle, FontTitle2, request); //본문생성 setBorder(border, true, true, true, true); //1행 PdfPTable table11 = new PdfPTable(6); table11.setWidthPercentage(100); table11.setSpacingBefore(7f); table11.setSpacingAfter(7f); float[] table11Width = {15f,3f,27f,3f,27f,30f}; table11.setWidths(table11Width); // 1행 PT_addCell(table11, new String [] { "계약번호" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("ORD_DOC_NO"), FontTitle, border,Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "작성일자" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REQ_DATE"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f,false); // PT_addCell(table11, new String [] { "작성자" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); // PT_addCell(table11, listRowSet.get("REQ_CHARGE_NAME"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); // PT_addCell(table11, new String [] { "협조부서" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); // PT_addCell(table11, listRowSet.get("COOP_DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "현장코드" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_CD"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f,false); PT_addCell(table11, new String [] { "통화" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CURRENCY_GB"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "현장명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 5, 20f ,false); /*PT_addCell(table11, new String [] { "현장명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "현장코드" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("DEPT_CD"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false);*/ PT_addCell(table11, new String [] { "계약명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CST_DOC_NAME"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 5, 20f ,false); PT_addCell(table11, new String [] { "계약업체명" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CORP_NM"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "대표이사" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REP_NAME"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "총계약금액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("ORD_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "선급금액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("PAYED_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "선급공급가" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_REQ_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "선급부가세" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_PAYED_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "지급구분" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("DEPOSIT_GB"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "신청선급금" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REMAINDER_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "신청선급공급가" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("BEF_ACMP_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "신청선급부가세" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_ACMP_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); // PT_addCell(table11, new String [] { "기선급공제액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); // PT_addCell(table11, listRowSet.get("PREPAY_ACMP_AMT"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); // PT_addCell(table11, new String [] { "지급사유" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); // PT_addCell(table11, listRowSet.get("DEPOSIT_RESN"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 2, 20f ,false); // PT_addCell(table11, new String [] { "선급잔액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); // PT_addCell(table11, listRowSet.get("PREPAY_RMDR"), FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); // PT_addCell(table11, new String [] { "기지불액" }, FontTitle, border, // Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); // PT_addCell(table11, listRowSet.get("PAYED_AMT")+" ("+listRowSet.get("PAYED_PERCENT")+")%", FontTitle, border, // Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); // PT_addCell(table11, new String [] { "전기성고" }, FontTitle, border, // Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); // PT_addCell(table11, listRowSet.get("BEF_ACMP_AMT")+" ("+listRowSet.get("BEF_ACMP_PERCENT")+")%", FontTitle, border, // Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); /* PT_addCell(table11, new String [] { "금회청구액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_REQ_AMT")+" ("+listRowSet.get("CUR_REQ_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "금회기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_ACMP_AMT")+" ("+listRowSet.get("CUR_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "금회포함지불액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_PAYED_AMT")+" ("+listRowSet.get("CUR_PAYED_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "금회포함기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("CUR_BEF_ACMP_AMT")+" ("+listRowSet.get("CUR_BEF_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "잔액" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,true); PT_addCell(table11, listRowSet.get("REMAINDER_AMT")+" ("+listRowSet.get("REMAINDER_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 2, 20f ,false); PT_addCell(table11, new String [] { "미기성고" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 2, 20f ,true); PT_addCell(table11, listRowSet.get("REMAINDER_ACMP_AMT")+" ("+listRowSet.get("REMAINDER_ACMP_PERCENT")+")%", FontTitle, border, Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table11, new String [] { "특기사항" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 200f ,true); PT_addCell(table11, listRowSet.get("RE_MARKS"), FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_TOP, 5, 200f ,false); PT_addCell(table11, new String [] { "첨부서류" }, FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 120f ,true); PdfPTable table21 = new PdfPTable(4); float[] table21Width = {3f,27,3,27f}; table21.setWidths(table21Width); PdfPCell permission = new PdfPCell(table21); PT_addCell(table21, listRowSet.get("DOC_PAYREQ"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "대금청구서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_COMPLETE"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "설치완료확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_GUAR_CONST"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "계약이행 보증보험 증권" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_TESTRUN"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "시운전완료확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_MRR"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "지급이행 보증보험 증권" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_INSPECTION_REPORT"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "Inspection Report" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_GUAR_AS"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "하자이행 보증보험 증권" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_SHIP"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "선적서류(B/L, Packing List)" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_ITEMINPUTCONFIRM"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "원자재입고확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_FINAL_DOCUMENTS"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "Final Documents 제출 확인서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_CONFIRM"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "MRR" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_CONST_COPY"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "계약서 사본" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_WORKQA"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f,false); PT_addCell(table21, new String [] { "거래명세서" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_ETC"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, new String [] { "기타" }, FontTitle, border, Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 20f ,false); PT_addCell(table21, listRowSet.get("DOC_MC"), FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 20f ,false); permission.setColspan(4); table11.addCell(permission); PT_addCell(table11, "", FontTitle, border, Element.ALIGN_CENTER, Element.ALIGN_MIDDLE, 1, 120f,false); */ document.add(table11); } catch (DocumentException de) { WAFLogger.debug("de.getMessage() = " + de.getMessage()); } catch (IOException ioe) { WAFLogger.debug("ioe.getMessage() = " + ioe.getMessage()); } catch (Exception e) { WAFLogger.debug("[Exception] ... " + e); } // step 5 document.close(); WAFLogger.debug("\n\t #################### "+ strFileName +" 생성완료"); } }