/**
* Список элементов
* @param array $arOrder
* @param array $arFilter
* @param array $arSelect
* @param array $arLimit
* @return DBResult
*/
public static function GetList($arOrder = array(), $arFilter = array(), $arSelect = array(), $arLimit = array())
{
global $DB;
if ($arFilter["CATALOG_SECTION_ID"] === 0) {
$arFilter["CATALOG_SECTION_ID"] = 'NULL';
}
$sql = getListSql(self::$table, $arOrder, $arFilter, $arSelect, $arLimit);
d($sql);
$res = $DB->Query($sql, "\\ScriptAcid\\CatalogSectionResult");
if ($DB->Error()) {
dbError($DB->Error());
return false;
}
parent::$result = $res;
return $res;
}
public static function GetList($arOrder = array(), $arFilter = array(), $arSelect = array(), $arLimit = array())
{
$DB = App::DB();
$arFilter = self::GetFilter($arFilter);
if (empty($arOrder)) {
$arOrder = array("SORT" => "ASC");
}
$arOrder = self::GetSort($arOrder);
$tables = array("CATALOG" => self::$table_catalog, "ELEMENT" => self::$table);
if (is_array($arLimit) and !empty($arLimit)) {
$page = !empty($arLimit['PAGE']) ? (int) $arLimit['PAGE'] : 1;
$total_count = self::GetCount($arFilter);
$arLimit['COUNT'] = $arLimit['COUNT'] > 0 ? $arLimit['COUNT'] : 3;
$pagination = new Paginator($arLimit['PAGE'], $arLimit['COUNT'], $total_count);
self::$pagination = $pagination->GetHtml();
$arLimit['OFFSET'] = $pagination->Offset();
} else {
$arLimit = array();
self::$pagination = '';
}
$sql = getListSql($tables, $arOrder, $arFilter, $arSelect, $arLimit);
//d($sql);
$res = $DB->Query($sql, "ScriptAcid\\CatalogElementResult");
if ($DB->Error()) {
dbError($DB->Error());
return false;
}
parent::$result = $res;
return $res;
}
