package other_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

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.LoanInfo;

import org.primefaces.context.RequestContext;

@ManagedBean(name="preMaturityStatement")
@ViewScoped
public class PreMaturityStatementBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	LoanInfo selectedLoan;
	double totalDebit,totalCredit,closingBalance, penaltyAmount,totalChqCharge,paidChqCharge,penaltyPaid, penaltyDue, penaltyDiscount,totalDueAmount,totalDelayDays,totalPenaltyBalance,contractBalance,contractAmount,financeAmount,paidPenaltyChargesForFinanceAmount,totalPenaltyDue,rebatePreclosure,totalRebateAmount,netAmountReceivable,totalReceivableAmount;
	String type,frequency, loanType="";
	ArrayList<ReportInfo> list,dailyPayList;
	ArrayList<ReportInfo> list1= new ArrayList<>();
	ArrayList<LoanInfo> emiPaidDetailList,maturityList;
	ArrayList<String> emiPay;
	String amounteceivableDate;
	boolean showPenaltyField, showSubLoanField;
	String loanNo, subLoanNo="",penaltyDate;
	DecimalFormat df=new DecimalFormat("##.##");
	DataBaseMethods dbm=new DataBaseMethods();
	
	public PreMaturityStatementBean() throws ParseException
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		Connection conn=DataBaseConnection.JAVAConnection();
		selectedLoan=(LoanInfo) ss.getAttribute("selectedLoan");
		rebatePreclosure=(double)ss.getAttribute("preclosureValue");
		type=selectedLoan.getLoanType();
		showPenaltyField=(boolean) ss.getAttribute("showPen");
		//penaltyAmount=new DataBase().penaltyAmountPaidByApplicant(selectedLoan.getLoanNo());
		//// System.out.println("penalty : "+penaltyAmount);
		// System.out.println("Selected loan no :"+selectedLoan.getLoanNo());
		if(selectedLoan.getLoanType().equals("Personal Loan"))
		{
			loanType="personalloan";
		}
		else if(selectedLoan.getLoanType().equals("Vehicle Loan"))
		{
			loanType="vehicleloan";
		}
		else if(selectedLoan.getLoanType().equals("Property Loan"))
		{
			loanType="propertyloan";
		}
		else if(selectedLoan.getLoanType().equals("Group Loan"))
		{
			loanType="grouploan";
		}
		
		
		//maturityList=new DataBaseMethodsParticular().loanReportForPreMaturity(selectedLoan.getLoanNo(),selectedLoan.getShareHolderNo(),selectedLoan.getLoanType(),conn);
		maturityList=new DataBaseMethods().loanInstallment(loanType,selectedLoan.getLoanNo(), conn);
		maturityList=new DataBaseMethods().penaltyCalculationMethod(loanType, selectedLoan.getLoanNo(), maturityList, conn);
		double penaltyBalance=0;
		totalDelayDays=0;
		
		penaltyDue=0;
		totalReceivableAmount=0;
		totalPenaltyBalance=0;
		paidPenaltyChargesForFinanceAmount=0;
		contractBalance=0;
	//	calculate();
		totalDueAmount=0;
		totalPenaltyDue=0;
		totalRebateAmount=0;
		contractAmount=0;
		totalCredit=totalDebit=closingBalance=financeAmount=0;
		netAmountReceivable=0;
		int count=0;
		for(LoanInfo kk : maturityList)
		{
			
			if(kk.getPaidAmount()>0)
			{
				totalDebit+=kk.getPaidAmount();
			}
			totalDueAmount +=kk.getInstallAmount();
			totalDelayDays +=kk.getPenaltydays();
			//penaltyDue +=kk.getPenaltyDue();
			penaltyBalance=penaltyBalance+kk.getPenaltyDue();
			kk.setPenaltyBalance(penaltyBalance);
			totalPenaltyBalance +=Double.valueOf(new DecimalFormat("##.##").format(kk.getPenaltyBalance()));
			penaltyDate=kk.getStrInstlmntDate();
			totalPenaltyDue +=kk.getPenaltyDue();
			// totalDueAmount +=kk.getAmount();
		}
		
		totalChqCharge=dbm.calculatePenaltyAndChequeBounceCharges(loanNo, "Cheque Bounce",loanType, conn);
		paidChqCharge=dbm.totalPaidPenaltyAndChequeBounceCharges(loanNo, "Cheque Bounce", conn);
		financeAmount=Double.valueOf(selectedLoan.getLoanAmount())-Double.valueOf(selectedLoan.getInterestAmount());
		contractBalance=totalDueAmount-totalDebit;
		contractAmount=Double.valueOf(selectedLoan.getLoanAmount())+Double.valueOf(selectedLoan.getInterestAmount());
		paidPenaltyChargesForFinanceAmount=Double.valueOf(new DecimalFormat("##.##").format(contractBalance+totalPenaltyDue+totalChqCharge));
		totalRebateAmount=Double.valueOf(new DecimalFormat("##.##").format((paidPenaltyChargesForFinanceAmount)*(rebatePreclosure/100)));
		amounteceivableDate=new SimpleDateFormat("dd/MM/yyyy").format(new Date());
		if((totalRebateAmount+paidChqCharge) > paidPenaltyChargesForFinanceAmount)
		{
			
			netAmountReceivable=paidPenaltyChargesForFinanceAmount;
		}
		else
		{
			netAmountReceivable=Double.valueOf(new DecimalFormat("##.##").format(paidPenaltyChargesForFinanceAmount-(totalRebateAmount+paidChqCharge)));
		}
		
		
		frequency=dbm.frequencyLabel(selectedLoan.getFrequency());
		
		loanNo=selectedLoan.getLoanNo();
		subLoanNo=selectedLoan.getSubLoanNo();
		
		if(selectedLoan.getLoanType().equals("Personal Loan"))
		{
			loanType="personalloan";
		}
		else if(selectedLoan.getLoanType().equals("Vehicle Loan"))
		{
			loanType="vehicleloan";
		}
		else if(selectedLoan.getLoanType().equals("Property Loan"))
		{
			loanType="propertyloan";
		}
		else if(selectedLoan.getLoanType().equals("Group Loan"))
		{
			loanType="grouploan";
		}
		
		if(subLoanNo==null || subLoanNo.equals(""))
		{
			showSubLoanField=false;
		}
		else
		{
			showSubLoanField=true;
		}
		//// System.out.println("penalty seldcteooioj: "+showPenaltyField);
		if(showPenaltyField==true)
		{
			penaltyAndChequeBounceCalculation();
		}
	}
	
	public void calculate()
	{
		totalDueAmount=0;
		totalCredit=totalDebit=closingBalance=financeAmount=0;
		for(LoanInfo ll:maturityList)
		{
			if(ll.getCreditAmount()>0)
			{
				totalCredit+=ll.getCreditAmount();
				System.out.println("sjdkasjdksaj"+totalCredit);
			}
			else if(ll.getDebitAmount()>0)
			{
				totalDebit+=ll.getDebitAmount();
			}
			totalDueAmount +=ll.getAmount();
			
		}
		financeAmount=totalDueAmount-totalCredit;
		closingBalance=totalCredit-totalDebit;
//		double dis=dbm.discountOnLastEMI(loanType, loanNo);
//		closingBalance=(closingBalance+penaltyDue)-dis;
		closingBalance=Double.parseDouble(df.format(closingBalance));
		
		/*emiPay=dbm.emiPaidDateList(selectedLoan.getLoanNo());
		for(int i=0; i<emiPay.size(); i++)
		{
			list.get(i+2).setEmiPaidDateStr(emiPay.get(i));
		}*/
	}
	
	
	
	
	public void checkPaidDetail()
	{
		if(selectedLoan.getLoanType().equals("Group Loan"))
		{
			emiPaidDetailList=dbm.checkEmiPaidDetailByloanNo(subLoanNo);
		}
		else
		{
			emiPaidDetailList=dbm.checkEmiPaidDetailByloanNo(loanNo);
		}
		
	}
	
	
	public void penaltyAndChequeBounceCalculation()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		penaltyAmount=penaltyDue=penaltyPaid=penaltyDiscount=0;
		String loanNo=selectedLoan.getLoanNo();
		
		if(selectedLoan.getPaidStatus().equals("unpaid"))
		{
			penaltyAmount=dbm.calculatePenaltyAndChequeBounceCharges(loanNo, "Penalty", loanType, conn);
			penaltyPaid=dbm.totalPaidPenaltyAndChequeBounceCharges(loanNo, "Penalty", conn);
			penaltyDiscount=dbm.discountOnPenaltyByLoanNo(loanNo);
			penaltyDue=penaltyAmount-(penaltyPaid+penaltyDiscount);
		}
		else
		{
			penaltyAmount=dbm.totalPaidPenaltyAndChequeBounceCharges(loanNo, "Penalty", conn);
			penaltyPaid=dbm.totalPaidPenaltyAndChequeBounceCharges(loanNo, "Penalty", conn);
			penaltyDiscount=dbm.discountOnPenaltyByLoanNo(loanNo);
			penaltyDue=0;
		}
		
		
		penaltyAmount=Double.parseDouble(df.format(penaltyAmount));
		penaltyPaid=Double.parseDouble(df.format(penaltyPaid));
		penaltyDue=Double.parseDouble(df.format(penaltyDue));
		
		totalChqCharge=dbm.calculatePenaltyAndChequeBounceCharges(loanNo, "Cheque Bounce",loanType, conn);
		paidChqCharge=dbm.totalPaidPenaltyAndChequeBounceCharges(loanNo, "Cheque Bounce", conn);
	
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void printDailyPay()
	{
		dailyPayList= new ArrayList<>();
		if(selectedLoan.getLoanType().equalsIgnoreCase("Group Loan"))
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanReport(selectedLoan.getSubLoanNo());
		}
		else
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanReport(selectedLoan.getLoanNo());
		}
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("penaltyAmount", penaltyAmount);
		ss.setAttribute("penaltyPaid", penaltyPaid);
		ss.setAttribute("penaltyDue", penaltyDue);
		ss.setAttribute("totalChqCharge", totalChqCharge);
		ss.setAttribute("paidChqCharge", paidChqCharge);
		ss.setAttribute("dailyPayList", dailyPayList);
		ss.setAttribute("selectedVal",selectedLoan);
		ss.setAttribute("operationVal", "loan");
		RequestContext.getCurrentInstance().execute("window.open('printPerticularDatePayment.xhtml')");
		
	}
	
	public String backButton()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		String pageName=(String) ss.getAttribute("pageName");
		return pageName;
	}

	
	public double getTotalChqCharge() {
		return totalChqCharge;
	}

	public void setTotalChqCharge(double totalChqCharge) {
		this.totalChqCharge = totalChqCharge;
	}

	public double getPaidChqCharge() {
		return paidChqCharge;
	}

	public void setPaidChqCharge(double paidChqCharge) {
		this.paidChqCharge = paidChqCharge;
	}

	public LoanInfo getSelectedLoan() {
		return selectedLoan;
	}
	public void setSelectedLoan(LoanInfo selectedLoan) {
		this.selectedLoan = selectedLoan;
	}
	public ArrayList<ReportInfo> getList() {
		return list;
	}
	public void setList(ArrayList<ReportInfo> list) {
		this.list = list;
	}
	public String getType() {
		return type;
	}
	public void setType(String type) {
		this.type = type;
	}
	public String getFrequency() {
		return frequency;
	}
	public void setFrequency(String frequency) {
		this.frequency = frequency;
	}
	public double getTotalDebit() {
		return totalDebit;
	}
	public void setTotalDebit(double totalDebit) {
		this.totalDebit = totalDebit;
	}
	public double getTotalCredit() {
		return totalCredit;
	}
	public void setTotalCredit(double totalCredit) {
		this.totalCredit = totalCredit;
	}
	public double getPenaltyPaid() {
		return penaltyPaid;
	}

	public void setPenaltyPaid(double penaltyPaid) {
		this.penaltyPaid = penaltyPaid;
	}

	public ArrayList<String> getEmiPay() {
		return emiPay;
	}

	public void setEmiPay(ArrayList<String> emiPay) {
		this.emiPay = emiPay;
	}

	public double getClosingBalance() {
		return closingBalance;
	}
	public void setClosingBalance(double closingBalance) {
		this.closingBalance = closingBalance;
	}

	public double getPenaltyAmount() {
		return penaltyAmount;
	}

	public void setPenaltyAmount(double penaltyAmount) {
		this.penaltyAmount = penaltyAmount;
	}

	public boolean isShowPenaltyField() {
		return showPenaltyField;
	}

	public void setShowPenaltyField(boolean showPenaltyField) {
		this.showPenaltyField = showPenaltyField;
	}

	public ArrayList<LoanInfo> getEmiPaidDetailList() {
		return emiPaidDetailList;
	}

	public void setEmiPaidDetailList(ArrayList<LoanInfo> emiPaidDetailList) {
		this.emiPaidDetailList = emiPaidDetailList;
	}

	public double getPenaltyDue() {
		return penaltyDue;
	}

	public void setPenaltyDue(double penaltyDue) {
		this.penaltyDue = penaltyDue;
	}

	public double getPenaltyDiscount() {
		return penaltyDiscount;
	}

	public void setPenaltyDiscount(double penaltyDiscount) {
		this.penaltyDiscount = penaltyDiscount;
	}

	public ArrayList<ReportInfo> getList1() {
		return list1;
	}

	public void setList1(ArrayList<ReportInfo> list1) {
		this.list1 = list1;
	}

	public boolean isShowSubLoanField() {
		return showSubLoanField;
	}

	public void setShowSubLoanField(boolean showSubLoanField) {
		this.showSubLoanField = showSubLoanField;
	}

	public String getSubLoanNo() {
		return subLoanNo;
	}

	public void setSubLoanNo(String subLoanNo) {
		this.subLoanNo = subLoanNo;
	}

	public String getLoanType() {
		return loanType;
	}

	public void setLoanType(String loanType) {
		this.loanType = loanType;
	}

	public ArrayList<ReportInfo> getDailyPayList() {
		return dailyPayList;
	}

	public void setDailyPayList(ArrayList<ReportInfo> dailyPayList) {
		this.dailyPayList = dailyPayList;
	}

	public String getLoanNo() {
		return loanNo;
	}

	public void setLoanNo(String loanNo) {
		this.loanNo = loanNo;
	}

	public DataBaseMethods getDbm() {
		return dbm;
	}

	public void setDbm(DataBaseMethods dbm) {
		this.dbm = dbm;
	}

	public ArrayList<LoanInfo> getMaturityList() {
		return maturityList;
	}

	public void setMaturityList(ArrayList<LoanInfo> maturityList) {
		this.maturityList = maturityList;
	}

	public double getTotalDueAmount() {
		return totalDueAmount;
	}

	public void setTotalDueAmount(double totalDueAmount) {
		this.totalDueAmount = totalDueAmount;
	}

	public double getTotalDelayDays() {
		return totalDelayDays;
	}

	public void setTotalDelayDays(double totalDelayDays) {
		this.totalDelayDays = totalDelayDays;
	}

	public double getTotalPenaltyBalance() {
		return totalPenaltyBalance;
	}

	public void setTotalPenaltyBalance(double totalPenaltyBalance) {
		this.totalPenaltyBalance = totalPenaltyBalance;
	}

	public double getContractBalance() {
		return contractBalance;
	}

	public void setContractBalance(double contractBalance) {
		this.contractBalance = contractBalance;
	}

	public double getFinanceAmount() {
		return financeAmount;
	}

	public void setFinanceAmount(double financeAmount) {
		this.financeAmount = financeAmount;
	}

	public String getPenaltyDate() {
		return penaltyDate;
	}

	public void setPenaltyDate(String penaltyDate) {
		this.penaltyDate = penaltyDate;
	}

	public double getPaidPenaltyChargesForFinanceAmount() {
		return paidPenaltyChargesForFinanceAmount;
	}

	public void setPaidPenaltyChargesForFinanceAmount(
			double paidPenaltyChargesForFinanceAmount) {
		this.paidPenaltyChargesForFinanceAmount = paidPenaltyChargesForFinanceAmount;
	}

	public double getTotalPenaltyDue() {
		return totalPenaltyDue;
	}

	public void setTotalPenaltyDue(double totalPenaltyDue) {
		this.totalPenaltyDue = totalPenaltyDue;
	}

	public double getRebatePreclosure() {
		return rebatePreclosure;
	}

	public void setRebatePreclosure(double rebatePreclosure) {
		this.rebatePreclosure = rebatePreclosure;
	}

	public double getTotalRebateAmount() {
		return totalRebateAmount;
	}

	public void setTotalRebateAmount(double totalRebateAmount) {
		this.totalRebateAmount = totalRebateAmount;
	}

	public double getNetAmountReceivable() {
		return netAmountReceivable;
	}

	public void setNetAmountReceivable(double netAmountReceivable) {
		this.netAmountReceivable = netAmountReceivable;
	}

	public String getAmounteceivableDate() {
		return amounteceivableDate;
	}

	public void setAmounteceivableDate(String amounteceivableDate) {
		this.amounteceivableDate = amounteceivableDate;
	}

	public double getContractAmount() {
		return contractAmount;
	}

	public void setContractAmount(double contractAmount) {
		this.contractAmount = contractAmount;
	}

	
	
}