package com.reallinkbilling.download;




import static java.awt.Color.WHITE;
import static org.apache.pdfbox.pdmodel.font.PDType1Font.HELVETICA;
import static org.vandeseer.easytable.settings.HorizontalAlignment.CENTER;
import static org.vandeseer.easytable.settings.HorizontalAlignment.LEFT;
import static org.vandeseer.easytable.settings.HorizontalAlignment.RIGHT;

import java.awt.Color;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.time.LocalDate;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

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.ServletActionContext;
import org.apache.struts2.dispatcher.SessionMap;
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.opensymphony.xwork2.ActionSupport;


import com.reallinkbilling.DAO.DailyExpenseDAO;
import com.reallinkbilling.db.GetDBConnection;



public class DownloadDailyExpenseReport extends ActionSupport implements SessionAware{
	
	
	/**
	 * 
	 */
	private static final long serialVersionUID = -8591113875387565921L;
	
	
	public HttpServletRequest request;
	public HttpServletResponse response;
	
	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 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 HttpSession session;
	private String fromDate;
	private String toDate;
	private List<DailyExpenseDAO> dailyExpenseList = new ArrayList<DailyExpenseDAO>();
	private SessionMap<String,Object> sessionMap; 
	
	private float totalExpenseAmount = 0.0f;
	
