/** * 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>
public function actionIndex() { Yii::app()->page->setTitle("Достопримечательности Узбекистана"); $city = CatalogCity::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("country_id=:cid")->setParams(array(":cid" => 1))->setOrderBy("name")->setLimit(-1)); $this->render("index", array("city" => $city)); }
<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;