package com.reallinkbilling.print;

import static java.awt.Color.WHITE;
import static org.apache.pdfbox.pdmodel.font.PDType1Font.HELVETICA;
import static org.vandeseer.easytable.settings.HorizontalAlignment.CENTER;

import java.awt.Color;
import java.io.File;
import java.io.FileInputStream;
import java.io.PrintWriter;
import java.net.URLDecoder;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.fontbox.ttf.TTFParser;
import org.apache.fontbox.ttf.TrueTypeFont;
import org.apache.pdfbox.pdmodel.PDDocument;
import org.apache.pdfbox.pdmodel.PDPage;
import org.apache.pdfbox.pdmodel.PDPageContentStream;
import org.apache.pdfbox.pdmodel.common.PDRectangle;
import org.apache.pdfbox.pdmodel.font.PDFont;
import org.apache.pdfbox.pdmodel.font.PDType0Font;
import org.apache.pdfbox.pdmodel.font.PDType1Font;
import org.apache.struts2.dispatcher.SessionMap;
import org.apache.struts2.interceptor.ServletRequestAware;
import org.apache.struts2.interceptor.ServletResponseAware;
import org.apache.struts2.interceptor.SessionAware;
import org.vandeseer.easytable.TableDrawer;
import org.vandeseer.easytable.structure.Row;
import org.vandeseer.easytable.structure.Table;
import org.vandeseer.easytable.structure.Table.TableBuilder;
import org.vandeseer.easytable.structure.cell.TextCell;

import com.reallinkbilling.cipher.EncryptionDecryption;
import com.reallinkbilling.utils.NumberToWordsConverter;
import com.reallinkbilling.utils.UnicodeToKrutiDev;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;

public class PrintCreditCollectionReceipt extends ActionSupport implements SessionAware,ServletRequestAware,ServletResponseAware{

	/**
	 * 
	 */
	private static final long serialVersionUID = 3394923236014698231L;

	private final static Color BLUE_DARK = new Color(76, 129, 190);
    private final static Color BLUE_LIGHT_1 = new Color(186, 206, 230);
    private final static Color BLUE_LIGHT_2 = new Color(218, 230, 242);

    private final static Color GRAY_LIGHT_1 = new Color(245, 245, 245);
    private final static Color GRAY_LIGHT_2 = new Color(240, 240, 240);
    private final static Color GRAY_LIGHT_3 = new Color(216, 216, 216);
    private static final float PADDING05 = 5f;
    private static final float PADDING10 = 10f;
    private static final float PADDING20 = 20f;
    private static final float PADDING30 = 30f;
    private static final float PADDING40 = 40f;
    private static final float PADDING50 = 50f;

	private SessionMap<String,Object> sessionMap;
	
	private HttpServletRequest request = null;
	private HttpServletResponse response = null;
	
