package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.SimpleDateFormat;
import java.util.ArrayList;

import javax.faces.bean.ManagedBean;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

import main_package.CenterInfo;
import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.LoanInfo;
import main_package.UserInfo;

@ManagedBean(name="printCenterDisbursementLetter")
public class PrintCenterDisbursementLetterBean implements Serializable
{
	ArrayList<LoanInfo> grpList;
	String center, freq, firstEmiDateStr, dayOfWeek, strDisburseDate;
	CenterInfo selectedCenter;
	DataBaseMethods dbm=new DataBaseMethods();
	double totalLoanAmount, totalLoanEmiAmount, totalRdAmount, totalAmount;
	
	public PrintCenterDisbursementLetterBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		grpList=(ArrayList<LoanInfo>) ss.getAttribute("printGrpList");
		int branchId = (int) ss.getAttribute("branchId");
		center=(String) ss.getAttribute("printCenter");
		SimpleDateFormat sf=new SimpleDateFormat("dd/MMM/yyyy");
		selectedCenter=dbm.selectedCenterInfo(center);
		Connection conn=DataBaseConnection.JAVAConnection();
		
		totalLoanAmount=totalLoanEmiAmount=totalRdAmount=totalAmount=0;
		for(int i=1;i<=grpList.size();i++)
		{
			grpList.get(i-1).setSno(i);
			grpList.get(i-1).setSavingTotal(dbm.RdAmountByshareHolderNo(branchId, grpList.get(i-1).getShareHolderNo()));
			grpList.get(i-1).setTotalAmount(grpList.get(i-1).getInstallAmount()+grpList.get(i-1).getSavingTotal());
			grpList.get(i-1).setPhoto(dbm.applicantPhotoByShareHolderNo(grpList.get(i-1).getShareHolderNo(), conn));
			if(i==1)
			{
				freq=grpList.get(i-1).getFreqLable();
				firstEmiDateStr=grpList.get(i-1).getStrEmiDueDate();
				dayOfWeek= new SimpleDateFormat("EE").format(grpList.get(i-1).getEmiDate());
				//grpList.get(i-1).setStrOfficeDate();
				strDisburseDate=sf.format(dbm.loanDisburseDateByLoanNo(grpList.get(i-1).getSubLoanNo(), conn));
			}
			
			totalLoanAmount+=grpList.get(i-1).getLoanAmtInt();
			totalLoanEmiAmount+=grpList.get(i-1).getInstallAmount();
			totalRdAmount+=grpList.get(i-1).getSavingTotal();
			totalAmount+=grpList.get(i-1).getTotalAmount();
		}
	}

	public ArrayList<LoanInfo> getGrpList() {
		return grpList;
	}

	public void setGrpList(ArrayList<LoanInfo> grpList) {
		this.grpList = grpList;
	}

	public String getCenter() {
		return center;
	}

	public void setCenter(String center) {
		this.center = center;
	}

	public CenterInfo getSelectedCenter() {
		return selectedCenter;
	}

	public void setSelectedCenter(CenterInfo selectedCenter) {
		this.selectedCenter = selectedCenter;
	}

	public String getFreq() {
		return freq;
	}

	public void setFreq(String freq) {
		this.freq = freq;
	}

	public String getFirstEmiDateStr() {
		return firstEmiDateStr;
	}

	public void setFirstEmiDateStr(String firstEmiDateStr) {
		this.firstEmiDateStr = firstEmiDateStr;
	}

	public double getTotalLoanAmount() {
		return totalLoanAmount;
	}

	public void setTotalLoanAmount(double totalLoanAmount) {
		this.totalLoanAmount = totalLoanAmount;
	}

	public double getTotalLoanEmiAmount() {
		return totalLoanEmiAmount;
	}

	public void setTotalLoanEmiAmount(double totalLoanEmiAmount) {
		this.totalLoanEmiAmount = totalLoanEmiAmount;
	}

	public double getTotalRdAmount() {
		return totalRdAmount;
	}

	public void setTotalRdAmount(double totalRdAmount) {
		this.totalRdAmount = totalRdAmount;
	}

	public double getTotalAmount() {
		return totalAmount;
	}

	public void setTotalAmount(double totalAmount) {
		this.totalAmount = totalAmount;
	}

	public String getDayOfWeek() {
		return dayOfWeek;
	}

	public void setDayOfWeek(String dayOfWeek) {
		this.dayOfWeek = dayOfWeek;
	}

	public String getStrDisburseDate() {
		return strDisburseDate;
	}

	public void setStrDisburseDate(String strDisburseDate) {
		this.strDisburseDate = strDisburseDate;
	}
	
	
}
