package natch_package;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.PreparedStatement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.primefaces.json.JSONObject;

import main_package.DataBaseConnection;

public class HdfcEventHandler extends HttpServlet {

    private static final long serialVersionUID = 1L;

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        response.setContentType("text/plain");
        response.setStatus(HttpServletResponse.SC_METHOD_NOT_ALLOWED);
        response.getWriter().write("GET method is not supported on this endpoint.");

        System.out.println("[HDFC CALLBACK] ❌ GET method called - Not supported.");
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        String requestBody = "";

        try {
            // 🔹 Read raw body
            StringBuilder sb = new StringBuilder();
            BufferedReader reader = request.getReader();

            String line;
            while ((line = reader.readLine()) != null) {
                sb.append(line);
            }

            requestBody = sb.toString().trim();

            // 🔹 Log received payload
            System.out.println("===== HDFC CALLBACK RECEIVED =====");
            System.out.println(requestBody);

            // 🔹 Save to DB
            hdfcWebhookSaver(requestBody);

            // 🔹 Send success response
            response.setStatus(HttpServletResponse.SC_OK);
            response.getWriter().write("SUCCESS");

        } catch (Exception e) {
            e.printStackTrace();

            response.setStatus(HttpServletResponse.SC_INTERNAL_SERVER_ERROR);
            response.getWriter().write("ERROR");
        }
    }

    // 🔹 Save callback to DB
    public void hdfcWebhookSaver(String requestBody) {

        Connection conn = null;
        PreparedStatement ps = null;

        try {
            conn = DataBaseConnection.JAVAConnection();

            String sql = "INSERT INTO hdfc_mandate_callback (response_payload) VALUES (?)";

            ps = conn.prepareStatement(sql);
            ps.setString(1, requestBody);

            int rows = ps.executeUpdate();

            if (rows > 0) {
                System.out.println("✅ HDFC callback stored successfully");
            } else {
                System.out.println("❌ Insert failed");
            }

        } catch (Exception e) {
            System.out.println("❌ DB Error while saving HDFC callback");
            e.printStackTrace();
        } finally {
            try {
                if (ps != null) ps.close();
                if (conn != null) conn.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
}