	public void download() throws ParseException
	{
		
		this.setSession(ServletActionContext.getRequest().getSession(false)); 
		 
	        if(this.getSession()==null || this.getSession().getAttribute("login")==null){ 
	        	addActionMessage("Please Login First !!!");
	        	
	        }  
	        else{
	        	
	        	response = ServletActionContext.getResponse();
				request = ServletActionContext.getRequest();
				
	        	
			//	String path=	request.getSession().getServletContext().getRealPath("/images/");
				
				
				
				String shopName = (String)  this.getSessionMap().get("shopnameenglish");
				String shopaddresseng = (String)  this.getSessionMap().get("shopaddresseng");
				
	        	String shopId = (String) this.getSessionMap().get("shopId");
	    		String shopCode = (String) this.getSessionMap().get("shopCode");
	        	
	        	Connection connection = null;
	    		PreparedStatement preparedStatement= null;
	    		ResultSet resultSet = null;
	    	 
	    		String sql = "";
	    		String db = (String) this.getSessionMap().get("db");
	    		
	    		try
	    		{
	    			
					connection = GetDBConnection.getDBConnection(db);
	    			
	    			sql = "SELECT "
	    					+ "entry_id,"
	    					+ "DATE_FORMAT(expense_date,'%d-%m-%Y'),"
	    					+ "expense_details,"
	    					+ "exepnse_amount,"
	    					+ "type_of_payment,"
	    					+ "expense_image "
	    					+ "FROM "
	    					+ "shop_daily_expense_details_master "
	    					+ "WHERE "
	    					+ "shop_id = ? "
	    					+ "AND "
	    					+ "shop_code = ? "
	    					+ "AND "
	    					+ "(expense_date BETWEEN "
	    					+ "STR_TO_DATE(?,'%d-%m-%Y') AND STR_TO_DATE(?,'%d-%m-%Y'))";
	    			
	    			preparedStatement = connection.prepareStatement(sql);
	    			
	    			preparedStatement.setString(1, shopId);
	    			preparedStatement.setString(2, shopCode);
	    			preparedStatement.setString(3, this.getFromDate());
	    			preparedStatement.setString(4, this.getToDate());
	    			
	    			resultSet = preparedStatement.executeQuery();
	    			resultSet.last();
	    			int resultCount = resultSet.getRow();
	    			resultSet.beforeFirst();
	    			
	    		float	totalExpAmount = 0.0f;
	    			
	    			if(resultCount > 0)
	    			{
	    				while(resultSet.next())
	    				{
	    					DailyExpenseDAO dailyExpenseDAO = new DailyExpenseDAO();
	    					dailyExpenseDAO.setId(resultSet.getString(1));
	    					dailyExpenseDAO.setExpenseDate(resultSet.getString(2));
	    					dailyExpenseDAO.setExpenseReason(resultSet.getString(3));
	    					dailyExpenseDAO.setAmount(resultSet.getString(4));
	    					
	    					totalExpAmount += Float.parseFloat(resultSet.getString(4));
	    					
	    					dailyExpenseDAO.setTypeOfPayment(resultSet.getString(5));	    				
	    					dailyExpenseDAO.setExpenseImage(resultSet.getBlob(6));
	    					
	    					this.getDailyExpenseList().add(dailyExpenseDAO);
	    					
	    				}
	    				
	    				this.setTotalExpenseAmount(totalExpAmount);
	    				
	    			}
	    			else
	    			{
	    				
	    				addActionError("Records not found for given dates!");
	    			}
	    			
	    			
	    			
	    			@SuppressWarnings("unchecked")
					String crusherName = (String) this.getSessionMap().get("crushernameenglish");
				    
					
				 DecimalFormat df = new DecimalFormat("##.##");
				 String path=	request.getSession().getServletContext().getRealPath("/images/");
		    			PDDocument document = new PDDocument(); 
						
						
						SimpleDateFormat sdf = new SimpleDateFormat("dd-MMM-Y");
						Date date = new Date();
						
						String dateToday = sdf.format(date); 
						
						
						 File fontFile  =  new File( request.getSession().getServletContext().getRealPath("/fonts/Nirmala.ttf"));
						 TrueTypeFont ttf1 = new TTFParser().parse(fontFile);
						 PDFont fontMarathi = PDType0Font.load(document, ttf1, true);
						
					        
					         int pageCount = 1;
		          
		          if(dailyExpenseList.size() > 0)
		          {


			          
				      	PDPage page = null;
							
							
				      	page = 	new PDPage(PDRectangle.A4);
							
							
							
				        document.addPage(page);
				         PDPageContentStream contentStream = new PDPageContentStream(document, page);
		          
				         Table pageheader;
			    			
			    			
		    			  TableBuilder tableHeaderBuilder = Table.builder()
					                .addColumnsOfWidth(595)				                
					                .font(HELVETICA)
					                .borderColor(Color.BLACK)
					                .horizontalAlignment(CENTER);
				         
				          Row headerName2 = Row.builder()
					                .add(TextCell.builder().text(shopName+","+shopaddresseng).horizontalAlignment(CENTER).borderWidth(0).lineSpacing(10F).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(PDType1Font.HELVETICA_BOLD).fontSize(20)				              
					                .horizontalAlignment(CENTER)
					                .build();
				          
				          
				          Row entryinfo1 = Row.builder()
					                .add(TextCell.builder().text("Daily Expense Report").borderWidthBottom(0.0F).horizontalAlignment(CENTER).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(PDType1Font.HELVETICA_BOLD).fontSize(10)
					                .horizontalAlignment(CENTER)
					                .build();
				    
				          
				          Row entryinfo2 = Row.builder()
				                .add(TextCell.builder().text("From Date: "
				                			+this.getFromDate()+" To Date : "+this.getToDate() +"       Page No . : "+pageCount+", Generated On : "+dateToday)
				                		.borderWidthBottom(0.0F).horizontalAlignment(CENTER).build())				               
				                .backgroundColor(WHITE)
				                .textColor(Color.BLACK)
				                .font(PDType1Font.HELVETICA_BOLD).fontSize(10)
				                .horizontalAlignment(CENTER)
				                .build();
				          
				       
				          tableHeaderBuilder.addRow(headerName2);
				          tableHeaderBuilder.addRow(entryinfo1);
				          tableHeaderBuilder.addRow(entryinfo2);
				       
				          pageheader = tableHeaderBuilder.build();
				          
				          
				          float balaceEntryStartY = page.getMediaBox().getHeight() - PADDING20;
				          float balaceEntryCurrentY = balaceEntryStartY;
				          
				          TableDrawer.builder()
			                .contentStream(contentStream)
			                .table(pageheader)
			                .startX(PADDING10)
			                .startY(balaceEntryCurrentY)
			                .build()
			                .draw();
				          
				          Table balaceEntryDetails ;
				          
				          TableBuilder balanceEntryDetailsBuilder = Table.builder()
					                .addColumnsOfWidth(40,50,50,295,80,60)				                
					                .font(HELVETICA)
					                .borderWidth(0.5F)
					                .borderColor(Color.BLACK)
					                .horizontalAlignment(CENTER);
				          
				          
				          Row balaceEntryDetailsTableHeader = Row.builder()
				        		  .add(TextCell.builder().text("SrNo").horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())	
	        					  .add(TextCell.builder().text("ID").horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())				                
	        					  .add(TextCell.builder().text("Date").horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())				                
						        	.add(TextCell.builder().text("Reason").horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())
						        	 .add(TextCell.builder().text("Payment Type").horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())	
					                .add(TextCell.builder().text("Amount").horizontalAlignment(LEFT).fontSize(9).borderWidth(0.5F).lineSpacing(0.2F).build())	
					               
					               
					                .backgroundColor(Color.LIGHT_GRAY)
					                .textColor(Color.BLACK)
					                .font(PDType1Font.HELVETICA_BOLD).fontSize(8)				              
					                .horizontalAlignment(CENTER)
					                .build();
				          balanceEntryDetailsBuilder.addRow(balaceEntryDetailsTableHeader);
				          
				          
				         
				          for(int s=0;s<this.getDailyExpenseList().size();s++)
			        	  {
				        	  if(balaceEntryCurrentY < 130)
			        		  {
			        			 
			        			  pageCount++;
			        			  balaceEntryDetails = balanceEntryDetailsBuilder.build();
			        			  TableDrawer.builder()
					                .contentStream(contentStream)
					                .table(balaceEntryDetails)
					                .startX(PADDING10)
					                .startY(balaceEntryStartY-70)
					                .build()
					                .draw();
			        			  
			        			  contentStream.close();
			        			  
			        			  contentStream = null;
						          
						      	PDPage newPage = new PDPage(PDRectangle.A4);
						      	contentStream = new PDPageContentStream(document,newPage);
						      	balaceEntryCurrentY =  newPage.getMediaBox().getHeight() - PADDING20;
				             document.addPage(newPage );
				            
				             balaceEntryDetails = null;
				             balanceEntryDetailsBuilder = null;
				             pageheader = null;
				             tableHeaderBuilder = null;
		        			  
		        			  
				             tableHeaderBuilder = Table.builder()
						                .addColumnsOfWidth(595)				                
						                .font(HELVETICA)
						                .borderColor(Color.BLACK)
						                .horizontalAlignment(CENTER);
					         
		        			  headerName2 = Row.builder()
						                .add(TextCell.builder().text(shopName+","+shopaddresseng).horizontalAlignment(CENTER).borderWidth(0).lineSpacing(10F).build())				               
						                .backgroundColor(WHITE)
						                .textColor(Color.BLACK)
						                .font(PDType1Font.HELVETICA_BOLD).fontSize(20)				              
						                .horizontalAlignment(CENTER)
						                .build();
					          
		        			  entryinfo1 = Row.builder()
						                .add(TextCell.builder().text("Daily Expense Report").borderWidthBottom(0.0F).horizontalAlignment(CENTER).build())				               
						                .backgroundColor(WHITE)
						                .textColor(Color.BLACK)
						                .font(PDType1Font.HELVETICA_BOLD).fontSize(10)
						                .horizontalAlignment(CENTER)
						                .build();
					       
					          
		        			  entryinfo2 = Row.builder()
					                .add(TextCell.builder().text("From Date: "
					                			+this.getFromDate()+" To Date : "+this.getToDate() +"       Page No . : "+pageCount).borderWidthBottom(0.0F).horizontalAlignment(CENTER).build())				               
					                .backgroundColor(WHITE)
					                .textColor(Color.BLACK)
					                .font(PDType1Font.HELVETICA_BOLD).fontSize(10)
					                .horizontalAlignment(CENTER)
					                .build();
					          
					       
		        			 tableHeaderBuilder.addRow(headerName2);
		        			  tableHeaderBuilder.addRow(entryinfo1);
		        			 tableHeaderBuilder.addRow(entryinfo2);
					       
		        			  pageheader = tableHeaderBuilder.build();
		        			  
		        			  TableDrawer.builder()
				                .contentStream(contentStream)
				                .table(pageheader)
				                .startX(PADDING10)
				                .startY(balaceEntryCurrentY)
				                .build()
				                .draw();
					          
		        			  balaceEntryDetails = null;
					          
					          
					          
		        			  balanceEntryDetailsBuilder = Table.builder()
		        					    .addColumnsOfWidth(40,50,50,295,80,60)				                
							                .font(HELVETICA)
						                .borderWidth(0.5F)
						                .borderColor(Color.BLACK)
						                .horizontalAlignment(CENTER);
					          
		        			  balaceEntryDetailsTableHeader = Row.builder()
		        					  .add(TextCell.builder().text("SrNo").horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())	
		        					  .add(TextCell.builder().text("ID").horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())				                
		        					  .add(TextCell.builder().text("Date").horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())				                
							        	.add(TextCell.builder().text("Reason").horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())
							        	 .add(TextCell.builder().text("Payment Type").horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())	
						                .add(TextCell.builder().text("Amount").horizontalAlignment(LEFT).fontSize(9).borderWidth(0.5F).lineSpacing(0.2F).build())	
						               
						               
						                .backgroundColor(Color.LIGHT_GRAY)
						                .textColor(Color.BLACK)
						                .font(PDType1Font.HELVETICA_BOLD).fontSize(8)				              
						                .horizontalAlignment(CENTER)
						                .build();
					          balanceEntryDetailsBuilder.addRow(balaceEntryDetailsTableHeader);
		        			
				             
				          
			        		  }
			        		  
			        		  
				        	  DailyExpenseDAO dao = this.getDailyExpenseList().get(s);
	        		 		  
			        	Row detailsInfoRow = Row.builder()
					        			.add(TextCell.builder().text(""+(s+1)).horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())				                
				        			  	.add(TextCell.builder().text(dao.getId()).horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())				                
				        			  	.add(TextCell.builder().text(dao.getExpenseDate()).horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())				                
				        			  	.add(TextCell.builder().text(dao.getExpenseReason()).horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())
				        				.add(TextCell.builder().text(dao.getTypeOfPayment()).horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())				                
				        			  	.add(TextCell.builder().text(dao.getAmount()).horizontalAlignment(LEFT).borderWidth(0.5F).lineSpacing(0.2F).build())				                
				        			  
				        			  	 

				        				.backgroundColor(Color.WHITE)
						                .textColor(Color.BLACK)
						                .font(fontMarathi)
						                .fontSize(8)				              
						                .horizontalAlignment(CENTER)
						                .height(25F)					                
						                .build();
			        		
				        	  
			        		balanceEntryDetailsBuilder.addRow(detailsInfoRow);
			        	
				        	 
			        		balaceEntryCurrentY = balaceEntryCurrentY -25;
			        		  
			        	  }
			        	  
			        	

				          
				      	Row balanceTotal = Row.builder()
		        			  	.add(TextCell.builder().text("Total").colSpan(5).horizontalAlignment(RIGHT).borderWidth(0.5F).lineSpacing(0.2F).build())				                
		        			  	.add(TextCell.builder().text(""+this.getTotalExpenseAmount()).horizontalAlignment(LEFT).fontSize(9).borderWidth(0.5F).lineSpacing(0.2F).build())				                
		        			  	
      
		        			  	.backgroundColor(Color.WHITE)
				                .textColor(Color.BLACK)
				                .font(PDType1Font.HELVETICA_BOLD)
				                .fontSize(9)				              
				                .horizontalAlignment(CENTER)
				                .height(25F)					                
				                .build();
				      	balanceEntryDetailsBuilder.addRow(balanceTotal);
			        		
			        	  
			        		balaceEntryDetails = balanceEntryDetailsBuilder.build();
			        		
				          TableDrawer.builder()
			                .contentStream(contentStream)
			                .table(balaceEntryDetails)
			                .startX(PADDING10)
			                .startY(balaceEntryStartY-70)
			                .build()
			                .draw();
				          
				          contentStream.close();
				          
							         
							         
								       // System.out.println(path);
												
								        
								        document.save(path+"/daily-expense-report.pdf");
								        document.close();
								        
								        response.setHeader("Content-disposition", "inline; filename=daily-expense-report.pdf");
										response.setContentType("application/pdf");
										FileInputStream fileInputStream = new FileInputStream(path+"/daily-expense-report.pdf");
										PrintWriter out = response.getWriter();  
										int bytes;
										while ((bytes = fileInputStream.read()) != -1) {
											out.write(bytes);
										}
										fileInputStream.close();
										out.flush();
										out.close();
										ttf1.close();
				  
		          }
	    			
	    		}
	    		 catch (SQLException e) {
		    			
		    			
		    			
		    			addActionError(e.getErrorCode()+" || "+e.getMessage() +" || Something Went Wrong!");
		    		} catch (IOException e) {
		    			
		    			
		    			addActionError(e.getMessage()+" || "+e.getCause()+" || Something Went Wrong!");
		    		} finally {
		    			if(resultSet != null)
						{
							try {
								resultSet.close();
							} catch (SQLException e) {
								
							}
						}
		    			if(preparedStatement != null)
		    			{
		    				try {preparedStatement.close();} catch (SQLException e) {}
		    			}
		    			if(connection != null)
		    			{
		    				
		    				try {connection.close();}catch (SQLException e) {}
		    			}
		    			
		    		}
	        	
	        }
	        
	        
	}

	@Override
	public void validate() {
		
		if(this.getFromDate().equals("") && this.getToDate().equals(""))
		{
			addActionError("Please select dates!");
		}
	}
	public HttpSession getSession() {
		return session;
	}

	public void setSession(HttpSession session) {
		this.session = session;
	}

	public String getFromDate() {
		return fromDate;
	}

	public void setFromDate(String fromDate) {
		this.fromDate = fromDate;
	}

	public String getToDate() {
		return toDate;
	}

	public void setToDate(String toDate) {
		this.toDate = toDate;
	}

	public List<DailyExpenseDAO> getDailyExpenseList() {
		return dailyExpenseList;
	}

	public void setDailyExpenseList(List<DailyExpenseDAO> dailyExpenseList) {
		this.dailyExpenseList = dailyExpenseList;
	}
	
	public SessionMap<String, Object> getSessionMap() {
		return sessionMap;
	}

	public void setSessionMap(SessionMap<String, Object> sessionMap) {
		this.sessionMap = sessionMap;
	}


	public void setSession(Map<String, Object> map) {  
	    sessionMap=(SessionMap<String, Object>)map;  
	}

	public float getTotalExpenseAmount() {
		return totalExpenseAmount;
	}

	public void setTotalExpenseAmount(float totalExpenseAmount) {
		this.totalExpenseAmount = totalExpenseAmount;
	}
	
		
	
	
	
	
	
}

