public static function getTrainingsForDate($date)
{
$start = $date->startOfDay()->toDateTimeString();
$end = $date->endOfDay()->toDateTimeString();
$trainings = Training::where('finished_at', '>=', $start)->where('finished_at', '<=', $end)->where('user_id', Auth::user()->id)->get();
return $trainings;
}
public function select_course($training_id)
{
$courses = Course::whereTraining_id($training_id)->get();
$trainingId = Training::where('id', '=', $training_id)->firstOrFail();
//dd($trainingId);
return view('view_trainee_report/select_course')->with('courses', $courses)->with('trainingId', $trainingId);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit(Request $request, $id)
{
$training = Training::where('id', $id)->first();
if ($training && ($request->user()->id == $training->user_id || $request->user()->is_admin())) {
return view('trainings.edit')->with('training', $training);
}
return redirect('/exercise/index')->withErrors('You have not sufficient permissions');
}
public function index()
{
$limit = 2;
$announcement = Announcement::orderBy('created_at', 'desc')->limit($limit)->get();
$now = new Datetime();
$now = $now->format('Y-m-d');
$upcomingTrainings = Training::where('status', '=', 1)->where('start_date', '>', Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $now . ' 00:00:00'))->orderBy('start_date', 'asc')->limit($limit)->get();
$ongoingTrainings = Training::where('status', '=', 1)->where('start_date', '<=', Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $now . ' 00:00:00'))->where('end_date', '>=', Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $now . ' 00:00:00'))->limit($limit)->get();
$all_slider = Slider::orderBy('position', 'asc')->get();
return view('bard_frontend.index', compact('announcement', 'upcomingTrainings', 'ongoingTrainings', 'all_slider'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update($training_slug, TrainingFormRequest $request)
{
//
$training = Training::where('training_slug', $training_slug)->firstOrFail();
$training->training_name = $request->get('training_name');
$training->training_type = $request->get('training_type');
$training->applying_information = $request->get('applying_information');
$training->objectives = $request->get('objectives');
$training->courses = $request->get('courses');
$training->start_date = $request->get('start_date');
$training->end_date = $request->get('end_date');
$training->provided_resources = $request->get('provided_resources');
$training->accommodation = $request->get('accommodation');
$training->testimonial = $request->get('testimonial');
$training->daily_schedule = $request->get('daily_schedule');
$training->fees_structure = $request->get('fees_structure');
$training->responsible_person = $request->get('responsible_person');
Training::where('training_slug', $training_slug)->update($training->toArray());
return redirect(action('TrainingController@edit', $training->training_slug))->with('status', 'The Training Information has been updated!');
}
public function statusUpdate($id)
{
$training = Training::where('id', $id)->firstOrFail();
$training->status = 1;
}
public function statusUpdate($id)
{
$training = Training::where('id', $id)->firstOrFail();
if ($training->status) {
$training->status = 0;
} else {
$training->status = 1;
}
$training->save();
$trainings = Training::all();
return view('trainings.index', compact('trainings'));
}
public function trainerIndex()
{
$this->info['namespace'] = "trainerIndex";
$groups = Group::where('trainer_id', Auth::user()->id)->get(['training_id', 'count']);
foreach ($groups as $group) {
$this->info['group_count'] = $group->count;
$this->info['trainings'] = Training::where('id', $group->training_id)->get();
}
//$this->info['trainings'] = Training::where('area_id', $area_id)->where('subarea_id', $subarea_id)->get();
$this->info['title'] = "Trainer Panel | " . $this->info['title'];
return view('trainerPages.home', ['info' => $this->info]);
}
public function restore($id)
{
return Training::where('id', $id)->withTrashed()->firstOrFail();
}
