package json_package;

import java.io.IOException;
import java.sql.Connection;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
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 org.json.simple.JSONArray;
import org.json.simple.JSONObject;

import main_package.DataBaseConnection;
import main_package.DataBaseMethodTaheer;
import main_package.DataBaseMethodsRavi;
import report_package.DailyInfo;
import report_package.DataBaseReportMethods;

@ManagedBean(name = "MyNidhiDailyDemandPaymentReportJson")
@ViewScoped
public class MyNidhiDailyDemandPaymentReportJson 
{
	private String json;
    DataBaseMethodsRavi dbr = new DataBaseMethodsRavi();
    DataBaseMethodTaheer dbmt= new DataBaseMethodTaheer();
    
    

	main_package.DataBaseMethods dbm = new main_package.DataBaseMethods();
	public MyNidhiDailyDemandPaymentReportJson() {
		JSONObject mainobj = new JSONObject();
		JSONArray mainArray = new JSONArray();

		try 
		{
			Map<String, String> params = FacesContext.getCurrentInstance().getExternalContext()
					.getRequestParameterMap();
	       
			String branchIdStr = params.get("branchId");
			String sDate = params.get("searchDate");
			String checkDlStr = params.get("checkDl");
			String uName = params.get("uName");
		    System.out.println("uuuuuuuuuuu"+uName);
			String dsaCode = "all";
			
			
			
			if (uName != null && !uName.trim().isEmpty()) {
				
				String username = uName.trim();
				if (uName.equalsIgnoreCase("admin") || uName.equalsIgnoreCase("masteradmin")) {
					dsaCode = "all";
				} 
				else {
					try (Connection conn = DataBaseConnection.JAVAConnection()) {
						String empDsaCode = dbm.dsaCodeByEmpUserId(username, conn);
						if (empDsaCode == null || empDsaCode.trim().isEmpty()) {
							mainobj.put("status", "error");
							mainobj.put("message", "Invalid employee username");
							json = mainobj.toJSONString();
							return;
						}
						dsaCode = empDsaCode.trim();
					}
				}
			}
			System.out.println("dsaAudit"+dsaCode);
			
			if (sDate == null || sDate.trim().equals("")) {
				mainobj.put("status", "error");
				mainobj.put("message", "please select search date");
				json = mainobj.toJSONString();
				return;
			}
			
			if (branchIdStr == null || branchIdStr.trim().equals("")) {
				mainobj.put("status", "error");
				mainobj.put("message", "BramchId is required");
				json = mainobj.toJSONString();
				return;
			}
			
			int branchId = Integer.parseInt(branchIdStr);
			
			if (branchId <= 0) {
				 mainobj.put("status", "error");
			        mainobj.put("message", "Invalid branch ID");
			        json = mainobj.toJSONString();
			        return;
			}
			
			
			boolean checkDl = false;
			if (checkDlStr != null && checkDlStr.equalsIgnoreCase("true")) {
			    checkDl = true;
			}
			

			DateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
			Date searchDate = formatter.parse(sDate);
//			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());
//			}

		    
		
			try(Connection conn = DataBaseConnection.JAVAConnection())
			{
			    ArrayList<DailyInfo> list =
			        dbReport.dailyDemandMethod(branchId, searchDate, dsaCode, checkDl);

			    for (DailyInfo dd : list) 
			    {
			        processDailyInfo(dd, mainArray, searchDate, conn);
			    }
			}

			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 processDailyInfo(DailyInfo dd, JSONArray mainArray, Date searchDate, Connection conn)
	{
		processDetail(dd, dd.getPlDetail(), "PL", mainArray, searchDate, conn);
		processDetail(dd, dd.getGlDetail(), "GL", mainArray, searchDate, conn);
		processDetail(dd, dd.getSlDetail(), "SL", mainArray, searchDate, conn);
		processDetail(dd, dd.getDdDetail(), "DD", mainArray, searchDate, conn);
		processDetail(dd, dd.getRdDetail(), "RD", mainArray, searchDate, conn);
	}

	private void processDetail(DailyInfo dd, String detail, String type,
	        JSONArray mainArray, Date searchDate, Connection conn)
	{
	    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 DataBaseMethodsRavi()
	                    .checkLoanPaymentSource(loanNo, searchDate, conn);

	            String source = String.valueOf(paymentData.get("source"));

	            JSONObject obj = new JSONObject();

	            // Daily Demand details
	            obj.put("memberNo", dd.getShareHolderNo());
	            obj.put("name", dd.getName());
	            obj.put("fatherHusbandName", dd.getFatherHusbandName());
	            obj.put("mobileNo", dd.getMobileNo());
	            obj.put("address", dd.getAddress());

	            obj.put("pl", dd.getPlDetail());
	            obj.put("gl", dd.getGlDetail());
	            obj.put("centerCode", dd.getCenter());
	            obj.put("centerName", dd.getCenterName());
	            obj.put("sl", dd.getSlDetail());
	            obj.put("dd", dd.getDdDetail());
	            obj.put("rd", dd.getRdDetail());
	            obj.put("total", dd.getTotal());
	            obj.put("remark", dd.getRemark());

	            // Loan / Payment details
	            obj.put("loanNo", loanNo);
	            obj.put("amount", paymentData.get("amount"));
	            obj.put("userId", paymentData.get("userId"));
	            obj.put("empName", paymentData.get("empName"));
	            obj.put("source", source);

	            // Status
	            
	            
	            String apiStatus = "unpaid";

				if (source.equalsIgnoreCase("Paid by App")) {
					apiStatus = dbr.checkAppLoanPaymentStatus(loanNo, conn);
				} else if (source.equalsIgnoreCase("Paid by Web")) {
					apiStatus = dbr.checkWebLoanPaymentStatus(loanNo, conn);
				}

				obj.put("status", apiStatus);

				mainArray.add(obj);
	            
//	            if (source.equalsIgnoreCase("by app")
//	                    || source.equalsIgnoreCase("by web"))
//	            {
//	                obj.put("status", "paid");
//	            }
//	            else
//	            {
//	                obj.put("status", "pending");
//	            }
//
//	            mainArray.add(obj);
	            
	        }
	    }
	    catch (Exception e)
	    {
	        e.printStackTrace();
	    }
	}


	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;
	}
}