package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.Timestamp;
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.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.HeaderBean;

@ManagedBean(name="memberOdReport")
@ViewScoped

public class MembersOurstandingReportBean implements Serializable
{
	int totalEntry;
	Date searchDate=new Date();
	ArrayList<MembersOdInfo> list;
	boolean show;
	double totalLoan, totalShare, totalRd, totalFd, totalDds, totalSaving, totalGd, totalMis, totalDepositBalance, grandTotalBalance;
	String strDate, memberType, dsaCode;
	ArrayList<SelectItem>  dsaList;
	DecimalFormat df=new DecimalFormat("##.##");
	
	public MembersOurstandingReportBean() 
	{
		Connection con = DataBaseConnection.JAVAConnection();
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		
		dsaList=new DataBaseMethods().allDsaList(branchId,"Loan",con);
		
		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void searchReport()
	{
		System.out.println("method hit");
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		totalLoan=totalShare=totalRd=totalFd=totalDds=totalSaving=totalMis=totalGd=0;
		//strDate=new SimpleDateFormat("dd_MM_yyyy").format(searchDate);
		HeaderBean hh=new HeaderBean();
		String sDate=hh.getStartFinYear()+"-04-01";
		
		System.out.println("Time 1 : "+new Timestamp(new Date().getTime()));
		
		list=new DataBaseReportMethods().outstandingListOfAllMember(branchId,sDate, searchDate, dsaCode);
		for(MembersOdInfo mm: list)
		{
			totalLoan+=mm.getLoanBalance();
			totalDds+=mm.getDdsBalance();
			totalRd+=mm.getRdBalance();
			totalFd+=mm.getFdBalance();
			totalShare+=mm.getShareBalance();
			totalSaving+=mm.getSavingBalance();
			totalMis+=mm.getMisBalance();
			totalDepositBalance+=mm.getTotalDepositBalance();
			grandTotalBalance+=mm.getGrandTotalBalance();
		}
		totalLoan=Double.parseDouble(df.format(totalLoan));
		totalDds=Double.parseDouble(df.format(totalDds));
		totalRd=Double.parseDouble(df.format(totalRd));
		totalFd=Double.parseDouble(df.format(totalFd));
		totalShare=Double.parseDouble(df.format(totalShare));
		totalSaving=Double.parseDouble(df.format(totalSaving));
		
		totalMis=Double.parseDouble(df.format(totalMis));
		totalDepositBalance=Double.parseDouble(df.format(totalDepositBalance));
		grandTotalBalance=Double.parseDouble(df.format(grandTotalBalance));
		
		totalEntry=list.size();
		show=true;
	}

	public int getTotalEntry() {
		return totalEntry;
	}

	public void setTotalEntry(int totalEntry) {
		this.totalEntry = totalEntry;
	}

	public Date getSearchDate() {
		return searchDate;
	}

	public void setSearchDate(Date searchDate) {
		this.searchDate = searchDate;
	}

	public ArrayList<MembersOdInfo> getList() {
		return list;
	}

	public void setList(ArrayList<MembersOdInfo> list) {
		this.list = list;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	public double getTotalLoan() {
		return totalLoan;
	}

	public void setTotalLoan(double totalLoan) {
		this.totalLoan = totalLoan;
	}

	public double getTotalShare() {
		return totalShare;
	}

	public void setTotalShare(double totalShare) {
		this.totalShare = totalShare;
	}

	public double getTotalRd() {
		return totalRd;
	}

	public void setTotalRd(double totalRd) {
		this.totalRd = totalRd;
	}

	public double getTotalFd() {
		return totalFd;
	}

	public void setTotalFd(double totalFd) {
		this.totalFd = totalFd;
	}

	public double getTotalDds() {
		return totalDds;
	}

	public void setTotalDds(double totalDds) {
		this.totalDds = totalDds;
	}

	public String getStrDate() {
		return strDate;
	}

	public void setStrDate(String strDate) {
		this.strDate = strDate;
	}

	public double getTotalSaving() {
		return totalSaving;
	}

	public void setTotalSaving(double totalSaving) {
		this.totalSaving = totalSaving;
	}

	public String getMemberType() {
		return memberType;
	}

	public void setMemberType(String memberType) {
		this.memberType = memberType;
	}

	public double getTotalGd() {
		return totalGd;
	}

	public void setTotalGd(double totalGd) {
		this.totalGd = totalGd;
	}

	public double getTotalMis() {
		return totalMis;
	}

	public void setTotalMis(double totalMis) {
		this.totalMis = totalMis;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	public double getTotalDepositBalance() {
		return totalDepositBalance;
	}

	public void setTotalDepositBalance(double totalDepositBalance) {
		this.totalDepositBalance = totalDepositBalance;
	}

	public double getGrandTotalBalance() {
		return grandTotalBalance;
	}

	public void setGrandTotalBalance(double grandTotalBalance) {
		this.grandTotalBalance = grandTotalBalance;
	}
	
	
}
