STATISTIK PEGAWAI BERDASARKAN PENDIDIKAN FORMAL
NO |
USIA
(Tahun) |
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 |
select(
\DB::raw("DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(a.tglhr)), '%Y')+0 AS tahun"),
\DB::raw("SUM(IF(a.idgolrupkt!='',1,0)) AS 'gol'"),
\DB::raw("SUM(IF(a.idgolrupkt='',1,0)) AS 'golempty'"),
\DB::raw("SUM(IF(a.idgolrupkt='11',1,0)) AS 'ia'"),
\DB::raw("SUM(IF(a.idgolrupkt='12',1,0)) AS 'ib'"),
\DB::raw("SUM(IF(a.idgolrupkt='13',1,0)) AS 'ic'"),
\DB::raw("SUM(IF(a.idgolrupkt='14',1,0)) AS 'id'"),
\DB::raw("SUM(IF(a.idgolrupkt='21',1,0)) AS 'iia'"),
\DB::raw("SUM(IF(a.idgolrupkt='22',1,0)) AS 'iib'"),
\DB::raw("SUM(IF(a.idgolrupkt='23',1,0)) AS 'iic'"),
\DB::raw("SUM(IF(a.idgolrupkt='24',1,0)) AS 'iid'"),
\DB::raw("SUM(IF(a.idgolrupkt='31',1,0)) AS 'iiia'"),
\DB::raw("SUM(IF(a.idgolrupkt='32',1,0)) AS 'iiib'"),
\DB::raw("SUM(IF(a.idgolrupkt='33',1,0)) AS 'iiic'"),
\DB::raw("SUM(IF(a.idgolrupkt='34',1,0)) AS 'iiid'"),
\DB::raw("SUM(IF(a.idgolrupkt='41',1,0)) AS 'iva'"),
\DB::raw("SUM(IF(a.idgolrupkt='42',1,0)) AS 'ivb'"),
\DB::raw("SUM(IF(a.idgolrupkt='43',1,0)) AS 'ivc'"),
\DB::raw("SUM(IF(a.idgolrupkt='44',1,0)) AS 'ivd'"),
\DB::raw("SUM(IF(a.idgolrupkt='45',1,0)) AS 'ive'")
)
->whereRaw($where)
->groupBy('tahun')
->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;
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Data tidak ditemukan. |
|
Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|