Untitled

 avatar
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