select('tb_01.*','a_golruang.golru','a_golruang.pangkat','a_skpd.path','a_esl.esl','a_tkpendid.tkpendid','a_jenjurusan.jenjurusan','a_jenjab.jenjab','a_dikstru.dikstru', \DB::raw('DATE_ADD(tb_01.tmtkgb, INTERVAL 2 YEAR) AS tmtkgbnext'), \DB::raw('DATE_ADD(tb_01.tglhr, INTERVAL IF(tb_01.idjabfung IN (2300411, 2200412, 4500401, 4300403, 3300407, 4400402, 4200404, 3400406, 3100409, 3200408, 2400410, 4100405, 2100413, 4300503, 3400506, 4100505, 4200503, 4400501, 3300506, 3100508, 3200508, 4500501, 4200803, 4400801, 4300803, 4500801, 3300806, 3400806, 3100808, 4100803, 3200808, 4207013, 4307013, 4407014, 4107013, 3407012, 4507014, 3107011, 3207011, 3307012, 4306101, 3306104, 2306106, 3406104, 2206106, 3106105, 4106101, 4206101, 3306102, 3106103, 3206105, 2406106, 3406102, 3206103, 3206006, 3106006, 4106004, 3406005, 3306005, 4206004, 4406003, 4506003, 4306004, 4306003, 3306004, 4506002, 4406002, 3406004, 3106005, 3206005, 4106003, 4206003, 4100853, 3400852, 3300852, 4300853, 4200853, 3200851, 4500854, 4400854, 20101007000, 20313007000,20304007000,20333007000,20101006000,20101005000,20101007000,20101008000,20102007000,20310007000,20305007000,20103007000,20401003000),60,IF(tb_01.idesljbt IN(21,22),60,IF(tb_01.idjabfung IN (20210008000,20208008000,20207008000,20301007000,20211007000,20203007000,20202007000,20308007000,20105007000,20109007000,20102008000,20208007000,20104007000,20309007000,20206007000,20207007000,20326007000),65,58))) YEAR) AS pensiunnext'), \DB::raw('CONCAT(tb_01.gdp,IF(LENGTH(tb_01.gdp)>0," ",""),tb_01.nama,IF(LENGTH(tb_01.gdb)>0,", ",""),tb_01.gdb) as namalengkap'),'a_jenkel.jenkel','a_agama.agama', \DB::raw('IF(tb_01.idjenjab>4,a_skpd.jab,IF(tb_01.idjenjab=2,a_jabfung.jabfung,IF(tb_01.idjenjab=3,a_jabfungum.jabfungum,IF(tb_01.idjenjab=4,a_jabnonjob.jabnonjob,"-")))) as jabatan'), \DB::raw(" CONCAT( IF((LEFT(tb_01.idgolrupkt,1) != LEFT(idgolrucpn,1)), (SUBSTR(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(IF(tb_01.tmtcpn='0000-00-00',tb_01.tmtpns,tb_01.tmtcpn))), '%Y%m')+0,1, (LENGTH(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(IF(tb_01.tmtcpn='0000-00-00',tb_01.tmtpns,tb_01.tmtcpn))), '%Y%m')+0)-2)) - (IF((LEFT(tb_01.idgolrupkt,1) >= 3 AND LEFT(idgolrucpn,1) = 1), 11 - tb_01.mkthncpn, IF((LEFT(tb_01.idgolrupkt,1) >= 3 AND LEFT(idgolrucpn,1) = 2), 5 - tb_01.mkthncpn, IF((LEFT(tb_01.idgolrupkt,1) = 2 AND LEFT(idgolrucpn,1) = 1), 6 - tb_01.mkthncpn, 0 )))) ), (SUBSTR(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(IF(tb_01.tmtcpn='0000-00-00',tb_01.tmtpns,tb_01.tmtcpn))), '%Y%m')+0,1, (LENGTH(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(IF(tb_01.tmtcpn='0000-00-00',tb_01.tmtpns,tb_01.tmtcpn))), '%Y%m')+0)-2)) + tb_01.mkthncpn ) ), RIGHT(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(IF(tb_01.tmtcpn='0000-00-00',tb_01.tmtpns,tb_01.tmtcpn))), '%Y%m')+0, 2)) AS mkskr "), \DB::raw("DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(tb_01.tglhr)), '%Y%m')+0 AS usia"), \DB::raw("a_golruangcpn.golru as golrucpn,a_golruangcpn.pangkat as pangkatcpn, a_golruangpns.golru as golrupns,a_golruangpns.pangkat as pangkatpns") ) ->join('a_skpd', 'tb_01.idskpd', '=', 'a_skpd.idskpd') ->leftjoin('a_jenjab', 'tb_01.idjenjab', '=', 'a_jenjab.idjenjab') ->leftjoin('a_esl', 'tb_01.idesljbt', '=', 'a_esl.idesl') ->leftjoin('a_tkpendid', 'tb_01.idtkpendid', '=', 'a_tkpendid.idtkpendid') ->leftjoin('a_jenjurusan', 'tb_01.idjenjurusan', '=', 'a_jenjurusan.idjenjurusan') ->leftjoin('a_golruang', 'tb_01.idgolrupkt', '=', 'a_golruang.idgolru') ->leftjoin('a_agama', 'tb_01.idagama', '=', 'a_agama.idagama') ->leftjoin('a_jenkel', 'tb_01.idjenkel', '=', 'a_jenkel.idjenkel') ->leftjoin('a_jabfung', 'tb_01.idjabfung', '=', 'a_jabfung.idjabfung') ->leftjoin('a_jabfungum', 'tb_01.idjabfungum', '=', 'a_jabfungum.idjabfungum') ->leftjoin('a_jabnonjob', 'tb_01.idjabnonjob', '=', 'a_jabnonjob.idjabnonjob') ->leftjoin('a_dikstru', 'tb_01.iddikstru', '=', 'a_dikstru.iddikstru') ->leftjoin('a_golruang as a_golruangcpn', 'tb_01.idgolrucpn', '=', 'a_golruangcpn.idgolru') ->leftjoin('a_golruang as a_golruangpns', 'tb_01.idgolrupns', '=', 'a_golruangpns.idgolru') ->whereRaw($where) ->havingRaw($having) ->orderBy(\DB::raw('tb_01.idgolrupkt, tb_01.tmtpkt, tb_01.nama')) ->get(); ?>

