package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
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.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import org.primefaces.context.RequestContext;

import other_package.DataBaseMethodsOther;
import other_package.ReportInfo;
import main_package.DataBaseConnection;
import main_package.DataBaseMethodTaheer;
import main_package.DataBaseMethods;
import main_package.LoanInfo;

@ManagedBean(name="loanAccountStatement")
@ViewScoped

public class LoanAccountStatementBean implements Serializable
{
	int total;
	
	
	double totalAmountPaid, totalTillLeft, totalBalance;
	
	
	String loanType, userId, dsaCode, center, searchType;
	
	
	Date searchDate = new Date();
	
	
	boolean disDsa, showTable;
	
	
	ArrayList<LoanInfo> list;
	
	ArrayList<SelectItem> dsaList, centerList, loanList;
	
	
	LoanInfo loan_info;
	
	
	DataBaseReportMethods dbmr = new DataBaseReportMethods();
	
	DataBaseMethods dbm = new DataBaseMethods();
	
	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
	
	
	DecimalFormat dc = new DecimalFormat("##.##");
	
	SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
	
	
	
	public LoanAccountStatementBean() 
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn = DataBaseConnection.JAVAConnection();
		userId = dbm.userId();
		dsaList = dbm.allDsaList(branchId,"",conn);
		centerList = dbm.allcenter(branchId,"all",conn);
		String empDataStatus = dbm.checkSMessageApiDetailFromTable("employee_wise_data", "",conn);
		
		if(dbm.userType().equals("employee") && empDataStatus.equalsIgnoreCase("active"))
		{
			dsaCode = dbm.dsaCodeByEmpUserId(userId, conn);
			disDsa = true;
		}
		
		try 
		{
			conn.close();
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
	}
	
	
	
