Доработки магазина Simpla: облако производителей

71
72
73
74
75

		// Бренды
		$query = sql_placeholder("SELECT * FROM brands ORDER BY name");
		$this->db->query($query);
		$allbrands = $this->db->results();
		$this->smarty->assign('all_brands', $allbrands);

// Бренды $query = sql_placeholder("SELECT * FROM brands ORDER BY name"); $this->db->query($query); $allbrands = $this->db->results(); $this->smarty->assign('all_brands', $allbrands);

71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88

		// Бренды
		$query = sql_placeholder("SELECT brands.*, COUNT(products.product_id) AS `count` FROM brands
            LEFT JOIN products ON products.brand_id = brands.brand_id
            WHERE products.enabled = 1
            GROUP BY brands.brand_id
            ORDER BY brands.name");
		$this->db->query($query);
		$allbrands = $this->db->results();
 
        $min = 100;
        $max = 0;
        foreach($allbrands AS $k=>$v) {
            if($min > $v->count) $min = $v->count;
            if($max < $v->count) $max = $v->count;
        }
        $this->smarty->assign('min_brands', $min);
        $this->smarty->assign('max_brands', $max);
$this->smarty->assign('all_brands', $allbrands);

// Бренды $query = sql_placeholder("SELECT brands.*, COUNT(products.product_id) AS `count` FROM brands LEFT JOIN products ON products.brand_id = brands.brand_id WHERE products.enabled = 1 GROUP BY brands.brand_id ORDER BY brands.name"); $this->db->query($query); $allbrands = $this->db->results(); $min = 100; $max = 0; foreach($allbrands AS $k=>$v) { if($min > $v->count) $min = $v->count; if($max < $v->count) $max = $v->count; } $this->smarty->assign('min_brands', $min); $this->smarty->assign('max_brands', $max); $this->smarty->assign('all_brands', $allbrands);

150
151
152
153
154
155
156
157
158
159
160

            <!-- Меню каталога #End /-->
 
            {if $all_brands}
            <!-- Список брендов /-->
            <div id="brands_menu">
				{foreach name=brands from=$all_brands item=b}
                 <a href='brands/{$b->url}'>{$b->name|escape}</a>
                {/foreach}  
            </div>
            <!-- Список брендов #End /-->
            {/if}

<!-- Меню каталога #End /--> {if $all_brands} <!-- Список брендов /--> <div id="brands_menu"> {foreach name=brands from=$all_brands item=b} <a href='brands/{$b->url}'>{$b->name|escape}</a> {/foreach} </div> <!-- Список брендов #End /--> {/if}

150
151
152
153
154
155
156
157
158
159
160
161

            <!-- Меню каталога #End /-->
 
            {if $all_brands}
            <!-- Список брендов /-->
            {math equation="(y - x) / z" x=$min_brands y=$max_brands z=5 assign='step_brands'}
            <div id="brands_menu">
				{foreach name=brands from=$all_brands item=b}
                 <a href='brands/{$b->url}' style='font-size:{math equation="round(12 + x/y*4)" x=$b->count y=$step_brands}px'>{$b->name|escape}</a>
                {/foreach}  
            </div>
            <!-- Список брендов #End /-->
            {/if}

<!-- Меню каталога #End /--> {if $all_brands} <!-- Список брендов /--> {math equation="(y - x) / z" x=$min_brands y=$max_brands z=5 assign='step_brands'} <div id="brands_menu"> {foreach name=brands from=$all_brands item=b} <a href='brands/{$b->url}' style='font-size:{math equation="round(12 + x/y*4)" x=$b->count y=$step_brands}px'>{$b->name|escape}</a> {/foreach} </div> <!-- Список брендов #End /--> {/if}