public function traineeHome() { $id = Auth::user()->id; $regId = Registration::where('user_id', '=', Auth::user()->id)->pluck('id'); $user_id = Auth::user()->id; $course_ids = TraineeCourse::where('trainee_id', $user_id)->select('course_id')->get(); //$course_ids=Info::where('trainee_login_id', $user_id)->get(); $courseAttendance = []; foreach ($course_ids as $course_id) { $course_name = $this->course_name_by_course_id($course_id->course_id); if (!$course_name->isempty()) { $absent = Attendance::where('course_id', $course_id->course_id)->where('trainee_id', $user_id)->where('trainee_attendance', '=', 'A')->count('id'); $courseAttendance[] = array('course_name' => $course_name, 'absent' => $absent); } } $info = Info::wheretrainee_login_id($user_id)->firstOrFail(); return view('trainee.trainee', compact('regId', 'courseAttendance', 'info')); //dd($regId); return view('trainee.trainee', compact('regId'))->with('id', $id); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $traineeCourse = TraineeCourse::whereid($id)->firstOrFail(); $traineeCourse->delete(); return redirect('/traineeCourse')->with('status', 'The Trainee Course Relation which ID was ' . $id . ' has been deleted!'); }
public function number_of_trainee_by_course_id($course_id) { return TraineeCourse::where('course_id', $course_id)->get()->count(); }
public function updateAttendance(Request $request) { $course_id = $request->get('course_id'); $session_name = $request->get('session'); $day = $request->get('date'); $trainee_ids = TraineeCourse::whereCourse_id($course_id)->lists('trainee_id'); //$trainee_ids=Info::whereCourse_id($course_id)->lists('trainee_login_id'); foreach ($trainee_ids as $trainee_id) { $attendance = Attendance::wheretrainee_id($trainee_id)->whereCourse_id($course_id)->whereSession_name($session_name)->where('day', '=', Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $day . ' 00:00:00'))->firstorFail(); $attendance->trainee_attendance = $request->get('ta__' . $trainee_id); $attendance->update(); } $presents = Attendance::whereCourse_id($course_id)->whereSession_name($session_name)->where('day', '=', Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $day . ' 00:00:00'))->where("trainee_attendance", "P")->select('trainee_id')->get(); $present_att = array(); $i = 0; foreach ($presents as $present) { $present = User::whereId($present->trainee_id)->select('name')->firstorFail(); $present_att[$i++] = $present->name; } $absents = Attendance::whereCourse_id($course_id)->whereSession_name($session_name)->where('day', '=', Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $day . ' 00:00:00'))->where("trainee_attendance", "A")->select('trainee_id')->get(); $absent_att = array(); $j = 0; foreach ($absents as $absent) { $absent = User::whereId($absent->trainee_id)->select('name')->firstorFail(); $absent_att[$j++] = $absent->name; } $course_name = $this->course_name_by_course_id($course_id); $session = $request->get('session'); $date = $request->get('date'); return view('attendances.attendance_show', compact('present_att', 'absent_att'))->with('date', $date)->with('session', $session)->with('course_name', $course_name)->with('course_id', $course_id); }
public function trainee_by_course_id($course_id) { //$trainees = Info::all(); $trainees = TraineeCourse::all(); $users = User::all(); dd($trainees); return view('admin/admin_trainee/show_trainee_list', compact('trainees', 'users')); }