	public void checkLoan()
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		loanList = new DataBaseMethods().loanNoList(loanType,branchId);
	}
	
	
	
	public void searchReport()
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		showTable = true;
		totalAmountPaid = totalTillLeft=totalBalance=0;
		list = dbmr.loanAccountStatementReport(branchId, dsaCode ,loanType, searchDate);
		
		for(LoanInfo ll: list)
		{
			totalAmountPaid += ll.getAmountPaid();
			totalTillLeft += ll.getTillLeft();
			totalBalance += ll.getBalance();
		}
		
		total = list.size();
	}
	
	
    
	public void printDailyPay() throws ParseException
	{
		Connection conn = DataBaseConnection.JAVAConnection();
		ArrayList<LoanInfo> loanEMIList = null;
		double penalty = 0;
		loanEMIList = dbm.loanInstallment(loanType,loan_info.getLoanNo(), conn);
		
		loanEMIList = dbm.penaltyCalculationMethod(loanType, loan_info.getLoanNo(), loanEMIList, conn);
//		double totPaid = dbm.totalPaidPenaltyAndChequeBounceCharges(loan_info.getLoanNo(), "Penalty", conn);
//		
//		if(totPaid > 0)
//		{
//			for(int i=0; i<loanEMIList.size(); i++)
//			{
//				if(totPaid>loanEMIList.get(i).getPenaltyDue())
//				{
//					loanEMIList.get(i).setPenaltyPaid(loanEMIList.get(i).getPenaltyDue());
//				}
//				else
//				{
//					loanEMIList.get(i).setPenaltyPaid(totPaid);
//					break;
//				}
//				totPaid=totPaid-loanEMIList.get(i).getPenaltyDue();
//			}
//		}
		
		
		
		Date closeDate = null;
		double actualPaid = 0;

		try {
		    PreparedStatement ps = conn.prepareStatement(
		        "SELECT pay_date, amount FROM loanpayment " +
		        "WHERE loanNo=? AND emi_no='-1' AND receipt_status='approved' AND chequeStatus='cleared'"
		    );
		    ps.setString(1, loan_info.getLoanNo());

		    ResultSet rs = ps.executeQuery();
		    if(rs.next()){
		        closeDate = rs.getDate("pay_date");   
		        actualPaid = rs.getDouble("amount");  
		        System.out.println("Close Date =====" + closeDate);  
 		    }
		    
		}catch(Exception e){
		    e.printStackTrace();
		}
		
		
		
		try
		{
			PreparedStatement psPay = conn.prepareStatement("SELECT emi_no, MAX(pay_date) AS pay_date, SUM(amount) AS total_amount "
														  + "FROM loanpayment WHERE loanNo=?  AND receipt_status='approved' AND "
														  + "chequeStatus='cleared' AND emi_no > 0 GROUP BY emi_no ORDER BY emi_no");
			psPay.setString(1, loan_info.getLoanNo());
			
			ResultSet rsPay = psPay .executeQuery();
			
			double[] maxAmount = new double[loanEMIList.size() + 1];

			while(rsPay.next())
			{
			    int emiNo = rsPay.getInt("emi_no");

			    Date payDate = rsPay.getDate("pay_date");

			    double amount = rsPay.getDouble("total_amount");
			    
			    double paidPenalty = dbmt.paidPenaltyAmountByLoanNoAndDate(loan_info.getLoanNo(), 
			    														   new java.sql.Date(payDate.getTime()), conn);

			    if(payDate != null && emiNo > 0 && emiNo <= loanEMIList.size())
			    {
			        if(amount >= maxAmount[emiNo])
			        {
			            maxAmount[emiNo] = amount;

			            loanEMIList.get(emiNo - 1).setPaidDate(payDate);
			            loanEMIList.get(emiNo - 1).setPaidAmount(amount);
			            loanEMIList.get(emiNo - 1).setPenaltyPaid(paidPenalty);
			            
			            if (amount < loan_info.getInstallAmount() && amount != 0) 
			            {
			            	System.out.println("noob");
				           
							if (payDate.equals(loanEMIList.get(emiNo - 2).getPaidDate())) 
							{
								double pa = loanEMIList.get(emiNo - 2).getPaidAmount();
								loanEMIList.get(emiNo - 2).setPaidAmount(pa + amount);
								
								if (closeDate == null) 
								{
//									double da = loanEMIList.get(emiNo - 1).getDueAmount();
//									loanEMIList.get(emiNo - 1).setDueAmount(da - amount);
									loanEMIList.get(emiNo - 1).setPaidAmount(0);
									loanEMIList.get(emiNo - 1).setPaidDate(null);
								}
								else 
								{
									loanEMIList.remove(emiNo- 1);
								}
							}
						}
			        }
			    }
			}
		}catch(Exception e) {
			e.printStackTrace();
		}
		
		
		
		LoanInfo infoObj = dbm.loanInfoByLoanNoLoanType(loan_info.getLoanNo(), loanType, conn);
		
		double emiAmount = infoObj.getInstallAmount();

		int terms = infoObj.getTerms();

		double interest = emiAmount * terms;
		
		double loanAmount = Double.parseDouble(loan_info.getLoanAmount());
		
		infoObj.setInterestAmount(String.valueOf(interest - loanAmount));

		System.out.println("EMI Amount: " + emiAmount);
		System.out.println("Terms: " + terms);
		System.out.println("Interest: " + interest);
		
		
		if(closeDate != null)
		{
		    ArrayList<LoanInfo> tempList = new ArrayList<>();

		    for(LoanInfo emi : loanEMIList)
		    {
		        if(!emi.getInstallDate().after(closeDate))
		        {
		            tempList.add(emi);
		        }
		    }
		    

		    loanEMIList = tempList;

		    LoanInfo info = new LoanInfo();

		    double totalEmiAmount = 0;

		    for(LoanInfo emi : loanEMIList)
		    {
		        totalEmiAmount += emi.getInstallAmount();
		    }

		    double remainingAmount = interest - totalEmiAmount;
		    
		    double paidPenalty = dbmt.paidPenaltyAmountByLoanNoAndDate(loan_info.getLoanNo(), 
					   												   new java.sql.Date(closeDate.getTime()), conn);
		    
		    info.setSno(loanEMIList.size() + 1);
		    info.setStrInstlmntDate(sdf.format(closeDate));
		    info.setPaidDate(closeDate);
		    info.setInstallAmount(Double.parseDouble(dc.format(remainingAmount)));
		    info.setPaidAmount(actualPaid);
		    info.setInterestAmount("0");
		    info.setPenaltyDue(0);
		    info.setPenaltyPaid(paidPenalty);
		    info.setPrincipalAmount("0");
		    info.setStatus("Closed");
		    
		    
		    loanEMIList.add(info);
		}
		
		
		double totalPenaltyDue=0,totalPenaltyPaid=0,totalIntrest=0,totalEmi = 0,totalPrincipal=0,totalDue=0,totalPaid=0;
		for(LoanInfo ll: loanEMIList)
		{
			totalEmi+=ll.getInstallAmount();
			totalIntrest+=Double.parseDouble(ll.getInterestAmount());
			totalPrincipal+=Double.parseDouble(ll.getPrincipalAmount());
			totalPaid+=ll.getPaidAmount();
			totalDue+=ll.getDueAmount();
			totalPenaltyDue+=ll.getPenaltyDue();
			totalPenaltyPaid+=ll.getPenaltyPaid();
			
			if (totalPenaltyDue < totalPenaltyPaid) 
			{
				if (ll.getStatus().equalsIgnoreCase("Closed"))
				{
					ll.setPenaltyDue(Math.round(totalPenaltyPaid - totalPenaltyDue));
					totalPenaltyDue = totalPenaltyPaid;
				}
			}
		}
		double penaltyDiscount=new DataBaseMethods().discountOnPenaltyByLoanNo(loan_info.getLoanNo());
		double currentPenaltyDue=totalPenaltyDue-(totalPenaltyPaid+penaltyDiscount);
		totalEmi=Math.round(totalEmi);
		totalIntrest=Math.round(totalIntrest);
		totalPrincipal=Math.round(totalPrincipal);
		totalPaid=Math.round(totalPaid);
		totalDue=Math.round(totalDue);
		totalPenaltyDue=Math.round(totalPenaltyDue);
		penaltyDiscount=Math.round(penaltyDiscount);
		totalPenaltyPaid=Math.round(totalPenaltyPaid);
		
		
		double totalChqCharge=dbm.calculatePenaltyAndChequeBounceCharges(loan_info.getLoanNo(), "Cheque Bounce",loanType, conn);
		double paidChqcharge=dbm.totalPaidPenaltyAndChequeBounceCharges(loan_info.getLoanNo(), "Cheque Bounce", conn);
		
		double loanBalance=(totalEmi+totalPenaltyDue+totalChqCharge)-(totalPaid+totalPenaltyPaid+paidChqcharge+penaltyDiscount);
		loanBalance=Double.parseDouble(dc.format(loanBalance));
		
		ArrayList<ReportInfo> dailyPayList= new ArrayList<>();
		dailyPayList= new DataBaseMethodsOther().dailyloanReport(loan_info.getLoanNo());
		/*if(loanType.equalsIgnoreCase("grouploan"))
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanReport(loan_info.getSubLoanNo());
		}
		else
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanReport(loan_info.getLoanNo());
		}*/
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("penaltyAmount", penalty);
		ss.setAttribute("penaltyPaid", totalPenaltyPaid);
		ss.setAttribute("penaltyDue", totalPenaltyDue);
		ss.setAttribute("totalChqCharge", totalChqCharge);
		ss.setAttribute("paidChqCharge", totalChqCharge);
		ss.setAttribute("dailyPayList", dailyPayList);
		ss.setAttribute("selectedVal",infoObj);
		ss.setAttribute("operationVal", "loan");
		ss.setAttribute("reportClosingBalance", totalDue);
		ss.setAttribute("disOnLoanClose",0.0);
		ss.setAttribute("printOverallEmi",loanEMIList );                  //RR 04/7 
		ss.setAttribute("totalEmi", totalEmi);                            //RR 04/7 
		ss.setAttribute("totalIntrest",totalIntrest);                     //RR 04/7 
		ss.setAttribute("totalPrincipal", totalPrincipal);                //RR 04/7 
		ss.setAttribute("totalPaid", totalPaid);
		
		RequestContext.getCurrentInstance().execute("window.open('printPerticularDatePayment.xhtml')");
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public String getLoanType() {
		return loanType;
	}

	public void setLoanType(String loanType) {
		this.loanType = loanType;
	}

	public String getUserId() {
		return userId;
	}

	public void setUserId(String userId) {
		this.userId = userId;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public boolean isDisDsa() {
		return disDsa;
	}

	public void setDisDsa(boolean disDsa) {
		this.disDsa = disDsa;
	}

	public Date getSearchDate() {
		return searchDate;
	}

	public void setSearchDate(Date searchDate) {
		this.searchDate = searchDate;
	}

	public ArrayList<LoanInfo> getList() {
		return list;
	}

	public void setList(ArrayList<LoanInfo> list) {
		this.list = list;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	public int getTotal() {
		return total;
	}

	public void setTotal(int total) {
		this.total = total;
	}

	public double getTotalAmountPaid() {
		return totalAmountPaid;
	}

	public void setTotalAmountPaid(double totalAmountPaid) {
		this.totalAmountPaid = totalAmountPaid;
	}

	public double getTotalTillLeft() {
		return totalTillLeft;
	}

	public void setTotalTillLeft(double totalTillLeft) {
		this.totalTillLeft = totalTillLeft;
	}

	public double getTotalBalance() {
		return totalBalance;
	}

	public void setTotalBalance(double totalBalance) {
		this.totalBalance = totalBalance;
	}

	public boolean isShowTable() {
		return showTable;
	}

	public void setShowTable(boolean showTable) {
		this.showTable = showTable;
	}

	public LoanInfo getLoan_info() {
		return loan_info;
	}

	public void setLoan_info(LoanInfo loan_info) {
		this.loan_info = loan_info;
	}

	public String getCenter() {
		return center;
	}

	public void setCenter(String center) {
		this.center = center;
	}

	public String getSearchType() {
		return searchType;
	}

	public void setSearchType(String searchType) {
		this.searchType = searchType;
	}

	public ArrayList<SelectItem> getCenterList() {
		return centerList;
	}

	public void setCenterList(ArrayList<SelectItem> centerList) {
		this.centerList = centerList;
	}

	public ArrayList<SelectItem> getLoanList() {
		return loanList;
	}

	public void setLoanList(ArrayList<SelectItem> loanList) {
		this.loanList = loanList;
	}
	
}
