public function tabs(Plan $plan) { // Take a business plan and create a tsv representation $tsv = "Type\tDescription\tDue\tOwner\tLead\tCollaborators\tStatus\tSuccess Measures\r\n"; foreach ($plan->goals()->orderBy('body', 'asc')->get() as $goal) { $tsv .= "Goal\t" . $goal->body . str_repeat("\t", 6) . "\r\n"; if (count($goal->objectives->all()) > 0) { foreach ($goal->objectives()->orderBy('body', 'asc')->get() as $objective) { $tsv .= "Objective\t" . $objective->body . str_repeat("\t", 6) . "\r\n"; if (count($objective->actions->all()) > 0) { foreach ($objective->actions()->orderBy('body', 'asc')->get() as $action) { $tsv .= "Action\t" . $action->body . "\t" . $action->date . "\t" . $action->owner . "\t" . $this->split_username_delimiters($action->lead) . "\t" . $this->split_username_delimiters($action->collaborators) . "\t" . $action->status . "\t" . $action->success . "\r\n"; if (count($action->tasks->all()) > 0) { foreach ($action->tasks()->orderBy('body', 'asc')->get() as $task) { $tsv .= "Task\t" . $task->body . "\t" . $task->date . "\t" . $task->owner . "\t" . $this->split_username_delimiters($task->lead) . "\t" . $this->split_username_delimiters($task->collaborators) . "\t" . $task->status . "\t" . $task->success . "\r\n"; } } } } } } } file_put_contents("bp.tsv", $tsv); return view('export.tsv'); }
public function createPlan(Request $request) { //Create the plan $plan = new Plan(); $plan->startdate = Carbon::create($request->startdate, 1, 1, 0, 0, 0); $plan->enddate = Carbon::create($request->enddate, 1, 1, 0, 0, 0); $plan->save(); //Add Goal 1 $goal1 = new Goal(); $goal1->body = $request->goal1; $plan->goals()->save($goal1); //Add Goal 2 $goal2 = new Goal(); $goal2->body = $request->goal2; $plan->goals()->save($goal2); //Add Objective 1 $obj1 = new Objective(); $obj1->body = $request->obj1; $goal1->objectives()->save($obj1); //Add Objective 2 $obj2 = new Objective(); $obj2->body = $request->obj2; $goal1->objectives()->save($obj2); //Add Objective 3 $obj3 = new Objective(); $obj3->body = $request->obj3; $goal2->objectives()->save($obj3); //Add Objective 4 $obj4 = new Objective(); $obj4->body = $request->obj4; $goal2->objectives()->save($obj4); //Add Action 1 $action1 = new Action(); $action1->body = $request->action1; if ($request->dateA1 != null) { $action1->date = Carbon::createFromFormat('Y-m-d', $request->dateA1); } else { $action1->date = ""; } $action1->owner = $request->ownerA1; $action1->lead = implode('__,__', $request->leadA1); $action1->collaborators = implode('__,__', $request->collabA1); $action1->status = $request->statusA1; $action1->success = $request->successA1; $obj1->actions()->save($action1); //Add Action 2 $action2 = new Action(); $action2->body = $request->action2; if ($request->dateA2 != null) { $action1->date = Carbon::createFromFormat('Y-m-d', $request->dateA2); } else { $action1->date = ""; } $action2->owner = $request->ownerA2; $action2->lead = implode('__,__', $request->leadA2); $action2->collaborators = implode('__,__', $request->collabA2); $action2->status = $request->statusA2; $action2->success = $request->successA2; $obj1->actions()->save($action2); //Add Action 3 $action3 = new Action(); $action3->body = $request->action3; if ($request->dateA3 != null) { $action3->date = Carbon::createFromFormat('Y-m-d', $request->dateA3); } else { $action3->date = ""; } $action3->owner = $request->ownerA3; $action3->lead = implode('__,__', $request->leadA3); $action3->collaborators = implode('__,__', $request->collabA3); $action3->status = $request->statusA3; $action3->success = $request->successA3; $obj2->actions()->save($action3); //Add Action 4 $action4 = new Action(); $action4->body = $request->action4; if ($request->dateA4 != null) { $action4->date = Carbon::createFromFormat('Y-m-d', $request->dateA4); } else { $action4->date = ""; } $action4->owner = $request->ownerA4; $action4->lead = implode('__,__', $request->leadA4); $action4->collaborators = implode('__,__', $request->collabA4); $action4->status = $request->statusA4; $action4->success = $request->successA4; $obj2->actions()->save($action4); //Add Action 5 $action5 = new Action(); $action5->body = $request->action5; if ($request->dateA5 != null) { $action5->date = Carbon::createFromFormat('Y-m-d', $request->dateA5); } else { $action5->date = ""; } $action5->owner = $request->ownerA5; $action5->lead = implode('__,__', $request->leadA5); $action5->collaborators = implode('__,__', $request->collabA5); $action5->status = $request->statusA5; $action5->success = $request->successA5; $obj3->actions()->save($action5); //Add Action 6 $action6 = new Action(); $action6->body = $request->action6; if ($request->dateA6 != null) { $action6->date = Carbon::createFromFormat('Y-m-d', $request->dateA6); } else { $action6->date = ""; } $action6->owner = $request->ownerA6; $action6->lead = implode('__,__', $request->leadA5); $action6->collaborators = implode('__,__', $request->collabA6); $action6->status = $request->statusA6; $action6->success = $request->successA6; $obj3->actions()->save($action6); //Add Action 7 $action7 = new Action(); $action7->body = $request->action7; if ($request->dateA7 != null) { $action7->date = Carbon::createFromFormat('Y-m-d', $request->dateA7); } else { $action7->date = ""; } $action7->owner = $request->ownerA7; $action7->lead = implode('__,__', $request->leadA7); $action7->collaborators = implode('__,__', $request->collabA7); $action7->status = $request->statusA7; $action7->success = $request->successA7; $obj4->actions()->save($action7); //Add Action 4 $action8 = new Action(); $action8->body = $request->action8; if ($request->dateA8 != null) { $action8->date = Carbon::createFromFormat('Y-m-d', $request->dateA8); } else { $action8->date = ""; } $action8->owner = $request->ownerA8; $action8->lead = implode('__,__', $request->leadA8); $action8->collaborators = implode('__,__', $request->collabA8); $action8->status = $request->statusA8; $action8->success = $request->successA8; $obj4->actions()->save($action8); //Tasks //Add Task 1 $task1 = new Task(); $task1->body = $request->task1; if ($request->dateT1 != null) { $task1->date = Carbon::createFromFormat('Y-m-d', $request->dateT1); } else { $task1->date = ""; } $task1->owner = $request->ownerT1; $task1->lead = implode('__,__', $request->leadT1); $task1->collaborators = implode('__,__', $request->collabT1); $task1->status = $request->statusT1; $task1->success = $request->successT1; $action1->tasks()->save($task1); //Add Task 2 $task2 = new Task(); $task2->body = $request->task2; if ($request->dateT2 != null) { $task2->date = Carbon::createFromFormat('Y-m-d', $request->dateT2); } else { $task2->date = ""; } $task2->owner = $request->ownerT2; $task2->lead = implode('__,__', $request->leadT2); $task2->collaborators = implode('__,__', $request->collabT2); $task2->status = $request->statusT2; $task2->success = $request->successT2; $action1->tasks()->save($task2); //Add Task 3 $task3 = new Task(); $task3->body = $request->task3; if ($request->dateT3 != null) { $task3->date = Carbon::createFromFormat('Y-m-d', $request->dateT3); } else { $task3->date = ""; } $task3->owner = $request->ownerT3; $task3->lead = implode('__,__', $request->leadT3); $task3->collaborators = implode('__,__', $request->collabT3); $task3->status = $request->statusT3; $task3->success = $request->successT3; $action2->tasks()->save($task3); //Add Task 4 $task4 = new Task(); $task4->body = $request->task4; if ($request->dateT4 != null) { $task4->date = Carbon::createFromFormat('Y-m-d', $request->dateT4); } else { $task4->date = ""; } $task4->owner = $request->ownerT4; $task4->lead = implode('__,__', $request->leadT4); $task4->collaborators = implode('__,__', $request->collabT4); $task4->status = $request->statusT4; $task4->success = $request->successT4; $action2->tasks()->save($task4); //Add Task 5 $task5 = new Task(); $task5->body = $request->task5; if ($request->dateT5 != null) { $task5->date = Carbon::createFromFormat('Y-m-d', $request->dateT5); } else { $task5->date = ""; } $task5->owner = $request->ownerT5; $task5->lead = implode('__,__', $request->leadT5); $task5->collaborators = implode('__,__', $request->collabT5); $task5->status = $request->statusT5; $task5->success = $request->successT5; $action3->tasks()->save($task5); //Add Task 6 $task6 = new Task(); $task6->body = $request->task6; if ($request->dateT6 != null) { $task6->date = Carbon::createFromFormat('Y-m-d', $request->dateT6); } else { $task6->date = ""; } $task6->owner = $request->ownerT6; $task6->lead = implode('__,__', $request->leadT6); $task6->collaborators = implode('__,__', $request->collabT6); $task6->status = $request->statusT6; $task6->success = $request->successT6; $action3->tasks()->save($task6); //Add Task 7 $task7 = new Task(); $task7->body = $request->task7; if ($request->dateT7 != null) { $task7->date = Carbon::createFromFormat('Y-m-d', $request->dateT7); } else { $task7->date = ""; } $task7->owner = $request->ownerT7; $task7->lead = implode('__,__', $request->leadT7); $task7->collaborators = implode('__,__', $request->collabT7); $task7->status = $request->statusT7; $task7->success = $request->successT7; $action4->tasks()->save($task7); //Add Task 8 $task8 = new Task(); $task8->body = $request->task8; if ($request->dateT8 != null) { $task8->date = Carbon::createFromFormat('Y-m-d', $request->dateT8); } else { $task8->date = ""; } $task8->owner = $request->ownerT8; $task8->lead = implode('__,__', $request->leadT8); $task8->collaborators = implode('__,__', $request->collabT8); $task8->status = $request->statusT8; $task8->success = $request->successT8; $action4->tasks()->save($task8); //Add Task 9 $task9 = new Task(); $task9->body = $request->task9; if ($request->dateT9 != null) { $task9->date = Carbon::createFromFormat('Y-m-d', $request->dateT9); } else { $task9->date = ""; } $task9->owner = $request->ownerT9; $task9->lead = implode('__,__', $request->leadT9); $task9->collaborators = implode('__,__', $request->collabT9); $task9->status = $request->statusT9; $task9->success = $request->successT9; $action5->tasks()->save($task9); //Add Task 10 $task10 = new Task(); $task10->body = $request->task10; if ($request->dateT10 != null) { $task10->date = Carbon::createFromFormat('Y-m-d', $request->dateT10); } else { $task10->date = ""; } $task10->owner = $request->ownerT10; $task10->lead = implode('__,__', $request->leadT10); $task10->collaborators = implode('__,__', $request->collabT10); $task10->status = $request->statusT10; $task10->success = $request->successT10; $action5->tasks()->save($task10); //Add Task 11 $task11 = new Task(); $task11->body = $request->task11; if ($request->dateT11 != null) { $task11->date = Carbon::createFromFormat('Y-m-d', $request->dateT11); } else { $task11->date = ""; } $task11->owner = $request->ownerT11; $task11->lead = implode('__,__', $request->leadT11); $task11->collaborators = implode('__,__', $request->collabT11); $task11->status = $request->statusT11; $task11->success = $request->successT11; $action6->tasks()->save($task11); //Add Task 4 $task12 = new Task(); $task12->body = $request->task12; if ($request->dateT12 != null) { $task12->date = Carbon::createFromFormat('Y-m-d', $request->dateT12); } else { $task12->date = ""; } $task12->owner = $request->ownerT12; $task12->lead = implode('__,__', $request->leadT12); $task12->collaborators = implode('__,__', $request->collabT12); $task12->status = $request->statusT12; $task12->success = $request->successT12; $action6->tasks()->save($task12); //Add Task 13 $task13 = new Task(); $task13->body = $request->task13; if ($request->dateT13 != null) { $task13->date = Carbon::createFromFormat('Y-m-d', $request->dateT13); } else { $task13->date = ""; } $task13->owner = $request->ownerT13; $task13->lead = implode('__,__', $request->leadT13); $task13->collaborators = implode('__,__', $request->collabT13); $task13->status = $request->statusT13; $task13->success = $request->successT13; $action7->tasks()->save($task13); //Add Task 14 $task14 = new Task(); $task14->body = $request->task14; if ($request->dateT14 != null) { $task14->date = Carbon::createFromFormat('Y-m-d', $request->dateT14); } else { $task14->date = ""; } $task14->owner = $request->ownerT14; $task14->lead = implode('__,__', $request->leadT14); $task14->collaborators = implode('__,__', $request->collabT14); $task14->status = $request->statusT14; $task14->success = $request->successT14; $action7->tasks()->save($task14); //Add Task 15 $task15 = new Task(); $task15->body = $request->task15; if ($request->dateT15 != null) { $task15->date = Carbon::createFromFormat('Y-m-d', $request->dateT15); } else { $task15->date = ""; } $task15->owner = $request->ownerT15; $task15->lead = implode('__,__', $request->leadT15); $task15->collaborators = implode('__,__', $request->collabT15); $task15->status = $request->statusT15; $task15->success = $request->successT15; $action8->tasks()->save($task15); //Add Task 16 $task16 = new Task(); $task16->body = $request->task16; if ($request->dateT16 != null) { $task16->date = Carbon::createFromFormat('Y-m-d', $request->dateT16); } else { $task16->date = ""; } $task16->owner = $request->ownerT16; $task16->lead = implode('__,__', $request->leadT16); $task16->collaborators = implode('__,__', $request->collabT16); $task16->status = $request->statusT16; $task16->success = $request->successT16; $action8->tasks()->save($task16); return view('createDone'); }