File Manager

✏️ Edit File: /home/rla105zs937x/public_html/kalamtrophy.in/feedback_view.php

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

require_once 'Tournament/Core/Database.php';
use Tournament\Core\Database;

try {
    $dbConn = Database::getInstance()->getConnection();
    
    // 1. Fetch All Submissions for Data Grid
    $stmt = $dbConn->query("SELECT * FROM tournament_feedback ORDER BY id DESC");
    $allFeedback = $stmt->fetchAll(\PDO::FETCH_ASSOC);

// 2. Fetch Aggregated Metrics for Metrics Dashboard
    $ldYes = $dbConn->query("SELECT COUNT(*) FROM tournament_feedback WHERE lucky_draw_opinion LIKE 'Yes%'")->fetchColumn();
    $ldNo = $dbConn->query("SELECT COUNT(*) FROM tournament_feedback WHERE lucky_draw_opinion LIKE 'No%'")->fetchColumn();
    $ldQual = $dbConn->query("SELECT COUNT(*) FROM tournament_feedback WHERE lucky_draw_opinion LIKE 'Conduct%'")->fetchColumn();

$sunStrict = $dbConn->query("SELECT COUNT(*) FROM tournament_feedback WHERE sunday_only_opinion LIKE 'Yes%'")->fetchColumn();
    $satOpen = $dbConn->query("SELECT COUNT(*) FROM tournament_feedback WHERE sunday_only_opinion LIKE 'No%'")->fetchColumn();
    $multiDay = $dbConn->query("SELECT COUNT(*) FROM tournament_feedback WHERE sunday_only_opinion LIKE 'Continuous%'")->fetchColumn();

} catch (\Exception $e) {
    die("Data Analytics Engine Failure: " . htmlspecialchars($e->getMessage()));
}

include('header.php');
?>

<main class="w-full max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 py-6 overflow-x-hidden">
    
    
    <div class="bg-white p-4 sm:p-6 rounded-2xl border border-slate-200 shadow-sm mb-6 flex flex-col sm:flex-row justify-between items-start sm:items-center gap-4">
        <div class="w-full sm:w-auto">
            <div class="flex flex-wrap items-center gap-2">
                <a href="admin_dashboard.php" class="text-slate-400 hover:text-slate-900 transition text-xs sm:text-sm font-bold flex items-center gap-1"><i class="bi bi-arrow-left"></i> Admin</a>
                <span class="text-slate-300">/</span>
                <span class="text-[10px] font-black text-amber-600 bg-amber-50 border border-amber-200 px-2 py-0.5 rounded uppercase tracking-wider">Analytics Mode</span>
            </div>
            <h1 class="text-lg sm:text-xl font-black text-slate-800 tracking-tight uppercase mt-2">Captains Survey Analytics</h1>
            <p class="text-[11px] sm:text-xs text-slate-400 mt-0.5">Real-time data reporting on registration structures and calendar preference matrices.</p>
        </div>
        <div class="text-xs font-bold text-slate-500 bg-slate-100 px-3 py-2 rounded-xl border border-slate-200 w-full sm:w-auto text-center">
            Total Submissions Logged: <span class="text-amber-600 font-black"><?php echo count($allFeedback); ?></span>
        </div>
    </div>

