Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): Failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/monara/public_html/test.athavaneng.com/themes.php on line 99

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 226

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 227

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 228

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 229

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 230

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 231
query("SELECT COUNT(*) FROM users WHERE role = 'member'")->fetchColumn() ?: 1; $deadline_hours = $pdo->query("SELECT setting_value FROM site_settings WHERE setting_key = 'audit_deadline_hours'")->fetchColumn() ?: 24; // 3. Fetch Dramas with Participation Stats $report_query = "SELECT d.*, COUNT(DISTINCT pr.user_id) as current_evaluators FROM dramas d LEFT JOIN production_ratings pr ON d.id = pr.drama_id GROUP BY d.id ORDER BY d.created_at DESC"; $dramas = $pdo->query($report_query)->fetchAll(); include '../includes/header.php'; ?>

Teledrama Analytics

Official Results & Manual Evaluation Tracking

Export Master Summary
= $total_members_count); $total_overall = 0; if ($is_complete) { $avg_sql = "SELECT AVG(prv.score) as avg_val FROM rating_parameters rp LEFT JOIN production_rating_values prv ON rp.id = prv.parameter_id LEFT JOIN production_ratings pr ON prv.production_rating_id = pr.id WHERE pr.drama_id = ? GROUP BY rp.id"; $stmt_avg = $pdo->prepare($avg_sql); $stmt_avg->execute([$row['id']]); $dynamic_stats = $stmt_avg->fetchAll(); foreach($dynamic_stats as $ds) { $total_overall += $ds['avg_val']; } } // 5. Calculate Deadline based on MANUAL START TRIGGER $seconds_left = 0; $is_expired = true; $has_started = !empty($row['evaluation_start_at']); if ($has_started) { $expiry_unix = strtotime($row['evaluation_start_at']) + ($deadline_hours * 3600); $seconds_left = $expiry_unix - time(); $is_expired = ($seconds_left <= 0); } // Time Calculations for display $d = floor(max(0, $seconds_left) / 86400); $h = floor((max(0, $seconds_left) % 86400) / 3600); $m = floor((max(0, $seconds_left) % 3600) / 60); $s = max(0, $seconds_left) % 60; ?>
Window Opened: Awaiting Manual Start
EVALUATION WINDOW Trigger Not Activated Audit Period Closed
DAYS
:
HRS
:
MINS
:
SECS
OFFICIAL CONSENSUS SCORE / 100
AVERAGE SCORE LOCKED -- . --
Participation /
Individual Report Individual Logs