/** * Returns an array containing the open, started and closed ticket count queries. * * @return array */ protected function getTicketCountQueries() { // Open ticket count $openQuery = Ticket::select('COUNT(t.id)')->where('t.milestone_id = m.id')->andWhere('t.is_closed = :open_count_is_closed'); // Started ticket count $startedQuery = Ticket::select('COUNT(t.id)')->where('t.milestone_id = m.id')->andWhere('s.status = 2')->leftJoin('t', Status::tableName(), 's', 's.id = t.status_id'); // Closed query count $closedQuery = Ticket::select('COUNT(t.id)')->where('t.milestone_id = m.id')->andWhere('t.is_closed = :closed_count_is_closed'); return [$openQuery, $startedQuery, $closedQuery]; }
/** * Project changelog. */ public function changelogAction() { $this->addCrumb($this->translate('changelog'), $this->generateUrl('changelog')); $types = []; $milestones = []; // Get milestones $milestonesQuery = $this->currentProject->milestones()->select('id', 'name', 'slug')->where('status = 2')->orderBy('display_order', 'DESC')->fetchAll(); foreach ($milestonesQuery as $milestone) { $milestones[$milestone['id']] = ['name' => $milestone['name'], 'slug' => $milestone['slug'], 'tickets' => []]; } // Get tickets if (count($milestones)) { $tickets = $this->currentProject->tickets()->select('t.ticket_id', 't.summary', 't.milestone_id', 'status.id AS status_id', 'status.name AS status_name', 'status.show_on_changelog AS status_show_on_changelog', 'type.id AS type_id', 'type.name AS type_name', 'type.bullet AS type_bullet', 'type.show_on_changelog AS type_show_on_changelog'); // Left join the status and types values $tickets->leftJoin('t', Status::tableName(), 'status', 'status.id = t.status_id'); $tickets->leftJoin('t', Type::tableName(), 'type', 'type.id = t.type_id'); // Filter by closed and milestones $tickets->where('is_closed = :is_closed')->andWhere($tickets->expr()->in('milestone_id', array_keys($milestones)))->orderBy('type_bullet', 'ASC'); $tickets->setParameter('is_closed', true, 'boolean'); foreach ($tickets->fetchAll() as $ticket) { $ticketInfo = ['ticket_id' => $ticket['ticket_id'], 'summary' => $ticket['summary'], 'type_id' => $ticket['type_id'], 'type_name' => $ticket['type_name'], 'status_id' => $ticket['status_id'], 'status_name' => $ticket['status_name']]; // Add types if (!isset($types[$ticket['type_id']])) { $types[$ticket['type_id']] = ['id' => $ticket['type_id'], 'name' => $ticket['type_name'], 'bullet' => $ticket['type_bullet']]; } if ($ticket['status_show_on_changelog'] && $ticket['type_show_on_changelog']) { $milestones[$ticket['milestone_id']]['tickets'][] = $ticketInfo; } } } // And now we get an array without the milestone ID's as the index. $milestones = array_values($milestones); return $this->respondTo(function ($format) use($types, $milestones) { if ($format == 'html') { return $this->render('projects/changelog.phtml', ['types' => $types, 'milestones' => $milestones]); } elseif ($format == 'json') { return $this->jsonResponse($milestones); } elseif ($format == 'txt') { return $this->render('projects/changelog.txt.php', ['types' => $types, 'milestones' => $milestones]); } }); }