Check_Auth(); if ($_SESSION['Access_Level'] < 1) { header('Location: Voting_Screen.php'); exit; } $db = db(); // Filters $search = $_GET['search'] ?? ''; $filterTrack = $_GET['track'] ?? ''; $filterGrade = $_GET['grade'] ?? ''; $filterSection = $_GET['section'] ?? ''; // Fetch Stats $totalVoters = $db->query("SELECT COUNT(*) FROM Voters")->fetchColumn(); $votedCount = $db->query("SELECT COUNT(*) FROM Voters WHERE Has_Voted = 1")->fetchColumn(); $notVotedCount = $totalVoters - $votedCount; // Fetch Breakdowns $tracks = $db->query("SELECT Track_Cluster as label, COUNT(*) as value FROM Voters GROUP BY Track_Cluster")->fetchAll(); $grades = $db->query("SELECT Grade_Level as label, COUNT(*) as value FROM Voters GROUP BY Grade_Level")->fetchAll(); $sections = $db->query("SELECT Section as label, COUNT(*) as value FROM Voters GROUP BY Section")->fetchAll(); // Build Query for List $queryStr = "SELECT * FROM Voters WHERE 1=1"; $params = []; if ($search) { $queryStr .= " AND Email LIKE ?"; $params[] = "%$search%"; } if ($filterTrack) { $queryStr .= " AND Track_Cluster = ?"; $params[] = $filterTrack; } if ($filterGrade) { $queryStr .= " AND Grade_Level = ?"; $params[] = $filterGrade; } if ($filterSection) { $queryStr .= " AND Section = ?"; $params[] = $filterSection; } $queryStr .= " ORDER BY Email ASC"; $stmt = $db->prepare($queryStr); $stmt->execute($params); $votersList = $stmt->fetchAll(); ?> Voter Management | Online School Election System

Voters List

View and manage registered voters

Total Voters
Voters Who Voted
Voters Who Haven't Voted

Total by Track

Total by Grade

Grade

Total by Section

5): ?>
+ more sections
User ID Email Track Grade Section Status
No voters found matching your criteria.
Grade Voted Pending
Showing of voters