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'));
}
