protected function AddStandardRAGs() { rag::create(array('subject_id' => $this->id, 'subject_type' => $this->subjecttype, 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => $this->id, 'subject_type' => $this->subjecttype, 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => $this->id, 'subject_type' => $this->subjecttype, 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => $this->id, 'subject_type' => $this->subjecttype, 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => $this->id, 'subject_type' => $this->subjecttype, 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => $this->id, 'subject_type' => $this->subjecttype, 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => $this->id, 'subject_type' => $this->subjecttype, 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('rags')->delete(); rag::create(array('subject_id' => 1, 'subject_type' => 'Program', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'Program', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'Program', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'Program', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'Program', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'Program', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'Program', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'WorkStream', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'WorkStream', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'WorkStream', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'WorkStream', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'WorkStream', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'WorkStream', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'WorkStream', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 2, 'subject_type' => 'WorkStream', 'title' => 'Resource', 'value' => 'A', 'comments' => 'Integration and FPLS Gaps project manager is leaving')); rag::create(array('subject_id' => 2, 'subject_type' => 'WorkStream', 'title' => 'Schedule', 'value' => 'G', 'comments' => 'Current plans are in line with the agreed July target date')); rag::create(array('subject_id' => 2, 'subject_type' => 'WorkStream', 'title' => 'Costs', 'value' => 'G', 'comments' => 'No Change')); rag::create(array('subject_id' => 2, 'subject_type' => 'WorkStream', 'title' => 'Quality', 'value' => 'G', 'comments' => 'No quality issues')); rag::create(array('subject_id' => 2, 'subject_type' => 'WorkStream', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 2, 'subject_type' => 'WorkStream', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 2, 'subject_type' => 'WorkStream', 'title' => 'Risks & Issues', 'value' => 'A', 'comments' => 'Still need to confirm the details of the location model')); rag::create(array('subject_id' => 3, 'subject_type' => 'WorkStream', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 3, 'subject_type' => 'WorkStream', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 3, 'subject_type' => 'WorkStream', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 3, 'subject_type' => 'WorkStream', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 3, 'subject_type' => 'WorkStream', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 3, 'subject_type' => 'WorkStream', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 3, 'subject_type' => 'WorkStream', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 4, 'subject_type' => 'WorkStream', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 4, 'subject_type' => 'WorkStream', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 4, 'subject_type' => 'WorkStream', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 4, 'subject_type' => 'WorkStream', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 4, 'subject_type' => 'WorkStream', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 4, 'subject_type' => 'WorkStream', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 4, 'subject_type' => 'WorkStream', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'WorkStream', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'WorkStream', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'WorkStream', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'WorkStream', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'WorkStream', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'WorkStream', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'WorkStream', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'WorkStream', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'WorkStream', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'WorkStream', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'WorkStream', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'WorkStream', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'WorkStream', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'WorkStream', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); //projects rag::create(array('subject_id' => 1, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'A', 'comments' => 'No contigency')); rag::create(array('subject_id' => 1, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 1, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 2, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'A', 'comments' => 'Change in PM and Analyst')); rag::create(array('subject_id' => 2, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'A', 'comments' => 'Need decision on SPIRIT integration')); rag::create(array('subject_id' => 2, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 2, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 2, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 2, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 2, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'A', 'comments' => 'Concerns on the risks')); rag::create(array('subject_id' => 3, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 3, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 3, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 3, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 3, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 3, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'A', 'comments' => 'Pre prod and prod delayed')); rag::create(array('subject_id' => 3, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 4, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'R', 'comments' => 'PM left')); rag::create(array('subject_id' => 4, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'A', 'comments' => 'Lack of clarity at this stage')); rag::create(array('subject_id' => 4, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 4, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 4, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 4, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 4, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 5, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 6, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 7, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 7, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 7, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 7, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 7, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 7, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 7, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 8, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 8, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 8, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 8, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 8, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 8, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 8, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 9, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 9, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 9, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 9, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 9, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 9, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 9, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 10, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 10, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 10, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 10, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 10, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 10, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 10, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 11, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 11, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 11, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 11, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 11, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 11, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 11, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 12, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 12, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 12, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 12, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 12, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 12, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 12, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 13, 'subject_type' => 'Project', 'title' => 'Resource', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 13, 'subject_type' => 'Project', 'title' => 'Schedule', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 13, 'subject_type' => 'Project', 'title' => 'Costs', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 13, 'subject_type' => 'Project', 'title' => 'Quality', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 13, 'subject_type' => 'Project', 'title' => 'Benefits', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 13, 'subject_type' => 'Project', 'title' => 'Infrastructure', 'value' => 'G', 'comments' => '')); rag::create(array('subject_id' => 13, 'subject_type' => 'Project', 'title' => 'Risks & Issues', 'value' => 'G', 'comments' => '')); }