package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
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 javax.servlet.http.HttpSession;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.DbYashwant;
import main_package.UserInfo;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ManagedBean(name="dashBoardJson")
@ViewScoped

public class DashBoardJsonBean implements Serializable
{
	String json;
	
	public DashBoardJsonBean() 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
        
		String userid = params.get("userid");
		String branch = params.get("branchId");
		
		if(userid.contains("'"))
		{
			userid="";
		}
		
		int branchId = 1;
		if(branch!=null && !branch.equalsIgnoreCase(""))
		{
			branchId=Integer.parseInt(branch);
		}
		
		DataBaseMethods dbm=new DataBaseMethods();
		DbYashwant dbY=new DbYashwant();
		
		UserInfo uu=new UserInfo();
		uu=dbm.firmDetails(branchId);
	      
		  JSONObject mainobj = new JSONObject();
				JSONArray arr=new JSONArray();
			         
 			    	 JSONObject obj = new JSONObject();
 			    	 
			    	 obj.put("st",dbm.checkLoginIdStatus(userid));
			    	 obj.put("name", uu.getFirm_name());
			    	 obj.put("address1", uu.getAddress1());
			    	 obj.put("address2", uu.getAddress2());
			    	 obj.put("address3", uu.getAddress3());
			    	 obj.put("address4", uu.getAddress4());
			    	 obj.put("mobileNo", uu.getMobile());
			    	 obj.put("logo", uu.getLogo());
			    	 
			    	 int apiBal=dbm.checkApiBalance("Aadhaar Verification API (OTP)");
			    	 obj.put("apiBal", apiBal);
			    	 
			    	 int bankApiBal=dbm.checkApiBalance("Bank Account Verification API");
			    	 obj.put("bankApiBal", bankApiBal);
			    	 
			    	 String apiKey=dbm.checkApiKey();
			    	 obj.put("apiKey", apiKey);
			    	 boolean showCibilBtn=dbY.checkEmployeeCibilStatus(userid);
			    	 obj.put("showCibilBtn",showCibilBtn);
			    	 
				      arr.add(obj);
				    	
	
			    mainobj.put("track", arr);

			json=mainobj.toJSONString();
	}
	
	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;
	}
	
}
