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.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.InstallmentInfo;
import main_package.LoanInfo;
import main_package.UserInfo;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

import other_package.DataBaseMethodsOther;

@ManagedBean(name="rdDetailJson")
@ViewScoped

public class RdFdDetailJsonBean implements Serializable
{
String json;
	
	public RdFdDetailJsonBean() 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
        
		String shareId = params.get("userid");
	//	String email=params.get("email");
		/*String mobile=params.get("mobile");
		String pwd=params.get("pwd");*/
		
		  if(shareId.contains("'"))
		   {
			   shareId="";
		   }
		  
        
		Connection conn=DataBaseConnection.JAVAConnection();
        
     ArrayList<UserInfo> list=new ArrayList<>();
     list =  list=new DataBaseMethodsOther().allRd_FDList(shareId);
     JSONObject mainobj = new JSONObject();
			JSONArray arr=new JSONArray();

		     if(list.size()>0)
		     {
		    	 for(UserInfo uu : list)
				   {
		    		 double currentDueEmi=0;int currentDueAmount=0;
		    		 ArrayList<InstallmentInfo> dlist=new ArrayList<>();
		    		  if(uu.getScheme_type().equalsIgnoreCase("DD") || uu.getScheme_type().equalsIgnoreCase("RD"))
		    		  {
		    			  dlist=new DataBaseMethods().showInstallment(uu.getUser_no(), conn);
			    			 
			    			
			    			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");
			    					}
			    				}
			    			}
		    		  }
		    			
		    		  
					   JSONObject obj = new JSONObject();
					   
					   obj.put("sno",uu.getSno());
					   obj.put("applicationNo",uu.getOffice_application_no());
					   obj.put("rdNo",uu.getUser_no());
					   obj.put("schemeType",uu.getScheme_type());
					   obj.put("amount",uu.getInstallment_amount());
					   obj.put("matureDate",uu.getStrMatDate());
					   obj.put("matureValue",uu.getMaturity_value());
					   obj.put("currentDueEmi",currentDueEmi);
				    	obj.put("currentDueAmount", currentDueAmount);
				    	
					   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;
	}
}
