query("SELECT * FROM companies LIMIT 1"); $company = $stmt->fetch(); // Fetch Order Details with Customer and Branch info $stmt = db()->prepare("SELECT o.*, c.name_en as customer_name_en, c.name_ar as customer_name_ar, c.phone as customer_phone, b.name_en as branch_name_en, b.name_ar as branch_name_ar, b.address_en as branch_address_en, b.address_ar as branch_address_ar, b.phone as branch_phone FROM orders o LEFT JOIN customers c ON o.customer_id = c.id LEFT JOIN branches b ON o.branch_id = b.id WHERE o.id = ?"); $stmt->execute([$order_id]); $order = $stmt->fetch(); if (!$order) { die("Order not found"); } // Fetch items for this order $stmt = db()->prepare("SELECT oi.*, i.name_en, i.name_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(); $lang = $_SESSION['lang'] ?? 'en'; function format_currency($amount) { return number_format($amount, decimals()) . ' ' . currency(); } ?>