package other_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.text.DecimalFormat;
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.DataBaseMethodsHemant;
import main_package.DataBaseConnection;
import main_package.LoanInfo;
import main_package.UserInfo;

import org.primefaces.context.RequestContext;

import report_package.DataBaseReportMethods;

@ManagedBean(name="parLoanReport")
@ViewScoped
public class LoanReportParticularBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	LoanInfo selectedLoan;
	double totalDebit,totalCredit,closingBalance, penaltyAmount,totalChqCharge,paidChqCharge,penaltyPaid, penaltyDue, penaltyDiscount,preclosurValue,rebatePreclosure;
	String type,frequency, loanType="";
	ArrayList<ReportInfo> list,dailyPayList;
	ArrayList<ReportInfo> list1= new ArrayList<>();
	ArrayList<LoanInfo> emiPaidDetailList;
	ArrayList<UserInfo>loanList=new ArrayList<>();
	ArrayList<String> emiPay;
	boolean showPenaltyField, showSubLoanField, showLoanPaidStatus, renField=true;
	String loanNo, subLoanNo="";
	DataBaseMethods dbm=new DataBaseMethods();
	DecimalFormat df=new DecimalFormat("##.##");
	double disOnLoanClose;
	DataBaseMethodsHemant dbmh=new DataBaseMethodsHemant();
	Date ledgerDate=new Date();
	
	public LoanReportParticularBean()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		Connection conn=DataBaseConnection.JAVAConnection();
		selectedLoan=(LoanInfo) ss.getAttribute("selectedLoan");
		if(selectedLoan!=null)
		{   
			type=selectedLoan.getLoanType();
			showPenaltyField=(boolean) ss.getAttribute("showPen");
			renField=false;
			
		
			//penaltyAmount=new DataBase().penaltyAmountPaidByApplicant(selectedLoan.getLoanNo());
			//// System.out.println("penalty : "+penaltyAmount);
			// System.out.println("Selected loan no :"+selectedLoan.getLoanNo());
			//list=new DataBaseMethodsOther().loanReport(selectedLoan.getLoanNo(),selectedLoan.getShareHolderNo(),selectedLoan.getLoanType(),conn);
			if(selectedLoan.getLoanType().equalsIgnoreCase("Group Loan") || selectedLoan.getLoanType().equalsIgnoreCase("grouploan"))
			{
				list=new DataBaseMethodsOther().loanReport(selectedLoan.getSubLoanNo(),selectedLoan.getShareHolderNo(),selectedLoan.getLoanType(),conn);
			}
			else
			{
				list=new DataBaseMethodsOther().loanReport(selectedLoan.getLoanNo(),selectedLoan.getShareHolderNo(),selectedLoan.getLoanType(),conn);
			}
			frequency=dbm.frequencyLabel(selectedLoan.getFrequency());
			
			if(selectedLoan.getPaidStatus().equalsIgnoreCase("paid"))
			{
				showLoanPaidStatus=true;
			}
			
			loanNo=selectedLoan.getLoanNo();
			subLoanNo=selectedLoan.getSubLoanNo();
			
			loanType=dbm.loanValueByLoanLabel(selectedLoan.getLoanType());
			
			if(subLoanNo==null || subLoanNo.equals(""))
			{
				showSubLoanField=false;
			}
			else
			{
				showSubLoanField=true;
			}
			//// System.out.println("penalty seldcteooioj: "+showPenaltyField);
			if(showPenaltyField==true)
			{
				penaltyAndChequeBounceCalculation();
			}
			calculate();
			
			for(ReportInfo ff:list)
			{
				
				if((ff.getAmount()!=0 && ff.getDebitAmount()!=0) || ff.getCreditAmount()!=0) 
				{
					// System.out.println(ff.getAmount());
					ReportInfo cate= new ReportInfo();
					cate.setAmount(ff.getAmount());
					cate.setStatus(ff.getStatus());
					cate.setDateStr(ff.getDateStr());
					cate.setCreditAmount(ff.getCreditAmount());
					cate.setDebitAmount(ff.getDebitAmount());
					list1.add(cate);
					// System.out.println("qshish");
				}
				
			}
		
		
		}
		
	}
	
	
	public void RebatePreclosure() throws IOException {
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("preclosureValue", preclosurValue);
		 RequestContext.getCurrentInstance().execute("window.open('prematurityStatement.xhtml')");
	//	return "prematurityStatement.xhtml";
	}
	
	public void loanStatement()
	{  
		Connection conn=DataBaseConnection.JAVAConnection();
		loanList= new ArrayList<>();
		LoanInfo obj=null ;
		
		if(selectedLoan.getLoanType().equalsIgnoreCase("Group Loan"))
		{
			
			obj=new DataBaseMethods().loanInfoByLoanNoLoanType(selectedLoan.getSubLoanNo(),"grouploan", conn);
			 double amount=((Double.valueOf(obj.getLoanTerm()))*obj.getInstallAmount())-Double.valueOf(obj.getLoanAmount());
			UserInfo tt=new UserInfo();
			tt.setCashRecievedStatus("AMT FINANCED");
			tt.setEntryDate(obj.getApprovalDate());
			tt.setFinanceAmt(Double.valueOf(obj.getLoanAmount())+amount);
			tt.setAmount(0);
			tt.setRecievedAmount(0);
			tt.setStatus("");
			tt.setBalance(0);
			tt.setOpeningAmt(Double.valueOf(obj.getLoanAmount())+amount);
			loanList.add(tt);
			loanList= new DataBaseReportMethods().loanStatementForSurya(selectedLoan.getSubLoanNo(),selectedLoan.getLoanType(),loanList,tt, conn);
		/*	for(UserInfo jj: loanList)
			{
				// System.out.println("dsdsdsdsdsdsdsdsd"+jj.getOpeningAmt());
				if(jj.getStatus().equalsIgnoreCase("due"))
				{
					
				}
			}*/
			
		}
		else
		{   
			
		    System.out.println("selected loan tyep is:"+selectedLoan.getLoanType());	
		    String loanType=   dbmh.loanTypeByLoanNo(selectedLoan.getLoanNo());
			obj=new DataBaseMethods().loanInfoByLoanNoLoanType(selectedLoan.getLoanNo(), loanType, conn);
			double amount=((Double.valueOf(obj.getLoanTerm()))*obj.getInstallAmount())-Double.valueOf(obj.getLoanAmount());
			//// System.out.println("sjdjdksjkdsjdjkskdjjsd"+Double.valueOf(obj.getLoanAmount()));
			UserInfo tt=new UserInfo();
			tt.setCashRecievedStatus("AMT FINANCED");
			tt.setEntryDate(obj.getApprovalDate());
			tt.setFinanceAmt(Double.valueOf(obj.getLoanAmount())+amount);
			tt.setAmount(0);
			tt.setRecievedAmount(0);
			tt.setStatus("");
			tt.setBalance(0);
			tt.setOpeningAmt(Double.valueOf(obj.getLoanAmount())+amount);
			loanList.add(tt);
			loanList= new DataBaseReportMethods().loanStatementForSurya(selectedLoan.getLoanNo(),selectedLoan.getLoanType(),loanList,tt, conn);
			double a=0;
			int i=0;
			/*for(UserInfo jj: loanList)
			{
				
				if(jj.getOpeningAmt() > 0)
				{
					// System.out.println("dsssssssssssssssssss"+jj.getOpeningAmt());
				a=jj.getOpeningAmt();
				}
				if(jj.getStatus().equalsIgnoreCase("due"))
				{
					// System.out.println("dsdsdsds"+a);
					jj.setOpeningAmt(a);
				}
				
			}*/
		}
		
		Collections.sort(loanList);		
		
		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", loanList);
		ss.setAttribute("selectedVal",selectedLoan);
		ss.setAttribute("operationVal", "loan");
		RequestContext.getCurrentInstance().execute("window.open('loanStatementForUser.xhtml')");
		
	}
	public void calculate()
	{
		
		totalCredit=totalDebit=closingBalance=disOnLoanClose=0;
		for(ReportInfo ll:list)
		{
			if(ll.getCreditAmount()>0)
			{
				totalCredit+=ll.getCreditAmount();
			}
			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);
		
	}
	
	public void loanLedgerReport()
	{
	    HttpSession ss=(HttpSession) FacesContext.getCurrentInstance()
	            .getExternalContext().getSession(false);

	    Connection conn = DataBaseConnection.JAVAConnection();

	    try
	    {   
	        UserInfo member =
	            dbm.userInfoByShareHolderNo(selectedLoan.getShareHolderNo(), conn);

	        UserInfo memberBranchDetail =
	            dbm.firmDetails(member.getBranchId());

	        // HeaderBean ke liye member branch ka address set
	        ss.setAttribute("selectedDataForHeaderBean", memberBranchDetail);

	        ss.setAttribute("sesLedgerDate", ledgerDate);

	        RequestContext.getCurrentInstance()
	            .execute("window.open('printLoanLedger.xhtml')");
	    }
	    catch(Exception e)
	    {
	        e.printStackTrace();
	    }
	    finally
	    {
	        try {
	            conn.close();
	        } catch (Exception e) {
	        }
	    }
	}
	
	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");
		ss.setAttribute("reportClosingBalance", closingBalance);
		ss.setAttribute("disOnLoanClose",disOnLoanClose);
		ss.setAttribute("totalEmi", 0.0);                         // RR 05/06
		ss.setAttribute("totalIntrest",0.0);                  // RR 05/06
		ss.setAttribute("totalPrincipal", 0.0);             // RR 05/06
		ss.setAttribute("totalPaid", 0.0);  
		
		RequestContext.getCurrentInstance().execute("window.open('printPerticularDatePaymentOld.xhtml')");
		
	}
	
	public void printDailyLoanAndSavingPay()
	{
		dailyPayList= new ArrayList<>();
		if(selectedLoan.getLoanType().equalsIgnoreCase("Group Loan") || selectedLoan.getLoanType().equalsIgnoreCase("grouploan"))
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanAndSavingReport(selectedLoan.getSubLoanNo());
		}
		else
		{
			dailyPayList= new DataBaseMethodsOther().dailyloanAndSavingReport(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");
		ss.setAttribute("reportClosingBalance", closingBalance);
		ss.setAttribute("disOnLoanClose",disOnLoanClose);
		ss.setAttribute("totalEmi", 0.0);                      // RR 05/06
		ss.setAttribute("totalIntrest",0.0);                  // RR 05/06
		ss.setAttribute("totalPrincipal", 0.0);             // RR 05/06
		ss.setAttribute("totalPaid", 0.0); 
		
		RequestContext.getCurrentInstance().execute("window.open('printPerticularDatePaymentOld.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 ArrayList<UserInfo> getLoanList() {
		return loanList;
	}


	public void setLoanList(ArrayList<UserInfo> loanList) {
		this.loanList = loanList;
	}


	public double getPreclosurValue() {
		return preclosurValue;
	}


	public void setPreclosurValue(double preclosurValue) {
		this.preclosurValue = preclosurValue;
	}


	public double getRebatePreclosure() {
		return rebatePreclosure;
	}


	public void setRebatePreclosure(double rebatePreclosure) {
		this.rebatePreclosure = rebatePreclosure;
	}


	public boolean isShowLoanPaidStatus() {
		return showLoanPaidStatus;
	}


	public void setShowLoanPaidStatus(boolean showLoanPaidStatus) {
		this.showLoanPaidStatus = showLoanPaidStatus;
	}


	public double getDisOnLoanClose() {
		return disOnLoanClose;
	}


	public void setDisOnLoanClose(double disOnLoanClose) {
		this.disOnLoanClose = disOnLoanClose;
	}


	public boolean isRenField() {
		return renField;
	}


	public void setRenField(boolean renField) {
		this.renField = renField;
	}


	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 DecimalFormat getDf() {
		return df;
	}


	public void setDf(DecimalFormat df) {
		this.df = df;
	}


	public DataBaseMethodsHemant getDbmh() {
		return dbmh;
	}


	public void setDbmh(DataBaseMethodsHemant dbmh) {
		this.dbmh = dbmh;
	}


	public Date getLedgerDate() {
		return ledgerDate;
	}


	public void setLedgerDate(Date ledgerDate) {
		this.ledgerDate = ledgerDate;
	}


	public static long getSerialversionuid() {
		return serialVersionUID;
	}
	
	
}