ebid/java/kr/co/udapsoft/common/commonSign/util/SACDOCreatePDF6.java

package kr.co.udapsoft.common.commonSign.util;

/*
 * 외주기성고 계산서 : 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 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.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;

import kr.co.udapsoft.common.util.PCMSUtil;
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;

public class SACDOCreatePDF6 {

	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, 12, 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);
			
			// 정보 검색 끝 ---------------------------------------------
			
			/*
			 * ===========================================================================================
			 * 제목 생성
			 * ===========================================================================================
			 */
			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")  , 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 +" 생성완료");
	}

	/*
	 * ===========================================================================================
	 * A. 타이틀
	 * ===========================================================================================
	 */
	
	/**
	 * @param args
	 */
	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, 9, 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(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);
            
            
            
            //2016.7.19 원정 listRowSet.get("CON_CUR_WON"), ￦ listRowSet.get("CON_CUR_NAME")
            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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON")}, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21,"(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" +  listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" + listRowSet.get("CON_CUR_NAME")+ 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" +  listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" +  listRowSet.get("CON_CUR_NAME") + 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"), FontTitle, border,
            			Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, new String [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21,  "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21,   "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON")}, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); 
            	PT_addCell(table31, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON")}, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); 
            	PT_addCell(table31, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); 
            	PT_addCell(table31, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); 
            	PT_addCell(table31, "(" + listRowSet.get("CON_CUR_NAME") +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 [] {listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); 
            	PT_addCell(table31, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] {listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); 
            	PT_addCell(table31, "(" + listRowSet.get("CON_CUR_NAME") + 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 +" 생성완료");
	}
	
	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);
		
		document.add(tbl_Title);
		
		
	}

	/*
	 * ===========================================================================================
	 * 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 MAIN.TMPSLIP_ID                                                                                                                              \n");
			sql.append("		                 , TO_CHAR(MAIN.PROOFDATE, '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.CON_DOC_NO                     AS CON_DOC_NO                                                                                        \n");
			sql.append("		                 , TO_CHAR(CONTRACT.CON_DATE,'YYYY-MM-DD') AS CON_DATE                                                                                        	\n");
			sql.append("		                 , CONTRACT.BUILD_NAME                     AS BUILD_NAME                                                                                        \n");
			sql.append("		                 , CONTRACT.UND_CON_NAME                   AS UND_CON_NAME                                                                                      \n");
			sql.append("		                 , CONTRACT.SUB_UND_CON_NAME               AS SUB_UND_CON_NAME                                                                                  \n");
			sql.append("		                 , CONTRACT.WORK_PLACE                     AS WORK_PLACE                                                                                        \n");
			sql.append("		                 , CONTRACT.CON_SUPPLY_AMT                 AS con_supply_amt                                                                                    \n");
			sql.append("		                 , CONTRACT.CON_SUPPLY_TAMT                 AS con_supply_tamt                                                                                    \n");
			sql.append("		                 , CONTRACT.CON_SUPPLY_NAMT                 AS con_supply_namt                                                                                    \n");
			sql.append("		                 , CONTRACT.CON_SURTAX_AMT                                                                                                                      \n");
			sql.append("		                 , CONTRACT.CON_AMT                                                                                                                             \n");
			sql.append("		                 , CONTRACT.LABOR_AMT                                                                                                                           \n");
			sql.append("		                 , CONTRACT.PREPAY_SUPPLY_AMT             AS PREPAY_SUPPLY_AMT                                                                                  \n");
			sql.append("		                 , CONTRACT.PREPAY_SUPPLY_TAMT            AS PREPAY_SUPPLY_TAMT                                                                                  \n");
			sql.append("		                 , CONTRACT.PREPAY_SUPPLY_NAMT            AS PREPAY_SUPPLY_NAMT                                                                                  \n");
			sql.append("		                 , CONTRACT.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.START_WORK_DATE,'YYYY-MM-DD') || ' ~ ' || TO_CHAR(CONTRACT.END_WORK_DATE,'YYYY-MM-DD') ) WORK_DATE                         \n");
			sql.append("		                 , CONTRACT.CON_EST_GUAR_RATE             AS CON_EST_GUAR_RATE                                                                                  \n");
			sql.append("		                 , CONTRACT.CON_EST_GUAR_AMT                                                                                                                    \n");
			sql.append("		                 , CONTRACT.CON_GUAR_TERM                AS CON_GUAR_TERM                                                                                       \n");
			sql.append("		                 , CONTRACT.DEF_EST_GUAR_RATE            AS DEF_EST_GUAR_RATE                                                                                   \n");
			sql.append("		                 , CONTRACT.DEF_GUAR_AMT                                                                                                                        \n");
			sql.append("		                 , CONTRACT.DEF_EST_TERM                 AS DEF_EST_TERM                                                                                        \n");
			sql.append("		                 , CONTRACT.LABOR_GUAR_JOIN_AMT_GB       AS LABOR_GUAR_JOIN_AMT_GB                                                                              \n");
			sql.append("		                 , CONTRACT.CON_SPE_TXT                  AS CON_SPE_TXT                                                                                         \n");
			sql.append("		                 , CONTRACT.DELAY_RATE        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.CORP_KOR        AS CORP_KOR                                                                                                        \n");
			sql.append("		                 , SUBVENDOR.CORP_ID                                                                                                                            \n");
			sql.append("		                 , MAIN.PREREQTFLG                                                                                                                              \n");
			sql.append("		                 , MAIN.ACMP_NO                                                                                                                                 \n");
			sql.append("		                 , MAIN.PROOF_CLASS                                                                                                                             \n");
			sql.append("		                 , MAIN.ORDACCDESC                                                                                                                              \n");
			sql.append("		                 , MAIN.CON_CUR_CD                                                                                                                              \n");
			sql.append("		                 , MAIN.SUPPLY_AMT                          SUPPLY_AMT                                                                                                    \n");
			sql.append("		                 , MAIN.SURTAX_AMT                          SURTAX_AMT                                                                                                    \n");
			sql.append("		                 , MAIN.SUPPLY_AMT + MAIN.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.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("		                 , MAIN.ACMP_ID                                                                                                                                 \n");
			sql.append("		                 , MAIN.PREPAY_ID                                                                                                                               \n");
			sql.append("		                 , PREPAY.CON_CORP_ID                                                                                                                           \n");
			sql.append("		                 , CONTRACT.SUB_CONT_ID                                                                                                                         \n");
			sql.append("		                  , CASE                                                                                                                                        \n");
			sql.append("		                        WHEN (SLIP.STATUS_CD = '1') AND (SLIP.RETURN_CD = 'Y') THEN '-1'                                                                        \n");
			sql.append("		                        ELSE SLIP.STATUS_CD                                                                                                                     \n");
			sql.append("		                      END                                      STATUS_CD                                                                                        \n");
			sql.append("		                                                                                                                                                                \n");
			sql.append("		              FROM SUB1050T            MAIN                                                                                                                     \n");
			sql.append("		                                                                                                                                                                \n");
			sql.append("		   LEFT OUTER JOIN SUB1030T            PREPAY                                                                                                                   \n");
			sql.append("		                ON MAIN.PREPAY_ID = PREPAY.PREPAY_ID                                                                                                            \n");
			sql.append("		                                                                                                                                                                \n");
			sql.append("		   LEFT OUTER JOIN SUB1020T         SUBVENDOR                                                                                                                  	\n");
			sql.append("		                ON SUBVENDOR.MAIN_CORP = 'Y'                                                                                                   					\n");
			sql.append("		               AND PREPAY.CON_CORP_ID = SUBVENDOR.CON_CORP_ID                                                                                                   \n");
			sql.append("		                                                                                                                                                                \n");
			sql.append("		   LEFT OUTER JOIN SUB1000T             CONTRACT                                                                                                                \n");
			sql.append("		                ON PREPAY.SUB_CONT_ID = CONTRACT.SUB_CONT_ID                                                                                                    \n");
			sql.append("		                                                                                                                                                                \n");
			sql.append("		   LEFT OUTER JOIN SAC01001            SLIP                                                                                                                     \n");
			sql.append("		                   ON MAIN.TMPSLIP_DEPT = SLIP.TMPSLIP_DEPT                                                                                                     \n");
			sql.append("		                  AND MAIN.TMPSLIP_DT     = SLIP.TMPSLIP_DT                                                                                                     \n");
			sql.append("		                  AND MAIN.TMPSLIP_NO      = SLIP.TMPSLIP_NO                                                                                                    \n");
			sql.append("		                                                                                                                                                                \n");
			sql.append("		   LEFT OUTER JOIN 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("		                                                                                                                                                                \n");
			sql.append("		   LEFT OUTER JOIN 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("		                                                                                                                                                                \n");
			sql.append("		   LEFT OUTER JOIN COM911T    CUR_CD                                                                                                                            \n");
			sql.append("		                  ON CUR_CD.BASECD = '911'                                                                                                                    	\n");
			sql.append("		                AND  CONTRACT.CON_CUR_CD = CUR_CD.DETAILCD                                                                                                      \n");
			sql.append("		                                                                                                                                                                \n");
			sql.append("		             WHERE PREREQTFLG     = 'PREPAY'                                                                                                                    \n");
			sql.append("		               AND TMPSLIP_ID 	  = "+tmpslipID+"                                                                                                               \n");
			sql.append("		             ORDER BY PROOFDATE desc, DEPT_NAME, CON_DOC_NO, CORP_KOR  																							\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 ){
		
		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.PROOFDATE, '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.CON_DOC_NO                     AS CON_DOC_NO                                                                                        \n");
			sql.append("		                 , TO_CHAR(CONTRACT.CON_DATE,'YYYY-MM-DD') AS CON_DATE                                                                                        	\n");
			sql.append("		                 , CONTRACT.BUILD_NAME                     AS BUILD_NAME                                                                                        \n");
			sql.append("		                 , CONTRACT.UND_CON_NAME                   AS UND_CON_NAME                                                                                      \n");
			sql.append("		                 , CONTRACT.SUB_UND_CON_NAME               AS SUB_UND_CON_NAME                                                                                  \n");
			sql.append("		                 , CONTRACT.WORK_PLACE                     AS WORK_PLACE                                                                                        \n");
			sql.append("		                 , CONTRACT.CON_SUPPLY_AMT                 AS con_supply_amt                                                                                    \n");
			sql.append("		                 , CONTRACT.CON_SUPPLY_TAMT                 AS con_supply_tamt                                                                                    \n");
			sql.append("		                 , CONTRACT.CON_SUPPLY_NAMT                 AS con_supply_namt                                                                                    \n");
			sql.append("		                 , CONTRACT.CON_SURTAX_AMT                                                                                                                      \n");
			sql.append("		                 , CONTRACT.CON_AMT                                                                                                                             \n");
			sql.append("		                 , CONTRACT.LABOR_AMT                                                                                                                           \n");
			sql.append("		                 , CONTRACT.PREPAY_SUPPLY_AMT             AS PREPAY_SUPPLY_AMT                                                                                  \n");
			sql.append("		                 , CONTRACT.PREPAY_SUPPLY_TAMT            AS PREPAY_SUPPLY_TAMT                                                                                  \n");
			sql.append("		                 , CONTRACT.PREPAY_SUPPLY_NAMT            AS PREPAY_SUPPLY_NAMT                                                                                  \n");
			sql.append("		                 , CONTRACT.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.START_WORK_DATE,'YYYY-MM-DD') || ' ~ ' || TO_CHAR(CONTRACT.END_WORK_DATE,'YYYY-MM-DD') ) WORK_DATE                         \n");
			sql.append("		                 , CONTRACT.CON_EST_GUAR_RATE             AS CON_EST_GUAR_RATE                                                                                  \n");
			sql.append("		                 , CONTRACT.CON_EST_GUAR_AMT                                                                                                                    \n");
			sql.append("		                 , CONTRACT.CON_GUAR_TERM                AS CON_GUAR_TERM                                                                                       \n");
			sql.append("		                 , CONTRACT.DEF_EST_GUAR_RATE            AS DEF_EST_GUAR_RATE                                                                                   \n");
			sql.append("		                 , CONTRACT.DEF_GUAR_AMT                                                                                                                        \n");
			sql.append("		                 , CONTRACT.DEF_EST_TERM                 AS DEF_EST_TERM                                                                                        \n");
			sql.append("		                 , CONTRACT.LABOR_GUAR_JOIN_AMT_GB       AS LABOR_GUAR_JOIN_AMT_GB                                                                              \n");
			sql.append("		                 , CONTRACT.CON_SPE_TXT                  AS CON_SPE_TXT                                                                                         \n");
			sql.append("		                 , CONTRACT.DELAY_RATE        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.CORP_KOR        AS CORP_KOR                                                                                                        \n");
			sql.append("		                 , SUBVENDOR.CORP_ID                                                                                                                            \n");
			sql.append("		                 , MAIN.PREREQTFLG                                                                                                                              \n");
			sql.append("		                 , MAIN.ACMP_NO                                                                                                                                 \n");
			sql.append("		                 , MAIN.PROOF_CLASS                                                                                                                             \n");
			sql.append("		                 , MAIN.ORDACCDESC                                                                                                                              \n");
			sql.append("		                 , MAIN.CON_CUR_CD                                                                                                                              \n");
			sql.append("		                 , MAIN.SUPPLY_AMT                          SUPPLY_AMT                                                                                                    \n");
			sql.append("		                 , MAIN.SURTAX_AMT                          SURTAX_AMT                                                                                                    \n");
			sql.append("		                 , MAIN.SUPPLY_AMT + MAIN.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.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("		                 , MAIN.ACMP_ID                                                                                                                                 \n");
			sql.append("		                 , MAIN.PREPAY_ID                                                                                                                               \n");
			sql.append("		                 , PREPAY.CON_CORP_ID                                                                                                                           \n");
			sql.append("		                 , CONTRACT.SUB_CONT_ID                                                                                                                         \n");
			/*
			sql.append("		                  , CASE                                                                                                                                        \n");
			sql.append("		                        WHEN (SLIP.STATUS_CD = '1') AND (SLIP.RETURN_CD = 'Y') THEN '-1'                                                                        \n");
			sql.append("		                        ELSE SLIP.STATUS_CD                                                                                                                     \n");
			sql.append("		                      END                                      STATUS_CD                                                                                        \n");
			sql.append("		                                                                                                                                                                \n");
			*/
			sql.append("		              FROM SUB1050T            MAIN                                                                                                                     \n");
			sql.append("		                                                                                                                                                                \n");
			sql.append("		   LEFT OUTER JOIN SUB1030T            PREPAY                                                                                                                   \n");
			sql.append("		                ON MAIN.PREPAY_ID = PREPAY.PREPAY_ID                                                                                                            \n");
			sql.append("		                                                                                                                                                                \n");
			sql.append("		   LEFT OUTER JOIN SUB1020T         SUBVENDOR                                                                                                                  	\n");
			sql.append("		                ON SUBVENDOR.MAIN_CORP = 'Y'                                                                                                   					\n");
			sql.append("		               AND PREPAY.CON_CORP_ID = SUBVENDOR.CON_CORP_ID                                                                                                   \n");
			sql.append("		                                                                                                                                                                \n");
			sql.append("		   LEFT OUTER JOIN SUB1000T             CONTRACT                                                                                                                \n");
			sql.append("		                ON PREPAY.SUB_CONT_ID = CONTRACT.SUB_CONT_ID                                                                                                    \n");
			sql.append("		                                                                                                                                                                \n");
			/*
			sql.append("		   LEFT OUTER JOIN SAC01001            SLIP                                                                                                                     \n");
			sql.append("		                   ON MAIN.TMPSLIP_DEPT = SLIP.TMPSLIP_DEPT                                                                                                     \n");
			sql.append("		                  AND MAIN.TMPSLIP_DT     = SLIP.TMPSLIP_DT                                                                                                     \n");
			sql.append("		                  AND MAIN.TMPSLIP_NO      = SLIP.TMPSLIP_NO                                                                                                    \n");
			sql.append("		                                                                                                                                                                \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("		                                                                                                                                                                \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("		                                                                                                                                                                \n");
			sql.append("		   LEFT OUTER JOIN EBID_COM911T    CUR_CD                                                                                                                            \n");
			sql.append("		                  ON CUR_CD.BASECD = '911'                                                                                                                    	\n");
			sql.append("		                AND  CONTRACT.CON_CUR_CD = CUR_CD.DETAILCD                                                                                                      \n");
			sql.append("		                                                                                                                                                                \n");
			sql.append("		             WHERE PREREQTFLG     = 'PREPAY'                                                                                                                    \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;
		
		
	}
	
	
	/**
	 * @param args
	 */
	public void doBiz1Rtn(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, 9, 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(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);
            
            
            
          //2016.7.19 원정 listRowSet.get("CON_CUR_WON"), ￦listRowSet.get("CON_CUR_NAME")
            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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21,"(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" +  listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" +  listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, "(" +  listRowSet.get("CON_CUR_NAME") + 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")  , FontTitle, border,
            			Element.ALIGN_RIGHT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21, new String [] {listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21,  "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false);          
            	PT_addCell(table21,   "(" + listRowSet.get("CON_CUR_NAME")+ 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); 
            	PT_addCell(table31, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); 
            	PT_addCell(table31, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); 
            	PT_addCell(table31, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); 
            	PT_addCell(table31, "(" + listRowSet.get("CON_CUR_NAME") +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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); 
            	PT_addCell(table31, "(" + listRowSet.get("CON_CUR_NAME") + 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 [] { listRowSet.get("CON_CUR_WON") }, FontTitle, border,
            			Element.ALIGN_LEFT, Element.ALIGN_MIDDLE, 1, 30f ,false); 
            	PT_addCell(table31, "(" + listRowSet.get("CON_CUR_NAME") + 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 +" 생성완료");
	}
}