REKAPITULASI : JUMLAH CALON / PEGAWAI NEGERI SIPIL PADA SEKRETARIAT DAERAH, LEMBAGA TEKNIS DAERAH
DINAS DAERAH DAN KECAMATAN DI
KEADAAN :
No |
Unit Organisasi |
Pegawai |
Calon Pegawai |
Tingkat Pendidikan |
Jenis Kelamin |
Tingkat Umur (tahun) |
Jml Total |
Jml Gol I |
Golongan I |
Jml Gol II |
Golongan II |
Jml Gol III |
Golongan III |
Jml Gol IV |
Golongan IV |
JML |
Gol I |
Gol II |
Gol III |
SD |
SLTP |
SLTA |
D1 |
D2 |
D3 |
D4 |
S1 |
S2 |
S3 |
L |
P |
18-25 |
26-30 |
31-35 |
36-40 |
41-45 |
46-50 |
51-55 |
>56 |
| a |
b |
c |
d |
a |
b |
c |
d |
a |
b |
c |
d |
a |
b |
c |
d |
e |
a |
b |
a |
b |
c |
a |
b |
select('a_skpd.idskpd','a_skpd.skpd',
\DB::raw("COUNT(*) AS jml"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=11,1,0)) AS gol1a"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=12,1,0)) AS gol1b"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=13,1,0)) AS gol1c"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=14,1,0)) AS gol1d"),
\DB::raw("SUM(IF(LEFT(tb_01.idgolrupkt,1)=1, 1,0)) jmlgol1"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=21,1,0)) AS gol2a"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=22,1,0)) AS gol2b"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=23,1,0)) AS gol2c"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=24,1,0)) AS gol2d"),
\DB::raw("SUM(IF(LEFT(tb_01.idgolrupkt,1)=2, 1,0)) jmlgol2"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=31,1,0)) AS gol3a"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=32,1,0)) AS gol3b"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=33,1,0)) AS gol3c"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=34,1,0)) AS gol3d"),
\DB::raw("SUM(IF(LEFT(tb_01.idgolrupkt,1)=3, 1,0)) jmlgol3"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=41,1,0)) AS gol4a"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=42,1,0)) AS gol4b"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=43,1,0)) AS gol4c"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=44,1,0)) AS gol4d"),
\DB::raw("SUM(IF(tb_01.idstspeg=2 AND tb_01.idgolrupkt=45,1,0)) AS gol4e"),
\DB::raw("SUM(IF(LEFT(tb_01.idgolrupkt,1)=4, 1,0)) jmlgol4"),
\DB::raw("SUM(IF(tb_01.idstspeg=1 AND tb_01.idgolrupkt=11,1,0)) AS g1a"),
\DB::raw("SUM(IF(tb_01.idstspeg=1 AND tb_01.idgolrupkt=12,1,0)) AS g1b"),
\DB::raw("SUM(IF(tb_01.idstspeg=1 AND tb_01.idgolrupkt=21,1,0)) AS g2a"),
\DB::raw("SUM(IF(tb_01.idstspeg=1 AND tb_01.idgolrupkt=22,1,0)) AS g2b"),
\DB::raw("SUM(IF(tb_01.idstspeg=1 AND tb_01.idgolrupkt=23,1,0)) AS g2c"),
\DB::raw("SUM(IF(tb_01.idstspeg=1 AND tb_01.idgolrupkt=31,1,0)) AS g3a"),
\DB::raw("SUM(IF(tb_01.idstspeg=1 AND tb_01.idgolrupkt=32,1,0)) AS g3b"),
\DB::raw("SUM(IF(tb_01.idstspeg=1 AND tb_01.idgolrupkt IN (11,12,21,22,23,31,32),1,0)) AS jmlcpns"),
\DB::raw("SUM(IF(tb_01.idtkpendid='01',1,0)) AS sd"),
\DB::raw("SUM(IF(tb_01.idtkpendid='02',1,0)) AS smp"),
\DB::raw("SUM(IF(tb_01.idtkpendid='03',1,0)) AS sma"),
\DB::raw("SUM(IF(tb_01.idtkpendid='04',1,0)) AS d1"),
\DB::raw("SUM(IF(tb_01.idtkpendid='05',1,0)) AS d2"),
\DB::raw("SUM(IF(tb_01.idtkpendid='06',1,0)) AS d3"),
\DB::raw("SUM(IF(tb_01.idtkpendid='07',1,0)) AS d4"),
\DB::raw("SUM(IF(tb_01.idtkpendid=50,1,0)) AS sarnon"),
\DB::raw("SUM(IF(tb_01.idtkpendid=60,1,0)) AS sarmud"),
\DB::raw("SUM(IF(tb_01.idtkpendid='08',1,0)) AS s1"),
\DB::raw("SUM(IF(tb_01.idtkpendid='09',1,0)) AS s2"),
\DB::raw("SUM(IF(tb_01.idtkpendid='10',1,0)) AS s3"),
\DB::raw("SUM(IF(tb_01.idjenkel=1,1,0)) AS jmll"),
\DB::raw("SUM(IF(tb_01.idjenkel=2,1,0)) AS jmlp"),
\DB::raw("SUM(IF(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 >= 18 AND DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 <= 25,1,0)) AS u1825"),
\DB::raw("SUM(IF(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 >= 26 AND DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 <= 30,1,0)) AS u2630"),
\DB::raw("SUM(IF(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 >= 31 AND DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 <= 35,1,0)) AS u3135"),
\DB::raw("SUM(IF(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 >= 36 AND DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 <= 40,1,0)) AS u3640"),
\DB::raw("SUM(IF(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 >= 41 AND DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 <= 45,1,0)) AS u4145"),
\DB::raw("SUM(IF(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 >= 46 AND DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 <= 50,1,0)) AS u4650"),
\DB::raw("SUM(IF(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 >= 51 AND DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 <= 55,1,0)) AS u5155"),
\DB::raw("SUM(IF(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tglhr)), '%Y')+0 >= 56,1,0)) AS u56")
)
->leftjoin('a_skpd', DB::raw('left(tb_01.idskpd,2)'), '=', DB::raw('left(a_skpd.idskpd,2)'))
->whereRaw("a_skpd.idparent = '' and a_skpd.idskpd != 99 and tb_01.idjenkedudupeg not in(99,21)")
->orderBy('tb_01.idskpd','asc')
->groupBy(\DB::raw('LEFT(tb_01.idskpd,2)'))
->get();
$n = 0;
$jml[$n] = 0; $jmlgol1[$n] = 0; $gol1a[$n] = 0;
$gol1b[$n] = 0; $gol1c[$n] = 0; $gol1d[$n] = 0;
$jmlgol2[$n] = 0; $gol2a[$n] = 0; $gol2b[$n] = 0;
$gol2c[$n] = 0; $gol2d[$n] = 0; $jmlgol3[$n] = 0;
$gol3a[$n] = 0; $gol3b[$n] = 0; $gol3c[$n] = 0;
$gol3d[$n] = 0; $jmlgol4[$n] = 0;
$gol4a[$n] = 0; $gol4b[$n] = 0; $gol4c[$n] = 0; $gol4d[$n] = 0;
$gol4e[$n] = 0; $jmlcpns[$n] = 0; $g1a[$n] = 0;
$g1b[$n] = 0; $g2a[$n] = 0;
$g2b[$n] = 0; $g2c[$n] = 0;
$g3a[$n] = 0; $g3b[$n] = 0;
$sd[$n] = 0; $smp[$n] = 0;
$sma[$n] = 0; $d2[$n] = 0;
$d1[$n] = 0; $d4[$n] = 0;
$d3[$n] = 0; $s1[$n] = 0;
$s2[$n] = 0; $s3[$n] = 0;
$jmll[$n] = 0; $jmlp[$n] = 0;
$u1825[$n] = 0; $u2630[$n] = 0;
$u3135[$n] = 0; $u3640[$n] = 0;
$u4145[$n] = 0; $u4650[$n] = 0;
$u5155[$n] = 0; $u56[$n] = 0;
foreach ($rs as $item) {
$n++;
$jml[$n] = $item->jml; $jmlgol1[$n] = $item->jmlgol1; $gol1a[$n] = $item->gol1a;
$gol1b[$n] = $item->gol1b; $gol1c[$n] = $item->gol1c; $gol1d[$n] = $item->gol1d;
$jmlgol2[$n] = $item->jmlgol2; $gol2a[$n] = $item->gol2a; $gol2b[$n] = $item->gol2b;
$gol2c[$n] = $item->gol2c; $gol2d[$n] = $item->gol2d; $jmlgol3[$n] = $item->jmlgol3;
$gol3a[$n] = $item->gol3a; $gol3b[$n] = $item->gol3b; $gol3c[$n] = $item->gol3c;
$gol3d[$n] = $item->gol3d; $jmlgol4[$n] = $item->jmlgol4;
$gol4a[$n] = $item->gol4a; $gol4b[$n] = $item->gol4b; $gol4c[$n] = $item->gol4c; $gol4d[$n] = $item->gol4d;
$gol4e[$n] = $item->gol4e; $jmlcpns[$n] = $item->jmlcpns; $g1a[$n] = $item->g1a;
$g1b[$n] = $item->g1b; $g2a[$n] = $item->g2a;
$g2b[$n] = $item->g2b; $g2c[$n] = $item->g2c;
$g3a[$n] = $item->g3a; $g3b[$n] = $item->g3b;
$sd[$n] = $item->sd; $smp[$n] = $item->smp;
$sma[$n] = $item->sma; $d2[$n] = $item->d2;
$d1[$n] = $item->d1; $d4[$n] = $item->d4;
$d3[$n] = $item->d3; $s1[$n] = $item->s1;
$s2[$n] = $item->s2; $s3[$n] = $item->s3;
$jmll[$n] = $item->jmll; $jmlp[$n] = $item->jmlp;
$u1825[$n] = $item->u1825; $u2630[$n] = $item->u2630;
$u3135[$n] = $item->u3135; $u3640[$n] = $item->u3640;
$u4145[$n] = $item->u4145; $u4650[$n] = $item->u4650;
$u5155[$n] = $item->u5155; $u56[$n] = $item->u56;
?>
|
skpd; ?> |
jml; ?> |
jmlgol1; ?> |
gol1a; ?> |
gol1b; ?> |
gol1c; ?> |
gol1d; ?> |
jmlgol2; ?> |
gol2a; ?> |
gol2b; ?> |
gol2c; ?> |
gol2d; ?> |
jmlgol3; ?> |
gol3a; ?> |
gol3b; ?> |
gol3c; ?> |
gol3d; ?> |
jmlgol4; ?> |
gol4a; ?> |
gol4b; ?> |
gol4c; ?> |
gol4d; ?> |
gol4e; ?> |
jmlcpns; ?> |
g1a; ?> |
g1b; ?> |
g2a; ?> |
g2b; ?> |
g2c; ?> |
g3a; ?> |
g3b; ?> |
sd; ?> |
smp; ?> |
sma; ?> |
d1; ?> |
d2; ?> |
d3; ?> |
d4; ?> |
s1; ?> |
s2; ?> |
s3; ?> |
jmll; ?> |
jmlp; ?> |
u1825; ?> |
u2630; ?> |
u3135; ?> |
u3640; ?> |
u4145; ?> |
u4650; ?> |
u5155; ?> |
u56; ?> |
| |
TOTAL |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|