package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;

import javax.faces.application.FacesMessage;
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 report_package.BranchReportBean.DynamicColumnInfo;
import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.InstallmentInfo;
import main_package.LoanInfo;

@ViewScoped
@ManagedBean(name="centerCardMultiple")
public class CenterCardMultipleBean implements Serializable
{
	ArrayList<SelectItem> centerList, groupNoList;
	String center, centerName, groupNo;
	boolean showData;
	DataBaseMethods dbm=new DataBaseMethods();
	ArrayList<InstallmentInfo> list;
	ArrayList<DynamicColumnInfo> columns;
	ArrayList<LoanInfo> gList;
	double total, totalRd;
	
	public CenterCardMultipleBean() 
	{	
		Connection conn=DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		centerList=dbm.allcenter(branchId,"all",conn);
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void searchGroupNoList()
	{
		groupNoList=dbm.groupNoListCenterCardMultiple(center);
		if(groupNoList.size()==0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Record Found !!!"));
		}
	}
	
	public void searchData()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		list=dbm.emiListForCenterCardMultiple(center, groupNo);
		if(list.size()>0)
		{
			showData=true;
			centerName=dbm.centerNameById(center, conn);
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Record Found !!!"));
		}
		
		gList=dbm.groupMemberDetailForCenterCardMultiple(groupNo);
		
		//System.out.println(itemList.size()+"========="+list.size());
		
		dbm.calculateCenterCardAmount(gList, list, conn);
		
		columns = new ArrayList<DynamicColumnInfo>(); 
		total=totalRd=0;
		for(LoanInfo ll: gList)
		{
			DynamicColumnInfo cc=new DynamicColumnInfo();
			
			cc.setSubLoanNo(ll.getSubLoanNo());
			cc.setLoanAmount(ll.getLoanAmount());
			cc.setName(ll.getName());
			cc.setFhName(ll.getFatherHusbandName());
			cc.setMobileNo(ll.getMobile());
			cc.setEmiAmount(ll.getEmiAmount());
			cc.setDayOfWeek(new SimpleDateFormat("EEEE").format(list.get(0).getEmiPaidDate()));
			cc.setTerms(ll.getTerms());
			cc.setRdEmiAmount(ll.getRdEmiAmtDue());
			totalRd+=cc.getRdEmiAmount();
			total+=cc.getEmiAmount();
			columns.add(cc);
		}
		
		
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	static public class DynamicColumnInfo implements Serializable 
	{
		String name, fhName, loanAmount, mobileNo, subLoanNo, dayOfWeek;
		double emiAmount, rdEmiAmount;
		int terms;
		

		public String getName() {
			return name;
		}

		public void setName(String name) {
			this.name = name;
		}

		public String getFhName() {
			return fhName;
		}

		public void setFhName(String fhName) {
			this.fhName = fhName;
		}

		public String getLoanAmount() {
			return loanAmount;
		}

		public void setLoanAmount(String loanAmount) {
			this.loanAmount = loanAmount;
		}

		public String getMobileNo() {
			return mobileNo;
		}

		public void setMobileNo(String mobileNo) {
			this.mobileNo = mobileNo;
		}

		public String getSubLoanNo() {
			return subLoanNo;
		}

		public void setSubLoanNo(String subLoanNo) {
			this.subLoanNo = subLoanNo;
		}

		public double getEmiAmount() {
			return emiAmount;
		}

		public void setEmiAmount(double emiAmount) {
			this.emiAmount = emiAmount;
		}

		public String getDayOfWeek() {
			return dayOfWeek;
		}

		public void setDayOfWeek(String dayOfWeek) {
			this.dayOfWeek = dayOfWeek;
		}

		public int getTerms() {
			return terms;
		}

		public void setTerms(int terms) {
			this.terms = terms;
		}

		public double getRdEmiAmount() {
			return rdEmiAmount;
		}

		public void setRdEmiAmount(double rdEmiAmount) {
			this.rdEmiAmount = rdEmiAmount;
		}

		
	}

	public ArrayList<SelectItem> getCenterList() {
		return centerList;
	}

	public void setCenterList(ArrayList<SelectItem> centerList) {
		this.centerList = centerList;
	}

	public String getCenter() {
		return center;
	}

	public void setCenter(String center) {
		this.center = center;
	}

	public boolean isShowData() {
		return showData;
	}

	public void setShowData(boolean showData) {
		this.showData = showData;
	}

	public ArrayList<SelectItem> getGroupNoList() {
		return groupNoList;
	}

	public void setGroupNoList(ArrayList<SelectItem> groupNoList) {
		this.groupNoList = groupNoList;
	}

	public String getGroupNo() {
		return groupNo;
	}

	public void setGroupNo(String groupNo) {
		this.groupNo = groupNo;
	}

	public ArrayList<InstallmentInfo> getList() {
		return list;
	}

	public void setList(ArrayList<InstallmentInfo> list) {
		this.list = list;
	}

	public ArrayList<DynamicColumnInfo> getColumns() {
		return columns;
	}

	public void setColumns(ArrayList<DynamicColumnInfo> columns) {
		this.columns = columns;
	}

	public ArrayList<LoanInfo> getgList() {
		return gList;
	}

	public void setgList(ArrayList<LoanInfo> gList) {
		this.gList = gList;
	}

	public String getCenterName() {
		return centerName;
	}

	public void setCenterName(String centerName) {
		this.centerName = centerName;
	}

	public double getTotal() {
		return total;
	}

	public void setTotal(double total) {
		this.total = total;
	}

	public double getTotalRd() {
		return totalRd;
	}

	public void setTotalRd(double totalRd) {
		this.totalRd = totalRd;
	}
}
