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