package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.text.DecimalFormat;
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;

@ManagedBean(name="depositReport")
@ViewScoped

public class DepositsReportBean implements Serializable
{
	DataBaseMethods obj=new DataBaseMethods();
	double fdBalance,rdBalance,ddBalance,savingsBalance,otherBalance,totalBalance;
	double preReceivedFD,preReceivedRD,preReceivedDD,preReceivedSavings,preReceivedOther;
	double preRepaidFD,preRepaidRD,preRepaidDD,preRepaidSavings,preRepaidOther;
	double receivedFD,receivedRD,receivedDD,receivedSavings,receivedOther,totalReceived;
	double repaidFD,repaidRD,repaidDD,repaidSavings,repaidOther,totalRepaid,endFD,endRD,endDD,endSavings,endOther,totalEnd;
	//***************************************************************************
	double proBalance,jewelBalance,depositBalance,otherLoanBalance,employeeBalance,totalLoanBalance;
	double receivedPro,receivedJewel,receivedDeposit,receivedOtherLoan,preReceivedOtherLoan,receivedEmployee,totalReceivedLoan;
	double disbursedPro,disbursedJewel,disbursedDeposit,disbursedOther,preDisbursedOther,disbursedEmployee,totalDisbursed;
	double endPro,endJewel,endDeposit,endEmployee,endOtherLoan,totalLoanEnd;
	//***************************************************************************
	Date startDate,endDate,preStart,preEnd;
	boolean show;
	ArrayList<UserInfo> rdList;
	ArrayList<LoanInfo> pList,prList,vList,gList,loanList,installmentList,finalLoanList;
	ArrayList<InstallmentInfo> finalList,templList;
	String stdt,enddt;
	DecimalFormat df=new DecimalFormat("##.##");
	int branchId;
	String branchUserId;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	int openingMember, addMember, lessMember, closingMember;
	
	
	
	public DepositsReportBean() 
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection con = DataBaseConnection.JAVAConnection();
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = new DataBaseMethods().branchList(branchUserId,con);
		preStart = new Date();
		preEnd = new Date();
		rdList = obj.showRDUser(branchId);
		
