STATISTIK PEGAWAI BERDASARKAN UNIT KERJA DAN PENDIDIKAN FORMAL

select( 'a.idskpd','a.skpd', \DB::raw("COUNT(*) AS 'TOT'"), \DB::raw("SUM(if(b.idtkpendid='',1,0)) AS 'empty'"), \DB::raw("SUM(IF(b.idtkpendid='05',1,0)) AS 'sd'"), \DB::raw("SUM(IF(b.idtkpendid='10',1,0)) AS 'sp'"), \DB::raw("SUM(IF(b.idtkpendid='12',1,0)) AS 'spk'"), \DB::raw("SUM(IF(b.idtkpendid='15',1,0)) AS 'sa'"), \DB::raw("SUM(IF(b.idtkpendid='17',1,0)) AS 'sak'"), \DB::raw("SUM(IF(b.idtkpendid='18',1,0)) AS 'sag'"), \DB::raw("SUM(IF(b.idtkpendid='20',1,0)) AS 'd1'"), \DB::raw("SUM(IF(b.idtkpendid='25',1,0)) AS 'd2'"), \DB::raw("SUM(IF(b.idtkpendid='30',1,0)) AS 'd3'"), \DB::raw("SUM(IF(b.idtkpendid='35',1,0)) AS 'd4'"), \DB::raw("SUM(IF(b.idtkpendid='40',1,0)) AS 's1'"), \DB::raw("SUM(IF(b.idtkpendid='45',1,0)) AS 's2'"), \DB::raw("SUM(IF(b.idtkpendid='50',1,0)) AS 's3'") ) ->leftjoin('tb_01 as b', 'a.idskpd', '=', 'b.idskpd') ->leftjoin('a_tkpendid as c', 'b.idtkpendid', '=', 'c.idtkpendid') ->whereRaw($where) ->groupBy('a.idskpd') ->get(); $n = 0; ?> 0): ?> TOT; $empty[] = $item->empty; $sd[] = $item->sd; $sp[] = $item->sp; $spk[] = $item->spk; $sa[] = $item->sa; $sak[] = $item->sak; $sag[] = $item->sag; $d1[] = $item->d1; $d2[] = $item->d2; $d3[] = $item->d3; $d4[] = $item->d4; $s1[] = $item->s1; $s2[] = $item->s2; $s3[] = $item->s3; ?> 0): ?>

UNIT KERJA	TOTAL	KOSONG	SD	SMP	SMPK	SMA	SMAK	SMAKG	D1	D2	D3	D4	S1	S2	S3
skpd; ?>	TOT; ?>	empty; ?>	sd; ?>	sp; ?>	spk; ?>	sa; ?>	sak; ?>	sag; ?>	d1; ?>	d2; ?>	d3; ?>	d4; ?>	s1; ?>	s2; ?>	s3; ?>
Data tidak ditemukan.
Total