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);
}
}
function send()
{
$emails = array();
$groups = array();
if (!isset($_POST['users']) and !isset($_POST['email'])) {
return;
}
$sqlGroups = '';
if (!empty($_POST['users'])) {
foreach ($_POST['users'] as $item) {
if ($item == 'iusers') {
$sql = 'SELECT email FROM {{iusers}} WHERE visible=1';
$emails = array_merge($emails, DB::getAll($sql, 'email'));
} elseif ($item == 'subscribers') {
$sql = 'SELECT email FROM {{subscribers}}';
$emails = array_merge($emails, DB::getAll($sql, 'email'));
} elseif ($item == 'orders') {
$sql = 'SELECT email FROM {{orders}}';
$emails = array_merge($emails, DB::getAll($sql, 'email'));
} else {
$groups[] = $item;
}
}
$sqlGroups = 'emailgroups=\'' . implode(',', $_POST['users']) . '\',';
}
if (!empty($groups)) {
$users = Iuser::getGroupUsers($groups, 'email');
$emails = array_merge($emails, $users);
}
$emails[] = $_POST['email'];
$emails = array_unique($emails);
$text = View::getRenderFullEmpty('email/notifications', array('text' => $_POST['body'], 'title' => $_POST['subject']));
foreach ($emails as $email) {
$mail = new Email();
$mail->Text($text);
$mail->Subject($_POST['subject']);
$mail->From($_POST['emailfrom']);
$mail->mailTo($email);
$mail->Send();
}
$sql = '
INSERT INTO {{notification}}
SET
subject=\'' . $_POST['subject'] . '\',
body=\'' . $_POST['body'] . '\',
email=\'' . implode(',', $emails) . '\',
' . $sqlGroups . '
emailfrom=\'' . $_POST['emailfrom'] . '\',
cdate=NOW(),
author=' . $_SESSION['user']['id'] . '
';
DB::exec($sql);
}
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();
}
function toOrder($iuserId = 0, $id = '', $send = true)
{
if ($id == '') {
$id = $this->saveBasket();
}
View::$layout = 'empty';
$data = $this->getOrder();
$data['id'] = $id;
$data['hits'] = Index::getHits();
$text = View::getRender('basket/mail', $data);
$textadmin = View::getRender('basket/mailadmin', $data);
$info = View::getRender('basket/mailinfo');
$code = '';
/*if($info!='Наличными'){
$_SESSION['code']=rand(1,9999);
$code='<br /><br /><b>Код подтверждения:<b/> '.$_SESSION['code'];
}*/
$this->saveBasket($id, $text, $data, $info, $iuserId);
if ($send) {
$mail = new Email();
$mail->Text($textadmin);
$mail->Subject('Поступил заказ с сайта www.' . str_replace('www.', '', $_SERVER["HTTP_HOST"]));
$mail->From('robot@' . str_replace('www.', '', $_SERVER["HTTP_HOST"]));
$mail->To(Funcs::$conf['email']['order']);
$mail->Send();
if ($_SESSION['mydata']['email']) {
$data['client'] = 1;
$text = View::getRender('basket/mail', $data);
$info = View::getRender('basket/mailinfo');
$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->mailTo($_SESSION['mydata']['email']);
$mail->Send();
}
}
if (SMSuser) {
file_get_contents('http://sms.spb.su/sms.cgi?user='******'&pass='******'&phone=' . Funcs::$conf['additional']['sms'] . '&flash=0&message=' . urlencode(iconv('utf-8', 'windows-1251', 'Заказ ' . $id . ' ' . $_SESSION['mydata']['name'] . ' ' . $_SESSION['mydata']['phone'])) . '&from=' . $_SERVER['HTTP_HOST'] . '');
}
$_SESSION['mydata'] = array();
$_SESSION['goods'] = array();
$_SESSION['orderId'] = $id;
}
public function setReport($id)
{
foreach ($_POST as $key => $value) {
$_POST[$key] = htmlspecialchars(trim(strip_tags($value)));
}
$cbid = 0;
$sql = '
INSERT INTO {{reports}}
SET
`tree`=' . $id . ',
`name`=\'' . $_POST['name'] . '\',
`email`=\'' . $_POST['email'] . '\',
`report`=\'' . $_POST['report'] . '\',
`stars`=' . $_POST['stars'] . ',
`create_date`=NOW()
';
DB::exec($sql);
$sql = 'SELECT * FROM {{reports}} WHERE tree=' . $id . '';
$list = DB::getAll($sql);
$count = count($list);
$sum = 0;
foreach ($list as $item) {
$sum += $item['stars'];
}
$rating = round($sum / $count);
$sql = '
UPDATE {{catalog}}
SET rating=' . $rating . '
WHERE tree=' . $id . '
';
DB::exec($sql);
$path = Tree::getPathToTree($id);
$text = View::getRenderEmpty('email/adminreport', array('path' => $path));
$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->mailTo(Funcs::$conf['email']['report']);
$mail->Send();
}
public static function addNewOrder($dealerId)
{
DB::escapePost();
$sum = 0;
foreach ($_POST['items'] as $key => $item) {
$sum += $_POST['prices'][$key] * $item;
}
$price = $sum - $sum / 100 * $_SESSION['dealer']['sale'];
//$sql='SELECT * FROM {{dealers_consignee}} WHERE id='.$_POST['cons'].'';
$sql = '
INSERT INTO {{dealers_orders}}
SET
status=1,
price=\'' . $price . '\',
sale=\'' . $sum / 100 * $_SESSION['dealer']['sale'] . '\',
saleperc=\'' . $_SESSION['dealer']['sale'] . '\',
cons=\'' . $_POST['cons'] . '\',
comment=\'' . $_POST['comment'] . '\',
dealer=\'' . $dealerId . '\',
preorder=\'' . $_POST['preorder'] . '\',
cdate=NOW()
';
$orderId = DB::exec($sql);
$dealer = DealersMain::getOne($dealerId);
self::addItemsToOrder($_POST['items'], $orderId, $_POST['prices']);
self::addHistory($orderId, '', 1);
$text = 'Новый заказ № ' . str_repeat('0', 6 - strlen($orderId)) . $orderId . ' поступил от дилера ' . $_SESSION['dealer']['company'] . '';
$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->mailTo(Funcs::$conf['email']['dealers']);
$mail->Send();
}
