<?php

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

include_once '../config/database.php'; 
include_once '../objects/reservation.php'; 
include_once '../config/_globle.php';

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

$reservation = new Reservation($db);

// Call new method to get monthly OTA & WalkIn sales
$stmt = $reservation->getMonthlySalesByChannel();
$num = $stmt->rowCount();

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

if ($num > 0) {
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        extract($row); 

        $item = array(
            "month"  => (int)$month,   // 1–12
            "OTA"    => (float)$OTA,   // OTA sales
            "WalkIn" => (float)$WalkIn // Walk-In sales
        );

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

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