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"; ?>