prepare("INSERT INTO departments (name, code) VALUES (:name, :code)");
$stmt->execute([':name' => $name, ':code' => $code]);
header('Location: departments.php?success=1');
exit;
}
}
$departments = $pdo->query("
SELECT d.*, COUNT(e.id) AS total_employee
FROM departments d
LEFT JOIN employees e ON e.dept_id = d.id
GROUP BY d.id
ORDER BY d.name ASC
")->fetchAll();
render_header('Data Departemen', 'departments');
?>
Departemen
Struktur organisasi yang digunakan untuk penempatan pegawai.
Departemen berhasil ditambahkan.
Daftar Departemen total
Belum ada departemen. Tambahkan departemen pertama.