Untitled

$izin = $this->db->table('tbl_izin')
            ->select('id_karyawan, status_izin, COUNT(DISTINCT tgl_izin) AS durasi_hari')
            ->where('id_karyawan', session()->get('id_karyawan'))
            ->where('status_izin', 1)
            ->groupBy('status_izin')
            ->get()->getResultArray();
            
        $sakit = $this->db->table('tbl_izin')
            ->select('id_karyawan, status_izin, COUNT(DISTINCT tgl_izin) AS durasi_hari')
            ->where('id_karyawan', session()->get('id_karyawan'))
            ->where('status_izin', 2)
            ->groupBy('id_karyawan, status_izin')
            ->get()->getResultArray();
            
// dd($sakit);
        return [
            'izin' => count($izin),
            'sakit' => count($sakit),
        ];