static public getGroupUsers ( $groups_id, $condition = '' ) | ||
$groups_id | ||
$condition | (default '') |
static function getGroupUsers($groups_id, $condition = '')
{
global $DB;
$users = array();
$query = "SELECT `glpi_users`.*,\n `glpi_groups_users`.`id` AS IDD,\n `glpi_groups_users`.`id` AS linkID,\n `glpi_groups_users`.`is_dynamic` AS is_dynamic,\n `glpi_groups_users`.`is_manager` AS is_manager,\n `glpi_groups_users`.`is_userdelegate` AS is_userdelegate\n FROM `glpi_groups_users`\n LEFT JOIN `glpi_users` ON (`glpi_users`.`id` = `glpi_groups_users`.`users_id`)\n WHERE `glpi_groups_users`.`groups_id` = '{$groups_id}'";
if (!empty($condition)) {
$query .= " AND {$condition} ";
}
$query .= "ORDER BY `glpi_users`.`name`";
foreach ($DB->request($query) as $data) {
$users[] = $data;
}
return $users;
}
/** * get users linked to an object including groups ones * * @since version 0.85 * * @param $type type to search (see constants) * * @return array **/ function getAllUsers($type) { $users = array(); foreach ($this->getUsers($type) as $link) { $users[$link['users_id']] = $link['users_id']; } foreach ($this->getGroups($type) as $link) { $gusers = Group_User::getGroupUsers($link['groups_id']); foreach ($gusers as $user) { $users[$user['id']] = $user['id']; } } return $users; }