package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
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;

import org.primefaces.context.RequestContext;

import com.mysql.fabric.xmlrpc.base.Array;

@ManagedBean(name = "collectionCheckRepo")
@ViewScoped

public class CheckCollectionDueBean implements Serializable {

	String reportType, applicantName, rdDate, status, dt, dt1, dateRangeAmount, penaltyField = "no", dsaCode;
	Date endDate = new Date(), initialDt, initialDt1, startDate = new Date();
	double amount = 0.00, count1, count2, count3, sumAmount, sumAmountDateRange, dailyCollection;
	ArrayList<LoanInfo> loanEMIList, loanEMIList1;
	double amountToPaid, penaltyDue, amountPaid, dueAmount, totalPenalty, duePenalty, paidPenalty, amountDateRange,
			rdAmountToPaid, rdAmountPaid, rdAmountDateRange, amounToPaidDateRange, rdAmountToPaidDateRange,
			dailyCall = 0;
	ArrayList<LoanInfo> collectionList =  new ArrayList<>();
	ArrayList<LoanInfo> collectionList2;
	ArrayList<String> list = new ArrayList<>();

	ArrayList<String> list1;
	ArrayList<String> list2 = new ArrayList<>();
	Boolean tbl1 = false, showPenaltyField, showCenter;
	ArrayList<InstallmentInfo> rdFdList = new ArrayList<>();
	ArrayList<SelectItem> loanTypeList, dsaList, centerList;
	DecimalFormat df = new DecimalFormat("##.##");
	SimpleDateFormat sdfForDb = new SimpleDateFormat("yyyy-MM-dd");
	DataBaseMethods obj = new DataBaseMethods();
	int branchId;
	String branchUserId, center, paidStatus, frequency;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	boolean disAll;
	String userType;
	DbYashwant dby = new DbYashwant();
	DataBaseMethodsHemant dbmh = new DataBaseMethodsHemant();
	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
	DataBaseMethodsRaviK dbrk = new DataBaseMethodsRaviK();

	public CheckCollectionDueBean() {

		Connection con = DataBaseConnection.JAVAConnection();
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchId = (int) ss.getAttribute("branchId");
		branchList = new DataBaseMethods().branchList(branchUserId, con);
		centerList = new DataBaseMethods().allcenter(branchId, "all", con);

//			if(branchList.size()>0)
//			{
//				String bId=(String) branchList.get(0).getValue();
//				branchId=Integer.parseInt(bId);
//			}

		String cc = (String) ss.getAttribute("companyName");
		userType = (String) ss.getAttribute("type");
		disAll = dbmh.disAllByCompanyNameUserType(userType, cc);
		dsaList = obj.allDsaList(branchId, "Loan", con);

		try {
			con.close();
		} catch (Exception e) {
			// TODO: handle exception
		}

	}