DAFTAR NOMINATIF KENAIKAN GAJI BERKALA


Nomor:
Tanggal:

Isian Khusus PPPK
Awal Perjanjian Kerja:
Akhir Perjanjian Kerja:
tmtkgbnext)); $date2 = date(strtotime($item->pensiunnext)); $difference = $date2 - $date1; $months = floor($difference / 86400 / 30 ); if($months > 0){ $n++; if($item->tmtpkt > $item->tmtkgb){ $thmker = $item->mkthnpkt; }else{ $thmker = $item->mkgolthnkgb; } //===faizal=== $thmker = $item->mkgolthnkgb; if (strlen($thmker)==1) $thmker="0".$thmker; $thmker2 = intval($thmker)+2; if (strlen($thmker2)==1) $thmker2="0".$thmker2; $style = (($item->nip=='')?' style="background-color:#f3f99a"':''); if(getgaji($item->idgolrupkt,$thmker2) == getgaji($item->idgolrupkt,$thmker)){ $style = 'style="background-color:#f3f99a;"'; } ?> >
NO
NAMA
TEMPAT, TGL LAHIR
NIP
KARPEG
JABATAN
UNIT KERJA
TMT
ESELON
TMT
PANGKAT / GOL. CPNS
TMT
MASA KERJA CPNS
PANGKAT / GOL. PNS
TMT
KENAIKAN PANGKAT
(GOL. SEKARANG)
TMT
MASA KERJA GOLONGAN
KGB TERKAHIR
NO. SK KGB
TANGGAL
TMT
MASA KERJA
GAJI
KGB BARU
TMT
MASA KERJA
GAJI
AKSI
.
namalengkap; ?>
tmlhr; ?>, tglhr!='0000-00-00')?date('d-m-Y', strtotime($item->tglhr)):''; ?>
nip); ?>
nokarpeg; ?>
jabatan; ?>
Pada
path; ?>
TMT : tmtjbt!='0000-00-00')?date('d-m-Y', strtotime($item->tmtjbt)):''; ?>
esl; ?>
tmtesljbt!='0000-00-00')?date('d-m-Y', strtotime($item->tmtesljbt)):''; ?>
golrucpn." - ".$item->pangkatcpn; ?>
tmtcpn!='0000-00-00')?date('d-m-Y', strtotime($item->tmtcpn)):''; ?>
mkthncpn." Tahun ".$item->mkblncpn." Bulan"; ?>
golrupns." - ".$item->pangkatpns; ?>
tmtpns!='0000-00-00')?date('d-m-Y', strtotime($item->tmtpns)):''; ?>
golru." - ".$item->pangkat; ?>
tmtpkt!='0000-00-00')?date('d-m-Y', strtotime($item->tmtpkt)):''; ?>
mkthnpkt." Tahun ".$item->mkblnpkt." Bulan"; ?>
noskkgb=='')?' ':$item->noskkgb; ?>
tmtkgb!='0000-00-00')?date('d-m-Y', strtotime($item->tmtkgb)):''; ?>
mkgolthnkgb." Tahun ".$item->mkgolblnkgb." Bulan"; ?>
Rp. idgolrupkt,$thmker)); ?>
 
tmtkgbnext!='0000-00-00')?date('d-m-Y', strtotime($item->tmtkgbnext)):''; ?>
mkgolblnkgb." Bulan"; ?>
Rp. idgolrupkt,$thmker2)); ?>
connect_error) { die("Connection failed: " . $conn_simpeg->connect_error); }else{ //print "succes"; } $sql_cek_usulan="select * from u_kgb where nip='".$item->nip."' and tmtkgb='".$item->tmtkgbnext."' and sts_usul='0'"; $result=mysqli_query($conn_simpeg,$sql_cek_usulan); $jml_data=mysqli_num_rows($result); if ($item->idgolrupkt<41){ print ""; }else if ($item->idgolrupkt>34){ if (session('role_id')==2){ if ($jml_data>0){ print ""; print "

Diusulkan

"; }else{ print ""; } }else{ if ($jml_data>0){ print "

Diusulkan

"; }else{ $user_id=session('user_id'); $role_id=session('role_id'); $param=$item->nip.";".$user_id.";".$role_id; print ""; } } } ?>