prepare("INSERT INTO positions (name, level) VALUES (:name, :level)"); $stmt->execute([':name' => $name, ':level' => $level !== '' ? $level : null]); header('Location: positions.php?success=1'); exit; } } $positions = $pdo->query(" SELECT p.*, COUNT(e.id) AS total_employee FROM positions p LEFT JOIN employees e ON e.position_id = p.id GROUP BY p.id ORDER BY p.name ASC ")->fetchAll(); render_header('Data Jabatan', 'positions'); ?>
Master data jabatan dan level dalam organisasi.
| Jabatan | Level | Jumlah Pegawai |
|---|---|---|
| = e($pos['name']) ?> | = e($pos['level'] ?? '-') ?> | = e((string)$pos['total_employee']) ?> |