36 lines
1.2 KiB
PHP
36 lines
1.2 KiB
PHP
<?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()]);
|
|
}
|