package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.ExternalContext;
import javax.faces.context.FacesContext;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.DataBaseAutoCompAndDuplicate;
import main_package.InstallmentInfo;
import main_package.LoanInfo;
import main_package.UserInfo;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;



@ManagedBean(name="depositNoDetailJson")
@ViewScoped

public class DepositNoDetailJsonBean implements Serializable
{
	String json;
	
	public DepositNoDetailJsonBean() 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
        
		String loanType = params.get("loanType");
		String loanNo=params.get("loanNoWithName");
		/*String mobile=params.get("mobile");
		String pwd=params.get("pwd");*/
		
		DataBaseMethods dbm=new DataBaseMethods();
        //UserInfo user_info=new UserInfo();
		UserInfo user_info=new UserInfo();
       if(loanNo==null || loanNo.equals(""))
       {
    	   
       }
       else
       {
    	   loanNo=loanNo.substring(0,loanNo.indexOf("/"));
    	   //user_info=new DataBase().userInfoByLoanNoLoanType(loanNo,loanType);
    	   user_info = dbm.userInfoDuringTransaction(loanNo);
    	   
       }
		
       
       ArrayList<InstallmentInfo> dlist=new ArrayList<>();
		 dlist=dbm.showInstallment(user_info.getUser_no(), conn);
		 
		double currentDueEmi=0;int currentDueAmount=0;
		for(int l=0;l<dlist.size();l++)
		{
			Date dt=new Date();
			if(dlist.get(l).getStatus().equals("Paid"))
			{
				dlist.get(l).setColorStatus("paid");
			}
			else
			{
				if(dlist.get(l).getInstlmntDate().before(dt))
				{
					dlist.get(l).setColorStatus("due");
					if(dlist.get(l).getColorStatus().equalsIgnoreCase("due"))
					{
						currentDueEmi+=1;
						currentDueAmount+=dlist.get(l).getInstallment_amount();
					}
				}
				else
				{
					dlist.get(l).setColorStatus("upcoming");
				}
			}
		}
	     
	System.out.println(currentDueAmount+"===="+currentDueEmi);
     List<String> list=new ArrayList<>();
     
     
     JSONObject mainobj = new JSONObject();
			JSONArray arr=new JSONArray();

		    /* if(user_info!=null)
		     {
		    	 JSONObject obj = new JSONObject();
		    	 
		    	 
		    	 obj.put("applicantName", user_info.getFirst_applicantName());
		    	 
		    	 arr.add(obj);
		     }*/
		     
		     if(user_info!=null)
		     {
		    	 JSONObject obj = new JSONObject();
		    	 
		    	 obj.put("shareHolderNo",user_info.getShareHolderNo());
		    	 obj.put("applicantName",user_info.getFirst_applicantName());
		    	 obj.put("loanNo",user_info.getUser_no());
		    	 //obj.put("filecharge", loan_info.getFileCharge());
		    	 obj.put("loanAmount",user_info.getMaturity_value());
		    	// obj.put("loanInterest", user_info.get);
		    	 obj.put("terms",user_info.getTerms());
		    	 obj.put("frequency", dbm.frequencyLabel(String.valueOf(user_info.getFrequency())));
		    	 obj.put("loanEMI", (int)user_info.getInstallment_amount());
		    	 obj.put("requestDate",user_info.getStrOffcDate());
		    	 obj.put("approveDate", user_info.getStrMatDate());
		    	 obj.put("schemeType", loanType);
		    	 obj.put("currentDueEmi",currentDueEmi);
		    	 obj.put("currentDueAmount", currentDueAmount);
		    	 obj.put("address", user_info.getAddress());
		    	 obj.put("contactNo",user_info.getContactNo());
		    	 
		    	 arr.add(obj);
		     }
					
		    	 /*String status="";
		    	 if(i==1)
		    	 {
		    		 status="Registered Successfully";
		    	 }
		    	 else if(i==-1)
		    	 {
		    		 status="Please enter a unique email id.";
		    	 }
		    	 else
		    	 {
		    		status="Something went wrong.";
		    	 }*/
		    	
		    	  
			      

		    mainobj.put("track", arr);

		json=mainobj.toJSONString();
	
		//int i=new DatabaseMethods1().news(concern);
		  
	}
	
	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;
	}
	
}
