apply_for_role_views_handler_field_user_roles.inc in Apply for role 7.2
File
views/handlers/apply_for_role_views_handler_field_user_roles.inc
View source
<?php
class apply_for_role_views_handler_field_user_roles extends views_handler_field_prerender_list {
function construct() {
parent::construct();
$this->additional_fields['uid'] = array(
'table' => 'users_roles_apply',
'field' => 'uid',
);
}
function query() {
$this
->add_additional_fields();
$this->field_alias = $this->aliases['uid'];
}
function pre_render(&$values) {
$uids = array();
$this->items = array();
foreach ($values as $result) {
$uids[] = $result->{$this->aliases['uid']};
}
if ($uids) {
$result = db_query("SELECT u.uid, u.rid, r.name\n FROM {role} r\n INNER JOIN {users_roles} u\n ON u.rid = r.rid\n WHERE u.uid\n IN (:uids)\n 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;
}
}
}
function render_item($count, $item) {
return $item['role'];
}
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.');
}
function add_self_tokens(&$tokens, $item) {
$tokens['[' . $this->options['id'] . '-role' . ']'] = $item['role'];
$tokens['[' . $this->options['id'] . '-rid' . ']'] = $item['rid'];
}
}