Esempi in PHP per CatalogKurortsCategory::sql

Esempio n. 1

File: curorts.php Progetto: bogiesoft/yii-travel

<?php

if ($this->beginCache("sectionsCurorts-" . $item->id . "_" . Yii::app()->getLanguage(), array('duration' => SiteHelper::getConfig("firmDescriptionTours")))) {
    ?>
    <div id="CIHeader" class="overflowHidden">
        <?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", "Категории");