<?php
require_once('includes/connection.php');

if (isset($_GET['vehicle_id'])) {
    $vehicle_id = intval($_GET['vehicle_id']);
    $response = [];

    // Fetch vehicle details
    $stmt = $conn->prepare("SELECT vehicle_capacity, vehicle_insurance_validy FROM vehicle_master WHERE id = ?");
    $stmt->bind_param("i", $vehicle_id);
    $stmt->execute();
    $stmt->bind_result($capacity, $insurance);
    $stmt->fetch();
    $response['vehicle_capacity'] = $capacity;
    $response['vehicle_insurance_validy'] = $insurance;
    $stmt->close();

    // Fetch brokers
    $brokers = [];
    $broker_stmt = $conn->prepare("SELECT transporter_name FROM broker_master WHERE vehicle_id = ? AND status = 1");
    $broker_stmt->bind_param("i", $vehicle_id);
    $broker_stmt->execute();
    $broker_result = $broker_stmt->get_result();
    while ($row = $broker_result->fetch_assoc()) {
        $brokers[] = $row;
    }
    $response['brokers'] = $brokers;
    $broker_stmt->close();

    header('Content-Type: application/json');
    echo json_encode($response);
}