CTicket::GetResponsibleList

function GetResponsibleList($user_id)
{
	$err_mess = (CTicket::err_mess())."
Function: GetSupportTeamMailList
Line: ";
	global $DB;

	$strSql = "
		SELECT DISTINCT
			U.ID as ID,
			U.LOGIN as LOGIN,
			concat('[',U.ID,'] ',' (',U.LOGIN,') ',ifnull(U.NAME,''),' ',ifnull(U.LAST_NAME,'')) as NAME,
			U.EMAIL as EMAIL
		FROM
			b_user U,
			b_ticket_user_ugroup TUG,
			b_ticket_user_ugroup TUG2
		WHERE
			TUG.USER_ID = '".intval($user_id)."'
		and TUG2.GROUP_ID = TUG.GROUP_ID
		and U.ID = TUG2.USER_ID
		and TUG2.CAN_MAIL_GROUP_MESSAGES = 'Y'
		ORDER BY
			U.ID
		";
	$res = $DB->Query($strSql, false, $err_mess.__LINE__);
	return $res;
}