package jsonPackage;

import java.io.IOException;
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 org.primefaces.json.JSONArray;
import org.primefaces.json.JSONObject;

import main_package.DataBaseConnection;

import main_package.DataBaseMethods;

import main_package.LoanInfo;

@ManagedBean(name = "loansByShareholderNo")
@ViewScoped
public class LoansByShareholderNoJsonBean {

	private String json;

	public LoansByShareholderNoJsonBean() {

		JSONObject mainobj = new JSONObject();

		try {
			Map<String, String> param = FacesContext.getCurrentInstance().getExternalContext().getRequestParameterMap();

			String shareholderNo = param.get("shareholderNo");

			if (shareholderNo == null || shareholderNo.trim().isEmpty()) {
				mainobj.put("success", false);
				mainobj.put("message", "shareholderNo is required");

				json = mainobj.toString();
				return;
			}

			shareholderNo = shareholderNo.trim();

			DataBaseMethods db = new DataBaseMethods();

			try (Connection conn = DataBaseConnection.JAVAConnection()) {

				if (conn == null) {
					throw new Exception("Database connection failed");
				}

				ArrayList<LoanInfo> loanList = db.fetchallLoanNobyshareholderNo(conn, shareholderNo);

				if (loanList == null) {
					loanList = new ArrayList<LoanInfo>();
				}

				System.out.println("LoanList = " + loanList );
				
				JSONArray loansArray = new JSONArray();

				for (LoanInfo loan : loanList) {

					JSONObject loanObj = new JSONObject();

					loanObj.put("loanNo", loan.getLoanNo() == null ? "" : loan.getLoanNo());

					loanObj.put("status", loan.getStatus() == null ? "" : loan.getStatus());

					loanObj.put("paidStatus", loan.getPaidStatus() == null ? "" : loan.getPaidStatus());

					loansArray.put(loanObj);
				}

				mainobj.put("success", true);
				mainobj.put("shareholderNo", shareholderNo);
				mainobj.put("totalLoans", loansArray.length());
				mainobj.put("loans", loansArray);

				json = mainobj.toString();
			}

		} catch (Exception e) {
			e.printStackTrace();

			mainobj.put("success", false);
			mainobj.put("message", "Unable to fetch shareholder loans");

			json = mainobj.toString();
		}
	}

	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 == null ? "{}" : json);

		externalContext.getResponseOutputWriter().flush();

		facesContext.responseComplete();
	}

	public String getJson() {
		return json;
	}

	public void setJson(String json) {
		this.json = json;
	}
}