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:

Pages:

Generate Additional Panel Members

Enter the number of additional panel members to generate:

Additional Count

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;"' : ''; ?>>