PHP News::find方法代码示例

 /**
  * Displays homepage.
  *
  * @return mixed
  */
 public function actionIndex()
 {
     $query = News::find();
     $pagination = new Pagination(['defaultPageSize' => 4, 'totalCount' => $query->count()]);
     $news = $query->orderBy(['id' => SORT_DESC])->offset($pagination->offset)->limit($pagination->limit)->all();
     return $this->render('index', ['news' => $news, 'pagination' => $pagination]);
 }

 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params, $cat)
 {
     if (Yii::$app->user->isGuest) {
         $isAdmin = false;
     } else {
         if (Yii::$app->user->identity->role == 1) {
             $isAdmin = true;
         } else {
             $isAdmin = false;
         }
     }
     if ($isAdmin) {
         $query = News::find();
     } else {
         $query = News::find()->where(['cat' => $cat]);
     }
     $dataProvider = new ActiveDataProvider(['query' => $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;
     }
     $query->andFilterWhere(['news_id' => $this->news_id, 'create_time' => $this->create_time, 'update_time' => $this->update_time, 'cat' => $this->cat, 'clickcnt' => $this->clickcnt]);
     $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'content', $this->content]);
     return $dataProvider;
 }

 public function actionArticle()
 {
     $id = $_GET['id'];
     $article = News::find()->where(["id" => $id])->one();
     // echo $id;
     return $this->render('article', ['article' => $article]);
 }

 public function actionIndex()
 {
     //Записываем в переменную все новости из базы через модель
     $model = News::find()->all();
     //Передаем переменную представлению
     return $this->render('index', ['news' => $model]);
 }

 public function actionIndex()
 {
     $news = News::find()->orderBy('createTime desc')->limit(3)->all();
     //  var_dump($news);
     //echo $news[0]->title;
     return $this->render('index', ['news' => $news]);
 }

 public function run()
 {
     // query
     $news = News::find()->orderBy('date_news DESC')->limit(5)->all();
     // render view
     return $this->render('news', ['news' => $news]);
 }

 public function actionIndex($kinds = 'all')
 {
     $sort = new Sort(['attributes' => ['theme' => ['asc' => ['theme' => SORT_ASC], 'desc' => ['theme' => SORT_DESC], 'default' => SORT_ASC, 'label' => '主题'], 'author' => ['asc' => ['author' => SORT_ASC], 'desc' => ['author' => SORT_DESC], 'default' => SORT_DESC, 'label' => '作者'], 'reply' => ['asc' => ['reply' => SORT_ASC], 'desc' => ['reply' => SORT_DESC], 'default' => SORT_DESC, 'label' => '回复'], 'updated_at' => ['asc' => ['updated_at' => SORT_ASC], 'desc' => ['updated_at' => SORT_DESC], 'default' => SORT_DESC, 'label' => '最后更新'], 'plike' => ['asc' => ['plike' => SORT_ASC], 'desc' => ['plike' => SORT_DESC], 'default' => SORT_DESC, 'label' => '赞'], 'kinds' => ['asc' => ['kinds' => SORT_ASC], 'desc' => ['kinds' => SORT_DESC], 'default' => SORT_ASC, 'label' => '类别']], 'defaultOrder' => ['updated_at' => SORT_DESC]]);
     if ($kinds === 'all') {
         $query = Forum::find();
     } elseif ($kinds === 'tucao') {
         $query = Forum::find()->where(array('kinds' => 'tucao'));
     } elseif ($kinds === 'tactic') {
         $query = Forum::find()->where(array('kinds' => 'tactic'));
     } elseif ($kinds === 'rule') {
         $query = Forum::find()->where(array('kinds' => 'rule'));
     } elseif ($kinds === 'bug') {
         $query = Forum::find()->where(array('kinds' => 'bug'));
     } elseif ($kinds === 'team') {
         $query = Forum::find()->where(array('kinds' => 'team'));
     } elseif ($kinds === 'myposts') {
         //我发的帖子
         $query = Forum::find()->where(array('author' => Yii::$app->user->identity->username));
     } elseif ($kinds === 'myreplies') {
         //我回复的帖子
         $queryid = DetailForum::find()->select(['fatherindex'])->where(array('author' => Yii::$app->user->identity->username));
         $query = Forum::find()->where(array('id' => $queryid));
     } else {
         $query = Forum::find();
     }
     $pagination = new Pagination(['defaultPageSize' => 10, 'totalCount' => $query->count()]);
     $forums = $query->orderBy($sort->orders)->offset($pagination->offset)->limit($pagination->limit)->all();
     //用来置顶2个点赞量最高的
     $sort1 = new Sort(['attributes' => ['plike' => ['asc' => ['plike' => SORT_ASC], 'desc' => ['plike' => SORT_DESC], 'default' => SORT_DESC, 'label' => '赞']], 'defaultOrder' => ['plike' => SORT_DESC]]);
     $topquery = Forum::find()->orderBy($sort1->orders)->limit(2)->all();
     //用来置顶2个点赞量最高的
     $news = News::find()->orderBy('addedat')->all();
     return $this->render('index', ['new' => $news[0], 'forums' => $forums, 'pagination' => $pagination, 'sort' => $sort, 'topquery' => $topquery]);
 }

 public function actionGet_data()
 {
     //      var_dump($_POST);
     $count = News::find()->count();
     $connection = Yii::$app->db;
     $sql = "select * from news ";
     $condition = '';
     if ($_POST['searchPhrase'] != '') {
         $condition .= 'where title like ' . '"%' . $_POST['searchPhrase'] . '%" ';
     }
     if (isset($_POST['sort']['title'])) {
         $condition .= " order by title  {$_POST['sort']['title']} ";
     }
     $t = (intval($_POST['current']) - 1) * $_POST['rowCount'];
     $condition .= " limit {$t} , {$_POST["rowCount"]}";
     $sql .= $condition;
     # $criteria->limit = $_POST['rowCount'];
     # $criteria->offset= (intval($_POST['current']) -1)*$_POST['rowCount'];
     //  echo $sql;
     #$model = News::find()->all($criteria);
     //      var_dump($model);
     $model = $connection->createCommand($sql)->queryAll();
     $arr = array();
     foreach ($model as $o) {
         $json = array('id' => intval($o['id']), 'title' => $o['title']);
         array_push($arr, $json);
     }
     //var_dump( $arr);
     echo json_encode(array('rowCount' => $_POST['rowCount'], 'current' => $_POST['current'], 'rows' => $arr, 'total' => $count));
 }

 public function run()
 {
     $query = News::find()->orderBy(['created_at' => SORT_DESC]);
     $countQuery = clone $query;
     $pages = new Pagination(['totalCount' => $countQuery->count()]);
     $models = $query->offset($pages->offset)->limit($pages->limit)->all();
     return $this->render('news', ['models' => $models, 'pages' => $pages]);
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function show($id)
 {
     $news = News::find($id);
     if ($news->status_id != 3) {
         return redirect('/');
     }
     return view('front.news.show', compact('news'));
 }

 public function actionIndex()
 {
     $season = Season::findBySql('SELECT * FROM season WHERE invisible = 0 AND (unit1 != "" OR unit2 != "" OR unit3 != "" OR unit4 != "")')->all();
     $news = News::find()->where(['type' => '1'])->orderBy('id DESC')->one();
     $event = News::find()->where(['type' => '2'])->orderBy('id DESC')->one();
     $msgs = Chatmain::find()->orderBy('id DESC')->limit(50)->all();
     return $this->render('index', ['season' => $season, 'news' => $news, 'event' => $event, 'msgs' => $msgs]);
 }

 public function actionNews($news_id)
 {
     $news = News::find()->where(['id' => $news_id, 'is_published' => 1])->asArray()->one();
     if ($news) {
         $news['categories'] = CategoryRelations::get_news_categories_names($news['id']);
         return $this->render('news', compact('news'));
     }
 }

 public function actionPage($view)
 {
     $page = Pages::findOne(['slug' => '/' . $view]);
     if ($page == null) {
         return $this->render('error');
     }
     $news = new ActiveDataProvider(['query' => News::find(), 'sort' => ['defaultOrder' => ['data_new' => SORT_DESC]], 'pagination' => ['pageSize' => 3, 'validatePage' => false]]);
     return $this->render('index', ['page' => $page, 'news' => $news]);
 }

 public static function getLatestNews()
 {
     $query = News::find()->orderBy('id desc');
     $countQuery = clone $query;
     $pages = new Pagination(['totalCount' => $countQuery->count()]);
     $pages->defaultPageSize = 12;
     $models = $query->offset($pages->offset)->limit($pages->limit)->all();
     return ['models' => $models, 'pages' => $pages];
 }

 public function actionAdmin($status = null)
 {
     $query = News::find()->orderBy('id DESC');
     if ($status !== null) {
         $query->andWhere(['status' => $status]);
     }
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]);
     return $this->render('admin', ['status' => $status, 'dataProvider' => $dataProvider]);
 }