3 namespace Friendica\Repository;
5 use Friendica\BaseModel;
6 use Friendica\BaseRepository;
7 use Friendica\Collection;
8 use Friendica\Core\L10n;
9 use Friendica\Database\DBA;
12 use Friendica\Model\Group;
13 use Friendica\Network\HTTPException;
15 class PermissionSet extends BaseRepository
17 protected static $table_name = 'permissionset';
19 protected static $model_class = Model\PermissionSet::class;
21 protected static $collection_class = Collection\PermissionSets::class;
25 * @return Model\PermissionSet
27 protected function create(array $data)
29 return new Model\PermissionSet($this->dba, $this->logger, $data);
33 * @param array $condition
34 * @return Model\PermissionSet
35 * @throws \Friendica\Network\HTTPException\NotFoundException
37 public function selectFirst(array $condition)
39 if (isset($condition['id']) && !$condition['id']) {
40 return $this->create([
42 'uid' => $condition['uid'] ?? 0,
50 return parent::selectFirst($condition);
54 * @param array $condition
55 * @param array $params
56 * @return Collection\PermissionSets
59 public function select(array $condition = [], array $params = [])
61 return parent::select($condition, $params);
65 * @param array $condition
66 * @param array $params
67 * @param int|null $max_id
68 * @param int|null $since_id
70 * @return Collection\PermissionSets
73 public function selectByBoundaries(array $condition = [], array $params = [], int $max_id = null, int $since_id = null, int $limit = self::LIMIT)
75 return parent::selectByBoundaries($condition, $params, $max_id, $since_id, $limit);
79 * Fetch the id of a given permission set. Generate a new one when needed
82 * @param string|null $allow_cid Allowed contact IDs - empty = everyone
83 * @param string|null $allow_gid Allowed group IDs - empty = everyone
84 * @param string|null $deny_cid Disallowed contact IDs - empty = no one
85 * @param string|null $deny_gid Disallowed group IDs - empty = no one
89 public function getIdFromACL(
91 string $allow_cid = null,
92 string $allow_gid = null,
93 string $deny_cid = null,
94 string $deny_gid = null
96 $ACLFormatter = DI::aclFormatter();
98 $allow_cid = $ACLFormatter->sanitize($allow_cid);
99 $allow_gid = $ACLFormatter->sanitize($allow_gid);
100 $deny_cid = $ACLFormatter->sanitize($deny_cid);
101 $deny_gid = $ACLFormatter->sanitize($deny_gid);
104 if (!$allow_cid && !$allow_gid && !$deny_cid && !$deny_gid) {
110 'allow_cid' => $allow_cid,
111 'allow_gid' => $allow_gid,
112 'deny_cid' => $deny_cid,
113 'deny_gid' => $deny_gid
117 $permissionset = $this->selectFirst($condition);
118 } catch(HTTPException\NotFoundException $exception) {
119 $permissionset = $this->insert($condition);
122 return $permissionset->id;
126 * Returns a permission set collection for a given contact
128 * @param integer $contact_id Contact id of the visitor
129 * @param integer $uid User id whom the items belong, used for ownership check.
131 * @return Collection\PermissionSets
134 public function selectByContactId($contact_id, $uid)
137 if (DBA::exists('contact', ['id' => $contact_id, 'uid' => $uid, 'blocked' => false])) {
138 $groups = Group::getIdsByContactId($contact_id);
141 $group_str = '<<>>'; // should be impossible to match
142 foreach ($groups as $group_id) {
143 $group_str .= '|<' . preg_quote($group_id) . '>';
146 $contact_str = '<' . $contact_id . '>';
148 $condition = ["`uid` = ? AND (NOT (`deny_cid` REGEXP ? OR deny_gid REGEXP ?)
149 AND (allow_cid REGEXP ? OR allow_gid REGEXP ? OR (allow_cid = '' AND allow_gid = '')))",
150 $uid, $contact_str, $group_str, $contact_str, $group_str];
152 return $this->select($condition);