package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Date;
import java.util.List;
import java.util.Map;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
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.UserInfo;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

import other_package.DataBaseMethodsOther;

@ManagedBean(name="savingNoDetailJson")
public class SavingNoDetailJsonBean implements Serializable
{
	String json;
	DataBaseMethods obj=new DataBaseMethods();
	UserInfo selectedUser;
	
	public SavingNoDetailJsonBean() 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
		String accno=params.get("loanNoWithName");
		 if(accno.contains("'"))
			{
		 accno="";
			}
		UserInfo user_info=new UserInfo();
       if(accno==null || accno.equals(""))
       {
    	   
       }
       else
       {
	   		if(accno.contains("/"))
	   		{
	   			accno=accno.substring(0,accno.indexOf("/"));
	   		}
	   		String shareHolderNo = obj.shareHolderNoBySavingAccountNO(accno);
	   		
	   		if (shareHolderNo!= "")
	   		{
	   			selectedUser=new DataBaseMethodsOther().particularSavingAccountBean(shareHolderNo);
	   		}	
	   		else
	   		{
	   			FacesContext fc=FacesContext.getCurrentInstance();
	   			fc.addMessage(null, new FacesMessage("Account No. Does Not Exists"));
	   		}
	   		
	   		
    	   
       }
		
       
     List<String> list=new ArrayList<>();
     
     
     JSONObject mainobj = new JSONObject();
			JSONArray arr=new JSONArray();

		    
		     if(user_info!=null)
		     {
		    	 JSONObject obj = new JSONObject();
		    	 
		    	 obj.put("shareHolderNo",selectedUser.getShareHolderNo());
		    	 obj.put("applicantName",selectedUser.getFirst_applicantName());
		    	 obj.put("loanNo",selectedUser.getAccountNo());
		    	 obj.put("depositType","saving");
		    	 obj.put("amount",selectedUser.getAmount());
		    	 obj.put("approveDate", selectedUser.getEntryDateStr());
		    	 obj.put("contactNo",selectedUser.getContactNo());
		    	 
		    	 arr.add(obj);
		     }

		    mainobj.put("track", arr);

		json=mainobj.toJSONString();
	
		try {
   			conn.close();
   		} catch (SQLException e) {
   			// TODO Auto-generated catch block
   			e.printStackTrace();
   		}
		  
	}
	
	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;
	}
}
