CXDIUser::GetList

function GetList($aSort=array(), $aFilter=array())
{
	global $DB;

	$arFilter = array();
	foreach($aFilter as $key=>$val)
	{
		$val = $DB->ForSql($val);
		if($val == '')
			continue;
		switch(mb_strtoupper($key))
		{
			case "USER_ID":
				$arFilter[] = "UR.USER_ID=".intval($val);
				break;
			case "GROUP_CODE":
				$arFilter[] = "UR.GROUP_CODE='".$val."'";
				break;
		}
	}

	$arOrder = array();
	foreach($aSort as $key=>$val)
	{
		$ord = (mb_strtoupper($val) <> "ASC"?"DESC":"ASC");
		switch(mb_strtoupper($key))
		{
			case "USER_ID":
				$arOrder[] = "UR.USER_ID ".$ord;
				break;
			case "GROUP_CODE":
				$arOrder[] = "UR.GROUP_CODE ".$ord;
				break;
		}
	}
	if(count($arOrder) == 0)
		$arOrder[] = "UR.USER_ID ASC";
	$sOrder = "nORDER BY ".implode(", ",$arOrder);

	if(count($arFilter) == 0)
		$sFilter = "";
	else
		$sFilter = "nWHERE ".implode("nAND ", $arFilter);

	$strSql = "
		SELECT
			UR.USER_ID
			,UR.GROUP_CODE
		FROM
			b_xdi_user_right UR
		".$sFilter.$sOrder;

	return $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
}