0){
$where .= "and tb_01.idesljbt = \"".Input::get('ideselon')."\"";
$titleadd = strtoupper($skpd)." ESELON ".$eselon;
}
switch(Input::get('idskpd')){
case "":
$where .= "";
break;
default:
$where .= " and tb_01.idskpd like '".Input::get('idskpd')."%'";
break;
}
if(Input::get('idgolru') == "notnull"){
$where .= " and tb_01.idgolrupkt between '11' and '45' ";
$titleadd = strtoupper($skpd)." SEMUA GOLONGAN ";
}else if(Input::get('idgolru') == "null"){
$where .= " and tb_01.idgolrupkt='' ";
$titleadd = strtoupper($skpd)." YANG GOLONGANNYA KOSONG ";
}else if(Input::get('idgolru') > 0){
$where .= " and tb_01.idgolrupkt='".Input::get('idgolru')."'";
$titleadd = strtoupper($skpd)." GOLONGAN ".strtoupper($golru);
}
$rs = \DB::table('tb_01')
->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%m')+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)
->orderBy('tb_01.idjenjab', 'asc')
->orderBy('tb_01.idgolrupkt', 'desc')
->orderBy('tb_01.tmtpkt', 'asc');
?>
DAFTAR PEGAWAI PADA
BERDASARKAN DIKLAT STRUKTURAL
|
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
|
get()) > 0): ?>
get() as $item): ?>
| . |
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. |