Panel | <?php echo APP

isLoggedIn()) { redirectTo('login.php'); } $currentUser = $auth->getCurrentUser(); $db = Database::getInstance(); // Function to get cached alignment score function getCachedAlignmentScore($db) { $result = $db->query(" SELECT alignment_score, total_panelists, calculated_at, calculated_by FROM panel_alignment_cache ORDER BY calculated_at DESC LIMIT 1 "); if ($result && $result->num_rows > 0) { return $result->fetch_assoc(); } return [ 'alignment_score' => 0.00, 'total_panelists' => 0, 'calculated_at' => null, 'calculated_by' => null ]; } // Pagination setup $current_page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1; $records_per_page = 50; $offset = ($current_page - 1) * $records_per_page; // Get total records count $total_result = $db->query("SELECT COUNT(*) as total FROM panel_data"); $total_records = $total_result ? $total_result->fetch_assoc()['total'] : 0; $total_pages = ceil($total_records / $records_per_page); // Pagination range calculation $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 headers $attributes = $db->query("SELECT * FROM attributes ORDER BY created_at ASC"); // Get active action $active_action = isset($_GET['action']) ? $_GET['action'] : ''; // Get actual panel data if records exist $panel_data = []; if ($total_records > 0) { $panel_query = $db->query(" SELECT * FROM panel_data ORDER BY created_at DESC LIMIT $offset, $records_per_page "); if ($panel_query) { while ($row = $panel_query->fetch_assoc()) { $panel_data[] = $row; } } } ?> Panel | <?php echo APP_NAME; ?>

isAdmin()): ?>

Panel Size:

Panel Alignment Score: Calculating...

Optimal Count Required:

Generating Panel Data

Initializing...

Processing in real-time batches for immediate progress updates.

Create New Directive

Define combinations of attributes that should NOT exist together in any panelist profile.

num_rows > 0): ?> fetch_assoc()): ?> data_seek(0); $values = json_decode($panel['attribute_values'], true); while ($attr = $attributes->fetch_assoc()): $value = $values[$attr['id']] ?? '-'; if (is_array($value)) { $value = implode(', ', $value); } ?>

Panelist ID		Actions

No panel data available. Click "Align" to generate panel data.

1): ?>

Create New Directive

Panel Integrity Check