CAllControllerMember::GetLog

static function GetLog($arFilter)
{
	global $DB;

	$obQueryWhere = new CSQLWhere;
	$arFields = array(
		"CONTROLLER_MEMBER_ID" => array(
			"TABLE_ALIAS" => "l",
			"FIELD_NAME" => "l.CONTROLLER_MEMBER_ID",
			"FIELD_TYPE" => "int",
			"JOIN" => false,
		),
		"FIELD" => array(
			"TABLE_ALIAS" => "l",
			"FIELD_NAME" => "l.FIELD",
			"FIELD_TYPE" => "string",
			"JOIN" => false,
		),
	);
	$obQueryWhere->SetFields($arFields);

	if(!is_array($arFilter))
		$arFilter = array();
	$strQueryWhere = $obQueryWhere->GetQuery($arFilter);

	$strSql = "
		SELECT l.*
			,".$DB->DateToCharFunction("l.CREATED_DATE", "FULL")." CREATED_DATE
			,".$DB->Concat("'('", "U.LOGIN", "') '", "U.NAME", "' '", "U.LAST_NAME")." USER_ID_USER
		FROM b_controller_member_log l
		LEFT JOIN b_user U ON U.ID = l.USER_ID
	";

	if($strQueryWhere)
	{
		$strSql .= "
			WHERE
			".$strQueryWhere."
		";
	}

	$strSql .= "
		ORDER BY l.ID DESC
	";

	return $DB->Query($strSql);
}