STATISTIK PEGAWAI BERDASARKAN DIKLAT STRUKTURAL
DIKLAT STRUKTURAL |
ESELON |
JML GOL. |
JML GOL. KOSONG |
JUMLAH PER-GOLONGAN |
| I.A |
I.B |
II.A |
II.B |
III.A |
III.B |
IV.A |
IV.B |
V.A |
V.B |
- |
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('a.iddikstru','a.dikstru',
\DB::raw("SUM(IF(b.idesljbt='11',1,0)) AS '_e11'"),
\DB::raw("SUM(IF(b.idesljbt='12',1,0)) AS '_e12'"),
\DB::raw("SUM(IF(b.idesljbt='21',1,0)) AS '_e21'"),
\DB::raw("SUM(IF(b.idesljbt='22',1,0)) AS '_e22'"),
\DB::raw("SUM(IF(b.idesljbt='31',1,0)) AS '_e31'"),
\DB::raw("SUM(IF(b.idesljbt='32',1,0)) AS '_e32'"),
\DB::raw("SUM(IF(b.idesljbt='41',1,0)) AS '_e41'"),
\DB::raw("SUM(IF(b.idesljbt='42',1,0)) AS '_e42'"),
\DB::raw("SUM(IF(b.idesljbt='51',1,0)) AS '_e51'"),
\DB::raw("SUM(IF(b.idesljbt='52',1,0)) AS '_e52'"),
\DB::raw("SUM(IF(b.idesljbt='60',1,IF(b.idesljbt='',1,0))) AS '_e60'"),
\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.iddikstru', '=', 'b.iddikstru')
->leftjoin('a_esl as c', 'b.idesljbt', '=', 'c.idesl')
->whereRaw($where)
->orderBy('a.iddikstru', 'asc')
->groupBy('a.iddikstru')
->get();
$n = 0;
?>
0): ?>
_e11;
$e12[] = $item->_e12;
$e21[] = $item->_e21;
$e22[] = $item->_e22;
$e31[] = $item->_e31;
$e32[] = $item->_e32;
$e41[] = $item->_e41;
$e42[] = $item->_e42;
$e51[] = $item->_e51;
$e52[] = $item->_e52;
$e60[] = $item->_e60;
$gol[] = $item->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;
?>
dikstru; ?> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Data tidak ditemukan. |
0): ?>
| Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|