public function actionDescription()
{
if (!empty($_GET["slug"])) {
$model = CatalogCountry::fetchBySlug(trim($_GET["slug"]));
}
if ($model && $model->id > 0) {
$item = $model;
Yii::app()->page->setInfo(array("description" => $item->name . "," . $this->description, "keyWord" => $item->name . "," . $this->keyWord));
if (!empty($item) && $item->id > 0) {
Yii::app()->page->title = $item->name;
$this->render('description', array("item" => $item, "tours" => CatalogTours::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("image>'' AND country_id=:id")->setParams(array(":id" => $item->id))->setOrderBy("col DESC")->setLimit(8)), "firms" => CatalogFirms::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("image>'' AND country_id=:id")->setParams(array(":id" => $item->id))->setOrderBy("rand()")->setLimit(12)), "otherCountry" => CatalogCountry::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("id!=:id")->setParams(array(":id" => $item->id))->setOrderBy("col DESC")->setLimit(8)), "tourCount" => CatalogTours::count(DBQueryParamsClass::CreateParams()->setConditions("country_id=:country")->setParams(array(":country" => $item->id))), "firmCount" => CatalogFirms::count(DBQueryParamsClass::CreateParams()->setConditions("country_id=:country")->setParams(array(":country" => $item->id)))));
} else {
throw new CHttpException("Ошибка", Yii::t("page", "Ошибка перехода на страницу"));
}
} else {
throw new CHttpException("Ошибка", Yii::t("page", "Ошибка перехода на страницу"));
}
}
public function actionIndex()
{
$page = (int) Yii::app()->request->getParam("p", 1);
$this->layout = '//layouts/main-landing';
if (!empty($_GET["country"])) {
$model = CatalogCountry::fetchBySlug(trim($_GET["country"]));
}
if ($model && $model->id > 0) {
$item = $model;
Yii::app()->page->setInfo(array("description" => $item->name . "," . $this->description, "keyWord" => $item->name . "," . $this->keyWord));
if (!empty($item) && $item->id > 0) {
Yii::app()->page->title = $item->name;
$this->render('index', array("item" => $item, "page" => $page, "tours" => CatalogTours::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("image>'' AND country_id=:id")->setParams(array(":id" => $item->id))->setOrderBy("rating DESC")->setLimit(12)), "gallerySlide" => CatGallery::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("catalog='catalog_country' AND type='slide-gallery' AND item_id=:id")->setParams(array(":id" => $item->id))->setOrderBy("pos")->setLimit(-1)), "gallery" => CatGallery::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("catalog='catalog_country' AND type='' AND item_id=:id")->setParams(array(":id" => $item->id))->setOrderBy("pos")->setLimit(9)), "info" => CatalogInfo::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("category_id=(SELECT id FROM catalog_info_category WHERE slug=:slug LIMIT 1)")->setParams(array(":slug" => $item->slug))), "monuments" => CatalogMonuments::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("country_id=:id")->setParams(array(":id" => $item->id)))));
} else {
throw new CHttpException("Ошибка", Yii::t("page", "Ошибка перехода на страницу"));
}
} else {
throw new CHttpException("Ошибка", Yii::t("page", "Ошибка перехода на страницу"));
}
}
$array = array();
foreach ($value as $cid) {
if ($cid > 0) {
$obj = CatalogToursCategory::fetch($cid);
$array[] = $obj;
}
}
$reCategory2[$ownerCategoryModel->name] = $array;
}
// Странны
$listCountry = CatalogCountry::sql("SELECT id FROM `catalog_country` WHERE id IN( SELECT country_id FROM catalog_tours WHERE firm_id=" . $item->id . " AND del=0 AND active=1 )");
$reCountry2 = array();
// Подменяем ID на обект и подсчитываем количество
foreach ($listCountry as $id => $keys) {
if ($keys["id"] > 0) {
$obj = CatalogCountry::fetch($keys["id"]);
if ($obj->id > 0) {
$reCountry2[] = $obj;
}
}
}
?>
<div class="col-xs-6">
<div class="panel panel-success">
<div class="panel-heading"><?php
echo Yii::t("page", "Категории туров");
?>
</div>
<div class="panel-body">
<ul>
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new CatalogCountry();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['CatalogCountry'])) {
$model->attributes = $_POST['CatalogCountry'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('create', array('model' => $model));
}
}
?>
<div id="CIHeader" class="overflowHidden">
<?php
if (Yii::app()->controller->getId() == "tours") {
?>
<div id="CIFind" class="panel panel-success panel-open">
<div class="panel-heading">ИСКАТЬ ТУРЫ ПО СТРАННАМ <img src="themes/classic/images/menu_bg3.png" /></div>
<div class="panel-body panel-display-block">
<?php
if ($this->beginCache("tours_country_" . Yii::app()->getLanguage(), array('duration' => 3600))) {
?>
<ul class="TFCountry">
<?php
foreach (CatalogCountry::fetchAll(DBQueryParamsClass::CreateParams()->setOrderBy("name")->setLimit(-1)) as $item) {
$count = CatalogTours::count(DBQueryParamsClass::CreateParams()->setConditions("country_id=:country")->setParams(array(":country" => $item->id))->setLimit(-1));
?>
<li><img src="<?php
echo $item->flag;
?>
"><a href="<?php
echo SiteHelper::createUrl("/tours/country") . "/" . $item->slug;
?>
.html" title="<?php
echo Yii::t("page", "туры");
?>
<?php
echo $item->name_2;
?>
"><?php
<?php
if ($this->beginCache("site_counts" . "_" . Yii::app()->getLanguage(), array('duration' => 3600 * 24))) {
?>
<div id="RStatistic">
<ul>
<li><b><?php
echo Yii::t("page", "На сайте");
?>
:</b></li>
<li><?php
echo Yii::t("page", "туристических стран");
?>
: <u><?php
echo CatalogCountry::count();
?>
</u></li>
<li><?php
echo Yii::t("page", "туров");
?>
: <u><?php
echo CatalogTours::count();
?>
</u></li>
<li><?php
echo Yii::t("page", "курортов");
?>
: <u><?php
echo CatalogKurorts::count();
?>
</u></li>
<?php
$this->widget('addressLineWidget', array('links' => array(Yii::t("travelAgency", "Туристические агентства") . $item->country_id->name_2 => SiteHelper::createUrl("/travelAgency"), $item->name)));
$listComments = CatalogFirmsComments::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("firm_id=:firm_id AND active=1")->setParams(array(":firm_id" => $item->id))->setOrderBy("id DESC")->setLimit(-1)->setCache(0));
$listService = CatalogFirmsService::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("firm_id=:firm_id AND active=1")->setParams(array(":firm_id" => $item->id))->setLimit(-1)->setCache(0));
$toursCondition = "firm_id=:firm_id AND active=1";
$tourParams = array(":firm_id" => $item->id);
$country = Yii::app()->request->getParam("country", "");
if (!empty($country)) {
$countryModel = CatalogCountry::fetchBySlug($country);
} else {
$countryModel = new CatalogCountry();
}
$category = Yii::app()->request->getParam("category", "");
if (!empty($category)) {
$categoryModel = CatalogToursCategory::fetchBySlug($category);
} else {
$categoryModel = new CatalogToursCategory();
}
if ($countryModel->id > 0) {
$toursCondition .= " AND country_id='" . $countryModel->id . "'";
}
if ($categoryModel->id > 0) {
$toursCondition .= " AND category_id='" . $categoryModel->id . "'";
}
$listTours = CatalogTours::fetchAll(DBQueryParamsClass::CreateParams()->setConditions($toursCondition)->setParams($tourParams)->setOrderBy("pos DESC")->setLimit(-1)->setCache(0));
$listItems = CatalogFirmsItems::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("firm_id=:firm_id AND active=1")->setParams(array(":firm_id" => $item->id))->setLimit(-1)->setCache(0));
?>
<div id="InnerText" class="innerPage">
<br/>
<?php
?>
</div>
<div id="fc_other">
<div id="fc_other_01">
<div id="fc_other_02">
<h3><?php
echo Yii::t("page", "Все туристические страны");
?>
:</h3>
<?php
if ($this->beginCache("firstPage_country_" . Yii::app()->getLanguage(), array('duration' => 3600))) {
?>
<ul>
<?php
foreach (CatalogCountry::fetchAll(DBQueryParamsClass::CreateParams()->setLimit(-1)->setCache(0)) as $item) {
$tour = CatalogTours::count(DBQueryParamsClass::CreateParams()->setConditions("country_id=:country_id")->setParams(array("country_id" => $item->id)));
$hotels = CatalogHotels::count(DBQueryParamsClass::CreateParams()->setConditions("country_id=:country_id")->setParams(array("country_id" => $item->id)));
$info = CatalogInfo::count(DBQueryParamsClass::CreateParams()->setConditions("country_id=:country_id")->setParams(array("country_id" => $item->id)));
?>
<li>
<a href="<?php
echo SiteHelper::createUrl("/tours/country") . "/" . $item->slug;
?>
.html" title="<?php
echo Yii::t("page", "Туры");
?>
<?php
echo $item->name_2;
?>
" onmouseover="displayOrNone('fcp_lt_<?php
<option value="">Еще категория</option>
<option value="">Третья категория</option>
</select>
</div>
</div>
<div class="MFRow">
<div class="FBlock">цена от (USD):<br/><input type="text" name="CatalogTours[price]" value="" /></div>
<div class="FBlock">цена до (USD):<br/><input type="text" name="CatalogTours[price_2]" value="" /></div>
<div class="FBlock FBSubmit"><input type="submit" name="send_find" value="НАЙТИ" /></div>
</div>
</form>
</div>
<div class="ListTours">
<h2>Популярные туристические страны</h2>
<?php
foreach (CatalogCountry::sql("SELECT c.id as id, c.name as name, c.title as title, c.description as description, c.banner2 as banner2, count(t.id) as tour_count, c.slug as slug, c.name_2 as name2 FROM `catalog_tours` t, catalog_country c WHERE c.id=t.country_id GROUP BY t.country_id ORDER BY count(t.id) DESC LIMIT 10") as $line) {
$minTour = CatalogTours::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("country_id=:id AND price>0")->setParams([":id" => $line["id"]])->setOrderBy("price")->setLimit(1));
$currency = $minTour[0]->currency_id->id > 0 ? $minTour[0]->currency_id->title : "\$";
?>
<div class="LTItem">
<div class="LTImag"><a href="<?php
echo SiteHelper::createUrl("/countryPage", array("country" => $line["slug"]));
?>
" title="<?php
echo $line["title"];
?>
"><img src="<?php
echo $line["banner2"];
?>
" alt="<?php
echo $line["title"];
public function actionIndex()
{
$this->render('index', ["country" => CatalogCountry::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("id IN ( SELECT country_id FROM catalog_tours WHERE is_newyear=1 )")->setOrderBy("rating DESC"))]);
}
public function actionShow($idIn = 0, $locatIn = "", $return = FALSE)
{
$id = (int) Yii::app()->request->getParam("id", 0);
if ($id == 0 && $idIn > 0) {
$id = $idIn;
}
$locat = Yii::app()->request->getParam("location", "");
if (empty($locat) && !empty($locatIn)) {
$locat = $locatIn;
}
/*
График:
По странам ( сортировка по цене ) 31
По категориям ( сортировка по цене ) 30
По странам ( сортировка по просмотрам)
По категориям ( сортировка по просмотрам )
Определям кандидата по очереди сначала города потом категории
Выбираем по сортировке первую страну
Проверяем по очередньсти
Формируем письмо
Заголовок ( зависит от того по стране или категории + от сортировки )
указываем группу подписциков
указываем группу рассылоку
И полетели
*/
$cout = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Cache-Control" content="public"/>
<meta http-equiv="Cache-Control" content="max-age=86400, must-revalidate"/>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>';
$logTable = SubscribeTable::fetch($id);
if ($logTable->id > 0) {
if ($locat == "uzb" && $logTable->country_id->id == 1) {
return "";
}
$countryId = 0;
$categoryId = 0;
if ($logTable->country_id->id > 0) {
$countryId = $logTable->country_id->id;
$countryModel = CatalogCountry::fetch($countryId);
}
if ($logTable->category_id->id > 0) {
$categoryId = $logTable->category_id->id;
$categoryModel = CatalogToursCategory::fetch($categoryId);
}
if ($countryId > 0 || $categoryId > 0) {
$info = [];
if ($countryId > 0) {
$toursMinPrice = CatalogTours::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("country_id=:cid AND price>0 AND active=1")->setParams([":cid" => $countryModel->id])->setOrderBy("price")->setLimit(1)->setCache(0));
$tours = CatalogTours::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("country_id=:cid AND id !=:id AND active=1")->setParams([":cid" => $countryModel->id, ":id" => $toursMinPrice[0]->id])->setLimit(7)->setOrderBy("rating DESC, price"));
$tours[] = $toursMinPrice[0];
$info = CatalogInfo::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("country_id=:cid")->setParams([":cid" => $countryModel->id])->setLimit(4)->setOrderBy("id DESC"));
$subject = $countryModel->title . ", от " . $tours[sizeof($tours) - 1]->price . ($tours[sizeof($tours) - 1]->currency_id->id ? $tours[sizeof($tours) - 1]->currency_id->title : "\$");
} else {
$params = [":cid" => $categoryModel->id];
$condition = "category_id=:cid";
if ($locat == "uzb") {
echo $locat . "==uzb<br/>";
$params = array_merge($params, [":country" => 1]);
$condition .= " AND country_id!=:country";
} else {
$params = array_merge($params, [":country" => 1]);
$condition .= " AND country_id=:country";
}
echo $condition . "*";
$toursMinPrice = CatalogTours::fetchAll(DBQueryParamsClass::CreateParams()->setConditions($condition)->setParams($params)->setOrderBy("price")->setLimit(1)->setCache(0));
$tours = CatalogTours::fetchAll(DBQueryParamsClass::CreateParams()->setConditions($condition . " AND id !=:id")->setParams(array_merge($params, [":id" => $toursMinPrice[0]->id]))->setLimit(7)->setOrderBy("rating DESC, price"));
$tours[] = $toursMinPrice[0];
//$info = CatalogInfo::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("country_id=:cid")->setParams([":cid" => $categoryModel->id])->setLimit(4)->setOrderBy("id DESC"));
if ($tours[sizeof($tours) - 1]->price > 0) {
$subject = "Тур - " . $categoryModel->name . ", от " . $tours[sizeof($tours) - 1]->price . ($tours[sizeof($tours) - 1]->currency_id->id ? $tours[sizeof($tours) - 1]->currency_id->title : "\$");
} else {
$subject = "Тур - " . $categoryModel->name;
}
}
$message = "Предлагаем Вашему вниманию интересную подборку с нашего портала <a href=\"http://www.world-travel.uz\">World-Travel.uz</a>.<br/><br/><h1>" . $subject . "</h1><br/><table>";
$n = 0;
$reserveNum = 0;
$reserveList = [];
foreach ($tours as $tour) {
if ($tour->id == 0) {
continue;
}
$image = ImageHelper::getImages($tour, 1);
// Если картинки для тура нету, то берем её из резерва catalog_image_reserve
if (sizeof($image) == 0) {
if (sizeof($reserveList) == 0) {
$reserveList = CatalogImageReserve::findByAttributes(["country_id" => $tour->country_id->id]);
}
if (sizeof($reserveList) > 0) {
$new = new CatGallery();
if (!empty($reserveList[$reserveNum])) {
$new->image = $reserveList[$reserveNum]->image;
} else {
if ($tour->country_id->banner) {
$new->image = $tour->country_id->banner;
} else {
$new->image = $tour->country_id->image;
}
}
$image[] = $new;
$reserveNum++;
}
}
if ($n == 0 || $n == 2 || $n == 4 || $n == 6) {
$message .= "<tr>";
}
$message .= "<td style=\"width:50%;text-align:center;vertical-align: top;background-color: #EEE9DD;padding: 10px;border: 1px solid #fff;\">\n <table width=\"100%\">\n <tr>\n <td style=\"background:#E4DDCD;font-size:13px;text-align: right;padding-right: 5px;vertical-align: middle;\"><b>" . $tour->name . "</b></td>";
if ($tour->price > 0) {
$message .= "<td style=\"background:#E4DDCD;vertical-align: top;line-height: 14px;text-align: center;\"><span style=\"font-size:10px;\">от</span><br/><b style=\"color:#ff4f00;font-size:24px;\"> " . $tour->price . ($tour->currency_id->id ? $tour->currency_id->title : "\$") . "</b><br/></td>";
}
$message .= "</tr>\n </table>";
if (sizeof($image) > 0) {
$message .= "<div style=\"max-height: 134px;overflow: hidden;\"><img src=\"" . (SiteHelper::createUrl("/") . ImageHelper::getImage($image[0]->image, 2)) . "\" style=\"max-width:200px\"/></div>";
}
//if( $tour->included )$message .= "<td>Включенно: ".$tour->included."</td></tr>";
if ($tour->duration) {
$message .= $tour->duration . "<br/>";
}
if ($tour->category_id->id > 0) {
$message .= "Тур - " . $tour->category_id->name2 . "<br/>";
}
$message .= "<div><a style=\"margin-top: 11px;background:#ff4f00;color:#fff;font-weight: bold;display: inline-block;padding: 5px 10px;border-radius: 4px;\" href=\"" . SiteHelper::createUrl("/tours/description") . "/" . $tour->slug . ".html\">Заказать</a></div></td>";
//
if ($n == 1 || $n == 3 || $n == 5 || $n == 7) {
$message .= "</tr>";
}
$n++;
}
$message .= '</table></div><br/>';
if (sizeof($info) > 0) {
$message .= '<div style="background: #e4ddcd;padding: 0px 10px 10px 10px;overflow: hidden;"><table>';
foreach ($info as $item) {
$message .= "<tr><td colspan=\"2\"><h3 style=\"margin:10px 0px 5px 0px;\">" . $item->name . "</h3></td></tr>\n <tr>\n <td colspan=\"2\" style=\"border-bottom:1px solid #F4F1EA;padding-bottom:10px;\">\n <table width=\"100%\">\n <tr>\n <td><img src=\"" . SiteHelper::createUrl("/") . ImageHelper::getImage($item->image, 2) . "\" style=\"padding-right: 10px;\" alt=\"" . $item->name . "\" /></td>\n <td style=\"text-align: justify;vertical-align:top\">" . SiteHelper::getSubTextOnWorld($item->description, 350) . "<br/><div align=\"right\"><a href=\"" . SiteHelper::createUrl("/touristInfo/description") . $item->slug . ".html\">читайте подробнее >>></a></div></td>\n </tr>\n </table>\n </td>\n </tr>";
//
}
$message .= "</table></div>";
}
$cout .= $message . "</body></html>";
//if( SubscribesUzHelper::sendEmails( array( 7, 35, 41 ), $subject, $message, 3 ) )echo "Ура отправил";
// else echo "Что-то пошло не так";
}
}
if ($return) {
return $cout;
} else {
echo $cout;
}
}
public function actionRegistration()
{
if (!Yii::app()->user->isGuest) {
$this->redirect(SiteHelper::createUrl("/user"));
}
$successfully = SiteHelper::checkedVaribal(Yii::app()->request->getParam("successfully", ""), "string");
$user = new CatalogUsersRegistration();
Yii::app()->page->title = Yii::t("user", "Регистрация");
if (!empty($_POST["CatalogUsersRegistration"])) {
$user->setAttributes($_POST["CatalogUsersRegistration"]);
// Если указан Email проверяем небыл ли он зарегетрирован ранее,
// если был но не активировал аккаунт то предлогаем отправить ему сообщение с активацией заново
if ($user->email) {
$checkUser = CatalogUsers::findByAttributes(array("email" => $user->email));
if (is_array($checkUser) && sizeof($checkUser) > 0) {
if ($checkUser[0]->active == 0) {
$content = CatalogContent::fetchBySlug("registration_resend_activation");
if ($content && $content->id > 0) {
$errorMessage = $content->description;
$errorMessage = str_replace("{link}", SiteHelper::createUrl("/user/default/resend", array("email" => $user->email)), $errorMessage);
} else {
$errorMessage = Yii::t("user", "Вы уже зарегистрировались ранее");
}
$user->addError(Yii::t("user", "Ошибка регистрации"), $errorMessage);
}
}
}
if ($user->save()) {
$user->onRegistration(new CModelEvent($user), array());
$this->redirect($this->createUrl("/user/default/registration", array("successfully" => $user->email)));
}
}
$arrayCountry = array();
$listCoutnry = CatalogCountry::fetchAll();
foreach ($listCoutnry as $key => $data) {
$arrayCountry[$data->id] = $data->name;
}
$title = "Регистрация";
if (!empty($successfully)) {
$okMessage = "<b>" . Yii::t("user", "Регистрация сохранена.</b><br/>В течении нескольких минут к Вам на почту придет письмо для подтверждения Email") . "<br/><br/><b>" . Yii::t("user", "Письмо не пришло?") . "</b><br/> <a href=\"" . SiteHelper::createUrl("/user/default/resend", array("email" => $successfully)) . "\">" . Yii::t("user", "отправить заново письмо для подтверждения на ") . $successfully . "</a>\n <br/><br/><b>" . Yii::t("user", "Все равно не пришло?</b><br/>Это странно, тогда Вам необходимо будет написать, с Email который вы указали при регистрации, письмо в службу тех. поддержки") . " <a href=\"mailto:" . Yii::app()->params["supportEmail"] . "\">" . Yii::app()->params["supportEmail"] . "</a><br/>" . Yii::t("user", "Пример письма:<br/>Заголовок письма - У меня проблемы с регистрацией<br/>Текст сообщения - Разберитесь пожалуйста");
} else {
$okMessage = null;
}
$this->render("registration", array("form" => $user, "arrayCountry" => $arrayCountry, "title" => $title, "okMessage" => $okMessage));
}
public function actionIndex()
{
$id = Yii::app()->request->getParam("id", 0);
$list_country = CatalogCountry::fetchAll();
$this->render("index", array("list_country" => $list_country, "images" => $images, "trees" => $listTree, "id" => $id));
}
