/** * Display the specified resource. * * @param int $id * @return Response */ public function show(Request $request, $id) { $data = $request->all(); $id_period = $data['id_period']; if ($id == 1) { // Add code for load teacher whitout period $teachers = \App\User::leftJoin('registry_teachers', function ($join) use($id_period) { $join->on('users.id', '=', 'registry_teachers.id_teacher')->where('registry_teachers.id_period', '=', $id_period); })->whereNull('registry_teachers.id_teacher')->Where('users.active', 1)->Where('users.type', '<>', 'Student')->select('users.id', 'users.first_name', 'users.last_name', 'users.type')->get()->toJson(); //dd(count(json_decode($teachers,true))); } else { // Add code for load teacher whit period $teachers = \App\RegistryTeacher::Join('users', 'users.id', '=', 'registry_teachers.id_teacher')->select('registry_teachers.id as id_registry_teacher', 'users.id', 'users.first_name', 'users.last_name', 'users.type')->Where('registry_teachers.id_period', $id_period)->get()->toJson(); } $status = count(json_decode($teachers, true)) > 0 ? true : false; if ($request->ajax()) { return response()->json(['status' => $status, 'data' => $teachers]); } }
public function getRegistryPeriods() { //dd(); $periods = \App\RegistryTeacher::Join('periods', 'periods.id', '=', 'registry_teachers.id_period')->select('registry_teachers.id as id_registry_teacher', 'periods.id', 'periods.name', 'periods.start', 'periods.end')->Where('id_teacher', $this->user->id)->orderBy('periods.end', 'desc')->get(); return $periods; }