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;
}