package report_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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 main_package.DataBaseMethods;
import main_package.DataBaseMethodsHemant;
import main_package.DataBaseMethodsNaman;
import main_package.DataBaseMethodsRaviK;
import main_package.DataBaseConnection;
import main_package.DataBaseMethodRahul;
import main_package.DataBaseMethodTaheer;
import main_package.InstallmentInfo;
import main_package.LoanInfo;
import main_package.UserInfo;
import other_package.DealerInfo;

import org.primefaces.context.RequestContext;

@ManagedBean(name="dueRDReport")
@ViewScoped

public class DueRDReportBean implements Serializable
{
	ArrayList<String> list, dueDateList, dateList;
	ArrayList<InstallmentInfo> dueList, multipleRows;
	ArrayList<InstallmentInfo> pdueList ;
	ArrayList<LoanInfo> pendingLoanList, dueLoanList;
	String[] center;
	String dateValues,schemeType,labelForDepositNo, frequency, dsaCode, userId, strSearchDate, dueAmtType,branchName,bucketDayValue;
	InstallmentInfo selected;
	Boolean tblrndr, showBtn, showNonStarterBtn,disDsa, showCenter;
	UserInfo uInfo=null;
	Date searchDate=new Date();
	LoanInfo lInfo=null;
	int count, a, npaEmi, npaDays, branchId ;
	double grandTotalOfEmiAmount,grandTotalOfDueAmount;
	int totDueEmi;
	DataBaseMethods db=new DataBaseMethods();
	DataBaseReportMethods dbmr=new DataBaseReportMethods();
	ArrayList<SelectItem> freqList, dsaList, centerList;
	SimpleDateFormat sf=new SimpleDateFormat("dd/MM/yyyy");
	DecimalFormat df=new DecimalFormat("##.##");
	String branchUserId;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	DataBaseMethodRahul dbr = new DataBaseMethodRahul(); //RR
	DataBaseMethodsNaman dbn=new DataBaseMethodsNaman();
	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
	DataBaseMethodsRaviK dbrk = new DataBaseMethodsRaviK();
	int i=0;
	int l=0;
	boolean renAllForBranch;
	
	
	
	public DueRDReportBean() 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = new DataBaseMethods().branchList(branchUserId,conn);

		   String uname= (String) ss.getAttribute("username");
		   System.out.println("u name is:"+uname);
		    
		    String getDesignationName =DataBaseMethodsHemant.getDesignationByUname(uname);

//		    if(getDesignationName.equalsIgnoreCase("BRANCH MANAGER"))
//		    {
//		    	renAllForBranch=true;
//		    }
//		    else
//		    {
//		    	renAllForBranch=false;
//		    }

		    if(("BRANCH MANAGER").equalsIgnoreCase(getDesignationName))
		    {
		    	renAllForBranch=true;
		    }
		    else
		    {
		    	renAllForBranch=false;
		    }

		userId=db.userId();
		checkData();
		
