select(
'a.idskpd','a.skpd','a.jab','a.path','b.nip','b.niplama','b.photo',
\DB::raw("concat(if(length(b.gdp)>0,concat(b.gdp,' '),''),b.nama,if(length(b.gdb)>0,concat(',',b.gdb),'')) as namalengkap")
)
->leftjoin('tb_01 as b', function($join){
$join->on('a.idskpd','=','b.idjabjbt')
->where('b.idjenkedudupeg','!=',99)
->where('b.idjenkedudupeg','!=',21);
})->where('a.idskpd', Input::get('idskpd'));
$item = $rs->first();
$div1 = "
".$item->nip."
";
$div2 = "
".$item->namalengkap."
";
if(File::exists("packages/upload/photo/pegawai/".$item->photo)){
$urlphoto = url()."/packages/upload/photo/pegawai/".$item->photo;
}else{
$urlphoto = url()."/packages/upload/photo/pegawai/default.jpg";
}
?>