public function AutocompleteController::suggestions in Open Social 8

Same name and namespace in other branches

1. 8.9 modules/social_features/social_mentions/src/Controller/AutocompleteController.php \Drupal\social_mentions\Controller\AutocompleteController::suggestions()
2. 8.2 modules/social_features/social_mentions/src/Controller/AutocompleteController.php \Drupal\social_mentions\Controller\AutocompleteController::suggestions()
3. 8.3 modules/social_features/social_mentions/src/Controller/AutocompleteController.php \Drupal\social_mentions\Controller\AutocompleteController::suggestions()
4. 8.4 modules/social_features/social_mentions/src/Controller/AutocompleteController.php \Drupal\social_mentions\Controller\AutocompleteController::suggestions()
5. 8.5 modules/social_features/social_mentions/src/Controller/AutocompleteController.php \Drupal\social_mentions\Controller\AutocompleteController::suggestions()
6. 8.6 modules/social_features/social_mentions/src/Controller/AutocompleteController.php \Drupal\social_mentions\Controller\AutocompleteController::suggestions()
7. 8.7 modules/social_features/social_mentions/src/Controller/AutocompleteController.php \Drupal\social_mentions\Controller\AutocompleteController::suggestions()
8. 8.8 modules/social_features/social_mentions/src/Controller/AutocompleteController.php \Drupal\social_mentions\Controller\AutocompleteController::suggestions()
9. 10.3.x modules/social_features/social_mentions/src/Controller/AutocompleteController.php \Drupal\social_mentions\Controller\AutocompleteController::suggestions()
10. 10.0.x modules/social_features/social_mentions/src/Controller/AutocompleteController.php \Drupal\social_mentions\Controller\AutocompleteController::suggestions()
11. 10.1.x modules/social_features/social_mentions/src/Controller/AutocompleteController.php \Drupal\social_mentions\Controller\AutocompleteController::suggestions()
12. 10.2.x modules/social_features/social_mentions/src/Controller/AutocompleteController.php \Drupal\social_mentions\Controller\AutocompleteController::suggestions()

Function for suggestions.

Parameters

\Symfony\Component\HttpFoundation\Request $request: The request.

Return value

\Symfony\Component\HttpFoundation\JsonResponse Returns a JsonResponse.

1 string reference to 'AutocompleteController::suggestions'

social_mentions.routing.yml in modules/social_features/social_mentions/social_mentions.routing.yml

modules/social_features/social_mentions/social_mentions.routing.yml

File

modules/social_features/social_mentions/src/Controller/AutocompleteController.php, line 81

Class

AutocompleteController

Class AutocompleteController.

Namespace

Drupal\social_mentions\Controller

Code

public function suggestions(Request $request) {
  $name = $request
    ->get('term');
  $config = $this->configFactory
    ->get('mentions.settings');
  $connection = Database::getConnection();
  $name = $connection
    ->escapeLike($name);
  $suggestion_format = $config
    ->get('suggestions_format');
  $query = $this->database
    ->select('users', 'u');
  $query
    ->join('users_field_data', 'uf', 'uf.uid = u.uid');
  switch ($suggestion_format) {
    case SOCIAL_MENTIONS_SUGGESTIONS_USERNAME:
      $query
        ->condition('uf.name', '%' . $name . '%', 'LIKE');
      break;
    case SOCIAL_MENTIONS_SUGGESTIONS_FULL_NAME:
      $query
        ->join('profile', 'p', 'p.uid = u.uid');
      $query
        ->join('profile__field_profile_first_name', 'fn', 'fn.entity_id = p.profile_id');
      $query
        ->join('profile__field_profile_last_name', 'ln', 'ln.entity_id = p.profile_id');
      $or = $query
        ->orConditionGroup();
      $or
        ->condition('fn.field_profile_first_name_value', '%' . $name . '%', 'LIKE')
        ->condition('ln.field_profile_last_name_value', '%' . $name . '%', 'LIKE');
      $query
        ->condition($or);
      break;
    case SOCIAL_MENTIONS_SUGGESTIONS_ALL:
      $query
        ->leftJoin('profile', 'p', 'p.uid = u.uid');
      $query
        ->leftJoin('profile__field_profile_first_name', 'fn', 'fn.entity_id = p.profile_id');
      $query
        ->leftJoin('profile__field_profile_last_name', 'ln', 'ln.entity_id = p.profile_id');
      $or = $query
        ->orConditionGroup();
      $or
        ->condition('uf.name', '%' . $name . '%', 'LIKE')
        ->condition('fn.field_profile_first_name_value', '%' . $name . '%', 'LIKE')
        ->condition('ln.field_profile_last_name_value', '%' . $name . '%', 'LIKE');
      $query
        ->condition($or);
      break;
  }
  $result = $query
    ->fields('u', [
    'uid',
  ])
    ->condition('uf.status', 1)
    ->range(0, 8)
    ->execute()
    ->fetchCol();
  $response = [];
  $accounts = User::loadMultiple($result);
  $storage = $this->entityTypeManager
    ->getStorage('profile');
  $view_builder = $this->entityTypeManager
    ->getViewBuilder('profile');

  /* @var \Drupal\Core\Session\AccountInterface $account */
  foreach ($accounts as $account) {
    $item = [
      'uid' => $account
        ->id(),
      'username' => $account
        ->getAccountName(),
      'value' => $account
        ->getAccountName(),
      'html_item' => '<div>' . $account
        ->getAccountName() . '</div>',
      'profile_id' => '',
    ];
    if ($storage && ($profile = $storage
      ->loadByUser($account, 'profile', TRUE)) && $suggestion_format != SOCIAL_MENTIONS_SUGGESTIONS_USERNAME) {
      $build = $view_builder
        ->view($profile, 'autocomplete_item');
      $item['html_item'] = render($build);
      $item['profile_id'] = $profile
        ->id();
      $item['value'] = $account
        ->getDisplayName();
    }
    $response[] = $item;
  }
  return new JsonResponse($response);
}