public function getProfileData(User $user) { $result = []; $result['subscribe'] = ['enabled' => $user->getIsSubscribed()]; $result['profile'] = $user; $connection = $this->getEntityManager()->getConnection(); $settings = $connection->fetchAll('SELECT tkey, value FROM ed_users_settings WHERE user_id=:user AND tkey IN (:keys)', ['user' => $user->getId(), 'keys' => ['lk_user_disabled', 'lk_privacy_disabled', 'lk_balance_disabled', 'lk_additional_disabled']], ['keys' => Connection::PARAM_STR_ARRAY]); $result['settings'] = []; foreach ($settings as $setting) { $result['settings'][$setting['tkey']] = $setting['value']; } return $result; }