$query, ]); $this->load($params); /*if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; }*/ // grid filtering conditions $query->andFilterWhere([ 'category_id' => $this->category_id, 'parent_id' => $this->parent_id, 'category_name_id' => $this->category_name_id, 'product_unit_id' => $this->product_unit_id, ]); $query->andFilterWhere(['like', 'alias', $this->alias]); $query->orderBy(['path' => SORT_ASC, 'depth' => SORT_ASC]); return $dataProvider; } public static function findByAlias($alias) { /** @var CategoryQuery $query */ $query = Category::find(); $query->byAlias($alias); if (($model = $query->one()) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } } }