<?php
include("inc/config.php");

if (isset($_POST['id'])) {
    $id = $_POST['id'];

    $query = "SELECT * FROM clients WHERE id = '$id'";
    $result = mysqli_query($conn, $query);

    if (mysqli_num_rows($result) > 0) {
        $row = mysqli_fetch_assoc($result);

        // Send client details as JSON response
        echo json_encode([
            'status' => 'success',
            'data' => [
                'company_name' => $row['client_name'], // Ensure 'client_name' column exists
                'phone' => $row['phone'],             // Ensure 'phone' column exists
                'email' => $row['email'],             // Ensure 'email' column exists
                'gstin' => $row['client_gst']         // Corrected field name
            ]
        ]);
    } else {
        echo json_encode(['status' => 'error', 'message' => 'No data found']);
    }
} else {
    echo json_encode(['status' => 'error', 'message' => 'Invalid request']);
}
?>