getConnection(); // Pagination $page = isset($_GET['page']) ? intval($_GET['page']) : 1; $perPage = 20; $offset = ($page - 1) * $perPage; // Filters $skinTypeFilter = isset($_GET['skin_type']) ? $_GET['skin_type'] : ''; $contactedFilter = isset($_GET['contacted']) ? $_GET['contacted'] : ''; $searchQuery = isset($_GET['search']) ? trim($_GET['search']) : ''; // Build query $where = []; $params = []; if ($skinTypeFilter) { $where[] = "skin_type = ?"; $params[] = $skinTypeFilter; } if ($contactedFilter !== '') { $where[] = "is_contacted = ?"; $params[] = $contactedFilter; } if ($searchQuery) { $where[] = "(name LIKE ? OR email LIKE ? OR phone LIKE ?)"; $searchParam = "%{$searchQuery}%"; $params[] = $searchParam; $params[] = $searchParam; $params[] = $searchParam; } $whereClause = !empty($where) ? "WHERE " . implode(" AND ", $where) : ""; // Get total count $countQuery = "SELECT COUNT(*) as total FROM skin_quiz_results {$whereClause}"; $countStmt = $conn->prepare($countQuery); $countStmt->execute($params); $totalResults = $countStmt->fetch(PDO::FETCH_ASSOC)['total']; $totalPages = ceil($totalResults / $perPage); // Get results $query = "SELECT * FROM skin_quiz_results {$whereClause} ORDER BY created_at DESC LIMIT {$perPage} OFFSET {$offset}"; $stmt = $conn->prepare($query); $stmt->execute($params); $results = $stmt->fetchAll(PDO::FETCH_ASSOC); // Statistics $statsQuery = " SELECT COUNT(*) as total, SUM(CASE WHEN is_contacted = 1 THEN 1 ELSE 0 END) as contacted, AVG(score) as avg_score, COUNT(CASE WHEN created_at >= DATE_SUB(NOW(), INTERVAL 7 DAY) THEN 1 END) as this_week FROM skin_quiz_results "; $statsStmt = $conn->query($statsQuery); $stats = $statsStmt->fetch(PDO::FETCH_ASSOC); ?> نتائج اختبار البشرة - Roz Skin Admin

🧪 نتائج اختبار البشرة

إدارة ومتابعة نتائج اختبارات العملاء

الإحصائيات إدارة الأسئلة

إجمالي النتائج

تم التواصل

متوسط النتيجة

هذا الأسبوع

['name' => 'دهنية', 'color' => 'blue'], 'dry' => ['name' => 'جافة', 'color' => 'orange'], 'combination' => ['name' => 'مختلطة', 'color' => 'purple'], 'normal' => ['name' => 'عادية', 'color' => 'green'], 'sensitive' => ['name' => 'حساسة', 'color' => 'pink'] ]; $skinInfo = $skinTypes[$result['skin_type']] ?? ['name' => $result['skin_type'], 'color' => 'gray']; ?>
العميل نوع البشرة النتيجة التاريخ الحالة إجراءات

لا توجد نتائج
/100
تم التواصل قيد الانتظار
عرض
1): ?>