API16

API16:JAccess/getGroupsByUser

From Joomla! Documentation

Revision as of 22:34, 22 March 2010 by Doxiki (talk | contribs) (New page: ===Description=== Method to return a list of user groups mapped to a user. The returned list can optionally hold only the groups explicitly mapped to the user or all groups both explicitl...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Description

Method to return a list of user groups mapped to a user. The returned list can optionally hold only the groups explicitly mapped to the user or all groups both explicitly mapped and inherited by the user.

[Edit Descripton]

Template:Description:JAccess/getGroupsByUser

Syntax

static getGroupsByUser($userId, $recursive=true)
Parameter Name Default Value Description
$userId Id of the user for which to get the list of groups.
$recursive true True to include inherited user groups.

Returns

array List of user group ids to which the user is mapped.

Defined in

libraries/joomla/access/access.php

Importing

jimport( 'joomla.access.access' );

Source Body

public static function getGroupsByUser($userId, $recursive = true)
{
        // Get the database connection object.
        $db = JFactory::getDbo();

        // Build the database query to get the rules for the asset.
        $query  = $db->getQuery(true);
        $query->select($recursive ? 'b.id' : 'a.id');
        $query->from('#__user_usergroup_map AS map');
        $query->where('map.user_id = '.(int) $userId);
        $query->leftJoin('#__usergroups AS a ON a.id = map.group_id');

        // If we want the rules cascading up to the global asset node we need a self-join.
        if ($recursive) {
                $query->leftJoin('#__usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt');
        }

        // Execute the query and load the rules from the result.
        $db->setQuery($query);
        $result = $db->loadResultArray();

        // Clean up any NULL or duplicate values, just in case
        JArrayHelper::toInteger($result);
        if (empty($result)) {
                $result = array('1');
        } else {
                $result = array_unique($result);
        }

        return $result;
}

[Edit See Also] Template:SeeAlso:JAccess/getGroupsByUser

Examples

<CodeExamplesForm />