public static function sendAllOrder($id)
{
$data = Orders::getOrderById($id);
View::$layout = 'empty';
$text = View::getRenderFullEmpty('email/order', $data);
$mail = new Email();
$mail->mailTo($data['email']);
$mail->Subject('Статус заказа №' . (str_repeat('0', 6 - strlen($id)) . $id) . ' на сайте ' . $_SERVER['HTTP_HOST'] . ' изменен');
$mail->From('robot@' . str_replace('www.', '', $_SERVER["HTTP_HOST"]));
$mail->Text($text);
$mail->Send();
}
public function getOrdersListByStatus($status = '', $all = '')
{
$list = array();
$status = '';
$sqlWhere = '';
if ($_GET['status'] != 'all') {
if ($_GET['status'] == '') {
$_GET['status'] = 'new';
}
$status = 'AND status=\'' . $_GET['status'] . '\'';
}
if ($_GET['from'] && $_GET['to']) {
$sqlWhere .= 'AND (wdate BETWEEN \'' . date('Y-m-d H:i:s', strtotime($_GET['from'])) . '\' AND \'' . date('Y-m-d H:i:s', strtotime($_GET['to'])) . '\')';
} elseif ($_GET['from'] && $_GET['to'] == '') {
$sqlWhere .= 'AND wdate>\'' . date('Y-m-d H:i:s', strtotime($_GET['from'])) . '\'';
} elseif ($_GET['from'] == '' && $_GET['to']) {
$sqlWhere .= 'AND wdate<\'' . date('Y-m-d H:i:s', strtotime($_GET['to'])) . '\'';
}
if (is_numeric($_GET['number'])) {
$sqlWhere .= 'AND id=\'' . $_GET['number'] . '\'';
}
if ($_GET['phone']) {
$sqlWhere .= 'AND phone LIKE \'%' . $_GET['phone'] . '%\'';
}
if ($_GET['fio']) {
$sqlWhere .= 'AND name LIKE \'%' . $_GET['fio'] . '%\'';
}
$sql = 'SELECT * FROM {{orders}} WHERE 1=1 ' . $status . ' ' . $sqlWhere . ' ORDER BY wdate DESC';
if ($all == '') {
$data = DB::getPagi($sql);
} else {
$data = DB::getAll($sql);
}
$itog = 0;
foreach ($data as $item) {
$temp = Orders::getOrderById($item['id']);
$temp['reports'][0] = 0;
$temp['reports'][1] = 0;
foreach ($temp['goods'] as $goods) {
$sql = 'SELECT tree FROM {{reports}} WHERE tree=' . $goods['tree'] . ' AND email=\'' . $item['email'] . '\'';
if (DB::getOne($sql)) {
$temp['reports'][0]++;
}
$temp['reports'][1]++;
}
$sql = 'SELECT * FROM {{orders_opinion}} WHERE orders=' . $item['id'] . '';
$temp['opinion'] = DB::getRow($sql);
$list[] = $temp;
$itog += $item['price'];
}
return array('list' => $list, 'itog' => $itog);
}
public static function getPayment()
{
$model = new Orders();
$data = $model->getOrderById(Funcs::$uri[3]);
print View::getPluginEmpty('payment', $data);
}
<?php
$orderData = Orders::getOrderById($id);
$maxPrice = -1;
$maxPriceArr = array();
for ($ii = 0; $ii < count($orderData["items"]); $ii++) {
if ($maxPrice < $orderData["items"][$ii]["price"]) {
$maxPrice = $orderData["items"][$ii]["price"];
$maxPriceArr = $orderData["items"][$ii];
}
}
/*
<tr>
<td style="background: #fff;padding: 25px;">
<table cellpadding="0" cellspacing="0" >
<tr>
<td>
<p style="font-size: 13pt; font-family: Arial, sans-serif;">
Здравствуйте, <?=$row["name"];?>!<br />
Некоторое время назад Вы оформляли у нас заказ на <b><?=$maxPriceArr["name"]?></b>. Большое спасибо за Ваш заказ!
Будем благодарны, если Вы напишите о Ваших впечатлениях о покупке у нас на странице нашего магазина.
С уважением, команда DVR-Group.ru<br/>
<br />
</p>
<table style="display: table; width: 100%; height: 43px; text-align: center;">
<tr>
<td> </td>
<td style="background: #0d4e91; background: -moz-linear-gradient(top, #0d9eec, #073d84);background: -webkit-linear-gradient(top, #0d9eec, #073d84);background: -o-linear-gradient(top, #0d9eec, #073d84); background: -ms-linear-gradient(top, #0d9eec, #073d84); background: linear-gradient(top, #0d9eec, #073d84);width: 130px;height: 43px;border-radius: 4px;text-decoration: none;vertical-align: middle;text-align: center;">
<a style="text-decoration: none; color: #FFFFFF; font-family: Tahoma, sans-serif; font-size: 12px; font-weight: bold;" href="<?=$row["yaopinions"];?>">Оставить отзыв</a>
</td>
<td> </td>
public static function getParcel($what, $orderid = 0)
{
$data = array('volume' => 0, 'weight' => 0, 'height' => 0, 'width' => 0, 'length' => 0);
if ($what == 'site') {
$order = Basket::getOrder();
$arrField = 'goods';
$data = array('volume' => 0, 'weight' => 0);
foreach ($order[$arrField] as $item) {
if ($item['set'] == true) {
foreach ($item['goods'] as $goods) {
$temp = Catalog::getArticle($goods['sizeId']);
$data['volume'] += $temp['height'] * $temp['width'] * $temp['length'];
$data['weight'] += $temp['weight'];
if ($temp['width'] > $data['width']) {
$data['width'] = $temp['width'];
}
if ($temp['length'] > $data['length']) {
$data['length'] = $temp['length'];
}
$data['height'] += $temp['height'];
}
} else {
$temp = Catalog::getArticle($item['sizeId']);
$data['volume'] += $temp['height'] * $temp['width'] * $temp['length'];
$data['weight'] += $temp['weight'];
if ($temp['width'] > $data['width']) {
$data['width'] = $temp['width'];
}
if ($temp['length'] > $data['length']) {
$data['length'] = $temp['length'];
}
$data['height'] += $temp['height'];
}
}
$data['volume'] = $data['volume'] / 1000000;
$data['weight'] = $data['weight'] / 1000;
$address = Region::getCity($_SESSION['iuser']['address'][0]['city']);
} else {
$order = Orders::getOrderById($orderid);
foreach ($order['goods'] as $item) {
$temp = Goods::getSizeByName($item['tree'], $item['size']);
$data['volume'] += $temp['height'] * $temp['width'] * $temp['length'];
$data['weight'] += $temp['weight'];
if ($temp['width'] > $data['width']) {
$data['width'] = $temp['width'];
}
if ($temp['length'] > $data['length']) {
$data['length'] = $temp['length'];
}
$data['height'] += $temp['height'];
}
$data['volume'] = $data['volume'] / 1000000;
$data['weight'] = $data['weight'] / 1000;
$address = IuserAddress::getCity($order['address']['city']);
}
return array('data' => $data, 'address' => $address);
}
public function printorder()
{
$model = new Orders();
$text = View::getPluginEmpty('print', $model->getOrderById($_GET['id']));
echo $text;
}
