package json_package;

import java.io.IOException;
import java.util.ArrayList;
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 org.json.simple.JSONArray;
import org.json.simple.JSONObject;

import main_package.DbYashwant;

@ManagedBean(name="fetchLoanDueAmount")
@ViewScoped
public class FetchLoanDueAmount {

	private String json;
	ArrayList<FinanaceCardInfo>list;
	DbYashwant dby = new DbYashwant();
	double dueMonth,totalLoanAmount;
	
	public FetchLoanDueAmount()
	{
		 Map<String, String> params = FacesContext.getCurrentInstance()
	                .getExternalContext().getRequestParameterMap();
	        String employee = params.get("userid");
	        System.out.println(employee+"ff");
	        
	        list=dby.selectTotalLoanAmount(employee);
	        
	        for(FinanaceCardInfo ff:list)
	        {
	        	dueMonth+=ff.getDueAmount();
	        	System.out.println(ff.getDueAmount()+"gg");
	        	totalLoanAmount+=ff.getLoanAmount();
	        }
	        
	        JSONObject mainobj = new JSONObject();
	        JSONArray arr = new JSONArray();
	       

	         {
	            
	            for(FinanaceCardInfo ff:list)
		        {
	            	 JSONObject obj = new JSONObject();
		        	dueMonth+=ff.getDueAmount();
		        	System.out.println(ff.getDueAmount()+"gg");
		        	totalLoanAmount+=ff.getLoanAmount();
		        	
		        	obj.put("loanNo",ff.getLoanNo());
		            obj.put("dueAmount",ff.getDueAmount());
		            obj.put("penaltyAmount",ff.getPenaltyAmount());
		            obj.put("penaltyPaid",ff.getPenaltyPaid());
		            obj.put("TotalLoanAmount", ff.getLoanAmount());
		            obj.put("bounceCharge", ff.getBounceCharge());
		            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;
	}
}
