package json_package;

import java.io.IOException;
import java.util.ArrayList;
import java.util.Date;
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 javax.servlet.http.HttpSession;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

import main_package.DataBaseMethodRaviJ;
import main_package.DataBaseMethodsRavi;
import report_package.DailyInfo;
import report_package.DataBaseReportMethods;

@ManagedBean(name = "dailyDemandPaymentJson")
@ViewScoped
public class DailyDemandPaymentJson {
	private String json;

	public DailyDemandPaymentJson() {
		JSONObject mainobj = new JSONObject();
		JSONArray mainArray = new JSONArray();

		try {
			FacesContext facesContext = FacesContext.getCurrentInstance();

		
			HttpSession ss = (HttpSession) facesContext.getExternalContext().getSession(false);

			int branchId = (int) ss.getAttribute("branchId");

			String dsaCode = "all";

			DataBaseReportMethods dbReport = new DataBaseReportMethods();

			main_package.DataBaseMethods dbm = new main_package.DataBaseMethods();

			String userId = dbm.userId();

			String empDataStatus = dbm.checkSMessageApiDetailFromTable("employee_wise_data", "",
					main_package.DataBaseConnection.JAVAConnection());

			if (dbm.userType().equals("employee") && empDataStatus.equalsIgnoreCase("active")) {
				dsaCode = dbm.dsaCodeByEmpUserId(userId, main_package.DataBaseConnection.JAVAConnection());
			}

		
			boolean checkDl = false;

			Date searchDate = new Date();

			ArrayList<DailyInfo> list = dbReport.dailyDemandMethod(branchId, searchDate, dsaCode, checkDl);
			
	

			for (DailyInfo dd : list) {
				processDetail(dd.getPlDetail(), mainArray);

				processDetail(dd.getGlDetail(), mainArray);

				processDetail(dd.getSlDetail(), mainArray);

				processDetail(dd.getDdDetail(), mainArray);

				processDetail(dd.getRdDetail(), mainArray);
			}

			mainobj.put("status", "success");
			mainobj.put("paymentList", mainArray);

		} catch (Exception e) {
			e.printStackTrace();

			mainobj.put("status", "error");
			mainobj.put("message", e.getMessage());
		}

		json = mainobj.toJSONString();
	}

	private void processDetail(String detail, JSONArray mainArray) {
		try {
			if (detail == null || detail.trim().equals(""))
				return;

			String[] details = detail.split(",");

			for (String item : details) {
				item = item.trim();

				if (item.equals(""))
					continue;

				String[] data = item.split("=");

				if (data.length < 1)
					continue;

				String loanNo = data[0].trim();

				JSONObject paymentData = new DataBaseMethodRaviJ().checkLoanPaymentSource(loanNo);

				String source = String.valueOf(paymentData.get("source"));

				if(source.equalsIgnoreCase("not found"))
				{
				    continue;
				}

				JSONObject obj = new JSONObject();

				obj.put("loanNo", paymentData.get("loanNo"));
				obj.put("amount", paymentData.get("amount"));
				obj.put("userId", paymentData.get("userId"));
				obj.put("source", source);

				mainArray.add(obj);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/*
	 * JSON response
	 */
	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;
	}
}