		try 
		{
			conn.close();
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		} 
	}
	
	
	
	public void checkData() 
	{	
		Connection conn=DataBaseConnection.JAVAConnection();
		centerList=db.allcenter(branchId,"all",conn);
		dsaList=db.allDsaList(branchId,"",conn);
		String userId=db.userId();
		String empDataStatus=db.checkSMessageApiDetailFromTable("employee_wise_data", "",conn);
		
		if(db.userType().equals("employee") && empDataStatus.equalsIgnoreCase("active"))
		{
			dsaCode=db.dsaCodeByEmpUserId(userId, conn);
			disDsa=true;
		}
		
		try 
		{
			conn.close();
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
	}

	
	
	public void createFrequencyList()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		if(schemeType.equalsIgnoreCase("DD") || schemeType.equalsIgnoreCase("RD"))
		{
			showBtn=false;
		} else if(schemeType.equalsIgnoreCase("all")){
			
			showBtn=true;
			freqList=db.frequencySelectItemListFormLoanTable(branchId,"personalloan", conn);
			
		}
		else
		{ 
			showBtn=true;
			freqList=db.frequencySelectItemListFormLoanTable(branchId,schemeType, conn);
		}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	
	public void sendMsg() throws IOException
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		
		if(multipleRows.size()>0)
		{
			Connection conn=DataBaseConnection.JAVAConnection();
			String check=db.checkStatusInMessageSettingTable("Due Emi");
			if(check.equals("active"))
			{	
				boolean isDLT = dbmt.isDLTMessageApi(conn);
				
				for(InstallmentInfo ll: multipleRows)
				{
					if (isDLT)  
					{
						Map<String, String> variables = new HashMap<>();
						variables.put("name", ll.getName());
						variables.put("amount", String.valueOf(ll.getPaidAmount()));
						variables.put("loanNo", ll.getUser_no());

						dbmt.sendDLTMessage(ll.getContactNo(), null, variables, conn, "overdue EMI");
					}
	 			 	else 
	 			 	{
						String typeMessage="Dear "+ll.getName()+", Your Total Due Rs. "+ll.getPaidAmount();
						db.runMessageUrl(branchId,ll.getContactNo(), typeMessage, userId,"1207161799197481933", conn);
						typeMessage="";
	 			 	}
				}
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(multipleRows.size()+" Message Send Sucessfully"));
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Message For This Module is not Active. Please Go to In User Block and Active Message For This Module."));
			}
			
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Select Atleast One Contact no from List."));
		}
	}
	
	public void sendWhatsApp()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		for(InstallmentInfo ll: multipleRows)
		{
			String typeMessage="Dear "+ll.getName()+" "+ll.getUser_no()+", Your Total Due Rs. "+ll.getPaidAmount();
			db.runWhatsAppUrl(ll.getContactNo(), typeMessage, conn);
		}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void search()
	{  
		System.out.println("Time 1 : "+new Timestamp(new Date().getTime()));
		
		if(i==0||schemeType.equalsIgnoreCase("personalloan")||schemeType.equalsIgnoreCase("grouploan")||schemeType.equalsIgnoreCase("secure_loan"))
		{ 
			if(l==0) {
				
			System.out.println("NEW LIST MADE");
		    pdueList = new ArrayList<>();
			}
		}
		i++;
		 
		  if("all".equalsIgnoreCase(schemeType)) {
			 
			  for(int k=0 ; k<3 ; k++) 
			  {				  
				  if(k==0) {
					  l=1;
					  pdueList = new ArrayList<>();
					  schemeType="personalloan";
					  search();
				  }else if(k==1) {
					  schemeType = "grouploan";
					  search();
				  }else if(k==2) {
					  schemeType = "secure_loan";
					  search();
					  schemeType = "break";
					  i=0;
					  l=0;
				  }
				  
			  }
			  
		  }
		  
		  if(!schemeType.equalsIgnoreCase("break")) {
		 
		branchName = new DataBaseMethods().bNameById(branchId); // RR 20/5
		strSearchDate=sf.format(searchDate);
		grandTotalOfDueAmount=grandTotalOfEmiAmount=totDueEmi=0;
		Connection conn=DataBaseConnection.JAVAConnection();
		tblrndr=true;
		   list=new ArrayList<>();
		   dueList= new ArrayList<>();
		  
		   dueDateList= new ArrayList<>();
		   if(schemeType.equalsIgnoreCase("dd") || schemeType.equalsIgnoreCase("rd"))
		   {
			   showNonStarterBtn=false;
			   labelForDepositNo="Deposit";
			
			   System.out.println("Time 2 : "+new Timestamp(new Date().getTime()));
			   
		   list= db.listDueRd(schemeType, dsaCode,branchId,conn);
		   int sn=1;
		   boolean chk=false;
		   Date dueDate=null;
		   
		   System.out.println("Time 3 : "+new Timestamp(new Date().getTime()));
		   
		   for(int i=0;i<list.size();i++)
			   {
				    count=0;int dueAmt=0;
				   dueList= db.showInstallment(list.get(i), conn);
				   for(int l=0;l<dueList.size();l++)
					 {
						if(!dueList.get(l).getStatus().equalsIgnoreCase("Paid"))
						  {
							 if(searchDate.after(dueList.get(l).getInstlmntDate()) && !sf.format(searchDate).equals(dueList.get(l).getIns_date()))
								{
								  
								  dueDateList.add(count+1+" - "+ sf.format(dueList.get(l).getInstlmntDate())+"?"+dueList.get(l).getUser_no());
								  count++;
								  dueAmt+=dueList.get(l).getDueAmount();
								  if(chk==false)
								  {
									  dueDate=dueLoanList.get(l).getInstallDate();
									  chk=true;
								  }
								}
						  }
						   if(l==dueList.size()-1 && count!=0)
						   { 
							
							InstallmentInfo cate= new InstallmentInfo();
							cate.setCount(count);
	                        cate.setSno(sn++);
	                        cate.setShareHolderNo(db.shareHolderNoByRdFdNo(dueList.get(l).getUser_no()));
	                        UserInfo basicDetail=db.memberBasicDetail(cate.getShareHolderNo(), conn);
	                        cate.setUser_no(dueList.get(l).getUser_no());
	                        cate.setName(dueList.get(l).getName());
	                        cate.setFatherHusbandName(basicDetail.getFather_husband_name());
	                        cate.setAddress(basicDetail.getAddress());
	                        cate.setPaidAmount(dueAmt);
	                        cate.setEmiAmount(dueList.get(l).getInstallment_amount());
	                        cate.setContactNo(basicDetail.getContactNo());
	                        cate.setStrPayOutDate(sf.format(dueDate));
	                        
							pdueList.add(cate);        
							 
						   }
					  }
				}
		   
		   		System.out.println("Time 4 : "+new Timestamp(new Date().getTime()));
		   	
		   }
		   else
		   {
			   System.out.println("Time 5 : "+new Timestamp(new Date().getTime()));
			   
			   showNonStarterBtn=true;
			   list= db.loanEmiDueList(branchId,schemeType, frequency, dsaCode,center, conn);
			   
			   System.out.println("Time 6 : "+new Timestamp(new Date().getTime()));
			   
			   if(list.size()==0)
			   {
				 //  FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Record Found !!"));
			   }
			   else
			   {
				   labelForDepositNo="Loan";
			   int sn=1;
			   for(int i=0;i<list.size();i++)
			   {
				    count=0;
				    Boolean checkDays=true;int days=0; //both variable add on 14 Sept 2023 due to days calculation
				    double dueAmt=0;
				    
				    System.out.println("Time 7 : "+new Timestamp(new Date().getTime()));
				    
				   dueLoanList= db.loanInstallment(schemeType, list.get(i), conn);
				   
				   System.out.println("Time 8 : "+new Timestamp(new Date().getTime()));
				  
				   boolean chk=false;
				   Date dueDate=null;
				   double totalDue=0;int balEmi=0;
				   for(int l=0;l<dueLoanList.size();l++)
					 {
					   System.out.println("Time 9 : "+new Timestamp(new Date().getTime()));
					   
						if(!dueLoanList.get(l).getStatus().equals("Paid"))
						  {
							 if(searchDate.after(dueLoanList.get(l).getInstallDate()) && !sf.format(searchDate).equals(dueLoanList.get(l).getStrInstlmntDate()))
								{
								  dueDateList.add(count+1+" - "+ sf.format(dueLoanList.get(l).getInstallDate())+"?"+list.get(i));
								  count++;
								  
								  	if(dueAmtType.equalsIgnoreCase("onlyPrincipal"))
									 {
								  		dueAmt+=dueLoanList.get(l).getPrincipal();
									 }
									 else if(dueAmtType.equalsIgnoreCase("onlyInterest"))
									 {
										 dueAmt+=dueLoanList.get(l).getInterest();
									 }
									 else
									 {
										 dueAmt+=dueLoanList.get(l).getDueAmount();
									 }
								  	
								 
								  if(chk==false)
								  {
									  dueDate=dueLoanList.get(l).getInstallDate();
									  chk=true;
								  }
								  

								  if(checkDays==true)
								  {
									  days = (int) ((searchDate.getTime()-dueLoanList.get(l).getInstallDate().getTime()) / (1000 * 60 * 60 * 24));
									  //System.out.println(list.get(i)+" = "+dueLoanList.get(l).getInstallDate()+" : Days : "+days);
									  checkDays=false;
								  }
								  
								  dueAmt=Double.parseDouble(df.format(dueAmt));
								}
							 
							 if(dueAmtType.equalsIgnoreCase("onlyPrincipal"))
							 {
								 totalDue+=dueLoanList.get(l).getPrincipal();
							 }
							 else if(dueAmtType.equalsIgnoreCase("onlyInterest"))
							 {
								 totalDue+=dueLoanList.get(l).getInterest();
							 }
							 else
							 {
								 totalDue+=dueLoanList.get(l).getDueAmount();
							 }
							 balEmi++;
						  }
					
						     if(l==dueLoanList.size()-1 && count!=0)
						   {
							InstallmentInfo cate= new InstallmentInfo();
							
							cate.setCount(count);
	                        cate.setSno(sn++);
	                        cate.setShareHolderNo(db.shareHolderNoByLoanNoLoanType(list.get(i), schemeType));
	                        UserInfo basicDetail=db.memberBasicDetail(cate.getShareHolderNo(), conn);
	                        cate.setUser_no(list.get(i));
	                        cate.setName(basicDetail.getName());
	                        lInfo=db.loanInfoByLoanNoLoanType(list.get(i), schemeType, conn);
	                        
	                        cate.setPaidAmount(Double.parseDouble(df.format(dueAmt)));
	                        cate.setEmiAmount(lInfo.getInstallAmount());
	                        cate.setContactNo(basicDetail.getContactNo());
	                        cate.setFatherHusbandName(basicDetail.getFather_husband_name());
	                        cate.setAddress(basicDetail.getAddress());
	                        cate.setStrPayOutDate(sf.format(dueDate));
	                        
	                       //Rahulchanges  
	                        
	                       
	                        int branchId =  dbr.branchIdByLoanTypeAndLoanNo(schemeType, list.get(i));
	                        String branchNN = db.branchNameByBranchId(branchId, conn);
	                        String lastPaidDate = dbr.lastPaidEmiDateByLoanNo(list.get(i));
	                       
	                        cate.setLastEmiPaidDate(lastPaidDate);
	                        
	                        cate.setBranchName(branchNN);
	                        if(schemeType.equalsIgnoreCase("grouploan"))
	                        {
	                        	 cate.setStatus(lInfo.getCenterName());
	                        	 showCenter=true;
	                        }
	                        else
	                        {
	                        	showCenter=false;
	                        }
	                        cate.setDays(days);
	                        if (days >= 1 && days <= 30) {
	                            cate.setBucket("1");
	                        } else if (days >= 31 && days <= 60) {
	                            cate.setBucket("2");
	                        } else if (days >= 61 && days <= 90) {
	                            cate.setBucket("3");
	                        } else {
	                            cate.setBucket("3+");
	                        }
                           //Rahul changes ends here 6-6-2025
	                        
	                        
	                        // add five column RK Rise 11-Jan-2024
	                        LoanInfo ll=db.loanInfoByLoanNoLoanType(list.get(i), schemeType, conn);
	                        cate.setDsaName(ll.getDsaName());
	                        cate.setDsaCode(ll.getDsacode());
	                        cate.setLoanAmount(ll.getLoanAmtInt());
	                        cate.setTerms(ll.getTerms());
	                        //int m=db.totalEMIPaidByLoanNo(ll.getLoanNo(), conn);
	                        cate.setBalTerms(balEmi);
	                        
	                        double interestAmt = dbrk.interestAmtByLoannoId(branchId, list.get(i), schemeType, conn);
	                        double emiAmount = lInfo.getInstallAmount();
 	                        double principleAmountCal = emiAmount - interestAmt;
	                        double principleDueEmi = balEmi * principleAmountCal;
	                        cate.setPrincipleEmiAmt(principleDueEmi);
	                        
	                        cate.setTotalDueAmount(Double.parseDouble(df.format(totalDue)));
	                        
	                        UserInfo g1BasicDetail=db.memberBasicDetail(ll.getFirstGuarantor(), conn); //dbmr.gurantor1ByLoanNo(list.get(i), schemeType, conn), conn
	                        cate.setG1Name(g1BasicDetail.getName());
	                        cate.setG1Address(g1BasicDetail.getAddress());
	                        cate.setG1ContactNo(g1BasicDetail.getContactNo());
	                      
	                        if ("secure_loan".equalsIgnoreCase(schemeType)) {

	                            DealerInfo dInfo =
	                                dbn.getSecureLoanMobileDealerInfo(list.get(i), conn);

	                            if (dInfo != null) {
	                                cate.setDealerName(dInfo.getShortName());
	                                cate.setDealerFullName(dInfo.getFullName());
	                            }
	                            
	                            DealerInfo dealInfo = dbrk.getDeviceDetailsByloanNo(list.get(i), conn);
	                            if (dealInfo != null) {
	                            	cate.setImei1(dealInfo.getImeiNo1());
	                            	cate.setImei2(dealInfo.getImeiNo2());
									cate.setMobileModel(dealInfo.getModalName());
									
								}
	                            
	                        }

	                        
							pdueList.add(cate);        
							 
						   }
						     
						     System.out.println("Time 10 : "+new Timestamp(new Date().getTime()));
					  }
				
				   
				   }
			   }
			   
		   }
		   for(InstallmentInfo ll : pdueList)
		   {
			   grandTotalOfDueAmount +=ll.getPaidAmount();
			   grandTotalOfEmiAmount +=ll.getEmiAmount();
			   totDueEmi+=ll.getCount();
		   }
		   try 
		   {
			   conn.close();
		   } 
		   catch (SQLException e) 
		   {
			// TODO Auto-generated catch block
			e.printStackTrace();
		   }
		   
		  }
		  
		
		
	}
	
	public String print()
	{
		
		HttpSession ses=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
        ses.setAttribute("list", pdueList);
        ses.setAttribute("grandTotalOfDueAmount", grandTotalOfDueAmount);
        ses.setAttribute("grandTotalOfEmiAmount", grandTotalOfEmiAmount);
        ses.setAttribute("grandTotDueEmi", totDueEmi);
        ses.setAttribute("labelForDepositNo", labelForDepositNo);
        RequestContext.getCurrentInstance().execute("window.open('PrintPendingDepositAndLoanReport.xhtml')");
		
        return "";
	}
	
	
	public String printDue()
	{
		int i=0;grandTotalOfEmiAmount=grandTotalOfDueAmount=0;
		ArrayList<InstallmentInfo> tempList=new ArrayList<>();
		if(pdueList.size()>0)
		{
			for(InstallmentInfo ii: pdueList)
			{
				if(ii.getCount()>=npaEmi)
				{
					 tempList.add(ii);
					 tempList.get(i).setSno(++i);
				}
			}
		}
		
	   for(InstallmentInfo ll : tempList)
	   {
		   grandTotalOfDueAmount +=ll.getPaidAmount();
		   grandTotalOfEmiAmount +=ll.getEmiAmount();
	   }
		   
		HttpSession ses=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
        ses.setAttribute("list", tempList);
        ses.setAttribute("grandTotalOfDueAmount", grandTotalOfDueAmount);
        ses.setAttribute("grandTotalOfEmiAmount", grandTotalOfEmiAmount);
        ses.setAttribute("grandTotDueEmi", totDueEmi);
        ses.setAttribute("labelForDepositNo", labelForDepositNo);
        RequestContext.getCurrentInstance().execute("window.open('PrintPendingDepositAndLoanReport.xhtml')");
		
        return "";
	}
	
	public String printNonStarter()
	{
		int i=0;grandTotalOfEmiAmount=grandTotalOfDueAmount=0;
		ArrayList<InstallmentInfo> tempList=new ArrayList<>();
		Connection conn=DataBaseConnection.JAVAConnection();
		if(pdueList.size()>0)
		{
			for(InstallmentInfo ii: pdueList)
			{
				double pamt=db.loanPaidAmountByUser(schemeType, ii.getUser_no(), conn);
				if(pamt<=0)
				{
					 tempList.add(ii);
					 tempList.get(i).setSno(++i);
				}
			}
		}
		
	   for(InstallmentInfo ll : tempList)
	   {
		   grandTotalOfDueAmount +=ll.getPaidAmount();
		   grandTotalOfEmiAmount +=ll.getEmiAmount();
	   }
	   
	   try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		   
		HttpSession ses=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
        ses.setAttribute("list", tempList);
        ses.setAttribute("grandTotalOfDueAmount", grandTotalOfDueAmount);
        ses.setAttribute("grandTotalOfEmiAmount", grandTotalOfEmiAmount);
        ses.setAttribute("grandTotDueEmi", totDueEmi);
        ses.setAttribute("labelForDepositNo", labelForDepositNo);
        RequestContext.getCurrentInstance().execute("window.open('PrintPendingDepositAndLoanReport.xhtml')");
		
        return "";
	}
	
	public String printOverTime()
	{
		int i=0;grandTotalOfEmiAmount=grandTotalOfDueAmount=totDueEmi=0;
		ArrayList<InstallmentInfo> tempList=new ArrayList<>();
		Connection conn=DataBaseConnection.JAVAConnection();
		if(pdueList.size()>0)
		{
			for(InstallmentInfo ii: pdueList)
			{
				ArrayList<LoanInfo> loanEmiListt=db.loanInstallment(schemeType, ii.getUser_no(), conn);
				//System.out.println(ii.getUser_no()+" Date "+loanEmiListt.get(loanEmiListt.size()-1).getInstallDate());
				if(searchDate.after(loanEmiListt.get(loanEmiListt.size()-1).getInstallDate()))
				{
					 tempList.add(ii);
					 tempList.get(i).setSno(++i);
				}
			}
		}
		
	   for(InstallmentInfo ll : tempList)
	   {
		   grandTotalOfDueAmount +=ll.getPaidAmount();
		   grandTotalOfEmiAmount +=ll.getEmiAmount();
		   totDueEmi+=ll.getCount();
	   }
	   
	   try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		   
		HttpSession ses=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
        ses.setAttribute("list", tempList);
        ses.setAttribute("grandTotalOfDueAmount", grandTotalOfDueAmount);
        ses.setAttribute("grandTotalOfEmiAmount", grandTotalOfEmiAmount);
        ses.setAttribute("labelForDepositNo", labelForDepositNo);
        ses.setAttribute("sesSearchDate", searchDate);
        ses.setAttribute("dueReportDsa", dsaCode);
        
        
        RequestContext.getCurrentInstance().execute("window.open('PrintPendingDepositAndLoanReport.xhtml')");
		
        return "";
	}
	
	public String printActiveDueAccount()
	{
		int i=0;grandTotalOfEmiAmount=grandTotalOfDueAmount=totDueEmi=0;
		ArrayList<InstallmentInfo> tempList=new ArrayList<>();
		Connection conn=DataBaseConnection.JAVAConnection();
		if(pdueList.size()>0)
		{
			for(InstallmentInfo ii: pdueList)
			{
				ArrayList<LoanInfo> loanEmiListt=db.loanInstallment(schemeType, ii.getUser_no(), conn);
				//System.out.println(ii.getUser_no()+" Date "+loanEmiListt.get(loanEmiListt.size()-1).getInstallDate());
				if(searchDate.before(loanEmiListt.get(loanEmiListt.size()-1).getInstallDate()))
				{
					 tempList.add(ii);
					 tempList.get(i).setSno(++i);
				}
			}
		}
		
	   for(InstallmentInfo ll : tempList)
	   {
		   grandTotalOfDueAmount +=ll.getPaidAmount();
		   grandTotalOfEmiAmount +=ll.getEmiAmount();
		   totDueEmi+=ll.getCount();
	   }
	   
	   try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		   
		HttpSession ses=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
        ses.setAttribute("list", tempList);
        ses.setAttribute("grandTotalOfDueAmount", grandTotalOfDueAmount);
        ses.setAttribute("grandTotalOfEmiAmount", grandTotalOfEmiAmount);
        ses.setAttribute("labelForDepositNo", labelForDepositNo);
        ses.setAttribute("sesSearchDate", searchDate);
        ses.setAttribute("dueReportDsa", dsaCode);
        
        
        RequestContext.getCurrentInstance().execute("window.open('PrintPendingDepositAndLoanReport.xhtml')");
		
        return "";
	}
	
	
	
	public String printDueDays()
	{
		int i=0;grandTotalOfEmiAmount=grandTotalOfDueAmount=0;
		ArrayList<InstallmentInfo> tempList=new ArrayList<>();
		
		if(pdueList.size()>0)
		{
			for(InstallmentInfo ii: pdueList)
			{
				if(ii.getDays()>=npaDays)
				{
					 tempList.add(ii);
					 tempList.get(i).setSno(++i);
				}
			}
		}
		
	   for(InstallmentInfo ll : tempList)
	   {
		   grandTotalOfDueAmount +=ll.getPaidAmount();
		   grandTotalOfEmiAmount +=ll.getEmiAmount();
	   }
		   
		HttpSession ses=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
        ses.setAttribute("list", tempList);
        ses.setAttribute("grandTotalOfDueAmount", grandTotalOfDueAmount);
        ses.setAttribute("grandTotalOfEmiAmount", grandTotalOfEmiAmount);
        ses.setAttribute("labelForDepositNo", labelForDepositNo);
        ses.setAttribute("sesSearchDate", searchDate);
        ses.setAttribute("dueReportDsa", dsaCode);
        ses.setAttribute("grandTotDueEmi", totDueEmi);
        
        RequestContext.getCurrentInstance().execute("window.open('PrintPendingDepositAndLoanReport.xhtml')");
		
        return "";
	}
	
	//RR method 20/5
	
	public String printBucketDays()
	{ 
		
	
		
		
		int  from=0 , to=0 ;
		
		if ("1".equals(bucketDayValue)) {
			
		   from = 1; to = 30 ;
			
		}else if("2".equals(bucketDayValue)) {
			
			  from = 30; to = 60 ;
			
		}else if("3".equals(bucketDayValue)) {
					
			  from = 60; to = 90;
			
		}else if("4".equals(bucketDayValue)) {
			
			  from = 90; to = 99999 ;
			
		}else {
			
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Alert ! Please Enter value 1 to 4"));
			
		}
		
		
		int i=0;grandTotalOfEmiAmount=grandTotalOfDueAmount=0;
		ArrayList<InstallmentInfo> tempList=new ArrayList<>();
		
		if(pdueList.size()>0)
		{
			for(InstallmentInfo ii: pdueList)
			{
				if(ii.getDays()>=from && ii.getDays()<=to)
				{
					 tempList.add(ii);
					 tempList.get(i).setSno(++i);
				
				}
			}
		}
		
	   for(InstallmentInfo ll : tempList)
	   {
		   grandTotalOfDueAmount +=ll.getPaidAmount();
		   grandTotalOfEmiAmount +=ll.getEmiAmount();
	   }
		   
		HttpSession ses=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
        ses.setAttribute("list", tempList);
        ses.setAttribute("grandTotalOfDueAmount", grandTotalOfDueAmount);
        ses.setAttribute("grandTotalOfEmiAmount", grandTotalOfEmiAmount);
        ses.setAttribute("labelForDepositNo", labelForDepositNo);
        ses.setAttribute("sesSearchDate", searchDate);
        ses.setAttribute("dueReportDsa", dsaCode);
        ses.setAttribute("branchName", branchName);
        ses.setAttribute("grandTotDueEmi", totDueEmi);
        
        RequestContext.getCurrentInstance().execute("window.open('PrintPendingDepositAndLoanReport.xhtml')");
		
        return "";
	}
	
	
	
	public void dueDate()
	{
		dateList= new ArrayList<>();
	
       for(int i=0;i<dueDateList.size();i++)
       {
    	   String[] temp= dueDateList.get(i).split("\\?");
    	   if(temp[1].equals(selected.getUser_no()))
    	   {
    		   dateList.add(temp[0]);
    	   }
       }
		
      
	}

	public ArrayList<InstallmentInfo> getDueList() {
		return dueList;
	}

	public void setDueList(ArrayList<InstallmentInfo> dueList) {
		this.dueList = dueList;
	}


	public int getCount() {
		return count;
	}

	public void setCount(int count) {
		this.count = count;
	}

	public int getA() {
		return a;
	}

	public void setA(int a) {
		this.a = a;
	}

	public ArrayList<InstallmentInfo> getPdueList() {
		return pdueList;
	}

	public void setPdueList(ArrayList<InstallmentInfo> pdueList) {
		this.pdueList = pdueList;
	}

	public ArrayList<String> getDueDateList() {
		return dueDateList;
	}

	public void setDueDateList(ArrayList<String> dueDateList) {
		this.dueDateList = dueDateList;
	}

	public String getDateValues() {
		return dateValues;
	}

	public void setDateValues(String dateValues) {
		this.dateValues = dateValues;
	}

	public ArrayList<String> getDateList() {
		return dateList;
	}

	public void setDateList(ArrayList<String> dateList) {
		this.dateList = dateList;
	}

	public ArrayList<String> getList() {
		return list;
	}

	public void setList(ArrayList<String> list) {
		this.list = list;
	}

	public InstallmentInfo getSelected() {
		return selected;
	}

	public void setSelected(InstallmentInfo selected) {
		this.selected = selected;
	}

	public String getSchemeType() {
		return schemeType;
	}

	public void setSchemeType(String schemeType) {
		this.schemeType = schemeType;
	}

	public Boolean getTblrndr() {
		return tblrndr;
	}

	public void setTblrndr(Boolean tblrndr) {
		this.tblrndr = tblrndr;
	}

	public ArrayList<LoanInfo> getDueLoanList() {
		return dueLoanList;
	}

	public void setDueLoanList(ArrayList<LoanInfo> dueLoanList) {
		this.dueLoanList = dueLoanList;
	}

	public String getLabelForDepositNo() {
		return labelForDepositNo;
	}

	public void setLabelForDepositNo(String labelForDepositNo) {
		this.labelForDepositNo = labelForDepositNo;
	}

	public double getGrandTotalOfEmiAmount() {
		return grandTotalOfEmiAmount;
	}

	public void setGrandTotalOfEmiAmount(double grandTotalOfEmiAmount) {
		this.grandTotalOfEmiAmount = grandTotalOfEmiAmount;
	}

	public double getGrandTotalOfDueAmount() {
		return grandTotalOfDueAmount;
	}

	public void setGrandTotalOfDueAmount(double grandTotalOfDueAmount) {
		this.grandTotalOfDueAmount = grandTotalOfDueAmount;
	}

	public int getNpaEmi() {
		return npaEmi;
	}

	public void setNpaEmi(int npaEmi) {
		this.npaEmi = npaEmi;
	}

	public ArrayList<LoanInfo> getPendingLoanList() {
		return pendingLoanList;
	}

	public void setPendingLoanList(ArrayList<LoanInfo> pendingLoanList) {
		this.pendingLoanList = pendingLoanList;
	}

	public Boolean getShowBtn() {
		return showBtn;
	}

	public void setShowBtn(Boolean showBtn) {
		this.showBtn = showBtn;
	}

	public UserInfo getuInfo() {
		return uInfo;
	}

	public void setuInfo(UserInfo uInfo) {
		this.uInfo = uInfo;
	}

	public LoanInfo getlInfo() {
		return lInfo;
	}

	public void setlInfo(LoanInfo lInfo) {
		this.lInfo = lInfo;
	}

	public ArrayList<SelectItem> getFreqList() {
		return freqList;
	}

	public void setFreqList(ArrayList<SelectItem> freqList) {
		this.freqList = freqList;
	}

	public String getFrequency() {
		return frequency;
	}

	public void setFrequency(String frequency) {
		this.frequency = frequency;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}

	public Boolean getDisDsa() {
		return disDsa;
	}

	public void setDisDsa(Boolean disDsa) {
		this.disDsa = disDsa;
	}

	public Boolean getShowCenter() {
		return showCenter;
	}

	public void setShowCenter(Boolean showCenter) {
		this.showCenter = showCenter;
	}

	public Date getSearchDate() {
		return searchDate;
	}

	public void setSearchDate(Date searchDate) {
		this.searchDate = searchDate;
	}

	public ArrayList<InstallmentInfo> getMultipleRows() {
		return multipleRows;
	}

	public void setMultipleRows(ArrayList<InstallmentInfo> multipleRows) {
		this.multipleRows = multipleRows;
	}

	public int getTotDueEmi() {
		return totDueEmi;
	}

	public void setTotDueEmi(int totDueEmi) {
		this.totDueEmi = totDueEmi;
	}

	public String getStrSearchDate() {
		return strSearchDate;
	}

	public void setStrSearchDate(String strSearchDate) {
		this.strSearchDate = strSearchDate;
	}

	public Boolean getShowNonStarterBtn() {
		return showNonStarterBtn;
	}

	public void setShowNonStarterBtn(Boolean showNonStarterBtn) {
		this.showNonStarterBtn = showNonStarterBtn;
	}

	public int getNpaDays() {
		return npaDays;
	}

	public void setNpaDays(int npaDays) {
		this.npaDays = npaDays;
	}

	

	public ArrayList<SelectItem> getCenterList() {
		return centerList;
	}

	public void setCenterList(ArrayList<SelectItem> centerList) {
		this.centerList = centerList;
	}

	public String getDueAmtType() {
		return dueAmtType;
	}

	public void setDueAmtType(String dueAmtType) {
		this.dueAmtType = dueAmtType;
	}

	public String[] getCenter() {
		return center;
	}

	public void setCenter(String[] center) {
		this.center = center;
	}

	public String getBranchUserId() {
		return branchUserId;
	}

	public void setBranchUserId(String branchUserId) {
		this.branchUserId = branchUserId;
	}

	public List<SelectItem> getBranchList() {
		return branchList;
	}

	public void setBranchList(List<SelectItem> branchList) {
		this.branchList = branchList;
	}

	public int getBranchId() {
		return branchId;
	}

	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}

	public String getBranchName() {
		return branchName;
	}

	public void setBranchName(String branchName) {
		this.branchName = branchName;
	}

	public String getBucketDayValue() {
		return bucketDayValue;
	}

	public void setBucketDayValue(String bucketDayValue) {
		this.bucketDayValue = bucketDayValue;
	}




	
	
	
}