select('tb_01.*','a_golruang.golru','a_skpd.path','a_esl.esl','a_tkpendid.tkpendid','a_jenjurusan.jenjurusan','a_jenjab.jenjab','tb_01.jamhari_dikstru','tb_01.tgsttp_dikstru',
\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("IFNULL(a_dikstru.dikstru,'') AS dikstru")
)
->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')
->whereRaw($where)
->orderBy(\DB::raw('tb_01.idgolrupkt desc,tb_01.tmtpkt,tb_01.idjenjab,tb_01.idesljbt,tb_01.tmtesljbt,tb_01.tmtcpn,tb_01.idtkpendid desc,tb_01.thijaz,tb_01.tglhr'))
->get();
?>
DAFTAR URUT KEPANGKATAN
PNS DI
GOLONGAN RUANG : I/a SAMPAI DENGAN IV/e
KEADAAN :
TOTAL PNS : ORANG
NO URUT |
NAMA PEGAWAI
NOMOR INDUK PEGAWAI
|
PANGKAT
|
JABATAN
|
MKER
|
LAT. JABATAN
|
PENDIDIKAN
|
TEM LAHIR
TGL LAHIR
|
CAT MUT KEPEG
|
UNIT KERJA
|
|
PEG
|
PKT
|
G/R AKHIR
TMT
|
NAMA JABATAN
TMT
|
TH
|
BL
|
NAMA
TGL LULUS
|
JAM
|
NAMA PENDIDIKAN
TINGKAT PENDIDIKAN
|
TH LLS
|
idgolrupkt;
$gol2[] = $item->idgolrupkt;
if($gol1[$n-1] == $gol2[$n-2]){
$m++;
}else{
$m=1;
}
/*masa kerja*/
$mkbln = substr($item->mkskr,-2) + $item->mkblncpn;
if($mkbln > 12){
$thnmkskr = substr($item->mkskr,0,-2)+1;
$blnmkskr = "0".($mkbln-12);
}else{
$thnmkskr = substr($item->mkskr,0,-2);
$blnmkskr = (strlen($mkbln)==2)?$mkbln:"0".$mkbln;
}
?>
|
|
namalengkap; ?>
NIP : nip; ?>
|
golru; ?>
tmtpkt)); ?>
|
jabatan; ?>
tmtjbt)); ?>
|
|
|
idjenjab == 1): ?>
dikstru); ?>
tgsttp_dikstru=='0000-00-00')?"":substr($item->tgsttp_dikstru,0,4)); ?>
|
idjenjab == 1): ?>
jamhari_dikstru==0)?'':$item->jamhari_dikstru; ?>
|
jenjurusan); ?>
|
thijaz; ?>
|
tmlhr; ?>
tglhr)); ?>
|
|
path; ?>
|