package report_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

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 main_package.DataBaseMethods;
import main_package.DataBaseConnection;
import main_package.LoanInfo;

import org.primefaces.context.RequestContext;



@ManagedBean(name="odLoanReport")
@ViewScoped
public class OdLoanReportBean implements Serializable
{
	Date currentDate=new Date();
	ArrayList<LoanInfo> odlist;
	LoanInfo selectedLoan;
	String statusType;
	Date startDate=new Date(),endDate=new Date();
	String type;
	DataBaseMethods obj=new DataBaseMethods();
	double gTotalOfOdLoanAmount,gTotalOfOdLoanInterest,gTotalOfOdLOAnReturnInterest,gTotalOfOdLoanReturnAmount;
	boolean show;
	int branchId;
	String branchUserId;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
		
	public OdLoanReportBean()
	{
		Connection con = DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = new DataBaseMethods().branchList(branchUserId,con);
		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	
	
	
	public void searchReport()
	{
		
		if(branchId != 0)
		{
			Connection conn=DataBaseConnection.JAVAConnection();
			odlist=new DataBaseMethods().odLoanReport(branchId,startDate,endDate,statusType,conn);
			gTotalOfOdLoanAmount =0;
			gTotalOfOdLoanInterest=0;
			gTotalOfOdLoanReturnAmount=0;
			gTotalOfOdLOAnReturnInterest=0;
			for(LoanInfo ll :odlist)
			{
				gTotalOfOdLoanAmount +=ll.getOdAmount();
				gTotalOfOdLoanInterest +=ll.getOdInterest();
				gTotalOfOdLoanReturnAmount +=ll.getOdLoanReturnAmount();
				gTotalOfOdLOAnReturnInterest +=ll.getOdLoanReturnInterest();
			}
			if(odlist.size()>0)
			{
				show=true;
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Record Found !!"));
			}
			try
			{
				conn.close();
			} catch (Exception e) 
			{
				// TODO: handle exception
			}
		}
    	else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
		}
		
	}
	
	public void viewOdLoan() throws IOException
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("selectedLoan", selectedLoan);
		RequestContext.getCurrentInstance().execute("window.open('viewOdLoan.xhtml')");
	}
	
	
	public void printWhole()
	{
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("list", odlist);
		RequestContext.getCurrentInstance().execute("window.open('printOdLoanReport.xhtml')");

	}

	

	public String getType() {
		return type;
	}

	public void setType(String type) {
		this.type = type;
	}

	public ArrayList<LoanInfo> getOdlist() {
		return odlist;
	}

	public void setOdlist(ArrayList<LoanInfo> odlist) {
		this.odlist = odlist;
	}

	public LoanInfo getSelectedLoan() {
		return selectedLoan;
	}

	public void setSelectedLoan(LoanInfo selectedLoan) {
		this.selectedLoan = selectedLoan;
	}

	public Date getCurrentDate() {
		return currentDate;
	}

	public void setCurrentDate(Date currentDate) {
		this.currentDate = currentDate;
	}

	public String getStatusType() {
		return statusType;
	}

	public void setStatusType(String statusType) {
		this.statusType = statusType;
	}

	public Date getStartDate() {
		return startDate;
	}

	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}

	public Date getEndDate() {
		return endDate;
	}

	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	public double getgTotalOfOdLoanAmount() {
		return gTotalOfOdLoanAmount;
	}

	public void setgTotalOfOdLoanAmount(double gTotalOfOdLoanAmount) {
		this.gTotalOfOdLoanAmount = gTotalOfOdLoanAmount;
	}

	public double getgTotalOfOdLoanInterest() {
		return gTotalOfOdLoanInterest;
	}

	public void setgTotalOfOdLoanInterest(double gTotalOfOdLoanInterest) {
		this.gTotalOfOdLoanInterest = gTotalOfOdLoanInterest;
	}

	public double getgTotalOfOdLOAnReturnInterest() {
		return gTotalOfOdLOAnReturnInterest;
	}

	public void setgTotalOfOdLOAnReturnInterest(double gTotalOfOdLOAnReturnInterest) {
		this.gTotalOfOdLOAnReturnInterest = gTotalOfOdLOAnReturnInterest;
	}

	public double getgTotalOfOdLoanReturnAmount() {
		return gTotalOfOdLoanReturnAmount;
	}

	public void setgTotalOfOdLoanReturnAmount(double gTotalOfOdLoanReturnAmount) {
		this.gTotalOfOdLoanReturnAmount = gTotalOfOdLoanReturnAmount;
	}
	public int getBranchId() {
		return branchId;
	}

	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}

	public List<SelectItem> getBranchList() {
		return branchList;
	}

	public void setBranchList(List<SelectItem> branchList) {
		this.branchList = branchList;
	}
	
}
