Exemplo n.º 1
0
 /**
  * Формирование данных доступных в шаблоне страницы "мои заказы".
  */
 function MyOrdersPage()
 {
     if (!A::$AUTH->isLogin()) {
         A::goUrl(getSectionLink(SECTION));
     }
     $orders = array();
     $pager = new A_Pager(20);
     $pager->tab = "orders";
     $pager->query("SELECT * FROM " . SECTION . "_orders WHERE iduser=? ORDER BY date DESC", A::$AUTH->id);
     while ($row = $pager->fetchRow()) {
         if ($section = getSectionByModule('robopay')) {
             $row['paylink'] = getSectionLink($section) . "?action=pay&code=" . md5($section . $row['date']);
         }
         $row['pay'] = function_exists('pay_getname') ? pay_getname($row['pay']) : "Наличные";
         $row['basket'] = !empty($row['basket']) ? unserialize($row['basket']) : array();
         $row['sum'] = round($row['sum'], 2);
         $orders[] = $row;
     }
     $pager->free();
     $this->Assign("orders", $orders);
     $this->Assign("orders_pager", $pager);
     $this->AddNavigation(SECTION_NAME, getSectionLink(SECTION));
 }
Exemplo n.º 2
0
 /**
  * Формирование данных доступных в шаблоне.
  */
 function createData()
 {
     $items = array();
     $pager = new A_Pager(A::$OPTIONS['rows']);
     if (!empty($_GET['idsec'])) {
         if (is_array($_GET['idsec'])) {
             foreach ($_GET['idsec'] as $i => $id) {
                 $idsec[$i] = (int) $id;
             }
         } else {
             $idsec = array((int) $_GET['idsec']);
         }
     }
     $imodules = array('feedback');
     if (!empty($_GET['query'])) {
         $_GET['query'] = mb_substr($_GET['query'], 0, 50);
         $stems = $_stems = array();
         $words = $_words = array();
         $query = explode(" ", $_GET['query']);
         foreach ($query as $word) {
             if (mb_strlen($word) > 2) {
                 $word = mb_strtolower($word);
                 $words[] = $word;
                 $_words[] = empty($_words) ? "+>{$word}" : ">{$word}";
                 if ($stem = A_SearchEngine::getInstance()->getStem($word)) {
                     if (mb_strlen($stem) > 3) {
                         $stems[] = $stem;
                         $_stems[] = empty($_stems) ? "+<{$stem}" : "<{$stem}";
                     }
                 }
             }
         }
         $_words = A::$DB->real_escape_string(implode(" ", $_words));
         $_stems = A::$DB->real_escape_string(implode(" ", $_stems));
         if (!empty($_words)) {
             $pager->query("\r\r\n\t    SELECT `date`,`idsec`,`iditem`,`name`,`content`,`idtags`,\r\r\n\t    MATCH(`name`) AGAINST('{$_words}')+MATCH(`content`) AGAINST('{$_words}')+MATCH(`stems`) AGAINST('{$_stems}') AS relevant\r\r\n\t    FROM " . SECTION . "\r\r\n\t    WHERE " . (!empty($idsec) ? "idsec IN(" . implode(",", $idsec) . ") AND " : "") . "\r\r\n\t    ( MATCH(`name`) AGAINST ('{$_words}' IN BOOLEAN MODE)\r\r\n\t      OR\r\r\n\t\t  MATCH(`content`) AGAINST ('{$_words}' IN BOOLEAN MODE)\r\r\n\t\t  OR\r\r\n\t\t  MATCH(`stems`) AGAINST ('{$_stems}' IN BOOLEAN MODE)\r\r\n\t    )\r\r\n\t    ORDER BY `relevant` DESC, `date` DESC");
             while ($row = $pager->fetchRow()) {
                 $row['num'] = $pager->begin + count($items);
                 $row['description'] = A_SearchEngine::getInstance()->getFindedText($words, $stems, $row['content']);
                 if ($srow = A::$DB->getRowById($row['idsec'], DOMAIN . "_sections")) {
                     $section = DOMAIN . '_' . $srow['lang'] . '_' . $srow['name'];
                     if (!empty($row['name']) && !in_array($srow['module'], $imodules)) {
                         if (!empty($srow['caption_' . LANG])) {
                             $row['name'] = $srow['caption_' . LANG] . " - " . $row['name'];
                         }
                     } else {
                         $row['name'] = $srow['caption_' . LANG];
                     }
                     if ($row['iditem'] > 0) {
                         $row['link'] = function_exists($srow['module'] . '_createItemLink') ? call_user_func($srow['module'] . '_createItemLink', $row['iditem'], $section) : getSectionLink($section);
                     } else {
                         $row['link'] = function_exists($srow['module'] . '_createCategoryLink') ? call_user_func($srow['module'] . '_createCategoryLink', -$row['iditem'], $section) : getSectionLink($section);
                     }
                     $row['images'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_images WHERE idsec=? AND iditem=? ORDER BY sort", array($row['idsec'], $row['iditem']));
                     $row['idimg'] = isset($row['images'][0]['id']) ? $row['images'][0]['id'] : 0;
                     $row['tags'] = A_SearchEngine::getInstance()->getTags($row['idtags']);
                     $items[] = $row;
                 }
             }
             $pager->free();
         }
     } elseif (!empty($_GET['tag'])) {
         if ($_GET['tag'] = mb_substr(mb_strtolower(trim($_GET['tag'])), 0, 50)) {
             if ($idtag = A::$DB->getOne("SELECT id FROM " . SECTION . "_tags WHERE tag=?", $_GET['tag'])) {
                 $idtag = sprintf("%04d", $idtag);
                 $pager->query("\r\r\n\t    SELECT `date`,`idsec`,`iditem`,`name`,`content`,`idtags`\r\r\n\t    FROM " . SECTION . "\r\r\n\t    WHERE " . (!empty($idsec) ? "idsec IN(" . implode(",", $idsec) . ") AND " : "") . "\r\r\n\t    MATCH(`idtags`) AGAINST ('{$idtag}' IN BOOLEAN MODE)\r\r\n\t    ORDER BY `date` DESC");
                 while ($row = $pager->fetchRow()) {
                     $row['num'] = $pager->begin + count($items);
                     $row['description'] = truncate($row['content'], 350);
                     if ($srow = A::$DB->getRowById($row['idsec'], DOMAIN . "_sections")) {
                         $section = DOMAIN . '_' . $srow['lang'] . '_' . $srow['name'];
                         if (!empty($row['name']) && !in_array($srow['module'], $imodules)) {
                             if (!empty($srow['caption_' . LANG])) {
                                 $row['name'] = $srow['caption_' . LANG] . " - " . $row['name'];
                             }
                         } else {
                             $row['name'] = $srow['caption_' . LANG];
                         }
                         if ($row['iditem'] > 0) {
                             $row['link'] = function_exists($srow['module'] . '_createItemLink') ? call_user_func($srow['module'] . '_createItemLink', $row['iditem'], $section) : getSectionLink($section);
                         } else {
                             $row['link'] = function_exists($srow['module'] . '_createCategoryLink') ? call_user_func($srow['module'] . '_createCategoryLink', -$row['iditem'], $section) : getSectionLink($section);
                         }
                         $row['images'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_images WHERE idsec=? AND iditem=? ORDER BY sort", array($row['idsec'], $row['iditem']));
                         $row['idimg'] = isset($row['images'][0]['id']) ? $row['images'][0]['id'] : 0;
                         $row['tags'] = A_SearchEngine::getInstance()->getTags($row['idtags']);
                         $items[] = $row;
                     }
                 }
                 $pager->free();
             }
         }
     }
     $this->Assign("items", $items);
     $this->Assign("items_pager", $pager);
     $this->Assign("sections", A_SearchEngine::getInstance()->getSections());
     $this->AddNavigation(SECTION_NAME);
 }
Exemplo n.º 3
0
 /**
  * Формирование данных доступных в шаблоне.
  */
 function createData()
 {
     if (!A_Session::is_set(SECTION . "_filter")) {
         $this->unFilter();
     }
     $fields = A::$DB->getFields(SECTION . "_orders");
     if (!in_array('pay', $fields)) {
         A::$DB->execute("ALTER TABLE `" . SECTION . "_orders` ADD `pay` int(11) NOT NULL default '0'");
     }
     $categories = A::$DB->getAll("SELECT id,idker,name FROM " . SECTION . "_categories ORDER BY level,sort");
     $this->Assign("categories", $categories);
     if (!empty($_GET['idcat'])) {
         $this->Assign("category", A::$DB->getRowById($_GET['idcat'], SECTION . "_categories"));
         $idcat = (int) $_GET['idcat'];
         $childcats = array($idcat);
         getTreeSubItems(SECTION . "_categories", $idcat, $childcats);
         $where = "(c.idcat IN(" . implode(",", $childcats) . ") OR c.idcat1 IN(" . implode(",", $childcats) . ") OR c.idcat2 IN(" . implode(",", $childcats) . "))";
         $this->Assign("childcats", $childcats = count($childcats));
     } else {
         $where = "";
     }
     if ($filter = $this->getFilter()) {
         $where = !empty($where) ? "{$where} AND {$filter}" : $filter;
     }
     $this->Assign("treebox", new A_CategoriesTree("items"));
     $rows = A_Session::get(SECTION . "_rows", isset($_COOKIE[SECTION . '_rows']) ? $_COOKIE[SECTION . '_rows'] : 20);
     $sort = escape_order_string(A_Session::get(SECTION . "_sort", isset($_COOKIE[SECTION . '_sort']) ? $_COOKIE[SECTION . '_sort'] : A::$OPTIONS['sort']));
     $items = array();
     $pager = new A_Pager($rows);
     $pager->tab = "items";
     $pager->query("\r\r\n\tSELECT c.*,c.svote/c.cvote AS vote,cc.name AS category\r\r\n\tFROM " . SECTION . "_catalog AS c\r\r\n\tLEFT JOIN " . SECTION . "_categories AS cc ON cc.id=c.idcat\r\r\n\t" . (!empty($where) ? " WHERE {$where}" : "") . "\r\r\n\tORDER BY {$sort}");
     while ($row = $pager->fetchRow()) {
         $row['link'] = shoplite_createItemLink($row['id'], SECTION);
         $row['catpath'] = "";
         if (empty($_GET['idcat']) || $childcats > 1) {
             $row['catpath'] .= getTreePath(SECTION . "_categories", $row['idcat']);
         }
         if (!empty($row['idcat1'])) {
             $row['catpath'] .= '<br>' . getTreePath(SECTION . "_categories", $row['idcat1']);
         }
         if (!empty($row['idcat2'])) {
             $row['catpath'] .= '<br>' . getTreePath(SECTION . "_categories", $row['idcat2']);
         }
         $row['vote'] = round($row['vote'], 2);
         if (A::$OPTIONS['useimages']) {
             $row['images'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_images WHERE idsec=? AND iditem=? ORDER BY sort", array(SECTION_ID, $row['id']));
             $row['idimg'] = isset($row['images'][0]['id']) ? $row['images'][0]['id'] : 0;
         }
         if (A::$OPTIONS['usefiles']) {
             $row['files'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_files WHERE idsec=? AND iditem=? ORDER BY sort", array(SECTION_ID, $row['id']));
             $row['idfile'] = isset($row['files'][0]['id']) ? $row['files'][0]['id'] : 0;
         }
         $items[] = $row;
     }
     $pager->free();
     $this->Assign("items", $items);
     $this->Assign("items_pager", $pager);
     $this->Assign("rows", $rows);
     $this->Assign("sort", $sort);
     $this->Assign("filter", !empty($filter));
     if (A::$OPTIONS['usecomments']) {
         $this->Assign("commbox", new A_CommentsEditor(SECTION . "_catalog"));
     }
     $rows = (int) A_Session::get(SECTION . "_rows2", 20);
     $idpays = A::$DB->getCol("SELECT DISTINCT pay FROM " . SECTION . "_orders ORDER BY pay");
     $pays = array();
     foreach ($idpays as $idpay) {
         $pays[$idpay] = function_exists('pay_getname') ? pay_getname($idpay) : "Наличные";
     }
     $pays = array_unique($pays);
     $this->Assign("pays", $pays);
     $where = array();
     if (isset($_GET['date'])) {
         if (!empty($_GET['from'])) {
             $where[] = "date>=" . (int) $_GET['from'];
         }
         if (!empty($_GET['to'])) {
             $where[] = "date<=" . (int) $_GET['to'];
         }
     }
     if (!empty($_GET['sum1'])) {
         $where[] = "sum>=" . (int) $_GET['sum1'];
     }
     if (!empty($_GET['sum2'])) {
         $where[] = "sum<=" . (int) $_GET['sum2'];
     }
     if (isset($_GET['status']) && $_GET['status'] >= 0) {
         $where[] = "status=" . (int) $_GET['status'];
     }
     if (isset($_GET['pay']) && $_GET['pay'] >= 0) {
         $where[] = "pay=" . (int) $_GET['pay'];
     }
     $where = implode(" AND ", $where);
     $orders = array();
     $pager2 = new A_Pager($rows);
     $pager2->tab = "orders";
     $pager2->query("SELECT * FROM " . SECTION . "_orders " . ($where ? "WHERE {$where}" : "") . " ORDER BY status,date DESC");
     while ($row = $pager2->fetchRow()) {
         $row['pay'] = function_exists('pay_getname') ? pay_getname($row['pay']) : "Наличные";
         $row['sum'] = round($row['sum'], 2);
         $orders[] = $row;
     }
     $pager2->free();
     $this->Assign("orders", $orders);
     $this->Assign("orders_pager", $pager2);
     $this->Assign("rows2", $rows);
     $this->Assign("optbox1", new A_OptionsBox("Внешний вид на сайте:", array("idgroup" => 1)));
     $this->Assign("optbox2", new A_OptionsBox("Файлы:", array("idgroup" => 2)));
     $this->Assign("optbox3", new A_OptionsBox("Заказ:", array("idgroup" => 3)));
     $this->Assign("optbox4", new A_OptionsBox("Комментирование и голосование:", array("idgroup" => 4)));
     $this->Assign("optbox5", new A_OptionsBox("Дополнительно:", array("idgroup" => 5)));
     $this->Assign("fieldsbox", new A_FieldsEditor(SECTION . "_catalog", array('tab' => 'opt', 'tab_opt' => 'fields'), false, true));
     $types = array('string' => 'Строка', 'int' => 'Целое число', 'float' => 'Дробное число', 'bool' => 'Логический (Да/Нет)', 'text' => 'Текст', 'select' => 'Значение из списка', 'mselect' => 'Множество значений из списка', 'mprice' => 'Модификатор цены', 'image' => 'Изображение', 'file' => 'Файл');
     $nums = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');
     $cols = array();
     A::$DB->query("SELECT * FROM " . SECTION . "_cols ORDER BY sort");
     while ($row = A::$DB->fetchRow()) {
         $row['num'] = array_shift($nums);
         $row['type'] = isset($types[$row['type']]) ? $types[$row['type']] : $row['type'];
         $cols[] = $row;
     }
     A::$DB->free();
     $this->Assign("cols", $cols);
 }
Exemplo n.º 4
0
 /**
  * Формирование данных доступных в шаблоне страницы категории.
  */
 function CategoryPage()
 {
     $this->supportCached();
     $this->addCacheParam_Get('page');
     if (A::$OPTIONS['usetags']) {
         $this->category['tags'] = A_SearchEngine::getInstance()->convertTags($this->category['tags']);
     }
     $this->Assign("category", $this->category);
     $categories = array();
     A::$DB->query("SELECT * FROM " . SECTION . "_categories WHERE idker={$this->idcat} AND active='Y' ORDER BY sort");
     while ($row = A::$DB->fetchRow()) {
         $row['link'] = gallery_createCategoryLink($row['id'], SECTION);
         $row['subcategories'] = array();
         A::$DB->query("SELECT * FROM " . SECTION . "_categories WHERE idker={$row['id']} AND active='Y' ORDER BY sort");
         while ($subrow = A::$DB->fetchRow()) {
             $subrow['link'] = gallery_createCategoryLink($subrow['id'], SECTION);
             $row['subcategories'][] = $subrow;
         }
         A::$DB->free();
         $categories[] = $row;
     }
     A::$DB->free();
     $this->Assign("categories", $categories);
     $rows = (int) (!empty($_GET['rows'])) ? (int) $_GET['rows'] : A::$OPTIONS['crows'];
     $irows = (int) (!empty($_GET['irows'])) ? (int) $_GET['irows'] : A::$OPTIONS['irows'];
     $sort = escape_order_string(!empty(A::$OPTIONS['mysort']) ? A::$OPTIONS['mysort'] : A::$OPTIONS['sort']);
     $this->Assign("rows", $rows);
     $this->Assign("irows", $irows);
     $this->Assign("sort", $sort);
     $where = $this->frontfilter();
     $albums = array();
     $pager = new A_Pager($rows);
     $pager->query("SELECT *,svote/cvote AS vote FROM " . SECTION . "_albums\tWHERE idcat={$this->idcat} AND active='Y'{$where} ORDER BY {$sort}");
     while ($row = $pager->fetchRow()) {
         $row['link'] = gallery_createItemLink($row['id'], SECTION);
         $row['category'] = getTreePath(SECTION . "_categories", $row['idcat']);
         $row['vote'] = round($row['vote'], 2);
         $row['images'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_images WHERE idsec=? AND iditem=? ORDER BY sort", array(SECTION_ID, $row['id']));
         if (A::$OPTIONS['usetags']) {
             $row['tags'] = A_SearchEngine::getInstance()->convertTags($row['tags']);
         }
         prepareValues(SECTION, $row);
         $row = A::$OBSERVER->Modifier('gallery_prepareValues', SECTION, $row);
         $albums[] = $row;
     }
     $pager->free();
     $this->Assign("albums", $albums);
     $this->Assign("albums_pager", $pager);
     $pager = new A_Pager($irows);
     $images = $pager->setItems(!empty($albums) ? $albums[0]['images'] : array());
     $this->Assign("images", $images);
     $this->Assign("images_pager", $pager);
     $this->AddNavigation(SECTION_NAME, getSectionLink(SECTION));
     $this->AddNavCategories($this->category['idker']);
     $this->title = $this->category['name'] . (!empty($this->title) ? " - " . $this->title : "");
     $this->description = $this->category['description'];
 }
Exemplo n.º 5
0
 function createData()
 {
     $categories = array();
     A::$DB->query("SELECT * FROM " . STRUCTURE . "_categories ORDER BY sort");
     while ($row = A::$DB->fetchRow()) {
         $row['count'] = A::$DB->getCount(STRUCTURE, "idcat=" . $row['id']);
         $row['selected'] = isset($_GET['idcat']) && $_GET['idcat'] == $row['id'];
         $categories[] = $row;
     }
     A::$DB->free();
     $this->Assign("categories", $categories);
     if (empty($_GET['tab']) && !empty($_COOKIE[STRUCTURE . '_idcat'])) {
         $_GET['idcat'] = (int) $_COOKIE[STRUCTURE . '_idcat'];
         $_REQUEST['tab'] = "banners";
     }
     if (!empty($_GET['idcat'])) {
         if ($row = A::$DB->getRowById($idcat = (int) $_GET['idcat'], STRUCTURE . "_categories")) {
             $this->Assign("category", $row);
             $rows = (int) A_Session::get(STRUCTURE . "_rows", isset($_COOKIE[STRUCTURE . '_rows']) ? $_COOKIE[STRUCTURE . '_rows'] : 10);
             $banners = array();
             $pager = new A_Pager($rows);
             $pager->tab = "banners";
             $pager->query("\r\r\n\t\tSELECT * FROM " . STRUCTURE . "\r\r\n\t\tWHERE idcat={$idcat}\r\r\n\t\tORDER BY " . A_Session::get(STRUCTURE . "_sort", isset($_COOKIE[STRUCTURE . '_sort']) ? A::$DB->real_escape_string($_COOKIE[STRUCTURE . '_sort']) : "sort"));
             while ($row = $pager->fetchRow()) {
                 $row['link'] = "http://" . DOMAINNAME . "/getfile/" . SNAME . "/click/?id=" . $row['id'];
                 $row['close'] = $row['active'] == 'N' || $row['date'] == 'Y' && !($row['date1'] < time() && time() < $row['date2']);
                 $banners[] = $row;
             }
             $pager->free();
             $this->Assign("banners", $banners);
             $this->Assign("banners_pager", $pager);
             setcookie(STRUCTURE . "_idcat", $idcat, time() + 31104000);
         } else {
             setcookie(STRUCTURE . "_idcat", 0, time() - 3600);
         }
     }
     $this->Assign("sort", A_Session::get(STRUCTURE . "_sort", isset($_COOKIE[STRUCTURE . '_sort']) ? A::$DB->real_escape_string($_COOKIE[STRUCTURE . '_sort']) : "sort"));
     $this->Assign("rows", A_Session::get(STRUCTURE . "_rows", isset($_COOKIE[STRUCTURE . '_rows']) ? $_COOKIE[STRUCTURE . '_rows'] : 10));
 }
Exemplo n.º 6
0
 /**
  * Формирование данных доступных в шаблоне страницы категории.
  */
 function CategoryPage()
 {
     if (empty($_GET['filter'])) {
         $this->supportCached();
         $this->addCacheParam_Get('filter');
         $this->addCacheParam_Get('page');
     }
     if (A::$OPTIONS['usetags']) {
         $this->category['tags'] = A_SearchEngine::getInstance()->convertTags($this->category['tags']);
     }
     $this->category = A::$OBSERVER->Modifier('fcategory_prepareValues', SECTION, $this->category);
     $this->Assign("category", $this->category);
     $categories = array();
     A::$DB->query("SELECT * FROM " . SECTION . "_categories WHERE idker={$this->idcat} AND active='Y' ORDER BY sort");
     while ($row = A::$DB->fetchRow()) {
         $row['link'] = catalog_createCategoryLink($row['id'], SECTION);
         $row['subcategories'] = array();
         A::$DB->query("SELECT * FROM " . SECTION . "_categories WHERE idker={$row['id']} AND active='Y' ORDER BY sort");
         while ($subrow = A::$DB->fetchRow()) {
             $subrow['link'] = catalog_createCategoryLink($subrow['id'], SECTION);
             $row['subcategories'][] = $subrow;
         }
         A::$DB->free();
         $categories[] = $row;
     }
     A::$DB->free();
     $this->Assign("categories", $categories);
     if (!empty($_REQUEST['sort'])) {
         A_Session::set(SECTION . '_csort', $_REQUEST['sort']);
     }
     if (!empty($_REQUEST['rows'])) {
         A_Session::set(SECTION . '_crows', $_REQUEST['rows']);
     }
     $sort = escape_order_string(A_Session::get(SECTION . '_csort', !empty(A::$OPTIONS['mysort']) ? A::$OPTIONS['mysort'] : A::$OPTIONS['sort']));
     $rows = (int) A_Session::get(SECTION . '_crows', A::$OPTIONS['crows']);
     $this->Assign("rows", $rows);
     $this->Assign("sort", $sort);
     $where = $this->frontfilter();
     $items = array();
     $pager = new A_Pager($rows);
     $pager->query("SELECT *,svote/cvote AS vote FROM " . SECTION . "_catalog WHERE idcat={$this->idcat} AND active='Y'{$where} ORDER BY {$sort}");
     while ($row = $pager->fetchRow()) {
         $row['link'] = catalog_createItemLink($row['id'], SECTION);
         $row['category'] = getTreePath(SECTION . "_categories", $row['idcat']);
         $row['vote'] = round($row['vote'], 2);
         if (A::$OPTIONS['useimages']) {
             $row['images'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_images WHERE idsec=? AND iditem=? ORDER BY sort", array(SECTION_ID, $row['id']));
             $row['idimg'] = isset($row['images'][0]['id']) ? $row['images'][0]['id'] : 0;
         }
         if (A::$OPTIONS['usefiles']) {
             $row['files'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_files WHERE idsec=? AND iditem=? ORDER BY sort", array(SECTION_ID, $row['id']));
             foreach ($row['files'] as $i => $data) {
                 $row['files'][$i]['link'] = (LANG == DEFAULTLANG ? "" : "/" . LANG) . "/getfile/" . $data['id'] . "/" . $data['name'];
                 $row['files'][$i]['size'] = sizestring($data['size']);
             }
             $row['idfile'] = isset($row['files'][0]['id']) ? $row['files'][0]['id'] : 0;
         }
         if (A::$OPTIONS['usetags']) {
             $row['tags'] = A_SearchEngine::getInstance()->convertTags($row['tags']);
         }
         prepareValues(SECTION, $row);
         $row = A::$OBSERVER->Modifier('catalog_prepareValues', SECTION, $row);
         $items[] = $row;
     }
     $pager->free();
     $this->Assign("items", $items);
     $this->Assign("items_pager", $pager);
     $this->AddNavigation(SECTION_NAME, getSectionLink(SECTION));
     $this->AddNavCategories($this->category['idker']);
     $this->AddNavigation($this->category['name']);
     $this->title = $this->category['name'] . (!empty($this->title) ? " - " . $this->title : "");
     $this->description = $this->category['description'];
 }
Exemplo n.º 7
0
 /**
  * Обработчик действия: Отдает таблицу с элементами текущего уровня.
  */
 function getGrid()
 {
     $form = new A_Form("module_pages_grid.tpl");
     $curdir = (int) A_Session::get(SECTION . "_cid", 0);
     $rows = (int) A_Session::get(SECTION . "_rows", isset($_COOKIE[SECTION . '_rows']) ? $_COOKIE[SECTION . '_rows'] : 20);
     $form->data['seo'] = getStructureByPlugin('seo');
     $form->data['title'] = $this->getPath($curdir);
     $form->data['pages'] = array();
     $pager = new A_Pager($rows, "gopage");
     $pager->query("SELECT * FROM " . SECTION . " WHERE idker={$curdir} ORDER BY sort");
     if ($curdir > 0 && ($row = A::$DB->getRowById($curdir, SECTION))) {
         $grow[0] = "&nbsp;";
         $grow[1] = AddImageButton("/templates/admin/images/back.gif", "indir({$row['idker']})", "Уровень выше", 16, 16);
         $grow[2] = AddClickText("...", "indir({$row['idker']})");
         $grow[3] = $grow[5] = $grow[6] = $grow[7] = $grow[8] = "&nbsp;";
         $grow[4] = 0;
         $form->data['sub'] = true;
         $form->data['pages'][] = $grow;
     } else {
         $form->data['sub'] = false;
     }
     $crows = 0;
     while ($row = $pager->fetchRow()) {
         $grow[0] = "<input type=\"checkbox\" id=\"checkp{$crows}\" name=\"checkpages[]\" value=\"{$row['id']}\"/>";
         $grow['link'] = pages_createItemLink($row['id'], SECTION);
         if ($row['type'] == 'dir') {
             $grow[1] = AddImage("/templates/admin/images/dir.gif", 16, 16);
             $grow[2] = AddLink(truncate($row['name'], 100), "javascript:indir({$row['id']})", "Войти в подраздел");
             $grow[3] = "&nbsp;";
             $grow[4] = $row['date'];
             $grow[5] = AddImageButton("/templates/admin/images/edit.gif", "geteditdirform({$row['id']})", "Редактировать", 16, 16);
             $grow[6] = AddImageButtonLink("/templates/admin/images/browse.gif", $grow['link'], "Просмотр на сайте", 16, 16, ' target="_blank"');
         } else {
             $grow[1] = AddImage("/templates/admin/images/text.gif", 16, 16);
             $grow[2] = AddLink(truncate($row['name'], 100), "javascript:geteditpageform({$row['id']})", "Редактировать");
             $grow[3] = "<a href=\"javascript:edittpl('{$row['template']}')\" title=\"Редактировать шаблон\">{$row['template']}</a>";
             $grow[4] = $row['date'];
             $grow[5] = "&nbsp;";
             $grow[6] = AddImageButtonLink("/templates/admin/images/browse.gif", $grow['link'], "Просмотр на сайте", 16, 16, ' target="_blank"');
         }
         $grow[7] = AddImageButton("/templates/admin/images/move.gif", "getmoveform({$row['id']})", "Переместить", 16, 16);
         $grow[8] = AddImageButton("/templates/admin/images/del.gif", "delitem({$row['id']},'{$row['urlname']}')", "Удалить", 16, 16);
         $grow['id'] = $row['id'];
         $grow['active'] = $row['active'];
         $form->data['pages'][] = $grow;
         $crows++;
     }
     $pager->free();
     $form->data['pager'] = $pager;
     $this->RESULT['html'] = $form->getContent();
 }
Exemplo n.º 8
0
 /**
  * Формирование данных доступных в шаблоне.
  */
 function createData()
 {
     if (!A_Session::is_set(SECTION . "_filter")) {
         $this->unFilter();
     }
     $categories = A::$DB->getAll("SELECT id,idker,name FROM " . SECTION . "_categories ORDER BY level,sort");
     $this->Assign("categories", $categories);
     if (!empty($_GET['idcat'])) {
         $this->Assign("category", A::$DB->getRowById($_GET['idcat'], SECTION . "_categories"));
         $idcat = (int) $_GET['idcat'];
         $childcats = array($idcat);
         getTreeSubItems(SECTION . "_categories", $idcat, $childcats);
         $where = "c.idcat IN(" . implode(",", $childcats) . ")";
         $this->Assign("childcats", $childcats = count($childcats));
     } else {
         $where = "";
     }
     if ($filter = $this->getFilter()) {
         $where = !empty($where) ? "{$where} AND {$filter}" : $filter;
     }
     $rows = (int) A_Session::get(SECTION . "_rows", isset($_COOKIE[SECTION . '_rows']) ? $_COOKIE[SECTION . '_rows'] : 10);
     $sort = escape_order_string(A_Session::get(SECTION . "_sort", isset($_COOKIE[SECTION . '_sort']) ? $_COOKIE[SECTION . '_sort'] : A::$OPTIONS['sort']));
     $items = array();
     $pager = new A_Pager($rows);
     $pager->tab = "items";
     $pager->query("\r\r\n\tSELECT c.*,c.svote/c.cvote AS vote,cc.name AS category\r\r\n\tFROM " . SECTION . "_catalog AS c\r\r\n\tLEFT JOIN " . SECTION . "_categories AS cc ON cc.id=c.idcat\r\r\n\t" . (!empty($where) ? " WHERE {$where}" : "") . "\r\r\n\tORDER BY {$sort}");
     while ($row = $pager->fetchRow()) {
         $row['link'] = catalog_createItemLink($row['id'], SECTION);
         $row['vote'] = round($row['vote'], 2);
         if (A::$OPTIONS['useimages']) {
             $row['images'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_images WHERE idsec=? AND iditem=? ORDER BY sort", array(SECTION_ID, $row['id']));
             $row['idimg'] = isset($row['images'][0]['id']) ? $row['images'][0]['id'] : 0;
         }
         if (A::$OPTIONS['usefiles']) {
             $row['files'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_files WHERE idsec=? AND iditem=? ORDER BY sort", array(SECTION_ID, $row['id']));
             $row['idfile'] = isset($row['files'][0]['id']) ? $row['files'][0]['id'] : 0;
         }
         $row['tags'] = A_SearchEngine::getInstance()->convertTags($row['tags']);
         if (empty($_GET['idcat']) || $childcats > 1) {
             $row['catpath'] = getTreePath(SECTION . "_categories", $row['idcat']);
         }
         $items[] = $row;
     }
     $pager->free();
     $this->Assign("items", $items);
     $this->Assign("items_pager", $pager);
     $this->Assign("treebox", new A_CategoriesTree("items"));
     if (A::$OPTIONS['usecomments']) {
         $this->Assign("commbox", new A_CommentsEditor(SECTION . "_catalog"));
     }
     $this->Assign("optbox1", new A_OptionsBox("Внешний вид на сайте:", array('idgroup' => 1)));
     $this->Assign("optbox2", new A_OptionsBox("Файлы:", array('idgroup' => 2)));
     $this->Assign("optbox3", new A_OptionsBox("Комментирование и голосование:", array('idgroup' => 3)));
     $this->Assign("optbox4", new A_OptionsBox("Дополнительно:", array('idgroup' => 4)));
     $this->Assign("fieldsbox", new A_FieldsEditor(SECTION . "_catalog", array('tab' => 'opt', 'tab_opt' => 'fields'), false, true));
     $this->Assign("rows", $rows);
     $this->Assign("sort", $sort);
     $this->Assign("filter", !empty($filter));
 }
Exemplo n.º 9
0
 function createData()
 {
     $pages = array();
     $pager = new A_Pager(20);
     $pager->query("SELECT * FROM " . STRUCTURE . " ORDER BY url");
     while ($row = $pager->fetchRow()) {
         $pages[] = $row;
     }
     $pager->free();
     $this->Assign("pages", $pages);
     $this->Assign("pages_pager", $pager);
 }