	public void search() throws ParseException {
		if (branchId != 0) {
			Connection conn = DataBaseConnection.JAVAConnection();

			try {
				dt = new SimpleDateFormat("dd-MM-yyyy").format(endDate);
				dt1 = new SimpleDateFormat("dd-MM-yyyy").format(startDate);

				if (startDate.after(endDate)) {
					FacesContext fc = FacesContext.getCurrentInstance();

					fc.addMessage(null, new FacesMessage("Start Date Must Be Before End Date"));

					return;
				}

				if (reportType.equalsIgnoreCase("grouploan")) {
					showCenter = true;
				} else {
					showCenter = false;
				}

				if (reportType.equals("all") || reportType.equals("personalloan") || reportType.equals("grouploan")
						|| reportType.equals("secure_loan")) {

					tbl1 = true;
					int sno = 1;

					collectionList = new ArrayList<LoanInfo>();
					loanTypeList = obj.loanTypeList(conn);

					count1 = 0.00;
					count2 = 0.00;
					count3 = 0.00;

					dailyCollection = 0.00;
					dailyCall = 0.00;
					if (reportType.equalsIgnoreCase("all")) {
						ArrayList<String> tempList = new ArrayList<>();
						tempList = dby.collectionlist(endDate, loanTypeList, "Loan", branchId, dsaCode, center, conn,
								frequency);
						System.out.println(tempList.size());

						list.addAll(tempList);

						ArrayList<LoanInfo> tempList2 = new ArrayList<>();

						tempList2 = rdFd(startDate, endDate, "RD", branchId, dsaCode);
						collectionList.addAll(tempList2);
						System.out.println("SIZE IS FETCHING BY RAVI" + tempList2.size());

						tempList2 = rdFd(startDate, endDate, "FD", branchId, dsaCode);
						System.out.println("SIZE IS FETCHING BY RAVI" + tempList2.size());
						collectionList.addAll(tempList2);

					} else {
						list = dby.collectionlist(endDate, loanTypeList, reportType, branchId, dsaCode, center, conn,
								frequency);

					}
					System.out.println("Loan List Size = " + list.size());

					for (int i = 0; i < list.size(); i++) {
						String loanNo = list.get(i);

						Date emiDueDate = null;

						list1 = new ArrayList<String>();
							loanEMIList = obj.loanInstallment("personalloan", loanNo, conn);
						if (loanNo.contains("GL")) {

							loanEMIList = obj.loanInstallment("grouploan", loanNo, conn);

						} else if (loanNo.contains("SL")) {

							loanEMIList = obj.loanInstallment("secure_loan", loanNo, conn);

						} 
											
						else {

							loanEMIList = obj.loanInstallment("personalloan", loanNo, conn);

						}

						amountPaid = obj.amountPaid(loanNo, endDate, conn);
						// amountDateRange = obj.amountWithInDateRange(loanNo, startDate, endDate,
						// conn);
						
						int terms = dbrk.LoanTermByLoanNo(loanNo, branchId, conn);
						int paidEmiCount = 0;
						for (LoanInfo paidEmi : loanEMIList) {
						    double emiAmount = paidEmi.getInstallAmount();
							double emiPaidAmount = dbrk.fetchEMIPaidAmountByLoanNo(conn, loanNo, paidEmi.getSno(),branchId);

						    if (emiPaidAmount >= emiAmount) {
						        paidEmiCount++;
						    }
						}
						
						if (paidEmiCount >= terms) {
						    //System.out.println("ALL EMI PAID -> SKIPPING LOAN : " + loanNo);
						    continue;
						}
						
						String shrHolderNo = obj.shareHolderNoByLoanNo(loanNo);
						UserInfo ub = obj.memberBasicDetail(shrHolderNo, conn);

						applicantName = ub.getName();
						double instlAmount = 0.00;
						int count = 0;

						amountToPaid = 0.00;
						paidPenalty = 0.00;
						duePenalty = 0.00;
						amounToPaidDateRange = 0.00;
						status = "";

						for (LoanInfo ff : loanEMIList) {
							try {
								initialDt = new SimpleDateFormat("dd/MM/yyyy").parse(ff.getStrInstlmntDate());
							} catch (ParseException e) {
								e.printStackTrace();
								continue;
							}
							boolean emiInRange = (initialDt.after(startDate) || initialDt.equals(startDate))
									&& (initialDt.before(endDate) || initialDt.equals(endDate));

							if (!emiInRange) {
								continue;
							}
							if (emiDueDate == null) {
								emiDueDate = initialDt;
							}
							amounToPaidDateRange = amounToPaidDateRange + ff.getInstallAmount();

							if (initialDt.before(endDate) || initialDt.equals(endDate)) {
								amountToPaid = amountToPaid + ff.getInstallAmount();

								list1.add(ff.getStrInstlmntDate());
							}

							double emiAmount = ff.getInstallAmount();

							String emiPaidDate = dbrk.fetchLastEMIPaymentByLoanNo(conn, loanNo, ff.getSno(), branchId);

							double emiPaidAmount = dbrk.fetchEMIPaidAmountByLoanNo(conn, loanNo, ff.getSno(), branchId);

							String installmentDate = ff.getStrInstlmntDate();
							double emiDueAmount = emiAmount - emiPaidAmount;
							if (emiDueAmount < 0) {
								emiDueAmount = 0.00;
							}

							LoanInfo cate = new LoanInfo();
							cate.setLoanNo(loanNo);
							cate.setApplicantName(applicantName);
							cate.setStrEmiDueDate(new SimpleDateFormat("dd-MM-yyyy").format(initialDt));
							cate.setInstallAmount(emiAmount);
							cate.setPaidAmount(emiPaidAmount);
							cate.setDueAmount(emiDueAmount);

							SimpleDateFormat paidFormat = new SimpleDateFormat("dd-MM-yyyy");
							SimpleDateFormat installmentFormat = new SimpleDateFormat("dd/MM/yyyy");

							String emiStatus = "Due";

							if (emiPaidDate != null && !emiPaidDate.trim().equals("")) {

								Date paidDate = paidFormat.parse(emiPaidDate);
								Date instDate = installmentFormat.parse(installmentDate);

								if (paidDate.before(instDate)) {
									emiStatus = "Advance";
								} else if (emiDueAmount == 0.0) {
									emiStatus = "Clear";
								} else {
									emiStatus = "Due";
								}

							} else {
								emiStatus = "Due";
							}

							cate.setStatus(emiStatus);
							cate.setPaidDateStr(emiPaidDate);
							if (emiStatus.equals("Due")) {
								cate.setDateRangeAmount(String.valueOf(emiAmount) + " (D)");
							} else {
								cate.setDateRangeAmount(String.valueOf(0.00) + " (C)");
							}
							cate.setShareHolderNo(shrHolderNo);
							cate.setContactNo(ub.getContactNo());
							cate.setAddress(ub.getAddress());
							cate.setFatherHusbandName(ub.getFather_husband_name());
							cate.setAltMobileNo(ub.getAltMobileNo());

							String loanType = reportType;
							if (loanNo.contains("PL")) {

								String dsaCodeName = dbrk.dsaCodeByLoanNo(loanNo, "personalloan", branchId, conn);
								cate.setDsaName(dsaCodeName);
							} else if (loanNo.contains("GL")) {

								String dsaCodeName = dbrk.dsaCodeByLoanNo(loanNo, "grouploan", branchId, conn);
								cate.setDsaName(dsaCodeName);
							} else if (loanNo.contains("SL")) {

								String dsaCodeName = dbrk.dsaCodeByLoanNo(loanNo, "secure_loan", branchId, conn);
								cate.setDsaName(dsaCodeName);
							}

							if (reportType.equalsIgnoreCase("grouploan")) {
								cate.setCenterName(obj
										.centerNameCodeById(obj.centerIdByGroupLoanNo(branchId, loanNo, conn), conn));
							}

							if (penaltyField.equalsIgnoreCase("yes")) {
								showPenaltyField = true;

								double penaltyAmount;
								double penaltyPaid;
								double penaltyDiscount;

								penaltyDue = 0.00;

								penaltyAmount = obj.calculatePenaltyAndChequeBounceCharges(loanNo, "Penalty", loanType,
										conn);

								penaltyPaid = obj.totalPaidPenaltyAndChequeBounceCharges(loanNo, "Penalty", conn);

								penaltyDiscount = obj.discountOnPenaltyByLoanNo(loanNo);

								penaltyDue = penaltyAmount - penaltyPaid;

								penaltyAmount = Double.parseDouble(df.format(penaltyAmount));

								penaltyPaid = Double.parseDouble(df.format(penaltyPaid));

								penaltyDue = Double.parseDouble(df.format(penaltyDue));

								cate.setPenaltyDue(penaltyDue);
							}

							cate.setSno(sno++);
							collectionList.add(cate);

							dailyCollection = dailyCollection + emiPaidAmount;

							dailyCall = dailyCall + emiAmount;
						}
					}
				}

				else if (reportType.equals("DD") || reportType.equals("RD")) {

					ArrayList<LoanInfo> list1 = new ArrayList<LoanInfo>();
					list1 = rdFd(startDate, endDate, reportType, branchId, dsaCode);

					collectionList.addAll(list1);

				} else {
					FacesContext fc = FacesContext.getCurrentInstance();

					fc.addMessage(null, new FacesMessage("Select Scheme Type"));
				}
			} catch (Exception e) {
				e.printStackTrace();

				FacesContext fc = FacesContext.getCurrentInstance();

				fc.addMessage(null, new FacesMessage("Error : " + e.getMessage()));
			} finally {
				try {
					if (conn != null) {
						conn.close();
					}
				} catch (Exception e) {
					e.printStackTrace();
				}
			}

			ArrayList<LoanInfo> tempList = new ArrayList<LoanInfo>();

			int count = 1;

			if (collectionList != null) {
				for (int i = 0; i < collectionList.size(); i++) {
					LoanInfo info = collectionList.get(i);

					if (info.getInstallAmount() > 0 || info.getPaidAmount() > 0) {
						info.setSno(count);

						tempList.add(info);

						count++;
					}
				}
			}

			collectionList = tempList;

			tempList = new ArrayList<LoanInfo>();

			System.out.println("Final Collection List Size = " + collectionList.size());
		} else {
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
		}

		if (collectionList != null) {
			System.out.println("Final Row Count = " + collectionList.size());
		}
	}

