/** * @param Project $project * @return \Illuminate\View\View */ public function show(Project $project) { $projectsRelation = $this->projectModel->getProjects()->limit(6)->get(); $contactInfo = User::join('profiles', 'users.id', '=', 'profiles.user_id')->where('user_id', $project->user_id)->first(); $preview = Project::isApproved(1)->where('id', '<', $project->id)->orderBy('id', 'desc')->first(); $next = Project::isApproved(1)->where('id', '>', $project->id)->orderBy('id', 'asc')->first(); return view('front.projects.show', compact('project', 'projectsRelation', 'contactInfo', 'preview', 'next')); }