public function delete($userId = null, $providerId = null, $providerUserId = null) { MDataType::mustBeNullableInt($userId); MDataType::mustBeNullableInt($providerId); MDataType::mustBeNullableString($providerUserId); $sql = "CALL mt_provider_user_delete(?,?, ?);"; $query = new MPDOQuery($sql, $this->connection); $query->bindValue($userId); $query->bindValue($providerId); $query->bindValue($providerUserId); $queryResult = $query->exec(); if ($queryResult == false) { throw new DeleteProviderException($query->getLastError()); } }
/** * @param int|null $userId * @return array * @throws \Exception */ public function get($userId = null) { MDataType::mustBeNullableInt($userId); $toReturn = array(); $sql = "CALL mt_role_get(?);"; $query = new MPDOQuery($sql, $this->connection); $query->bindValue($userId); $queryResult = $query->exec(); if ($queryResult == false || $query->getResult()->rowCount() <= 0) { return $toReturn; } foreach ($query->getResult() as $row) { $role = new Role(); $role->setId($row['id'])->setName($row['name']); $toReturn[] = $role; } return $toReturn; }
/** * @param int|null $userId * @param string|null $username * @param string|null $email * @return User[] * @throws \Exception */ public function get($userId = null, $username = null, $email = null) { MDataType::mustBeNullableInt($userId); MDataType::mustBeNullableString($username); MDataType::mustBeNullableString($email); $userList = array(); $sql = "CALL mt_user_get(?, ?, ?);"; $query = new MPDOQuery($sql, $this->connection); $query->bindValue($userId); $query->bindValue($username); $query->bindValue($email); $queryResult = $query->exec(); if ($queryResult == false || $query->getResult()->rowCount() <= 0) { return $userList; } foreach ($query->getResult() as $row) { $user = new User(); $enabledDate = \DateTime::createFromFormat('Y-m-d H:i:s', $row['enabled_date']); $user->setId((int) $row['id'])->setEmail($row['email'])->setPassword($row['password'])->setPhoneNumber($row['phone_number'])->setTwoFactorEnabled($row['two_factor_enabled'] == 1 ? true : false)->setEnabledDate($enabledDate)->setEnabled($row['enabled'] == 1 ? true : false)->setAccessFailedCount((int) $row['access_failed_count'])->setUserName($row['username'])->setRoleList($this->roleBook->get((int) $row['id']))->setProviderUserList($this->providerUserBook->get((int) $row['id'])); $userList[] = $user; } return $userList; }