package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
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 org.json.simple.JSONArray;
import org.json.simple.JSONObject;



@ManagedBean(name="empEmiLedgerListJson")
@ViewScoped

public class EmpEmiLedgerListJsonBean implements Serializable
{
	
	private static final long serialVersionUID = 1L;

	String json;
	
	DataBaseMethods db = new DataBaseMethods();
	
	public EmpEmiLedgerListJsonBean() 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
        
		String loanType = params.get("loanType");
		String loanNo=params.get("loanNo");
		/*String mobile=params.get("mobile");
		String pwd=params.get("pwd");*/
		
		 if(loanType.contains("'") || loanNo.contains("'"))
			 
			{
			 
		 loanType="";
		 loanNo="";
			
			}
		 
		ArrayList<LoanInfo> list=new ArrayList<>();
		
		Connection conn=DataBaseConnection.JAVAConnection();
		if(loanNo==null || loanNo.equals(""))
		{
    	   
		}
		else
		{
			list=new DataBaseMethods().loanInstallment(loanType,loanNo, conn);
			/*user_info=new DataBase().userInfoByLoanNoLoanType(loanNo,loanType);
			loan_info=new DataBase().loanInfoByLoanNoLoanType(loanNo,loanType);
    	   */
		}
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		boolean chkPaid=true; 
		
		
		
		if(db.companyName().equalsIgnoreCase("ROYAL MICROFINANCE") )
		{
			chkPaid=false;
		}
     
     
     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("emiAmount",uu.getInstallAmount());
					   obj.put("interest",uu.getInterestAmount());
					   obj.put("principal",uu.getPrincipalAmount());
					  
					   if(chkPaid==true)
					   {
						   obj.put("paidAmount",uu.getPaidAmount());
					   }
					   else
					   {
						   obj.put("paidAmount",0);
					}
					   obj.put("paidAmount",uu.getPaidAmount());
					   obj.put("dueAmount",uu.getDueAmount());
					   obj.put("status",uu.getStatus());
					   obj.put("emiDate",uu.getStrInstlmntDate());
					   
					   arr.add(obj);
				   }
					
		     }
		     
					
		    	 /*String status="";
		    	 if(i==1)
		    	 {
		    		 status="Registered Successfully";
		    	 }
		    	 else if(i==-1)
		    	 {
		    		 status="Please enter a unique email id.";
		    	 }
		    	 else
		    	 {
		    		status="Something went wrong.";
		    	 }*/
		    	
		    	  
			      

		    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;
	}
	
}
