PHP Category::findOne方法代码示例

 public function actionEdit($id)
 {
     $categoryModel = Category::findOne(['id' => $id]);
     if ($categoryModel->load(Yii::$app->request->post()) && $categoryModel->save()) {
     }
     return $this->render('edit', ['model' => $categoryModel]);
 }

 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $this->scenario = '';
     $query = Product::find()->where(['active' => 1]);
     $this->scenario = 'default';
     $this->load($params, '');
     $order_arr = !empty($this->order_by) ? explode(':', $this->order_by) : ['id', 'desc'];
     $orderField = count($order_arr) > 0 ? $order_arr[0] : 'id';
     $orderSort = count($order_arr) > 1 && $order_arr[1] == 'desc' ? SORT_DESC : SORT_ASC;
     $this->order_by = $orderField . ':' . ($orderSort == SORT_DESC ? 'desc' : 'asc');
     /** @var Category $category */
     if (isset($params['code']) && !empty($params['code'])) {
         $this->_category = Category::find()->where(['url_code' => $params['code']])->one();
     }
     if (is_null($this->_category) && isset($params['id']) && !empty($params['id'])) {
         $this->_category = Category::findOne($params['id']);
     }
     if (!is_null($this->_category)) {
         $arr_cats = $this->_category->fillSubCategoryArray();
         $query->andFilterWhere(['in', 'category_id', $arr_cats]);
     }
     $per_page = isset($params['per-page']) ? $params['per-page'] : 12;
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => $per_page], 'sort' => ['defaultOrder' => ['new' => SORT_DESC], 'attributes' => ['new' => ['desc' => ['id' => SORT_DESC], 'asc' => false, 'default' => SORT_DESC, 'label' => Yii::t('app', 'Newest Arrivals')], 'featured' => ['asc' => false, 'desc' => ['featured' => SORT_DESC], 'default' => SORT_DESC, 'label' => Yii::t('app', 'Featured')], 'price_asc' => ['desc' => false, 'asc' => ['price_custom' => SORT_ASC], 'default' => SORT_ASC, 'label' => Yii::t('app', 'Price: Low to High')], 'price_desc' => ['asc' => false, 'desc' => ['price_custom' => SORT_DESC], 'default' => SORT_DESC, 'label' => Yii::t('app', 'Price: High to Low')]]]]);
     return $dataProvider;
 }

 /**
  * Finds the Category model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param string $alias
  * @return Category the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModelByAlias($alias)
 {
     if (($model = Category::findOne(['alias' => $alias])) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }

 /**
  * Возвращает модель категории.
  * @param int $id идентификатор категории
  * @throws NotFoundHttpException в случае, когда категория не найдена
  * @return Category
  */
 public function getCategory($id)
 {
     if (($model = Category::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested post does not exist.');
     }
 }

 /**
  * @param string $id
  * @return Category|bool
  * @throws NotFoundHttpException
  */
 protected function findModel($id)
 {
     if (($model = Category::findOne($id)) !== null) {
         return $model;
     } else {
         return false;
     }
 }

 protected function findModel($id)
 {
     if (($model = Category::findOne($id)) !== null && $model->user_id == Yii::$app->user->id) {
         return $model;
     } else {
         throw new NotFoundHttpException('The page you requested is not available or does not exist.');
     }
 }

 /**
  * Finds the Users model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return Users the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = Category::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }

 /**
  * @return \yii\db\ActiveQuery
  */
 public function getParentName()
 {
     if ($this->parent != 0) {
         $data = Category::findOne($this->parent);
         return Html::a($data->name, ['view', 'id' => $data->id]);
     } else {
         return "Главная категория";
     }
 }

 /**
  * @param $node
  * @return string
  * @throws NotFoundHttpException
  */
 public function actionList($node)
 {
     $category = Category::findOne($node);
     if (!$category) {
         throw new NotFoundHttpException();
     }
     $model = new ProductSearch();
     $dataProvider = $model->search(\Yii::$app->request->queryParams);
     return $this->render('list', ['dataProvider' => $dataProvider, 'searchModel' => $model, 'category' => $category]);
 }

 public function actionCategory($categories = null)
 {
     if ($categories) {
         $category = Category::findOne(['categories' => $categories]);
         if ($category) {
             return $this->render('category', ['model' => $category]);
         }
     } else {
         $this->goHome();
     }
 }

 static function loadCategory()
 {
     $categories = \app\models\Category::find()->asArray()->all();
     for ($i = 0; $i <= count($categories) - 1; $i++) {
         if ($categories[$i]['parent'] != 0) {
             $categories[$i]['name'] = $categories[$i]['name'] . "(" . \app\models\Category::findOne(['id' => $categories[$i]['parent']])->name . ")";
         }
     }
     $categories = ArrayHelper::map($categories, 'id', 'name');
     return $categories;
 }

 public function actionFixCategory()
 {
     $catGoogle = \app\models\CategoryGoogle::find()->all();
     foreach ($catGoogle as $cat) {
         if (isset($cat->parent_id)) {
             $mCat = \app\models\Category::findOne($cat->parent_id);
             $mGoogleCat = \app\models\CategoryGoogle::findOne(['nombre' => $mCat->nombre_categoria]);
             $cat->parent_id = $mGoogleCat->id;
             $cat->save();
         }
     }
 }

 public function init()
 {
     parent::init();
     $category = Category::findOne(83);
     $descendants = $category->children()->all();
     $menuItems = [];
     foreach ($descendants as $key => $value) {
         $menuItems[] = ['label' => $value->name, 'url' => ['post/index', 'id' => $value->id]];
     }
     $menuItems[] = ['label' => '未分类', 'url' => ['post/index', 'id' => 0]];
     echo '<h4 class="text-right">分类</h4>';
     echo Menu::widget(['options' => ['class' => 'side-menu list-unstyled'], 'items' => $menuItems, 'encodeLabels' => false]);
 }

 public function actionIndex()
 {
     $queryParams = Yii::$app->request->getQueryParams();
     $query = Post::find()->where(['status' => 1]);
     $category = "";
     if (isset($queryParams['id'])) {
         $category = Category::findOne($queryParams['id']);
         $query = $query->andWhere(['category_id' => $queryParams['id']]);
     }
     if (isset($queryParams['tag'])) {
         $query = $query->andWhere(['like', 'tags', $queryParams['tag']]);
     }
     $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['created_at' => SORT_DESC]], 'pagination' => ['pageSize' => 20]]);
     return $this->render('index', ['dataProvider' => $dataProvider, 'category' => $category]);
 }

 public function actionCategory($id)
 {
     $cur_category = Category::findOne($id);
     if ($cur_category === null) {
         throw new NotFoundHttpException();
     } elseif ($cur_category->status === Category::STATUS_INACTIVE) {
         return $this->redirect(['index']);
     }
     $categories = Category::find()->where(['status' => Category::STATUS_ACTIVE])->orderBy('caption')->all();
     $query = $cur_category->getNews()->where(['status' => News::STATUS_ACTIVE])->orderBy('date DESC');
     $count = $query->count();
     $pagination = new Pagination(['totalCount' => $count, 'defaultPageSize' => NewsController::DEFAULT_PAGE_SIZE]);
     $news = $query->offset($pagination->offset)->orderBy('date')->limit($pagination->limit)->all();
     return $this->render('index', ['categories' => $categories, 'news' => $news, 'pagination' => $pagination, 'cur_category' => $cur_category]);
 }