public function getDataNIK(Request $request) { $getnik = $request->term; $data = Raport::select('id', 'nik', 'nama')->whereRaw('lulus = "LULUS" and isevabul=0 and jabatan in ("KASIR","PRAMUNIAGA","MD")')->where('nik', 'LIKE', "{$getnik}%")->get(); return response()->json($data); }
public function getEvent() { $events = Raport::select('angkatan')->whereNotNull('angkatan')->distinct()->get(); foreach ($events as $event) { $event->title = ' Reguler : ' . date('j F Y', strtotime($event->angkatan)); $event->url = url('raport/' . $event->angkatan); $event->start = $event->angkatan; } return $events; }