<?php

header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=UTF-8");

include_once '../config/database.php'; 
include_once '../objects/room.php'; 
include_once '../helpers/rental_metadata.php';

$database = new Database();
$db = $database->getConnection();

$room = new Room($db);

$stmt = $room->getAllRows();
$num = $stmt->rowCount();


$response = array();
$response["records"] = array();

if ($num > 0) {

    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        extract($row); 
        $vehicle_meta = parse_vehicle_metadata($remark);
        $brand_model = trim(implode(' ', array_filter(array(
            $vehicle_meta['brand'],
            $vehicle_meta['model'],
            $vehicle_meta['year'],
        ))));
        $odometer = $vehicle_meta['odometer'] !== '' ? $vehicle_meta['odometer'] . ' km' : '';

        $item = array(
            (int)$id,
            $room_number, 
            $room_type,
            $bed_type,
            $max_occupancy,
            $room_rate,
            $extra_bed,
            $extra_person,
            $brand_model,
            $vehicle_meta['color'],
            $vehicle_meta['fuel_type'],
            $odometer,
            $vehicle_meta['note'],
        );


        array_push($response["records"], $item);
    }
}


http_response_code(200);
echo json_encode($response);
?>
