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;
}
public function GetList($arFilter = array(), $arPaginator = array())
{
global $DB;
// Постраничка
if (!empty($arPaginator)) {
$page = !empty($arPaginator['PAGE']) ? (int) $arPaginator['PAGE'] : 1;
$per_page = $arPaginator['PAGE_COUNT'];
$total_count = $this->GetCount();
$pagination = new Paginator($page, $per_page, $total_count);
$arFiles['PAGINATOR'] = $pagination->GetHtml();
}
// TODO: Добавить фильтр
$sql = "SELECT * FROM `" . self::$file_db . "`";
if (!empty($arPaginator)) {
$sql .= "LIMIT {$per_page} ";
$sql .= "OFFSET {$pagination->Offset()}";
}
$DB->Query($sql);
while ($arFile = $DB->Fetch()) {
$arFiles['FILES'][] = $arFile;
}
if (empty($arFiles)) {
return false;
}
return $arFiles;
}
/**
* Получить список пользователей по фильтру
* @global object $DB
* @param array $arFilter
* @param array $arPaginator
* @return array
*/
public function GetList($arFilter = array(), $arPaginator = array())
{
$DB = App::DB();
// Постраничка
if (!empty($arPaginator)) {
$page = !empty($arPaginator['PAGE']) ? (int) $arPaginator['PAGE'] : 1;
$per_page = $arPaginator['PAGE_COUNT'];
$total_count = $this->GetCount();
$pagination = new Paginator($page, $per_page, $total_count);
$arUsers['PAGINATOR'] = $pagination->GetHtml();
}
// TODO: Добавить фильтр
$sql = "SELECT * FROM `b_user`";
if (!empty($arPaginator)) {
$sql .= "LIMIT {$per_page} ";
$sql .= "OFFSET {$pagination->Offset()}";
}
$DB->Query($sql);
while ($arUser = $DB->Fetch()) {
$arUsers['USERS'][] = $arUser;
}
if (empty($arUsers)) {
return false;
}
foreach ($arUsers as $k => $user) {
$sqlg = "SELECT * FROM `b_user_group` WHERE `USER_ID` = '" . $user["ID"] . "';";
$DB->Query($sqlg);
while ($arGroup = $DB->Fetch()) {
$arUsers['USERS'][$k]["GROUPS"][] = $arGroup["GROUP_ID"];
}
}
return $arUsers;
}