	public ArrayList<LoanInfo> rdFd(Date startDate1, Date endDate1, String reportType2, int branchId, String dsaCode2) {

		showPenaltyField = false;

		tbl1 = true;

		collectionList2 = new ArrayList<LoanInfo>();
		Connection conn = DataBaseConnection.JAVAConnection();

		list2 = obj.listRdFd(endDate, reportType2, branchId, dsaCode2);

		int sno = 1;

		dailyCollection = 0.00;

		for (int j = 0; j < list2.size(); j++) {
			rdFdList = obj.showInstallment(list2.get(j), conn);

			// rdAmountPaid = obj.rdAmountPaid(list2.get(j), endDate);
			rdAmountPaid = dbrk.paidRdAmount(list2.get(j), branchId, conn);
			System.out.println("RD PAID AMOUNT" + rdAmountPaid);
			String shareHolderNum = obj.shareHolderNoByRdFdNo(list2.get(j));

			UserInfo ub = obj.memberBasicDetail(shareHolderNum, conn);

			applicantName = obj.applicantNameByShareHolderNo(shareHolderNum, conn);

			rdAmountDateRange = obj.rdAmountWithInDateRange(list2.get(j), startDate1, endDate1);

			rdAmountToPaid = 0.00;

			rdAmountToPaidDateRange = 0.00;

			int count = 0;

			double instlAmount = 0.00;

			for (InstallmentInfo obj1 : rdFdList) {
				String eDate = sdfForDb.format(endDate);
				String sDate = sdfForDb.format(startDate);

				String insDate = sdfForDb.format(obj1.getInstlmntDate());

				if (obj1.getInstlmntDate().before(endDate) || insDate.equals(eDate)) {
					rdDate = obj1.getIns_date();

					rdAmountToPaid = obj1.getInstallment_amount() + rdAmountToPaid;
				}

				if ((obj1.getInstlmntDate().after(startDate) || insDate.equals(sDate))
						&& (obj1.getInstlmntDate().before(endDate) || insDate.equals(eDate))) {
					rdAmountToPaidDateRange = rdAmountToPaidDateRange + obj1.getInstallment_amount();
				}

				if (count == 0 && insDate.equals(sDate)) {
					instlAmount = obj1.getInstallment_amount();

					count++;
				}
			}

			if (rdAmountToPaid > rdAmountPaid) {
				status = "Due";

				dueAmount = rdAmountToPaid - rdAmountPaid;
			} else if (rdAmountPaid == 0.00) {
				status = "No Amount Paid";

				dueAmount = 0.00;
			} else if (rdAmountToPaid - rdAmountPaid == 0.00) {
				status = "Clear";

				dueAmount = 0.00;
			} else {
				status = "Advance";

				dueAmount = rdAmountPaid - rdAmountToPaid;
			}

			if (rdAmountToPaidDateRange > rdAmountDateRange) {
				dateRangeAmount = String.valueOf(rdAmountToPaidDateRange - rdAmountDateRange) + " (D)";
			} else if (rdAmountDateRange == 0.00) {
				dateRangeAmount = "0.00 (NILL)";
			} else if (rdAmountToPaidDateRange - rdAmountDateRange == 0.00) {
				dateRangeAmount = "0.00 (C)";
			} else {
				dateRangeAmount = String.valueOf(rdAmountDateRange - rdAmountToPaidDateRange) + " (A)";
			}

			dailyCollection = rdAmountDateRange + dailyCollection;

			dailyCall = dailyCall + rdAmountToPaidDateRange;

			LoanInfo cate = new LoanInfo();

			cate.setLoanNo(list2.get(j));

			cate.setDueAmount(dueAmount);

			cate.setApplicantName(applicantName);

			cate.setDateRangeAmount(dateRangeAmount);

			cate.setStatus(status);

			cate.setPaidAmount(rdAmountPaid); // paid rd amount

			cate.setInstallAmount(instlAmount); // emiAmount

			cate.setSno(sno++);

			cate.setShareHolderNo(shareHolderNum);

			cate.setContactNo(ub.getContactNo());

			cate.setAddress(ub.getAddress());

			cate.setFatherHusbandName(ub.getFather_husband_name());

			collectionList2.add(cate);
		}
		return collectionList2;

	}

