@@ -22,7 +22,7 @@ discard block |
||
22 | 22 | parent::__construct($db, 'passman_sharing_acl'); |
23 | 23 | } |
24 | 24 | |
25 | - public function createACLEntry(SharingACL $acl){ |
|
25 | + public function createACLEntry(SharingACL $acl) { |
|
26 | 26 | return $this->insert($acl); |
27 | 27 | } |
28 | 28 | |
@@ -33,7 +33,7 @@ discard block |
||
33 | 33 | * @return SharingACL[] |
34 | 34 | */ |
35 | 35 | public function getVaultEntries($user_id, $vault_id) { |
36 | - $q = "SELECT * FROM ". self::TABLE_NAME ." WHERE user_id = ? AND vault_guid = ?"; |
|
36 | + $q = "SELECT * FROM " . self::TABLE_NAME . " WHERE user_id = ? AND vault_guid = ?"; |
|
37 | 37 | return $this->findEntities($q, [$user_id, $vault_id]); |
38 | 38 | } |
39 | 39 | |
@@ -46,7 +46,7 @@ discard block |
||
46 | 46 | public function getItemACL($user_id, $item_guid) { |
47 | 47 | $q = "SELECT * FROM " . self::TABLE_NAME . " WHERE item_guid = ? AND "; |
48 | 48 | $filter = [$item_guid]; |
49 | - if ($user_id === null){ |
|
49 | + if ($user_id === null) { |
|
50 | 50 | $q .= 'user_id is null'; |
51 | 51 | } |
52 | 52 | else { |
@@ -73,11 +73,11 @@ discard block |
||
73 | 73 | * @return SharingACL[] |
74 | 74 | */ |
75 | 75 | public function getCredentialAclList($item_guid) { |
76 | - $q = "SELECT * FROM ". self::TABLE_NAME ." WHERE item_guid = ?"; |
|
76 | + $q = "SELECT * FROM " . self::TABLE_NAME . " WHERE item_guid = ?"; |
|
77 | 77 | return $this->findEntities($q, [$item_guid]); |
78 | 78 | } |
79 | 79 | |
80 | - public function deleteShareACL(SharingACL $ACL){ |
|
80 | + public function deleteShareACL(SharingACL $ACL) { |
|
81 | 81 | return $this->delete($ACL); |
82 | 82 | } |
83 | 83 | } |
84 | 84 | \ No newline at end of file |
@@ -22,7 +22,7 @@ discard block |
||
22 | 22 | parent::__construct($db, 'passman_sharing_acl'); |
23 | 23 | } |
24 | 24 | |
25 | - public function createACLEntry(SharingACL $acl){ |
|
25 | + public function createACLEntry(SharingACL $acl) { |
|
26 | 26 | return $this->insert($acl); |
27 | 27 | } |
28 | 28 | |
@@ -46,10 +46,9 @@ discard block |
||
46 | 46 | public function getItemACL($user_id, $item_guid) { |
47 | 47 | $q = "SELECT * FROM " . self::TABLE_NAME . " WHERE item_guid = ? AND "; |
48 | 48 | $filter = [$item_guid]; |
49 | - if ($user_id === null){ |
|
49 | + if ($user_id === null) { |
|
50 | 50 | $q .= 'user_id is null'; |
51 | - } |
|
52 | - else { |
|
51 | + } else { |
|
53 | 52 | $q .= 'user_id = ? '; |
54 | 53 | $filter[] = $user_id; |
55 | 54 | } |
@@ -77,7 +76,7 @@ discard block |
||
77 | 76 | return $this->findEntities($q, [$item_guid]); |
78 | 77 | } |
79 | 78 | |
80 | - public function deleteShareACL(SharingACL $ACL){ |
|
79 | + public function deleteShareACL(SharingACL $ACL) { |
|
81 | 80 | return $this->delete($ACL); |
82 | 81 | } |
83 | 82 | } |
84 | 83 | \ No newline at end of file |
@@ -16,68 +16,68 @@ |
||
16 | 16 | use OCA\Passman\Utility\Utils; |
17 | 17 | |
18 | 18 | class SharingACLMapper extends Mapper { |
19 | - const TABLE_NAME = '*PREFIX*passman_sharing_acl'; |
|
19 | + const TABLE_NAME = '*PREFIX*passman_sharing_acl'; |
|
20 | 20 | |
21 | - public function __construct(IDBConnection $db) { |
|
22 | - parent::__construct($db, 'passman_sharing_acl'); |
|
23 | - } |
|
21 | + public function __construct(IDBConnection $db) { |
|
22 | + parent::__construct($db, 'passman_sharing_acl'); |
|
23 | + } |
|
24 | 24 | |
25 | - public function createACLEntry(SharingACL $acl){ |
|
26 | - return $this->insert($acl); |
|
27 | - } |
|
25 | + public function createACLEntry(SharingACL $acl){ |
|
26 | + return $this->insert($acl); |
|
27 | + } |
|
28 | 28 | |
29 | - /** |
|
30 | - * Gets the currently accepted share requests from the given user for the given vault guid |
|
31 | - * @param $user_id |
|
32 | - * @param $vault_guid |
|
33 | - * @return SharingACL[] |
|
34 | - */ |
|
35 | - public function getVaultEntries($user_id, $vault_guid) { |
|
36 | - $q = "SELECT * FROM ". self::TABLE_NAME ." WHERE user_id = ? AND vault_guid = ?"; |
|
37 | - return $this->findEntities($q, [$user_id, $vault_guid]); |
|
38 | - } |
|
29 | + /** |
|
30 | + * Gets the currently accepted share requests from the given user for the given vault guid |
|
31 | + * @param $user_id |
|
32 | + * @param $vault_guid |
|
33 | + * @return SharingACL[] |
|
34 | + */ |
|
35 | + public function getVaultEntries($user_id, $vault_guid) { |
|
36 | + $q = "SELECT * FROM ". self::TABLE_NAME ." WHERE user_id = ? AND vault_guid = ?"; |
|
37 | + return $this->findEntities($q, [$user_id, $vault_guid]); |
|
38 | + } |
|
39 | 39 | |
40 | - /** |
|
41 | - * Gets the acl for a given item guid |
|
42 | - * @param $user_id |
|
43 | - * @param $item_guid |
|
44 | - * @return SharingACL |
|
45 | - */ |
|
46 | - public function getItemACL($user_id, $item_guid) { |
|
47 | - $q = "SELECT * FROM " . self::TABLE_NAME . " WHERE item_guid = ? AND "; |
|
48 | - $filter = [$item_guid]; |
|
49 | - if ($user_id === null){ |
|
50 | - $q .= 'user_id is null'; |
|
51 | - } |
|
52 | - else { |
|
53 | - $q .= 'user_id = ? '; |
|
54 | - $filter[] = $user_id; |
|
55 | - } |
|
56 | - return $this->findEntity($q, $filter); |
|
57 | - } |
|
40 | + /** |
|
41 | + * Gets the acl for a given item guid |
|
42 | + * @param $user_id |
|
43 | + * @param $item_guid |
|
44 | + * @return SharingACL |
|
45 | + */ |
|
46 | + public function getItemACL($user_id, $item_guid) { |
|
47 | + $q = "SELECT * FROM " . self::TABLE_NAME . " WHERE item_guid = ? AND "; |
|
48 | + $filter = [$item_guid]; |
|
49 | + if ($user_id === null){ |
|
50 | + $q .= 'user_id is null'; |
|
51 | + } |
|
52 | + else { |
|
53 | + $q .= 'user_id = ? '; |
|
54 | + $filter[] = $user_id; |
|
55 | + } |
|
56 | + return $this->findEntity($q, $filter); |
|
57 | + } |
|
58 | 58 | |
59 | - /** |
|
60 | - * Update the acl for a given item guid |
|
61 | - * @param $user_id |
|
62 | - * @param $item_guid |
|
63 | - * @return SharingACL |
|
64 | - */ |
|
65 | - public function updateCredentialACL(SharingACL $sharingACL) { |
|
66 | - return $this->update($sharingACL); |
|
67 | - } |
|
59 | + /** |
|
60 | + * Update the acl for a given item guid |
|
61 | + * @param $user_id |
|
62 | + * @param $item_guid |
|
63 | + * @return SharingACL |
|
64 | + */ |
|
65 | + public function updateCredentialACL(SharingACL $sharingACL) { |
|
66 | + return $this->update($sharingACL); |
|
67 | + } |
|
68 | 68 | |
69 | - /** |
|
70 | - * Gets the currently accepted share requests from the given user for the given vault guid |
|
71 | - * @param $user_id |
|
72 | - * @param $vault_id |
|
73 | - * @return SharingACL[] |
|
74 | - */ |
|
75 | - public function getCredentialAclList($item_guid) { |
|
76 | - $q = "SELECT * FROM ". self::TABLE_NAME ." WHERE item_guid = ?"; |
|
77 | - return $this->findEntities($q, [$item_guid]); |
|
78 | - } |
|
69 | + /** |
|
70 | + * Gets the currently accepted share requests from the given user for the given vault guid |
|
71 | + * @param $user_id |
|
72 | + * @param $vault_id |
|
73 | + * @return SharingACL[] |
|
74 | + */ |
|
75 | + public function getCredentialAclList($item_guid) { |
|
76 | + $q = "SELECT * FROM ". self::TABLE_NAME ." WHERE item_guid = ?"; |
|
77 | + return $this->findEntities($q, [$item_guid]); |
|
78 | + } |
|
79 | 79 | |
80 | - public function deleteShareACL(SharingACL $ACL){ |
|
81 | - return $this->delete($ACL); |
|
80 | + public function deleteShareACL(SharingACL $ACL){ |
|
81 | + return $this->delete($ACL); |
|
82 | 82 | } |
83 | 83 | } |
84 | 84 | \ No newline at end of file |
@@ -37,60 +37,60 @@ |
||
37 | 37 | |
38 | 38 | class ShareRequest extends PermissionEntity implements \JsonSerializable { |
39 | 39 | |
40 | - protected |
|
41 | - $itemId, |
|
42 | - $itemGuid, |
|
43 | - $targetUserId, |
|
44 | - $targetVaultId, |
|
45 | - $targetVaultGuid, |
|
46 | - $sharedKey, |
|
47 | - $permissions, |
|
48 | - $created, |
|
40 | + protected |
|
41 | + $itemId, |
|
42 | + $itemGuid, |
|
43 | + $targetUserId, |
|
44 | + $targetVaultId, |
|
45 | + $targetVaultGuid, |
|
46 | + $sharedKey, |
|
47 | + $permissions, |
|
48 | + $created, |
|
49 | 49 | $fromUserId; |
50 | 50 | |
51 | - public function __construct() { |
|
52 | - // add types in constructor |
|
53 | - $this->addType('itemId', 'integer'); |
|
54 | - $this->addType('vaultId', 'integer'); |
|
55 | - $this->addType('permissions', 'integer'); |
|
51 | + public function __construct() { |
|
52 | + // add types in constructor |
|
53 | + $this->addType('itemId', 'integer'); |
|
54 | + $this->addType('vaultId', 'integer'); |
|
55 | + $this->addType('permissions', 'integer'); |
|
56 | 56 | $this->addType('created', 'integer'); |
57 | 57 | $this->addType('targetVaultId', 'integer'); |
58 | - } |
|
58 | + } |
|
59 | 59 | |
60 | - /** |
|
61 | - * Specify data which should be serialized to JSON |
|
62 | - * @link http://php.net/manual/en/jsonserializable.jsonserialize.php |
|
63 | - * @return mixed data which can be serialized by <b>json_encode</b>, |
|
64 | - * which is a value of any type other than a resource. |
|
65 | - * @since 5.4.0 |
|
66 | - */ |
|
67 | - function jsonSerialize() |
|
68 | - { |
|
69 | - return [ |
|
70 | - 'req_id' => $this->getId(), |
|
71 | - 'item_id' => $this->getItemId(), |
|
72 | - 'item_guid' => $this->getItemGuid(), |
|
73 | - 'target_user_id' => $this->getTargetUserId(), |
|
74 | - 'target_vault_id' => $this->getTargetVaultId(), |
|
75 | - 'target_vault_guid' => $this->getTargetVaultGuid(), |
|
76 | - 'from_user_id' => $this->getFromUserId(), |
|
77 | - 'shared_key' => $this->getSharedKey(), |
|
78 | - 'permissions' => $this->getPermissions(), |
|
79 | - 'created' => $this->getCreated(), |
|
80 | - ]; |
|
81 | - } |
|
60 | + /** |
|
61 | + * Specify data which should be serialized to JSON |
|
62 | + * @link http://php.net/manual/en/jsonserializable.jsonserialize.php |
|
63 | + * @return mixed data which can be serialized by <b>json_encode</b>, |
|
64 | + * which is a value of any type other than a resource. |
|
65 | + * @since 5.4.0 |
|
66 | + */ |
|
67 | + function jsonSerialize() |
|
68 | + { |
|
69 | + return [ |
|
70 | + 'req_id' => $this->getId(), |
|
71 | + 'item_id' => $this->getItemId(), |
|
72 | + 'item_guid' => $this->getItemGuid(), |
|
73 | + 'target_user_id' => $this->getTargetUserId(), |
|
74 | + 'target_vault_id' => $this->getTargetVaultId(), |
|
75 | + 'target_vault_guid' => $this->getTargetVaultGuid(), |
|
76 | + 'from_user_id' => $this->getFromUserId(), |
|
77 | + 'shared_key' => $this->getSharedKey(), |
|
78 | + 'permissions' => $this->getPermissions(), |
|
79 | + 'created' => $this->getCreated(), |
|
80 | + ]; |
|
81 | + } |
|
82 | 82 | |
83 | - function asACLJson(){ |
|
84 | - return [ |
|
85 | - 'item_id' => $this->getItemId(), |
|
86 | - 'item_guid' => $this->getItemGuid(), |
|
87 | - 'user_id' => $this->getTargetUserId(), |
|
88 | - 'created' => $this->getCreated(), |
|
89 | - 'permissions' => $this->getPermissions(), |
|
90 | - 'vault_id' => $this->getTargetVaultId(), |
|
91 | - 'vault_guid' => $this->getTargetVaultGuid(), |
|
92 | - 'shared_key' => $this->getSharedKey(), |
|
93 | - 'pending' => true, |
|
94 | - ]; |
|
95 | - } |
|
83 | + function asACLJson(){ |
|
84 | + return [ |
|
85 | + 'item_id' => $this->getItemId(), |
|
86 | + 'item_guid' => $this->getItemGuid(), |
|
87 | + 'user_id' => $this->getTargetUserId(), |
|
88 | + 'created' => $this->getCreated(), |
|
89 | + 'permissions' => $this->getPermissions(), |
|
90 | + 'vault_id' => $this->getTargetVaultId(), |
|
91 | + 'vault_guid' => $this->getTargetVaultGuid(), |
|
92 | + 'shared_key' => $this->getSharedKey(), |
|
93 | + 'pending' => true, |
|
94 | + ]; |
|
95 | + } |
|
96 | 96 | } |
97 | 97 | \ No newline at end of file |
@@ -16,120 +16,120 @@ |
||
16 | 16 | use OCP\IDBConnection; |
17 | 17 | |
18 | 18 | class ShareRequestMapper extends Mapper { |
19 | - const TABLE_NAME = 'passman_share_request'; |
|
20 | - |
|
21 | - public function __construct(IDBConnection $db) { |
|
22 | - parent::__construct($db, self::TABLE_NAME); |
|
23 | - } |
|
24 | - |
|
25 | - public function createRequest(ShareRequest $request){ |
|
26 | - return $this->insert($request); |
|
27 | - } |
|
28 | - |
|
29 | - /** |
|
30 | - * Obtains a request by the given item and vault GUID pair |
|
31 | - * @param $item_guid |
|
32 | - * @param $target_vault_guid |
|
33 | - * @return ShareRequest |
|
34 | - */ |
|
35 | - public function getRequestByItemAndVaultGuid($item_guid, $target_vault_guid){ |
|
36 | - $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? AND target_vault_guid = ?"; |
|
37 | - return $this->findEntity($q, [$item_guid, $target_vault_guid]); |
|
38 | - } |
|
39 | - |
|
40 | - /** |
|
41 | - * Get shared items for the given item_guid |
|
42 | - * @param $item_guid |
|
43 | - * @return ShareRequest[] |
|
44 | - */ |
|
45 | - public function getRequestsByItemGuidGroupedByUser($item_guid){ |
|
46 | - $this->db->executeQuery("SET sql_mode = '';"); |
|
47 | - $q = "SELECT *, target_user_id FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? GROUP BY target_user_id;"; |
|
48 | - return $this->findEntities($q, [$item_guid]); |
|
49 | - } |
|
50 | - |
|
51 | - /** |
|
52 | - * Deletes all pending requests for the given user to the given item |
|
53 | - * @param $item_id The item ID |
|
54 | - * @param $target_user_id The target user |
|
55 | - * @return \PDOStatement The result of running the db query |
|
56 | - */ |
|
57 | - public function cleanItemRequestsForUser($item_id, $target_user_id){ |
|
19 | + const TABLE_NAME = 'passman_share_request'; |
|
20 | + |
|
21 | + public function __construct(IDBConnection $db) { |
|
22 | + parent::__construct($db, self::TABLE_NAME); |
|
23 | + } |
|
24 | + |
|
25 | + public function createRequest(ShareRequest $request){ |
|
26 | + return $this->insert($request); |
|
27 | + } |
|
28 | + |
|
29 | + /** |
|
30 | + * Obtains a request by the given item and vault GUID pair |
|
31 | + * @param $item_guid |
|
32 | + * @param $target_vault_guid |
|
33 | + * @return ShareRequest |
|
34 | + */ |
|
35 | + public function getRequestByItemAndVaultGuid($item_guid, $target_vault_guid){ |
|
36 | + $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? AND target_vault_guid = ?"; |
|
37 | + return $this->findEntity($q, [$item_guid, $target_vault_guid]); |
|
38 | + } |
|
39 | + |
|
40 | + /** |
|
41 | + * Get shared items for the given item_guid |
|
42 | + * @param $item_guid |
|
43 | + * @return ShareRequest[] |
|
44 | + */ |
|
45 | + public function getRequestsByItemGuidGroupedByUser($item_guid){ |
|
46 | + $this->db->executeQuery("SET sql_mode = '';"); |
|
47 | + $q = "SELECT *, target_user_id FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? GROUP BY target_user_id;"; |
|
48 | + return $this->findEntities($q, [$item_guid]); |
|
49 | + } |
|
50 | + |
|
51 | + /** |
|
52 | + * Deletes all pending requests for the given user to the given item |
|
53 | + * @param $item_id The item ID |
|
54 | + * @param $target_user_id The target user |
|
55 | + * @return \PDOStatement The result of running the db query |
|
56 | + */ |
|
57 | + public function cleanItemRequestsForUser($item_id, $target_user_id){ |
|
58 | 58 | $q = "DELETE FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_id = ? AND target_user_id = ?"; |
59 | 59 | $this->execute($q, [$item_id, $target_user_id]); |
60 | - return $this->execute($q, [$item_id, $target_user_id]); |
|
61 | - } |
|
62 | - |
|
63 | - /** |
|
64 | - * Obtains all pending share requests for the given user ID |
|
65 | - * @param $user_id |
|
66 | - * @return ShareRequest[] |
|
67 | - */ |
|
68 | - public function getUserPendingRequests($user_id){ |
|
69 | - $q = "SELECT * FROM *PREFIX*". self::TABLE_NAME ." WHERE target_user_id = ?"; |
|
70 | - return $this->findEntities($q, [$user_id]); |
|
71 | - } |
|
72 | - |
|
73 | - /** |
|
74 | - * Deletes the given share request |
|
75 | - * @param ShareRequest $shareRequest Request to delete |
|
76 | - * @return ShareRequest The deleted request |
|
77 | - */ |
|
78 | - public function deleteShareRequest(ShareRequest $shareRequest){ |
|
79 | - return $this->delete($shareRequest); |
|
60 | + return $this->execute($q, [$item_id, $target_user_id]); |
|
61 | + } |
|
62 | + |
|
63 | + /** |
|
64 | + * Obtains all pending share requests for the given user ID |
|
65 | + * @param $user_id |
|
66 | + * @return ShareRequest[] |
|
67 | + */ |
|
68 | + public function getUserPendingRequests($user_id){ |
|
69 | + $q = "SELECT * FROM *PREFIX*". self::TABLE_NAME ." WHERE target_user_id = ?"; |
|
70 | + return $this->findEntities($q, [$user_id]); |
|
80 | 71 | } |
81 | 72 | |
82 | - /** |
|
83 | - * Gets a share request by it's unique incremental id |
|
84 | - * @param $id |
|
85 | - * @return ShareRequest |
|
73 | + /** |
|
74 | + * Deletes the given share request |
|
75 | + * @param ShareRequest $shareRequest Request to delete |
|
76 | + * @return ShareRequest The deleted request |
|
77 | + */ |
|
78 | + public function deleteShareRequest(ShareRequest $shareRequest){ |
|
79 | + return $this->delete($shareRequest); |
|
80 | + } |
|
81 | + |
|
82 | + /** |
|
83 | + * Gets a share request by it's unique incremental id |
|
84 | + * @param $id |
|
85 | + * @return ShareRequest |
|
86 | 86 | * @throws DoesNotExistException |
87 | - */ |
|
87 | + */ |
|
88 | 88 | public function getShareRequestById($id){ |
89 | 89 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE id = ?"; |
90 | 90 | return $this->findEntity($q, [$id]); |
91 | 91 | } |
92 | 92 | |
93 | - /** |
|
94 | - * Gets all share requests by a given item GUID |
|
95 | - * @param $item_guid |
|
96 | - * @return ShareRequest[] |
|
97 | - */ |
|
93 | + /** |
|
94 | + * Gets all share requests by a given item GUID |
|
95 | + * @param $item_guid |
|
96 | + * @return ShareRequest[] |
|
97 | + */ |
|
98 | 98 | public function getShareRequestsByItemGuid($item_guid){ |
99 | 99 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ?"; |
100 | 100 | return $this->findEntities($q, [$item_guid]); |
101 | 101 | } |
102 | 102 | |
103 | - /** |
|
104 | - * Updates the given share request, |
|
105 | - * @param ShareRequest $shareRequest |
|
106 | - * @return ShareRequest |
|
107 | - */ |
|
103 | + /** |
|
104 | + * Updates the given share request, |
|
105 | + * @param ShareRequest $shareRequest |
|
106 | + * @return ShareRequest |
|
107 | + */ |
|
108 | 108 | public function updateShareRequest(ShareRequest $shareRequest){ |
109 | 109 | return $this->update($shareRequest); |
110 | 110 | } |
111 | 111 | |
112 | - /** |
|
113 | - * Finds pending requests sent to the given user to the given item. |
|
114 | - * @param $item_guid |
|
115 | - * @param $user_id |
|
116 | - * @return ShareRequest[] |
|
117 | - */ |
|
112 | + /** |
|
113 | + * Finds pending requests sent to the given user to the given item. |
|
114 | + * @param $item_guid |
|
115 | + * @param $user_id |
|
116 | + * @return ShareRequest[] |
|
117 | + */ |
|
118 | 118 | public function getPendingShareRequests($item_guid, $user_id){ |
119 | 119 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? and target_user_id= ?"; |
120 | 120 | return $this->findEntities($q, [$item_guid, $user_id]); |
121 | 121 | } |
122 | 122 | |
123 | - /** |
|
124 | - * Updates all pending requests with the given permissions |
|
125 | - * @param $item_guid The item for which to update the requests |
|
126 | - * @param $user_id The user for which to update the requests |
|
127 | - * @param $permissions The new permissions to apply |
|
128 | - * @return \PDOStatement The result of the operation |
|
129 | - */ |
|
123 | + /** |
|
124 | + * Updates all pending requests with the given permissions |
|
125 | + * @param $item_guid The item for which to update the requests |
|
126 | + * @param $user_id The user for which to update the requests |
|
127 | + * @param $permissions The new permissions to apply |
|
128 | + * @return \PDOStatement The result of the operation |
|
129 | + */ |
|
130 | 130 | public function updatePendinRequestPermissions($item_guid, $user_id, $permissions){ |
131 | - $q = "UPDATE *PREFIX*" . self::TABLE_NAME . " SET permissions = ? WHERE item_guid = ? AND target_user_id = ?"; |
|
132 | - return $this->execute($q, [$permissions, $item_guid, $user_id]); |
|
133 | - } |
|
131 | + $q = "UPDATE *PREFIX*" . self::TABLE_NAME . " SET permissions = ? WHERE item_guid = ? AND target_user_id = ?"; |
|
132 | + return $this->execute($q, [$permissions, $item_guid, $user_id]); |
|
133 | + } |
|
134 | 134 | |
135 | 135 | } |
136 | 136 | \ No newline at end of file |
@@ -22,7 +22,7 @@ discard block |
||
22 | 22 | parent::__construct($db, self::TABLE_NAME); |
23 | 23 | } |
24 | 24 | |
25 | - public function createRequest(ShareRequest $request){ |
|
25 | + public function createRequest(ShareRequest $request) { |
|
26 | 26 | return $this->insert($request); |
27 | 27 | } |
28 | 28 | |
@@ -32,7 +32,7 @@ discard block |
||
32 | 32 | * @param $target_vault_guid |
33 | 33 | * @return ShareRequest |
34 | 34 | */ |
35 | - public function getRequestByItemAndVaultGuid($item_guid, $target_vault_guid){ |
|
35 | + public function getRequestByItemAndVaultGuid($item_guid, $target_vault_guid) { |
|
36 | 36 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? AND target_vault_guid = ?"; |
37 | 37 | return $this->findEntity($q, [$item_guid, $target_vault_guid]); |
38 | 38 | } |
@@ -42,7 +42,7 @@ discard block |
||
42 | 42 | * @param $item_guid |
43 | 43 | * @return ShareRequest[] |
44 | 44 | */ |
45 | - public function getRequestsByItemGuidGroupedByUser($item_guid){ |
|
45 | + public function getRequestsByItemGuidGroupedByUser($item_guid) { |
|
46 | 46 | $this->db->executeQuery("SET sql_mode = '';"); |
47 | 47 | $q = "SELECT *, target_user_id FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? GROUP BY target_user_id;"; |
48 | 48 | return $this->findEntities($q, [$item_guid]); |
@@ -54,7 +54,7 @@ discard block |
||
54 | 54 | * @param $target_user_id The target user |
55 | 55 | * @return \PDOStatement The result of running the db query |
56 | 56 | */ |
57 | - public function cleanItemRequestsForUser($item_id, $target_user_id){ |
|
57 | + public function cleanItemRequestsForUser($item_id, $target_user_id) { |
|
58 | 58 | $q = "DELETE FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_id = ? AND target_user_id = ?"; |
59 | 59 | $this->execute($q, [$item_id, $target_user_id]); |
60 | 60 | return $this->execute($q, [$item_id, $target_user_id]); |
@@ -65,8 +65,8 @@ discard block |
||
65 | 65 | * @param $user_id |
66 | 66 | * @return ShareRequest[] |
67 | 67 | */ |
68 | - public function getUserPendingRequests($user_id){ |
|
69 | - $q = "SELECT * FROM *PREFIX*". self::TABLE_NAME ." WHERE target_user_id = ?"; |
|
68 | + public function getUserPendingRequests($user_id) { |
|
69 | + $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE target_user_id = ?"; |
|
70 | 70 | return $this->findEntities($q, [$user_id]); |
71 | 71 | } |
72 | 72 | |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | * @param ShareRequest $shareRequest Request to delete |
76 | 76 | * @return ShareRequest The deleted request |
77 | 77 | */ |
78 | - public function deleteShareRequest(ShareRequest $shareRequest){ |
|
78 | + public function deleteShareRequest(ShareRequest $shareRequest) { |
|
79 | 79 | return $this->delete($shareRequest); |
80 | 80 | } |
81 | 81 | |
@@ -85,7 +85,7 @@ discard block |
||
85 | 85 | * @return ShareRequest |
86 | 86 | * @throws DoesNotExistException |
87 | 87 | */ |
88 | - public function getShareRequestById($id){ |
|
88 | + public function getShareRequestById($id) { |
|
89 | 89 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE id = ?"; |
90 | 90 | return $this->findEntity($q, [$id]); |
91 | 91 | } |
@@ -95,7 +95,7 @@ discard block |
||
95 | 95 | * @param $item_guid |
96 | 96 | * @return ShareRequest[] |
97 | 97 | */ |
98 | - public function getShareRequestsByItemGuid($item_guid){ |
|
98 | + public function getShareRequestsByItemGuid($item_guid) { |
|
99 | 99 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ?"; |
100 | 100 | return $this->findEntities($q, [$item_guid]); |
101 | 101 | } |
@@ -105,7 +105,7 @@ discard block |
||
105 | 105 | * @param ShareRequest $shareRequest |
106 | 106 | * @return ShareRequest |
107 | 107 | */ |
108 | - public function updateShareRequest(ShareRequest $shareRequest){ |
|
108 | + public function updateShareRequest(ShareRequest $shareRequest) { |
|
109 | 109 | return $this->update($shareRequest); |
110 | 110 | } |
111 | 111 | |
@@ -115,7 +115,7 @@ discard block |
||
115 | 115 | * @param $user_id |
116 | 116 | * @return ShareRequest[] |
117 | 117 | */ |
118 | - public function getPendingShareRequests($item_guid, $user_id){ |
|
118 | + public function getPendingShareRequests($item_guid, $user_id) { |
|
119 | 119 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? and target_user_id= ?"; |
120 | 120 | return $this->findEntities($q, [$item_guid, $user_id]); |
121 | 121 | } |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | * @param $permissions The new permissions to apply |
128 | 128 | * @return \PDOStatement The result of the operation |
129 | 129 | */ |
130 | - public function updatePendinRequestPermissions($item_guid, $user_id, $permissions){ |
|
130 | + public function updatePendinRequestPermissions($item_guid, $user_id, $permissions) { |
|
131 | 131 | $q = "UPDATE *PREFIX*" . self::TABLE_NAME . " SET permissions = ? WHERE item_guid = ? AND target_user_id = ?"; |
132 | 132 | return $this->execute($q, [$permissions, $item_guid, $user_id]); |
133 | 133 | } |
@@ -22,7 +22,7 @@ discard block |
||
22 | 22 | parent::__construct($db, self::TABLE_NAME); |
23 | 23 | } |
24 | 24 | |
25 | - public function createRequest(ShareRequest $request){ |
|
25 | + public function createRequest(ShareRequest $request) { |
|
26 | 26 | return $this->insert($request); |
27 | 27 | } |
28 | 28 | |
@@ -32,7 +32,7 @@ discard block |
||
32 | 32 | * @param $target_vault_guid |
33 | 33 | * @return ShareRequest |
34 | 34 | */ |
35 | - public function getRequestByItemAndVaultGuid($item_guid, $target_vault_guid){ |
|
35 | + public function getRequestByItemAndVaultGuid($item_guid, $target_vault_guid) { |
|
36 | 36 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? AND target_vault_guid = ?"; |
37 | 37 | return $this->findEntity($q, [$item_guid, $target_vault_guid]); |
38 | 38 | } |
@@ -42,7 +42,7 @@ discard block |
||
42 | 42 | * @param $item_guid |
43 | 43 | * @return ShareRequest[] |
44 | 44 | */ |
45 | - public function getRequestsByItemGuidGroupedByUser($item_guid){ |
|
45 | + public function getRequestsByItemGuidGroupedByUser($item_guid) { |
|
46 | 46 | $this->db->executeQuery("SET sql_mode = '';"); |
47 | 47 | $q = "SELECT *, target_user_id FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? GROUP BY target_user_id;"; |
48 | 48 | return $this->findEntities($q, [$item_guid]); |
@@ -54,7 +54,7 @@ discard block |
||
54 | 54 | * @param $target_user_id The target user |
55 | 55 | * @return \PDOStatement The result of running the db query |
56 | 56 | */ |
57 | - public function cleanItemRequestsForUser($item_id, $target_user_id){ |
|
57 | + public function cleanItemRequestsForUser($item_id, $target_user_id) { |
|
58 | 58 | $q = "DELETE FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_id = ? AND target_user_id = ?"; |
59 | 59 | $this->execute($q, [$item_id, $target_user_id]); |
60 | 60 | return $this->execute($q, [$item_id, $target_user_id]); |
@@ -65,7 +65,7 @@ discard block |
||
65 | 65 | * @param $user_id |
66 | 66 | * @return ShareRequest[] |
67 | 67 | */ |
68 | - public function getUserPendingRequests($user_id){ |
|
68 | + public function getUserPendingRequests($user_id) { |
|
69 | 69 | $q = "SELECT * FROM *PREFIX*". self::TABLE_NAME ." WHERE target_user_id = ?"; |
70 | 70 | return $this->findEntities($q, [$user_id]); |
71 | 71 | } |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | * @param ShareRequest $shareRequest Request to delete |
76 | 76 | * @return ShareRequest The deleted request |
77 | 77 | */ |
78 | - public function deleteShareRequest(ShareRequest $shareRequest){ |
|
78 | + public function deleteShareRequest(ShareRequest $shareRequest) { |
|
79 | 79 | return $this->delete($shareRequest); |
80 | 80 | } |
81 | 81 | |
@@ -85,7 +85,7 @@ discard block |
||
85 | 85 | * @return ShareRequest |
86 | 86 | * @throws DoesNotExistException |
87 | 87 | */ |
88 | - public function getShareRequestById($id){ |
|
88 | + public function getShareRequestById($id) { |
|
89 | 89 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE id = ?"; |
90 | 90 | return $this->findEntity($q, [$id]); |
91 | 91 | } |
@@ -95,7 +95,7 @@ discard block |
||
95 | 95 | * @param $item_guid |
96 | 96 | * @return ShareRequest[] |
97 | 97 | */ |
98 | - public function getShareRequestsByItemGuid($item_guid){ |
|
98 | + public function getShareRequestsByItemGuid($item_guid) { |
|
99 | 99 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ?"; |
100 | 100 | return $this->findEntities($q, [$item_guid]); |
101 | 101 | } |
@@ -105,7 +105,7 @@ discard block |
||
105 | 105 | * @param ShareRequest $shareRequest |
106 | 106 | * @return ShareRequest |
107 | 107 | */ |
108 | - public function updateShareRequest(ShareRequest $shareRequest){ |
|
108 | + public function updateShareRequest(ShareRequest $shareRequest) { |
|
109 | 109 | return $this->update($shareRequest); |
110 | 110 | } |
111 | 111 | |
@@ -115,7 +115,7 @@ discard block |
||
115 | 115 | * @param $user_id |
116 | 116 | * @return ShareRequest[] |
117 | 117 | */ |
118 | - public function getPendingShareRequests($item_guid, $user_id){ |
|
118 | + public function getPendingShareRequests($item_guid, $user_id) { |
|
119 | 119 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? and target_user_id= ?"; |
120 | 120 | return $this->findEntities($q, [$item_guid, $user_id]); |
121 | 121 | } |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | * @param $permissions The new permissions to apply |
128 | 128 | * @return \PDOStatement The result of the operation |
129 | 129 | */ |
130 | - public function updatePendinRequestPermissions($item_guid, $user_id, $permissions){ |
|
130 | + public function updatePendinRequestPermissions($item_guid, $user_id, $permissions) { |
|
131 | 131 | $q = "UPDATE *PREFIX*" . self::TABLE_NAME . " SET permissions = ? WHERE item_guid = ? AND target_user_id = ?"; |
132 | 132 | return $this->execute($q, [$permissions, $item_guid, $user_id]); |
133 | 133 | } |