public function getAllitems(Request $req) { if ($req->ajax()) { $res = []; $items = ref_jabatan::where('nm_jabatan', $req->src)->paginate(10); $out = ''; if ($items->total() > 0) { $no = $items->currentPage() == 1 ? 1 : $items->perPage() * $items->currentPage() - $items->perPage() + 1; foreach ($items as $item) { $out .= ' <tr class="item_' . $item->id . ' items"> <td>' . $no . '</td> <td>' . $item->nm_jabatan . '</td> <td> <div> ' . \Format::indoDate($item->created_at) . ' </div> <small class="text-muted">' . \Format::hari($item->created_at) . ', ' . \Format::jam($item->created_at) . '</small> </td> </tr> '; $no++; } } else { $out = ' <tr> <td colspan="3">Tidak ditemukan</td> </tr> '; } $res['data'] = $out; $res['pagin'] = $items->render(); return json_encode($res); } }
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]); }