<div class="grid grid-cols-1 md:grid-cols-2 gap-4 sm:gap-6 mb-6">
        
        
        <div class="bg-white p-4 sm:p-5 rounded-2xl border border-slate-200 shadow-sm">
            <h3 class="text-[11px] font-black text-slate-400 uppercase tracking-wider mb-4 flex items-center gap-1.5">
                <i class="bi bi-pie-chart-fill text-slate-500"></i> Q1: Entry Selection Structure Opinion
            </h3>
            <div class="space-y-3.5">
                <div>
                    <div class="flex justify-between text-xs font-bold text-slate-700 mb-1">
                        <span class="truncate pr-2">Lucky Draw is fair</span>
                        <span class="shrink-0"><?php echo $ldYes; ?> votes</span>
                    </div>
                    <div class="w-full bg-slate-100 h-2 rounded-full overflow-hidden">
                        <div class="bg-emerald-500 h-full rounded-full" style="width: <?php echo count($allFeedback) > 0 ? ($ldYes / count($allFeedback)) * 100 : 0; ?>%"></div>
                    </div>
                </div>
                <div>
                    <div class="flex justify-between text-xs font-bold text-slate-700 mb-1">
                        <span class="truncate pr-2">First-Come, First-Served</span>
                        <span class="shrink-0"><?php echo $ldNo; ?> votes</span>
                    </div>
                    <div class="w-full bg-slate-100 h-2 rounded-full overflow-hidden">
                        <div class="bg-amber-500 h-full rounded-full" style="width: <?php echo count($allFeedback) > 0 ? ($ldNo / count($allFeedback)) * 100 : 0; ?>%"></div>
                    </div>
                </div>
                <div>
                    <div class="flex justify-between text-xs font-bold text-slate-700 mb-1">
                        <span class="truncate pr-2">Local Qualifier Matches</span>
                        <span class="shrink-0"><?php echo $ldQual; ?> votes</span>
                    </div>
                    <div class="w-full bg-slate-100 h-2 rounded-full overflow-hidden">
                        <div class="bg-blue-500 h-full rounded-full" style="width: <?php echo count($allFeedback) > 0 ? ($ldQual / count($allFeedback)) * 100 : 0; ?>%"></div>
                    </div>
                </div>
            </div>
        </div>

<div class="bg-white p-4 sm:p-5 rounded-2xl border border-slate-200 shadow-sm">
            <h3 class="text-[11px] font-black text-slate-400 uppercase tracking-wider mb-4 flex items-center gap-1.5">
                <i class="bi bi-bar-chart-steps text-slate-500"></i> Q2: Calendar Management Preference
            </h3>
            <div class="space-y-3.5">
                <div>
                    <div class="flex justify-between text-xs font-bold text-slate-700 mb-1">
                        <span class="truncate pr-2">Strictly Sundays Only</span>
                        <span class="shrink-0"><?php echo $sunStrict; ?> votes</span>
                    </div>
                    <div class="w-full bg-slate-100 h-2 rounded-full overflow-hidden">
                        <div class="bg-indigo-500 h-full rounded-full" style="width: <?php echo count($allFeedback) > 0 ? ($sunStrict / count($allFeedback)) * 100 : 0; ?>%"></div>
                    </div>
                </div>
                <div>
                    <div class="flex justify-between text-xs font-bold text-slate-700 mb-1">
                        <span class="truncate pr-2">Open to Saturdays</span>
                        <span class="shrink-0"><?php echo $satOpen; ?> votes</span>
                    </div>
                    <div class="w-full bg-slate-100 h-2 rounded-full overflow-hidden">
                        <div class="bg-purple-500 h-full rounded-full" style="width: <?php echo count($allFeedback) > 0 ? ($satOpen / count($allFeedback)) * 100 : 0; ?>%"></div>
                    </div>
                </div>
                <div>
                    <div class="flex justify-between text-xs font-bold text-slate-700 mb-1">
                        <span class="truncate pr-2">Continuous Multi-Day</span>
                        <span class="shrink-0"><?php echo $multiDay; ?> votes</span>
                    </div>
                    <div class="w-full bg-slate-100 h-2 rounded-full overflow-hidden">
                        <div class="bg-rose-500 h-full rounded-full" style="width: <?php echo count($allFeedback) > 0 ? ($multiDay / count($allFeedback)) * 100 : 0; ?>%"></div>
                    </div>
                </div>
            </div>
        </div>

</div>

