package jsonPackage;

import group_head_package.DataBaseIncomeExpense;
import json_package.DatabaseMethods1;

import java.io.ByteArrayInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Base64;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.ExternalContext;
import javax.faces.context.FacesContext;

import main_package.DataBaseConnection;
import main_package.DataBaseMethodTaheer;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsRavi;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ManagedBean(name = "payLoanEmiByCustomerJson")
@ViewScoped

public class PayLoanEmiByCustomerJsonBean implements Serializable
{
    private static final long serialVersionUID = 1L;

    String json;
    
    Date startDate;

    DataBaseMethods obj = new DataBaseMethods();
    DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
    DataBaseMethodsRavi dbr = new DataBaseMethodsRavi();

	public PayLoanEmiByCustomerJsonBean() throws ParseException {

		Map<String, String> params = FacesContext.getCurrentInstance().getExternalContext().getRequestParameterMap();

		String loanType = params.get("loanType");
		String loanNo = params.get("loanNo");
		String sDate = params.get("startDate");
		String amount = params.get("amount");
		String savingAmount = params.get("savingAmount");
		String penaltyAmount = params.get("penaltyAmount");
		String rdAmount = params.get("rdAmount");
		String payMode = params.get("payMode");
		String transactionId = params.get("transactionId");
		String response = params.get("response");
		String paymentProof = params.get("paymentProof");
		String rdNumber = params.get("rdNumber");
		String chequeBounceAmount = params.get("chequeBounceCharge");

		String employee = "";
		int branchId = 0;

		// Default values
		if (paymentProof == null) {
			paymentProof = "";
		}

		if (savingAmount == null || savingAmount.trim().isEmpty()) {
			savingAmount = "0";
		}

		if (penaltyAmount == null || penaltyAmount.trim().isEmpty()) {
			penaltyAmount = "0";
		}

		if (rdAmount == null || rdAmount.trim().isEmpty()) {
			rdAmount = "0";
		}

		if (amount == null || amount.trim().isEmpty()) {
			amount = "0";
		}
	     if (chequeBounceAmount == null || chequeBounceAmount.equals(""))
	        {
	        	chequeBounceAmount = "0";
	        }

		// Normalize loan number
		if (loanNo != null && loanNo.contains("/")) {
			loanNo = loanNo.substring(0, loanNo.indexOf("/"));
		}

		JSONObject mainobj = new JSONObject();
		JSONArray arr = new JSONArray();
		JSONObject resultObj = new JSONObject();

		// Validate loan number
		if (loanNo == null || loanNo.trim().isEmpty()) {
			resultObj.put("st", "Loan number is required.");
			arr.add(resultObj);
			mainobj.put("track", arr);
			json = mainobj.toJSONString();
			return;
		}

		// Calculate missing values from loan number
		try (Connection conn = DataBaseConnection.JAVAConnection()) {

			if (loanType == null || loanType.trim().isEmpty()) {
				loanType = dbr.loanTypeByLoanNo(loanNo);
			}

			employee = dbr.userIdByLoanNo(loanNo, conn);
			branchId = dbr.branchIdByLoanNo(loanNo, conn);

		} catch (Exception e) {
			e.printStackTrace();
		}

		// Do not save request if loan details are missing
		if (loanType == null || loanType.trim().isEmpty() || employee == null || employee.trim().isEmpty()
				|| branchId <= 0) {

			resultObj.put("st", "Invalid loan number or loan details not found.");
			arr.add(resultObj);
			mainobj.put("track", arr);
			json = mainobj.toJSONString();
			return;
		}

		// Payment proof handling - existing logic
		String paymentProofPath = "";

		if (!paymentProof.trim().isEmpty()) {
			try {
				String extension = ".jpg";

				if (paymentProof.startsWith("data:image/png")) {
					extension = ".png";
				} else if (paymentProof.startsWith("data:image/webp")) {
					extension = ".webp";
				}

				if (paymentProof.contains(",")) {
					paymentProof = paymentProof.substring(paymentProof.indexOf(",") + 1);
				}

				paymentProof = paymentProof.replace(' ', '+');
				paymentProof = paymentProof.replace("\r", "").replace("\n", "").replace("\t", "");

				byte[] fileBytes = Base64.getDecoder().decode(paymentProof);

				String fileName = "payment_proof_" + System.currentTimeMillis() + extension;

				paymentProofPath = fileName;

				try (InputStream in = new ByteArrayInputStream(fileBytes)) {
					obj.makeProfile(in, paymentProofPath);
				}

			} catch (Exception e) {
				e.printStackTrace();
				paymentProofPath = "";
			}
		}

		// Date handling - existing logic
		DateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");

		if (sDate != null && !sDate.trim().isEmpty()) {
			startDate = formatter.parse(sDate);
		}

		if (startDate == null) {
			resultObj.put("st", "Start date is required.");
			arr.add(resultObj);
			mainobj.put("track", arr);
			json = mainobj.toJSONString();
			return;
		}

		String loginStatus = obj.checkLoginIdStatus(employee);

		int i = 0;

		if (loginStatus != null && loginStatus.equalsIgnoreCase("active")) {

			i = dbr.paymentRequest2(branchId, employee, startDate, loanType, loanNo, amount, payMode,
					"NA", transactionId, response, "", paymentProofPath);

		} else {
			i = -99;
		}

		// Saving payment - existing flow
		if (Double.parseDouble(savingAmount) > 0 && loginStatus != null && loginStatus.equalsIgnoreCase("active")) {

			String shno = obj.shareHolderNoByLoanNo(loanNo);
			String svno = obj.savingAccountByShareHolderNo(shno);

			dbr.paymentRequest2(branchId, employee, startDate, "saving",svno,savingAmount, payMode,
					"deposit", transactionId, response, "", "");
		}

		// Penalty payment
		if (Double.parseDouble(penaltyAmount) > 0 && loginStatus != null && loginStatus.equalsIgnoreCase("active")) {

			dbr.paymentRequest2(branchId, employee, startDate, "penalty", loanNo, penaltyAmount,
					payMode, "NA", transactionId, response, "", "");
		}
		
	       if (Double.parseDouble(chequeBounceAmount) > 0 && loginStatus.equalsIgnoreCase("active"))
	        {
	            dbr.paymentRequest2(branchId, employee, startDate, "bounceCharge", loanNo, chequeBounceAmount, payMode, "NA",
	            									  transactionId, response, "", paymentProofPath);
	        }

		// RD payment
		if (Double.parseDouble(rdAmount) > 0 && loginStatus != null && loginStatus.equalsIgnoreCase("active")) {

			dbr.paymentRequest2(branchId, employee, startDate, "RD", rdNumber, rdAmount, payMode,
					"NA", transactionId, response, "", "");
		}

		String status = "";

		if (i >= 1) {
			status = "Payment Request Sent Successfully";

			sendMessage(branchId, employee, loanNo, amount, payMode, savingAmount, penaltyAmount);

			if (response != null && response.equalsIgnoreCase("success")) {

				String typeMessage = "Dear Sir, A Request of Payment Amount " + amount
						+ "/- Receive From Payment Gateway. " + "Please Capture This Payment from Payment "
						+ "Gateway. Thanks...";

				try (Connection conn = DataBaseConnection.JAVAConnection()) {

					String contactNo = obj.contactNoForSchedularMsg(branchId, conn);

					obj.runMessageUrl(branchId, contactNo, typeMessage, "System", "pending", conn);

				} catch (SQLException e) {
					e.printStackTrace();
				}
			}

		} else if (i == -99) {
			status = "Your User ID Has been Blocked By Admin.";
		} else {
			status = "Something went wrong.";
		}

		resultObj.put("st", status);
		arr.add(resultObj);
		mainobj.put("track", arr);
		json = mainobj.toJSONString();
	}


    
    
