/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = MenuItem::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); // multilang $titleField = 'title_' . Yii::$app->language; $dataProvider->sort->attributes[$titleField] = ['asc' => ['title' => SORT_ASC], 'desc' => ['title' => SORT_DESC]]; $query->joinWith(['items']); $query->andFilterWhere(['like', 'title', $this->{$titleField}]); $query->andFilterWhere(['like', 'locale', Yii::$app->language]); // multilang if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'menu_type_id' => $this->menu_type_id, 'parent_id' => $this->parent_id]); $query->andFilterWhere(['like', 'url', $this->url])->andFilterWhere(['like', 'status', $this->status]); return $dataProvider; }
/** * @param null $parent_id * @param string $menuTypeName * @return array */ public function getTree($parent_id = null, $menuTypeName = 'main') { $items = []; $titleFiled = 'title_' . Yii::$app->language; $model = MenuItem::find()->where(['status' => '1', 'parent_id' => $parent_id]); // Filter by parent if (isset($menuType)) { $menuType = MenuType::findOne(['like', 'name', '%' . $menuTypeName . '%']); $model = $model->andWhere(['menu_type_id' => $menuType->id]); } $menuItems = $model->orderBy(['sort' => 'DESC'])->all(); foreach ($menuItems as $menuItem) { $url = $this->checkParams($menuItem->url); if ($menuItem->visible == 'all') { $visible = true; } elseif ($menuItem->visible == 'notuser') { $visible = Yii::$app->user->isGuest; } else { $visible = Yii::$app->user->can($menuItem->visible); } $item = ['label' => $menuItem->{$titleFiled}, 'url' => is_array($url) ? Yii::$app->urlManager->createUrl($url) : $url, 'visible' => $visible, 'linkOptions' => $menuItem->data_method == 'post' ? ['data-method' => 'post'] : []]; // Get the item's children $children = $this->getTree($menuItem->id, $menuTypeName); if ($children) { $item['items'] = $children; } $items[] = $item; } return $items; }