public static function getSalesOrderBy($categoryId = '')
{
$where = '';
if ($categoryId) {
$items = Tree::find()->where(['tree_id' => $categoryId])->all();
$itemIds = ArrayHelper::getColumn($items, 'item_id');
$where = ' where item_id in (' . implode(',', $itemIds) . ') ';
}
$sql = 'SELECT name, count(item_id) as count FROM `order_item` ' . $where . ' group by item_id order by count desc';
return Yii::$app->db->createCommand($sql)->queryAll();
}
public static function getTreesById($id)
{
/** @var \star\system\models\Tree|\creocoder\nestedsets\NestedSetsBehavior $root */
$root = static::find()->where(['id' => $id])->one();
if ($root) {
$categories = Tree::find()->where('lft >= ' . $root->lft . ' and rgt <= ' . $root->rgt . ' and root = ' . $root->root . ' order by id desc')->indexBy('id')->all();
return array_map(function ($cate) use($root) {
return $cate->name;
}, $categories);
} else {
return false;
}
}
<!--</figure>-->
<!--</div>-->
<hr class="divider_type_3 m_bottom_15">
<a href="category_grid.html" role="button" class="d_inline_b bg_light_color_2 color_dark tr_all_hover button_type_4 r_corners"><i class="fa fa-reply m_left_5 m_right_10 f_size_large"></i>Back to: Woman</a>
</section>
<!--right column-->
<aside class="col-lg-3 col-md-3 col-sm-3">
<figure class="widget shadow r_corners wrapper m_bottom_30">
<figcaption>
<h3 class="color_light">Categories</h3>
</figcaption>
<div class="widget_content">
<!--Categories list-->
<ul class="categories_list">
<?php
$tree = Tree::find()->where(['name' => '商品分类'])->one();
$childrenTags = $tree->children('1')->all();
foreach ($childrenTags as $childrenTag) {
$secondChildren = $childrenTag->children('1')->all();
?>
<li>
<a href="#" class="f_size_large color_dark d_block relative">
<b><?php
echo $childrenTag->name;
?>
</b>
<span class="bg_light_color_1 r_corners f_right color_dark talign_c"></span>
</a>
<?php
if ($secondChildren) {
?>
<span class="centered_db r_corners"></span>
</button>
<!--main menu-->
<nav role="navigation" class="f_left f_xs_none d_xs_none">
<ul class="horizontal_list main_menu clearfix">
<li class="<?php
echo Yii::$app->request->get('catalog') || Yii::$app->request->get('tab') ? '' : 'current';
?>
relative f_xs_none m_xs_bottom_5">
<a href="<?php
echo Url::to(['/']);
?>
" class="tr_delay_hover color_light tt_uppercase"><b>首页</b></a>
</li>
<?php
$root = \star\system\models\Tree::find()->where(['name' => '商品分类'])->one();
if ($root) {
$categories = $root->children(1)->indexBy('id')->limit(5)->all();
if ($categories) {
foreach ($categories as $category) {
?>
<li class="<?php
echo Yii::$app->request->get('catalog') == $category->id ? 'current' : '';
?>
relative f_xs_none m_xs_bottom_5">
<a href="<?php
echo Url::to(['/catalog/home/item/list', 'catalog' => $category->id]);
?>
" class="tr_delay_hover color_light tt_uppercase"><b><?php
echo $category->name;
?>
