public function ForcePasswordChangeMapper::getUserCountForRole in Force Password Change 8

Same name and namespace in other branches

1. 2.0.x src/Mapper/ForcePasswordChangeMapper.php \Drupal\force_password_change\Mapper\ForcePasswordChangeMapper::getUserCountForRole()

*

Overrides ForcePasswordChangeMapperInterface::getUserCountForRole

File

src/Mapper/ForcePasswordChangeMapper.php, line 115

Class

ForcePasswordChangeMapper

Namespace

Drupal\force_password_change\Mapper

Code

public function getUserCountForRole($rid = FALSE) {
  $sql = 'SELECT COUNT(ufd.uid) FROM {users_field_data} AS ufd ';
  $values = [];
  if ($rid) {
    $sql .= 'JOIN {user__roles} AS roles ON roles.entity_id = ufd.uid AND roles.roles_target_id = :rid ';
    $values[':rid'] = $rid;
  }
  $sql .= 'WHERE ufd.status = 1';
  return $this->connection
    ->query($sql, $values)
    ->fetchField();
}