package other_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
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 main_package.DataBaseMethods;
import main_package.DataBaseConnection;
import main_package.InstallmentInfo;
import main_package.UserInfo;

import org.primefaces.context.RequestContext;

@ManagedBean(name="par_RD_FD_Report")
@ViewScoped
public class RD_FD_ReportParticularBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	UserInfo selectedUser;
	double totalPaid, totalDue;
	ArrayList<InstallmentInfo> list, rdPayList;
	DataBaseMethods obj=new DataBaseMethods();
	ArrayList<ReportInfo> dailyPayList;
	
	public RD_FD_ReportParticularBean()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		selectedUser=(UserInfo) ss.getAttribute("selectedUser");
		// System.out.println("enter1");
	//	list=new DataBaseMethodsParticular().rd_fdReport(selectedUser.getUser_no());
		
		if(selectedUser.getScheme_type().equalsIgnoreCase("FD"))
		{
			list=new ArrayList<>();
			InstallmentInfo ii = new InstallmentInfo();
			double paidAmount = obj.paidAmountByUser(selectedUser.getUser_no(),conn);
			
			ii.setInstallment_amount(selectedUser.getInstallment_amount());
			ii.setPaidAmount(paidAmount);
			ii.setUser_no(selectedUser.getUser_no());
			ii.setSno(1);
			ii.setIns_date(new SimpleDateFormat("dd/MM/yyyy").format(selectedUser.getOffice_date()));
			ii.setInstlmntDate(selectedUser.getOffice_date());
		
			if(paidAmount==selectedUser.getInstallment_amount())
			{
				ii.setStatus("Paid");
			}
			else
			{
				ii.setStatus("Due");
			}
			ii.setTerms(selectedUser.getTerms());
			ii.setCalc_interest(selectedUser.getMaturity_value() - selectedUser.getInstallment_amount());
			ii.setTot_sum(Double.parseDouble(new DecimalFormat("#.##").format(selectedUser.getMaturity_value())));
			
			list.add(ii);
		}
		else
		{
			list=obj.showInstallment(selectedUser.getUser_no(), conn);
		}
		
		/*for(int i=0;i<list.size();i++)
        {
        	list.get(i).setCalc_interest(Double.parseDouble(new DecimalFormat("##.##").format(list.get(i).getCalc_interest())));
        	list.get(i).setTot_sum(Double.parseDouble(new DecimalFormat("##.##").format(list.get(i).getTot_sum())));
        }*/
		 
		totalDue=totalPaid=0;
		for(InstallmentInfo ff: list)
		{
			if(ff.getStatus().equalsIgnoreCase("paid"))
			{
				totalPaid+=ff.getInstallment_amount();
			}
			else
			{
				totalDue+=ff.getInstallment_amount();
			}
		}
		
		totalDue=Double.parseDouble(new DecimalFormat("##.##").format(totalDue));
		totalPaid=Double.parseDouble(new DecimalFormat("##.##").format(totalPaid));
	}
	
	
	public void checkPaidDetail()
	{
		rdPayList=obj.checkRdFdPaidDetailByUserNo(selectedUser.getUser_no());
	}
	
	public void printDailyPay()
	{
		Connection con = DataBaseConnection.JAVAConnection();
		
		dailyPayList= new ArrayList<>();
		// System.out.println(selectedUser.getUser_no());
		// System.out.println(selectedUser.getScheme_type());
		dailyPayList= obj.dailyRDFDReport(selectedUser.getUser_no(),selectedUser.getScheme_type(),con);
		try 
		{
			con.close();
		} 
		catch (Exception e) 
		{
			// TODO: handle exception
		}
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("RDFDailyPayList", dailyPayList);
		ss.setAttribute("selectedUserInfo", selectedUser);
		ss.setAttribute("totalSchDue", totalDue);
		ss.setAttribute("totalSchPaid", totalPaid);
		RequestContext.getCurrentInstance().execute("window.open('printPerticularDateSchemePayment.xhtml')");
		
	}
	
	
	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;
	}
	
	
}
