CAllTicket::GetResponsibleList

static function GetResponsibleList($userID, $CMGM = null, $CMUGM = null, $SG = null)
{
			
	$condition = "";
	if($CMGM != null) $condition .= "
						AND TUG2.CAN_MAIL_GROUP_MESSAGES = '" . ($CMGM == "Y" ? "Y" : "N") . "'";
	if($CMUGM != null) $condition .= "
						AND TUG2.CAN_MAIL_UPDATE_GROUP_MESSAGES = '" . ($CMUGM == "Y" ? "Y" : "N") . "'";
	
	$condition2 = "";
	if($SG != null) $condition2 .= "
						AND TG.IS_TEAM_GROUP = '" . ($SG == "Y" ? "Y" : "N") . "'";
	
	
	$err_mess = (CTicket::err_mess())."
Function: GetSupportTeamMailList
Line: ";
	global $DB;
	$strSql = "
		SELECT
			U.ID as ID,
			U.LOGIN as LOGIN,
			". $DB->Concat(CTicket::isnull("U.LAST_NAME", "''"), CTicket::isnull("U.NAME", "''"), 'U.LOGIN')." as NAME,
			U.EMAIL as EMAIL
		FROM
			(
			SELECT
				TUG2.USER_ID AS USER_ID				
			FROM
				b_ticket_ugroups TG
				INNER JOIN b_ticket_user_ugroup TUG
					ON TG.ID = TUG.GROUP_ID" . $condition2 . "
				INNER JOIN b_ticket_user_ugroup TUG2
					ON TUG.USER_ID = '" . intval($userID) . "'
						AND TUG.GROUP_ID = TUG2.GROUP_ID" . $condition . "
			GROUP BY
				TUG2.USER_ID
			) TU
			INNER JOIN b_user U
				ON TU.USER_ID = U.ID
			ORDER BY
				U.ID

		";
	$res = $DB->Query($strSql, false, $err_mess.__LINE__);
	return $res;
}