/** * Returns options for the specific ticket filter. * * @param string $filter * * @return array */ public static function selectOptionsFor($filter, Project $project) { switch ($filter) { // Milestone options case 'milestone': $options = $project->milestoneSelectOptions('slug'); break; // Version options // Version options case 'version': $options = $project->milestoneSelectOptions('slug'); break; // Type options // Type options case 'type': $options = Type::selectOptions('name'); break; // Status options // Status options case 'status': $options = Status::selectOptions('name'); break; // Component options // Component options case 'component': $options = Component::selectOptions($project->id, 'name'); break; // Priority options // Priority options case 'priority': $options = Priority::selectOptions('name'); break; // Severity options // Severity options case 'severity': $options = Severity::selectOptions('name'); break; } return $options; }
<?php /*! * Traq Lite * Copyright (c) 2009-2016 Jack P. * https://github.com/nirix/traq-lite * * Licensed under the BSD 3-Clause license. */ use Traq\Models\Type; $type = new Type(); if (Request::$method == 'POST') { $type->set('name', Request::$post['name']); if ($type->validate()) { db()->beginTransaction(); $query = db()->prepare('INSERT INTO ' . PREFIX . 'types (name) VALUES(:name)'); $query->bindValue(':name', $type['name']); $query->execute(); db()->commit(); return redirect('/admin/types'); } } return view('admin/types/new.phtml', ['type' => $type]);
/** * Insert types. */ public function insertTypes() { $types = [['name' => "Defect", 'bullet' => "-", 'show_on_changelog' => true], ['name' => "Feature Request", 'bullet' => "+", 'show_on_changelog' => true], ['name' => "Enhancement", 'bullet' => "*", 'show_on_changelog' => true], ['name' => "Task", 'bullet' => "*", 'show_on_changelog' => true]]; foreach ($types as $type) { $model = new Type($type); $model->save(); } }
/** * 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]); } }); }
function createType() { $type = new Type(['name' => 'type-' . mkRandomHash(5) . '-name', 'bullet' => rand(1, 100)]); $type->save(); return $type; }