nextcloud /
passman
@@ -15,119 +15,119 @@ |
||
| 15 | 15 | use OCP\IDBConnection; |
| 16 | 16 | |
| 17 | 17 | class ShareRequestMapper extends Mapper { |
| 18 | - const TABLE_NAME = 'passman_share_request'; |
|
| 19 | - |
|
| 20 | - public function __construct(IDBConnection $db) { |
|
| 21 | - parent::__construct($db, self::TABLE_NAME); |
|
| 22 | - } |
|
| 23 | - |
|
| 24 | - public function createRequest(ShareRequest $request){ |
|
| 25 | - return $this->insert($request); |
|
| 26 | - } |
|
| 27 | - |
|
| 28 | - /** |
|
| 29 | - * Obtains a request by the given item and vault GUID pair |
|
| 30 | - * @param $item_guid |
|
| 31 | - * @param $target_vault_guid |
|
| 32 | - * @return ShareRequest |
|
| 33 | - */ |
|
| 34 | - public function getRequestByItemAndVaultGuid($item_guid, $target_vault_guid){ |
|
| 35 | - $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? AND target_vault_guid = ?"; |
|
| 36 | - return $this->findEntity($q, [$item_guid, $target_vault_guid]); |
|
| 37 | - } |
|
| 38 | - |
|
| 39 | - /** |
|
| 40 | - * Get shared items for the given item_guid |
|
| 41 | - * @param $item_guid |
|
| 42 | - * @return ShareRequest[] |
|
| 43 | - */ |
|
| 44 | - public function getRequestsByItemGuid($item_guid){ |
|
| 45 | - $this->db->executeQuery("SET sql_mode = '';"); |
|
| 46 | - $q = "SELECT *, target_user_id FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? GROUP BY target_user_id;"; |
|
| 47 | - return $this->findEntities($q, [$item_guid]); |
|
| 48 | - } |
|
| 49 | - |
|
| 50 | - /** |
|
| 51 | - * Deletes all pending requests for the given user to the given item |
|
| 52 | - * @param $item_id The item ID |
|
| 53 | - * @param $target_user_id The target user |
|
| 54 | - * @return \PDOStatement The result of running the db query |
|
| 55 | - */ |
|
| 56 | - public function cleanItemRequestsForUser($item_id, $target_user_id){ |
|
| 18 | + const TABLE_NAME = 'passman_share_request'; |
|
| 19 | + |
|
| 20 | + public function __construct(IDBConnection $db) { |
|
| 21 | + parent::__construct($db, self::TABLE_NAME); |
|
| 22 | + } |
|
| 23 | + |
|
| 24 | + public function createRequest(ShareRequest $request){ |
|
| 25 | + return $this->insert($request); |
|
| 26 | + } |
|
| 27 | + |
|
| 28 | + /** |
|
| 29 | + * Obtains a request by the given item and vault GUID pair |
|
| 30 | + * @param $item_guid |
|
| 31 | + * @param $target_vault_guid |
|
| 32 | + * @return ShareRequest |
|
| 33 | + */ |
|
| 34 | + public function getRequestByItemAndVaultGuid($item_guid, $target_vault_guid){ |
|
| 35 | + $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? AND target_vault_guid = ?"; |
|
| 36 | + return $this->findEntity($q, [$item_guid, $target_vault_guid]); |
|
| 37 | + } |
|
| 38 | + |
|
| 39 | + /** |
|
| 40 | + * Get shared items for the given item_guid |
|
| 41 | + * @param $item_guid |
|
| 42 | + * @return ShareRequest[] |
|
| 43 | + */ |
|
| 44 | + public function getRequestsByItemGuid($item_guid){ |
|
| 45 | + $this->db->executeQuery("SET sql_mode = '';"); |
|
| 46 | + $q = "SELECT *, target_user_id FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? GROUP BY target_user_id;"; |
|
| 47 | + return $this->findEntities($q, [$item_guid]); |
|
| 48 | + } |
|
| 49 | + |
|
| 50 | + /** |
|
| 51 | + * Deletes all pending requests for the given user to the given item |
|
| 52 | + * @param $item_id The item ID |
|
| 53 | + * @param $target_user_id The target user |
|
| 54 | + * @return \PDOStatement The result of running the db query |
|
| 55 | + */ |
|
| 56 | + public function cleanItemRequestsForUser($item_id, $target_user_id){ |
|
| 57 | 57 | $q = "DELETE FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_id = ? AND target_user_id = ?"; |
| 58 | 58 | $this->execute($q, [$item_id, $target_user_id]); |
| 59 | - return $this->execute($q, [$item_id, $target_user_id]); |
|
| 60 | - } |
|
| 61 | - |
|
| 62 | - /** |
|
| 63 | - * Obtains all pending share requests for the given user ID |
|
| 64 | - * @param $user_id |
|
| 65 | - * @return ShareRequest[] |
|
| 66 | - */ |
|
| 67 | - public function getUserPendingRequests($user_id){ |
|
| 68 | - $q = "SELECT * FROM *PREFIX*". self::TABLE_NAME ." WHERE target_user_id = ?"; |
|
| 69 | - return $this->findEntities($q, [$user_id]); |
|
| 70 | - } |
|
| 71 | - |
|
| 72 | - /** |
|
| 73 | - * Deletes the given share request |
|
| 74 | - * @param ShareRequest $shareRequest Request to delete |
|
| 75 | - * @return ShareRequest The deleted request |
|
| 76 | - */ |
|
| 77 | - public function deleteShareRequest(ShareRequest $shareRequest){ |
|
| 78 | - return $this->delete($shareRequest); |
|
| 59 | + return $this->execute($q, [$item_id, $target_user_id]); |
|
| 60 | + } |
|
| 61 | + |
|
| 62 | + /** |
|
| 63 | + * Obtains all pending share requests for the given user ID |
|
| 64 | + * @param $user_id |
|
| 65 | + * @return ShareRequest[] |
|
| 66 | + */ |
|
| 67 | + public function getUserPendingRequests($user_id){ |
|
| 68 | + $q = "SELECT * FROM *PREFIX*". self::TABLE_NAME ." WHERE target_user_id = ?"; |
|
| 69 | + return $this->findEntities($q, [$user_id]); |
|
| 79 | 70 | } |
| 80 | 71 | |
| 81 | - /** |
|
| 82 | - * Gets a share request by it's unique incremental id |
|
| 83 | - * @param $id |
|
| 84 | - * @return ShareRequest |
|
| 85 | - */ |
|
| 72 | + /** |
|
| 73 | + * Deletes the given share request |
|
| 74 | + * @param ShareRequest $shareRequest Request to delete |
|
| 75 | + * @return ShareRequest The deleted request |
|
| 76 | + */ |
|
| 77 | + public function deleteShareRequest(ShareRequest $shareRequest){ |
|
| 78 | + return $this->delete($shareRequest); |
|
| 79 | + } |
|
| 80 | + |
|
| 81 | + /** |
|
| 82 | + * Gets a share request by it's unique incremental id |
|
| 83 | + * @param $id |
|
| 84 | + * @return ShareRequest |
|
| 85 | + */ |
|
| 86 | 86 | public function getShareRequestById($id){ |
| 87 | 87 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE id = ?"; |
| 88 | 88 | return $this->findEntity($q, [$id]); |
| 89 | 89 | } |
| 90 | 90 | |
| 91 | - /** |
|
| 92 | - * Gets all share requests by a given item GUID |
|
| 93 | - * @param $item_guid |
|
| 94 | - * @return ShareRequest[] |
|
| 95 | - */ |
|
| 91 | + /** |
|
| 92 | + * Gets all share requests by a given item GUID |
|
| 93 | + * @param $item_guid |
|
| 94 | + * @return ShareRequest[] |
|
| 95 | + */ |
|
| 96 | 96 | public function getShareRequestsByItemGuid($item_guid){ |
| 97 | 97 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ?"; |
| 98 | 98 | return $this->findEntities($q, [$item_guid]); |
| 99 | 99 | } |
| 100 | 100 | |
| 101 | - /** |
|
| 102 | - * Updates the given share request, |
|
| 103 | - * @param ShareRequest $shareRequest |
|
| 104 | - * @return ShareRequest |
|
| 105 | - */ |
|
| 101 | + /** |
|
| 102 | + * Updates the given share request, |
|
| 103 | + * @param ShareRequest $shareRequest |
|
| 104 | + * @return ShareRequest |
|
| 105 | + */ |
|
| 106 | 106 | public function updateShareRequest(ShareRequest $shareRequest){ |
| 107 | 107 | return $this->update($shareRequest); |
| 108 | 108 | } |
| 109 | 109 | |
| 110 | - /** |
|
| 111 | - * Finds pending requests sent to the given user to the given item. |
|
| 112 | - * @param $item_guid |
|
| 113 | - * @param $user_id |
|
| 114 | - * @return ShareRequest[] |
|
| 115 | - */ |
|
| 110 | + /** |
|
| 111 | + * Finds pending requests sent to the given user to the given item. |
|
| 112 | + * @param $item_guid |
|
| 113 | + * @param $user_id |
|
| 114 | + * @return ShareRequest[] |
|
| 115 | + */ |
|
| 116 | 116 | public function getPendingShareRequests($item_guid, $user_id){ |
| 117 | 117 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? and target_user_id= ?"; |
| 118 | 118 | return $this->findEntities($q, [$item_guid, $user_id]); |
| 119 | 119 | } |
| 120 | 120 | |
| 121 | - /** |
|
| 122 | - * Updates all pending requests with the given permissions |
|
| 123 | - * @param $item_guid The item for which to update the requests |
|
| 124 | - * @param $user_id The user for which to update the requests |
|
| 125 | - * @param $permissions The new permissions to apply |
|
| 126 | - * @return \PDOStatement The result of the operation |
|
| 127 | - */ |
|
| 121 | + /** |
|
| 122 | + * Updates all pending requests with the given permissions |
|
| 123 | + * @param $item_guid The item for which to update the requests |
|
| 124 | + * @param $user_id The user for which to update the requests |
|
| 125 | + * @param $permissions The new permissions to apply |
|
| 126 | + * @return \PDOStatement The result of the operation |
|
| 127 | + */ |
|
| 128 | 128 | public function updatePendinRequestPermissions($item_guid, $user_id, $permissions){ |
| 129 | - $q = "UPDATE *PREFIX*" . self::TABLE_NAME . " SET permissions = ? WHERE item_guid = ? AND target_user_id = ?"; |
|
| 130 | - return $this->execute($q, [$permissions, $item_guid, $user_id]); |
|
| 131 | - } |
|
| 129 | + $q = "UPDATE *PREFIX*" . self::TABLE_NAME . " SET permissions = ? WHERE item_guid = ? AND target_user_id = ?"; |
|
| 130 | + return $this->execute($q, [$permissions, $item_guid, $user_id]); |
|
| 131 | + } |
|
| 132 | 132 | |
| 133 | 133 | } |
| 134 | 134 | \ No newline at end of file |
