|
<?php |
|
|
|
namespace Kanboard\Model; |
|
|
|
use Kanboard\Core\Base; |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
class ProjectRoleRestrictionModel extends Base |
|
{ |
|
const TABLE = 'project_role_has_restrictions'; |
|
|
|
const RULE_TASK_CREATION = 'task_creation'; |
|
const RULE_TASK_SUPPRESSION = 'task_remove'; |
|
const RULE_TASK_OPEN_CLOSE = 'task_open_close'; |
|
const RULE_TASK_MOVE = 'task_move'; |
|
const RULE_TASK_CHANGE_ASSIGNEE = 'task_change_assignee'; |
|
const RULE_TASK_UPDATE_ASSIGNED = 'task_update_assigned'; |
|
|
|
|
|
|
|
|
|
|
|
|
|
public function getRules() |
|
{ |
|
return array( |
|
self::RULE_TASK_CREATION => t('Task creation is not permitted'), |
|
self::RULE_TASK_SUPPRESSION => t('Task suppression is not permitted'), |
|
self::RULE_TASK_OPEN_CLOSE => t('Closing or opening a task is not permitted'), |
|
self::RULE_TASK_MOVE => t('Moving a task is not permitted'), |
|
self::RULE_TASK_CHANGE_ASSIGNEE => t('Changing assignee is not permitted'), |
|
self::RULE_TASK_UPDATE_ASSIGNED => t('Update only assigned tasks is permitted'), |
|
); |
|
} |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public function getById($project_id, $restriction_id) |
|
{ |
|
return $this->db |
|
->table(self::TABLE) |
|
->eq('project_id', $project_id) |
|
->eq('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', |
|
'rule' |
|
) |
|
->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', |
|
'rule', |
|
'pr.role' |
|
) |
|
->eq(self::TABLE.'.project_id', $project_id) |
|
->eq('role', $role) |
|
->left(ProjectRoleModel::TABLE, 'pr', 'role_id', self::TABLE, 'role_id') |
|
->findAll(); |
|
} |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public function create($project_id, $role_id, $rule) |
|
{ |
|
return $this->db->table(self::TABLE) |
|
->persist(array( |
|
'project_id' => $project_id, |
|
'role_id' => $role_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) { |
|
$result = $this->db->table(self::TABLE)->persist(array( |
|
'project_id' => $project_dst_id, |
|
'role_id' => $role_dst_id, |
|
'rule' => $row['rule'], |
|
)); |
|
|
|
if (! $result) { |
|
return false; |
|
} |
|
} |
|
|
|
return true; |
|
} |
|
} |
|
|