Dolibarr / dolibarr

htdocs/includes/sabre/sabre/dav/lib/DAVACL/Exception/NeedPrivileges.php

Indentation +43 added lines, -43 removed lines

@@ -18,56 +18,56 @@
  */
 class NeedPrivileges extends DAV\Exception\Forbidden
 {
-    /**
-     * The relevant uri.
-     *
-     * @var string
-     */
-    protected $uri;
+	/**
+	 * The relevant uri.
+	 *
+	 * @var string
+	 */
+	protected $uri;
 
-    /**
-     * The privileges the user didn't have.
-     *
-     * @var array
-     */
-    protected $privileges;
+	/**
+	 * The privileges the user didn't have.
+	 *
+	 * @var array
+	 */
+	protected $privileges;
 
-    /**
-     * Constructor.
-     *
-     * @param string $uri
-     */
-    public function __construct($uri, array $privileges)
-    {
-        $this->uri = $uri;
-        $this->privileges = $privileges;
+	/**
+	 * Constructor.
+	 *
+	 * @param string $uri
+	 */
+	public function __construct($uri, array $privileges)
+	{
+		$this->uri = $uri;
+		$this->privileges = $privileges;
 
-        parent::__construct('User did not have the required privileges ('.implode(',', $privileges).') for path "'.$uri.'"');
-    }
+		parent::__construct('User did not have the required privileges ('.implode(',', $privileges).') for path "'.$uri.'"');
+	}
 
-    /**
-     * Adds in extra information in the xml response.
-     *
-     * This method adds the {DAV:}need-privileges element as defined in rfc3744
-     */
-    public function serialize(DAV\Server $server, \DOMElement $errorNode)
-    {
-        $doc = $errorNode->ownerDocument;
+	/**
+	 * Adds in extra information in the xml response.
+	 *
+	 * This method adds the {DAV:}need-privileges element as defined in rfc3744
+	 */
+	public function serialize(DAV\Server $server, \DOMElement $errorNode)
+	{
+		$doc = $errorNode->ownerDocument;
 
-        $np = $doc->createElementNS('DAV:', 'd:need-privileges');
-        $errorNode->appendChild($np);
+		$np = $doc->createElementNS('DAV:', 'd:need-privileges');
+		$errorNode->appendChild($np);
 
-        foreach ($this->privileges as $privilege) {
-            $resource = $doc->createElementNS('DAV:', 'd:resource');
-            $np->appendChild($resource);
+		foreach ($this->privileges as $privilege) {
+			$resource = $doc->createElementNS('DAV:', 'd:resource');
+			$np->appendChild($resource);
 
-            $resource->appendChild($doc->createElementNS('DAV:', 'd:href', $server->getBaseUri().$this->uri));
+			$resource->appendChild($doc->createElementNS('DAV:', 'd:href', $server->getBaseUri().$this->uri));
 
-            $priv = $doc->createElementNS('DAV:', 'd:privilege');
-            $resource->appendChild($priv);
+			$priv = $doc->createElementNS('DAV:', 'd:privilege');
+			$resource->appendChild($priv);
 
-            preg_match('/^{([^}]*)}(.*)$/', $privilege, $privilegeParts);
-            $priv->appendChild($doc->createElementNS($privilegeParts[1], 'd:'.$privilegeParts[2]));
-        }
-    }
+			preg_match('/^{([^}]*)}(.*)$/', $privilege, $privilegeParts);
+			$priv->appendChild($doc->createElementNS($privilegeParts[1], 'd:'.$privilegeParts[2]));
+		}
+	}
 }

htdocs/includes/sabre/sabre/dav/lib/DAVACL/IPrincipalCollection.php

Indentation +42 added lines, -42 removed lines

@@ -18,47 +18,47 @@
  */
 interface IPrincipalCollection extends DAV\ICollection
 {
-    /**
-     * This method is used to search for principals matching a set of
-     * properties.
-     *
-     * This search is specifically used by RFC3744's principal-property-search
-     * REPORT. You should at least allow searching on
-     * http://sabredav.org/ns}email-address.
-     *
-     * The actual search should be a unicode-non-case-sensitive search. The
-     * keys in searchProperties are the WebDAV property names, while the values
-     * are the property values to search on.
-     *
-     * By default, if multiple properties are submitted to this method, the
-     * various properties should be combined with 'AND'. If $test is set to
-     * 'anyof', it should be combined using 'OR'.
-     *
-     * This method should simply return a list of 'child names', which may be
-     * used to call $this->getChild in the future.
-     *
-     * @param string $test
-     *
-     * @return array
-     */
-    public function searchPrincipals(array $searchProperties, $test = 'allof');
+	/**
+	 * This method is used to search for principals matching a set of
+	 * properties.
+	 *
+	 * This search is specifically used by RFC3744's principal-property-search
+	 * REPORT. You should at least allow searching on
+	 * http://sabredav.org/ns}email-address.
+	 *
+	 * The actual search should be a unicode-non-case-sensitive search. The
+	 * keys in searchProperties are the WebDAV property names, while the values
+	 * are the property values to search on.
+	 *
+	 * By default, if multiple properties are submitted to this method, the
+	 * various properties should be combined with 'AND'. If $test is set to
+	 * 'anyof', it should be combined using 'OR'.
+	 *
+	 * This method should simply return a list of 'child names', which may be
+	 * used to call $this->getChild in the future.
+	 *
+	 * @param string $test
+	 *
+	 * @return array
+	 */
+	public function searchPrincipals(array $searchProperties, $test = 'allof');
 
-    /**
-     * Finds a principal by its URI.
-     *
-     * This method may receive any type of uri, but mailto: addresses will be
-     * the most common.
-     *
-     * Implementation of this API is optional. It is currently used by the
-     * CalDAV system to find principals based on their email addresses. If this
-     * API is not implemented, some features may not work correctly.
-     *
-     * This method must return a relative principal path, or null, if the
-     * principal was not found or you refuse to find it.
-     *
-     * @param string $uri
-     *
-     * @return string
-     */
-    public function findByUri($uri);
+	/**
+	 * Finds a principal by its URI.
+	 *
+	 * This method may receive any type of uri, but mailto: addresses will be
+	 * the most common.
+	 *
+	 * Implementation of this API is optional. It is currently used by the
+	 * CalDAV system to find principals based on their email addresses. If this
+	 * API is not implemented, some features may not work correctly.
+	 *
+	 * This method must return a relative principal path, or null, if the
+	 * principal was not found or you refuse to find it.
+	 *
+	 * @param string $uri
+	 *
+	 * @return string
+	 */
+	public function findByUri($uri);
 }

