CTicket::GetSupportTeamList

static function GetSupportTeamList()
{
	$err_mess = (CTicket::err_mess())."
Function: GetSupportTeamList
Line: ";
	global $DB;
	$arrGid = CTicket::GetSupportTeamGroups();
	$arrAid = CTicket::GetAdminGroups();
	if (count($arrGid)>0)
	{
		$gid = implode(",",$arrGid);
	}
	else
	{
		$gid = 0;
	}
	if (count($arrAid)>0)
	{
		$aid = implode(",",$arrAid);
	}
	else
	{
		$aid = 0;
	}
	$strSql = "
		SELECT DISTINCT
			U.ID as REFERENCE_ID,
			concat('[',U.ID,'] ',' (',U.LOGIN,') ',ifnull(U.NAME,''),' ',ifnull(U.LAST_NAME,'')) as REFERENCE,
			U.ACTIVE
		FROM
			b_user U,
			b_user_group G
		WHERE
			U.ID = G.USER_ID
		and G.GROUP_ID in ($gid, $aid)
		ORDER BY
			U.ID
		";
	$res = $DB->Query($strSql, false, $err_mess.__LINE__);
	return $res;
}