STATISTIK PEGAWAI BERDASARKAN JENIS KELAMIN DAN GOLONGAN


select('a.idjenkel','a.jenkel', \DB::raw("COUNT(*) AS 'TOT'"), \DB::raw("SUM(IF(b.idesljbt!='',1,0)) AS eselon"), \DB::raw("SUM(IF(b.idesljbt='',1,0)) AS eselonempty"), \DB::raw("SUM(IF(b.idesljbt='11',1,0)) AS '_11'"), \DB::raw("SUM(IF(b.idesljbt='12',1,0)) AS '_12'"), \DB::raw("SUM(IF(b.idesljbt='21',1,0)) AS '_21'"), \DB::raw("SUM(IF(b.idesljbt='22',1,0)) AS '_22'"), \DB::raw("SUM(IF(b.idesljbt='31',1,0)) AS '_31'"), \DB::raw("SUM(IF(b.idesljbt='32',1,0)) AS '_32'"), \DB::raw("SUM(IF(b.idesljbt='41',1,0)) AS '_41'"), \DB::raw("SUM(IF(b.idesljbt='42',1,0)) AS '_42'"), \DB::raw("SUM(IF(b.idesljbt='51',1,0)) AS '_51'"), \DB::raw("SUM(IF(b.idesljbt='52',1,0)) AS '_52'"), \DB::raw("SUM(IF(b.idesljbt='99',1,0)) AS '_99'") ) ->leftjoin('tb_01 as b', 'a.idjenkel', '=', 'b.idjenkel') ->whereRaw($where) ->orderBy('a.idjenkel', 'asc') ->groupBy('a.idjenkel') ->get(); $n = 0; ?> 0): ?> eselon; $eselonempty[] = $item->eselonempty; $ia[] = $item->_11; $ib[] = $item->_12; $iia[] = $item->_21; $iib[] = $item->_22; $iiia[] = $item->_31; $iiib[] = $item->_32; $iva[] = $item->_41; $ivb[] = $item->_42; $va[] = $item->_51; $vb[] = $item->_52; $v0[] = $item->_99; ?>
JENIS KELAMIN
JML ESL.
JML ESL. KOSONG
JUMLAH PER-ESELON
ESL I
ESL II
ESL III
ESL IV
ESL V
-
I/a
I/b
II/a
II/b
III/a
III/b
IV/a
IV/b
V/a
V/b
idjenkel=='1')?'Laki-laki':'Perempuan'; ?>
eselon; ?>
eselonempty; ?>
_11; ?>
_12; ?>
_21; ?>
_22; ?>
_31; ?>
_32; ?>
_41; ?>
_42; ?>
_51; ?>
_52; ?>
_99; ?>
Data tidak ditemukan.
Total