public function getList($parent)
{
$data = array();
if ($limit != '') {
$limit = 'LIMIT ' . $limit;
}
$sql = 'SELECT * FROM {{tree}} WHERE parent=' . $parent . ' AND visible=1 ORDER BY name ';
$list = DB::getPagi($sql);
$i = 0;
foreach ($list as $item) {
$field = Fields::getFieldsByTree($item['id'], 'gal');
$path = Tree::getPathToTree($item['id']);
$data['list'][] = array('id' => $item['id'], 'name' => $item['name'], 'path' => $path, 'udate' => date('d.m.Y', strtotime($item['udate'])), 'fields' => $field, 'pic' => $field['files_gal1']['image'][0]['path']);
if (preg_match("/^[0-9]+\$/", substr($item['name'], 0, 1))) {
$data['list2']['0-9'][] = array('id' => $item['id'], 'name' => $item['name'], 'path' => $path);
}
if (preg_match("/^[a-zA-Z]+\$/", substr($item['name'], 0, 1))) {
$data['list2'][strtoupper(substr($item['name'], 0, 1))][] = array('id' => $item['id'], 'name' => $item['name'], 'path' => $path);
}
if (preg_match("/^[а-яА-Я]+\$/", substr($item['name'], 0, 1))) {
$data['list2']['А-Я'][] = array('id' => $item['id'], 'name' => $item['name'], 'path' => $path);
}
}
return $data;
}
function atb()
{
$model = Catalog::getOne($_GET['id']);
$model['parentpath'] = Tree::getPathToTree($model['parent']);
$temp = Basket::getSimpleOrder();
$model['sum'] = $temp['sum'];
$model['goods'] = $temp['goods'];
View::$layout = 'popup';
View::render('popup/addtobasket', $model);
}
public function getList($parent, $order = 'num', $limit = '')
{
$data = array();
if ($limit != '') {
$limit = 'LIMIT ' . $limit;
}
$sql = 'SELECT * FROM {{tree}} WHERE parent=' . $parent . ' ORDER BY ' . $order . ' ' . $limit;
$list = DB::getPagi($sql);
foreach ($list as $item) {
$field = Fields::getFieldsByTree($item['id'], 'gal');
$data[] = array('id' => $item['id'], 'name' => $item['name'], 'path' => Tree::getPathToTree($item['id']), 'udate' => date('d.m.Y', strtotime($item['udate'])), 'fields' => $field, 'pic' => $field['files_gal1']['image'][0]['path']);
}
return $data;
}
function run($id = '')
{
$fullURI = Funcs::$uri;
if ($id) {
$fullURI = explode('/', Tree::getPathToTree($id));
unset($fullURI[0]);
unset($fullURI[count($fullURI)]);
}
$data = array();
$parent = Funcs::$siteDB;
$path = '';
foreach ($fullURI as $uri) {
$path = $path . '/' . $uri;
if (is_numeric($uri)) {
$sql = 'SELECT * FROM {{tree}} WHERE parent=' . $parent . ' AND id=' . $uri . '';
} else {
$sql = 'SELECT * FROM {{tree}} WHERE parent=' . $parent . ' AND path=\'' . $uri . '\'';
}
$row = DB::getRow($sql);
$row['path'] = $path . '/';
$parent = $row['id'];
if ($parent == '') {
$parent = 0;
}
$data[] = $row;
}
if ($fullURI[0] == 'catalog' && is_numeric($fullURI[count(Funcs::$uri) - 1])) {
$uri = explode('/', $_SERVER['REQUEST_URI']);
$num = count($data);
$data[count($data)] = $data[count($data) - 1];
$path = $data;
unset($path[count($path) - 1]);
unset($path[count($path) - 1]);
$items = array();
foreach ($path as $item) {
$items[] = $item['path'];
}
Funcs::$reference['vendor'][$uri[$num]]['path'] = $items[count($items) - 1] . Funcs::$reference['vendor'][$uri[$num]]['path'] . '/';
$data[count($data) - 2] = Funcs::$reference['vendor'][$uri[$num]];
} elseif (isset($_GET['ve'])) {
$path = $items[count($items)] . Funcs::$reference['vendor'][$uri[$num]]['path'] . '/';
$data[] = array('name' => Funcs::$referenceId['vendor'][$_GET['ve']]['name'], 'path' => $path);
}
View::widget('crumbs', array('list' => $data));
}
function getList()
{
$data = array();
$xml = Sitemap::getSitemapXML();
//$site=Control::getSite(Funcs::$siteDB);
$sql = 'SELECT * FROM {{tree}} WHERE visible=1 ORDER BY mdate DESC, cdate DESC';
$list = DB::getAll($sql);
foreach ($list as $item) {
$info = Tree::getInfo($item['id']);
if ($info['id2'] != 0 && $info['params'] != '') {
$path = 'http://' . $_SERVER['HTTP_HOST'] . Tree::getPathToTree($item['id'], $info['params']);
} else {
$path = 'http://' . $_SERVER['HTTP_HOST'] . Tree::getPathToTree($item['id']);
}
$data[] = array('id' => $item['id'], 'name' => $item['name'], 'path' => $path, 'mdate' => date('Y-m-d', strtotime($item['mdate'])), 'changefreq' => $xml[str_replace('/', '_', $path)]['changefreq'], 'priority' => $xml[str_replace('/', '_', $path)]['priority'], 'checked' => is_array($xml[str_replace('/', '_', $path)]) ? 'checked' : '');
}
return $data;
}
public function getResult()
{
$data = array();
$q = trim(strip_tags($_GET['q']));
if ($q) {
$sql = '
SELECT * FROM {{search}}
INNER JOIN {{tree}} ON {{search}}.tree={{tree}}.id
WHERE search LIKE \'%' . $q . '%\' AND visible=1
ORDER BY {{search}}.cdate DESC
';
$list = DB::getAll($sql);
foreach ($list as $item) {
$fields = Fields::getFieldsByTree($item['tree'], 'gal');
$path = Tree::getPathToTree($item['tree']);
$data[] = array('id' => $item['tree'], 'name' => $item['name'], 'path' => $path, 'fields' => $fields, 'info' => Tree::getInfo($item['tree']));
}
}
return $data;
}
public function getList($parent, $order = 'num', $limit = '')
{
$data = array();
if ($limit != '') {
$limit = 'LIMIT ' . $limit;
}
$act = '';
if (isset($_GET['act'])) {
$act = ' AND value_int=' . $_GET['act'] . '';
}
$sql = '
SELECT DISTINCT {{tree}}.* FROM {{tree}}
INNER JOIN {{data}} ON {{data}}.tree={{tree}}.id
WHERE parent=' . $parent . ' AND {{data}}.path=\'act\' ' . $act . '
ORDER BY ' . $order . ' ' . $limit . '
';
$list = DB::getPagi($sql);
foreach ($list as $item) {
$field = Fields::getFieldsByTree($item['id'], 'gal');
$data[] = array('id' => $item['id'], 'name' => $item['name'], 'path' => Tree::getPathToTree($item['id']), 'udate' => date('d.m.Y', strtotime($item['udate'])), 'fields' => $field, 'pic' => $field['files_gal1'][0]['path']);
}
return $data;
}
public function OffersMenu()
{
$data = array();
$sql = 'SELECT id FROM {{tree}} WHERE parent=1 AND path=\'offers\' AND visible=1 ORDER BY num';
$parent = DB::getOne($sql);
$sql = 'SELECT * FROM {{tree}} WHERE parent=' . $parent . ' AND visible=1 AND menu=1 ORDER BY num';
$list = DB::getAll($sql);
foreach ($list as $i => $item) {
$data[$i % 4][] = array('name' => $item['name'], 'path' => Tree::getPathToTree($item['id']), 'id' => $item['id']);
}
View::widget('menu/offers', array('list' => $data));
}
public static function getPrev()
{
$tree = Tree::getTreeByUrl();
$parent = ' parent=' . $tree['parent'] . ' AND ';
if ($_GET['ids']) {
$parent = ' id IN (' . $_GET['ids'] . ') AND ';
}
$sql = 'SELECT count(*) FROM {{tree}} WHERE ' . $parent . ' visible=1 AND id<>' . $tree['id'] . '';
if (DB::getOne($sql) > 0) {
$sql = '
SELECT id FROM {{tree}}
WHERE ' . $parent . ' visible=1 AND id<>' . $tree['id'] . ' AND num<=\'' . $tree['num'] . '\'
ORDER BY num
';
$id = DB::getOne($sql);
if ($id) {
return Tree::getPathToTree($id) . ($_GET['ids'] != '' ? '?ids=' . $_GET['ids'] : '');
} else {
return Video::getNext();
}
}
}
public static function getServices($parent)
{
$data = array();
$sql = '
SELECT * FROM {{tree}}
WHERE visible=1 AND parent=' . $parent . ' AND menu=1
ORDER BY num
';
$list = DB::getAll($sql);
foreach ($list as $item) {
$item['path'] = Tree::getPathToTree($item['id']);
$fields = Fields::getFieldsByTree($item['id'], 'gal');
$data[] = array('id' => $item['id'], 'name' => $item['name'], 'path' => $item['path'], 'preview' => $fields['preview'], 'pic' => $fields['files_gal1']['image'][0]['path'], 'picname' => $fields['files_gal1']['image'][0]['name']);
}
return $data;
}
public function getRecurs($parent)
{
$data = array('sub' => array(), 'count' => 0);
$sql = '
SELECT * FROM {{tree}}
WHERE parent=' . $parent . ' AND visible=1 AND menu=0
ORDER BY num
';
$list = DB::getAll($sql);
foreach ($list as $item) {
$items = Faq::getRecurs($item['id']);
$path = Tree::getPathToTree($item['id']);
$data['sub'][] = array('name' => $item['name'], 'path' => $path, 'sub' => $items['sub'], 'count' => $countAll);
}
$data['count'] = $countAll;
return $data;
}
public static function getPrev($id, $parent, $date)
{
$sql = '
SELECT id FROM {{tree}}
WHERE parent=' . $parent . ' AND visible=1 AND id<>' . $id . ' AND udate<=\'' . date('Y-m-d', strtotime($date)) . '\'
ORDER BY udate DESC
';
$news = DB::getOne($sql);
if ($news) {
return Tree::getPathToTree($news);
}
}
public static function getType($id, $parent)
{
if (!Funcs::$uri[3]) {
$parent = $id;
}
$sql = '
SELECT {{tree}}.* FROM {{tree}}
LEFT JOIN {{catalog}} ON {{tree}}.id={{catalog}}.tree
WHERE {{tree}}.parent=' . $parent . ' AND {{catalog}}.tree IS NULL ORDER BY {{tree}}.num
';
$list = DB::getAll($sql);
foreach ($list as $item) {
$item['path'] = Tree::getPathToTree($item['id']);
$data['list'][] = $item;
}
return $data;
}
function __construct()
{
if ($_POST) {
DB::escapePost();
if (isset($_POST['report'])) {
$tree = Tree::getTreeByUrl();
$href = Catalog::getPathToTree($tree['id']);
Catalog::setReport($tree['id']);
View::$layout = 'empty';
View::render('site/redirect', array('href' => $href, 'text' => 'Отзыв успешно добавлен!'));
die;
}
if (isset($_POST['subscribe'])) {
$tree = Tree::getTreeByUrl();
$href = Tree::getPathToTree($tree['id']);
Catalog::setSubscribe($tree['id']);
die;
}
} else {
DB::escapeGet();
if (Funcs::$uri[1] == '' && isset($_GET['hits']) && Funcs::$uri[1] != 'setratingstars' && Funcs::$uri[1] != 'delreport') {
$tree = Tree::getTreeByUrl();
Funcs::setMeta($tree);
$tree = Catalog::getHitCatalog($tree['id']);
View::render('catalog/catalog', array('list' => $tree, 'name' => 'Все хиты'));
} elseif (Funcs::$uri[1] == '' && Funcs::$uri[1] != 'setratingstars' && Funcs::$uri[1] != 'delreport') {
$tree = Tree::getTreeByUrl();
Funcs::setMeta($tree);
$tree = Catalog::getPreviewCatalog($tree['id']);
//View::render('catalog/catalog',array('list'=>$tree));
} elseif (Funcs::$uri[1] != 'setratingstars' && Funcs::$uri[1] != 'delreport') {
$tree = Tree::getTreeByUrl(Funcs::$uri[0]);
if ($tree['info']['type'] == 'struct') {
$temp = Catalog::getInnerListPagi($tree['id']);
$tree['list'] = $temp['list'];
$tree['vendors'] = Catalog::getVendors($tree['id'], $tree['list']);
//$tree['options']['available']=array();
//$tree['options']['catalog']=Catalog::getType($tree['id'],$tree['parent']);
//$tree['options']['vendors']=Catalog::getVendors($tree['id']);
if ($_GET['ve']) {
$tree['name'] = $tree['seo_description'] = $tree['name'] . ' ' . Funcs::$referenceId['vendor'][$_GET['ve']]['name'];
Funcs::setMeta($tree);
}
$tree['options']['price'] = Catalog::getValuesPrice($tree['id']);
$tree['options']['price2'] = Catalog::getLink('pricelink');
//$tree['options']['rating']=array();
Funcs::setMeta($tree);
$tree['quantity'] = $temp['quantity'];
if ($_GET['ajax'] == 'act') {
print $tree['quantity'];
die;
} else {
View::render('catalog/list', $tree);
}
} else {
Funcs::setMeta($tree, 'goods');
$id = $tree['id'];
$tree = Catalog::getOne($id);
Catalog::setPopularity($id);
$tree['reports'] = Catalog::getReports($id);
Catalog::setViewed($id);
$tree['same_price'] = Catalog::getAdditionalgood($id, 'better_for_same_price');
$tree['accessories'] = Catalog::getAdditionalgood($id, 'accessories');
//$tree['similargoods']=Catalog::getAdditionalgood($id,'similargoods');
$tree['similargoods'] = Catalog::getMore($tree['id'], $tree['parent']);
$tree['reportme'] = Catalog::getReport($tree['id']);
if (isset($_GET['print'])) {
View::$layout = 'empty';
View::render('catalog/print', $tree);
die;
} else {
View::render('catalog/one', $tree);
}
}
}
}
}