prepare("SELECT COUNT(*) FROM undi WHERE id_pengguna = ? AND jawatan_calon = ?"); $stmt->execute([$_SESSION['id_pengguna'], $pos]); $user_votes[$pos] = $stmt->fetchColumn() > 0; } // Dapatkan calon mengikut jawatan $positions = ['pengerusi', 'setiausaha', 'bendahari', 'jawatankuasa']; $candidates_by_position = []; foreach ($positions as $position) { $stmt = $pdo->prepare("SELECT * FROM calon WHERE jawatan_calon = ? ORDER BY nama_calon"); $stmt->execute([$position]); $candidates_by_position[$position] = $stmt->fetchAll(); } // Semak julat tarikh pengundian $current_date = date('Y-m-d'); $stmt = $pdo->prepare("SELECT nilai_tetapan FROM tetapan WHERE kunci_tetapan = 'tarikh_pengundian'"); $stmt->execute(); $date_json = $stmt->fetchColumn(); $dates = json_decode($date_json, true); $start_date = $dates['mula']; $end_date = $dates['tamat']; $date_valid = ($current_date >= $start_date && $current_date <= $end_date); $can_vote = $date_valid; if ($_POST && isset($_POST['vote'])) { $candidate_id = (int)$_POST['candidate_id']; $position = $_POST['position']; if (!$can_vote) { $error = "Pengundian hanya boleh dibuat dari $start_date hingga $end_date!"; } elseif (!$user_votes[$position]) { $pdo->beginTransaction(); $stmt = $pdo->prepare("INSERT INTO undi (id_pengguna, id_calon, jawatan_calon) VALUES (?, ?, ?)"); $stmt->execute([$_SESSION['id_pengguna'], $candidate_id, $position]); $stmt = $pdo->prepare("UPDATE calon SET undi_calon = undi_calon + 1 WHERE id_calon = ?"); $stmt->execute([$candidate_id]); $pdo->commit(); $success = "Undi untuk jawatan $position berjaya direkodkan!"; $user_votes[$position] = true; } } if ($_POST && isset($_POST['reset_vote'])) { $position = $_POST['position']; if ($user_votes[$position]) { $pdo->beginTransaction(); $stmt = $pdo->prepare("SELECT id_calon FROM undi WHERE id_pengguna = ? AND jawatan_calon = ?"); $stmt->execute([$_SESSION['id_pengguna'], $position]); $vote = $stmt->fetch(); if ($vote) { $stmt = $pdo->prepare("DELETE FROM undi WHERE id_pengguna = ? AND jawatan_calon = ?"); $stmt->execute([$_SESSION['id_pengguna'], $position]); $stmt = $pdo->prepare("UPDATE calon SET undi_calon = undi_calon - 1 WHERE id_calon = ?"); $stmt->execute([$vote['id_calon']]); $pdo->commit(); $success = "Undi untuk jawatan $position berjaya di set semula!"; $user_votes[$position] = false; } } } // Dapatkan calon yang telah diundi oleh pengguna $user_voted_candidates = []; foreach ($positions as $position) { if ($user_votes[$position]) { $stmt = $pdo->prepare("SELECT c.nama_calon FROM undi u JOIN calon c ON u.id_calon = c.id_calon WHERE u.id_pengguna = ? AND u.jawatan_calon = ?"); $stmt->execute([$_SESSION['id_pengguna'], $position]); $user_voted_candidates[$position] = $stmt->fetchColumn(); } } ?> Sistem Pengundian Jawatankuasa Kelab Badminton

🏸 SISTEM PENGUNDIAN JAWATANKUASA KELAB BADMINTON

Mengundi pengerusi, setiausaha, bendahari dan jawatankuasa lain yang utama dalam Kelab Badminton SMJK Chung Ling

Status:
Tempoh: hingga
Lihat Keputusan Langsung Urus Profil
Pengerusi
Setiausaha
Bendahari
Jawatankuasa

Terima kasih kerana mengundi!

$vote_name): ?>

:

'Pengerusi', 'setiausaha' => 'Setiausaha', 'bendahari' => 'Bendahari', 'jawatankuasa' => 'Jawatankuasa Lain' ]; foreach ($positions as $position): ?>

<?php echo htmlspecialchars($candidate['nama_calon']); ?>

Ingin tukar undi untuk ?