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
0) { $stmt = $pdo->prepare("SELECT * FROM dramas WHERE id = ?"); $stmt->execute([$target_id]); $dramas = $stmt->fetchAll(); if (!$dramas) exit("Drama not found"); $filename = "Production_" . preg_replace('/[^a-zA-Z0-9]/', '_', $dramas[0]['title']) . "_Report.xls"; } else { $dramas = $pdo->query("SELECT * FROM dramas ORDER BY created_at DESC")->fetchAll(); $filename = "All_Teledramas_Summary_Report.xls"; } $members = $pdo->query("SELECT id, full_name FROM users WHERE role = 'member' ORDER BY id ASC")->fetchAll(); $params = $pdo->query("SELECT * FROM rating_parameters ORDER BY id ASC")->fetchAll(); // Force Download Headers header("Content-Type: application/vnd.ms-excel; charset=utf-8"); header("Content-Disposition: attachment; filename=$filename"); header("Pragma: no-cache"); header("Expires: 0"); // Start HTML Output for Excel ?>
SWARNAVAHINI TELEDRAMA CONTENT COMMITTEE - EVALUATION REPORT
Generated on:

prepare(" SELECT score FROM production_rating_values prv JOIN production_ratings pr ON prv.production_rating_id = pr.id WHERE pr.drama_id = ? AND pr.user_id = ? AND prv.parameter_id = ? "); $score_stmt->execute([$drama_id, $m['id'], $p['id']]); $score = $score_stmt->fetchColumn(); if ($score !== false): $row_sum += $score; $voter_count++; ?> prepare("SELECT total_score FROM production_ratings WHERE drama_id = ? AND user_id = ?"); $total_stmt->execute([$drama_id, $m['id']]); $ts = $total_stmt->fetchColumn(); if ($ts !== false): $grand_sum += $ts; $voters_overall++; ?>
PRODUCTION:
Criteria Max Marks Total Sum Mean Score
N/A 0) ? number_format($row_sum / $voter_count, 2) : '0.00' ?>
GRAND TOTAL 100 0 0) ? number_format($grand_sum / $voters_overall, 2) : '0.00' ?>