prepare("SELECT * FROM orders WHERE id = ?");
if ($branch_id) {
$stmt = db()->prepare("SELECT * FROM orders WHERE id = ? AND branch_id = ?");
$stmt->execute([$edit_order_id, $branch_id]);
} else {
$stmt->execute([$edit_order_id]);
}
$edit_order = $stmt->fetch();
if ($edit_order) {
$stmt = db()->prepare("SELECT oi.*, i.name_en, i.name_ar, i.vat_percent, 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([$edit_order_id]);
$edit_items_raw = $stmt->fetchAll();
foreach ($edit_items_raw as $ei) {
$edit_items[] = [
'item_id' => $ei['item_id'],
'service_id' => $ei['service_id'],
'name' => $lang === 'en' ? $ei['name_en'] : $ei['name_ar'],
'service_name' => $lang === 'en' ? $ei['service_en'] : $ei['service_ar'],
'price' => (float)$ei['unit_price'],
'qty' => (int)$ei['quantity'],
'vat_percent' => (float)$ei['vat_percent']
];
}
}
}
// Get all categories
$categories = db()->query("SELECT * FROM categories WHERE is_deleted = 0 ORDER BY name_en ASC")->fetchAll();
// Get all items with details
$stmt = db()->prepare("SELECT i.*, c.name_en as cat_en, c.name_ar as cat_ar
FROM items i
LEFT JOIN categories c ON i.category_id = c.id
WHERE i.is_deleted = 0
ORDER BY i.name_en ASC");
$stmt->execute();
$items_raw = $stmt->fetchAll();
// Get all services
$services_raw = db()->query("SELECT * FROM services WHERE is_deleted = 0 ORDER BY name_en ASC")->fetchAll();
// Get all prices (globally shared)
$stmt = db()->prepare("SELECT * FROM prices");
$stmt->execute();
$prices_raw = $stmt->fetchAll();
$prices = [];
foreach ($prices_raw as $p) {
$prices[$p['item_id']][$p['service_id']] = (float)$p['price'];
}
$items = [];
foreach ($items_raw as $i) {
$item_services = [];
foreach ($services_raw as $s) {
if (isset($prices[$i['id']][$s['id']])) {
$item_services[] = [
'id' => $s['id'],
'name_en' => $s['name_en'],
'name_ar' => $s['name_ar'],
'price' => $prices[$i['id']][$s['id']]
];
}
}
if (!empty($item_services)) {
$items[$i['id']] = [
'id' => $i['id'],
'name_en' => $i['name_en'],
'name_ar' => $i['name_ar'],
'category_id' => $i['category_id'],
'image_url' => $i['image_url'],
'vat_percent' => (float)($i['vat_percent'] ?? 15),
'services' => $item_services
];
}
}
// Get all customers
$stmt = db()->prepare("SELECT id, name_en, name_ar, phone, loyalty_points FROM customers ORDER BY name_en ASC");
$stmt->execute();
$customers = $stmt->fetchAll();
$pageTitle = $edit_order ? ($lang == 'en' ? 'Edit Order #' . $edit_order['order_number'] : 'تعديل طلب رقم ' . $edit_order['order_number']) : ($lang == 'en' ? 'Point of Sale' : 'نقطة البيع');
?>
 ?>)
% VAT