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';
?>
Production Analytics
Official Results & Manual Evaluation Tracking
= $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 ActivatedAudit Period Closed