package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
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 main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.LoanInfo;
import report_package.DataBaseReportMethods;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ManagedBean(name="loanPenaltyJson")
@ViewScoped
public class LoanPenaltyJsonBean implements Serializable
{
    String json;
	
	public LoanPenaltyJsonBean() 
	{
		
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
             
		String userid = params.get("userid");
		String loanNo = params.get("loanNo");

		if(userid.contains("'") || loanNo.contains("'"))
		{
			userid="";
			loanNo="";
		}
		
		DataBaseMethods dbm=new DataBaseMethods();
		Connection conn=DataBaseConnection.JAVAConnection();
	    
     ArrayList<LoanInfo> list=new ArrayList<>();
     list=new DataBaseReportMethods().paidPenaltyListByLoanNo(loanNo);
     
     // condition for sikarwar 17 May 2024
     if((dbm.companyName().equalsIgnoreCase("ROYAL MICROFINANCE")) && (!dbm.userTypeByUserId(userid, conn).equalsIgnoreCase("admin")))
     {
    	 list=new ArrayList<>();
     }
     
     JSONObject mainobj = new JSONObject();
			JSONArray arr=new JSONArray();
   
		     if(list.size()>0)
		     {
		    	 for(LoanInfo uu : list)
				   {
					   JSONObject obj = new JSONObject();
					   
					   obj.put("sno",uu.getSno());
					   obj.put("paidDate",uu.getStrRequestDate());
					   obj.put("paidAmount",uu.getLoanAmount());
					   
					   arr.add(obj);
				   }
		     }		    	  
		    mainobj.put("track", arr);

		json=mainobj.toJSONString();
	
		//int i=new DatabaseMethods1().news(concern);
		  
	}
	
	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;
	}
}
