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)); }