	private String key;
	
	
@SuppressWarnings("deprecation")
public void downloadCollectionReceipt() throws Exception {
		
		//System.out.println("Bill Number : "+billNumber);
		
				Connection connection = null;
				PreparedStatement preparedStatement= null;
				ResultSet resultSet = null;
				
				String sql = "";
				String db = "easymilkbilling";
				
				Map<String, Object> session = ActionContext.getContext().getSession();
				
				
				if(session != null)
				{
					
					String shopId = (String) session.get("shopId");
					String shopCode = (String) session.get("shopCode");
					
					try
		        	{
						String creditCollectionData [] = EncryptionDecryption.decrypt(URLDecoder.decode(this.getKey(),"UTF-8")).split("#");
						//customerId#Customername#entryDate#time#Amount
						String custId = creditCollectionData[0];
						String custname = creditCollectionData[1];
						String entryDate = creditCollectionData[2];
						String time = creditCollectionData[3];
						String amount = creditCollectionData[4];
						String entryBy = creditCollectionData[5];
						
						String fontPath =	this.getRequest().getSession().getServletContext().getRealPath("/fonts/NirmalaB.ttf");
						String path= this.getRequest().getSession().getServletContext().getRealPath("/images/");
						
						
						String billHeader = (String) session.get("shopnamemarathi"); 
						String billAddress = (String) session.get("shopaddressmr");
						String billMobile = (String) session.get("shopcustcarenumber");
						
						 
					
						 
						PDDocument document = new PDDocument(); 
						PDPage page = null;
						PDRectangle pdRectangle = new PDRectangle(220, 300);
						
						 page = new PDPage(pdRectangle);
						
						 File f = new File(fontPath);
						 
						 
						 
						 document.addPage(page);
					
						 PDFont fontMarathi = PDType0Font.load(document, f);
						 
						 File fontFilekrutiDev2  =  new File( request.getSession().getServletContext().getRealPath("/fonts/Kruti_Dev_100__Bold.ttf"));
						 
						 TrueTypeFont ttf3 = new TTFParser().parse(fontFilekrutiDev2);
						 PDFont krutiDev2 = PDType0Font.load(document, ttf3, true);
						 
						 
				         PDPageContentStream contentStream = new PDPageContentStream(document, page);
				         
				         
				         
				         Table header;
				         
				         
				         
				         
				         TableBuilder tableHeaderBuilder = Table.builder()
					                .addColumnsOfWidth(220)				                
					                .font(HELVETICA)
					                .borderColor(Color.BLACK)
					                .horizontalAlignment(CENTER);
				         
				         Row shopNameHeader = Row.builder()
					                .add(TextCell.builder().text(UnicodeToKrutiDev.convert(billHeader)).horizontalAlignment(CENTER).borderWidth(0).lineSpacing(10F).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(krutiDev2).fontSize(14)				              
					                .horizontalAlignment(CENTER)
					                .build();
				         
				         Row addressRow = Row.builder()
					                .add(TextCell.builder().text(billAddress).horizontalAlignment(CENTER).borderWidth(0).lineSpacing(10F).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(fontMarathi).fontSize(8)				              
					                .horizontalAlignment(CENTER)
					                .build();
				         
				         
				         Row reportInfo1 = Row.builder()
					                .add(TextCell.builder()
					                		.text("Contact :"+billMobile)
					                		.horizontalAlignment(CENTER).borderWidth(0).lineSpacing(10F).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(fontMarathi).fontSize(9)				              
					                .horizontalAlignment(CENTER)
					                .build();
				         
				         
				         
				         
				         tableHeaderBuilder.addRow(shopNameHeader);
				         tableHeaderBuilder.addRow(addressRow);
				         tableHeaderBuilder.addRow(reportInfo1);
				         contentStream.moveTo(5, 240);
				         contentStream.lineTo(215, 240);
				         contentStream.stroke();
				        
				         //contentStream.moveTo(5, 210);
				        // contentStream.lineTo(215, 210);
				        // contentStream.stroke();
				         header = tableHeaderBuilder.build();
				         
				         float startY = page.getMediaBox().getHeight() - PADDING10;
				         TableDrawer.builder()
			                .contentStream(contentStream)
			                .table(header)
			                .startX(PADDING05)
			                .startY(startY)
			                .build()
			                .draw();
				         
				         
				         Table dateDetails;
				         
				         TableBuilder tableDateBuilder = Table.builder()
					                .addColumnsOfWidth(220)				                
					                .font(HELVETICA)
					                .borderColor(Color.BLACK)
					                .horizontalAlignment(CENTER);
				         Row title = Row.builder()
					                .add(TextCell.builder()
					                		.text("Payment Receipt")
					                		.horizontalAlignment(CENTER).borderWidth(0).lineSpacing(10F).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(PDType1Font.HELVETICA_BOLD).fontSize(14)				              
					                .horizontalAlignment(CENTER)
					                .build();
						
				         Row date = Row.builder()
					                .add(TextCell.builder()
					                		.text("Date :"+entryDate+" : "+time)
					                		.horizontalAlignment(CENTER).borderWidth(0).lineSpacing(10F).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(fontMarathi).fontSize(10)				              
					                .horizontalAlignment(CENTER)
					                .build();
				         
				         Row receivedBy = Row.builder()
					                .add(TextCell.builder()
					                .text("Received By : "+entryBy)
					                .horizontalAlignment(CENTER).borderWidth(0).lineSpacing(10F).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(fontMarathi).fontSize(10)				              
					                .horizontalAlignment(CENTER)
					                .build();
				         
				         
				         tableDateBuilder.addRow(title);
				         tableDateBuilder.addRow(date);
				         tableDateBuilder.addRow(receivedBy);
				         
				         //contentStream.moveTo(5, 180);
				         //contentStream.lineTo(215, 180);
				         //contentStream.stroke();
				         
				         dateDetails = tableDateBuilder.build();
				         
				         TableDrawer.builder()
			                .contentStream(contentStream)
			                .table(dateDetails)
			                .startX(PADDING05)
			                .startY(startY-55)
			                .build()
			                .draw();
				         
				         
				         Table receiptDetails;
				         
				         TableBuilder tablereceiptDetailsBuilder = Table.builder()
					                .addColumnsOfWidth(220)				                
					                .font(HELVETICA)
					                .borderColor(Color.BLACK)
					                .horizontalAlignment(CENTER);
				         
				         String toWords = "";
				         
				         NumberToWordsConverter convert = new NumberToWordsConverter();
				         toWords = convert.getConverted(amount+".0");
				         Row detailsLine = Row.builder()
					                .add(TextCell.builder()
					                		.text("Rs. "+amount+ " received by \n"+custname)
					                		.horizontalAlignment(CENTER).borderWidth(0).lineSpacing(0.5F).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(PDType1Font.HELVETICA_BOLD).fontSize(14)				              
					                .horizontalAlignment(CENTER)
					                .height(30F)
					                .build();
				         
				        // System.out.println(toWords);
				         Row inWords = Row.builder()
					                .add(TextCell.builder()
					                		.text("(In words:"+toWords+")")
					                		.horizontalAlignment(CENTER).borderWidth(0).lineSpacing(0.5F).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(PDType1Font.HELVETICA_BOLD).fontSize(8)				              
					                .horizontalAlignment(CENTER)
					                .height(20F)
					                .build();
				         
				         Row thankYou = Row.builder()
					                .add(TextCell.builder()
					                		.text("Thank You!")
					                		.horizontalAlignment(CENTER).borderWidth(0).lineSpacing(0.5F).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(PDType1Font.HELVETICA_BOLD).fontSize(9)				              
					                .horizontalAlignment(CENTER)
					                .height(10F)
					                .build();
				         tablereceiptDetailsBuilder.addRow(detailsLine);
				         tablereceiptDetailsBuilder.addRow(inWords);
				         tablereceiptDetailsBuilder.addRow(thankYou);
				        
				         
				         contentStream.moveTo(5, 80);
				         contentStream.lineTo(215, 80);
				         contentStream.stroke();
				         receiptDetails = tablereceiptDetailsBuilder.build();
				         TableDrawer.builder()
			                .contentStream(contentStream)
			                .table(receiptDetails)
			                .startX(PADDING05)
			                .startY(startY-120)
			                .build()
			                .draw();
				         
				         
				         
				         Table developedBy;
				         
				         TableBuilder tableDevelopedByBuilder = Table.builder()
					                .addColumnsOfWidth(220)				                
					                .font(HELVETICA)
					                .borderColor(Color.BLACK)
					                .horizontalAlignment(CENTER);
				         
				         
				         Row devBy = Row.builder()
					                .add(TextCell.builder()
					                		.text("Developed By:\nReal Link Webtech Pvt. Ltd.\n8208064913/ 9226400110")
					                		.horizontalAlignment(CENTER).borderWidth(0).lineSpacing(0.5F).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(PDType1Font.HELVETICA_BOLD).fontSize(9)				              
					                .horizontalAlignment(CENTER)
					                .height(10F)
					                .build();
				         
				         tableDevelopedByBuilder.addRow(devBy);
				         developedBy = tableDevelopedByBuilder.build();
				         
				         TableDrawer.builder()
			                .contentStream(contentStream)
			                .table(developedBy)
			                .startX(PADDING05)
			                .startY(startY-220)
			                .build()
			                .draw();
				         
				         	contentStream.close();
						 	document.save(path+"/credit-receipt"+shopCode+".pdf");
					        document.close();
					        
					        

							response.setHeader("Content-disposition", "inline; filename=credit-receipt"+shopCode+".pdf");
							response.setContentType("application/pdf");
							FileInputStream fileInputStream = new FileInputStream(path+"/credit-receipt"+shopCode+".pdf");
							PrintWriter out = response.getWriter();  
							int bytes;
							while ((bytes = fileInputStream.read()) != -1) {
								out.write(bytes);
							}
							fileInputStream.close();
							out.flush();
							out.close();
						
		        	}catch (Exception e) {
						e.printStackTrace();
					}finally {
						if(resultSet != null)
	    				{
	    					try {
	    						resultSet.close();resultSet = null;
	    					} catch (SQLException e) {
	    						
	    					}
	    				}
						if(preparedStatement != null)
						{
							try {preparedStatement.close(); preparedStatement = null;} catch (SQLException e) {}
						}
						if(connection != null)
						{
							
							try {connection.close(); connection = null;}catch (SQLException e) {}
						}
						
						
		        	}
				}
				else
				{
					
				}
					
}	




@Override  
public void setSession(Map<String, Object> map) {  
sessionMap=(SessionMap<String, Object>)map;  
}

public SessionMap<String, Object> getSessionMap() {
return sessionMap;
}

public void setSessionMap(SessionMap<String, Object> sessionMap) {
this.sessionMap = sessionMap;
}
public HttpServletRequest getRequest() {
return request;
}

public void setRequest(HttpServletRequest request) {
this.request = request;
}

public HttpServletResponse getResponse() {
return response;
}

public void setResponse(HttpServletResponse response) {
this.response = response;
}

@Override
public void setServletResponse(HttpServletResponse httpServletResponse) {
this.response = httpServletResponse;
}

@Override
public void setServletRequest(HttpServletRequest httpServletRequest) {
this.request = httpServletRequest;
}




public String getKey() {
	return key;
}




public void setKey(String key) {
	this.key = key;
}




public static long getSerialversionuid() {
	return serialVersionUID;
}


}