3 namespace Friendica\Repository;
5 use Friendica\BaseRepository;
6 use Friendica\Collection;
7 use Friendica\Database\Database;
9 use Friendica\Model\Group;
10 use Friendica\Network\HTTPException;
11 use Friendica\Util\ACLFormatter;
12 use Psr\Log\LoggerInterface;
14 class PermissionSet extends BaseRepository
16 /** @var int Virtual permission set id for public permission */
19 protected static $table_name = 'permissionset';
21 protected static $model_class = Model\PermissionSet::class;
23 protected static $collection_class = Collection\PermissionSets::class;
25 /** @var ACLFormatter */
26 private $aclFormatter;
28 public function __construct(Database $dba, LoggerInterface $logger, ACLFormatter $aclFormatter)
30 parent::__construct($dba, $logger);
32 $this->aclFormatter = $aclFormatter;
37 * @return Model\PermissionSet
39 protected function create(array $data)
41 return new Model\PermissionSet($this->dba, $this->logger, $data);
45 * @param array $condition
46 * @return Model\PermissionSet
47 * @throws \Friendica\Network\HTTPException\NotFoundException
49 public function selectFirst(array $condition)
51 if (isset($condition['id']) && !$condition['id']) {
52 return $this->create([
54 'uid' => $condition['uid'] ?? 0,
62 return parent::selectFirst($condition);
66 * @param array $condition
67 * @param array $params
68 * @return Collection\PermissionSets
71 public function select(array $condition = [], array $params = [])
73 return parent::select($condition, $params);
77 * @param array $condition
78 * @param array $params
79 * @param int|null $max_id
80 * @param int|null $since_id
82 * @return Collection\PermissionSets
85 public function selectByBoundaries(array $condition = [], array $params = [], int $max_id = null, int $since_id = null, int $limit = self::LIMIT)
87 return parent::selectByBoundaries($condition, $params, $max_id, $since_id, $limit);
91 * Fetch the id of a given permission set. Generate a new one when needed
94 * @param string|null $allow_cid Allowed contact IDs - empty = everyone
95 * @param string|null $allow_gid Allowed group IDs - empty = everyone
96 * @param string|null $deny_cid Disallowed contact IDs - empty = no one
97 * @param string|null $deny_gid Disallowed group IDs - empty = no one
101 public function getIdFromACL(
103 string $allow_cid = null,
104 string $allow_gid = null,
105 string $deny_cid = null,
106 string $deny_gid = null
108 $allow_cid = $this->aclFormatter->sanitize($allow_cid);
109 $allow_gid = $this->aclFormatter->sanitize($allow_gid);
110 $deny_cid = $this->aclFormatter->sanitize($deny_cid);
111 $deny_gid = $this->aclFormatter->sanitize($deny_gid);
114 if (!$allow_cid && !$allow_gid && !$deny_cid && !$deny_gid) {
120 'allow_cid' => $allow_cid,
121 'allow_gid' => $allow_gid,
122 'deny_cid' => $deny_cid,
123 'deny_gid' => $deny_gid
127 $permissionset = $this->selectFirst($condition);
128 } catch(HTTPException\NotFoundException $exception) {
129 $permissionset = $this->insert($condition);
132 return $permissionset->id;
136 * Returns a permission set collection for a given contact
138 * @param integer $contact_id Contact id of the visitor
139 * @param integer $uid User id whom the items belong, used for ownership check.
141 * @return Collection\PermissionSets
144 public function selectByContactId($contact_id, $uid)
147 if ($this->dba->exists('contact', ['id' => $contact_id, 'uid' => $uid, 'blocked' => false])) {
148 $groups = Group::getIdsByContactId($contact_id);
151 $group_str = '<<>>'; // should be impossible to match
152 foreach ($groups as $group_id) {
153 $group_str .= '|<' . preg_quote($group_id) . '>';
156 $contact_str = '<' . $contact_id . '>';
158 $condition = ["`uid` = ? AND (NOT (`deny_cid` REGEXP ? OR deny_gid REGEXP ?)
159 AND (allow_cid REGEXP ? OR allow_gid REGEXP ? OR (allow_cid = '' AND allow_gid = '')))",
160 $uid, $contact_str, $group_str, $contact_str, $group_str];
162 return $this->select($condition);