package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Map;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.ExternalContext;
import javax.faces.context.FacesContext;
import javax.faces.model.SelectItem;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.EmpInfo;
import main_package.InstallmentInfo;
import main_package.LoanInfo;
import main_package.UserInfo;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ManagedBean(name="bulkDueEmiReportJson")
@ViewScoped
public class BulkDueEmiReportJsonBean implements Serializable
{
	String json;
	DataBaseMethods obj=new DataBaseMethods();
	ArrayList<String> list, dueDateList, dateList;
	ArrayList<InstallmentInfo> dueList,pdueList;
	ArrayList<LoanInfo> pendingLoanList, dueLoanList;
	String dateValues,schemeType,labelForDepositNo, frequency, dsaCode;
	InstallmentInfo selected;
	Boolean tblrndr, showBtn,disDsa, showCenter;
	UserInfo uInfo=null;
	LoanInfo lInfo=null;
	int count, a, npaEmi;
	double grandTotalOfEmiAmount,grandTotalOfDueAmount;
	DataBaseMethods db=new DataBaseMethods();
	ArrayList<SelectItem> freqList, dsaList;
	
	public BulkDueEmiReportJsonBean() throws ParseException 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
		schemeType =params.get("schemeType");
		dsaCode=params.get("dsaCode");
		frequency =params.get("frequency");
		String branchStr = params.get("branchId");
		int branchId = Integer.valueOf(branchStr);
		
		JSONObject mainobj = new JSONObject();
		JSONArray arr=new JSONArray();
		
		pdueList=search(branchId);
		if(pdueList.size()>0)
	     {
	    	 for(InstallmentInfo uu : pdueList)
			   {
				   JSONObject obj = new JSONObject();
				   
				 
				   obj.put("sno",uu.getSno());
				   obj.put("loanRdNo", uu.getUser_no());
				   obj.put("shareHolderNo",uu.getShareHolderNo());
				   obj.put("name", uu.getName());
				   obj.put("contactNo",uu.getContactNo());
				   obj.put("centerName", uu.getStatus());
				   obj.put("emiAmount",uu.getEmiAmount());
				   obj.put("noOfEmiDue", uu.getCount());
				   obj.put("dueAmount",uu.getPaidAmount());
				   
				   arr.add(obj);
			   }
	     }

	    mainobj.put("track", arr);

	json=mainobj.toJSONString();
	
		//int i=new DatabaseMethods1().news(concern);
		  
	}
	
	
	public ArrayList<InstallmentInfo> search(int branchId)
	{
		grandTotalOfDueAmount=0;
		grandTotalOfEmiAmount=0;
		Connection conn=DataBaseConnection.JAVAConnection();
		tblrndr=true;
		   list=new ArrayList<>();
		   dueList= new ArrayList<>();
		   pdueList= new ArrayList<>();
		   dueDateList= new ArrayList<>();
		   if(schemeType.equalsIgnoreCase("dd") || schemeType.equalsIgnoreCase("rd"))
		   {
			   labelForDepositNo="Deposit";
		   list= db.listDueRd(schemeType, dsaCode,branchId,conn);
		   int sn=1;
		   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++)
					 {
					    Date dt=new Date();
						if(!dueList.get(l).getStatus().equals("Paid"))
						  {
							 if(dt.after(dueList.get(l).getInstlmntDate()) && !new SimpleDateFormat("dd/MM/yyyy").format(dt).equals(dueList.get(l).getIns_date()))
								{
								  
								  dueDateList.add(count+1+" - "+ new SimpleDateFormat("dd/MM/yyyy").format(dueList.get(l).getInstlmntDate())+"?"+dueList.get(l).getUser_no());
								  count++;
								  dueAmt+=dueList.get(l).getDueAmount();
								}
						  }
						 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()));
	                        cate.setUser_no(dueList.get(l).getUser_no());
	                        cate.setName(dueList.get(l).getName());
	                        cate.setPaidAmount(dueAmt);
	                        cate.setEmiAmount(dueList.get(l).getInstallment_amount());
	                        cate.setContactNo(db.applicantContactNoByShareHolderNo(cate.getShareHolderNo(), conn));
							pdueList.add(cate);        
							 
						   }
					  }
				}
		   }
		   else
		   {
			   String center[] = null;
			   list= db.loanEmiDueList(branchId,schemeType, frequency, dsaCode,center, conn);
			   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;
				    double dueAmt=0;
				   dueLoanList= db.loanInstallment(schemeType, list.get(i), conn);
				   for(int l=0;l<dueLoanList.size();l++)
					 {
					    Date dt=new Date();
						if(!dueLoanList.get(l).getStatus().equals("Paid"))
						  {
							 if(dt.after(dueLoanList.get(l).getInstallDate()) && !new SimpleDateFormat("dd/MM/yyyy").format(dt).equals(dueLoanList.get(l).getStrInstlmntDate()))
								{
								  dueDateList.add(count+1+" - "+ new SimpleDateFormat("dd/MM/yyyy").format(dueLoanList.get(l).getInstallDate())+"?"+list.get(i));
								  count++;
								  dueAmt+=dueLoanList.get(l).getDueAmount();
								}
						  }
						 if(l==dueLoanList.size()-1 && count!=0)
						   {
							InstallmentInfo cate= new InstallmentInfo();
							cate.setCount(count);
	                        cate.setSno(sn++);
	                        cate.setShareHolderNo(db.shareHolderNoByLoanNo(list.get(i)));
	                        cate.setUser_no(list.get(i));
	                        cate.setName(db.shareHolderNameByShareHolderNo(cate.getShareHolderNo(), conn));
	                        lInfo=db.loanInfoByLoanNoLoanType(list.get(i), schemeType, conn);
	                        cate.setPaidAmount(dueAmt);
	                        cate.setEmiAmount(lInfo.getInstallAmount());
	                        cate.setContactNo(db.applicantContactNoByShareHolderNo(cate.getShareHolderNo(), conn));
	                        
	                        if(schemeType.equalsIgnoreCase("grouploan"))
	                        {
	                        	 cate.setStatus(lInfo.getCenterName());
	                        	 showCenter=true;
	                        }
	                        else
	                        {
	                        	showCenter=false;
	                        }
	                       
	                        
							pdueList.add(cate);        
							 
						   }
					  }
				
				   
				   }
			   }
			   
		   }
		   for(InstallmentInfo ll : pdueList)
		   {
			   grandTotalOfDueAmount +=ll.getPaidAmount();
			   grandTotalOfEmiAmount +=ll.getEmiAmount();
		   }
		   try 
		   {
			   conn.close();
		   } 
		   catch (SQLException e) 
		   {
			// TODO Auto-generated catch block
			e.printStackTrace();
		   }
		return pdueList;
	}
	
	
	public void renderJson() throws IOException {
 	    FacesContext facesContext = FacesContext.getCurrentInstance();
 	    ExternalContext externalContext = facesContext.getExternalContext();
 	    externalContext.setResponseContentType("application/json");
 	    externalContext.setResponseCharacterEncoding("UTF-8");
 	    externalContext.getResponseOutputWriter().write(json);
 	    facesContext.responseComplete();
 	    
 	    
 	}

	public String getJson() {
		return json;
	}

	public void setJson(String json) {
		this.json = json;
	}
}
