00001 <?php
00007 class views_handler_field_user_permissions 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
00028
00029 $module_info = system_get_info('module');
00030 $modules = array();
00031 foreach (module_implements('permission') as $module) {
00032 $modules[$module] = $module_info[$module]['name'];
00033 }
00034 asort($modules);
00035
00036 $permissions = module_invoke_all('permission');
00037
00038 $result = db_query("SELECT u.uid, u.rid, rp.permission FROM {role_permission} rp INNER JOIN {users_roles} u ON u.rid = rp.rid WHERE u.uid IN (:uids) AND rp.module IN (:modules) ORDER BY rp.permission",
00039 array(':uids' => $uids, ':modules' => array_keys($modules)));
00040
00041 foreach ($result as $perm) {
00042 $this->items[$perm->uid][$perm->permission]['permission'] = $permissions[$perm->permission]['title'];
00043 }
00044 }
00045 }
00046
00047 function render_item($count, $item) {
00048 return $item['permission'];
00049 }
00050
00051
00052
00053
00054
00055
00056
00057
00058
00059
00060
00061
00062 }