/** * Функция загрузки списка из данных каталога. * * @param string $item Полный строковой идентификатор раздела. */ function catalog_loadlist($item) { $rows = A::$DB->getAll("SELECT * FROM {$item}_catalog LIMIT 0,500"); $rows = array_multisort_key($rows, 'name'); $list = array(); foreach ($rows as $row) { prepareValues($item, $row); $list[$row['id']] = $row; } return $list; }
$item = array('title' => $row['name'], 'link' => "http://" . DOMAINNAME . catalog_createItemLink($row['id'], $section), 'pubDate' => date("r", $row['date']), 'description' => strip_tags($row['description'])); if (!empty($row['category'])) { $item['category'] = $row['category']; } $data['channel'][] = $item; } A::$DB->free(); } else { $items = array(); $sections = getSectionsByModule('catalog'); foreach ($sections as $section) { A::$DB->queryLimit("\r\r\n SELECT a.*,c.name AS category\r\r\n FROM {$section}_catalog AS a\r\r\n LEFT JOIN {$section}_categories AS c ON c.id=a.idcat\r\r\n WHERE a.active='Y'\r\r\n ORDER BY date DESC", 0, $rssrow['rows']); while ($row = A::$DB->fetchRow()) { $row['link'] = catalog_createItemLink($row['id'], $section); $items[] = $row; } A::$DB->free(); } $items = array_multisort_key($items, 'date', SORT_DESC); $items = array_slice($items, 0, $rssrow['rows']); foreach ($items as $row) { $item = array('title' => $row['name'], 'link' => "http://" . DOMAINNAME . $row['link'], 'pubDate' => date("r", $row['date']), 'description' => strip_tags($row['description'])); if (!empty($row['category'])) { $item['category'] = $row['category']; } $data['channel'][] = $item; } } $serializer->serialize($data); header("Content-type: text/xml; charset=utf-8"); die($serializer->getSerializedData());
/** * Обработчик действия: Отдает форму пермещения элементов. */ function getMovePagesForm() { if (empty($_POST['pages'])) { return; } $form = new A_Form("module_pages_cmove.tpl"); $form->data['pages'] = array_values($_POST['pages']); $form->data['idker'] = A::$DB->getOne("SELECT idker FROM " . SECTION . " WHERE id=" . (int) current($form->data['pages'])); $form->data['dirs'] = array(); $cid = (int) A_Session::get(SECTION . "_cid", 0); $this->getDirs($form->data['dirs'], 0, $cid); $form->data['dirs'] = array_multisort_key($form->data['dirs'], "level_sort"); if ($cid > 0 && count($form->data['dirs']) == 0) { $row = A::$DB->getRow("SELECT id,idker,name,level,sort FROM " . SECTION . " WHERE id={$cid}"); $row['level_sort'] = sprintf("%03d_%03d", $row['level'], $row['sort']); $form->data['dirs'][] = $row; } if (count($form->data['dirs']) > 0) { $this->RESULT['html'] = $form->getContent(); } else { $this->RESULT['html'] = AddLabel("Нет вариантов перемещения."); } }
/** * Формирование данных доступных в шаблоне. */ function createData() { $this->supportCached(); $this->addCacheParam_Get('page'); if ($this->month == 0) { $this->month = date('m'); } if ($this->year == 0) { $this->year = date('Y'); } $checkeds = !empty(A::$OPTIONS['sections']) ? unserialize(A::$OPTIONS['sections']) : array(); $srows = $sections = array(); foreach ($checkeds as $idsec) { if ($srow = A::$DB->getRowById($idsec, DOMAIN . "_sections")) { $section = DOMAIN . "_" . $srow['lang'] . "_" . $srow['name']; $sections[$section] = $srow['module']; $srows[$section] = $srow; } } $calendar = new A_Calendar($sections); $this->Assign("calendar", $calendar->getMonthHTML($this->day, $this->month, $this->year)); if ($this->day > 0) { $date1 = mktime(0, 0, 0, $this->month, $this->day, $this->year); $date2 = mktime(23, 59, 59, $this->month, $this->day, $this->year); $this->Assign("date", $date1); } else { $date1 = mktime(0, 0, 0, $this->month, 1, $this->year); $date2 = mktime(0, 0, 0, $this->month + 1 > 12 ? 1 : $this->month + 1, 1, $this->month + 1 > 12 ? $this->year + 1 : $this->year) - 1; $this->Assign("date1", $date1); $this->Assign("date2", $date2); } $items = array(); foreach ($sections as $section => $module) { $srows[$section]['caption'] = $srows[$section]['caption_' . LANG]; $srows[$section]['link'] = getSectionLink($section); A::$DB->query("SELECT *,svote/cvote AS vote FROM {$section}_catalog WHERE date>={$date1} AND date<={$date2} AND active='Y' ORDER BY date"); while ($row = A::$DB->fetchRow()) { $row['section'] = $section; $items[] = $row; } A::$DB->free(); } $items = array_multisort_key($items, 'date'); $pager = new A_Pager(A::$OPTIONS['rows']); $items = $pager->setItems($items); foreach ($items as $i => $row) { $section = $row['section']; $row['section'] = $srows[$section]; $row['section_name'] = $srows[$section]['caption']; $row['section_link'] = $srows[$section]['link']; $row['link'] = catalog_createItemLink($row['id'], $section); $row['vote'] = round($row['vote'], 2); $row['category'] = getTreePath("{$section}_categories", $row['idcat']); $row['images'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_images WHERE idsec=? AND iditem=? ORDER BY sort", array($srows[$section]['id'], $row['id'])); $row['idimg'] = isset($row['images'][0]['id']) ? $row['images'][0]['id'] : 0; $row['files'] = A::$DB->getAll("SELECT * FROM " . DOMAIN . "_files WHERE idsec=? AND iditem=? ORDER BY sort", array($srows[$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 (!empty($row['tags'])) { $row['tags'] = A_SearchEngine::getInstance()->convertTags($row['tags']); } prepareValues($section, $row); $items[$i] = $row; } $this->Assign("items", $items); $this->Assign("items_pager", $pager); $this->AddNavigation(SECTION_NAME); }
function SortName() { if (isset($_REQUEST['checkdata'])) { $values = array(); $sort = array(); foreach ($_REQUEST['checkdata'] as $id) { $row = A::$DB->getRowById($id, STRUCTURE); $sort[] = $row['sort']; $values[] = $row; } $values = array_multisort_key($values, 'name_' . LANG); foreach ($values as $i => $row) { A::$DB->execute("UPDATE " . STRUCTURE . " SET sort=" . $sort[$i] . " WHERE id=" . $row['id']); } } return true; }