예제 #1
0
 public function testMovePosition()
 {
     $t = new Task($this->registry);
     $p = new Project($this->registry);
     $this->assertEquals(1, $p->create(array('name' => 'Project #1')));
     $counter = 1;
     $task_per_column = 5;
     foreach (array(1, 2, 3, 4) as $column_id) {
         for ($i = 1; $i <= $task_per_column; $i++, $counter++) {
             $task = array('title' => 'Task #' . $i . '-' . $column_id, 'project_id' => 1, 'column_id' => $column_id, 'owner_id' => 0);
             $this->assertEquals($counter, $t->create($task));
             $task = $t->getById($counter);
             $this->assertNotFalse($task);
             $this->assertNotEmpty($task);
             $this->assertEquals($i, $task['position']);
         }
     }
     // We move task id #4, column 1, position 4 to the column 2, position 3
     $this->assertTrue($t->movePosition(1, 4, 2, 3));
     // We check the new position of the task
     $task = $t->getById(4);
     $this->assertEquals(4, $task['id']);
     $this->assertEquals(2, $task['column_id']);
     $this->assertEquals(3, $task['position']);
     // The tasks before have the correct position
     $task = $t->getById(3);
     $this->assertEquals(3, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals(3, $task['position']);
     $task = $t->getById(7);
     $this->assertEquals(7, $task['id']);
     $this->assertEquals(2, $task['column_id']);
     $this->assertEquals(2, $task['position']);
     // The tasks after have the correct position
     $task = $t->getById(5);
     $this->assertEquals(5, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals(4, $task['position']);
     $task = $t->getById(8);
     $this->assertEquals(8, $task['id']);
     $this->assertEquals(2, $task['column_id']);
     $this->assertEquals(4, $task['position']);
     // The number of tasks per column
     $this->assertEquals($task_per_column - 1, $t->countByColumnId(1, 1));
     $this->assertEquals($task_per_column + 1, $t->countByColumnId(1, 2));
     $this->assertEquals($task_per_column, $t->countByColumnId(1, 3));
     $this->assertEquals($task_per_column, $t->countByColumnId(1, 4));
     // We move task id #1, column 1, position 1 to the column 4, position 6 (last position)
     $this->assertTrue($t->movePosition(1, 1, 4, $task_per_column + 1));
     // We check the new position of the task
     $task = $t->getById(1);
     $this->assertEquals(1, $task['id']);
     $this->assertEquals(4, $task['column_id']);
     $this->assertEquals($task_per_column + 1, $task['position']);
     // The tasks before have the correct position
     $task = $t->getById(20);
     $this->assertEquals(20, $task['id']);
     $this->assertEquals(4, $task['column_id']);
     $this->assertEquals($task_per_column, $task['position']);
     // The tasks after have the correct position
     $task = $t->getById(2);
     $this->assertEquals(2, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals(1, $task['position']);
     // The number of tasks per column
     $this->assertEquals($task_per_column - 2, $t->countByColumnId(1, 1));
     $this->assertEquals($task_per_column + 1, $t->countByColumnId(1, 2));
     $this->assertEquals($task_per_column, $t->countByColumnId(1, 3));
     $this->assertEquals($task_per_column + 1, $t->countByColumnId(1, 4));
     // Our previous moved task should stay at the same place
     $task = $t->getById(4);
     $this->assertEquals(4, $task['id']);
     $this->assertEquals(2, $task['column_id']);
     $this->assertEquals(3, $task['position']);
     // Test wrong position number
     $this->assertFalse($t->movePosition(1, 2, 3, 0));
     $this->assertFalse($t->movePosition(1, 2, 3, -2));
     // Wrong column
     $this->assertFalse($t->movePosition(1, 2, 22, 2));
     // Test position greater than the last position
     $this->assertTrue($t->movePosition(1, 11, 1, 22));
     $task = $t->getById(11);
     $this->assertEquals(11, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals($t->countByColumnId(1, 1), $task['position']);
     $task = $t->getById(5);
     $this->assertEquals(5, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals($t->countByColumnId(1, 1) - 1, $task['position']);
     $task = $t->getById(4);
     $this->assertEquals(4, $task['id']);
     $this->assertEquals(2, $task['column_id']);
     $this->assertEquals(3, $task['position']);
     $this->assertEquals($task_per_column - 1, $t->countByColumnId(1, 1));
     $this->assertEquals($task_per_column + 1, $t->countByColumnId(1, 2));
     $this->assertEquals($task_per_column - 1, $t->countByColumnId(1, 3));
     $this->assertEquals($task_per_column + 1, $t->countByColumnId(1, 4));
     // Our previous moved task should stay at the same place
     $task = $t->getById(4);
     $this->assertEquals(4, $task['id']);
     $this->assertEquals(2, $task['column_id']);
     $this->assertEquals(3, $task['position']);
     // Test moving task to position 1
     $this->assertTrue($t->movePosition(1, 14, 1, 1));
     $task = $t->getById(14);
     $this->assertEquals(14, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals(1, $task['position']);
     $task = $t->getById(2);
     $this->assertEquals(2, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals(2, $task['position']);
     $this->assertEquals($task_per_column, $t->countByColumnId(1, 1));
     $this->assertEquals($task_per_column + 1, $t->countByColumnId(1, 2));
     $this->assertEquals($task_per_column - 2, $t->countByColumnId(1, 3));
     $this->assertEquals($task_per_column + 1, $t->countByColumnId(1, 4));
 }
예제 #2
0
 /**
  * Get all projects, optionaly fetch stats for each project and can check users permissions
  *
  * @access public
  * @param  bool       $fetch_stats          If true, return metrics about each projects
  * @param  bool       $check_permissions    If true, remove projects not allowed for the current user
  * @return array
  */
 public function getAll($fetch_stats = false, $check_permissions = false)
 {
     if (!$fetch_stats) {
         return $this->db->table(self::TABLE)->asc('name')->findAll();
     }
     $this->db->startTransaction();
     $projects = $this->db->table(self::TABLE)->asc('name')->findAll();
     $boardModel = new Board($this->db, $this->event);
     $taskModel = new Task($this->db, $this->event);
     $aclModel = new Acl($this->db, $this->event);
     foreach ($projects as $pkey => &$project) {
         if ($check_permissions && !$this->isUserAllowed($project['id'], $aclModel->getUserId())) {
             unset($projects[$pkey]);
         } else {
             $columns = $boardModel->getcolumns($project['id']);
             $project['nb_active_tasks'] = 0;
             foreach ($columns as &$column) {
                 $column['nb_active_tasks'] = $taskModel->countByColumnId($project['id'], $column['id']);
                 $project['nb_active_tasks'] += $column['nb_active_tasks'];
             }
             $project['columns'] = $columns;
             $project['nb_tasks'] = $taskModel->countByProjectId($project['id']);
             $project['nb_inactive_tasks'] = $project['nb_tasks'] - $project['nb_active_tasks'];
         }
     }
     $this->db->closeTransaction();
     return $projects;
 }