package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
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.LoanInfo;
import main_package.UserInfo;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ViewScoped
@ManagedBean(name="centerWiseAppMemberListJson")

public class CenterWiseAppMemberListJsonBean implements Serializable
{
	String json;
	Date startDate, endDate;
	
	public CenterWiseAppMemberListJsonBean() throws ParseException 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
        
	
		String userId=params.get("userId");
		String centerId=params.get("centerId");
		String branchStr = params.get("branchId");
		int branchId = Integer.valueOf(branchStr);
		
		if(userId.contains("'") || centerId.contains("'"))
		{
			centerId="";
		}
		
		ArrayList<UserInfo> list=new ArrayList<>();
		
		
		list=new DataBaseMethods().memberRegListByAppCenterWise(userId, centerId,branchId);
     
     
		JSONObject mainobj = new JSONObject();
		JSONArray arr=new JSONArray();
			
		if(list.size()>0)
	     {
	    	 for(UserInfo uu : list)
			   {
				   JSONObject obj = new JSONObject();
				   
				   obj.put("sno",uu.getSno());
				   obj.put("id",uu.getId());
				   obj.put("strRegDate",uu.getStrOffcDate());
				   obj.put("name",uu.getName());
				   obj.put("relationName",uu.getFather_husband_name());
				   obj.put("relation",uu.getRelation());
				   obj.put("strDob",uu.getStrdob());
				   obj.put("mobile",uu.getMobile());
				   obj.put("address",uu.getAddress());
				   obj.put("voterId",uu.getVoterId());
				   obj.put("uniqueId",uu.getUniqueId());
				   obj.put("userId",uu.getUserId());
				   
				   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;
	}
	
}
