<?php
session_start();
require_once 'db.php';

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'delete') {
    $id = intval($_POST['id']);

    if ($id > 0) {
        try {
            $con->autocommit(false);

            // Check if the customer has associated products in cus_product
            $checkQuery = "SELECT COUNT(*) as count FROM cus_product WHERE cid = $id";
            $result = $con->query($checkQuery);
            $row = $result->fetch_assoc();

            if ($row['count'] > 0) {
                echo json_encode([
                    "status" => "error",
                    "message" => "Cannot delete customer. Associated products exist."
                ]);
                exit;
            }

            // Delete customer-related records
            $deleteCustomer = "DELETE FROM customers WHERE id = $id";
            $con->query($deleteCustomer);

            $deleteAddress = "DELETE FROM customer_addresses WHERE customer_id = $id";
            $con->query($deleteAddress);

            $con->commit();

            echo json_encode([
                "status" => "success",
                "message" => "Customer deleted successfully."
            ]);

        } catch (Exception $e) {
            $con->rollback();
            echo json_encode([
                "status" => "error",
                "message" => "Error deleting customer: " . $e->getMessage()
            ]);
        }
    } else {
        echo json_encode([
            "status" => "error",
            "message" => "Invalid customer ID."
        ]);
    }
} else {
    echo json_encode([
        "status" => "error",
        "message" => "Invalid request."
    ]);
}
?>