<?php
// Категории
$listCategory = CatalogKurortsCategory::sql("SELECT id, owner FROM `catalog_kurorts_category` WHERE owner>0 AND id IN( SELECT category_id FROM catalog_kurorts WHERE " . $kurortsSQL . " 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 = CatalogKurortsCategory::fetch($category);
$array = array();
foreach ($value as $cid) {
if ($cid > 0) {
$obj = CatalogKurortsCategory::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
.html" title="<?php
echo $item_->name;
?>
<?php
echo Yii::t("page", "зоны отдыха");
?>
"><?php
echo $item_->name;
?>
( <?php
echo $count;
?>
)</a>
<ul>
<?php
foreach (CatalogKurortsCategory::fetchAll(DBQueryParamsClass::CreateParams()->setOrderBy("name")->setConditions("owner=:owner")->setParams(array(":owner" => $item_->id))->setLimit(-1)) as $item) {
$count = CatalogKurorts::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("/resorts/category") . "/" . $item->slug;
?>
.html" title="<?php
echo $item->name;
?>
"><?php
echo $item->name;
?>