		try 
		{
			con.close();
		} 
		catch (Exception e) 
		{
			// TODO: handle exception
		}
	}
	
	
	
	public void showReport()
	{
		System.out.println("method i=hit");
		if(branchId != 0)
		{
			Connection conn=DataBaseConnection.JAVAConnection();
			if(endDate.before(startDate))
			{
				show=false;
				FacesContext.getCurrentInstance().addMessage(null, 
												new FacesMessage("Enter Dates Carefully! End Date can't be after statr date."));
			}
			else
			{
				stdt=new SimpleDateFormat("dd/MM/yyyy").format(startDate);
				enddt=new SimpleDateFormat("dd/MM/yyyy").format(endDate);
				
				
				preStart.setDate(1);preStart.setMonth(10);preStart.setYear(115);
				preEnd=new Date(startDate.getTime()-1);
				
				
				preReceivedFD=obj.totalFDAmountTaken(branchId,preStart, preEnd);
				preRepaidFD=obj.totalDDRDFDAmountReturnSchemeTypeWise(branchId,preStart, preEnd, "FD", conn);
				
				
				receivedFD=obj.totalFDAmountTaken(branchId,startDate, endDate);
				repaidFD=obj.totalDDRDFDAmountReturnSchemeTypeWise(branchId,startDate, endDate, "FD", conn);
				
				
				fdBalance=preReceivedFD-preRepaidFD;
				endFD=fdBalance+receivedFD-repaidFD;
				//********************************************************************************************************************
				//rdBalance=checkRDBalance(startDate,endDate);
				
				
				preReceivedRD=obj.totalDDRDAmountTaken(branchId,preStart, preEnd, "RD");
				preRepaidRD=obj.totalDDRDFDAmountReturnSchemeTypeWise(branchId,preStart, preEnd, "RD", conn);
				
				
				receivedRD=obj.totalDDRDAmountTaken(branchId,startDate, endDate, "RD");
				repaidRD=obj.totalDDRDFDAmountReturnSchemeTypeWise(branchId,startDate, endDate, "RD", conn);
				
				
				rdBalance=preReceivedRD-preRepaidRD;
				endRD=rdBalance+receivedRD-repaidRD;
				
				
				
				//********************************************************************************************************************
				//DD Detail
				preReceivedDD=obj.totalDDRDAmountTaken(branchId,preStart, preEnd, "DD");
				preRepaidDD=obj.totalDDRDFDAmountReturnSchemeTypeWise(branchId,preStart, preEnd, "DD", conn);
				
				
				receivedDD=obj.totalDDRDAmountTaken(branchId,startDate, endDate, "DD");
				repaidDD=obj.totalDDRDFDAmountReturnSchemeTypeWise(branchId,startDate, endDate, "DD", conn);
				
				
				ddBalance=preReceivedDD-preRepaidDD;
				endDD=ddBalance+receivedDD-repaidDD;
				//********************************************************************************************************************
				preReceivedSavings=obj.totalDepositedAmount(branchId,preStart,preEnd,conn);
				preRepaidSavings=obj.totalWithdrawlAmount(branchId,preStart,preEnd,conn);
				
				
				receivedSavings=obj.totalDepositedAmount(branchId,startDate,endDate,conn);
				repaidSavings=obj.totalWithdrawlAmount(branchId,startDate,endDate,conn);
				
				
				savingsBalance=preReceivedSavings-preRepaidSavings;
				endSavings=savingsBalance+receivedSavings-repaidSavings;
				endSavings=Double.parseDouble(df.format(endSavings));
				//********************************************************************************************************************
				totalReceived=receivedFD+receivedRD+receivedDD+receivedSavings+receivedOther;
				totalRepaid=repaidFD+repaidRD+repaidDD+repaidSavings+repaidOther;
				totalEnd=endFD+endRD+endDD+endSavings+endOther;
				totalBalance=fdBalance+rdBalance+ddBalance+savingsBalance+otherBalance;
				//********************************************************************************************************************
				//otherLoanBalance=checkLoanBalance(startDate,endDate);
				
				
				preDisbursedOther=obj.totalLoanAmount(branchId,preStart, preEnd);
				preReceivedOtherLoan=obj.totalLoanPrinciple(branchId,preStart, preEnd);
				
				
				disbursedOther=Double.parseDouble(df.format(obj.totalLoanAmount(branchId,startDate, endDate)));
				receivedOtherLoan=Double.parseDouble(df.format(obj.totalLoanPrinciple(branchId,startDate, endDate)));
				
				
				otherLoanBalance=preDisbursedOther-preReceivedOtherLoan;
				otherLoanBalance=Double.parseDouble(df.format(otherLoanBalance));
				endOtherLoan=Double.parseDouble(df.format(otherLoanBalance+disbursedOther-receivedOtherLoan));
				//********************************************************************************************************************
				totalLoanBalance=proBalance+jewelBalance+depositBalance+otherLoanBalance+employeeBalance;
				totalDisbursed=disbursedPro+disbursedJewel+disbursedDeposit+disbursedOther+disbursedEmployee;
				totalReceivedLoan=receivedPro+receivedJewel+receivedDeposit+receivedOtherLoan+receivedEmployee;
				totalLoanEnd=endPro+endJewel+endDeposit+endOtherLoan+endEmployee;
				
				//********************************************************************************************************************
				// Member Detail add for NDH-3 Monthly Report dated on ....   09 March 2020
				
				openingMember= obj.openingTotalMemberForNdh(startDate,branchId,conn);
				addMember= obj.addMemberBetweenForNdh(startDate,endDate,branchId,conn);
				closingMember=openingMember+addMember;
								
				try 
				{
					conn.close();
				} 
				catch (Exception e) 
				{
					// TODO: handle exception
				}
				show=true;
			}
		}
    	else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
		}	
	}
	
	
	
	public double checkLoanBalance(Date startDate2, Date endDate2) 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		
		finalLoanList=new ArrayList<>();
		String loanType="",loanNo="";
		loanList=new ArrayList<>();
		double dueAmount=0;
		Timestamp sttdt=new Timestamp(startDate2.getTime());sttdt.setHours(0);sttdt.setMinutes(0);sttdt.setSeconds(0);sttdt.setNanos(0);
		Timestamp enndt=new Timestamp(endDate2.getTime());enndt.setHours(0);enndt.setMinutes(0);enndt.setSeconds(0);enndt.setNanos(0);
		
		pList = obj.personalLoanList(branchId,"All","All","-1","");
		prList = obj.propertyLoanList(branchId,"All");
		vList = obj.vehicleLoanList(branchId,"All");
		gList = obj.groupLoanList(branchId,"All");
		
		loanList.addAll(pList);
		loanList.addAll(prList);
		loanList.addAll(vList);
		loanList.addAll(gList);
		
		for(LoanInfo ll : loanList)
		{
			if(ll.getLoanType().equals("Personal Loan"))
			{
				loanType="personalloan";
				loanNo=ll.getLoanNo();
			}
			else if(ll.getLoanType().equals("Vehicle Loan"))
			{
				loanType="vechicleloan";
				loanNo=ll.getLoanNo();
			}
			else if(ll.getLoanType().equals("Property Loan"))
			{
				loanType="propertyloan";
				loanNo=ll.getLoanNo();
			}
			else if(ll.getLoanType().equals("Group Loan"))
			{
				loanType="grouploan";
				loanNo=ll.getLoanNo();
			}
			else if(ll.getLoanType().equals("Secure Loan"))
			{
				loanType="secure_loan";
				loanNo=ll.getLoanNo();
			}
			
			else if(ll.getLoanType().equals("Business Loan"))
			{
				loanType="business_loan";
				loanNo=ll.getLoanNo();
			}
			
			installmentList=obj.loanInstallment(loanType, loanNo, conn);
			finalLoanList.addAll(installmentList);	
		}
		
		for(LoanInfo info : finalLoanList)
		{
			if((info.getInstallDate().after(sttdt) || info.getInstallDate().equals(sttdt)) && 
			   (info.getInstallDate().before(enndt) || info.getInstallDate().equals(enndt)) && info.getStatus().equals("Due"))
			{
				dueAmount+=(Double.valueOf(info.getPrincipalAmount()));
			}
		}
		
		try 
		{
			conn.close();
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		
		return Double.parseDouble(df.format(dueAmount));
	}
    
	public double checkRDBalance(Date start, Date end)
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		finalList=new ArrayList<>();
		Timestamp strdt=new Timestamp(start.getTime());strdt.setHours(0);strdt.setMinutes(0);strdt.setSeconds(0);strdt.setNanos(0);
		Timestamp endt=new Timestamp(end.getTime());endt.setHours(0);endt.setMinutes(0);endt.setSeconds(0);endt.setNanos(0);
		double amount=0;
		for(UserInfo uu : rdList)
		{
			templList=obj.showInstallment(uu.getUser_no(),conn);
			finalList.addAll(templList);
		}
		
		for(InstallmentInfo ii : finalList)
		{
			if((ii.getInstlmntDate().after(strdt) || ii.getInstlmntDate().equals(strdt)) && 
					(ii.getInstlmntDate().before(endt) || ii.getInstlmntDate().equals(endt))/* && ii.getStatus().equals("Due")*/)
			{
				amount+=(ii.getInstallment_amount()-ii.getPaidAmount());
			}
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
		return amount;
	}

	public boolean isShow() {
		return show;
	}
	public void setShow(boolean show) {
		this.show = show;
	}
	public double getFdBalance() {
		return fdBalance;
	}

	public void setFdBalance(double fdBalance) {
		this.fdBalance = fdBalance;
	}

	public double getRdBalance() {
		return rdBalance;
	}

	public void setRdBalance(double rdBalance) {
		this.rdBalance = rdBalance;
	}

	public double getSavingsBalance() {
		return savingsBalance;
	}

	public void setSavingsBalance(double savingsBalance) {
		this.savingsBalance = savingsBalance;
	}

	public double getOtherBalance() {
		return otherBalance;
	}

	public void setOtherBalance(double otherBalance) {
		this.otherBalance = otherBalance;
	}

	public double getTotalBalance() {
		return totalBalance;
	}

	public void setTotalBalance(double totalBalance) {
		this.totalBalance = totalBalance;
	}

	public double getReceivedFD() {
		return receivedFD;
	}

	public void setReceivedFD(double receivedFD) {
		this.receivedFD = receivedFD;
	}

	public double getReceivedRD() {
		return receivedRD;
	}

	public void setReceivedRD(double receivedRD) {
		this.receivedRD = receivedRD;
	}

	public double getReceivedSavings() {
		return receivedSavings;
	}

	public void setReceivedSavings(double receivedSavings) {
		this.receivedSavings = receivedSavings;
	}

	public double getReceivedOther() {
		return receivedOther;
	}

	public void setReceivedOther(double receivedOther) {
		this.receivedOther = receivedOther;
	}

	public double getTotalReceived() {
		return totalReceived;
	}

	public void setTotalReceived(double totalReceived) {
		this.totalReceived = totalReceived;
	}

	public double getRepaidFD() {
		return repaidFD;
	}

	public void setRepaidFD(double repaidFD) {
		this.repaidFD = repaidFD;
	}

	public double getRepaidRD() {
		return repaidRD;
	}

	public void setRepaidRD(double repaidRD) {
		this.repaidRD = repaidRD;
	}

	public double getRepaidSavings() {
		return repaidSavings;
	}

	public void setRepaidSavings(double repaidSavings) {
		this.repaidSavings = repaidSavings;
	}

	public double getRepaidOther() {
		return repaidOther;
	}

	public void setRepaidOther(double repaidOther) {
		this.repaidOther = repaidOther;
	}

	public double getTotalRepaid() {
		return totalRepaid;
	}

	public void setTotalRepaid(double totalRepaid) {
		this.totalRepaid = totalRepaid;
	}

	public double getEndFD() {
		return endFD;
	}

	public void setEndFD(double endFD) {
		this.endFD = endFD;
	}

	public double getEndRD() {
		return endRD;
	}

	public void setEndRD(double endRD) {
		this.endRD = endRD;
	}

	public double getEndSavings() {
		return endSavings;
	}

	public void setEndSavings(double endSavings) {
		this.endSavings = endSavings;
	}

	public double getEndOther() {
		return endOther;
	}

	public void setEndOther(double endOther) {
		this.endOther = endOther;
	}

	public double getTotalEnd() {
		return totalEnd;
	}

	public void setTotalEnd(double totalEnd) {
		this.totalEnd = totalEnd;
	}

	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 String getStdt() {
		return stdt;
	}

	public void setStdt(String stdt) {
		this.stdt = stdt;
	}

	public String getEnddt() {
		return enddt;
	}

	public void setEnddt(String enddt) {
		this.enddt = enddt;
	}

	public double getProBalance() {
		return proBalance;
	}

	public void setProBalance(double proBalance) {
		this.proBalance = proBalance;
	}

	public double getJewelBalance() {
		return jewelBalance;
	}

	public void setJewelBalance(double jewelBalance) {
		this.jewelBalance = jewelBalance;
	}

	public double getDepositBalance() {
		return depositBalance;
	}

	public void setDepositBalance(double depositBalance) {
		this.depositBalance = depositBalance;
	}

	public double getOtherLoanBalance() {
		return otherLoanBalance;
	}

	public void setOtherLoanBalance(double otherLoanBalance) {
		this.otherLoanBalance = otherLoanBalance;
	}

	public double getEmployeeBalance() {
		return employeeBalance;
	}

	public void setEmployeeBalance(double employeeBalance) {
		this.employeeBalance = employeeBalance;
	}

	public double getTotalLoanBalance() {
		return totalLoanBalance;
	}

	public void setTotalLoanBalance(double totalLoanBalance) {
		this.totalLoanBalance = totalLoanBalance;
	}

	public double getReceivedPro() {
		return receivedPro;
	}

	public void setReceivedPro(double receivedPro) {
		this.receivedPro = receivedPro;
	}

	public double getReceivedJewel() {
		return receivedJewel;
	}

	public void setReceivedJewel(double receivedJewel) {
		this.receivedJewel = receivedJewel;
	}

	public double getReceivedDeposit() {
		return receivedDeposit;
	}

	public void setReceivedDeposit(double receivedDeposit) {
		this.receivedDeposit = receivedDeposit;
	}

	public double getReceivedOtherLoan() {
		return receivedOtherLoan;
	}

	public void setReceivedOtherLoan(double receivedOtherLoan) {
		this.receivedOtherLoan = receivedOtherLoan;
	}

	public double getReceivedEmployee() {
		return receivedEmployee;
	}

	public void setReceivedEmployee(double receivedEmployee) {
		this.receivedEmployee = receivedEmployee;
	}

	public double getTotalReceivedLoan() {
		return totalReceivedLoan;
	}

	public void setTotalReceivedLoan(double totalReceivedLoan) {
		this.totalReceivedLoan = totalReceivedLoan;
	}

	public double getDisbursedPro() {
		return disbursedPro;
	}

	public void setDisbursedPro(double disbursedPro) {
		this.disbursedPro = disbursedPro;
	}

	public double getDisbursedJewel() {
		return disbursedJewel;
	}

	public void setDisbursedJewel(double disbursedJewel) {
		this.disbursedJewel = disbursedJewel;
	}

	public double getDisbursedDeposit() {
		return disbursedDeposit;
	}

	public void setDisbursedDeposit(double disbursedDeposit) {
		this.disbursedDeposit = disbursedDeposit;
	}

	public double getDisbursedOther() {
		return disbursedOther;
	}

	public void setDisbursedOther(double disbursedOther) {
		this.disbursedOther = disbursedOther;
	}

	public double getDisbursedEmployee() {
		return disbursedEmployee;
	}

	public void setDisbursedEmployee(double disbursedEmployee) {
		this.disbursedEmployee = disbursedEmployee;
	}

	public double getTotalDisbursed() {
		return totalDisbursed;
	}

	public void setTotalDisbursed(double totalDisbursed) {
		this.totalDisbursed = totalDisbursed;
	}

	public double getEndPro() {
		return endPro;
	}

	public void setEndPro(double endPro) {
		this.endPro = endPro;
	}

	public double getEndJewel() {
		return endJewel;
	}

	public void setEndJewel(double endJewel) {
		this.endJewel = endJewel;
	}

	public double getEndDeposit() {
		return endDeposit;
	}

	public void setEndDeposit(double endDeposit) {
		this.endDeposit = endDeposit;
	}

	public double getEndEmployee() {
		return endEmployee;
	}

	public void setEndEmployee(double endEmployee) {
		this.endEmployee = endEmployee;
	}

	public double getEndOtherLoan() {
		return endOtherLoan;
	}

	public void setEndOtherLoan(double endOtherLoan) {
		this.endOtherLoan = endOtherLoan;
	}

	public double getTotalLoanEnd() {
		return totalLoanEnd;
	}

	public void setTotalLoanEnd(double totalLoanEnd) {
		this.totalLoanEnd = totalLoanEnd;
	}

	public ArrayList<UserInfo> getRdList() {
		return rdList;
	}

	public void setRdList(ArrayList<UserInfo> rdList) {
		this.rdList = rdList;
	}

	public ArrayList<InstallmentInfo> getFinalList() {
		return finalList;
	}

	public void setFinalList(ArrayList<InstallmentInfo> finalList) {
		this.finalList = finalList;
	}

	public ArrayList<InstallmentInfo> getTemplList() {
		return templList;
	}

	public void setTemplList(ArrayList<InstallmentInfo> templList) {
		this.templList = templList;
	}

	public double getPreReceivedDD() {
		return preReceivedDD;
	}

	public void setPreReceivedDD(double preReceivedDD) {
		this.preReceivedDD = preReceivedDD;
	}

	public double getPreRepaidDD() {
		return preRepaidDD;
	}

	public void setPreRepaidDD(double preRepaidDD) {
		this.preRepaidDD = preRepaidDD;
	}

	public double getReceivedDD() {
		return receivedDD;
	}

	public void setReceivedDD(double receivedDD) {
		this.receivedDD = receivedDD;
	}

	public double getRepaidDD() {
		return repaidDD;
	}

	public void setRepaidDD(double repaidDD) {
		this.repaidDD = repaidDD;
	}

	public double getEndDD() {
		return endDD;
	}

	public void setEndDD(double endDD) {
		this.endDD = endDD;
	}

	public double getDdBalance() {
		return ddBalance;
	}

	public void setDdBalance(double ddBalance) {
		this.ddBalance = ddBalance;
	}
	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;
	}

	public int getOpeningMember() {
		return openingMember;
	}

	public void setOpeningMember(int openingMember) {
		this.openingMember = openingMember;
	}

	public int getAddMember() {
		return addMember;
	}

	public void setAddMember(int addMember) {
		this.addMember = addMember;
	}

	public int getLessMember() {
		return lessMember;
	}

	public void setLessMember(int lessMember) {
		this.lessMember = lessMember;
	}

	public int getClosingMember() {
		return closingMember;
	}

	public void setClosingMember(int closingMember) {
		this.closingMember = closingMember;
	}
	
}
