Untitled
unknown
plain_text
a year ago
567 B
4
Indexable
$izin_sakit = $this->db->table('tbl_izin') ->select('status_izin, COUNT(DISTINCT tgl_izin) AS durasi_hari') ->where('id_karyawan', session()->get('id_karyawan')) ->whereIn('status_izin', [1, 2]) ->groupBy('status_izin') ->get()->getResultArray(); $data = [ 'izin' => 0, 'sakit' => 0, ]; foreach ($izin_sakit as $item) { if ($item['status_izin'] == 1) { $data['izin'] = $item['durasi_hari']; } elseif ($item['status_izin'] == 2) { $data['sakit'] = $item['durasi_hari']; } } return $data;
Editor is loading...
Leave a Comment