package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Map;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.RequestScoped;
import javax.faces.context.ExternalContext;
import javax.faces.context.FacesContext;

import org.json.simple.JSONObject;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsRaviK;

@ManagedBean(name = "activeMemberJson")
@RequestScoped

public class activeLoanMemberJson implements Serializable {
	private static final long serialVersionUID = 1L;
	 String json;
	 DataBaseMethods dbm= new DataBaseMethods();

	public activeLoanMemberJson() {

		Map<String, String> params = FacesContext.getCurrentInstance().getExternalContext().getRequestParameterMap();

		String branchId = params.get("branchId");
		String userId= params.get("userId");
		System.out.println("user id is "+userId);

		JSONObject obj = new JSONObject();
		Connection conn = null;

		try {	
					conn = DataBaseConnection.JAVAConnection();
					String dsacode = dbm.dsaCodeByEmpUserId(userId, conn);

					DataBaseMethodsRaviK dbrk= new DataBaseMethodsRaviK();
					Map<String, Integer> loanCounts = dbrk.activeLoanMemberList(Integer.parseInt(branchId), conn,dsacode);

					int personalLoan = loanCounts.getOrDefault("personalloan", 0);
					int secureLoan = loanCounts.getOrDefault("secure_loan", 0);
					int groupLoan = loanCounts.getOrDefault("grouploan", 0);
                    
					obj.put("branchId", Integer.parseInt(branchId));
					obj.put("status", "success");
					obj.put("personalloan", personalLoan);
					obj.put("secure_loan", secureLoan);
					obj.put("grouploan", groupLoan);
					obj.put("totalActiveLoanMembers", personalLoan + secureLoan + groupLoan);
				
			

		} catch (NumberFormatException e) {

			obj.put("status", "error");
			obj.put("message", "branchId must be a valid integer");

		} catch (Exception e) {

			obj.put("status", "error");
			obj.put("message", "Unable to fetch active loan counts");

		} finally {
			if (conn != null) {
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}

		json = obj.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;
	}

}
