.html" title="<?php 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; ?>
echo CatalogKurorts::count(); ?> </u></li> <li><?php echo Yii::t("page", "гостиниц"); ?> : <u><?php echo CatalogHotels::count(); ?> </u></li> <li><?php echo Yii::t("page", "туристических фирм"); ?> : <u><?php echo CatalogFirms::count(); ?> </u></li> <li><?php echo Yii::t("page", "статей о туризме"); ?> : <u><?php echo CatalogInfoCategory::count(); ?> </u></li> <!-- <li>частных объявлений: <u>45</u></li> --> </ul> </div> <?php $this->endCache(); }
<?php // Категории $listCategory = CatalogInfoCategory::sql("SELECT id, owner FROM `catalog_info_category` WHERE owner>0 AND id IN( SELECT category_id FROM catalog_info WHERE " . $infoSQL . " AND del=0 AND active=1 )"); $reCategory = array(); $reCategory2 = array(); // Раскладываем по OWNER-у foreach ($listCategory as $category) { $reCategory[$category["owner"]][] = $category["id"]; } // Подменяем ID на обект и подсчитываем количество foreach ($reCategory as $category => $value) { $ownerCategoryModel = CatalogInfoCategory::fetch($category); $array = array(); foreach ($value as $cid) { if ($cid > 0) { $obj = CatalogInfoCategory::fetch($cid); $array[] = $obj; } } $reCategory2[$ownerCategoryModel->name] = $array; } ?> <div class="CICategory"> <div class="CICLabel"><?php echo Yii::t("page", "Категории"); ?> </div> <div class="CICategoryScrool"> <ul> <?php