public function actionIndex()
{
$tab = Yii::app()->request->getParam("tab", "");
$page = (int) Yii::app()->request->getParam("p", 1);
$action = Yii::app()->request->getParam("action", "t");
$country = Yii::app()->request->getParam("country", "");
$category = Yii::app()->request->getParam("category", "");
$ccategory = Yii::app()->request->getParam("ccategory", "");
$icategory = Yii::app()->request->getParam("icategory", "");
$slug = Yii::app()->request->getParam("slug", "");
$activeTab = "";
$t_page = 1;
$i_page = 1;
$c_page = 1;
if ($action == "t") {
$t_page = $page;
$activeTab = "s_tours";
}
if ($action == "i" || $tab == "info") {
$i_page = $page;
$activeTab = "s_info";
}
if ($action == "c" || $tab == "curorts") {
$c_page = $page;
$activeTab = "s_curorts";
}
/* foreach( $_GET as $key=>$item )
{
echo "#";
if( empty( $_GET[$key] ) || $_GET[$key]=="null" )continue;
echo $key."*";
$item = CatalogSections::fetchBySlug( $key );
if( $item->id >0 )break;
}*/
if (!empty($slug)) {
$item = CatalogSections::fetchBySlug($slug);
} else {
$item = CatalogSections::fetchBySlug("otdyh-v-gorah");
}
if ($item && $item->id > 0) {
Yii::app()->page->setInfo(array("description" => $item->name . "," . $this->description, "keyWord" => $item->name . "," . $this->keyWord));
if (!empty($item) && $item->id > 0) {
$infoCategory = " 1=1 ";
$infoSQL = " 1=1 ";
if (!empty($icategory)) {
$infoCategory .= " AND category_id = ( SELECT id FROM catalog_info_category WHERE slug='" . $icategory . "' )";
}
$i = 0;
if (sizeof($item->info) > 0) {
$infoCategory .= " AND ( ";
$infoSQL .= " AND ( ";
foreach ($item->info as $itemC) {
if ($i > 0) {
$infoCategory .= " OR ";
$infoSQL .= " OR ";
}
$infoCategory .= " category_id='" . $itemC->id . "' ";
$infoSQL .= " category_id='" . $itemC->id . "' ";
$i++;
}
$infoCategory .= " ) ";
$infoSQL .= " ) ";
}
$curortsCategory = " 1=1 ";
$kurortsSQL = " 1=1 ";
if (!empty($ccategory)) {
$curortsCategory .= " AND category_id = ( SELECT id FROM catalog_kurorts_category WHERE slug='" . $ccategory . "' )";
}
if (sizeof($item->curorts) > 0) {
$curortsCategory .= " AND ( ";
$kurortsSQL .= " AND ( ";
$i = 0;
foreach ($item->curorts as $itemC) {
if ($i > 0) {
$curortsCategory .= " OR ";
$kurortsSQL .= " OR ";
}
$curortsCategory .= " category_id='" . $itemC->id . "' ";
$kurortsSQL .= " category_id='" . $itemC->id . "' ";
$i++;
}
$curortsCategory .= " ) ";
$kurortsSQL .= " ) ";
$cororts = CatalogKurorts::fetchAll(DBQueryParamsClass::CreateParams()->setConditions($curortsCategory)->setOrderBy("col DESC")->setPage($c_page)->setLimit(15));
$curortsCount = CatalogKurorts::count(DBQueryParamsClass::CreateParams()->setConditions($curortsCategory));
} else {
$cororts = array();
$curortsCount = 0;
}
$toursCategory = " 1=1 ";
$toursSQL = " 1=1 ";
if ($item->country_id->id > 0) {
$toursCategory .= " AND country_id = '" . $item->country_id->id . "'";
$toursSQL .= " AND country_id = '" . $item->country_id->id . "'";
}
if (!empty($country)) {
$toursCategory .= " AND country_id = ( SELECT id FROM catalog_country WHERE slug='" . $country . "' LIMIT 1 )";
}
if (!empty($category)) {
$toursCategory .= " AND category_id = ( SELECT id FROM catalog_tours_category WHERE slug='" . $category . "' LIMIT 1 )";
}
if (sizeof($item->tours) > 0) {
$toursCategory .= " AND ( ";
$toursSQL .= " AND ( ";
}
$i = 0;
foreach ($item->tours as $itemC) {
if ($i > 0) {
$toursCategory .= " OR ";
$toursSQL .= " OR ";
}
$toursCategory .= " category_id='" . $itemC->id . "' ";
$toursSQL .= " category_id='" . $itemC->id . "' ";
$i++;
}
if (sizeof($item->tours) > 0) {
$toursCategory .= " ) ";
$toursSQL .= " ) ";
}
// Одно исключение для детских лагерей
if ($item->id == 7) {
$detCount = CatalogKurorts::count(DBQueryParamsClass::CreateParams()->setConditions($curortsCategory));
} else {
$detCount = 0;
}
Yii::app()->page->title = $item->name;
$this->render('index', array("icategory" => $icategory, "ccategory" => $ccategory, "category" => $category, "country" => $country, "activeTab" => $activeTab, "item" => $item, "infoSQL" => $infoSQL, "info" => CatalogInfo::fetchAll(DBQueryParamsClass::CreateParams()->setConditions($infoCategory)->setOrderBy("col DESC")->setPage($i_page)->setLimit(15)), "infoCount" => CatalogInfo::count(DBQueryParamsClass::CreateParams()->setConditions($infoCategory)), "toursSQL" => $toursSQL, "tours" => CatalogTours::fetchAll(DBQueryParamsClass::CreateParams()->setConditions($toursCategory)->setOrderBy("col DESC")->setPage($t_page)->setLimit(15)), "tourCount" => CatalogTours::count(DBQueryParamsClass::CreateParams()->setConditions($toursCategory)), "kurortsSQL" => $kurortsSQL, "curorts" => $cororts, "curortsCount" => $curortsCount, "detCount" => $detCount, "t_page" => $t_page, "i_page" => $i_page, "c_page" => $c_page, "offset" => 15));
} else {
throw new CHttpException("Ошибка", Yii::t("page", "Ошибка перехода на страницу"));
}
} else {
throw new CHttpException("Ошибка", Yii::t("page", "Ошибка перехода на страницу"));
}
}
<th>Название</th>
<th>Дата</th>
<th>Страна</th>
<th>Категория<br/>тура</th>
<th>Действие</th>
</tr>
<?php
foreach ($list as $item) {
$worldCount = 0;
$uzCount = 0;
$itemCount = 0;
// Определеяем количество статей
if ($item->info_category_id->id > 0) {
$itemCount = CatalogInfo::count(DBQueryParamsClass::CreateParams()->setConditions("category_id =:cid")->setParams([":cid" => $item->info_category_id->id]));
} elseif ($item->country_id->id > 0) {
$itemCount = CatalogInfo::count(DBQueryParamsClass::CreateParams()->setConditions("country_id = :cid")->setParams([":cid" => $item->country_id->id]));
} elseif ($item->category_id->id > 0) {
$itemCountArr = CatalogInfo::sql("SELECT count(id) as count_ FROM catalog_info WHERE id in ( SELECT leftId FROM cat_relations WHERE leftClass='CatalogInfo' AND rightId='" . $item->category_id->id . "' AND rightClass='CatalogToursCategory' )");
if (sizeof($itemCountArr) > 0) {
$itemCount = $itemCountArr[0]["count_"];
}
}
if ($item->country_id->id > 0) {
$countryWhere = "country_id = ";
}
$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) {
echo $item_->name;
?>
<?php
echo Yii::t("page", "информация для туристов");
?>
"><?php
echo $item_->name;
?>
( <?php
echo $count;
?>
)</a>
<ul>
<?php
foreach (CatalogInfoCategory::fetchAll(DBQueryParamsClass::CreateParams()->setOrderBy("name")->setConditions("owner=:owner")->setParams(array(":owner" => $item_->id))->setLimit(-1)) as $item) {
$count = CatalogInfo::count(DBQueryParamsClass::CreateParams()->setConditions("category_id=:category")->setParams(array(":category" => $item->id))->setLimit(-1));
?>
<?php
if ($count > 0) {
?>
<li><a href="<?php
echo SiteHelper::createUrl("/touristInfo", array("category" => $item->slug));
?>
.html" title="<?php
echo $item->name;
?>
"><?php
echo $item->name;
?>
( <?php
<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
echo $item->id;
?>
')" onmouseout="displayOrNone('fcp_lt_<?php