<div class="bg-white rounded-2xl border border-slate-200 shadow-sm overflow-hidden w-full">
        <div class="px-4 sm:px-6 py-4 border-b border-slate-100 bg-slate-50/50">
            <h2 class="text-xs font-black text-slate-500 uppercase tracking-wider">All Captain Responses Registry</h2>
        </div>
        
        
        <div class="w-full overflow-x-auto scrolling-touch">
            <table class="w-full text-left border-collapse min-w-[700px] table-fixed">
                <thead>
                    <tr class="border-b border-slate-200 bg-slate-100 text-[10px] font-black uppercase tracking-wider text-slate-500">
                        <th class="py-3.5 px-4 w-[25%]">Team / Captain</th>
                        <th class="py-3.5 px-4 w-[22%]">Q1: Entry Preference</th>
                        <th class="py-3.5 px-4 w-[22%]">Q2: Date Availability</th>
                        <th class="py-3.5 px-4 w-[31%]">System Recommendations</th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-slate-100 text-xs font-medium text-slate-700">
                    <?php if (!empty($allFeedback)): ?>
                        <?php foreach ($allFeedback as $row): ?>
                            <tr class="hover:bg-slate-50/80 transition-colors">
                                <td class="py-4 px-4 break-words overflow-hidden">
                                    <span class="block font-black text-slate-900 text-xs sm:text-sm leading-tight"><?php echo htmlspecialchars($row['team_name']); ?></span>
                                    <span class="block text-slate-400 font-semibold text-[10px] sm:text-[11px] mt-1 truncate"><i class="bi bi-person"></i> <?php echo htmlspecialchars($row['captain_name']); ?></span>
                                    <span class="block text-slate-400 font-semibold text-[10px] sm:text-[11px] mt-0.5 truncate"><i class="bi bi-telephone"></i> <?php echo htmlspecialchars($row['phone_number']); ?></span>
                                </td>
                                <td class="py-4 px-4 break-words overflow-hidden">
                                    <span class="inline-block px-2 py-1 rounded bg-slate-100 text-slate-800 text-[10px] sm:text-[11px] font-bold leading-normal">
                                        <?php echo htmlspecialchars($row['lucky_draw_opinion']); ?>
                                    </span>
                                </td>
                                <td class="py-4 px-4 break-words overflow-hidden">
                                    <span class="inline-block px-2 py-1 rounded bg-slate-100 text-slate-700 text-[10px] sm:text-[11px] font-bold leading-normal">
                                        <?php echo htmlspecialchars($row['sunday_only_opinion']); ?>
                                    </span>
                                </td>
                                <td class="py-4 px-4 break-words overflow-hidden">
                                    <?php if (!empty($row['additional_comments'])): ?>
                                        <div class="text-slate-600 bg-slate-50 p-2 rounded-lg border border-slate-200/60 leading-relaxed font-semibold italic text-[11px] whitespace-normal break-words max-h-32 overflow-y-auto">
                                            "<?php echo htmlspecialchars($row['additional_comments']); ?>"
                                        </div>
                                    <?php else: ?>
                                        <span class="text-slate-300 italic font-normal text-[11px]">No custom text provided</span>
                                    <?php endif; ?>
                                </td>
                            </tr>
                        <?php endforeach; ?>
                    <?php else: ?>
                        <tr>
                            <td colspan="4" class="py-12 text-center text-slate-400 font-bold italic">
                                No feedback responses found in database tables.
                            </td>
                        </tr>
                    <?php endif; ?>
                </tbody>
            </table>
        </div>
    </div>
</main>

<?php include('footer.php'); ?>

Batal

