Find the link from access level back to user's usergroup

Question

In my Joomla system there is an access level that grants permission to an area of the system.

This access level is granted to several different user groups.

In plugin code, I am at a position where I know that a user has been granted the access level, but I now need to know which of those groups he is a member of in order to have been granted it.

Is there an easy way to query for this?

Answer 1

Try this:

$user = JFactory::getUser();
$usergroups = JAccess::getGroupsByUser($user->id,false);

$db = JFactory::getDBO();
$query = $db->getQuery(true);   
$query->select('title, rules');
$query->from('#__viewlevels');
$db->setQuery($query);
$rows = $db->loadObjectList();

$viewlevels = array();
$levels = array();

foreach($rows as $viewlevel){
    $viewlevels[$viewlevel->title] = json_decode($viewlevel->rules);
}

foreach($viewlevels as $level => $viewgroups){
    $result = array_intersect($usergroups, $viewgroups);
    if(!empty($result)){
        $levels[] = $level;
    }
}

echo '<pre>';
print_r($levels);
echo '</pre>';

This will give you an array of view levels that the user has access to, you can then compare that to the view level of your current article, menu item, etc. The false flag sets getGroupsByUser to only return important groups (strips out public, guest, etc)

ALso if you want to filter out default access levels just add this to the query for the #__viewlevels table right after the "$query->from" statement on the next line:

$query->where("title NOT IN ('Guest','Public','Registered','Special','Super Users')");