public function showStatistics()
{
$meetings = Meeting::whereRaw('user_id = ' . \Auth::user()->id . ' and status = \'accomplished\'')->orderBy('date_time', 'DESC')->take(5)->get();
if (count($meetings) > 0) {
$last_meeting = $meetings->first();
$labels = [];
$weights = [];
$bmis = [];
$waists = [];
$hips = [];
for ($i = count($meetings) - 1; $i >= 0; $i--) {
array_push($labels, date('j/m/Y', strtotime($meetings[$i]->date_time)));
array_push($weights, $meetings[$i]->weight);
array_push($bmis, $meetings[$i]->bmi);
array_push($waists, $meetings[$i]->waist);
array_push($hips, $meetings[$i]->hip);
}
return view('patient.tracking', compact('last_meeting', 'labels', 'weights', 'bmis', 'waists', 'hips'));
} else {
return redirect('patient.tracking')->with('warning', 'Aún no has asistido a cita.');
}
}
protected function isAvailable($meetingDate, $hour)
{
$query = 'nutritionist_id = \'' . $this->user->id . '\' and date_time = \'' . $meetingDate . ' ' . $hour . ':00:00\'';
$meeting = Meeting::whereRaw($query)->get();
if (count($meeting) == 0) {
return true;
}
return false;
}
public function showSchedule(Request $request)
{
$sort = $request->get('orden');
if ($sort == '') {
$sort = 'DESC';
}
$meetings = Meeting::whereRaw('nutritionist_id = ' . \Auth::user()->id)->wheremonth($request->get('mes'))->whereyear($request->get('ano'))->wheretime($request->get('hora'))->wherestatus($request->get('estatus'))->orderBy('date_time', $sort)->paginate(10);
return view('nutritionist.meetings', compact('meetings'));
}
