public function actionTest2()
{
/*
нужно сделать сарипт на WT который будет отправлять рассылку в очередь основываясь на таблице
- Нужно делать 2 версии для узбекистана и остальные
- Если в рассылки меньше 4 предложений то не отправлять такое предложение
*/
$logTable = SubscribeTable::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("date2=:date")->setParams(array(":date" => date("Y-m-d")))->setLimit(1)->setCache(0));
if (sizeof($logTable) > 0) {
Yii::import("modules.console.components.*");
Yii::import("modules.console.controllers.*");
$worldCount = 0;
$uzCount = 0;
$itemCount = 0;
$item = $logTable[0];
$sql = "SELECT count(id) as count_ FROM catalog_tours WHERE active=1";
if ($item->category_id->id > 0) {
$sql .= " AND category_id='" . $item->category_id->id . "'";
}
$worldCountArr = CatalogTours::sql($sql . " AND country_id='1' ");
if (sizeof($worldCountArr) > 0) {
$worldCount = $worldCountArr[0]["count_"];
}
if ($item->country_id->id > 1) {
$uzCountArr = CatalogTours::sql($sql . " AND country_id='" . $item->country_id->id . "'");
if (sizeof($uzCountArr) > 0) {
$uzCount = $uzCountArr[0]["count_"];
}
} else {
$uzCountArr = CatalogTours::sql($sql . " AND country_id!=1 ");
if (sizeof($uzCountArr) > 0) {
$uzCount = $uzCountArr[0]["count_"];
}
}
$class = new SubscribeTableController(rand(100, 999));
echo $logTable[0]->id . "*";
// отпраляем рассылку для мира
if ($worldCount > 4) {
$message = $class->actionShow($logTable[0]->id, "", true);
$usersGroup = SubscribeTableUsers::sql("SELECT id FROM subscribe_table_users WHERE id in( SELECT rightId FROM cat_relations WHERE leftClass='SubscribeTable' AND leftId='" . $logTable[0]->id . "' AND rightClass='SubscribeTableUsers' )");
foreach ($usersGroup as $key => $value) {
$usersGroupsList[] = $value["id"];
}
if (!empty($usersGroupsList) && sizeof($usersGroupsList) > 0) {
if (SubscribesUzHelper::sendEmails($usersGroupsList, $logTable[0]->name, $message, 3)) {
echo "Send in World";
} else {
echo "Have the error, wen send in World";
}
}
}
echo "<hr/>";
if ($uzCount > 4 && $logTable[0]->country_id->id != 1) {
echo $class->actionShow($logTable[0]->id, "uzb", true);
}
// echo $message."*";
//if( SubscribesUzHelper::sendEmails( array( 7, 35, 41 ), $subject, $message, 3 ) )echo "Ура отправил";
// else echo "Что-то пошло не так";
} else {
echo sizeof($logTable) . "*";
}
//echo "</body></html>";
}
}
$sql = "SELECT count(id) as count_ FROM catalog_tours WHERE active=1";
if ($item->category_id->id > 0) {
$sql .= " AND category_id='" . $item->category_id->id . "'";
}
$worldCountArr = CatalogTours::sql($sql . " AND country_id='1' ");
if (sizeof($worldCountArr) > 0) {
$worldCount = $worldCountArr[0]["count_"];
}
if ($item->country_id->id > 1) {
$uzCountArr = CatalogTours::sql($sql . " AND country_id='" . $item->country_id->id . "'");
if (sizeof($uzCountArr) > 0) {
$uzCount = $uzCountArr[0]["count_"];
}
} else {
$uzCountArr = CatalogTours::sql($sql . " AND country_id!=1 ");
if (sizeof($uzCountArr) > 0) {
$uzCount = $uzCountArr[0]["count_"];
}
}
?>
<tr>
<td class="fieldID"><?php
echo $item->id;
?>
</td>
<td><?php
echo $item->name;
?>
</td>
<td><?php
<?php
list($arr) = CatalogTours::sql("SELECT sum(col) as sum_ FROM catalog_tours WHERE firm_id='" . $item->id . "'");
$countTour = $arr["sum_"] > 0 ? $arr["sum_"] : 0;
list($arr) = CatalogTours::sql("SELECT sum(col) as sum_ FROM catalog_firms_banners WHERE firm_id='" . $item->id . "'");
$countBanners = $arr["sum_"] > 0 ? $arr["sum_"] : 0;
$listBanners = CatalogFirmsBanners::findByAttributes(array("firm_id" => $item->id));
?>
<h2><?php
echo Yii::t("counter_page", "Статистика посещаемости");
?>
</h2>
<?php
echo SiteHelper::getAnimateText("tekstovka-dlya-stranicy-kabinet-statistika");
?>
<table align="center">
<tr>
<th><?php
echo Yii::t("counter_page", "Количество просмотров страниц о компании");
?>
: </th>
<td><?php
echo $item->col;
?>
</td>
</tr>
<tr>
<th><?php
echo Yii::t("counter_page", "Общее количество просмотров туров компании");
?>
:</th>
</div>
<div class="overflowHidden">
<?php
echo $line["tour_count"];
?>
предложений
</div>
</div>
<?php
}
?>
</div>
<div class="ListTours2">
<h2>Лучшие туры</h2>
<?php
foreach (CatalogTours::sql("SELECT t.*, g.image as image2 FROM catalog_tours t, cat_gallery g WHERE g.catalog='catalog_tours' AND g.item_id = t.id GROUP BY country_id ORDER BY t.rating DESC LIMIT 10") as $item) {
?>
<div class="LTItem2">
<div class="LTHover2"><a href="<?php
echo SiteHelper::createUrl("/tours/description") . "/" . $item["slug"] . ".html";
?>
" title="<?php
echo $item["name"];
?>
"><?php
echo $item["name"];
?>
</a></div>
<div class="LTImag2"><a href="<?php
echo SiteHelper::createUrl("/tours/description") . "/" . $item["slug"] . ".html";
?>
