public function updateSessionType(Request $request, $id) { $SessionType = SessionType::find($id); $SessionType->stID = $request->input('stID'); $SessionType->stName = $request->input('stName'); $SessionType->stDeleted = 0; $SessionType->save(); return response()->json($SessionType); }
public function AverageHoursFitness(Request $request, $id) { $SleepSessionType = SessionType::where('stName', 'Fitness')->first(); $date1 = new \DateTime('last sunday'); $date2 = new \DateTime('last sunday +7 days'); $Sessions = Session::where('loginID', $id)->where('sessionDeleted', 0)->whereRaw("sessions.sessionStartTime between '" + $date1->format('Y-m-d H:i:s') + '" and "' + $date2->format('Y-m-d H:i:s') + "'")->get(); $length = 0; for ($i = 0; $i < 7; $i++) { foreach ($Sessions as $Session) { $today = new \DateTime('last sunday'); $today->setTime(0, 0); $today->add(new \DateInterval('P' . $i . 'D')); $lateToday = new \DateTime('last sunday'); $lateToday->add(new \DateInterval('P' . $i . 'D')); $lateToday->setTime(23, 59); $sessionStartTime = new \DateTime($Session->sessionStartTime); $sessionEndTime = new \DateTime($Session->sessionEndTime); if ($Session->sessionTypeID == $SleepSessionType->id) { if ($sessionStartTime > $today) { if ($sessionStartTime <= $lateToday) { $length += $sessionEndTime->diff($sessionStartTime)->h; } } } } } return response()->json(number_format($length / 7, 2)); }