/** * Execute the console command. * * @return mixed */ public function handle() { $issues = Issue::with('company', 'company.person')->has('task', '<', 1)->get(); foreach ($issues as $issue) { $task = new Task(); $task->issue_id = $issue->id; $task->person_id = $issue->company->person->id; $task->priority = $issue->level * $issue->company->score; $task->save(); } $tasks = Task::with('issue', 'issue.company', 'person')->orderBy('priority', 'DESC')->get(); echo 'ID | Name | Company | Priority | Assigned Person', PHP_EOL; foreach ($tasks as $task) { echo sprintf('%d | %s | %s | %d | %s', $task->id, $task->issue->name, $task->issue->company->name, $task->priority, $task->person->name), PHP_EOL; } }