package HdfcEmandate;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.net.HttpURLConnection;
import java.net.URL;

// SQL
import java.sql.Connection;
import java.sql.PreparedStatement;

// Your project
import main_package.DataBaseConnection;

public class HdfcVerificationService {

    public static void verifyMandate(EmandateRequest mandate) {

        try {
            String apiUrl = "https://YOUR_HDFC_VERIFICATION_API_URL"; // replace

            URL url = new URL(apiUrl);
            HttpURLConnection conn = (HttpURLConnection) url.openConnection();

            conn.setRequestMethod("POST");
            conn.setRequestProperty("Content-Type", "application/json");
            conn.setDoOutput(true);

            //Build JSON manually
            String jsonRequest = "{ \"mandatemsgIDList\": [ { " +
                    "\"Utilitycode\": \"" + mandate.getUtilCode() + "\"," +
                    "\"Shortcode\": \"UAT\"," +
                    "\"Msgid\": \"" + mandate.getMsgId() + "\"," +
                    "\"TransDate\": \"" + mandate.getCustomerStartDate() + "\"," +
                    "\"TransTime\": \"11:25\"" +
                    "} ] }";

            // Send request
            OutputStream os = conn.getOutputStream();
            os.write(jsonRequest.getBytes("UTF-8"));
            os.flush();
            os.close();

            // 🔹 Read response
            BufferedReader br = new BufferedReader(
                    new InputStreamReader(conn.getInputStream(), "UTF-8"));

            StringBuilder response = new StringBuilder();
            String line;

            while ((line = br.readLine()) != null) {
                response.append(line);
            }

            br.close();

            String responseStr = response.toString();
            System.out.println("Verification Response: " + responseStr);

            // Manual parsing (simple extraction)
            String accepted = extractValue(responseStr, "Accptd");
            String umrn = extractValue(responseStr, "UMRN");
            String reasonCode = extractValue(responseStr, "ReasonCode");
            String reasonDesc = extractValue(responseStr, "ReasonDesc");

            updateMandateStatus(
                    mandate.getMsgId(),
                    "true".equalsIgnoreCase(accepted) ? "SUCCESS" : "FAILED",
                    umrn,
                    reasonCode,
                    reasonDesc,
                    responseStr
            );

        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    // Simple JSON value extractor (no library)
    private static String extractValue(String json, String key) {
        try {
            String search = "\"" + key + "\":";
            int start = json.indexOf(search);

            if (start == -1) return null;

            start += search.length();

            // Skip spaces and quotes
            while (start < json.length() &&
                    (json.charAt(start) == ' ' || json.charAt(start) == '\"')) {
                start++;
            }

            int end = start;

            while (end < json.length() &&
                    json.charAt(end) != '\"' &&
                    json.charAt(end) != ',' &&
                    json.charAt(end) != '}') {
                end++;
            }

            return json.substring(start, end).replace("\"", "").trim();

        } catch (Exception e) {
            return null;
        }
    }

    // DB Update
    public static void updateMandateStatus(String msgId, String status,
                                           String umrn, String errorCode,
                                           String errorMsg, String rawResponse) {

        String sql = "UPDATE hdfc_emandates SET status=?, umrn=?, error_code=?, error_message=?, raw_response=? WHERE msg_id=?";

        try (Connection conn = DataBaseConnection.JAVAConnection();
             PreparedStatement ps = conn.prepareStatement(sql)) {

            ps.setString(1, status);
            ps.setString(2, umrn);
            ps.setString(3, errorCode);
            ps.setString(4, errorMsg);
            ps.setString(5, rawResponse);
            ps.setString(6, msgId);

            ps.executeUpdate();

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}