package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import org.primefaces.context.RequestContext;

@ManagedBean(name="printCollectionAnalysis")
@ViewScoped
public class PrintCollectionAnalysisBean implements Serializable
{
	ArrayList<LoanInfo> collectionList;
	Double dueCount=0.00,clearCount=0.00,advanceCount=0.00,totalDueTill=0.00,totalDue=0.00,totalAdvance=0.00,totalAdvanceTill=0.00,dailyCollection,dailyCall, collectionPercent;
	String sDate,eDate, dsaCode, dsaName;
	Date startDate,endDate;
	
	public PrintCollectionAnalysisBean()
	{
		
	   HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
	   collectionList=(ArrayList<LoanInfo>) ss.getAttribute("collectionList");
	   startDate=(Date) ss.getAttribute("startDate");
	   endDate=(Date) ss.getAttribute("endDate");
	   dailyCollection=(Double) ss.getAttribute("dailyCollection");
	   dailyCall= (Double) ss.getAttribute("dailyCall");
	   sDate=new SimpleDateFormat("dd-MMM-yyyy").format(startDate);
	   eDate=new SimpleDateFormat("dd-MMM-yyyy").format(endDate);
	   dsaCode=(String) ss.getAttribute("caDsaCode");
	   
	   Connection conn=DataBaseConnection.JAVAConnection();
	   dsaName=new DataBaseMethods().dsaNameById(dsaCode, conn);
	   
	   try {
		conn.close();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	   // System.out.println(eDate);
	   // System.out.println(sDate);
	   for(LoanInfo obj:collectionList)
		   {
	           String temp[]=obj.getDateRangeAmount().split("\\(");
		   	String typeReport=temp[1].substring(0, 1);
		   	
		   	if(typeReport.equals("D"))
			   	{
			   		  totalDueTill=totalDueTill+Double.valueOf(temp[0]);
			   	}
		   	else
		   		if(typeReport.equals("A"))
		   		{
		   			totalAdvanceTill=totalAdvanceTill+Double.valueOf(temp[0]);
		   		}
		   	
		   	// System.out.println(totalDueTill);
		   	// System.out.println(totalAdvanceTill);
		   	
		   	
		   	
		   	if(obj.getStatus().equals("Due"))
			   	{
		   		   dueCount=dueCount+1;
		   		   totalDue=totalDue+obj.getDueAmount();
	                }
		   	else
		   	 if(obj.getStatus().equals("Clear"))
			   	 {
			   		clearCount=clearCount+1; 
			   	 }
		   	else
		   	 if(obj.getStatus().equals("Advance"))
			   	 {
					   		advanceCount=advanceCount+1;
					   		totalAdvance=totalAdvance+obj.getDueAmount();
			   	 }
		   	
		   }
	   
		for(int i=0;i<collectionList.size();i++)
	   	{
	   		collectionList.get(i).setSno(i+1);
	   	}
	   collectionPercent=Double.parseDouble(new DecimalFormat("##.##").format((dailyCollection/dailyCall)*100));
	}


	public String getsDate() {
		return sDate;
	}


	public void setsDate(String sDate) {
		this.sDate = sDate;
	}


	public String geteDate() {
		return eDate;
	}


	public void seteDate(String eDate) {
		this.eDate = eDate;
	}


	public ArrayList<LoanInfo> getCollectionList() {
		return collectionList;
	}


	public Double getDueCount() {
		return dueCount;
	}


	public void setDueCount(Double dueCount) {
		this.dueCount = dueCount;
	}


	public Double getClearCount() {
		return clearCount;
	}


	public void setClearCount(Double clearCount) {
		this.clearCount = clearCount;
	}


	public Double getAdvanceCount() {
		return advanceCount;
	}


	public Double getTotalDueTill() {
		return totalDueTill;
	}


	public void setTotalDueTill(Double totalDueTill) {
		this.totalDueTill = totalDueTill;
	}


	public Double getTotalDue() {
		return totalDue;
	}


	public void setTotalDue(Double totalDue) {
		this.totalDue = totalDue;
	}



	public Double getTotalAdvance() {
		return totalAdvance;
	}


	public void setTotalAdvance(Double totalAdvance) {
		this.totalAdvance = totalAdvance;
	}


	public Double getTotalAdvanceTill() {
		return totalAdvanceTill;
	}


	public void setTotalAdvanceTill(Double totalAdvanceTill) {
		this.totalAdvanceTill = totalAdvanceTill;
	}


	public Double getDailyCollection() {
		return dailyCollection;
	}


	public void setDailyCollection(Double dailyCollection) {
		this.dailyCollection = dailyCollection;
	}


	public void setAdvanceCount(Double advanceCount) {
		this.advanceCount = advanceCount;
	}


	public Double getDailyCall() {
		return dailyCall;
	}


	public void setDailyCall(Double dailyCall) {
		this.dailyCall = dailyCall;
	}


	public void setCollectionList(ArrayList<LoanInfo> collectionList) {
		this.collectionList = collectionList;
	}


	public Double getCollectionPercent() {
		return collectionPercent;
	}


	public void setCollectionPercent(Double collectionPercent) {
		this.collectionPercent = collectionPercent;
	}


	public String getDsaCode() {
		return dsaCode;
	}


	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}


	public String getDsaName() {
		return dsaName;
	}


	public void setDsaName(String dsaName) {
		this.dsaName = dsaName;
	}
	
}