private function AddVariablesForTopBar()
{
view()->composer('partials.topbar', function ($view) {
$projects = Project::Active()->get();
$view->with(compact('projects'));
});
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('projects')->delete();
/* 1 */
Project::create(array('program_id' => 1, 'work_stream_id' => 2, 'name' => 'OB P2_Protocol Pilot', 'Status' => 7, 'PI' => 'PI0012823', 'StartDate' => date_create('11/01/2014'), 'EndDate' => date_create('10/01/2015'), 'description' => 'Protocol Pilot'));
/* 2 */
Project::create(array('program_id' => 1, 'work_stream_id' => 2, 'name' => 'OB P2_Comprehensive Protocol Solution', 'Status' => 7, 'PI' => 'PI0013123', 'StartDate' => date_create('01/01/2015'), 'EndDate' => date_create('09/15/2015'), 'description' => 'Agree a global process for site placement and implement the appropriate tool to support the new process'));
/* 3 */
Project::create(array('program_id' => 1, 'work_stream_id' => 2, 'name' => 'OB P2_Site Placement Implementation', 'Status' => 5, 'PI' => 'PI0013341', 'StartDate' => date_create('06/01/2015'), 'EndDate' => date_create('07/01/2016'), 'description' => 'Implement site placement in BioPlan'));
/* 4 */
Project::create(array('program_id' => 1, 'work_stream_id' => 2, 'name' => 'OB P2_Protocol Implementation', 'Status' => 5, 'PI' => 'PI0013340', 'StartDate' => date_create('06/18/2015'), 'EndDate' => date_create('07/01/2016'), 'description' => 'Implement globabl protocol solution including new tool'));
/* 5 */
Project::create(array('program_id' => 1, 'work_stream_id' => 2, 'name' => 'OB P2_System Integration Service and Governance', 'Status' => 5, 'PI' => 'PI0012969', 'StartDate' => date_create('04/01/2015'), 'EndDate' => date_create('04/01/2016'), 'description' => 'Biztalk based integration service'));
/* 6 */
Project::create(array('program_id' => 1, 'work_stream_id' => 2, 'name' => 'OB P2_Data Transport POC', 'Status' => 7, 'PI' => 'PI0012865', 'StartDate' => date_create('01/01/2015'), 'EndDate' => date_create('01/01/2016'), 'description' => 'Produce report recommending how to support our data movement needs'));
/* 7 */
Project::create(array('program_id' => 1, 'work_stream_id' => 6, 'name' => 'OB P2_Data Transport Implementation', 'Status' => 0, 'PI' => '', 'StartDate' => date_create('07/01/2016'), 'EndDate' => date_create('05/01/2017'), 'description' => 'Implement a data transport mechanism'));
/* 8 */
Project::create(array('program_id' => 1, 'work_stream_id' => 2, 'name' => 'OB P2_FPLS Gaps solution', 'Status' => 5, 'PI' => 'PI0013810', 'StartDate' => date_create('07/01/2015'), 'EndDate' => date_create('07/01/2016'), 'description' => 'Resolve gaps in functionality that are in FPLS but not covered by protocol or site placement'));
/* 9 */
Project::create(array('program_id' => 1, 'work_stream_id' => 2, 'name' => 'OB P2_One Biology Portal', 'Status' => 5, 'PI' => 'PI0011059', 'StartDate' => date_create('07/01/2015'), 'EndDate' => date_create('05/01/2016'), 'description' => 'User Experience Platform'));
/* 10 */
Project::create(array('program_id' => 1, 'work_stream_id' => 3, 'name' => 'OB P2_Analytics & Reporting tools Pilot', 'Status' => 5, 'PI' => 'PI0013342', 'StartDate' => date_create('07/01/2015'), 'EndDate' => date_create('03/31/2016'), 'description' => 'This is a pilot'));
/* 11 */
Project::create(array('program_id' => 1, 'work_stream_id' => 3, 'name' => 'OB P2_Trial Data Accessibility project', 'Status' => 5, 'PI' => 'PI0013343', 'StartDate' => date_create('07/01/2015'), 'EndDate' => date_create('03/31/2016'), 'description' => 'This is a POC'));
/* 12 */
Project::create(array('program_id' => 1, 'work_stream_id' => 3, 'name' => 'Trialing Data Structure Project', 'Status' => 5, 'PI' => 'PI0013703', 'StartDate' => date_create('07/01/2015'), 'EndDate' => date_create('03/01/2016'), 'description' => 'This is a POC'));
/* 13 */
Project::create(array('program_id' => 1, 'work_stream_id' => 3, 'name' => 'OB P2_Common Language Delivery', 'Status' => 5, 'PI' => 'PI0012970', 'StartDate' => date_create('05/01/2015'), 'EndDate' => date_create('01/01/2016'), 'description' => 'Implement a new process for agreeing common language'));
/* 14 */
Project::create(array('program_id' => 1, 'work_stream_id' => 3, 'name' => 'OB P2_Legacy Trialing Data Migration Proposal Project', 'Status' => 5, 'PI' => 'PI0013344', 'StartDate' => date_create('07/01/2015'), 'EndDate' => date_create('03/01/2016'), 'description' => 'This is a POC'));
}
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'));
}
public function indexTask($subjecttype, $subjectid, Request $request)
{
$title = "Tasks for {$subjecttype} " . Breadcrumbs::getSubjectName($subjecttype, $subjectid);
$breadcrumbs = Breadcrumbs::getBreadCrumb($subjecttype, $subjectid);
$breadcrumbs[] = ['Tasks', action('TaskController@indexTask', [$subjecttype, $subjectid]), true];
$tasks = Task::where('subject_type', $subjecttype)->where('subject_id', $subjectid)->get();
if ($subjecttype == 'Project') {
$project = Project::findOrFail($subjectid);
return view('Tasks.indexProject', compact('subjectid', 'subjecttype', 'tasks', 'title', 'breadcrumbs', 'project'));
} else {
return view('Tasks.index', compact('subjectid', 'subjecttype', 'tasks', 'title', 'breadcrumbs'));
}
}
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 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'));
}
public function Projects()
{
$userid = $this->id;
return Project::whereHas('Members', function ($q) use($userid) {
$q->where('user_id', $userid);
})->get();
}
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;
}
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update($id, Request $request)
{
//return $request->all();
$subject = Project::findorFail($id);
$subject->Status = $request->Status;
$subject->PI = $request->PI;
$subject->name = $request->name;
$subject->description = $request->description;
$subject->StartDate = Carbon::parse($request->StartDate)->toDateTimeString();
$subject->EndDate = Carbon::parse($request->EndDate)->toDateTimeString();
$subject->save();
flash()->success('Success', "Project updated successfully");
return redirect(Session::GetRedirect());
}
