select('tb_01.*','a_golruang.golru','a_skpd.path','a_esl.esl','a_tkpendid.tkpendid','a_jenjurusan.jenjurusan', \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')+0 AS usia") ) ->join('a_skpd', 'tb_01.idskpd', '=', 'a_skpd.idskpd') ->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') ->whereRaw($where) ->havingRaw($having) ->orderBy('tb_01.idjenjab', 'asc') ->orderBy('tb_01.idgolrupkt', 'desc') ->orderBy('tb_01.tmtpkt', 'asc'); ?>
get()) > 0): ?> get() as $item): ?>

NO.	NAMA TEMPAT, TGL LAHIR	NIP KARPEG	GOL. TMT	ESELON TMT	JABATAN UNIT KERJA TMT	MASA KERJA		s/d SEKARANG		PENDIDIKAN TERAKHIR TAHUN	AGAMA USIA
						THN	BLN	THN	BLN
.	nama; ?> tmlhr; ?>, tglhr!='0000-00-00')?date('d-m-Y', strtotime($item->tglhr)):''; ?>	nip); ?> nokarpeg; ?>	golru; ?> tmtpkt!='0000-00-00')?date('d-m-Y', strtotime($item->tmtpkt)):''; ?>	esl!='')?$item->esl:'-'; ?>	jabatan; ?> Pada path; ?> TMT : tmtjbt!='0000-00-00')?date('d-m-Y', strtotime($item->tmtjbt)):''; ?>	mkthnpkt; ?>	mkblnpkt; ?>	mkskr,0,-2); ?>	mkskr,-2); ?>	jenjurusan)); ?> thijaz; ?>	agama; ?> usia,0,2); ?> thn usia,2,2); ?> bln
Daftar Pegawai tidak tersedia.