query->findAll(); $colors = $this->color->getDefaultColors(); $bars = array(); foreach ($projects as $project) { $start = empty($project['start_date']) ? time() : strtotime($project['start_date']); $end = empty($project['end_date']) ? $start : strtotime($project['end_date']); $color = next($colors) ?: reset($colors); $bars[] = array( 'type' => 'project', 'id' => $project['id'], 'title' => $project['name'], 'start' => array( (int) date('Y', $start), (int) date('n', $start), (int) date('j', $start), ), 'end' => array( (int) date('Y', $end), (int) date('n', $end), (int) date('j', $end), ), 'link' => $this->helper->url->href('ProjectViewController', 'show', array('project_id' => $project['id'])), 'board_link' => $this->helper->url->href('BoardViewController', 'show', array('project_id' => $project['id'])), 'gantt_link' => $this->helper->url->href('TaskGanttController', 'show', array('project_id' => $project['id'])), 'color' => $color, 'not_defined' => empty($project['start_date']) || empty($project['end_date']), 'users' => $this->projectUserRole->getAllUsersGroupedByRole($project['id']), ); } return $bars; } }