public function actionCity()
{
$slug = Yii::app()->request->getParam("slug", "");
$city = CatalogCity::fetchBySlug($slug);
Yii::app()->page->setTitle('Достопримечательности ' . $city->name2);
$this->render("city", array("city" => $city));
}
public function actionCity()
{
if (!empty($_GET["slug"])) {
$model = CatalogCity::fetchBySlug(trim($_GET["slug"]));
if ($model->id > 0) {
unset($_GET["slug"]);
$_GET["city_id"] = $model->id;
}
}
$this->actionIndex();
}
/**
* This is the default 'index' action that is invoked
* when an action is not explicitly requested by users.
*/
public function actionListCity()
{
$countryId = !empty($_GET["country"]) && (int) $_GET["country"] > 0 ? (int) $_GET["country"] : null;
if (!empty($countryId)) {
$dbcriterii = DBQueryParamsClass::CreateParams()->setConditions("country=:country_id")->setParams(array(":country_id" => $countryId));
$cout = "";
$listCity = CatalogCity::fetchAll($dbcriterii);
if (sizeof($listCity) > 0) {
foreach ($listCity as $key => $data) {
$cout .= "<option value='" . $data->id . "'>" . $data->name . "</option> ";
}
} else {
$cout .= "<option value=''> --- --- --- </option> ";
}
echo $cout;
}
Yii::app()->end();
die;
}
<div id="LMenu">
<div class="MNHeader">Города</div>
<?php
foreach (CatalogCity::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("country_id=:cid AND id in(1,2,3,4,6,7,8)")->setParams(array(":cid" => 1))->setOrderBy("name")->setLimit(-1)) as $item) {
?>
<div class="LMItem">
<a href="<?php
echo SiteHelper::createUrl("/attractions") . $item->slug;
?>
.html" title="<?php
echo $item->name;
?>
"><?php
echo $item->name;
?>
</a>
</div>
<?php
}
?>
</div>
<div class="lBanner"><?php
echo Yii::app()->banners->getBannerByCategory("left");
?>
</div>
<br/>
<div id="LeftBG">
<?php
$this->widget("infoWidget", array("title" => Yii::t("page", "Информация туристу"), "class" => "CatalogInfo", "link" => "/touristInfo"));
?>
</div>
<div class="leftBlock">
<?php
$this->widget("findFormWidget");
?>
<div class="LeftMenu">
<h3><?php
echo Yii::t("page", "Разделение по городам");
?>
</h3>
<?php
if ($this->beginCache("hotels_city" . "_" . Yii::app()->getLanguage(), array('duration' => 3600))) {
?>
<ul>
<?php
foreach (CatalogCountry::fetchAll(DBQueryParamsClass::CreateParams()->setOrderBy("name")->setLimit(-1)) as $citem) {
$clitCity = CatalogCity::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("country_id=:country_id")->setParams(array(":country_id" => $citem->id))->setOrderBy("name")->setLimit(-1));
?>
<?php
if (sizeof($clitCity) > 0) {
?>
<li><a href="<?php
echo SiteHelper::createUrl("/hotels/country") . "/" . $citem->slug;
?>
.html" title="<?php
echo Yii::t("page", "отели");
?>
<?php
echo $citem->name_2;
?>
"><?php
echo $citem->name;