	public void print() {
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("collectionList", collectionList);
		ss.setAttribute("startDate", startDate);
		ss.setAttribute("endDate", endDate);
		ss.setAttribute("dailyCall", dailyCall);
		ss.setAttribute("dailyCollection", dailyCollection);
		ss.setAttribute("caDsaCode", dsaCode);

		RequestContext.getCurrentInstance().execute("window.open('printCollectionAnalysis.xhtml')");
	}

	public void printDueList() {
		dailyCall = dailyCollection = 0;
		ArrayList<LoanInfo> dueList = new ArrayList<>();
		for (LoanInfo ll : collectionList) {
			if (ll.dateRangeAmount.contains("(D)")) {
				dailyCall += ll.getInstallAmount();
				dailyCollection += ll.getPaidAmount();
				dueList.add(ll);
			}
		}
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("collectionList", dueList);
		ss.setAttribute("startDate", startDate);
		ss.setAttribute("endDate", endDate);
		ss.setAttribute("dailyCall", dailyCall);
		ss.setAttribute("dailyCollection", dailyCollection);
		RequestContext.getCurrentInstance().execute("window.open('printCollectionAnalysis.xhtml')");
	}

	public String getReportType() {
		return reportType;
	}

	public void setReportType(String reportType) {
		this.reportType = reportType;
	}

