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; }