STATISTIK PEGAWAI BERDASARKAN AGAMA
AGAMA |
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.idagama','a.agama',
\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.idagama', '=', 'b.idagama')
->whereRaw($where)
->orderBy('a.idagama', 'asc')
->groupBy('a.idagama')
->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;
?>
agama; ?> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Data tidak ditemukan. |
| Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|