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