public static function userTimeForProject($projectId) { try { $users; $userIdList = \Projectcollabs::where('project_id', $projectId)->lists('user_id'); $taskIdList = \Task::where('project_id', $projectId)->lists('id'); foreach ($userIdList as $userId) { $tempUserData; $timeList = \Timesheet::whereIn('task_id', $taskIdList)->where('user_id', $userId)->lists('total_time_spent'); $totalTime = 0; foreach ($timeList as $time) { $totalTime = $totalTime + $time; } $user = \User::find($userId); $tempUserData['userName'] = $user->first_name . $user->last_name; $tempUserData['userId'] = $userId; $tempUserData['totalTime'] = \DateAndTime::convertTime($totalTime); $users[] = $tempUserData; } return $users; } catch (\Exception $e) { \Log::error('Something Went Wrong in Report Repository - userTimeForProject():' . $e->getMessage()); throw new SomeThingWentWrongException(); } }