PHP Post::tableName方法代码示例

 /**
  * @return string
  */
 public function actionIndex()
 {
     /* @var $postType PostType */
     /* @var $post Post */
     /* @var $taxonomies Taxonomy[] */
     /* @var $taxonomy Taxonomy */
     /* @var $lastMedia Media */
     $response = Yii::$app->response;
     $response->headers->set('Content-Type', 'text/xml; charset=UTF-8');
     $response->format = $response::FORMAT_RAW;
     $postTypes = PostType::find()->select(['id', 'post_type_slug'])->all();
     $taxonomies = Taxonomy::find()->select(['id', 'taxonomy_slug'])->all();
     $items = [];
     foreach ($postTypes as $postType) {
         if (!isset($this->_option['post_type'][$postType->id]['enable']) || !$this->_option['post_type'][$postType->id]['enable']) {
             continue;
         }
         if ($post = $postType->getPosts()->andWhere(['post_status' => 'publish'])->orderBy(['id' => SORT_DESC])->one()) {
             $lastmod = new \DateTime($post->post_modified, new \DateTimeZone(Option::get('time_zone')));
             $query = $postType->getPosts()->andWhere(['post_status' => 'publish']);
             $countQuery = clone $query;
             $pages = new Pagination(['totalCount' => $countQuery->count(), 'pageSize' => $this->_option['entries_per_page']]);
             for ($i = 1; $i <= $pages->pageCount; $i++) {
                 $items[] = ['loc' => Yii::$app->urlManager->hostInfo . Url::to(['view', 'type' => 'p', 'slug' => $postType->post_type_slug, 'page' => $i]), 'lastmod' => $lastmod->format('r')];
             }
         }
     }
     foreach ($taxonomies as $taxonomy) {
         if (!isset($this->_option['taxonomy'][$taxonomy->id]['enable']) || !$this->_option['taxonomy'][$taxonomy->id]['enable']) {
             continue;
         }
         if ($terms = $taxonomy->terms) {
             $post = Post::find()->from(['post' => Post::tableName()])->innerJoinWith(['terms' => function ($query) {
                 /* @var $query \yii\db\ActiveQuery */
                 $query->from(['term' => Term::tableName()]);
             }])->where(['IN', 'term.id', ArrayHelper::getColumn($terms, 'id')])->andWhere(['post.post_status' => 'publish'])->orderBy(['post.id' => SORT_DESC])->one();
             if ($post) {
                 $query = $taxonomy->getTerms();
                 $lastmod = new \DateTime($post->post_modified, new \DateTimeZone(Option::get('time_zone')));
                 $countQuery = clone $query;
                 $pages = new Pagination(['totalCount' => $countQuery->count(), 'pageSize' => $this->_option['entries_per_page']]);
                 for ($i = 1; $i <= $pages->pageCount; $i++) {
                     $items[] = ['loc' => Yii::$app->urlManager->hostInfo . Url::to(['view', 'type' => 'c', 'slug' => $taxonomy->taxonomy_slug, 'page' => $i]), 'lastmod' => $lastmod->format('r')];
                 }
             }
         }
     }
     if (isset($this->_option['media']['enable']) && $this->_option['media']['enable']) {
         $query = Media::find();
         $countQuery = clone $query;
         $pages = new Pagination(['totalCount' => $countQuery->count(), 'pageSize' => $this->_option['entries_per_page']]);
         if ($lastMedia = $query->orderBy(['id' => SORT_DESC])->one()) {
             $lastmod = new \DateTime($lastMedia->media_modified, new \DateTimeZone(Option::get('time_zone')));
             for ($i = 1; $i <= $pages->pageCount; $i++) {
                 $items[] = ['loc' => Yii::$app->urlManager->hostInfo . Url::to(['view', 'type' => 'm', 'slug' => 'media', 'page' => $i]), 'lastmod' => $lastmod->format('r')];
             }
         }
     }
     return $this->renderPartial('index', ['items' => $items]);
 }

 /**
  * Render home page of the site.
  *
  * @throws \yii\web\NotFoundHttpException
  * @return string
  */
 public function actionIndex()
 {
     /* @var $post \common\models\Post */
     $query = Post::find()->from(['t' => Post::tableName()])->andWhere(['post_status' => 'publish'])->orderBy(['t.id' => SORT_DESC]);
     if (Option::get('show_on_front') == 'page' && ($frontPage = Option::get('front_page'))) {
         $render = '/post/view';
         $comment = new PostComment();
         $query = $query->andWhere(['id' => $frontPage]);
         if ($post = $query->one()) {
             if (is_file($this->view->theme->basePath . '/post/view-' . $post->postType->post_type_slug . '.php')) {
                 $render = '/post/view-' . $post->postType->post_type_slug;
             }
             return $this->render($render, ['post' => $post, 'comment' => $comment]);
         }
         throw new NotFoundHttpException(Yii::t('writesdown', 'The requested page does not exist.'));
     } else {
         if (Option::get('front_post_type') !== 'all') {
             $query->innerJoinWith(['postType'])->andWhere(['post_type_name' => Option::get('front_post_type')]);
         }
         $countQuery = clone $query;
         $pages = new Pagination(['totalCount' => $countQuery->count(), 'pageSize' => Option::get('posts_per_page')]);
         $query->offset($pages->offset)->limit($pages->limit);
         if ($posts = $query->all()) {
             return $this->render('index', ['posts' => $posts, 'pages' => isset($pages) ? $pages : null]);
         }
         throw new NotFoundHttpException(Yii::t('writesdown', 'The requested page does not exist.'));
     }
 }

 public function actionIndex()
 {
     $searchModel = new TweetSearch();
     $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
     $dataProvider->query->andWhere([Post::tableName() . '.type' => Tweet::TYPE, 'status' => [Post::STATUS_ACTIVE, Post::STATUS_EXCELLENT]]);
     $model = new Tweet();
     return $this->render('index', ['model' => $model, 'searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
 }

 /**
  * @param $params
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Post::find()->joinWith(['category', 'user']);
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 20], 'sort' => ['defaultOrder' => ['order' => SORT_ASC, 'updated_at' => SORT_DESC]]]);
     $dataProvider->sort->attributes['category_name'] = ['asc' => ['name' => SORT_ASC], 'desc' => ['name' => SORT_DESC]];
     $dataProvider->sort->attributes['username'] = ['asc' => ['username' => SORT_ASC], 'desc' => ['username' => SORT_DESC]];
     if (!($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id, 'post_meta_id' => $this->post_meta_id, 'user_id' => $this->user_id, 'view_count' => $this->view_count, 'comment_count' => $this->comment_count, 'favorite_count' => $this->favorite_count, 'like_count' => $this->like_count, 'thanks_count' => $this->thanks_count, 'hate_count' => $this->hate_count, Post::tableName() . '.status' => $this->status, 'order' => $this->order, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]);
     $query->andFilterWhere(['like', Post::tableName() . '.type', $this->type])->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'author', $this->author])->andFilterWhere(['like', 'excerpt', $this->excerpt])->andFilterWhere(['like', 'image', $this->image])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'tags', $this->tags])->andFilterWhere(['like', 'name', $this->category_name])->andFilterWhere(['like', 'username', $this->username]);
     return $dataProvider;
 }

 /**
  * 话题列表
  * @return mixed
  */
 public function actionIndex()
 {
     $searchModel = new PostSearch();
     // 话题或者分类筛选
     $params = Yii::$app->request->queryParams;
     empty($params['tag']) ?: ($params['PostSearch']['tags'] = $params['tag']);
     if (isset($params['node'])) {
         $postMeta = PostMeta::findOne(['alias' => $params['node']]);
         $postMeta ? $params['PostSearch']['post_meta_id'] = $postMeta->id : '';
     }
     $dataProvider = $searchModel->search($params);
     $dataProvider->query->andWhere([Post::tableName() . '.type' => 'topic', 'status' => [Post::STATUS_ACTIVE, Post::STATUS_EXCELLENT]]);
     // 排序
     $sort = $dataProvider->getSort();
     $sort->attributes = array_merge($sort->attributes, ['hotest' => ['asc' => ['comment_count' => SORT_DESC, 'created_at' => SORT_DESC]], 'excellent' => ['asc' => ['status' => SORT_DESC, 'comment_count' => SORT_DESC, 'created_at' => SORT_DESC]], 'uncommented' => ['asc' => ['comment_count' => SORT_ASC, 'created_at' => SORT_DESC]]]);
     return $this->render('index', ['searchModel' => $searchModel, 'sorts' => $this->sorts, 'dataProvider' => $dataProvider]);
 }

 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Post::find();
     // add conditions that should always apply here
     $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]);
     $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
     $post = Post::tableName();
     $user = User::tableName();
     $query->andFilterWhere([$post . '.id' => $this->id, $post . '.status' => $this->status, 'create_time' => $this->create_time, 'update_time' => $this->update_time, 'author_id' => $this->author_id]);
     $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'tags', $this->tags]);
     $query->join('INNER JOIN', $user, $post . '.author_id = User.id');
     $query->andFilterWhere(['like', $user . '.username', $this->username]);
     return $dataProvider;
 }

 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = SelectedBlog::find();
     $selectedBlogTable = SelectedBlog::tableName();
     $blogTable = Post::tableName();
     $query->joinWith(['post' => function ($query) use($blogTable) {
         $query->from(['post' => $blogTable]);
     }]);
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]);
     // enable sorting for the related columns
     $addSortAttributes = ["post.title"];
     foreach ($addSortAttributes as $addSortAttribute) {
         $dataProvider->sort->attributes[$addSortAttribute] = ['asc' => [$addSortAttribute => SORT_ASC], 'desc' => [$addSortAttribute => SORT_DESC]];
     }
     if (!($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id, 'post_id' => $this->post_id]);
     $query->andFilterWhere(['like', 'post.title', $this->getAttribute('post.title')]);
     return $dataProvider;
 }

 public static function findRoots()
 {
     /** @var Section[] $sections */
     $sections = static::find()->with(['children' => function ($q) {
         $q->indexBy('id');
     }])->where(['section_id' => null])->orderBy('title')->all();
     $ids = [];
     foreach ($sections as $section) {
         $ids = array_merge($ids, array_keys($section->children));
     }
     $query = new Query();
     $counts = $query->select('COUNT(id)')->from(Post::tableName())->where(['section_id' => $ids])->groupBy('section_id')->indexBy('section_id')->column(static::getDb());
     foreach ($sections as $section) {
         $section->postCount = 0;
         foreach ($section->children as $id => $child) {
             $child->postCount = isset($counts[$id]) ? $counts[$id] : 0;
             $section->postCount += $child->postCount;
         }
     }
     return $sections;
 }

 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $user = Yii::$app->getModule("user")->model("User");
     $query = Post::find();
     $postTable = Post::tableName();
     // set up query with relation to `user.username`
     $userTable = $user::tableName();
     $query->joinWith(['user' => function ($query) use($userTable) {
         $query->from(['user' => $userTable]);
     }]);
     $tagTable = Tag::tableName();
     $taggingTable = Tagging::tableName();
     $query->leftJoin($taggingTable, "{$taggingTable}.taggable_id = {$postTable}.id AND {$taggingTable}.taggable_type = '" . Tagging::TAGGABLE_POST . "'");
     $query->leftJoin($tagTable, "{$tagTable}.id = {$taggingTable}.tag_id");
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10], 'sort' => ['defaultOrder' => ['created_at' => SORT_DESC]]]);
     // enable sorting for the related columns
     $addSortAttributes = ["user.username"];
     foreach ($addSortAttributes as $addSortAttribute) {
         $dataProvider->sort->attributes[$addSortAttribute] = ['asc' => [$addSortAttribute => SORT_ASC], 'desc' => [$addSortAttribute => SORT_DESC]];
     }
     if (!($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     $query->andFilterWhere(["{$postTable}.id" => $this->id, 'user_id' => $this->user_id, 'is_public' => $this->is_public, 'is_index' => $this->is_index, 'is_top' => $this->is_top, 'is_pin' => $this->is_pin, 'with_video' => $this->with_video, 'with_photo' => $this->with_photo, 'content_category_id' => $this->content_category_id, 'is_yandex_rss' => $this->is_yandex_rss, 'allow_comment' => $this->allow_comment]);
     $createdTime = strtotime($this->created_at);
     $startDay = date("Y-m-d 00:00:00", $createdTime);
     $endDay = date("Y-m-d 00:00:00", $createdTime + 60 * 60 * 24);
     if ($this->created_at) {
         $query->andFilterWhere(['between', 'created_at', $startDay, $endDay]);
     }
     $updatedTime = strtotime($this->updated_at);
     $startDay = date("Y-m-d 00:00:00", $updatedTime);
     $endDay = date("Y-m-d 00:00:00", $updatedTime + 60 * 60 * 24);
     if ($this->updated_at) {
         $query->andFilterWhere(['between', 'updated_at', $startDay, $endDay]);
     }
     $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'source_title', $this->source_title])->andFilterWhere(['like', 'source_url', $this->source_url])->andFilterWhere(['like', 'cached_tag_list', $this->cached_tag_list])->andFilterWhere(['like', 'user.username', $this->getAttribute('user.username')])->andFilterWhere(['like', "{$tagTable}.name", $this->getAttribute('tag.name')]);
     return $dataProvider;
 }

 /**
  * Display list of blogs in json format
  *
  * @param string $query Query for search
  * @return mixed Json data
  */
 public function actionBlogList($query = null)
 {
     if ($query == null) {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
     $search = urldecode($query);
     $query = new Query();
     $query->select('id as value, title as text')->from(Post::tableName())->where(['like', 'title', $search])->andWhere(['=', 'content_category_id', Post::CATEGORY_BLOG])->limit(10);
     $command = $query->createCommand();
     $data = $command->queryAll();
     $out = array_values($data);
     echo Json::encode($out);
 }

 /**
  * Get block with video reviews
  * @return array Data
  */
 public static function getVideoNews()
 {
     $postTable = Post::tableName();
     $assetTable = Asset::tableName();
     // Video review
     $videoReviewNews = VideoPost::find()->where(['is_public' => 1])->orderBy(['created_at' => SORT_DESC])->limit(3)->all();
     if (count($videoReviewNews) == 0) {
         return false;
     }
     $block = ['view' => '@frontend/views/blocks/review_news_block', 'data' => compact('videoReviewNews')];
     return $block;
 }

 /**
  * Url: /match/{$id}/report
  * @param $id
  * @return mixed
  * @throws NotFoundHttpException
  */
 public function actionMatchReport($id)
 {
     $match = Match::findOne($id);
     if (!isset($match)) {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
     $postTable = Post::tableName();
     $relationTable = Relation::tableName();
     $post = Post::find()->innerJoin($relationTable, "{$postTable}.id = {$relationTable}.relationable_id")->where(['is_public' => 1, "{$relationTable}.relation_type_id" => Relation::RELATION_REPORT, "{$relationTable}.relationable_type" => Relation::RELATIONABLE_POST, "{$relationTable}.parent_id" => $match->id])->one();
     $options = ['templateType' => 'col2', 'title' => 'Dynamomania.com | Отчет по матчу: ' . $match->name, 'columnFirst' => ['menu' => ['view' => '@frontend/views/translation/menu', 'data' => compact('match')]], 'columnSecond' => ['short_news' => SiteBlock::getshortNews(50)]];
     if (isset($post)) {
         $image = $post->getAsset(Asset::THUMBNAIL_CONTENT);
         $options['columnFirst']['post'] = ['view' => '@frontend/views/site/post', 'data' => compact('post', 'image'), 'weight' => 3];
         if ($post->allow_comment) {
             $options['columnFirst']['comments'] = Comment::getCommentsBlock($post->id, Comment::COMMENTABLE_POST);
             $options['columnFirst']['comments']['weight'] = 5;
         }
     } else {
         $options['columnFirst']['post'] = ['view' => '@frontend/views/site/empty', 'data' => [], 'weight' => 3];
     }
     usort($options['columnFirst'], 'self::cmp');
     return $this->render('@frontend/views/site/index', $options);
 }