public static function calcSale($orderId)
{
$order = DealersOrders::getOrderProp($orderId);
$sql = '
SELECT {{dealers}},*, {{dealers_status}}.sale as statussale FROM {{dealers}}
LEFT JOIN ((dealers_status)) ON {{dealers}}.status = {{dealers_status}}.id
WHERE {{dealers}}.id=' . $order['dealer'] . '
';
$dealer = DB::getRow($dealerId);
$sale_status = $dealer['statussale'];
$sale_one = self::calc($order['sum'], 'sale_one');
$sale_year = self::calc($order['sum'], 'sale_year');
$sale_total = $sale_status + max($sale_year, $sale) + $order['add_sale'];
return $sale_total;
}
function getUndefinedDealers()
{
$data = array();
// INNER JOIN {{dealers_status}} ON {{dealers}}.status = {{dealers_status}}.id
$sql = '
SELECT {{dealers}}.* , {{dealers_status}}.shortname as statusname, {{dealers}}.id as dealer_id, (
SELECT COUNT(*)
FROM {{dealers_orders}}
LEFT JOIN {{dealers_orders_status}} ON {{dealers_orders}}.status = {{dealers_orders_status}}.id
WHERE {{dealers_orders}}.`dealer` = dealer_id AND {{dealers_orders_status}}.path = \'new\'
) as new_orders
FROM {{dealers}}
LEFT JOIN {{dealers_status}} ON {{dealers}}.status = {{dealers_status}}.id
WHERE {{dealers}}.active=1
ORDER BY new_orders DESC
';
//getPagi не cпособен переварить запрос с подзапросами
//вместо
//$list=DB::getPagi($sql);
//приходится делать так
$dealers_count = DB::getOne('SELECT COUNT(*) FROM {{dealers}}');
if (Funcs::$OneSSA) {
$perpage = $_SESSION['user']['perpage'];
} else {
if ($_SESSION['perpage'][end(Funcs::$uri)]) {
$perpage = $_SESSION['perpage'][end(Funcs::$uri)];
} else {
$perpage = 10;
}
}
$page = intval($_GET['p']) > 0 ? $_GET['p'] : '1';
if (class_exists(PaginationWidget)) {
PaginationWidget::$count = $dealers_count;
}
$sql .= ' LIMIT ' . ($page - 1) * $perpage . ',' . $perpage;
$list = DB::getAll($sql);
foreach ($list as $item) {
$item['stores_cnt'] = DealersStores::getCount($item['id']);
$item['consignee_cnt'] = DealersConsignee::getCount($item['id']);
$item['balance'] = self::getBalance($item['id']);
$item['files'] = DealersFiles::getCountFiles($item['id']);
$item['orders'] = DealersOrders::getOrdersCountByStatus($item['id'], 'new') . '/' . DealersOrders::getOrdersCountByStatus($item['id']);
$data[] = $item;
}
return $data;
}
function getUndefinedDealers()
{
$data = array();
//$sql='SELECT * FROM {{dealers}} ORDER BY cdate';
$sql = '
SELECT {{dealers}}.* ,{{dealers_status}}.shortname as statusname FROM {{dealers}}
INNER JOIN {{dealers_status}} ON {{dealers}}.status = {{dealers_status}}.id
ORDER by cdate
';
$list = DB::getPagi($sql);
foreach ($list as $item) {
$item['stores_cnt'] = DealersStores::getCount($item['id']);
$item['consignee_cnt'] = DealersConsignee::getCount($item['id']);
$item['balance'] = self::getBalance($item['id']);
$item['files'] = DealersFiles::getCountFiles($item['id']);
$item['orders'] = DealersOrders::getOrdersCountByStatus($item['id']);
$data[] = $item;
}
return $data;
}
public static function order_status($order)
{
$order = DealersOrders::getOne($order);
$dealer = DealersMain::getOne($order['dealer']);
self::send($dealer['emailreport'], 'Изменение статуса заказа на сайте www.' . self::site(), View::getPluginEmpty('email/order_status', array('dealer' => $dealer, 'order' => $order)));
}
public function allorders()
{
$search = array();
if ($_GET['from'] && $_GET['to']) {
$search['from'] = $_GET['from'];
$search['to'] = $_GET['to'];
}
if ($_GET['city']) {
$search['city'] = $_GET['city'];
}
$list = DealersOrders::getOrdersList(null, isset($_GET['status']) ? $_GET['status'] : 'new', $search);
View::plugin('orders/allorders', $list);
}
} else {
?>
<a href="/<?php
echo Funcs::$cdir;
?>
/dealers/allorders/?status=<?php
echo $item['path'];
echo $dealer;
?>
" class="button-whitegreen">
<strong><?php
echo $item['name'];
?>
</strong>
<?php
echo DealersOrders::getOrdersCountByStatus(null, $item['path']);
?>
</a>
<?php
}
?>
<?php
}
?>
</div>
</div>
<div class="ltRow">
<div class="cell_page-content_control-panel">
<div class="clearfix">
<div class="control-panel_inline">
<header class="control-panel_inline_header">Выборка:</header>
private static function getCatalogLayer($parent, $depth = 0, $pre = false)
{
$sql = '
SELECT {{tree}}.id as tree_id, {{tree}}.*, {{catalog}}.* FROM {{tree}}
LEFT JOIN {{catalog}} ON {{tree}}.id = {{catalog}}.tree
WHERE {{tree}}.visible=1 AND parent = ' . $parent . '
ORDER BY num
';
$elements = DB::getAll($sql);
$depth++;
foreach ($elements as $key => $item) {
$sql = '
SELECT {{tree}}.id as tree_id, {{tree}}.*, {{catalog}}.* FROM {{tree}}
LEFT JOIN {{catalog}} ON {{tree}}.id = {{catalog}}.tree
WHERE {{tree}}.visible = 1 AND parent = ' . $item['tree_id'] . '
ORDER BY num
';
$temp = DB::getAll($sql);
$f = self::getFieldsByTree($item['tree_id']);
//print Run::$colors[$f['color']]['pic'];
if (Funcs::$uri[0] != ONESSA_DIR) {
if ($f['color']) {
self::$currentColor = $f['color'];
}
$f['wcolor'] = Run::$colors[self::$currentColor];
}
//print $elements[$key]['name'].' ('.$item['tree_id'].') |'.$f['numberWarehouse'].'|<br><br>';
if ($pre) {
if (isset($f['value']) || $item['preorder'] == 1 || !isset($f['value']) && !isset($item['preorder'])) {
$elements[$key]['fields'] = $f;
if (!is_null($item['tree'])) {
$elements[$key]['model'] = true;
$fields = true;
//$elements[$key]['fields']=self::getFieldsByTree($item['tree_id']);
} else {
$fields = false;
}
if (count($temp) > 0) {
$elements[$key]['sub'] = self::getCatalogLayer($item['tree_id'], $depth, $pre);
}
$elements[$key]['depth'] = $depth;
} else {
unset($elements[$key]);
}
if (count($elements[$key]['sub']) == 0 && !$elements[$key]['fields']['value']) {
unset($elements[$key]);
}
} else {
if (isset($f['value']) && $f['numberWarehouse'] > 0 || !isset($f['value'])) {
$elements[$key]['fields'] = $f;
if (!is_null($item['tree'])) {
$elements[$key]['model'] = true;
$fields = true;
//$elements[$key]['fields']=self::getFieldsByTree($item['tree_id']);
} else {
$fields = false;
}
if (count($temp) > 0) {
$elements[$key]['sub'] = self::getCatalogLayer($item['tree_id'], $depth);
}
$elements[$key]['depth'] = $depth;
} else {
unset($elements[$key]);
}
if (count($elements[$key]['sub']) == 0 && !$elements[$key]['fields']['value']) {
unset($elements[$key]);
}
}
}
return $elements;
}
} else {
?>
<a href="/<?php
echo Funcs::$cdir;
?>
/dealers/orders/?status=<?php
echo $item['path'];
echo $dealer;
?>
" class="button-whitegreen">
<strong><?php
echo $item['name'];
?>
</strong>
<?php
echo DealersOrders::getOrdersCountByStatus($dealerId, $item['path']);
?>
</a>
<?php
}
?>
<?php
}
?>
</div>
</div>
<div class="ltRow">
<div class="cell_page-content_control-panel">
<div class="clearfix">
<div class="control-panel_inline">
