Panel | <?php echo APP_NAME; ?>

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 cached alignment score instead of calculating $cachedAlignment = getCachedAlignmentScore($db); $alignmentScore = $cachedAlignment['alignment_score']; $lastCalculated = $cachedAlignment['calculated_at']; // Format the last calculated time $calculatedTimeText = ''; if ($lastCalculated) { $calculatedTime = new DateTime($lastCalculated); $calculatedTime->setTimezone(new DateTimeZone('Asia/Kolkata')); $calculatedTimeText = $calculatedTime->format('M d, Y H:i'); } // 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: % Last:

Optimal Count Required:

Create New Directive

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

First Condition Attribute

Choice(s) 1 (Multiple selections allowed) Hold Ctrl/Cmd to select multiple items

Second Condition Attribute

Choice(s) 2 (Multiple selections allowed) Hold Ctrl/Cmd to select multiple items

ID	First Condition	Second Condition	Status	Actions
Loading directives...

Panel Generation Progress

Initializing...

num_rows > 0): ?> data_seek(0); while ($attr = $attributes->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): ?>