package other_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.DecimalFormat;
import java.util.ArrayList;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

import report_package.DataBaseReportMethods;
import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.InstallmentInfo;
import main_package.UserInfo;

@ManagedBean(name="par_RD_FD_Report_closer")
@ViewScoped
public class RD_FD_CloserReportsBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	UserInfo selectedUser;
	double totalPaid, totalDue, totalAmount, rdReturnAmt, fdReturnAmt;
	ArrayList<InstallmentInfo> list, rdPayList, payList;
	UserInfo info;
	String amountInwords, matPayMode;
	
	public RD_FD_CloserReportsBean()
	{  
		Connection conn=DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		selectedUser=(UserInfo) ss.getAttribute("selectedUser");
		list=new DataBaseMethodsOther().rd_fdReport(selectedUser.getUser_no());
		info=new DataBaseMethods().userInfoByShareHolderNo(selectedUser.getShareHolderNo(), conn);
		
		
		totalDue=totalPaid=0;
		payList=new ArrayList<>();
		for(InstallmentInfo ff: list)
		{
			if(ff.getStatus().equalsIgnoreCase("paid"))
			{
				totalPaid+=ff.getInstallment_amount();
				payList.add(ff);
			}
			else
			{
				totalDue+=ff.getInstallment_amount();
			}
		}
		
		totalDue=Double.parseDouble(new DecimalFormat("##.##").format(totalDue));
		totalPaid=Double.parseDouble(new DecimalFormat("##.##").format(totalPaid));
	
		if(selectedUser.getUser_no().contains("NMDS"))
		{
			rdReturnAmt=selectedUser.getMaturity_value();
		}
		else 
		{
			fdReturnAmt=selectedUser.getMaturity_value();
		}
		
		matPayMode=new DataBaseMethods().maturityPaymentMode(selectedUser.getUser_no());
		totalAmount=/*info.getTotalAmount()+*/selectedUser.getMaturity_value();
		amountInwords=new DataBaseReportMethods().numberToWords(Integer.parseInt(new DecimalFormat("##").format(totalAmount))).toUpperCase();
	
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	
	public void checkPaidDetail()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		rdPayList=new DataBaseMethods().checkRdFdPaidDetailByUserNo(selectedUser.getUser_no());
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public String backButton()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		String pageName=(String) ss.getAttribute("pageName");
		return pageName;
	}
	
	public String printReport()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("selectedUser",selectedUser);
		return "printParticularRd_FdReport.xhtml";
	}
	
	
	
	public UserInfo getSelectedUser() {
		return selectedUser;
	}

	public void setSelectedUser(UserInfo selectedUser) {
		this.selectedUser = selectedUser;
	}
	public ArrayList<InstallmentInfo> getList() {
		return list;
	}
	public void setList(ArrayList<InstallmentInfo> list) {
		this.list = list;
	}


	public ArrayList<InstallmentInfo> getRdPayList() {
		return rdPayList;
	}


	public void setRdPayList(ArrayList<InstallmentInfo> rdPayList) {
		this.rdPayList = rdPayList;
	}


	public double getTotalPaid() {
		return totalPaid;
	}


	public void setTotalPaid(double totalPaid) {
		this.totalPaid = totalPaid;
	}


	public double getTotalDue() {
		return totalDue;
	}


	public void setTotalDue(double totalDue) {
		this.totalDue = totalDue;
	}


	public ArrayList<InstallmentInfo> getPayList() {
		return payList;
	}


	public void setPayList(ArrayList<InstallmentInfo> payList) {
		this.payList = payList;
	}


	public UserInfo getInfo() {
		return info;
	}


	public void setInfo(UserInfo info) {
		this.info = info;
	}


	public double getTotalAmount() {
		return totalAmount;
	}


	public void setTotalAmount(double totalAmount) {
		this.totalAmount = totalAmount;
	}


	public String getAmountInwords() {
		return amountInwords;
	}


	public void setAmountInwords(String amountInwords) {
		this.amountInwords = amountInwords;
	}


	public double getRdReturnAmt() {
		return rdReturnAmt;
	}


	public void setRdReturnAmt(double rdReturnAmt) {
		this.rdReturnAmt = rdReturnAmt;
	}


	public double getFdReturnAmt() {
		return fdReturnAmt;
	}


	public void setFdReturnAmt(double fdReturnAmt) {
		this.fdReturnAmt = fdReturnAmt;
	}


	public String getMatPayMode() {
		return matPayMode;
	}


	public void setMatPayMode(String matPayMode) {
		this.matPayMode = matPayMode;
	}
	
	
}
