public static function Report()
{
$sql = 'SELECT * FROM {{orders}} WHERE loyalty=1 AND sent=0';
$list = DB::getAll($sql);
foreach ($list as $order) {
$sql = '
SELECT * FROM {{orders_items}}
WHERE orders=' . $order['id'] . '
';
$items = DB::getAll($sql);
$data = $order;
foreach ($items as $item) {
$temp = Tree::getInfo($item['tree']);
if ($temp['path'] != 'catalogopt') {
$data['list'][] = Catalog::getOne($item['tree']);
}
}
$text = View::getRenderEmpty('email/report', $data);
$mail = new Email();
$mail->Text($text);
$mail->Subject('Оставьте отзыв о товаре на сайте www.' . str_replace('www.', '', $_SERVER["HTTP_HOST"]));
$mail->From('robot@' . str_replace('www.', '', $_SERVER["HTTP_HOST"]));
$mail->To($order['email']);
$mail->Send();
$sql = '
UPDATE {{orders}}
SET sent=1
WHERE id=' . $order['id'] . '
';
DB::exec($sql);
}
}
public static function getManagerBooks()
{
$data = array();
$sql = '
SELECT {{tree}}.id, \'tree\' AS what, {{tree}}.mdate AS udate FROM {{tree}}
INNER JOIN {{catalog}} ON {{tree}}.id={{catalog}}.tree
WHERE (({{catalog}}.rejected=\'\' AND {{tree}}.visible=0) OR ({{catalog}}.status=\'salereq\')) AND filecover<>\'\'
ORDER BY {{tree}}.mdate DESC
';
$list = DB::getPagi($sql);
foreach ($list as $item) {
$data[] = Catalog::getOne($item['id']);
}
return $data;
}
function getSales()
{
$data = array();
$sql = '
SELECT {{catalog}}.tree FROM {{catalog}}
INNER JOIN {{tree}} ON {{catalog}}.tree={{tree}}.id
WHERE visible=1 AND {{catalog}}.price<{{catalog}}.oldprice
ORDER BY RAND() LIMIT 0,2
';
$list = DB::getAll($sql, 'tree');
foreach ($list as $item) {
$data[] = Catalog::getOne($item);
}
return $data;
}
function books()
{
if (is_numeric(Funcs::$uri[2]) && !isset($_GET['preview'])) {
$data = Catalog::getOne(Funcs::$uri[2]);
$seo['seo_title'] = $data['name'];
Funcs::setMeta($seo);
$data['list'] = Catalog::getCabinetBooksList($data['vendor']);
View::render('cabinet/booksOne', $data);
} elseif (is_numeric(Funcs::$uri[2]) && isset($_GET['preview'])) {
$data = Catalog::getOne(Funcs::$uri[2]);
$seo['seo_title'] = $data['name'];
Funcs::setMeta($seo);
View::render('cabinet/booksPreview', $data);
} elseif (Funcs::$uri[2] == 'del' && is_numeric(Funcs::$uri[3])) {
$data = Catalog::delBook(Funcs::$uri[32]);
$this->redirect($_GET['redirect']);
} elseif (Funcs::$uri[2] == 'saleoff') {
Catalog::saleOff($_GET['id']);
$this->redirect($_GET['redirect']);
} elseif (Funcs::$uri[2] == 'private') {
Catalog::saleOff($_GET['id']);
$this->redirect($_GET['redirect']);
} else {
$seo['seo_title'] = 'Мои книги';
Funcs::setMeta($seo);
$data['list'] = Catalog::getCabinetBooksList($_SESSION['iuser']['id']);
View::render('cabinet/books', $data);
}
}
public function getConfirm($id)
{
$sql = 'SELECT * FROM {{orders}} WHERE id=' . $id . '';
$data = DB::getRow($sql);
$sql = 'SELECT * FROM {{orders_items}} WHERE orders=' . $id . '';
$data['goods'] = DB::getAll($sql);
$sum = 0;
$count = 0;
$sale = 0;
foreach ($data['goods'] as $key => $item) {
$goods = Catalog::getOne($item['tree']);
$sum += $item['price'] * $item['num'];
$sale += ($goods['price'] - $item['price']) * $item['num'];
$count++;
$goods['sale'] = $item['sale'];
$goods['realprice'] = $goods['price'];
$goods['total'] = $item['price'] * $item['num'];
$goods['num'] = $item['num'];
$goods['price'] = $item['price'];
$data['goods'][$key] = $goods;
}
$data['sum'] = $sum;
$data['count'] = $count;
$data['sale'] = $sale;
return $data;
}
public static function getHits()
{
$data = array();
$ids = Tree::getChilds(2);
$sql = '
SELECT DISTINCT {{tree}}.id FROM {{tree}}
INNER JOIN {{catalog}} ON {{catalog}}.tree={{tree}}.id
WHERE {{tree}}.visible=1 AND {{tree}}.parent IN (' . implode(',', $ids) . ') AND {{catalog}}.hit=1
ORDER BY {{tree}}.num DESC LIMIT 0,4
';
//print DB::prefix($sql);
$list = DB::getAll($sql);
foreach ($list as $item) {
$data[] = Catalog::getOne($item['id']);
}
return $data;
}
public static function getCompare()
{
if (count($_SESSION['compare']) > 0) {
$return = array();
$data = array();
$i = 0;
foreach ($_SESSION['compare'] as $id) {
if ($i < 3) {
$data[] = Catalog::getOne($id);
}
$i++;
}
$additional = array();
if (count($data) > 0) {
foreach ($data as $item) {
if (is_array($item['additional'])) {
foreach ($item['additional'] as $title => $values) {
if (is_array($values)) {
foreach ($values as $k => $v) {
$additional[$title][$k] = '';
}
}
}
}
//$additional
}
foreach ($data as $i => $item) {
foreach ($additional as $title => $values) {
foreach ($values as $k => $v) {
$data[$i]['additional'][$title][$k] = $item['additional'][$title][$k];
}
}
}
$additional = array();
if (is_array($data[0]['additional'])) {
foreach ($data[0]['additional'] as $title => $values) {
if (is_array($values)) {
foreach ($values as $k => $v) {
$tn = '';
foreach ($data as $key => $item) {
if ($tn != $item['additional'][$title][$k] && $item['additional'][$title][$k] != '' && $tn != '') {
$additional[$title][$k] = 1;
$n = 1;
}
$tn = $item['additional'][$title][$k];
}
}
} else {
$tn = '';
foreach ($data as $key => $item) {
if ($tn != $item['additional'][$title] && $item['additional'][$title] != '' && $tn != '') {
$additional[$title] = 1;
$n = 1;
}
$tn = $item['additional'][$title];
}
}
}
}
}
return array('items' => $data, 'additional' => $additional);
} else {
return array();
}
}
public static function getFavorite()
{
if (isset($_COOKIE['favorite'])) {
$favorite = explode(',', $_COOKIE['favorite']);
}
if (count($favorite) > 0) {
$tab = strtolower(__CLASS__);
$return = array();
$sql = '
SELECT DISTINCT {{tree}}.id FROM {{' . $tab . '}}
INNER JOIN {{tree}} ON {{' . $tab . '}}.tree={{tree}}.id
WHERE {{tree}}.id IN (' . implode(',', $favorite) . ')
';
$catalog = DB::getAll($sql, 'id');
foreach ($catalog as $item) {
$return[] = Catalog::getOne($item);
}
return $return;
} else {
return array();
}
}
function askprice()
{
if ($_SESSION['iuser']) {
View::$layout = 'popup';
View::render('popup/askprice', Catalog::getOne($_GET['id']));
}
}
public function getOrderGoods($order)
{
$data = array();
$sql = '
SELECT {{dealers_orders_items}}.*, {{tree}}.name FROM {{dealers_orders_items}}
INNER JOIN {{tree}} ON {{dealers_orders_items}}.tree={{tree}}.id
WHERE {{dealers_orders_items}}.`order`=' . $order . '
';
$list = DB::getAll($sql);
foreach ($list as $item) {
$sql = 'SELECT parent FROM {{tree}} WHERE id=' . $item['tree'] . '';
$id = DB::getOne($sql);
$item['fields'] = Fields::getFieldsByTree($item['tree']);
$data[] = array('goods' => Catalog::getOne($id), 'size' => $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);
}
}
}
}
}