	public ArrayList<LoanInfo> getCollectionList() {
		return collectionList;
	}

	public void setCollectionList(ArrayList<LoanInfo> collectionList) {
		this.collectionList = collectionList;
	}

	public Boolean getTbl1() {
		return tbl1;
	}

	public void setTbl1(Boolean tbl1) {
		this.tbl1 = tbl1;
	}

	public String getDt() {
		return dt;
	}

	public void setDt(String dt) {
		this.dt = dt;
	}

	public Date getEndDate() {
		return endDate;
	}

	public Date getStartDate() {
		return startDate;
	}

	public String getDt1() {
		return dt1;
	}

	public void setDt1(String dt1) {
		this.dt1 = dt1;
	}

	public double getDailyCollection() {
		return dailyCollection;
	}

	public void setDailyCollection(double dailyCollection) {
		this.dailyCollection = dailyCollection;
	}

	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}

	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}

	public Boolean getShowPenaltyField() {
		return showPenaltyField;
	}

	public void setShowPenaltyField(Boolean showPenaltyField) {
		this.showPenaltyField = showPenaltyField;
	}

	public String getPenaltyField() {
		return penaltyField;
	}

	public void setPenaltyField(String penaltyField) {
		this.penaltyField = penaltyField;
	}

	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 ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public Boolean getShowCenter() {
		return showCenter;
	}

	public void setShowCenter(Boolean showCenter) {
		this.showCenter = showCenter;
	}

	public String getCenter() {
		return center;
	}

	public void setCenter(String center) {
		this.center = center;
	}

	public ArrayList<SelectItem> getCenterList() {
		return centerList;
	}

	public void setCenterList(ArrayList<SelectItem> centerList) {
		this.centerList = centerList;
	}

	public String getPaidStatus() {
		return paidStatus;
	}

	public void setPaidStatus(String paidStatus) {
		this.paidStatus = paidStatus;
	}

	public String getFrequency() {
		return frequency;
	}

	public void setFrequency(String frequency) {
		this.frequency = frequency;
	}

	public String getUserType() {
		return userType;
	}

	public void setUserType(String userType) {
		this.userType = userType;
	}

	public boolean isDisAll() {
		return disAll;
	}

	public void setDisAll(boolean disAll) {
		this.disAll = disAll;
	}

	public ArrayList<LoanInfo> getCollectionList2() {
		return collectionList2;
	}

	public void setCollectionList2(ArrayList<LoanInfo> collectionList2) {
		this.collectionList2 = collectionList2;
	}

}