getConnection(); $project_id = isset($_GET['id']) ? intval($_GET['id']) : 0; if ($project_id <= 0) { header('Location: index.php'); exit; } // جلب معلومات المشروع $query = "SELECT * FROM iot_projects WHERE id = :id"; $stmt = $conn->prepare($query); $stmt->bindParam(':id', $project_id); $stmt->execute(); $project = $stmt->fetch(PDO::FETCH_ASSOC); if (!$project) { header('Location: index.php'); exit; } // جلب الغرف والأجهزة $rooms_query = "SELECT r.*, (SELECT COUNT(*) FROM iot_project_devices WHERE room_id = r.id) as devices_count FROM iot_project_rooms r WHERE r.project_id = :project_id ORDER BY r.created_at ASC"; $rooms_stmt = $conn->prepare($rooms_query); $rooms_stmt->bindParam(':project_id', $project_id); $rooms_stmt->execute(); $rooms = $rooms_stmt->fetchAll(PDO::FETCH_ASSOC); // جلب الأجهزة لكل غرفة $rooms_with_devices = []; foreach ($rooms as $room) { $devices_query = "SELECT * FROM iot_project_devices WHERE room_id = :room_id"; $devices_stmt = $conn->prepare($devices_query); $devices_stmt->bindParam(':room_id', $room['id']); $devices_stmt->execute(); $room['devices'] = $devices_stmt->fetchAll(PDO::FETCH_ASSOC); $rooms_with_devices[] = $room; } ?> كروكي المشروع 2D - <?php echo htmlspecialchars($project['customer_name']); ?>

كروكي المشروع 2D

مشروع:

العودة

أدوات الرسم

الغرف ()

'🛏️', 'living_room' => '🛋️', 'kitchen' => '🍳', 'bathroom' => '🚿', 'office' => '💼', 'garage' => '🚗', 'garden' => '🌳', 'other' => '📍' ]; echo $room_icons[$room['room_type']] ?? '📍'; ?>

م² • جهاز

دليل الألوان

غرف نوم

صالات

مطابخ

حمامات

اضغط واسحب لرسم الغرف • انقر لإضافة الأجهزة