STATISTIK PEGAWAI BERDASARKAN JENIS KELAMIN DAN GOLONGAN


select('a.idjenkel','a.jenkel', \DB::raw("COUNT(*) AS 'TOT'"), \DB::raw("SUM(if(b.idgolrupkt!='',1,0)) as 'gol'"), \DB::raw("SUM(if(b.idgolrupkt='',1,0)) as 'golempty'"), \DB::raw("SUM(IF(b.idgolrupkt='11',1,0)) AS '_11'"), \DB::raw("SUM(IF(b.idgolrupkt='12',1,0)) AS '_12'"), \DB::raw("SUM(IF(b.idgolrupkt='13',1,0)) AS '_13'"), \DB::raw("SUM(IF(b.idgolrupkt='14',1,0)) AS '_14'"), \DB::raw("SUM(IF(b.idgolrupkt='21',1,0)) AS '_21'"), \DB::raw("SUM(IF(b.idgolrupkt='22',1,0)) AS '_22'"), \DB::raw("SUM(IF(b.idgolrupkt='23',1,0)) AS '_23'"), \DB::raw("SUM(IF(b.idgolrupkt='24',1,0)) AS '_24'"), \DB::raw("SUM(IF(b.idgolrupkt='31',1,0)) AS '_31'"), \DB::raw("SUM(IF(b.idgolrupkt='32',1,0)) AS '_32'"), \DB::raw("SUM(IF(b.idgolrupkt='33',1,0)) AS '_33'"), \DB::raw("SUM(IF(b.idgolrupkt='34',1,0)) AS '_34'"), \DB::raw("SUM(IF(b.idgolrupkt='41',1,0)) AS '_41'"), \DB::raw("SUM(IF(b.idgolrupkt='42',1,0)) AS '_42'"), \DB::raw("SUM(IF(b.idgolrupkt='43',1,0)) AS '_43'"), \DB::raw("SUM(IF(b.idgolrupkt='44',1,0)) AS '_44'"), \DB::raw("SUM(IF(b.idgolrupkt='45',1,0)) AS '_45'") ) ->leftjoin('tb_01 as b', 'a.idjenkel', '=', 'b.idjenkel') ->whereRaw($where) ->orderBy('a.idjenkel', 'asc') ->groupBy('a.idjenkel') ->get(); $n = 0; ?> 0): ?> gol; $golempty[] = $item->golempty; $ia[] = $item->_11; $ib[] = $item->_12; $ic[] = $item->_13; $id[] = $item->_14; $iia[] = $item->_21; $iib[] = $item->_22; $iic[] = $item->_23; $iid[] = $item->_24; $iiia[] = $item->_31; $iiib[] = $item->_32; $iiic[] = $item->_33; $iiid[] = $item->_34; $iva[] = $item->_41; $ivb[] = $item->_42; $ivc[] = $item->_43; $ivd[] = $item->_44; $ive[] = $item->_45; ?>
JENIS KELAMIN
JML GOL.
JML GOL. KOSONG
JUMLAH PER-GOLONGAN
GOL I
GOL II
GOL III
GOL IV
I/a
I/b
I/c
I/d
II/a
II/b
II/c
II/d
III/a
III/b
III/c
III/d
IV/a
IV/b
IV/c
IV/d
IV/e
idjenkel=='1')?'Laki-laki':'Perempuan'; ?>
gol; ?>
golempty; ?>
_11; ?>
_12; ?>
_13; ?>
_14; ?>
_21; ?>
_22; ?>
_23; ?>
_24; ?>
_31; ?>
_32; ?>
_33; ?>
_34; ?>
_41; ?>
_42; ?>
_43; ?>
_44; ?>
_45; ?>
Data tidak ditemukan.
Total