aDriv4 - MANAGER

Edit File: views_handler_field_user_roles.inc

<?php

/**
 * @file
 * Definition of views_handler_field_user_roles.
 */

/**
 * Field handler to provide a list of roles.
 *
 * @ingroup views_field_handlers
 */
class views_handler_field_user_roles extends views_handler_field_prerender_list {

/**
   * {@inheritdoc}
   */
  public function construct() {
    parent::construct();
    $this->additional_fields['uid'] = array('table' => 'users', 'field' => 'uid');
  }

function option_definition() {
    $options = parent::option_definition();
    $options['display_roles'] = array('default' => array());

return $options;
  }

function options_form(&$form, &$form_state) {
    $roles = user_roles(TRUE);
    unset($roles[DRUPAL_AUTHENTICATED_RID]);
    if (!empty($roles)) {
      $form['display_roles'] = array(
        '#type' => 'checkboxes',
        '#title' => t('Only display the selected roles'),
        '#description' => t("If no roles are selected, all of the user's roles will be shown."),
        '#options' => $roles,
        '#default_value' => $this->options['display_roles'],
      );
    }
    parent::options_form($form, $form_state);
  }

/**
   * {@inheritdoc}
   */
  public function query() {
    $this->add_additional_fields();
    $this->field_alias = $this->aliases['uid'];
  }

/**
   * {@inheritdoc}
   */
  public function pre_render(&$values) {
    $uids = array();
    $this->items = array();

foreach ($values as $result) {
      $uids[] = $this->get_value($result, NULL, TRUE);
    }

if ($uids) {
      $rids = array_filter($this->options['display_roles']);
      if (!empty($rids)) {
        $result = db_query("SELECT u.uid, u.rid, r.name FROM {role} r INNER JOIN {users_roles} u ON u.rid = r.rid WHERE u.uid IN (:uids) AND r.rid IN (:rids) ORDER BY r.name",
          array(':uids' => $uids, ':rids' => $rids));
      }
      else {
        $result = db_query("SELECT u.uid, u.rid, r.name FROM {role} r INNER JOIN {users_roles} u ON u.rid = r.rid WHERE u.uid IN (:uids) ORDER BY r.name",
          array(':uids' => $uids));
      }
      foreach ($result as $role) {
        $this->items[$role->uid][$role->rid]['role'] = check_plain($role->name);
        $this->items[$role->uid][$role->rid]['rid'] = $role->rid;
      }
    }
  }

/**
   * {@inheritdoc}
   */
  public function render_item($count, $item) {
    return t($item['role']);
  }

/**
   * {@inheritdoc}
   */
  public function document_self_tokens(&$tokens) {
    $tokens['[' . $this->options['id'] . '-role' . ']'] = t('The name of the role.');
    $tokens['[' . $this->options['id'] . '-rid' . ']'] = t('The role ID of the role.');
  }

/**
   * {@inheritdoc}
   */
  public function add_self_tokens(&$tokens, $item) {
    if (!empty($item['role'])) {
      $tokens['[' . $this->options['id'] . '-role' . ']'] = $item['role'];
      $tokens['[' . $this->options['id'] . '-rid' . ']'] = $item['rid'];
    }
  }

}