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