public function Programs() { $userid = $this->id; return Program::whereHas('Members', function ($q) use($userid) { $q->where('user_id', $userid); })->get(); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($programid, $workstreamid, $subjectid) { $program = Program::findOrFail($programid); $workstream = WorkStream::where('id', $workstreamid)->with('RAGs', 'Risks', 'Projects.RAGs', 'Members.User', 'Tasks.ActionOwner')->first(); $subject = Project::where('id', $subjectid)->with('RAGs', 'Risks', 'Members.User', 'Tasks.ActionOwner', 'Comments')->first(); $subjecttype = 'Project'; $subjectid = $subject->id; return view('Project.show', compact('program', 'workstream', 'subject', 'subjecttype', 'subjectid')); }
public function OpenLoadForm($projectID) { //get the project try { $project = Project::findOrFail($projectID); } catch (ModelNotFoundException $e) { abort(404, "Project with the id {$projectID} not found"); } $program = Program::findOrFail($project->program_id); $workstream = WorkStream::findOrFail($project->work_stream_id); return view('Project.UploadMicrosoftProjectPlan', compact('project', 'workstream', 'program')); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { $subject = Program::where('id', $id)->with('RAGs', 'Risks', 'Members.User', 'Tasks.ActionOwner')->first(); if (!$subject) { abort(404, 'Program not found'); } //get worksteams for this program //todo : Move this to a seperate model to ensure single responsibility. Should add number of active projects to the workstream list. Maybe a nice small char $workstreams = WorkStream::where('program_id', $id)->orderBy('phase')->orderBy('status')->orderBy('name')->with('RAGs', 'Risks', 'Members.User')->get(); //return $program->Tasks; $subjecttype = 'Program'; $subjectid = $subject->id; return view('Program.show', compact('subject', 'workstreams', 'subjecttype', 'subjectid')); }
public function show($programid, $workstreamid) { try { $program = Program::findOrFail($programid); } catch (ModelNotFoundException $e) { App::abort(404, 'Program not found'); } $subject = WorkStream::where('id', $workstreamid)->with('RAGs', 'Risks', 'Projects.RAGs', 'Members.User', 'Tasks.ActionOwner')->first(); if (!$subject) { App::abort(404, 'WorkStream not found'); } $subjecttype = 'WorkStream'; $subjectid = $subject->id; return view('workstream.show', compact('program', 'subject', 'subjecttype', 'subjectid')); }
public static function GetObject($subject_type, $subject_id) { switch ($subject_type) { case 'Program': return Program::findorFail($subject_id); break; case 'WorkStream': return WorkStream::findorFail($subject_id); break; case 'Project': return Project::findorFail($subject_id); break; case 'Risk': return Risk::findorFail($subject_id); break; case 'Task': return Task::findorFail($subject_id); break; case 'Action': return Action::findorFail($subject_id); break; case 'Rag': return rag::findorFail($subject_id); break; case 'Dependency': return Dependency::findorFail($subject_id); break; case 'ChangeRequest': return ChangeRequest::findorFail($subject_id); break; case 'Meeting': return Meeting::findorFail($subject_id); break; case 'Link': return Link::findorFail($subject_id); break; case 'Assumption': return Assumption::findorFail($subject_id); break; case 'Decision': return Decision::findorFail($subject_id); break; default: return null; } }
public function editWorkstreamRiskOrIssue($programid, $workstreamid, $riskid) { $program = Program::findOrFail($programid); $workstream = WorkStream::findOrFail($workstreamid); $risk = Risk::findorFail($riskid); //return "Owner id: $risk->owner , Owner Name: $risk->OwnerName"; $title = "Edit {$risk->title} for the {$workstream->name} Workstream"; $breadcrumbs[] = ['Home', URL::asset('/home'), false]; $breadcrumbs[] = ['Programs', URL::asset('programs'), false]; $breadcrumbs[] = [$program->name, URL::asset('/') . "/programs/{$programid}", false]; $breadcrumbs[] = ['Workstreams', '', false]; $breadcrumbs[] = [$workstream->name, URL::asset('/') . "/programs/{$programid}/workstreams/{$workstreamid}", false]; $breadcrumbs[] = ['Risks & Issues', '', false]; $breadcrumbs[] = [$risk->title, '', false]; $breadcrumbs[] = ['Edit', URL::asset('/') . "/programs/{$programid}/workstreams/{$workstreamid}/risksandissues/{$riskid}/edit", true]; $redirect = "/programs/{$programid}/workstreams/{$workstreamid}"; //return $risk->NextReviewDate; return $this->edit($risk, $title, $breadcrumbs, $redirect); }
public function dashboard($userid) { $user = User::findOrFail($userid); //get programs, workstreams and projects that the user is a member of $programs = Program::whereHas('Members', function ($q) use($userid) { $q->where('user_id', $userid); })->get(); $workstreams = WorkStream::whereHas('Members', function ($q) use($userid) { $q->where('user_id', $userid); })->get(); $projects = Project::whereHas('Members', function ($q) use($userid) { $q->where('user_id', $userid); })->get(); //get tasks for the user $tasks = Task::where('action_owner', $userid)->get(); //Get the users actions $actions = Action::where('actionee', $userid)->get(); //Get risks and issues assigned to the user $risks = Risk::where('owner', $userid)->orWhere('action_owner', $userid)->get(); //return $risks; return view('Users.dashboard', compact('user', 'programs', 'workstreams', 'projects', 'tasks', 'risks', 'actions')); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('programs')->delete(); Program::create(array('name' => 'One Biology', 'Status' => 0, 'RAG' => 'G', 'StartDate' => date_create('01/05/2010'), 'EndDate' => date_create('01/01/2018'), 'description' => 'One Biology R&D change program to deliver the future trialing processes, ways of working and tools')); Program::create(array('name' => 'MINT', 'Status' => 0, 'RAG' => 'A', 'StartDate' => date_create('01/02/2009'), 'EndDate' => date_create('01/01/2017'), 'description' => 'Material Identity aNd Tracking R&D change program')); }
public static function getSubjectName($subjecttype, $subjectid) { switch ($subjecttype) { case "Program": $program = Program::findOrFail($subjectid); return $program->name; break; case "WorkStream": $workstream = WorkStream::findOrFail($subjectid); return $workstream->name; break; case "Project": $project = Project::findOrFail($subjectid); return $project->name; break; case "Risk": $risk = Risk::findOrFail($subjectid); return $risk->title; break; case "Rag": $rag = rag::findOrFail($subjectid); return $rag->title; break; case "Task": $task = Task::findOrFail($subjectid); return $task->title; break; case "Dependency": $dependency = Dependency::findOrFail($subjectid); return $dependency->title; break; case "ChangeRequest": $changerequest = ChangeRequest::findOrFail($subjectid); return $changerequest->title; break; case "Meeting": $meeting = Meeting::findOrFail($subjectid); return $meeting->title; break; case "Action": $action = Action::findOrFail($subjectid); return $action->title; break; case "Link": $link = Link::findOrFail($subjectid); return $link->title; break; case "Assumption": $assumption = Assumption::findOrFail($subjectid); return $assumption->title; break; } }