<?php
header('Content-Type: application/json');
require_once __DIR__ . '/../db/config.php';
require_once __DIR__ . '/../includes/lang.php';

$order_id = $_GET['id'] ?? null;

if (!$order_id) {
    echo json_encode(['success' => false, 'error' => 'Order ID is required']);
    exit;
}

try {
    $stmt = db()->prepare("SELECT oi.quantity, i.name_en as item_en, i.name_ar as item_ar, 
                         s.name_en as service_en, s.name_ar as service_ar
                         FROM order_items oi
                         JOIN items i ON oi.item_id = i.id
                         JOIN services s ON oi.service_id = s.id
                         WHERE oi.order_id = ?");
    $stmt->execute([$order_id]);
    $items = $stmt->fetchAll(PDO::FETCH_ASSOC);

    // Fetch order number for the modal title
    $stmt = db()->prepare("SELECT order_number FROM orders WHERE id = ?");
    $stmt->execute([$order_id]);
    $order = $stmt->fetch(PDO::FETCH_ASSOC);

    echo json_encode([
        'success' => true,
        'order_number' => $order['order_number'] ?? '',
        'items' => $items
    ]);
} catch (Exception $e) {
    echo json_encode(['success' => false, 'error' => $e->getMessage()]);
}