package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
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 org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ManagedBean(name="loginJson")
@ViewScoped

public class LoginJsonBean implements Serializable
{
	String json;
	
	public LoginJsonBean() 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
        
		String userid = params.get("userid");
		String pwd=params.get("pwd");
		System.out.println(userid);
		System.out.println(pwd);
		
		 if(userid.contains("'") || pwd.contains("'"))
			{
				userid="";
				pwd="";
			}
		     
		DataBaseMethods dbm=new DataBaseMethods();
		double preAmount=0;
        
        
     Connection conn=DataBaseConnection.JAVAConnection();   
     String type;
     
     // app ke liye sabhi ke liye ye common user id pass fix set hai isse kabhi remove nhi krna hai .
     if(userid.equalsIgnoreCase("171717") && pwd.equalsIgnoreCase("171717"))
     {
    	 type ="user";
     }
     else {
         type=  new DatabaseMethods1().loginUser(userid,pwd);
 
     }
     
     System.out.println(type);
     // Work for Admin App is active or not
     String appStatus="";
     
     
   String  gpsTrackingStatus=dbm.checkSMessageApiDetailFromTable("gps_tracking","", conn);
   String  employeeWiseDataStatus=dbm.checkSMessageApiDetailFromTable("employee_wise_data","", conn);
		//int i=new DatabaseMethods1().news(concern);
		  JSONObject mainobj = new JSONObject();
				JSONArray arr=new JSONArray();
			   
 			    	 JSONObject obj = new JSONObject();
				
 			    	 
 			    	 String status="";
 			    	if(!type.equals("") && (type.equalsIgnoreCase("admin") || type.equalsIgnoreCase("masterAdmin")))
 			    	 {
 			    		 appStatus=dbm.checkSMessageApiDetailFromTable("admin_app","", conn);
 			    		 if(appStatus.equalsIgnoreCase("") || appStatus.equalsIgnoreCase("inactive"))
 	 			    	 {
 	 			    		status="Dear User, You Don't have Permission to Access Admin App. Please Contact to Administrator for Purchase Admin App.";
 	 			    		type="";
 	 			    	 }
 			    		 else
 			    		 {
 			    			 status=type;
 			    		 }
 			    	 }
 			    	 
 			    	 else if(!type.equals("") && type.equalsIgnoreCase("employee"))
 			    	 {
 			    		 appStatus=dbm.checkSMessageApiDetailFromTable("employee_app","", conn);
 			    		 if(appStatus.equalsIgnoreCase("") || appStatus.equalsIgnoreCase("inactive"))
 	 			    	 {
 	 			    		status="Dear User, You Don't have Permission to Access Employee App. Please Contact to Administrator.";
 	 			    		type="";
 	 			    	 }
 			    		 else
 			    		 {
 			    			 status=type;
 			    		 }
 			    	 }
 			    	 
 			    	 else if(!type.equals("") && type.equalsIgnoreCase("user"))
 			    	 {
 			    		 appStatus=dbm.checkSMessageApiDetailFromTable("user_app","", conn);
 			    		 if(appStatus.equalsIgnoreCase("") || appStatus.equalsIgnoreCase("inactive"))
 	 			    	 {
 	 			    		status="Dear User, You Don't have Permission to Access Member/Client App. Please Contact to Administrator.";
 	 			    		type="";
 	 			    	 }
 			    		 else
 			    		 {
 			    			 status=type;
 			    			 
 			    			 String accno=dbm.savingAccountByShareHolderNo(userid);
 	 			    	     preAmount=dbm.acconuntHolderAmountByAccountNo(accno);
 			    		 }
 			    	 }
 			    	 
 			    	 else  if(!type.equals(""))
	    			 {
 			    		status=type;
	    			 }
 			    	 else
 			    	 {
 			    		// System.out.println("finall eslese ");
 			    		 type=dbm.userTypeByUserId(userid, conn);
 			    		 //System.out.println("type : "+type);
 			    		 if(type.equalsIgnoreCase("user"))
 			    		 {
 			    			status="Your Account Does Not Exist.";
 			    		 }
 			    		 else
 			    		 {
 			    			status="Please enter valid user id or password.";
 			    		 }
 			    	 }
 			    	
			    	 obj.put("st",status);
			    	 obj.put("savingBalance",preAmount);
			    	 obj.put("gpsTrackingStatus",gpsTrackingStatus);
			    	 obj.put("employeeWiseDataStatus",employeeWiseDataStatus);
			    	 obj.put("memberBranchId",dbm.branchIdFromByUserIdFromLoginTable(userid, conn));
			    	 obj.put("showDeposit", dbm.checkDepositModuleStatus(conn));
			    	 
				      arr.add(obj);
				    	
	            
			    mainobj.put("track", arr);
                
			json=mainobj.toJSONString();
		
			
			
			  String typeApp=  new DatabaseMethods1().loginUser(userid,pwd);
	    		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(true);
	    		ss.setAttribute("usernameApp", userid);
				ss.setAttribute("type",typeApp);
				// code Must
				
				//System.out.println(userid+"==="+typeApp);
	}
	
	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;
	}
	
	

}
