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 javax.xml.stream.events.StartDocument;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.HeaderBean;
import main_package.LoanInfo;
import main_package.UserInfo;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

import report_package.DataBaseReportMethods;

@ManagedBean(name="empEmiPayJson")
@ViewScoped

public class EmpEmiPayJsonBean implements Serializable
{
	
	String json;
	Date searchDate=new Date();

	
    public EmpEmiPayJsonBean() throws ParseException 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
		ArrayList<UserInfo>list = new ArrayList<>();
        Connection conn=DataBaseConnection.JAVAConnection();
        DataBaseMethods db=new DataBaseMethods();
        
		String dateStr = params.get("date");
		String userid=params.get("userid");
		String searchType=params.get("searchType");
		String entryStatus=params.get("entryStatus");
		String branchStr = params.get("branchId");
		int branchId = Integer.valueOf(branchStr);
		
		 if(userid.contains("'") || dateStr.contains("'") || searchType.contains("'") || entryStatus.contains("'"))
			{
				userid="";
				dateStr="";
				searchType="";
				entryStatus="";
			}

		 
		DateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
		searchDate = (Date)formatter.parse(dateStr);
		
		list= new DataBaseReportMethods().empEmiPayListByApp(branchId,searchDate, userid, conn, searchType, entryStatus);
		
		// Condition for manage Sikarwar nidhi : only show today data
				if((db.companyName().equalsIgnoreCase("ROYAL MICROFINANCE") || db.companyName().equalsIgnoreCase("SHRI G FINANCE SERVICES")) && db.userTypeByUserId(userid, conn).equalsIgnoreCase("employee"))
				{
					String toDate=new SimpleDateFormat("dd/MM/yyyy").format(new Date());
					if(!toDate.equals(dateStr))
					{
						list=new ArrayList<>();
					}
				}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
     
     
     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("empName",uu.getName());
					   obj.put("loanType",uu.getType());
					   obj.put("loanNo",uu.getLoanNo());
					   obj.put("applicantName",uu.getFirst_applicantName());
					   obj.put("address",uu.getAddress());
					   obj.put("strOfficeDate",uu.getStrOffcDate());
					   obj.put("amount",uu.getAmount());
					   obj.put("status",uu.getStatus());
					   
					   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;
	}

}
