Since: 3.0.0
Author: Jack P.
Inheritance: extends Traq\Models\Model
Exemple #1
0
 /**
  * Save project.
  */
 public function saveAction()
 {
     $project = Project::find($this->currentProject['id']);
     $project->set($this->projectParams());
     if ($project->save()) {
         return $this->redirectTo('project_settings');
     } else {
         return $this->render('project_settings/options/index.phtml', ['proj' => $project]);
     }
 }
Exemple #2
0
 public function __construct()
 {
     // parent::__construct();
     session_start();
     $this->db = $GLOBALS['db'];
     $this->title(setting('title'));
     $this->set('traq', $this);
     // Is this an overlay request?
     if (Request::$headers->has('X-Overlay')) {
         $this->isOverlay = true;
         $this->layout = false;
     }
     // Are we on a project page?
     if ($projectSlug = Request::$properties->get('pslug')) {
         $this->currentProject = Project::where('slug = ?')->setParameter(0, $projectSlug)->fetch();
     }
     // Is the user logged in?
     if (isset($_COOKIE['traq']) && ($sessionHash = $_COOKIE['traq'])) {
         $user = User::select('u.*', 'g.is_admin')->leftJoin('u', PREFIX . 'usergroups', 'g', 'g.id = u.group_id');
         // Project role
         if ($this->currentProject) {
             $user->addSelect('r.project_role_id')->leftJoin('u', PREFIX . 'user_roles', 'r', 'r.user_id = u.id');
         }
         // By session
         if ($sessionHash) {
             $user->where('u.login_hash = :login_hash')->setParameter('login_hash', $sessionHash);
         }
         // By API key
         // if ($apiKey) {
         // }
         $this->currentUser = $user->fetch();
     }
     // Set current user
     $GLOBALS['currentUser'] = $this->currentUser;
     $this->set('currentUser', $this->currentUser);
     // Set current project
     $GLOBALS['currentProject'] = $this->currentProject;
     $this->set('currentProject', $this->currentProject);
     // Set title
     if ($this->currentProject) {
         $this->title($this->currentProject['name']);
     }
     // Check permission
     $this->before('*', function () use($projectSlug) {
         // Check if project exists
         if ($projectSlug && !$this->currentProject || $projectSlug && !$this->hasPermission('view')) {
             return $this->show404();
         }
     });
     $this->before('*', function () {
         if ($this->currentUser && $this->currentUser['password_ver'] == 'sha1' && Request::$properties->get('controller') != 'Traq\\Controllers\\UserCP' && Request::$properties->get('controller') != 'Traq\\Controllers\\Sessions') {
             return $this->redirectTo('usercp_password');
         }
     });
 }
Exemple #3
0
 /**
  * Always call this when defining `__construct()` in sub-classes.
  */
 public function __construct()
 {
     $this->db = ConnectionManager::getConnection();
     // Modal?
     if (Request::$headers->has('X-Modal')) {
         $this->isModal = Request::$headers->get('X-Modal') == true;
     }
     // Get current project.
     if (Request::$properties->has('pslug')) {
         $this->currentProject = Project::find('slug', Request::$properties->get('pslug')) ?: null;
         $GLOBALS['current_project'] = $this->currentProject;
         $this->before('*', function () {
             if (!$this->hasPermission('view', $this->currentProject)) {
                 return $this->show404();
             }
         });
     } else {
         $GLOBALS['current_project'] = null;
     }
     // Get current user.
     if ($sessionHash = Request::$cookies->get('traq')) {
         if ($this->currentProject) {
             $user = User::select('u.*')->addSelect('pur.project_role_id')->leftJoin('u', UserRole::tableName(), 'pur', 'pur.project_id = :project_id AND pur.user_id = u.id');
             $user->where('u.session_hash = :session_hash');
             $user->setParameter('project_id', $this->currentProject['id']);
             $user->setParameter('session_hash', $sessionHash);
             $this->currentUser = $user->fetch() ?: null;
         } else {
             $this->currentUser = User::find('session_hash', $sessionHash) ?: null;
         }
         $GLOBALS['current_user'] = $this->currentUser;
     } else {
         $GLOBALS['current_user'] = null;
     }
     $GLOBALS['permissions'] = Permission::getPermissions($this->currentUser, $this->currentProject);
     // Add Traq as first breadcrumb.
     $this->addCrumb(setting('title'), $this->generateUrl('root'));
     // Check if the user has permission to view the current project
     if (isset($this->currentProject)) {
         $this->before('*', function () {
             if (!$this->hasPermission('view')) {
                 return $this->show403();
             }
         });
     }
     // If the user has a `sha1` hashed password, require them to change it because
     // as of Traq 4.1, only mcrypt passwords will work.
     if ($this->currentUser['password_ver'] == 'sha1') {
         $this->before('*', function () {
             if (Request::$properties['controller'] != 'Traq\\Controllers\\UserCP' && Request::$properties['controller'] != 'Traq\\Controllers\\Sessions') {
                 return $this->redirectTo('usercp_password');
             }
         });
     }
 }
