/** * отображаем весь список материалов */ function indexAction() { // если перешли по get ссылке из меню if (isset($_POST['name'])) { $_SESSION['name'] = $_POST['name']; } if (isset($_POST['artikul'])) { $_SESSION['artikul'] = $_POST['artikul']; } if ($_POST) { if (isset($_POST['block_new'])) { $_SESSION['block_new'] = $_POST['block_new']; } else { unset($_SESSION['block_new']); } if (isset($_POST['block_lider'])) { $_SESSION['block_lider'] = $_POST['block_lider']; } else { unset($_SESSION['block_lider']); } } if (isset($_POST['id_parent'])) { $_SESSION['id_parent'] = $_POST['id_parent']; } if (isset($_POST['brand'])) { $_SESSION['brand'] = $_POST['brand']; } if (isset($_POST['photo'])) { $_SESSION['photo'] = $_POST['photo']; } if (isset($_POST['sklad'])) { $_SESSION['sklad'] = $_POST['sklad']; } if (isset($_POST['status'])) { $_SESSION['status'] = $_POST['status']; } // get limit // всего в каталоге $_total_catalog = dbh::catalog_get_total_count(); $limit = pager::pager_limit($_total_catalog, ADMIN_CATALOG_AT_PAGE); // строим запрос $_sql = 'SELECT * FROM ' . $this->tablename . ' where id>0 ' . general::get_status_for_filter($this->tablename) . ' order by sort limit ' . $limit; // выполняем запрос + при необходимости выводим сам запрос $result = mysql::query($_sql, 0); return system::show_tpl(array('result' => $result, 'msg' => $this->msg, '_total_catalog' => $_total_catalog, '_status' => isset($_SESSION['status']) ? $_SESSION['status'] : 2, '_brand' => isset($_SESSION['brand']) ? $_SESSION['brand'] : 0, '_photo' => isset($_SESSION['photo']) ? $_SESSION['photo'] : 2, '_sklad' => isset($_SESSION['sklad']) ? $_SESSION['sklad'] : 3, 'tpl_folder' => $this->tpl_folder, 'select' => dbh::get_catolog_tree(), 'brand' => dbh::get_brand(), 'curent_id_parent' => isset($_SESSION['id_parent']) ? $_SESSION['id_parent'] : 0), $this->tpl_folder . '/index.php'); }