| @@ -33,12 +33,18 @@ | ||
| 33 | 33 | return $this->findEntities($sql, [$user_id, $vault_id]); | 
| 34 | 34 | } | 
| 35 | 35 | |
| 36 | + /** | |
| 37 | + * @param integer $vault_id | |
| 38 | + */ | |
| 36 | 39 |  	public function getRandomCredentialByVaultId($vault_id, $user_id) { | 
| 37 | 40 | $sql = 'SELECT * FROM `*PREFIX*passman_credentials` ' . | 
| 38 | 41 | 'WHERE `user_id` = ? and vault_id = ? AND shared_key is NULL ORDER BY RAND() LIMIT 1'; | 
| 39 | 42 | return $this->findEntities($sql, [$user_id, $vault_id]); | 
| 40 | 43 | } | 
| 41 | 44 | |
| 45 | + /** | |
| 46 | + * @param integer $timestamp | |
| 47 | + */ | |
| 42 | 48 |  	public function getExpiredCredentials($timestamp) { | 
| 43 | 49 | $sql = 'SELECT * FROM `*PREFIX*passman_credentials` ' . | 
| 44 | 50 | 'WHERE `expire_time` > 0 AND `expire_time` < ?'; | 
| @@ -50,28 +50,28 @@ discard block | ||
| 50 | 50 | * @param null $user_id | 
| 51 | 51 | * @return Credential | 
| 52 | 52 | */ | 
| 53 | -	public function getCredentialById($credential_id, $user_id = null){ | |
| 53 | +	public function getCredentialById($credential_id, $user_id = null) { | |
| 54 | 54 | $sql = 'SELECT * FROM `*PREFIX*passman_credentials` ' . | 
| 55 | 55 | 'WHERE `id` = ?'; | 
| 56 | 56 | // If we want to check the owner, add it to the query | 
| 57 | 57 | $params = [$credential_id]; | 
| 58 | -		if ($user_id !== null){ | |
| 58 | +		if ($user_id !== null) { | |
| 59 | 59 | $sql .= ' and `user_id` = ? '; | 
| 60 | 60 | array_push($params, $user_id); | 
| 61 | 61 | } | 
| 62 | - return $this->findEntity($sql,$params); | |
| 62 | + return $this->findEntity($sql, $params); | |
| 63 | 63 | } | 
| 64 | 64 | |
| 65 | 65 | /** | 
| 66 | 66 | * @param integer $credential_id | 
| 67 | 67 | */ | 
| 68 | -	public function getCredentialLabelById($credential_id){ | |
| 68 | +	public function getCredentialLabelById($credential_id) { | |
| 69 | 69 | $sql = 'SELECT id, label FROM `*PREFIX*passman_credentials` ' . | 
| 70 | 70 | 'WHERE `id` = ? '; | 
| 71 | - return $this->findEntity($sql,[$credential_id]); | |
| 71 | + return $this->findEntity($sql, [$credential_id]); | |
| 72 | 72 | } | 
| 73 | 73 | |
| 74 | -	public function create($raw_credential){ | |
| 74 | +	public function create($raw_credential) { | |
| 75 | 75 | $credential = new Credential(); | 
| 76 | 76 | |
| 77 | 77 | $credential->setGuid($this->utils->GUID()); | 
| @@ -144,10 +144,10 @@ discard block | ||
| 144 | 144 | * @param $credential_guid | 
| 145 | 145 | * @return Credential | 
| 146 | 146 | */ | 
| 147 | -	public function getCredentialByGUID($credential_guid, $user_id = null){ | |
| 147 | +	public function getCredentialByGUID($credential_guid, $user_id = null) { | |
| 148 | 148 | $q = 'SELECT * FROM `*PREFIX*passman_credentials` WHERE guid = ? '; | 
| 149 | 149 | $params = [$credential_guid]; | 
| 150 | -		if ($user_id !== null){ | |
| 150 | +		if ($user_id !== null) { | |
| 151 | 151 | $q .= ' and `user_id` = ? '; | 
| 152 | 152 | array_push($params, $user_id); | 
| 153 | 153 | } | 
| @@ -255,21 +255,18 @@ | ||
| 255 | 255 |  	public function getRevision($credential_guid) { | 
| 256 | 256 |  		try { | 
| 257 | 257 | $credential = $this->credentialService->getCredentialByGUID($credential_guid); | 
| 258 | - } | |
| 259 | -		catch (DoesNotExistException $ex) { | |
| 258 | +		} catch (DoesNotExistException $ex) { | |
| 260 | 259 | return new NotFoundJSONResponse(); | 
| 261 | 260 | } | 
| 262 | 261 | |
| 263 | 262 | // If the request was made by the owner of the credential | 
| 264 | 263 |  		if ($this->userId === $credential->getUserId()) { | 
| 265 | 264 | $result = $this->credentialRevisionService->getRevisions($credential->getId(), $this->userId); | 
| 266 | - } | |
| 267 | -		else { | |
| 265 | +		} else { | |
| 268 | 266 | $acl = $this->sharingService->getACL($this->userId, $credential_guid); | 
| 269 | 267 |  			if ($acl->hasPermission(SharingACL::HISTORY)) { | 
| 270 | 268 | $result = $this->credentialRevisionService->getRevisions($credential->getId()); | 
| 271 | - } | |
| 272 | -			else { | |
| 269 | +			} else { | |
| 273 | 270 | return new NotFoundJSONResponse(); | 
| 274 | 271 | } | 
| 275 | 272 | } | 
| @@ -32,7 +32,7 @@ discard block | ||
| 32 | 32 | 'WHERE `credential_id` = ?'; | 
| 33 | 33 | $params = [$credential_id]; | 
| 34 | 34 |  		if ($user_id !== null) { | 
| 35 | - $sql.= ' and `user_id` = ? '; | |
| 35 | + $sql .= ' and `user_id` = ? '; | |
| 36 | 36 | $params[] = $user_id; | 
| 37 | 37 | } | 
| 38 | 38 | return $this->findEntities($sql, $params); | 
| @@ -48,7 +48,7 @@ discard block | ||
| 48 | 48 | 'WHERE `id` = ?'; | 
| 49 | 49 | $params = [$revision_id]; | 
| 50 | 50 |  		if ($user_id !== null) { | 
| 51 | - $sql.= ' and `user_id` = ? '; | |
| 51 | + $sql .= ' and `user_id` = ? '; | |
| 52 | 52 | $params[] = $user_id; | 
| 53 | 53 | } | 
| 54 | 54 | return $this->findEntity($sql, $params); | 
| @@ -22,7 +22,7 @@ discard block | ||
| 22 | 22 | $this->utils = $utils; | 
| 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 getRequestsByItemGuid($item_guid){ | |
| 45 | +	public function getRequestsByItemGuid($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 | |
| @@ -84,7 +84,7 @@ discard block | ||
| 84 | 84 | * @param $id | 
| 85 | 85 | * @return ShareRequest | 
| 86 | 86 | */ | 
| 87 | -	public function getShareRequestById($id){ | |
| 87 | +	public function getShareRequestById($id) { | |
| 88 | 88 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE id = ?"; | 
| 89 | 89 | return $this->findEntity($q, [$id]); | 
| 90 | 90 | } | 
| @@ -94,7 +94,7 @@ discard block | ||
| 94 | 94 | * @param $item_guid | 
| 95 | 95 | * @return ShareRequest[] | 
| 96 | 96 | */ | 
| 97 | -	public function getShareRequestsByItemGuid($item_guid){ | |
| 97 | +	public function getShareRequestsByItemGuid($item_guid) { | |
| 98 | 98 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ?"; | 
| 99 | 99 | return $this->findEntities($q, [$item_guid]); | 
| 100 | 100 | } | 
| @@ -104,7 +104,7 @@ discard block | ||
| 104 | 104 | * @param ShareRequest $shareRequest | 
| 105 | 105 | * @return ShareRequest | 
| 106 | 106 | */ | 
| 107 | -	public function updateShareRequest(ShareRequest $shareRequest){ | |
| 107 | +	public function updateShareRequest(ShareRequest $shareRequest) { | |
| 108 | 108 | return $this->update($shareRequest); | 
| 109 | 109 | } | 
| 110 | 110 | |
| @@ -114,7 +114,7 @@ discard block | ||
| 114 | 114 | * @param $user_id | 
| 115 | 115 | * @return ShareRequest[] | 
| 116 | 116 | */ | 
| 117 | -	public function getPendingShareRequests($item_guid, $user_id){ | |
| 117 | +	public function getPendingShareRequests($item_guid, $user_id) { | |
| 118 | 118 | $q = "SELECT * FROM *PREFIX*" . self::TABLE_NAME . " WHERE item_guid = ? and target_user_id= ?"; | 
| 119 | 119 | return $this->findEntities($q, [$item_guid, $user_id]); | 
| 120 | 120 | } | 
| @@ -126,7 +126,7 @@ discard block | ||
| 126 | 126 | * @param $permissions The new permissions to apply | 
| 127 | 127 | * @return \PDOStatement The result of the operation | 
| 128 | 128 | */ | 
| 129 | -	public function updatePendinRequestPermissions($item_guid, $user_id, $permissions){ | |
| 129 | +	public function updatePendinRequestPermissions($item_guid, $user_id, $permissions) { | |
| 130 | 130 | $q = "UPDATE *PREFIX*" . self::TABLE_NAME . " SET permissions = ? WHERE item_guid = ? AND target_user_id = ?"; | 
| 131 | 131 | return $this->execute($q, [$permissions, $item_guid, $user_id]); | 
| 132 | 132 | } | 
| @@ -77,7 +77,7 @@ | ||
| 77 | 77 | ]; | 
| 78 | 78 | } | 
| 79 | 79 | |
| 80 | -	function asACLJson(){ | |
| 80 | +	function asACLJson() { | |
| 81 | 81 | return [ | 
| 82 | 82 | 'item_id' => $this->getItemId(), | 
| 83 | 83 | 'item_guid' => $this->getItemGuid(), | 
| @@ -95,11 +95,11 @@ | ||
| 95 | 95 | /** | 
| 96 | 96 | * @param integer $credential_id | 
| 97 | 97 | */ | 
| 98 | -	public function getCredentialLabelById($credential_id){ | |
| 98 | +	public function getCredentialLabelById($credential_id) { | |
| 99 | 99 | return $this->credentialMapper->getCredentialLabelById($credential_id); | 
| 100 | 100 | } | 
| 101 | 101 | |
| 102 | -	public function getCredentialByGUID($credential_guid, $user_id = null){ | |
| 102 | +	public function getCredentialByGUID($credential_guid, $user_id = null) { | |
| 103 | 103 | return $this->credentialMapper->getCredentialByGUID($credential_guid, $user_id); | 
| 104 | 104 | } | 
| 105 | 105 | } | 
| 106 | 106 | \ No newline at end of file |