00001 <?php
00007 class views_handler_field_user_roles extends views_handler_field_prerender_list {
00008 function construct() {
00009 parent::construct();
00010 $this->additional_fields['uid'] = array('table' => 'users', 'field' => 'uid');
00011 }
00012
00013 function query() {
00014 $this->add_additional_fields();
00015 $this->field_alias = $this->aliases['uid'];
00016 }
00017
00018 function pre_render(&$values) {
00019 $uids = array();
00020 $this->items = array();
00021
00022 foreach ($values as $result) {
00023 $uids[] = $this->get_value($result, NULL, TRUE);
00024 }
00025
00026 if ($uids) {
00027 $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",
00028 array(':uids' => $uids));
00029 foreach ($result as $role) {
00030 $this->items[$role->uid][$role->rid]['role'] = check_plain($role->name);
00031 $this->items[$role->uid][$role->rid]['rid'] = $role->rid;
00032 }
00033 }
00034 }
00035
00036 function render_item($count, $item) {
00037 return $item['role'];
00038 }
00039
00040 function document_self_tokens(&$tokens) {
00041 $tokens['[' . $this->options['id'] . '-role' . ']'] = t('The name of the role.');
00042 $tokens['[' . $this->options['id'] . '-rid' . ']'] = t('The role ID of the role.');
00043 }
00044
00045 function add_self_tokens(&$tokens, $item) {
00046 $tokens['[' . $this->options['id'] . '-role' . ']'] = $item['role'];
00047 $tokens['[' . $this->options['id'] . '-rid' . ']'] = $item['rid'];
00048 }
00049 }
