Query getListPegawaiDinasPendidikanAtasan
SELECT ri.id AS instansi_id, ri.nama AS instansi_nama, u.id AS unor_id, u.unit AS unor_unit, p.jabatan_siasn, p.jabatan, p.nip, p.nama AS pegawai_nama, p.id AS pegawai_id FROM pegawai p LEFT JOIN unor u ON u.id = p.unor_id LEFT JOIN ref_instansi ri ON ri.id = p.ref_instansi_id WHERE p.jenis_jabatan = '1' AND u.unit LIKE 'DINAS PENDIDIKAN%' AND u.deleted_at IS NULL AND p.disabled_at IS NULL;
Leave a Comment