STATISTIK PEGAWAI BERDASARKAN PENDIDIKAN FORMAL


select( 'a.idtkpendid','a.tkpendid', \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 'ia'"), \DB::raw("SUM(IF(b.idgolrupkt='12',1,0)) AS 'ib'"), \DB::raw("SUM(IF(b.idgolrupkt='13',1,0)) AS 'ic'"), \DB::raw("SUM(IF(b.idgolrupkt='14',1,0)) AS 'id'"), \DB::raw("SUM(IF(b.idgolrupkt='21',1,0)) AS 'iia'"), \DB::raw("SUM(IF(b.idgolrupkt='22',1,0)) AS 'iib'"), \DB::raw("SUM(IF(b.idgolrupkt='23',1,0)) AS 'iic'"), \DB::raw("SUM(IF(b.idgolrupkt='24',1,0)) AS 'iid'"), \DB::raw("SUM(IF(b.idgolrupkt='31',1,0)) AS 'iiia'"), \DB::raw("SUM(IF(b.idgolrupkt='32',1,0)) AS 'iiib'"), \DB::raw("SUM(IF(b.idgolrupkt='33',1,0)) AS 'iiic'"), \DB::raw("SUM(IF(b.idgolrupkt='34',1,0)) AS 'iiid'"), \DB::raw("SUM(IF(b.idgolrupkt='41',1,0)) AS 'iva'"), \DB::raw("SUM(IF(b.idgolrupkt='42',1,0)) AS 'ivb'"), \DB::raw("SUM(IF(b.idgolrupkt='43',1,0)) AS 'ivc'"), \DB::raw("SUM(IF(b.idgolrupkt='44',1,0)) AS 'ivd'"), \DB::raw("SUM(IF(b.idgolrupkt='45',1,0)) AS 'ive'") ) ->leftjoin('tb_01 as b', 'a.idtkpendid', '=', 'b.idtkpendid') ->whereRaw($where) ->orderBy('a.idtkpendid', 'asc') ->groupBy('a.idtkpendid') ->get(); $n = 0; ?> 0): ?> gol; $golempty[] = $item->golempty; $ia[] = $item->ia; $ib[] = $item->ib; $ic[] = $item->ic; $id[] = $item->id; $iia[] = $item->iia; $iib[] = $item->iib; $iic[] = $item->iic; $iid[] = $item->iid; $iiia[] = $item->iiia; $iiib[] = $item->iiib; $iiic[] = $item->iiic; $iiid[] = $item->iiid; $iva[] = $item->iva; $ivb[] = $item->ivb; $ivc[] = $item->ivc; $ivd[] = $item->ivd; $ive[] = $item->ive; ?> 0): ?>
PENDIDIKAN FORMAL
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
tkpendid); ?>
gol); ?>
golempty); ?>
ia); ?>
ib); ?>
ic); ?>
id); ?>
iia); ?>
iib); ?>
iic); ?>
iid); ?>
iiia); ?>
iiib); ?>
iiic); ?>
iiid); ?>
iva); ?>
ivb); ?>
ivc); ?>
ivd); ?>
ive); ?>
Data tidak ditemukan.
Total