Exemple #4
0
 /**
  * Project listing.
  */
 public function indexAction()
 {
     $projects = [];
     foreach (Project::all() as $project) {
         if ($this->hasPermission('view', $project)) {
             $projects[] = $project;
         }
     }
     return $this->respondTo(function ($format) use($projects) {
         if ($format == 'html') {
             return $this->render('projects/index.phtml', ['projects' => $projects]);
         } elseif ($format == 'json') {
             return $this->jsonResponse($projects);
         }
     });
 }
Exemple #5
0
 /**
  * Returns the subscribed object.
  *
  * @return object
  */
 public function object()
 {
     if ($this->object !== null) {
         return $this->object;
     }
     switch ($this->type) {
         case 'project':
             $this->object = Project::find($this->object_id);
             break;
         case 'milestone':
             $this->object = Milestone::find($this->object_id);
             break;
         case 'ticket':
             $this->object = Ticket::find($this->object_id);
             break;
     }
     return $this->object;
 }
Exemple #6
0
 /**
  * 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;
 }
Exemple #7
0
<?php

use Traq\Models\Project;
$testSuite->createGroup('Models / Project', function ($g) {
    $project = new Project(['name' => 'Project Model Test', 'slug' => 'project-model-test']);
    $g->test('Create', function ($t) use($project) {
        $t->assertTrue($project->save());
    });
    $g->test('Update', function ($t) use($project) {
        $project['name'] = 'Project Model Test - Updated';
        $t->assertTrue($project->save());
    });
    $g->test('Slug in use', function ($t) {
        $project = new Project(['slug' => 'project-model-test']);
        $t->assertFalse($project->save());
        $t->assertEquals('Slug is already in use', $project->getError('slug')[0]);
    });
    $g->test('Get select options', function ($t) {
        $options = Project::selectOptions();
        $t->assertArray($options);
    });
    $g->test('Delete', function ($t) use($project) {
        $project->delete();
        $t->assertFalse(Project::find('slug', 'project-model-test'));
    });
});
Exemple #8
0
/*!
 * Traq Lite
 * Copyright (c) 2009-2016 Jack P.
 * https://github.com/nirix/traq-lite
 *
 * Licensed under the BSD 3-Clause license.
 */
use Traq\Models\Project;
$query = db()->prepare('SELECT * FROM ' . PREFIX . 'projects WHERE id = ? LIMIT 1');
$query->bindValue(1, Request::$properties['id']);
$query->execute();
$project = $query->fetch();
if (!$project) {
    return show404();
}
$project = new Project($project);
if (Request::$method == 'POST') {
    $project->set(['name' => Request::$post['name'], 'slug' => Request::$post['slug'], 'description' => Request::$post['description'], 'display_order' => Request::$post['display_order']]);
    if ($project->validate()) {
        db()->beginTransaction();
        $query = db()->prepare('
            UPDATE ' . PREFIX . 'projects
            SET name = :name,
                slug = :slug,
                description = :description,
                display_order = :display_order,
                updated_at = NOW()
            WHERE id = :id
            LIMIT 1
        ');
        $query->bindValue(':id', $project['id']);
Exemple #9
0
function createProject()
{
    $project = new Project(['name' => 'project-' . mkRandomHash(5) . '-name', 'slug' => 'project-' . mkRandomHash(5) . '-slug']);
    $project->save();
    return $project;
}