CCrmExternalSale::GetList

static function GetList($arOrder = array(), $arFilter = array())
{
	global $DB;

	$arSelectFields = array('ID', 'ACTIVE', 'DATE_CREATE', 'DATE_UPDATE', 'NAME', 'SCHEME', 'SERVER', 'PORT', 'LOGIN', 'PASSWORD', 'MODIFICATION_LABEL', 'IMPORT_SIZE', 'COOKIE', 'LAST_STATUS', 'IMPORT_PERIOD', "IMPORT_PROBABILITY", "IMPORT_RESPONSIBLE", "IMPORT_PUBLIC", "IMPORT_PREFIX", "IMPORT_ERRORS", 'IMPORT_GROUP_ID', 'LAST_STATUS_DATE', 'SYNC_DATA');

	static $arFields = array(
		"ID" => array("FIELD" => "E.ID", "TYPE" => "int"),
		"ACTIVE" => array("FIELD" => "E.ACTIVE", "TYPE" => "string"),
		"DATE_CREATE" => array("FIELD" => "E.DATE_CREATE", "TYPE" => "datetime"),
		"DATE_UPDATE" => array("FIELD" => "E.DATE_UPDATE", "TYPE" => "datetime"),
		"NAME" => array("FIELD" => "E.NAME", "TYPE" => "string"),
		"SCHEME" => array("FIELD" => "E.SCHEME", "TYPE" => "string"),
		"SERVER" => array("FIELD" => "E.SERVER", "TYPE" => "string"),
		"PORT" => array("FIELD" => "E.PORT", "TYPE" => "int"),
		"LOGIN" => array("FIELD" => "E.LOGIN", "TYPE" => "string"),
		"PASSWORD" => array("FIELD" => "E.PASSWORD", "TYPE" => "string"),
		"MODIFICATION_LABEL" => array("FIELD" => "E.MODIFICATION_LABEL", "TYPE" => "int"),
		"IMPORT_SIZE" => array("FIELD" => "E.IMPORT_SIZE", "TYPE" => "int"),
		"COOKIE" => array("FIELD" => "E.COOKIE", "TYPE" => "string"),
		"LAST_STATUS" => array("FIELD" => "E.LAST_STATUS", "TYPE" => "string"),
		"IMPORT_PERIOD" => array("FIELD" => "E.IMPORT_PERIOD", "TYPE" => "int"),
		"IMPORT_PROBABILITY" => array("FIELD" => "E.IMPORT_PROBABILITY", "TYPE" => "int"),
		"IMPORT_RESPONSIBLE" => array("FIELD" => "E.IMPORT_RESPONSIBLE", "TYPE" => "int"),
		"IMPORT_PUBLIC" => array("FIELD" => "E.IMPORT_PUBLIC", "TYPE" => "string"),
		"IMPORT_PREFIX" => array("FIELD" => "E.IMPORT_PREFIX", "TYPE" => "string"),
		"IMPORT_ERRORS" => array("FIELD" => "E.IMPORT_ERRORS", "TYPE" => "int"),
		"IMPORT_GROUP_ID" => array("FIELD" => "E.IMPORT_GROUP_ID", "TYPE" => "int"),
		"LAST_STATUS_DATE" => array("FIELD" => "E.LAST_STATUS_DATE", "TYPE" => "datetime"),
		"SYNC_DATA" => array("FIELD" => "E.SYNC_DATA", "TYPE" => "string"),
	);

	$arSqls = self::PrepareSql($arFields, $arOrder, $arFilter, $arSelectFields);

	$arSqls["SELECT"] = str_replace("%%_DISTINCT_%%", "", $arSqls["SELECT"]);

	$strSql =
		"SELECT ".$arSqls["SELECT"]." ".
		"FROM b_crm_external_sale E ".
		"	".$arSqls["FROM"]." ";
	if ($arSqls["WHERE"] <> '')
		$strSql .= "WHERE ".$arSqls["WHERE"]." ";
	if ($arSqls["ORDERBY"] <> '')
		$strSql .= "ORDER BY ".$arSqls["ORDERBY"]." ";

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

	return $dbRes;
}