htdocs/includes/sabre/sabre/dav/lib/DAVACL/PrincipalBackend/CreatePrincipalSupport.php

Indentation +10 added lines, -10 removed lines

@@ -16,14 +16,14 @@
  */
 interface CreatePrincipalSupport extends BackendInterface
 {
-    /**
-     * Creates a new principal.
-     *
-     * This method receives a full path for the new principal. The mkCol object
-     * contains any additional webdav properties specified during the creation
-     * of the principal.
-     *
-     * @param string $path
-     */
-    public function createPrincipal($path, MkCol $mkCol);
+	/**
+	 * Creates a new principal.
+	 *
+	 * This method receives a full path for the new principal. The mkCol object
+	 * contains any additional webdav properties specified during the creation
+	 * of the principal.
+	 *
+	 * @param string $path
+	 */
+	public function createPrincipal($path, MkCol $mkCol);
 }

htdocs/includes/sabre/sabre/dav/lib/DAVACL/PrincipalBackend/AbstractBackend.php

Indentation +33 added lines, -33 removed lines

@@ -17,38 +17,38 @@
  */
 abstract class AbstractBackend implements BackendInterface
 {
-    /**
-     * Finds a principal by its URI.
-     *
-     * This method may receive any type of uri, but mailto: addresses will be
-     * the most common.
-     *
-     * Implementation of this API is optional. It is currently used by the
-     * CalDAV system to find principals based on their email addresses. If this
-     * API is not implemented, some features may not work correctly.
-     *
-     * This method must return a relative principal path, or null, if the
-     * principal was not found or you refuse to find it.
-     *
-     * @param string $uri
-     * @param string $principalPrefix
-     *
-     * @return string|null
-     */
-    public function findByUri($uri, $principalPrefix)
-    {
-        // Note that the default implementation here is a bit slow and could
-        // likely be optimized.
-        if ('mailto:' !== substr($uri, 0, 7)) {
-            return;
-        }
-        $result = $this->searchPrincipals(
-            $principalPrefix,
-            ['{http://sabredav.org/ns}email-address' => substr($uri, 7)]
-        );
+	/**
+	 * Finds a principal by its URI.
+	 *
+	 * This method may receive any type of uri, but mailto: addresses will be
+	 * the most common.
+	 *
+	 * Implementation of this API is optional. It is currently used by the
+	 * CalDAV system to find principals based on their email addresses. If this
+	 * API is not implemented, some features may not work correctly.
+	 *
+	 * This method must return a relative principal path, or null, if the
+	 * principal was not found or you refuse to find it.
+	 *
+	 * @param string $uri
+	 * @param string $principalPrefix
+	 *
+	 * @return string|null
+	 */
+	public function findByUri($uri, $principalPrefix)
+	{
+		// Note that the default implementation here is a bit slow and could
+		// likely be optimized.
+		if ('mailto:' !== substr($uri, 0, 7)) {
+			return;
+		}
+		$result = $this->searchPrincipals(
+			$principalPrefix,
+			['{http://sabredav.org/ns}email-address' => substr($uri, 7)]
+		);
 
-        if ($result) {
-            return $result[0];
-        }
-    }
+		if ($result) {
+			return $result[0];
+		}
+	}
 }

htdocs/includes/sabre/sabre/dav/lib/DAVACL/PrincipalBackend/PDO.php

Indentation +415 added lines, -415 removed lines

