STATISTIK PEGAWAI BERDASARKAN ESELON DAN GOLONGAN
ESELON |
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(
'a.idesl','a.esl',
\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.idesl', '=', 'b.idesljbt')
->whereRaw($where)
->orderBy('a.idesl', 'asc')
->groupBy('a.idesl')
->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;
?>
esl; ?> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Data tidak ditemukan. |
0): ?>
| Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|