getConnection(); // Get filter parameters $filter_status = $_GET['status'] ?? ''; $filter_date = $_GET['date'] ?? ''; $search = $_GET['search'] ?? ''; $query = "SELECT bb.*, bs.name as service_name, bs.price as service_price, u.name as customer_name FROM beauty_bookings bb LEFT JOIN beauty_services bs ON bb.service_id = bs.id LEFT JOIN users u ON bb.user_id = u.id WHERE 1=1"; $params = []; if ($filter_status) { $query .= " AND bb.status = ?"; $params[] = $filter_status; } if ($filter_date) { $query .= " AND bb.appointment_date = ?"; $params[] = $filter_date; } if ($search) { $query .= " AND (bb.name LIKE ? OR bb.phone LIKE ? OR bb.email LIKE ?)"; $search_param = "%$search%"; $params[] = $search_param; $params[] = $search_param; $params[] = $search_param; } $query .= " ORDER BY bb.appointment_date DESC, bb.appointment_time DESC"; $stmt = $db->prepare($query); $stmt->execute($params); $all_bookings = $stmt->fetchAll(PDO::FETCH_ASSOC); // Statistics $total_bookings = count($all_bookings); $pending_bookings = count(array_filter($all_bookings, fn($b) => $b['status'] === 'pending')); $confirmed_bookings = count(array_filter($all_bookings, fn($b) => $b['status'] === 'confirmed')); $completed_bookings = count(array_filter($all_bookings, fn($b) => $b['status'] === 'completed')); } catch (Exception $e) { $error = "خطأ: " . $e->getMessage(); $all_bookings = []; } $status_ar = [ 'pending' => 'في الانتظار', 'confirmed' => 'مؤكد', 'completed' => 'مكتمل', 'cancelled' => 'ملغي' ]; $message = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_status'])) { try { $booking_id = $_POST['booking_id']; $status = $_POST['status']; $query = "UPDATE beauty_bookings SET status = ? WHERE id = ?"; $stmt = $db->prepare($query); $stmt->execute([$status, $booking_id]); header("Location: index.php?updated=1"); exit; } catch (Exception $e) { $message = "خطأ في التحديث: " . $e->getMessage(); } } if (isset($_GET['updated'])) { $message = 'تم تحديث حالة الحجز بنجاح!'; } ?> إدارة الحجوزات - Roz Skin

إدارة حجوزات البيوتي

عرض وإدارة جميع الحجوزات

إجمالي الحجوزات

في الانتظار

مؤكدة

مكتملة

إلغاء

جميع الحجوزات ()

# العميل الهاتف البريد الخدمة التاريخ الوقت الحالة الإجراءات
#
()
 - -
ج.م
 'bg-yellow-100 text-yellow-800', 'confirmed' => 'bg-blue-100 text-blue-800', 'completed' => 'bg-green-100 text-green-800', 'cancelled' => 'bg-red-100 text-red-800' ]; $status_class = $status_classes[$booking['status']] ?? 'bg-gray-100 text-gray-800'; ?>

لا توجد حجوزات

لم يتم إجراء أي حجوزات بعد