package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.SimpleDateFormat;
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.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.LoanInfo;
import org.primefaces.context.RequestContext;

@ManagedBean(name="loanSummaryReport")
@ViewScoped
public class LoanSummaryReportBean implements Serializable
{
	ArrayList<LoanInfo> list,selectedAdvanceList,selectedDueList;
	String loanType,selectPenalty,selectLoan;
	double totalamount, totalPrincipalPaid, totalIntrestPaid, totalPrincipalBalance, totalPaid,grandTotalOfDueAmount,grandTotalOfAmount,grandTotalOfmonthAmount,grandTotalOfPenalty,grandTotalOFAdvanceAmount,grandTotalOFDueInPaidAmount;
	int totalLoan;
	boolean show,showForCheckButton,showPenalty;
	LoanInfo selectedLoan;
	DataBaseReportMethods obj1=new DataBaseReportMethods();
	Date startDate=new Date();
	int branchId;
	String branchUserId;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	
	public LoanSummaryReportBean()
	{

    	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)
		{
			grandTotalOfAmount=0;
			grandTotalOfDueAmount=0;
			grandTotalOfmonthAmount=0;
			grandTotalOfPenalty=0;
			double aa=0;
			double bb=0;
			Connection conn=DataBaseConnection.JAVAConnection();
			
			if(selectLoan.equals("All"))
			 {
					
				list = obj1.loanSummaryList(branchId,startDate, conn,selectPenalty);
				for(LoanInfo jj :list)
				{
					if(new SimpleDateFormat("dd/MM/yyyy").format(startDate).equals((new SimpleDateFormat("dd/MM/yyyy").format(new Date()))))
					{
							grandTotalOfAmount=0.0;
					}
					else
					{
						grandTotalOfDueAmount +=jj.getDueAmount();
						grandTotalOfmonthAmount +=jj.getDuePaidAmountinMonth();
							bb +=jj.getDueInPaidAmount()+jj.getClearAmount();
							aa +=jj.getAmount();
							grandTotalOfAmount =((aa+grandTotalOfDueAmount+grandTotalOfmonthAmount)-(bb));
						
					}
					grandTotalOfDueAmount +=jj.getDueAmount();
					grandTotalOfmonthAmount +=jj.getMonthAmount();
					if(selectPenalty.equals("withPenalty"))
					{
						if(jj.getPenaltyAmount().equals(""))
						{
							jj.setPenaltyAmount("0");
						}
						grandTotalOfPenalty +=Double.valueOf(jj.getPenaltyAmount());
					}
					
				}
				if(list.size()>0)
				{
					show=true;
					totalLoan=list.size();
					
				}
				else
				{
					show=false;
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Record Found"));
				}
				showForCheckButton=false;
			}
			else if(selectLoan.equals("datewise"))
			{
				if(selectPenalty.equals("withPenalty"))
				{
					showPenalty=true;
				}
				else
				{
					showPenalty=false;
				}
				showForCheckButton=true;
				list = obj1.loanSummaryDateWise(branchId,startDate, conn,selectPenalty);
				for(LoanInfo tt:list)
				{
					grandTotalOfPenalty +=tt.getPenaltyDue();
					grandTotalOfDueAmount +=tt.getDueAmount();
					grandTotalOfmonthAmount +=tt.getDuePaidAmountinMonth();
						bb +=tt.getDueInPaidAmount()+tt.getClearAmount();
						aa +=tt.getAmount();
						grandTotalOfAmount =((aa+grandTotalOfDueAmount)-(bb));
					
				}
				if(list.size()>0)
				{
					show=true;
					totalLoan=list.size();
					
				}
				else
				{
					show=false;
					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 selectedLoanReport()
	{
		if(branchId != 0)
		{
			grandTotalOfAmount =0;
			grandTotalOFAdvanceAmount=0;
			grandTotalOFDueInPaidAmount=0;
			Connection conn=DataBaseConnection.JAVAConnection();
			list = obj1.loanSummaryDateWise(branchId,startDate, conn,selectPenalty);
			for(LoanInfo nn:list)
			{
				
				
					grandTotalOfAmount +=nn.getDueAmount();
				
			
			}
			selectedDueList=obj1.selectedLoanSummaryForduePayment(branchId,startDate, conn, selectPenalty);
			for(LoanInfo ll : selectedDueList)
			{
				grandTotalOFDueInPaidAmount +=ll.getDueInPaidAmount();
			}
			
			selectedAdvanceList=obj1.selectedLoanSummaryForAdvance(branchId,startDate, conn, selectPenalty);
			for(LoanInfo ll : selectedAdvanceList)
			{
				grandTotalOFAdvanceAmount +=ll.getAmount();
			
				
			}
			System.out.println(grandTotalOfAmount);
			grandTotalOFAdvanceAmount=grandTotalOFAdvanceAmount+grandTotalOfAmount;
					
					try {
						conn.close();
					} catch (Exception e) {
						// TODO: handle exception
					}
		}
    	else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
		}
		
	}
	
	public void printWhole()
	{
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("grandTotalOfPenalty", grandTotalOfPenalty);
		ss.setAttribute("grandTotalOfAmount", grandTotalOfAmount);
		ss.setAttribute("grandTotalOfDueAmount", grandTotalOfDueAmount);
		ss.setAttribute("grandTotalOfmonthAmount", grandTotalOfmonthAmount);
		ss.setAttribute("selectPenalty", selectPenalty);
		ss.setAttribute("list", list);
		
		RequestContext.getCurrentInstance().execute("window.open('PrintLoanSummaryReport.xhtml')");

	}
	
	
	public int getTotalLoan() {
		return totalLoan;
	}

	public void setTotalLoan(int totalLoan) {
		this.totalLoan = totalLoan;
	}


	public String getLoanType() {
		return loanType;
	}


	public void setLoanType(String loanType) {
		this.loanType = loanType;
	}


	public double getTotalamount() {
		return totalamount;
	}


	public void setTotalamount(double totalamount) {
		this.totalamount = totalamount;
	}


	public double getTotalPrincipalPaid() {
		return totalPrincipalPaid;
	}


	public void setTotalPrincipalPaid(double totalPrincipalPaid) {
		this.totalPrincipalPaid = totalPrincipalPaid;
	}


	public double getTotalIntrestPaid() {
		return totalIntrestPaid;
	}


	public void setTotalIntrestPaid(double totalIntrestPaid) {
		this.totalIntrestPaid = totalIntrestPaid;
	}


	public double getTotalPrincipalBalance() {
		return totalPrincipalBalance;
	}


	public void setTotalPrincipalBalance(double totalPrincipalBalance) {
		this.totalPrincipalBalance = totalPrincipalBalance;
	}


	public double getTotalPaid() {
		return totalPaid;
	}


	public void setTotalPaid(double totalPaid) {
		this.totalPaid = totalPaid;
	}


	public boolean isShow() {
		return show;
	}


	public void setShow(boolean show) {
		this.show = show;
	}

	public LoanInfo getSelectedLoan() {
		return selectedLoan;
	}

	public void setSelectedLoan(LoanInfo selectedLoan) {
		this.selectedLoan = selectedLoan;
	}

	

	public Date getStartDate() {
		return startDate;
	}

	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}

	

	public ArrayList<LoanInfo> getList() {
		return list;
	}

	public void setList(ArrayList<LoanInfo> list) {
		this.list = list;
	}



	public double getGrandTotalOfDueAmount() {
		return grandTotalOfDueAmount;
	}



	public void setGrandTotalOfDueAmount(double grandTotalOfDueAmount) {
		this.grandTotalOfDueAmount = grandTotalOfDueAmount;
	}



	public double getGrandTotalOfAmount() {
		return grandTotalOfAmount;
	}



	public void setGrandTotalOfAmount(double grandTotalOfAmount) {
		this.grandTotalOfAmount = grandTotalOfAmount;
	}



	public double getGrandTotalOfmonthAmount() {
		return grandTotalOfmonthAmount;
	}



	public void setGrandTotalOfmonthAmount(double grandTotalOfmonthAmount) {
		this.grandTotalOfmonthAmount = grandTotalOfmonthAmount;
	}



	public String getSelectPenalty() {
		return selectPenalty;
	}



	public void setSelectPenalty(String selectPenalty) {
		this.selectPenalty = selectPenalty;
	}



	public double getGrandTotalOfPenalty() {
		return grandTotalOfPenalty;
	}



	public void setGrandTotalOfPenalty(double grandTotalOfPenalty) {
		this.grandTotalOfPenalty = grandTotalOfPenalty;
	}



	public String getSelectLoan() {
		return selectLoan;
	}



	public void setSelectLoan(String selectLoan) {
		this.selectLoan = selectLoan;
	}

	public ArrayList<LoanInfo> getSelectedAdvanceList() {
		return selectedAdvanceList;
	}

	public void setSelectedAdvanceList(ArrayList<LoanInfo> selectedAdvanceList) {
		this.selectedAdvanceList = selectedAdvanceList;
	}

	public ArrayList<LoanInfo> getSelectedDueList() {
		return selectedDueList;
	}

	public void setSelectedDueList(ArrayList<LoanInfo> selectedDueList) {
		this.selectedDueList = selectedDueList;
	}

	public double getGrandTotalOFAdvanceAmount() {
		return grandTotalOFAdvanceAmount;
	}

	public void setGrandTotalOFAdvanceAmount(double grandTotalOFAdvanceAmount) {
		this.grandTotalOFAdvanceAmount = grandTotalOFAdvanceAmount;
	}

	public double getGrandTotalOFDueInPaidAmount() {
		return grandTotalOFDueInPaidAmount;
	}

	public void setGrandTotalOFDueInPaidAmount(double grandTotalOFDueInPaidAmount) {
		this.grandTotalOFDueInPaidAmount = grandTotalOFDueInPaidAmount;
	}

	public boolean isShowForCheckButton() {
		return showForCheckButton;
	}

	public void setShowForCheckButton(boolean showForCheckButton) {
		this.showForCheckButton = showForCheckButton;
	}

	public boolean isShowPenalty() {
		return showPenalty;
	}

	public void setShowPenalty(boolean showPenalty) {
		this.showPenalty = showPenalty;
	}
	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;
	}

}