@@ -20,424 +20,424 @@
  */
 class PDO extends AbstractBackend implements CreatePrincipalSupport
 {
-    /**
-     * PDO table name for 'principals'.
-     *
-     * @var string
-     */
-    public $tableName = 'principals';
-
-    /**
-     * PDO table name for 'group members'.
-     *
-     * @var string
-     */
-    public $groupMembersTableName = 'groupmembers';
-
-    /**
-     * pdo.
-     *
-     * @var PDO
-     */
-    protected $pdo;
-
-    /**
-     * A list of additional fields to support.
-     *
-     * @var array
-     */
-    protected $fieldMap = [
-        /*
+	/**
+	 * PDO table name for 'principals'.
+	 *
+	 * @var string
+	 */
+	public $tableName = 'principals';
+
+	/**
+	 * PDO table name for 'group members'.
+	 *
+	 * @var string
+	 */
+	public $groupMembersTableName = 'groupmembers';
+
+	/**
+	 * pdo.
+	 *
+	 * @var PDO
+	 */
+	protected $pdo;
+
+	/**
+	 * A list of additional fields to support.
+	 *
+	 * @var array
+	 */
+	protected $fieldMap = [
+		/*
          * This property can be used to display the users' real name.
          */
-        '{DAV:}displayname' => [
-            'dbField' => 'displayname',
-        ],
+		'{DAV:}displayname' => [
+			'dbField' => 'displayname',
+		],
 
-        /*
+		/*
          * This is the users' primary email-address.
          */
-        '{http://sabredav.org/ns}email-address' => [
-            'dbField' => 'email',
-        ],
-    ];
-
-    /**
-     * Sets up the backend.
-     */
-    public function __construct(\PDO $pdo)
-    {
-        $this->pdo = $pdo;
-    }
-
-    /**
-     * Returns a list of principals based on a prefix.
-     *
-     * This prefix will often contain something like 'principals'. You are only
-     * expected to return principals that are in this base path.
-     *
-     * You are expected to return at least a 'uri' for every user, you can
-     * return any additional properties if you wish so. Common properties are:
-     *   {DAV:}displayname
-     *   {http://sabredav.org/ns}email-address - This is a custom SabreDAV
-     *     field that's actualy injected in a number of other properties. If
-     *     you have an email address, use this property.
-     *
-     * @param string $prefixPath
-     *
-     * @return array
-     */
-    public function getPrincipalsByPrefix($prefixPath)
-    {
-        $fields = [
-            'uri',
-        ];
-
-        foreach ($this->fieldMap as $key => $value) {
-            $fields[] = $value['dbField'];
-        }
-        $result = $this->pdo->query('SELECT '.implode(',', $fields).'  FROM '.$this->tableName);
-
-        $principals = [];
-
-        while ($row = $result->fetch(\PDO::FETCH_ASSOC)) {
-            // Checking if the principal is in the prefix
-            list($rowPrefix) = Uri\split($row['uri']);
-            if ($rowPrefix !== $prefixPath) {
-                continue;
-            }
-
-            $principal = [
-                'uri' => $row['uri'],
-            ];
-            foreach ($this->fieldMap as $key => $value) {
-                if ($row[$value['dbField']]) {
-                    $principal[$key] = $row[$value['dbField']];
-                }
-            }
-            $principals[] = $principal;
-        }
-
-        return $principals;
-    }
-
-    /**
-     * Returns a specific principal, specified by it's path.
-     * The returned structure should be the exact same as from
-     * getPrincipalsByPrefix.
-     *
-     * @param string $path
-     *
-     * @return array
-     */
-    public function getPrincipalByPath($path)
-    {
-        $fields = [
-            'id',
-            'uri',
-        ];
-
-        foreach ($this->fieldMap as $key => $value) {
-            $fields[] = $value['dbField'];
-        }
-        $stmt = $this->pdo->prepare('SELECT '.implode(',', $fields).'  FROM '.$this->tableName.' WHERE uri = ?');
-        $stmt->execute([$path]);
-
-        $row = $stmt->fetch(\PDO::FETCH_ASSOC);
-        if (!$row) {
-            return;
-        }
-
-        $principal = [
-            'id' => $row['id'],
-            'uri' => $row['uri'],
-        ];
-        foreach ($this->fieldMap as $key => $value) {
-            if ($row[$value['dbField']]) {
-                $principal[$key] = $row[$value['dbField']];
-            }
-        }
-
-        return $principal;
-    }
-
-    /**
-     * Updates one ore more webdav properties on a principal.
-     *
-     * The list of mutations is stored in a Sabre\DAV\PropPatch object.
-     * To do the actual updates, you must tell this object which properties
-     * you're going to process with the handle() method.
-     *
-     * Calling the handle method is like telling the PropPatch object "I
-     * promise I can handle updating this property".
-     *
-     * Read the PropPatch documentation for more info and examples.
-     *
-     * @param string $path
-     */
-    public function updatePrincipal($path, DAV\PropPatch $propPatch)
-    {
-        $propPatch->handle(array_keys($this->fieldMap), function ($properties) use ($path) {
-            $query = 'UPDATE '.$this->tableName.' SET ';
-            $first = true;
-
-            $values = [];
-
-            foreach ($properties as $key => $value) {
-                $dbField = $this->fieldMap[$key]['dbField'];
-
-                if (!$first) {
-                    $query .= ', ';
-                }
-                $first = false;
-                $query .= $dbField.' = :'.$dbField;
-                $values[$dbField] = $value;
-            }
-
-            $query .= ' WHERE uri = :uri';
-            $values['uri'] = $path;
-
-            $stmt = $this->pdo->prepare($query);
-            $stmt->execute($values);
-
-            return true;
-        });
-    }
-
-    /**
-     * This method is used to search for principals matching a set of
-     * properties.
-     *
-     * This search is specifically used by RFC3744's principal-property-search
-     * REPORT.
-     *
-     * The actual search should be a unicode-non-case-sensitive search. The
-     * keys in searchProperties are the WebDAV property names, while the values
-     * are the property values to search on.
-     *
-     * By default, if multiple properties are submitted to this method, the
-     * various properties should be combined with 'AND'. If $test is set to
-     * 'anyof', it should be combined using 'OR'.
-     *
-     * This method should simply return an array with full principal uri's.
-     *
-     * If somebody attempted to search on a property the backend does not
-     * support, you should simply return 0 results.
-     *
-     * You can also just return 0 results if you choose to not support
-     * searching at all, but keep in mind that this may stop certain features
-     * from working.
-     *
-     * @param string $prefixPath
-     * @param string $test
-     *
-     * @return array
-     */
-    public function searchPrincipals($prefixPath, array $searchProperties, $test = 'allof')
-    {
-        if (0 == count($searchProperties)) {
-            return [];
-        }    //No criteria
-
-        $query = 'SELECT uri FROM '.$this->tableName.' WHERE ';
-        $values = [];
-        foreach ($searchProperties as $property => $value) {
-            switch ($property) {
-                case '{DAV:}displayname':
-                    $column = 'displayname';
-                    break;
-                case '{http://sabredav.org/ns}email-address':
-                    $column = 'email';
-                    break;
-                default:
-                    // Unsupported property
-                    return [];
-            }
-            if (count($values) > 0) {
-                $query .= (0 == strcmp($test, 'anyof') ? ' OR ' : ' AND ');
-            }
-            $query .= 'lower('.$column.') LIKE lower(?)';
-            $values[] = '%'.$value.'%';
-        }
-        $stmt = $this->pdo->prepare($query);
-        $stmt->execute($values);
-
-        $principals = [];
-        while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
-            // Checking if the principal is in the prefix
-            list($rowPrefix) = Uri\split($row['uri']);
-            if ($rowPrefix !== $prefixPath) {
-                continue;
-            }
-
-            $principals[] = $row['uri'];
-        }
-
-        return $principals;
-    }
-
-    /**
-     * Finds a principal by its URI.
-     *
-     * This method may receive any type of uri, but mailto: addresses will be
-     * the most common.
-     *
-     * Implementation of this API is optional. It is currently used by the
-     * CalDAV system to find principals based on their email addresses. If this
-     * API is not implemented, some features may not work correctly.
-     *
-     * This method must return a relative principal path, or null, if the
-     * principal was not found or you refuse to find it.
-     *
-     * @param string $uri
-     * @param string $principalPrefix
-     *
-     * @return string
-     */
-    public function findByUri($uri, $principalPrefix)
-    {
-        $uriParts = Uri\parse($uri);
-
-        // Only two types of uri are supported :
-        //   - the "mailto:" scheme with some non-empty address
-        //   - a principals uri, in the form "principals/NAME"
-        // In both cases, `path` must not be empty.
-        if (empty($uriParts['path'])) {
-            return null;
-        }
-
-        $uri = null;
-        if ('mailto' === $uriParts['scheme']) {
-            $query = 'SELECT uri FROM '.$this->tableName.' WHERE lower(email)=lower(?)';
-            $stmt = $this->pdo->prepare($query);
-            $stmt->execute([$uriParts['path']]);
-
-            while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
-                // Checking if the principal is in the prefix
-                list($rowPrefix) = Uri\split($row['uri']);
-                if ($rowPrefix !== $principalPrefix) {
-                    continue;
-                }
-
-                $uri = $row['uri'];
-                break; //Stop on first match
-            }
-        } else {
-            $pathParts = Uri\split($uriParts['path']); // We can do this since $uriParts['path'] is not null
-
-            if (2 === count($pathParts) && $pathParts[0] === $principalPrefix) {
-                // Checking that this uri exists
-                $query = 'SELECT * FROM '.$this->tableName.' WHERE uri = ?';
-                $stmt = $this->pdo->prepare($query);
-                $stmt->execute([$uriParts['path']]);
-                $rows = $stmt->fetchAll();
-
-                if (count($rows) > 0) {
-                    $uri = $uriParts['path'];
-                }
-            }
-        }
-
-        return $uri;
-    }
-
-    /**
-     * Returns the list of members for a group-principal.
-     *
-     * @param string $principal
-     *
-     * @return array
-     */
-    public function getGroupMemberSet($principal)
-    {
-        $principal = $this->getPrincipalByPath($principal);
-        if (!$principal) {
-            throw new DAV\Exception('Principal not found');
-        }
-        $stmt = $this->pdo->prepare('SELECT principals.uri as uri FROM '.$this->groupMembersTableName.' AS groupmembers LEFT JOIN '.$this->tableName.' AS principals ON groupmembers.member_id = principals.id WHERE groupmembers.principal_id = ?');
-        $stmt->execute([$principal['id']]);
-
-        $result = [];
-        while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
-            $result[] = $row['uri'];
-        }
-
-        return $result;
-    }
-
-    /**
-     * Returns the list of groups a principal is a member of.
-     *
-     * @param string $principal
-     *
-     * @return array
-     */
-    public function getGroupMembership($principal)
-    {
-        $principal = $this->getPrincipalByPath($principal);
-        if (!$principal) {
-            throw new DAV\Exception('Principal not found');
-        }
-        $stmt = $this->pdo->prepare('SELECT principals.uri as uri FROM '.$this->groupMembersTableName.' AS groupmembers LEFT JOIN '.$this->tableName.' AS principals ON groupmembers.principal_id = principals.id WHERE groupmembers.member_id = ?');
-        $stmt->execute([$principal['id']]);
-
-        $result = [];
-        while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
-            $result[] = $row['uri'];
-        }
-
-        return $result;
-    }
-
-    /**
-     * Updates the list of group members for a group principal.
-     *
-     * The principals should be passed as a list of uri's.
-     *
-     * @param string $principal
-     */
-    public function setGroupMemberSet($principal, array $members)
-    {
-        // Grabbing the list of principal id's.
-        $stmt = $this->pdo->prepare('SELECT id, uri FROM '.$this->tableName.' WHERE uri IN (? '.str_repeat(', ? ', count($members)).');');
-        $stmt->execute(array_merge([$principal], $members));
-
-        $memberIds = [];
-        $principalId = null;
-
-        while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
-            if ($row['uri'] == $principal) {
-                $principalId = $row['id'];
-            } else {
-                $memberIds[] = $row['id'];
-            }
-        }
-        if (!$principalId) {
-            throw new DAV\Exception('Principal not found');
-        }
-        // Wiping out old members
-        $stmt = $this->pdo->prepare('DELETE FROM '.$this->groupMembersTableName.' WHERE principal_id = ?;');
-        $stmt->execute([$principalId]);
-
-        foreach ($memberIds as $memberId) {
-            $stmt = $this->pdo->prepare('INSERT INTO '.$this->groupMembersTableName.' (principal_id, member_id) VALUES (?, ?);');
-            $stmt->execute([$principalId, $memberId]);
-        }
-    }
-
-    /**
-     * Creates a new principal.
-     *
-     * This method receives a full path for the new principal. The mkCol object
-     * contains any additional webdav properties specified during the creation
-     * of the principal.
-     *
-     * @param string $path
-     */
-    public function createPrincipal($path, MkCol $mkCol)
-    {
-        $stmt = $this->pdo->prepare('INSERT INTO '.$this->tableName.' (uri) VALUES (?)');
-        $stmt->execute([$path]);
-        $this->updatePrincipal($path, $mkCol);
-    }
+		'{http://sabredav.org/ns}email-address' => [
+			'dbField' => 'email',
+		],
+	];
+
+	/**
+	 * Sets up the backend.
+	 */
+	public function __construct(\PDO $pdo)
+	{
+		$this->pdo = $pdo;
+	}
+
+	/**
+	 * Returns a list of principals based on a prefix.
+	 *
+	 * This prefix will often contain something like 'principals'. You are only
+	 * expected to return principals that are in this base path.
+	 *
+	 * You are expected to return at least a 'uri' for every user, you can
+	 * return any additional properties if you wish so. Common properties are:
+	 *   {DAV:}displayname
+	 *   {http://sabredav.org/ns}email-address - This is a custom SabreDAV
+	 *     field that's actualy injected in a number of other properties. If
+	 *     you have an email address, use this property.
+	 *
+	 * @param string $prefixPath
+	 *
+	 * @return array
+	 */
+	public function getPrincipalsByPrefix($prefixPath)
+	{
+		$fields = [
+			'uri',
+		];
+
+		foreach ($this->fieldMap as $key => $value) {
+			$fields[] = $value['dbField'];
+		}
+		$result = $this->pdo->query('SELECT '.implode(',', $fields).'  FROM '.$this->tableName);
+
+		$principals = [];
+
+		while ($row = $result->fetch(\PDO::FETCH_ASSOC)) {
+			// Checking if the principal is in the prefix
+			list($rowPrefix) = Uri\split($row['uri']);
+			if ($rowPrefix !== $prefixPath) {
+				continue;
+			}
+
+			$principal = [
+				'uri' => $row['uri'],
+			];
+			foreach ($this->fieldMap as $key => $value) {
+				if ($row[$value['dbField']]) {
+					$principal[$key] = $row[$value['dbField']];
+				}
+			}
+			$principals[] = $principal;
+		}
+
+		return $principals;
+	}
+
+	/**
+	 * Returns a specific principal, specified by it's path.
+	 * The returned structure should be the exact same as from
+	 * getPrincipalsByPrefix.
+	 *
+	 * @param string $path
+	 *
+	 * @return array
+	 */
+	public function getPrincipalByPath($path)
+	{
+		$fields = [
+			'id',
+			'uri',
+		];
+
+		foreach ($this->fieldMap as $key => $value) {
+			$fields[] = $value['dbField'];
+		}
+		$stmt = $this->pdo->prepare('SELECT '.implode(',', $fields).'  FROM '.$this->tableName.' WHERE uri = ?');
+		$stmt->execute([$path]);
+
+		$row = $stmt->fetch(\PDO::FETCH_ASSOC);
+		if (!$row) {
+			return;
+		}
+
+		$principal = [
+			'id' => $row['id'],
+			'uri' => $row['uri'],
+		];
+		foreach ($this->fieldMap as $key => $value) {
+			if ($row[$value['dbField']]) {
+				$principal[$key] = $row[$value['dbField']];
+			}
+		}
+
+		return $principal;
+	}
+
+	/**
+	 * Updates one ore more webdav properties on a principal.
+	 *
+	 * The list of mutations is stored in a Sabre\DAV\PropPatch object.
+	 * To do the actual updates, you must tell this object which properties
+	 * you're going to process with the handle() method.
+	 *
+	 * Calling the handle method is like telling the PropPatch object "I
+	 * promise I can handle updating this property".
+	 *
+	 * Read the PropPatch documentation for more info and examples.
+	 *
+	 * @param string $path
+	 */
+	public function updatePrincipal($path, DAV\PropPatch $propPatch)
+	{
+		$propPatch->handle(array_keys($this->fieldMap), function ($properties) use ($path) {
+			$query = 'UPDATE '.$this->tableName.' SET ';
+			$first = true;
+
+			$values = [];
+
+			foreach ($properties as $key => $value) {
+				$dbField = $this->fieldMap[$key]['dbField'];
+
+				if (!$first) {
+					$query .= ', ';
+				}
+				$first = false;
+				$query .= $dbField.' = :'.$dbField;
+				$values[$dbField] = $value;
+			}
+
+			$query .= ' WHERE uri = :uri';
+			$values['uri'] = $path;
+
+			$stmt = $this->pdo->prepare($query);
+			$stmt->execute($values);
+
+			return true;
+		});
+	}
+
+	/**
+	 * This method is used to search for principals matching a set of
+	 * properties.
+	 *
+	 * This search is specifically used by RFC3744's principal-property-search
+	 * REPORT.
+	 *
+	 * The actual search should be a unicode-non-case-sensitive search. The
+	 * keys in searchProperties are the WebDAV property names, while the values
+	 * are the property values to search on.
+	 *
+	 * By default, if multiple properties are submitted to this method, the
+	 * various properties should be combined with 'AND'. If $test is set to
+	 * 'anyof', it should be combined using 'OR'.
+	 *
+	 * This method should simply return an array with full principal uri's.
+	 *
+	 * If somebody attempted to search on a property the backend does not
+	 * support, you should simply return 0 results.
+	 *
+	 * You can also just return 0 results if you choose to not support
+	 * searching at all, but keep in mind that this may stop certain features
+	 * from working.
+	 *
+	 * @param string $prefixPath
+	 * @param string $test
+	 *
+	 * @return array
+	 */
+	public function searchPrincipals($prefixPath, array $searchProperties, $test = 'allof')
+	{
+		if (0 == count($searchProperties)) {
+			return [];
+		}    //No criteria
+
+		$query = 'SELECT uri FROM '.$this->tableName.' WHERE ';
+		$values = [];
+		foreach ($searchProperties as $property => $value) {
+			switch ($property) {
+				case '{DAV:}displayname':
+					$column = 'displayname';
+					break;
+				case '{http://sabredav.org/ns}email-address':
+					$column = 'email';
+					break;
+				default:
+					// Unsupported property
+					return [];
+			}
+			if (count($values) > 0) {
+				$query .= (0 == strcmp($test, 'anyof') ? ' OR ' : ' AND ');
+			}
+			$query .= 'lower('.$column.') LIKE lower(?)';
+			$values[] = '%'.$value.'%';
+		}
+		$stmt = $this->pdo->prepare($query);
+		$stmt->execute($values);
+
+		$principals = [];
+		while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
+			// Checking if the principal is in the prefix
+			list($rowPrefix) = Uri\split($row['uri']);
+			if ($rowPrefix !== $prefixPath) {
+				continue;
+			}
+
+			$principals[] = $row['uri'];
+		}
+
+		return $principals;
+	}
+
+	/**
+	 * Finds a principal by its URI.
+	 *
+	 * This method may receive any type of uri, but mailto: addresses will be
+	 * the most common.
+	 *
+	 * Implementation of this API is optional. It is currently used by the
+	 * CalDAV system to find principals based on their email addresses. If this
+	 * API is not implemented, some features may not work correctly.
+	 *
+	 * This method must return a relative principal path, or null, if the
+	 * principal was not found or you refuse to find it.
+	 *
+	 * @param string $uri
+	 * @param string $principalPrefix
+	 *
+	 * @return string
+	 */
+	public function findByUri($uri, $principalPrefix)
+	{
+		$uriParts = Uri\parse($uri);
+
+		// Only two types of uri are supported :
+		//   - the "mailto:" scheme with some non-empty address
+		//   - a principals uri, in the form "principals/NAME"
+		// In both cases, `path` must not be empty.
+		if (empty($uriParts['path'])) {
+			return null;
+		}
+
+		$uri = null;
+		if ('mailto' === $uriParts['scheme']) {
+			$query = 'SELECT uri FROM '.$this->tableName.' WHERE lower(email)=lower(?)';
+			$stmt = $this->pdo->prepare($query);
+			$stmt->execute([$uriParts['path']]);
+
+			while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
+				// Checking if the principal is in the prefix
+				list($rowPrefix) = Uri\split($row['uri']);
+				if ($rowPrefix !== $principalPrefix) {
+					continue;
+				}
+
+				$uri = $row['uri'];
+				break; //Stop on first match
+			}
+		} else {
+			$pathParts = Uri\split($uriParts['path']); // We can do this since $uriParts['path'] is not null
+
+			if (2 === count($pathParts) && $pathParts[0] === $principalPrefix) {
+				// Checking that this uri exists
+				$query = 'SELECT * FROM '.$this->tableName.' WHERE uri = ?';
+				$stmt = $this->pdo->prepare($query);
+				$stmt->execute([$uriParts['path']]);
+				$rows = $stmt->fetchAll();
+
+				if (count($rows) > 0) {
+					$uri = $uriParts['path'];
+				}
+			}
+		}
+
+		return $uri;
+	}
+
+	/**
+	 * Returns the list of members for a group-principal.
+	 *
+	 * @param string $principal
+	 *
+	 * @return array
+	 */
+	public function getGroupMemberSet($principal)
+	{
+		$principal = $this->getPrincipalByPath($principal);
+		if (!$principal) {
+			throw new DAV\Exception('Principal not found');
+		}
+		$stmt = $this->pdo->prepare('SELECT principals.uri as uri FROM '.$this->groupMembersTableName.' AS groupmembers LEFT JOIN '.$this->tableName.' AS principals ON groupmembers.member_id = principals.id WHERE groupmembers.principal_id = ?');
+		$stmt->execute([$principal['id']]);
+
+		$result = [];
+		while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
+			$result[] = $row['uri'];
+		}
+
+		return $result;
+	}
+
+	/**
+	 * Returns the list of groups a principal is a member of.
+	 *
+	 * @param string $principal
+	 *
+	 * @return array
+	 */
+	public function getGroupMembership($principal)
+	{
+		$principal = $this->getPrincipalByPath($principal);
+		if (!$principal) {
+			throw new DAV\Exception('Principal not found');
+		}
+		$stmt = $this->pdo->prepare('SELECT principals.uri as uri FROM '.$this->groupMembersTableName.' AS groupmembers LEFT JOIN '.$this->tableName.' AS principals ON groupmembers.principal_id = principals.id WHERE groupmembers.member_id = ?');
+		$stmt->execute([$principal['id']]);
+
+		$result = [];
+		while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
+			$result[] = $row['uri'];
+		}
+
+		return $result;
+	}
+
+	/**
+	 * Updates the list of group members for a group principal.
+	 *
+	 * The principals should be passed as a list of uri's.
+	 *
+	 * @param string $principal
+	 */
+	public function setGroupMemberSet($principal, array $members)
+	{
+		// Grabbing the list of principal id's.
+		$stmt = $this->pdo->prepare('SELECT id, uri FROM '.$this->tableName.' WHERE uri IN (? '.str_repeat(', ? ', count($members)).');');
+		$stmt->execute(array_merge([$principal], $members));
+
+		$memberIds = [];
+		$principalId = null;
+
+		while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
+			if ($row['uri'] == $principal) {
+				$principalId = $row['id'];
+			} else {
+				$memberIds[] = $row['id'];
+			}
+		}
+		if (!$principalId) {
+			throw new DAV\Exception('Principal not found');
+		}
+		// Wiping out old members
+		$stmt = $this->pdo->prepare('DELETE FROM '.$this->groupMembersTableName.' WHERE principal_id = ?;');
+		$stmt->execute([$principalId]);
+
+		foreach ($memberIds as $memberId) {
+			$stmt = $this->pdo->prepare('INSERT INTO '.$this->groupMembersTableName.' (principal_id, member_id) VALUES (?, ?);');
+			$stmt->execute([$principalId, $memberId]);
+		}
+	}
+
+	/**
+	 * Creates a new principal.
+	 *
+	 * This method receives a full path for the new principal. The mkCol object
+	 * contains any additional webdav properties specified during the creation
+	 * of the principal.
+	 *
+	 * @param string $path
+	 */
+	public function createPrincipal($path, MkCol $mkCol)
+	{
+		$stmt = $this->pdo->prepare('INSERT INTO '.$this->tableName.' (uri) VALUES (?)');
+		$stmt->execute([$path]);
+		$this->updatePrincipal($path, $mkCol);
+	}
 }

