package other_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collections;
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 main_package.UserInfo;

import org.primefaces.context.RequestContext;

@ManagedBean(name="printPaidLoanEmiReport")
@ViewScoped
public class PrintPaidLoanEmiReportBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	LoanInfo selectedLoan;
	double totalDebit,totalCredit,closingBalance, penaltyAmount,totalChqCharge,paidChqCharge,penaltyPaid, penaltyDue, penaltyDiscount,disOnLoanClose;
	String type,frequency, loanType="";
	ArrayList<ReportInfo> list,dailyPayList;
	ArrayList<ReportInfo> list1= new ArrayList<>();
	ArrayList<LoanInfo> emiPaidDetailList;
	ArrayList<String> emiPay;
	boolean showPenaltyField, showSubLoanField, showLoanPaidStatus;
	String loanNo, subLoanNo="";
	DecimalFormat df=new DecimalFormat("##.##");
	DataBaseMethods dbm=new DataBaseMethods();
	double loanBalance;
	ArrayList<LoanInfo>  loanEMIList;
	UserInfo memberBasicDetail;
	ArrayList<ReportInfo>  commanList, emiList, paidEmiList, penaltyPaidList,bounceList ,bouncePaidList;
	SimpleDateFormat sf=new SimpleDateFormat("dd/MM/yyyy");
	String strFirstEmiDate, strEndEmiDate;
	double  dueInstallmentAmount, totalOutstanding;


	
	public ArrayList<ReportInfo> incomeListByLoanNo(String loanNo, String itemName) 
	{
		ArrayList<ReportInfo> incomeList=new ArrayList<>();
		
		Statement st=null;
		ResultSet rs=null;
		try(Connection conn=DataBaseConnection.JAVAConnection())
		{
			st=conn.createStatement();
			String query="select *,sum(amount) from income_table where loan_no='"+loanNo+"' and item='"+itemName+"' and status='active' and chequeStatus='cleared'"
					+ " group by income_date";
			////System.out.println(query);
			rs=st.executeQuery(query);
			while(rs.next())
			{
				ReportInfo obj= new ReportInfo();
				
				obj.setAmount(rs.getDouble("sum(amount)"));
				obj.setCreditAmount(obj.getAmount());
				obj.setStatus(itemName);
				obj.setDate(rs.getDate("income_date"));
				obj.setDateStr(sf.format(rs.getDate("income_date")));
				obj.setReceiptNo(rs.getString("voucher_no"));
				obj.setRemark(rs.getString("description"));
				
				incomeList.add(obj);
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			try 
			{
				if(st!=null)
				{
					st.close();
				}
				if(rs!=null)
				{
					rs.close();
				}
			} 
			catch (Exception e2) {
				// TODO: handle exception
			}
		}
		return incomeList;
	}	

	
	
	public PrintPaidLoanEmiReportBean()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		Connection conn=DataBaseConnection.JAVAConnection();
		selectedLoan=(LoanInfo) ss.getAttribute("selectedLoan");
		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());
		System.out.println("selected loan thpe is:"+selectedLoan.getLoanType());
		list=new DataBaseMethodsOther().PaidEmiloanReport(selectedLoan.getLoanNo(),selectedLoan.getShareHolderNo(),selectedLoan.getLoanType(),conn);
		frequency=dbm.frequencyLabel(selectedLoan.getFrequency());
		
		
		loanNo=selectedLoan.getLoanNo();
		subLoanNo=selectedLoan.getSubLoanNo();
		
		if(selectedLoan.getPaidStatus().equalsIgnoreCase("paid"))
		{
			showLoanPaidStatus=true;
		}
		

		loanType=dbm.loanValueByLoanLabel(selectedLoan.getLoanType());
		System.out.println("");
		
		System.out.println("loan type is:"+loanType);
		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();
		}
		calculate();
		
        
		// Work For Ledger report on 17 September 2023  
		memberBasicDetail=dbm.memberBasicDetail(selectedLoan.getShareHolderNo(), conn);
		commanList=new ArrayList<>();
		emiList=new DataBaseMethodsOther().paidEmiloanReportForLedger(selectedLoan.getLoanNo(),selectedLoan.getShareHolderNo(),loanType,conn);
		bounceList=new DataBaseMethodsOther().chequeBounceReport(loanNo);
		paidEmiList=new DataBaseMethodsOther().dailyloanReport(loanNo);
		penaltyPaidList=dbm.incomeListByLoanNo(loanNo, "Receive Penalty");
		bouncePaidList=dbm.incomeListByLoanNo(loanNo, "Receive Cheque Bounce Charges");
		
		commanList.addAll(emiList);
		commanList.addAll(bounceList);
		commanList.addAll(paidEmiList);
		commanList.addAll(penaltyPaidList);
		commanList.addAll(bouncePaidList);
		
		Collections.sort(commanList);
		
		totalDebit=totalCredit=0;
		for(ReportInfo rr: commanList)
		{
			totalDebit+=rr.getDebitAmount();
			totalCredit+=rr.getCreditAmount();
			rr.setBalance(totalDebit-totalCredit);
		}
		
		loanEMIList=new DataBaseMethods().loanInstallment(loanType,loanNo, conn);
		//strFirstEmiDate=loanEMIList.get(0).getStrInstlmntDate();
		if (loanEMIList != null && !loanEMIList.isEmpty()) {
		    strFirstEmiDate = loanEMIList.get(0).getStrInstlmntDate();
		} else {
		    strFirstEmiDate = "";
		}
		//strEndEmiDate=loanEMIList.get(loanEMIList.size()-1).getStrInstlmntDate();
		
		if (loanEMIList != null && !loanEMIList.isEmpty()) {

		    strFirstEmiDate = loanEMIList.get(0).getStrInstlmntDate();

		    strEndEmiDate = loanEMIList
		            .get(loanEMIList.size() - 1)
		            .getStrInstlmntDate();

		} else {

		    strFirstEmiDate = "";
		    strEndEmiDate = "";

		}
		
		loanBalance=dueInstallmentAmount=totalOutstanding=0;
		
		for(int l=0;l<loanEMIList.size();l++)
		{
			Date dt=new Date();
			if(loanEMIList.get(l).getStatus().equals("Due"))
			{
				if(loanEMIList.get(l).getInstallDate().before(dt))
				{
					dueInstallmentAmount+=loanEMIList.get(l).getDueAmount();
				}
				else
				{
					loanBalance+=Double.valueOf(loanEMIList.get(l).getPrincipalAmount());
				}
			}
		}
		
		double balBounce=totalChqCharge-paidChqCharge;
		dueInstallmentAmount=dueInstallmentAmount+balBounce; // bounce charge inculde in due install amount by vbpl 20-feb-2024
		
		totalOutstanding=loanBalance+dueInstallmentAmount+penaltyAmount;
		
		loanBalance=Math.round(loanBalance);
		dueInstallmentAmount=Math.round(dueInstallmentAmount);
		penaltyAmount=Math.round(penaltyAmount);
		totalOutstanding=Math.round(totalOutstanding);
	}
	
	public void calculate()
	{
		totalCredit=totalDebit=closingBalance=0;
		for(ReportInfo ll:list)
		{
			if(ll.getCreditAmount()>0)
			{
				totalCredit+=ll.getCreditAmount();
				//System.out.println("sjdkasjdksaj"+totalCredit);
			}
			else if(ll.getDebitAmount()>0)
			{
				totalDebit+=ll.getDebitAmount();
			}
		}
		closingBalance=totalCredit-totalDebit;
//		double dis=dbm.discountOnLastEMI(loanType, loanNo);
//		closingBalance=(closingBalance+penaltyDue)-dis;
		closingBalance=Double.parseDouble(df.format(closingBalance));
		if(selectedLoan.getPaidStatus().equalsIgnoreCase("paid"))
		{
			closingBalance=0;
			disOnLoanClose=dbm.discountOnLoanCloser(loanNo);
		}
		/*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);
		System.out.println("+paid cheque charge bounce"+paidChqCharge);
		
	}
	
	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 double getDisOnLoanClose() {
		return disOnLoanClose;
	}

	public void setDisOnLoanClose(double disOnLoanClose) {
		this.disOnLoanClose = disOnLoanClose;
	}

	public boolean isShowLoanPaidStatus() {
		return showLoanPaidStatus;
	}

	public void setShowLoanPaidStatus(boolean showLoanPaidStatus) {
		this.showLoanPaidStatus = showLoanPaidStatus;
	}

	public double getLoanBalance() {
		return loanBalance;
	}

	public void setLoanBalance(double loanBalance) {
		this.loanBalance = loanBalance;
	}

	public DecimalFormat getDf() {
		return df;
	}

	public void setDf(DecimalFormat df) {
		this.df = df;
	}

	public ArrayList<LoanInfo> getLoanEMIList() {
		return loanEMIList;
	}

	public void setLoanEMIList(ArrayList<LoanInfo> loanEMIList) {
		this.loanEMIList = loanEMIList;
	}

	public UserInfo getMemberBasicDetail() {
		return memberBasicDetail;
	}

	public void setMemberBasicDetail(UserInfo memberBasicDetail) {
		this.memberBasicDetail = memberBasicDetail;
	}

	public ArrayList<ReportInfo> getCommanList() {
		return commanList;
	}

	public void setCommanList(ArrayList<ReportInfo> commanList) {
		this.commanList = commanList;
	}

	public ArrayList<ReportInfo> getEmiList() {
		return emiList;
	}

	public void setEmiList(ArrayList<ReportInfo> emiList) {
		this.emiList = emiList;
	}

	public ArrayList<ReportInfo> getPaidEmiList() {
		return paidEmiList;
	}

	public void setPaidEmiList(ArrayList<ReportInfo> paidEmiList) {
		this.paidEmiList = paidEmiList;
	}

	public ArrayList<ReportInfo> getPenaltyPaidList() {
		return penaltyPaidList;
	}

	public void setPenaltyPaidList(ArrayList<ReportInfo> penaltyPaidList) {
		this.penaltyPaidList = penaltyPaidList;
	}

	public ArrayList<ReportInfo> getBounceList() {
		return bounceList;
	}

	public void setBounceList(ArrayList<ReportInfo> bounceList) {
		this.bounceList = bounceList;
	}

	public ArrayList<ReportInfo> getBouncePaidList() {
		return bouncePaidList;
	}

	public void setBouncePaidList(ArrayList<ReportInfo> bouncePaidList) {
		this.bouncePaidList = bouncePaidList;
	}



	public SimpleDateFormat getSf() {
		return sf;
	}



	public void setSf(SimpleDateFormat sf) {
		this.sf = sf;
	}



	public String getStrFirstEmiDate() {
		return strFirstEmiDate;
	}



	public void setStrFirstEmiDate(String strFirstEmiDate) {
		this.strFirstEmiDate = strFirstEmiDate;
	}



	public String getStrEndEmiDate() {
		return strEndEmiDate;
	}



	public void setStrEndEmiDate(String strEndEmiDate) {
		this.strEndEmiDate = strEndEmiDate;
	}



	public static long getSerialversionuid() {
		return serialVersionUID;
	}



	public double getDueInstallmentAmount() {
		return dueInstallmentAmount;
	}



	public void setDueInstallmentAmount(double dueInstallmentAmount) {
		this.dueInstallmentAmount = dueInstallmentAmount;
	}



	public double getTotalOutstanding() {
		return totalOutstanding;
	}



	public void setTotalOutstanding(double totalOutstanding) {
		this.totalOutstanding = totalOutstanding;
	}
	
	
}