function getPrint($id)
{
$karyawan = data_karyawan::find($id);
$keluarga = data_karyawan_klrg::where('id_karyawan', $karyawan->id_karyawan)->get();
$status_karyawan = data_personalia::join('ref_status_karyawan', 'ref_status_karyawan.id', '=', 'data_personalia.id_status')->where('tipe_status', 1)->where('id_karyawan', $karyawan->id_karyawan)->get();
$catatan = data_personalia::join('ref_status_karyawan', 'ref_status_karyawan.id', '=', 'data_personalia.id_status')->where('tipe_status', 3)->orWhere('tipe_status', 4)->orWhere('tipe_status', 5)->where('id_karyawan', $karyawan->id_karyawan)->get();
$jabatan = ref_jabatan::where('id', $karyawan->jabatan)->first();
$agama = ref_agama::where('id', $karyawan->agama)->first();
return view('Print.Personalia.karyawan', ['karyawan' => $karyawan, 'keluarga' => $keluarga, 'status_karyawan' => $status_karyawan, 'jabatan' => $jabatan, 'agama' => $agama, 'catatan' => $catatan]);
}
/**
* Execute the job.
*
* @return void
*/
public function handle()
{
data_personalia::create(['id_karyawan' => $this->req['id_karyawan'], 'id_status' => $this->req['id_status'], 'surat_keputusan' => $this->req['surat_keputusan'], 'datetime_out' => date('Y-m-d', strtotime($this->req['datetime_in'])), 'keterangan' => $this->req['keterangan']]);
return $this->req;
}
public function getCuti()
{
$data = data_karyawan::join('ref_status_karyawan', 'ref_status_karyawan.id', '=', 'data_karyawan.id_status')->where('tipe_status', 1)->orWhere('id_status', 15)->get();
$cuti = data_personalia::join('data_karyawan', 'data_karyawan.id_karyawan', '=', 'data_personalia.id_karyawan')->join('ref_status_karyawan', 'ref_status_karyawan.id', '=', 'data_personalia.id_status')->where('tipe_status', 3)->get();
return view('Personalia.Status.status_cuti', ['cuti' => ref_status_karyawan::where('tipe_status', 3)->get(), 'data' => $data]);
}