0);
// Cek apakah kolom roles ada di database
$check_roles_column_query = "SHOW COLUMNS FROM users LIKE 'roles'";
$roles_column_result = mysqli_query($conn, $check_roles_column_query);
$roles_column_exists = (mysqli_num_rows($roles_column_result) > 0);
// Jika kolom roles tidak ada, buat kolom tersebut
if (!$roles_column_exists) {
$alter_query = "ALTER TABLE users ADD COLUMN roles JSON DEFAULT NULL";
if (mysqli_query($conn, $alter_query)) {
$roles_column_exists = true;
$message = '
Kolom roles berhasil ditambahkan ke database!
';
} else {
$message = '
Error membuat kolom roles: ' . mysqli_error($conn) . '
';
}
}
// Proses pembuatan kolom face_verified jika diminta
if (isset($_POST['create_face_verified_column'])) {
$alter_query = "ALTER TABLE users ADD COLUMN face_verified TINYINT(1) DEFAULT 0";
if (mysqli_query($conn, $alter_query)) {
$face_verified_column_exists = true;
$message = '
Kolom face_verified berhasil ditambahkan ke database!
';
} else {
$message = '
Error membuat kolom face_verified: ' . mysqli_error($conn) . '
';
}
}
// PROSES HAPUS SEMUA SISWA
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['hapus_semua_siswa'])) {
$confirm = isset($_POST['confirm_delete_siswa']) ? $_POST['confirm_delete_siswa'] : '';
if ($confirm !== 'HAPUS SEMUA SISWA') {
$message = '
Konfirmasi tidak valid. Ketik "HAPUS SEMUA SISWA" untuk melanjutkan.
';
} else {
mysqli_begin_transaction($conn);
try {
$deleted_count = 0;
$deleted_kelas_count = 0;
$get_siswa_query = "SELECT id FROM users WHERE role = 'siswa'";
$get_siswa_result = mysqli_query($conn, $get_siswa_query);
$siswa_ids = [];
while ($row = mysqli_fetch_assoc($get_siswa_result)) {
$siswa_ids[] = $row['id'];
}
$total_siswa = count($siswa_ids);
if (!empty($siswa_ids)) {
$ids_string = implode(',', array_map('intval', $siswa_ids));
$delete_siswa_kelas = "DELETE FROM siswa_kelas WHERE id_siswa IN ($ids_string)";
mysqli_query($conn, $delete_siswa_kelas);
$deleted_kelas_count = mysqli_affected_rows($conn);
}
$delete_users_query = "DELETE FROM users WHERE role = 'siswa'";
$delete_users_stmt = mysqli_prepare($conn, $delete_users_query);
mysqli_stmt_execute($delete_users_stmt);
$deleted_count = mysqli_stmt_affected_rows($delete_users_stmt);
mysqli_stmt_close($delete_users_stmt);
mysqli_commit($conn);
$message = '
? Berhasil menghapus SEMUA data siswa!
?? Total siswa dihapus: ' . $deleted_count . ' pengguna.
?? Total record siswa_kelas dihapus: ' . $deleted_kelas_count . ' record.
';
} else {
$check_query = "SELECT id FROM users WHERE (username = '$username' OR email = '$email') AND id != $edit_id";
$check_result = mysqli_query($conn, $check_query);
if (mysqli_num_rows($check_result) > 0) {
$message = '
Username atau email sudah digunakan!
';
} else {
if ($edit_id > 0) {
if ($roles_column_exists) {
if ($role == 'siswa') {
$update_query = "UPDATE users SET username = '$username', email = '$email',
nama_lengkap = '$nama_lengkap', role = '$role',
roles = '$roles_json', id_kelas = $id_kelas
WHERE id = $edit_id";
} else {
$update_query = "UPDATE users SET username = '$username', email = '$email',
nama_lengkap = '$nama_lengkap', role = '$role',
roles = '$roles_json', id_kelas = NULL
WHERE id = $edit_id";
}
} else {
if ($role == 'siswa') {
$update_query = "UPDATE users SET username = '$username', email = '$email',
nama_lengkap = '$nama_lengkap', role = '$role', id_kelas = $id_kelas
WHERE id = $edit_id";
} else {
$update_query = "UPDATE users SET username = '$username', email = '$email',
nama_lengkap = '$nama_lengkap', role = '$role', id_kelas = NULL
WHERE id = $edit_id";
}
}
if (mysqli_query($conn, $update_query)) {
$message = '
';
} else {
$check_user_query = "SELECT id, username, nama_lengkap FROM users WHERE id = $target_user_id";
$check_user_result = mysqli_query($conn, $check_user_query);
if (mysqli_num_rows($check_user_result) == 0) {
$message = '
User tidak ditemukan!
';
} else {
$user_data = mysqli_fetch_assoc($check_user_result);
$password_hashed = password_hash($new_password, PASSWORD_DEFAULT);
$update_password_query = "UPDATE users SET password = ? WHERE id = ?";
$update_password_stmt = mysqli_prepare($conn, $update_password_query);
mysqli_stmt_bind_param($update_password_stmt, "si", $password_hashed, $target_user_id);
if (mysqli_stmt_execute($update_password_stmt)) {
$message = '
? Password berhasil diubah!
Password untuk user ' . htmlspecialchars($user_data['username']) . '
(' . htmlspecialchars($user_data['nama_lengkap']) . ') telah diperbarui.
';
} else {
$message = '
Error: ' . mysqli_error($conn) . '
';
}
mysqli_stmt_close($update_password_stmt);
}
}
}
// Ambil data user untuk edit
$edit_user = null;
if ($action == 'edit' && $user_id > 0) {
$query = "SELECT *, kelas.nama_kelas as nama_kelas
FROM users
LEFT JOIN kelas ON users.id_kelas = kelas.id
WHERE users.id = $user_id";
$result = mysqli_query($conn, $query);
$edit_user = mysqli_fetch_assoc($result);
// PERBAIKAN: Validasi apakah user ditemukan
if (!$edit_user) {
$message = '
User dengan ID ' . $user_id . ' tidak ditemukan!
';
$action = ''; // batalkan mode edit
} else {
if ($roles_column_exists) {
$edit_user['roles_array'] = getRolesArray($edit_user);
} else {
$edit_user['roles_array'] = [$edit_user['role']];
}
if (!$face_verified_column_exists) {
$edit_user['face_verified'] = 0;
}
}
}
// Ambil data kelas untuk dropdown
$kelas_query = "SELECT * FROM kelas ORDER BY tingkat, nama_kelas";
$kelas_result = mysqli_query($conn, $kelas_query);
$kelas_list = mysqli_fetch_all($kelas_result, MYSQLI_ASSOC);
// Ambil parameter filter
$filter_kelas = isset($_GET['filter_kelas']) ? $_GET['filter_kelas'] : '';
$filter_role = isset($_GET['filter_role']) ? $_GET['filter_role'] : '';
// Query untuk mengambil data user dengan filter
$query = "SELECT users.*, kelas.nama_kelas as nama_kelas, kelas.tingkat
FROM users
LEFT JOIN kelas ON users.id_kelas = kelas.id
WHERE 1=1";
if (!empty($filter_kelas) && $filter_kelas != '') {
$query .= " AND users.id_kelas = " . intval($filter_kelas);
}
if (!empty($filter_role) && $filter_role != '') {
$query .= " AND users.role = '$filter_role'";
}
$query .= " ORDER BY role, nama_lengkap";
$result = mysqli_query($conn, $query);
if (!$result) {
die('Query error: ' . mysqli_error($conn));
}
$users = mysqli_fetch_all($result, MYSQLI_ASSOC);
foreach ($users as &$user) {
if ($roles_column_exists) {
$user['roles_array'] = getRolesArray($user);
} else {
$user['roles_array'] = [$user['role']];
}
if (!$face_verified_column_exists) {
$user['face_verified'] = 0;
}
}
unset($user);
$admin_count = 0;
$guru_count = 0;
$siswa_count = 0;
$face_verified_count = 0;
foreach ($users as $user) {
if (in_array('admin', $user['roles_array'])) $admin_count++;
if (in_array('guru', $user['roles_array'])) $guru_count++;
if (in_array('siswa', $user['roles_array'])) $siswa_count++;
if ($user['face_verified']) {
$face_verified_count++;
}
}
$siswa_list_query = "
SELECT u.id, u.username, u.email, u.nama_lengkap,
k.tingkat, k.nama_kelas,
sk.tahun_ajaran, sk.semester
FROM users u
LEFT JOIN siswa_kelas sk ON u.id = sk.id_siswa
LEFT JOIN kelas k ON sk.id_kelas = k.id
WHERE u.role = 'siswa'
ORDER BY u.nama_lengkap
";
$siswa_list_result = mysqli_query($conn, $siswa_list_query);
$total_siswa = mysqli_num_rows($siswa_list_result);
?>
Kelola Pengguna - E-Learning Sekolah