function _webform_access_tokens_get_access_group_emails in Webform 6.x

Same name and namespace in other branches

1. 8.5 modules/webform_access/webform_access.tokens.inc \_webform_access_tokens_get_access_group_emails()

Get webform access group administrator or user email addresses.

@internal

Parameters

string $type: The type of user (admin or user).

array $group_ids: An array of webform access group ids.

Return value

string Administrator or user email addresses.

1 call to _webform_access_tokens_get_access_group_emails()

webform_access_tokens in modules/webform_access/webform_access.tokens.inc

Implements hook_tokens().

File

modules/webform_access/webform_access.tokens.inc, line 165

Builds placeholder replacement tokens for webform access type.

Code

function _webform_access_tokens_get_access_group_emails($type, array $group_ids) {
  $query = \Drupal::database()
    ->select('webform_access_group_' . $type, 'gu');
  $query
    ->condition('gu.group_id', $group_ids, 'IN');
  $query
    ->join('users_field_data', 'u', 'u.uid = gu.uid');
  $query
    ->fields('u', [
    'mail',
  ]);
  $query
    ->condition('u.status', 1);
  $query
    ->condition('u.mail', '', '<>');
  $query
    ->orderBy('mail');
  $query
    ->distinct();
  return $query
    ->execute()
    ->fetchCol();
}