⬅ Naik ke public_html 43 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁.well-known	dir	—	2026-06-16 16:17	📂 Buka
📁Tournament	dir	—	2026-05-25 22:24	📂 Buka
📁cgi-bin	dir	—	2026-06-16 16:16	📂 Buka
📁finance	dir	—	2026-07-03 23:30	📂 Buka
📁images	dir	—	2026-06-16 17:08	📂 Buka
📁shop	dir	—	2026-07-18 08:13	📂 Buka
📁uploads	dir	—	2026-06-25 16:43	📂 Buka
📁vendor	dir	—	2026-06-05 02:15	📂 Buka
🐘admin_dashboard.php	php	9.9 KB	2026-06-29 12:36	✏️ Edit 👁️ View
🐘auth_footer.php	php	2.8 KB	2026-07-01 16:40	✏️ Edit 👁️ View
🐘auth_header.php	php	3.6 KB	2026-07-01 16:40	✏️ Edit 👁️ View
📋composer.json	json	63 B	2026-06-05 02:15	✏️ Edit 👁️ View
📄composer.lock	lock	5.1 KB	2026-06-05 02:15	✏️ Edit 👁️ View
🐘config.php	php	175 B	2026-05-25 22:27	✏️ Edit 👁️ View
🐘dashboard.php	php	6.6 KB	2026-06-01 23:57	✏️ Edit 👁️ View
📄error_log	file	9.1 KB	2026-07-04 12:40	✏️ Edit 👁️ View
🐘feedback.php	php	15 KB	2026-07-01 16:39	✏️ Edit 👁️ View
🐘feedback_view.php	php	11.8 KB	2026-07-01 16:55	✏️ Edit 👁️ View
🐘footer.php	php	1.7 KB	2026-06-29 12:50	✏️ Edit 👁️ View
🐘get_players.php	php	1 KB	2026-07-03 23:15	✏️ Edit 👁️ View
🐘header.php	php	12.9 KB	2026-07-04 13:03	✏️ Edit 👁️ View
🐘index.php	php	35.9 KB	2026-06-16 16:49	✏️ Edit 👁️ View
🗜️kalam_trophy.zip	zip	2.4 MB	2026-06-16 16:18	✏️ Edit 👁️ View
🐘login.php	php	4.8 KB	2026-06-29 12:38	✏️ Edit 👁️ View
🐘logout.php	php	633 B	2026-05-25 22:40	✏️ Edit 👁️ View
🐘manage_players.php	php	21.8 KB	2026-07-24 09:27	✏️ Edit 👁️ View
🐘player_api.php	php	5.1 KB	2026-07-03 23:01	✏️ Edit 👁️ View
🐘player_list.php	php	11.5 KB	2026-07-03 23:13	✏️ Edit 👁️ View
🐘players_manage.php	php	22.1 KB	2026-07-24 08:46	✏️ Edit 👁️ View
🐘process_login.php	php	2.9 KB	2026-06-29 12:37	✏️ Edit 👁️ View
🐘process_player.php	php	7 KB	2026-07-24 09:21	✏️ Edit 👁️ View
🐘process_register.php	php	10.6 KB	2026-06-16 16:54	✏️ Edit 👁️ View
🐘process_umpire.php	php	5 KB	2026-06-29 12:36	✏️ Edit 👁️ View
🐘qualify_teams.php	php	14.2 KB	2026-07-24 09:59	✏️ Edit 👁️ View
🐘register.php	php	13.4 KB	2026-06-16 16:30	✏️ Edit 👁️ View
🐘registered_teams.php	php	10.5 KB	2026-06-29 16:51	✏️ Edit 👁️ View
🐘schedule_engine.php	php	4.1 KB	2026-07-24 10:00	✏️ Edit 👁️ View
🐘scheduler_engine.php	php	13.2 KB	2026-07-19 11:29	✏️ Edit 👁️ View
🐘team_directory.php	php	5.8 KB	2026-07-03 23:21	✏️ Edit 👁️ View
🐘team_process.php	php	3.6 KB	2026-06-29 12:36	✏️ Edit 👁️ View
🐘teams_list.php	php	6.3 KB	2026-07-04 12:59	✏️ Edit 👁️ View
🐘teams_manage.php	php	19 KB	2026-07-16 12:09	✏️ Edit 👁️ View
🐘umpires.php	php	17.1 KB	2026-06-25 16:37	✏️ Edit 👁️ View