    private void addPenalty(int branchId, String employee, String lno, String penaltyAmount, String loanType)
    {
        Connection conn = DataBaseConnection.JAVAConnection();

        String loanLabel = obj.loanLabelByLoanValue(loanType);

        String paymentMode = "Cash";

        String voucherNo = obj.generateVoucherNo(branchId, "income_table", conn);

        int i = new DataBaseIncomeExpense().addIncome(branchId, startDate, "Other_Cr", paymentMode, penaltyAmount, "", "", "", 
									        		  null, "Receive Loan Penalty", "Receive Penalty", 0, "N/A", "0", 0,
									                  lno, loanLabel, voucherNo, "", 0, "active", "");

        if (i > 0)
        {
            if (paymentMode.equalsIgnoreCase("Cash"))
            {
                obj.decreaseSharedCompanyAmount(branchId, Double.parseDouble(penaltyAmount));
            }
        }
    }

 
    
    private void sendMessage(int branchId, String employee, String lno, String amount, String payMode,
			String savingAmount, String penaltyAmount) 
    {			
		double totalAmount = Double.parseDouble(savingAmount) + Double.parseDouble(amount)
				+ Double.parseDouble(penaltyAmount);

		Connection conn = DataBaseConnection.JAVAConnection();

		String check = obj.checkStatusInMessageSettingTable("Pay Loan Emi By App");
		
		if (check.equals("active")) {

			String shno = obj.shareHolderNoByLoanNo(lno);
			String name = obj.firstApplicantNameBySHNo(shno, conn);
			String contactNo = obj.applicantContactNoByShareHolderNo(shno, conn);
			
			boolean isDLT = dbmt.isDLTMessageApi(conn);
			
			if (isDLT) {
				Map<String, String> variables = new HashMap<>();
				variables.put("name", name);
				variables.put("amount", String.valueOf(totalAmount));

				dbmt.sendDLTMessage(contactNo, null, variables, conn, "loan EMI payment");
			}
			else 
			{
				String typeMessage = "Dear " + name + ", Rs. " + totalAmount + " Submit Sucessfully By " + payMode;
				obj.runMessageUrl(branchId, contactNo, typeMessage, employee,
				        "1207161822711123650", conn);
			}

		} else {
			FacesContext.getCurrentInstance().addMessage(null,
					new FacesMessage("Message For This Module is not Active. "
							+ "Please Go to In Master Setting Module " + "and Active Message For This Module."));
		}

		try {
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

    // =============================================================
    // RENDER JSON
    // =============================================================

	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;
    }
}