Spacing +1 added lines, -1 removed lines

@@ -177,7 +177,7 @@
      */
     public function updatePrincipal($path, DAV\PropPatch $propPatch)
     {
-        $propPatch->handle(array_keys($this->fieldMap), function ($properties) use ($path) {
+        $propPatch->handle(array_keys($this->fieldMap), function($properties) use ($path) {
             $query = 'UPDATE '.$this->tableName.' SET ';
             $first = true;
 

htdocs/includes/sabre/sabre/dav/lib/DAVACL/PrincipalCollection.php

Indentation +69 added lines, -69 removed lines

@@ -20,77 +20,77 @@
  */
 class PrincipalCollection extends AbstractPrincipalCollection implements IExtendedCollection, IACL
 {
-    use ACLTrait;
+	use ACLTrait;
 
-    /**
-     * This method returns a node for a principal.
-     *
-     * The passed array contains principal information, and is guaranteed to
-     * at least contain a uri item. Other properties may or may not be
-     * supplied by the authentication backend.
-     *
-     * @return \Sabre\DAV\INode
-     */
-    public function getChildForPrincipal(array $principal)
-    {
-        return new Principal($this->principalBackend, $principal);
-    }
+	/**
+	 * This method returns a node for a principal.
+	 *
+	 * The passed array contains principal information, and is guaranteed to
+	 * at least contain a uri item. Other properties may or may not be
+	 * supplied by the authentication backend.
+	 *
+	 * @return \Sabre\DAV\INode
+	 */
+	public function getChildForPrincipal(array $principal)
+	{
+		return new Principal($this->principalBackend, $principal);
+	}
 
-    /**
-     * Creates a new collection.
-     *
-     * This method will receive a MkCol object with all the information about
-     * the new collection that's being created.
-     *
-     * The MkCol object contains information about the resourceType of the new
-     * collection. If you don't support the specified resourceType, you should
-     * throw Exception\InvalidResourceType.
-     *
-     * The object also contains a list of WebDAV properties for the new
-     * collection.
-     *
-     * You should call the handle() method on this object to specify exactly
-     * which properties you are storing. This allows the system to figure out
-     * exactly which properties you didn't store, which in turn allows other
-     * plugins (such as the propertystorage plugin) to handle storing the
-     * property for you.
-     *
-     * @param string $name
-     *
-     * @throws InvalidResourceType
-     */
-    public function createExtendedCollection($name, MkCol $mkCol)
-    {
-        if (!$mkCol->hasResourceType('{DAV:}principal')) {
-            throw new InvalidResourceType('Only resources of type {DAV:}principal may be created here');
-        }
+	/**
+	 * Creates a new collection.
+	 *
+	 * This method will receive a MkCol object with all the information about
+	 * the new collection that's being created.
+	 *
+	 * The MkCol object contains information about the resourceType of the new
+	 * collection. If you don't support the specified resourceType, you should
+	 * throw Exception\InvalidResourceType.
+	 *
+	 * The object also contains a list of WebDAV properties for the new
+	 * collection.
+	 *
+	 * You should call the handle() method on this object to specify exactly
+	 * which properties you are storing. This allows the system to figure out
+	 * exactly which properties you didn't store, which in turn allows other
+	 * plugins (such as the propertystorage plugin) to handle storing the
+	 * property for you.
+	 *
+	 * @param string $name
+	 *
+	 * @throws InvalidResourceType
+	 */
+	public function createExtendedCollection($name, MkCol $mkCol)
+	{
+		if (!$mkCol->hasResourceType('{DAV:}principal')) {
+			throw new InvalidResourceType('Only resources of type {DAV:}principal may be created here');
+		}
 
-        $this->principalBackend->createPrincipal(
-            $this->principalPrefix.'/'.$name,
-            $mkCol
-        );
-    }
+		$this->principalBackend->createPrincipal(
+			$this->principalPrefix.'/'.$name,
+			$mkCol
+		);
+	}
 
-    /**
-     * Returns a list of ACE's for this node.
-     *
-     * Each ACE has the following properties:
-     *   * 'privilege', a string such as {DAV:}read or {DAV:}write. These are
-     *     currently the only supported privileges
-     *   * 'principal', a url to the principal who owns the node
-     *   * 'protected' (optional), indicating that this ACE is not allowed to
-     *      be updated.
-     *
-     * @return array
-     */
-    public function getACL()
-    {
-        return [
-            [
-                'principal' => '{DAV:}authenticated',
-                'privilege' => '{DAV:}read',
-                'protected' => true,
-            ],
-        ];
-    }
+	/**
+	 * Returns a list of ACE's for this node.
+	 *
+	 * Each ACE has the following properties:
+	 *   * 'privilege', a string such as {DAV:}read or {DAV:}write. These are
+	 *     currently the only supported privileges
+	 *   * 'principal', a url to the principal who owns the node
+	 *   * 'protected' (optional), indicating that this ACE is not allowed to
+	 *      be updated.
+	 *
+	 * @return array
+	 */
+	public function getACL()
+	{
+		return [
+			[
+				'principal' => '{DAV:}authenticated',
+				'privilege' => '{DAV:}read',
+				'protected' => true,
+			],
+		];
+	}
 }

htdocs/includes/sabre/sabre/dav/lib/DAV/ICopyTarget.php

Indentation +18 added lines, -18 removed lines

@@ -17,22 +17,22 @@
  */
 interface ICopyTarget extends ICollection
 {
-    /**
-     * Copies a node into this collection.
-     *
-     * It is up to the implementors to:
-     *   1. Create the new resource.
-     *   2. Copy the data and any properties.
-     *
-     * If you return true from this function, the assumption
-     * is that the copy was successful.
-     * If you return false, sabre/dav will handle the copy itself.
-     *
-     * @param string $targetName new local file/collection name
-     * @param string $sourcePath Full path to source node
-     * @param INode  $sourceNode Source node itself
-     *
-     * @return bool
-     */
-    public function copyInto($targetName, $sourcePath, INode $sourceNode);
+	/**
+	 * Copies a node into this collection.
+	 *
+	 * It is up to the implementors to:
+	 *   1. Create the new resource.
+	 *   2. Copy the data and any properties.
+	 *
+	 * If you return true from this function, the assumption
+	 * is that the copy was successful.
+	 * If you return false, sabre/dav will handle the copy itself.
+	 *
+	 * @param string $targetName new local file/collection name
+	 * @param string $sourcePath Full path to source node
+	 * @param INode  $sourceNode Source node itself
+	 *
+	 * @return bool
+	 */
+	public function copyInto($targetName, $sourcePath, INode $sourceNode);
 }

htdocs/includes/sabre/sabre/dav/lib/DAV/IMoveTarget.php

Indentation +22 added lines, -22 removed lines

@@ -21,26 +21,26 @@
  */
 interface IMoveTarget extends ICollection
 {
-    /**
-     * Moves a node into this collection.
-     *
-     * It is up to the implementors to:
-     *   1. Create the new resource.
-     *   2. Remove the old resource.
-     *   3. Transfer any properties or other data.
-     *
-     * Generally you should make very sure that your collection can easily move
-     * the move.
-     *
-     * If you don't, just return false, which will trigger sabre/dav to handle
-     * the move itself. If you return true from this function, the assumption
-     * is that the move was successful.
-     *
-     * @param string $targetName new local file/collection name
-     * @param string $sourcePath Full path to source node
-     * @param INode  $sourceNode Source node itself
-     *
-     * @return bool
-     */
-    public function moveInto($targetName, $sourcePath, INode $sourceNode);
+	/**
+	 * Moves a node into this collection.
+	 *
+	 * It is up to the implementors to:
+	 *   1. Create the new resource.
+	 *   2. Remove the old resource.
+	 *   3. Transfer any properties or other data.
+	 *
+	 * Generally you should make very sure that your collection can easily move
+	 * the move.
+	 *
+	 * If you don't, just return false, which will trigger sabre/dav to handle
+	 * the move itself. If you return true from this function, the assumption
+	 * is that the move was successful.
+	 *
+	 * @param string $targetName new local file/collection name
+	 * @param string $sourcePath Full path to source node
+	 * @param INode  $sourceNode Source node itself
+	 *
+	 * @return bool
+	 */
+	public function moveInto($targetName, $sourcePath, INode $sourceNode);
 }

htdocs/includes/sabre/sabre/dav/lib/DAV/SimpleCollection.php

Indentation +82 added lines, -82 removed lines

@@ -18,92 +18,92 @@
  */
 class SimpleCollection extends Collection
 {
-    /**
-     * List of childnodes.
-     *
-     * @var INode[]
-     */
-    protected $children = [];
+	/**
+	 * List of childnodes.
+	 *
+	 * @var INode[]
+	 */
+	protected $children = [];
 
-    /**
-     * Name of this resource.
-     *
-     * @var string
-     */
-    protected $name;
+	/**
+	 * Name of this resource.
+	 *
+	 * @var string
+	 */
+	protected $name;
 
-    /**
-     * Creates this node.
-     *
-     * The name of the node must be passed, child nodes can also be passed.
-     * This nodes must be instances of INode
-     *
-     * @param string  $name
-     * @param INode[] $children
-     */
-    public function __construct($name, array $children = [])
-    {
-        $this->name = $name;
-        foreach ($children as $key => $child) {
-            if (is_string($child)) {
-                $child = new SimpleFile($key, $child);
-            } elseif (is_array($child)) {
-                $child = new self($key, $child);
-            } elseif (!$child instanceof INode) {
-                throw new InvalidArgumentException('Children must be specified as strings, arrays or instances of Sabre\DAV\INode');
-            }
-            $this->addChild($child);
-        }
-    }
+	/**
+	 * Creates this node.
+	 *
+	 * The name of the node must be passed, child nodes can also be passed.
+	 * This nodes must be instances of INode
+	 *
+	 * @param string  $name
+	 * @param INode[] $children
+	 */
+	public function __construct($name, array $children = [])
+	{
+		$this->name = $name;
+		foreach ($children as $key => $child) {
+			if (is_string($child)) {
+				$child = new SimpleFile($key, $child);
+			} elseif (is_array($child)) {
+				$child = new self($key, $child);
+			} elseif (!$child instanceof INode) {
+				throw new InvalidArgumentException('Children must be specified as strings, arrays or instances of Sabre\DAV\INode');
+			}
+			$this->addChild($child);
+		}
+	}
 
-    /**
-     * Adds a new childnode to this collection.
-     */
-    public function addChild(INode $child)
-    {
-        $this->children[$child->getName()] = $child;
-    }
+	/**
+	 * Adds a new childnode to this collection.
+	 */
+	public function addChild(INode $child)
+	{
+		$this->children[$child->getName()] = $child;
+	}
 
-    /**
-     * Returns the name of the collection.
-     *
-     * @return string
-     */
-    public function getName()
-    {
-        return $this->name;
-    }
+	/**
+	 * Returns the name of the collection.
+	 *
+	 * @return string
+	 */
+	public function getName()
+	{
+		return $this->name;
+	}
 
-    /**
-     * Returns a child object, by its name.
-     *
-     * This method makes use of the getChildren method to grab all the child nodes, and compares the name.
-     * Generally its wise to override this, as this can usually be optimized
-     *
-     * This method must throw Sabre\DAV\Exception\NotFound if the node does not
-     * exist.
-     *
-     * @param string $name
-     *
-     * @throws Exception\NotFound
-     *
-     * @return INode
-     */
-    public function getChild($name)
-    {
-        if (isset($this->children[$name])) {
-            return $this->children[$name];
-        }
-        throw new Exception\NotFound('File not found: '.$name.' in \''.$this->getName().'\'');
-    }
+	/**
+	 * Returns a child object, by its name.
+	 *
+	 * This method makes use of the getChildren method to grab all the child nodes, and compares the name.
+	 * Generally its wise to override this, as this can usually be optimized
+	 *
+	 * This method must throw Sabre\DAV\Exception\NotFound if the node does not
+	 * exist.
+	 *
+	 * @param string $name
+	 *
+	 * @throws Exception\NotFound
+	 *
+	 * @return INode
+	 */
+	public function getChild($name)
+	{
+		if (isset($this->children[$name])) {
+			return $this->children[$name];
+		}
+		throw new Exception\NotFound('File not found: '.$name.' in \''.$this->getName().'\'');
+	}
 
-    /**
-     * Returns a list of children for this collection.
-     *
-     * @return INode[]
-     */
-    public function getChildren()
-    {
-        return array_values($this->children);
-    }
+	/**
+	 * Returns a list of children for this collection.
+	 *
+	 * @return INode[]
+	 */
+	public function getChildren()
+	{
+		return array_values($this->children);
+	}
 }