|
<?php |
|
|
|
namespace Kanboard\Model; |
|
|
|
use Kanboard\Core\Base; |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
class ColumnRestrictionModel extends Base |
|
{ |
|
const TABLE = 'column_has_restrictions'; |
|
|
|
const RULE_ALLOW_TASK_CREATION = 'allow.task_creation'; |
|
const RULE_ALLOW_TASK_OPEN_CLOSE = 'allow.task_open_close'; |
|
const RULE_BLOCK_TASK_CREATION = 'block.task_creation'; |
|
const RULE_BLOCK_TASK_OPEN_CLOSE = 'block.task_open_close'; |
|
|
|
|
|
|
|
|
|
|
|
|
|
public function getRules() |
|
{ |
|
return array( |
|
self::RULE_ALLOW_TASK_CREATION => t('Task creation is permitted for this column'), |
|
self::RULE_ALLOW_TASK_OPEN_CLOSE => t('Closing or opening a task is permitted for this column'), |
|
self::RULE_BLOCK_TASK_CREATION => t('Task creation is blocked for this column'), |
|
self::RULE_BLOCK_TASK_OPEN_CLOSE => t('Closing or opening a task is blocked for this column'), |
|
); |
|
} |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public function getById($project_id, $restriction_id) |
|
{ |
|
return $this->db |
|
->table(self::TABLE) |
|
->columns( |
|
'restriction_id', |
|
'project_id', |
|
'role_id', |
|
'column_id', |
|
'rule', |
|
'pr.role', |
|
'c.title as column_title' |
|
) |
|
->left(ColumnModel::TABLE, 'c', 'id', self::TABLE, 'column_id') |
|
->left(ProjectRoleModel::TABLE, 'pr', 'role_id', self::TABLE, 'role_id') |
|
->eq(self::TABLE.'.project_id', $project_id) |
|
->eq(self::TABLE.'.restriction_id', $restriction_id) |
|
->findOne(); |
|
} |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public function getAll($project_id) |
|
{ |
|
$rules = $this->getRules(); |
|
$restrictions = $this->db |
|
->table(self::TABLE) |
|
->columns( |
|
'restriction_id', |
|
'project_id', |
|
'role_id', |
|
'column_id', |
|
'rule', |
|
'pr.role', |
|
'c.title as column_title' |
|
) |
|
->left(ColumnModel::TABLE, 'c', 'id', self::TABLE, 'column_id') |
|
->left(ProjectRoleModel::TABLE, 'pr', 'role_id', self::TABLE, 'role_id') |
|
->eq(self::TABLE.'.project_id', $project_id) |
|
->findAll(); |
|
|
|
foreach ($restrictions as &$restriction) { |
|
$restriction['title'] = $rules[$restriction['rule']]; |
|
} |
|
|
|
return $restrictions; |
|
} |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public function getAllByRole($project_id, $role) |
|
{ |
|
return $this->db |
|
->table(self::TABLE) |
|
->columns( |
|
'restriction_id', |
|
'project_id', |
|
'role_id', |
|
'column_id', |
|
'rule', |
|
'pr.role' |
|
) |
|
->eq(self::TABLE.'.project_id', $project_id) |
|
->eq('pr.role', $role) |
|
->left(ProjectRoleModel::TABLE, 'pr', 'role_id', self::TABLE, 'role_id') |
|
->findAll(); |
|
} |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public function create($project_id, $role_id, $column_id, $rule) |
|
{ |
|
return $this->db |
|
->table(self::TABLE) |
|
->persist(array( |
|
'project_id' => $project_id, |
|
'role_id' => $role_id, |
|
'column_id' => $column_id, |
|
'rule' => $rule, |
|
)); |
|
} |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public function remove($restriction_id) |
|
{ |
|
return $this->db->table(self::TABLE)->eq('restriction_id', $restriction_id)->remove(); |
|
} |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public function duplicate($project_src_id, $project_dst_id, $role_src_id, $role_dst_id) |
|
{ |
|
$rows = $this->db->table(self::TABLE) |
|
->eq('project_id', $project_src_id) |
|
->eq('role_id', $role_src_id) |
|
->findAll(); |
|
|
|
foreach ($rows as $row) { |
|
$column_title = $this->columnModel->getColumnTitleById($row['column_id']); |
|
$dst_column_id = $this->columnModel->getColumnIdByTitle($project_dst_id, $column_title); |
|
|
|
if (! $dst_column_id) { |
|
$this->logger->error("The column $column_title is not present in project $project_dst_id"); |
|
return false; |
|
} |
|
|
|
$result = $this->db->table(self::TABLE)->persist(array( |
|
'project_id' => $project_dst_id, |
|
'role_id' => $role_dst_id, |
|
'column_id' => $dst_column_id, |
|
'rule' => $row['rule'], |
|
)); |
|
|
|
if (! $result) { |
|
return false; |
|
} |
|
} |
|
|
|
return true; |
|
} |
|
} |
|
|