. * */ namespace Friendica\Security\PermissionSet\Repository; use Exception; use Friendica\BaseRepository; use Friendica\Database\Database; use Friendica\Model\Contact; use Friendica\Model\Group; use Friendica\Network\HTTPException\NotFoundException; use Friendica\Security\PermissionSet\Factory; use Friendica\Security\PermissionSet\Collection; use Friendica\Security\PermissionSet\Entity; use Friendica\Util\ACLFormatter; use Psr\Log\LoggerInterface; class PermissionSet extends BaseRepository { /** @var int Virtual permission set id for public permission */ const PUBLIC = 0; /** @var Factory\PermissionSet */ protected $factory; protected static $table_name = 'permissionset'; /** @var ACLFormatter */ private $aclFormatter; public function __construct(Database $database, LoggerInterface $logger, Factory\PermissionSet $factory, ACLFormatter $aclFormatter) { parent::__construct($database, $logger, $factory); $this->aclFormatter = $aclFormatter; } /** * replaces the PUBLIC id for the public permissionSet * (no need to create the default permission set over and over again) * * @param $condition */ private function checkPublicSelect(&$condition) { if (empty($condition['allow_cid']) && empty($condition['allow_gid']) && empty($condition['deny_cid']) && empty($condition['deny_gid'])) { $condition['uid'] = self::PUBLIC; } } /** * @param array $condition * @param array $params * * @return Entity\PermissionSet * @throws NotFoundException */ private function selectOne(array $condition, array $params = []): Entity\PermissionSet { return parent::_selectOne($condition, $params); } private function select(array $condition, array $params = []): Collection\PermissionSets { return new Collection\PermissionSets(parent::_select($condition, $params)->getArrayCopy()); } /** * Converts a given PermissionSet into a DB compatible row array * * @param Entity\PermissionSet $permissionSet * * @return array */ protected function convertToTableRow(Entity\PermissionSet $permissionSet): array { return [ 'uid' => $permissionSet->uid, 'allow_cid' => $this->aclFormatter->toString($permissionSet->allow_cid), 'allow_gid' => $this->aclFormatter->toString($permissionSet->allow_gid), 'deny_cid' => $this->aclFormatter->toString($permissionSet->deny_cid), 'deny_gid' => $this->aclFormatter->toString($permissionSet->deny_gid), ]; } /** * @param int $id A PermissionSet table row id or self::PUBLIC * @param int $uid The owner of the PermissionSet * @return Entity\PermissionSet * @throws NotFoundException */ public function selectOneById(int $id, int $uid): Entity\PermissionSet { if ($id === self::PUBLIC) { return $this->factory->createFromString($uid); } return $this->selectOne(['id' => $id, 'uid' => $uid]); } /** * Returns a permission set collection for a given contact * * @param int $cid Contact id of the visitor * @param int $uid User id whom the items belong, used for ownership check. * * @return Collection\PermissionSets */ public function selectByContactId(int $cid, int $uid): Collection\PermissionSets { $cdata = Contact::getPublicAndUserContactID($cid, $uid); if (!empty($cdata)) { $public_contact_str = $this->aclFormatter->toString($cdata['public']); $user_contact_str = $this->aclFormatter->toString($cdata['user']); $cid = $cdata['user']; } else { $public_contact_str = $this->aclFormatter->toString($cid); $user_contact_str = ''; } $groups = []; if (!empty($user_contact_str) && $this->db->exists('contact', [ 'id' => $cid, 'uid' => $uid, 'blocked' => false ])) { $groups = Group::getIdsByContactId($cid); } $group_str = '<<>>'; // should be impossible to match foreach ($groups as $group_id) { $group_str .= '|<' . preg_quote($group_id) . '>'; } if (!empty($user_contact_str)) { $condition = ["`uid` = ? AND (NOT (`deny_cid` REGEXP ? OR `deny_cid` REGEXP ? OR deny_gid REGEXP ?) AND (allow_cid REGEXP ? OR allow_cid REGEXP ? OR allow_gid REGEXP ? OR (allow_cid = '' AND allow_gid = '')))", $uid, $user_contact_str, $public_contact_str, $group_str, $user_contact_str, $public_contact_str, $group_str]; } else { $condition = ["`uid` = ? AND (NOT (`deny_cid` REGEXP ? OR deny_gid REGEXP ?) AND (allow_cid REGEXP ? OR allow_gid REGEXP ? OR (allow_cid = '' AND allow_gid = '')))", $uid, $public_contact_str, $group_str, $public_contact_str, $group_str]; } return $this->select($condition); } /** * Fetch the default PermissionSet for a given user, create it if it doesn't exist * * @param int $uid * * @return Entity\PermissionSet * @throws Exception */ public function selectDefaultForUser(int $uid): Entity\PermissionSet { $self_contact = Contact::selectFirst(['id'], ['uid' => $uid, 'self' => true]); return $this->selectOrCreate($this->factory->createFromString( $uid, $this->aclFormatter->toString($self_contact['id']) )); } /** * Fetch the public PermissionSet * * @param int $uid * * @return Entity\PermissionSet */ public function selectPublicForUser(int $uid): Entity\PermissionSet { return $this->factory->createFromString($uid, '', '', '', '', self::PUBLIC); } /** * Selects or creates a PermissionSet based on it's fields * * @param Entity\PermissionSet $permissionSet * * @return Entity\PermissionSet */ public function selectOrCreate(Entity\PermissionSet $permissionSet): Entity\PermissionSet { if ($permissionSet->id) { return $permissionSet; } // Don't select/update Public permission sets if ($permissionSet->isPublic()) { return $this->selectPublicForUser($permissionSet->uid); } try { return $this->selectOne($this->convertToTableRow($permissionSet)); } catch (NotFoundException $exception) { return $this->save($permissionSet); } } /** * @param Entity\PermissionSet $permissionSet * * @return Entity\PermissionSet * @throws NotFoundException */ public function save(Entity\PermissionSet $permissionSet): Entity\PermissionSet { // Don't save/update the common public PermissionSet if ($permissionSet->isPublic()) { return $this->selectPublicForUser($permissionSet->uid); } $fields = $this->convertToTableRow($permissionSet); if ($permissionSet->id) { $this->db->update(self::$table_name, $fields, ['id' => $permissionSet->id]); } else { $this->db->insert(self::$table_name, $fields); $permissionSet = $this->selectOneById($this->db->lastInsertId(), $permissionSet->uid); } return $permissionSet; } }