
package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collections;
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 org.json.simple.JSONArray;
import org.json.simple.JSONObject;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.UserInfo;
import report_package.DataBaseReportMethods;

@ManagedBean(name = "dueEmiReportJson")
@ViewScoped
public class AllDueEmiReportJsonBean implements Serializable {

	String json;
	DataBaseReportMethods db = new DataBaseReportMethods();


public AllDueEmiReportJsonBean() {
    try {
        Map<String, String> params = FacesContext.getCurrentInstance()
                .getExternalContext().getRequestParameterMap();

        String branchStr = params.get("branchId");
        String category = params.get("category");
        String empCode = params.get("empCode");
        String frequency = "all";

        // Required validation
        if (branchStr == null || branchStr.trim().isEmpty()
                || category == null || category.trim().isEmpty()
                || empCode == null || empCode.trim().isEmpty()) {

            json = "{\"status\":\"error\",\"message\":\"branchId, category and empCode are required\"}";
            return;
        }

        // Branch validation: all = -1
        int branchId;

        if ("all".equalsIgnoreCase(branchStr.trim())) {
            branchId = -1;
        } else {
            try {
                branchId = Integer.parseInt(branchStr.trim());

              
                if (branchId == 0 || branchId < -1) {
                    json = "{\"status\":\"error\",\"message\":\"Invalid branchId\"}";
                    return;
                }
            } catch (NumberFormatException e) {
                json = "{\"status\":\"error\",\"message\":\"branchId must be numeric or all\"}";
                return;
            }
        }

        // Category validation
        if (!category.equalsIgnoreCase("Loan")
                && !category.equalsIgnoreCase("RD")) {

            json = "{\"status\":\"error\",\"message\":\"category must be Loan or RD\"}";
            return;
        }

        if ("RD".equalsIgnoreCase(category)) {
            category = "rd/fd";
        }

        // Employee filter: all means no employee filter
        if ("all".equalsIgnoreCase(empCode.trim())) {
            empCode = "all";
        }

        Connection conn = DataBaseConnection.JAVAConnection();

        try {
        	
        	System.out.println("branchId = " + branchId);
        	System.out.println("category = " + category);
        	System.out.println("empCode = " + empCode);
        	
            ArrayList<UserInfo> templist = db.allDueEMI(branchId, category, frequency, empCode, conn);
            ArrayList<UserInfo> list = new ArrayList<>();
                    
            for(int i=0;i<templist.size();i++)
			{
				if(!templist.get(i).getEntryDateStr().equalsIgnoreCase(new SimpleDateFormat("dd/MM/yyyy").format(new Date())))
				{
					list.add(templist.get(i));
				}
			}
            
            Collections.sort(list);

            System.out.println("Due EMI list size = " + list.size());
            
            JSONArray arr = new JSONArray();

            int sno = 1;

            for (UserInfo item : list) {
                JSONObject row = new JSONObject();

                row.put("sno", sno++);
                row.put("shareHolderNo", item.getShareHolderNo());
                row.put("first_applicantName", item.getFirst_applicantName());
                row.put("contactNo", item.getContactNo());
                row.put("type", item.getChq_ddNo());
                row.put("loanNo", item.getLoanNo());
                row.put("dsaName", item.getDsaName());
                row.put("centerName", item.getCenterName());
                row.put("entryDateStr", item.getEntryDateStr());
                row.put("amount", item.getAmount());

                arr.add(row);
            }

            JSONObject response = new JSONObject();
            response.put("status", "success");
            response.put("count", arr.size());
            response.put("dueEmiReport", arr);

            json = response.toJSONString();

        } finally {
            conn.close();
        }

    } catch (Exception e) {
        e.printStackTrace();

        JSONObject response = new JSONObject();
        response.put("status", "error");
        response.put("message", "Unable to fetch due EMI report");

        json = response.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;
	}
}
