package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DecimalFormat;
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.servlet.http.HttpSession;

import main_package.DataBaseMethods;
import main_package.DataBaseConnection;
import main_package.UserInfo;

@ManagedBean(name="fdDdReportAll")
@ViewScoped

public class FdDdReportAll implements Serializable
{
	private static final long serialVersionUID = 1L;
	ArrayList<UserInfo> list;
	int totalHolders,sno;
	double totalamount,maturityValue;
	String searchType;
	boolean show;
	
	DataBaseReportMethods obj1=new DataBaseReportMethods();
	
	public void view()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection con=DataBaseConnection.JAVAConnection();
		totalamount=maturityValue=0;
		show=true;
		list = obj1.fdDdALlList(branchId,searchType,con);
		totalHolders = list.size();
		for(UserInfo info:list)
		{
			totalamount = totalamount + info.getInstallment_amount();
			maturityValue = maturityValue + info.getMaturity_value();
		}
		
		maturityValue=Double.parseDouble(new DecimalFormat("##.##").format(maturityValue));
		
		try {
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public String print()
	{
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("report", "rdfd");
		ss.setAttribute("rdFdList", list);
		
		return "printRdFdReport";
		
	}
	
	
	public int getSno() {
		return sno;
	}

	public void setSno(int sno) {
		this.sno = sno;
	}

	public double getMaturityValue() {
		return maturityValue;
	}

	public void setMaturityValue(double maturityValue) {
		this.maturityValue = maturityValue;
	}

	public int getTotalHolders() {
		return totalHolders;
	}

	public void setTotalHolders(int totalHolders) {
		this.totalHolders = totalHolders;
	}

	public double getTotalamount() {
		return totalamount;
	}

	public void setTotalamount(double totalamount) {
		this.totalamount = totalamount;
	}

	public ArrayList<UserInfo> getList() {
		return list;
	}

	public void setList(ArrayList<UserInfo> list) {
		this.list = list;
	}

	public String getSearchType() {
		return searchType;
	}

	public void setSearchType(String searchType) {
		this.searchType = searchType;
	}
	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	
	
}
