Panel | <?php echo APP

isLoggedIn()) { redirectTo('login.php'); } $currentUser = $auth->getCurrentUser(); $db = Database::getInstance(); // Get URL action parameter for UI state $active_action = $_GET['action'] ?? ''; // Calculate pagination $records_per_page = 25; $current_page = max(1, intval($_GET['page'] ?? 1)); $offset = ($current_page - 1) * $records_per_page; // Get filters and search $search = $_GET['search'] ?? ''; $attribute_filter = $_GET['attribute_filter'] ?? ''; $value_filter = $_GET['value_filter'] ?? ''; // Build WHERE clause for filters $whereConditions = []; $params = []; $types = ''; if (!empty($search)) { $whereConditions[] = "panelist_id LIKE ?"; $params[] = "%$search%"; $types .= 's'; } if (!empty($attribute_filter) && !empty($value_filter)) { $whereConditions[] = "JSON_EXTRACT(attribute_values, '$.$attribute_filter') LIKE ?"; $params[] = "%$value_filter%"; $types .= 's'; } $whereClause = !empty($whereConditions) ? 'WHERE ' . implode(' AND ', $whereConditions) : ''; // Get total records count for pagination $countQuery = "SELECT COUNT(*) as count FROM panel_data $whereClause"; if (!empty($params)) { $countStmt = $db->prepare($countQuery); $countStmt->bind_param($types, ...$params); $countStmt->execute(); $total_records = $countStmt->get_result()->fetch_assoc()['count']; } else { $total_result = $db->query($countQuery); $total_records = $total_result ? $total_result->fetch_assoc()['count'] : 0; } $total_pages = ceil($total_records / $records_per_page); // Calculate pagination range $pagination_range = 5; $pagination_start = max(1, $current_page - floor($pagination_range / 2)); $pagination_end = min($total_pages, $pagination_start + $pagination_range - 1); if ($pagination_end - $pagination_start + 1 < $pagination_range) { $pagination_start = max(1, $pagination_end - $pagination_range + 1); } // Get attributes for table columns and filters $attributes = $db->query("SELECT id, name FROM attributes ORDER BY created_at ASC"); // Get actual panel data with filters $panel_data = []; if ($total_records > 0) { $dataQuery = " SELECT * FROM panel_data $whereClause ORDER BY created_at DESC LIMIT $offset, $records_per_page "; if (!empty($params)) { $dataStmt = $db->prepare($dataQuery); $dataStmt->bind_param($types, ...$params); $dataStmt->execute(); $panel_query = $dataStmt->get_result(); } else { $panel_query = $db->query($dataQuery); } if ($panel_query) { while ($row = $panel_query->fetch_assoc()) { $panel_data[] = $row; } } } ?> Panel | <?php echo APP_NAME; ?>

isAdmin()): ?>

Panel Size:

Alignment Score: Calculating...

Optimal Count Required:

num_rows > 0): ?> data_seek(0); while ($attr = $attributes->fetch_assoc()): ?> data_seek(0); ?> fetch_assoc()): ?>

Panelist ID		Actions

No Panel Data Available No panel members match your current filters. Try adjusting your search criteria. Click "Synthesize" to generate panel data based on your statistical requirements.

1): ?>

Showing - of panel members

> > = $total_pages ? 'style="pointer-events: none;"' : ''; ?>> = $total_pages ? 'style="pointer-events: none;"' : ''; ?>>

Generating Panel Data

Initializing...

Generated

Target

Time

Filter & Search Panel Members