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.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;

@ManagedBean(name="collectionAnalysis")
@ViewScoped
public class CollectionAnalysisBean 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;
	ArrayList<String> list;
	
	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 CollectionAnalysisBean()
	{   
		
		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
	{
		System.out.println(startDate);
		System.out.println(endDate);
		System.out.println(branchId);
		System.out.println(penaltyField);
		System.out.println(reportType);
		System.out.println(dsaCode);
		System.out.println(center);
		System.out.println(frequency);
		
		
		
		if(branchId != 0)
		{
			Connection conn=DataBaseConnection.JAVAConnection();
			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"));			
			}
			
			else
			{
				if(reportType.equalsIgnoreCase("grouploan"))
				{
					showCenter=true;
				}
				else
				{
					showCenter=false;
				}
				
				if(reportType.equals("Loan")||reportType.equals("personalloan")||reportType.equals("grouploan")||reportType.equals("secure_loan"))
				{
				   
				   System.out.println(reportType);
				   tbl1=true;
				   int sno=1;
				   collectionList=new ArrayList<>();
		           loanTypeList=obj.loanTypeList(conn);
		            
		            count1=0.00;count2=0.00;count3=0.00;dailyCollection=0.00;dailyCall=0;
					list= dby.collectionlist(endDate,loanTypeList,reportType,branchId, dsaCode,center,conn,frequency);
					 System.out.println("list s:"+list);
					for(int i=0;i<list.size();i++)
					{
						Date emiDueDate = null;
			   	    list1=new ArrayList<>();
			   		loanEMIList=obj.loanInstallment(reportType,list.get(i),conn);
			   		
			   		if(list.get(i).equalsIgnoreCase("PL-10100153"))
			   		{
			   			System.out.println("loan emi list size is"+loanEMIList.size());
			   		}
			   		
			   		amountPaid=obj.amountPaid(list.get(i),endDate,conn);
			   		amountDateRange= obj.amountWithInDateRange(list.get(i),startDate,endDate,conn);
			   		String paidDate = dbmt.fetchLastEMIPaymentByLoanNo(conn, list.get(i), startDate, endDate);
			   		String shrHolderNo=obj.shareHolderNoByLoanNo(list.get(i));
			   		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();
							}
				   		
				   		if (emiDueDate == null && (initialDt.before(endDate) || initialDt.equals(endDate))) {
				   	        emiDueDate = initialDt;
				   	    }
				   		
			   			if((initialDt.after(startDate) || initialDt.equals(startDate))&& (initialDt.before(endDate)  || initialDt.equals(endDate)))
			   			{
			   			   amounToPaidDateRange=amounToPaidDateRange+ff.getInstallAmount();
			   			}
			   		    
			   			if(initialDt.before(endDate) || initialDt.equals(endDate))
			   			{
		   					String dt=ff.getStrInstlmntDate();
		   				   amountToPaid=amountToPaid+ff.getInstallAmount();
		   				   
		   				   list1.add(dt);
			   			}
			   			
			   			if(count==0  && initialDt.equals(startDate))
			   			{ 
			   				           
			   				instlAmount=ff.getInstallAmount();
			   				// // System.out.println(instlAmount);
			   				count=count+1;
			   				
			   			}
				   	}
				   			
				  					String loanNo=list.get(i);
				  					String loanType=reportType;
				  					/*if(loanNo.contains("PL") || loanNo.contains("LA"))
				  					{
				  						loanType="personalloan";
				  					}
				  					else
				  					{
				  						loanType="grouploan";
				  					}*/
						   	
				  				if(penaltyField.equalsIgnoreCase("yes"))
				  				{
				  					showPenaltyField=true;
				  					double penaltyAmount,penaltyPaid,penaltyDiscount;
				  					penaltyDue=0;
							   		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));
				  				}
				  				
				   		if(amountToPaid>amountPaid )
					   		{
				   			 
					   			status="Due";
					   			dueAmount=amountToPaid-amountPaid;
					   			
					   		}
				   		else
			   				if(amountPaid==0.00)
			   				{
			   					status="No Amount Paid";
			   					dueAmount=0.00;
			   				}
				   		else
				   			if(amountToPaid-amountPaid==0.00)
					   			{
					   				status="Clear";
					   				dueAmount=0.00;
					   			}
				   			
			   			else
				   			{
				   				status="Advance";
				   				dueAmount=amountPaid-amountToPaid;
				   			}
				   		 
				   		 
			   		if(amounToPaidDateRange>amountDateRange )
				   		{
				   			dateRangeAmount=String.valueOf(amounToPaidDateRange-amountDateRange)+" (D)";
				   		}
			   		else
		   				if(amountDateRange==0.00)
		   				{
		   					dateRangeAmount=String.valueOf(0.00)+" (NILL)";
		   				}
			   		else
			   			if(amounToPaidDateRange-amountDateRange==0.00)
				   			{
			   				dateRangeAmount=String.valueOf(0.00)+" (C)";
				   			}
			   			
		   			else
			   			{
			   				dateRangeAmount=String.valueOf(amountDateRange-amounToPaidDateRange)+" (A)";
			   			}
			   		    dailyCollection=amountDateRange+dailyCollection;
			   		    dailyCall=dailyCall+amounToPaidDateRange;
			   		    
			   		     // // System.out.println("aaaaaaaaaaa"+amounToPaidDateRange);
				   		LoanInfo cate = new LoanInfo();
				   		
				   		
				   		cate.setLoanNo(list.get(i));
				   		cate.setDueAmount(dueAmount);
				   		cate.setStatus(status);
				   		cate.setDateRangeAmount(dateRangeAmount);
				   		cate.setApplicantName(applicantName);
				   		cate.setSno(sno++);
				   		cate.setInstallAmount(amounToPaidDateRange);
				   		System.out.println("noob2"+amounToPaidDateRange);
				   		cate.setPaidAmount(amountDateRange);
				   		cate.setPaidDateStr(paidDate);
				   		cate.setPenaltyDue(penaltyDue);
				   		cate.setShareHolderNo(shrHolderNo);
				   		cate.setContactNo(ub.getContactNo());
				   		cate.setAddress(ub.getAddress());
				   		cate.setFatherHusbandName(ub.getFather_husband_name());
				   		cate.setAltMobileNo(ub.getAltMobileNo());
				   		String dsaCodeName = dbrk.dsaCodeByLoanNo(loanNo, loanType, branchId, conn);
				   		cate.setDsaName(dsaCodeName);
				   		
				   		if (emiDueDate != null) 
				   		{
				   		    cate.setStrEmiDueDate(new SimpleDateFormat("dd-MM-yyyy").format(emiDueDate));
				   		}
				   		else 
				   		{
				   		    cate.setStrEmiDueDate("");
				   		}
				   		
				   		if(reportType.equalsIgnoreCase("grouploan"))
						{
				   			cate.setCenterName(obj.centerNameCodeById(obj.centerIdByGroupLoanNo(branchId,list.get(i), conn), conn));
						}
				   		collectionList.add(cate);
					   }    
				}
				
				else
					if(reportType.equals("DD")||reportType.equals("RD"))
					{
						showPenaltyField=false;
					   tbl1=true;
					   collectionList=new ArrayList<>();
						
							list2= obj.listRdFd(endDate,reportType,branchId, dsaCode);
						
						
						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);
								String shareHolderNum= obj.shareHolderNoByRdFdNo(list2.get(j));
								UserInfo ub=obj.memberBasicDetail(shareHolderNum, conn);
						   		applicantName=ub.getName();
								applicantName=obj.applicantNameByShareHolderNo(shareHolderNum, conn);
								rdAmountDateRange= obj.rdAmountWithInDateRange(list2.get(j),startDate,endDate);
							    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();
						   				// // System.out.println(instlAmount);
						   				count=count+1;
						   				
						   			}
										 
									}
								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=String.valueOf(0.00)+" (NILL)";
				   				}
					   		else
					   			if(rdAmountToPaidDateRange-rdAmountDateRange==0.00)
						   			{
					   				  dateRangeAmount=String.valueOf(0.00)+" (C)";
						   			}
				   			
				   			else
					   			{
					   				dateRangeAmount=String.valueOf(rdAmountDateRange-rdAmountToPaidDateRange)+" (A)";
					   			}	
				   		        
								dailyCollection=rdAmountDateRange+dailyCollection;
								// // System.out.println("@@@"+rdAmountDateRange);
								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.setPenaltyDue(rdAmountDateRange);
					   		cate.setPaidAmount(rdAmountDateRange);
					   		cate.setInstallAmount(rdAmountToPaidDateRange);
					   		cate.setSno(sno++);
					   		cate.setShareHolderNo(shareHolderNum);
					   		cate.setContactNo(ub.getContactNo());
					   		cate.setAddress(ub.getAddress());
					   		cate.setFatherHusbandName(ub.getFather_husband_name());
					   		collectionList.add(cate);
								 
							}
				}
					else
					{
						FacesContext fc=FacesContext.getCurrentInstance();
						fc.addMessage(null, new FacesMessage("Select Scheme Type"));
					}
				}
			try 
			{   
				conn.close();
			}
			catch (Exception e)
			{
				// TODO: handle exception
			}
		    
			ArrayList<LoanInfo> tempList=new ArrayList<>();
			int count=1;
			for(int i=0;i<collectionList.size();i++)
			{
				if(collectionList.get(i).getInstallAmount()>0 || collectionList.get(i).getPaidAmount()>0)
				{
					collectionList.get(i).setSno(count);
					tempList.add(collectionList.get(i));
					count++;
				}
			}
			
			collectionList=new ArrayList<>();
			collectionList=tempList;
			tempList=new ArrayList<>();
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Select Branch"));
		}
		System.out.println("test-1"+ collectionList.size());
		
		// Code Error Testing Pending 
	}
	
	
	
	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;
	}

}