/**
* @return array[]
*/
public function milestoneSelectOptions($valueField = 'id', $status = null, $sort = 'ASC')
{
$options = [];
$milestones = Milestone::where('project_id = ?')->setParameter(0, $this->id)->orderBy('display_order', $sort);
if ($status !== null) {
$milestones->andWhere('status = ?')->setParameter(1, $status);
}
foreach ($milestones->execute()->fetchAll() as $milestone) {
$options[] = ['label' => $milestone['name'], 'value' => $milestone[$valueField]];
}
return $options;
}
public function milestoneOverview($team_id)
{
$project_info = Project::where('team_id', '=', $team_id)->first();
$project_id = $project_info->id;
$milestones = Milestone::where('project_id', '=', $project_id)->get();
return $milestones;
}
