razonyang / yii2-app-template

app/Http/Controller/ArticleController.php

<?php
namespace App\Http\Controller;

use App\Model\Article;
use App\Model\ArticleComment;
use App\Model\ArticleLike;
use App\Model\StatusInterface;
use yii\data\Pagination;
use yii\helpers\ArrayHelper;
use yii\helpers\HtmlPurifier;
use yii\web\NotFoundHttpException;

class ArticleController extends Controller
{
    public function afterAction($action, $result)
    {
        if ($action->id === 'view') {
            $this->model->updateCounters([
                'views' => 1
            ]);
        }

        return parent::afterAction($action, $result);
    }

    public function actionIndex()
    {
        $query = Article::find()
            ->alias('a')
            ->joinWith('category')
            ->where([
                'a.status' => StatusInterface::STATUS_ACTIVE,
                'a.is_deleted' => 0,
            ])
            ->andWhere(['<=', 'a.release_time', time()])
            ->orderBy(['a.release_time' => SORT_DESC]);

        $count = $query->count();
        $pagination = new Pagination(['totalCount' => $count]);

        $articles = $query->offset($pagination->offset)
            ->limit($pagination->limit)
            ->all();

        $likes = ArticleLike::find()
            ->select([
                'article_id',
                'count' => 'count(*)'
            ])
            ->where(['IN', 'article_id', array_column($articles, 'id')])
            ->groupBy(['article_id'])
            ->asArray()
            ->all();
        $likesCount = ArrayHelper::map($likes, 'article_id', 'count');
        
        return $this->render('index', [
            'articles' => $articles,
            'likesCount' => $likesCount,
            'pagination' => $pagination,
        ]);
    }

    public function actionView($id)
    {
        $model = $this->findModel($id);
        
        return $this->render('view', [
            'model' => $model,
            'content' => HtmlPurifier::process($model->meta->content),
        ]);
    }

    /**
     * @var Article $model
     */
    private $model;

    private function findModel($id)
    {
        $model = Article::findOne($id);
        if (!$model) {

$model is of type yii\db\ActiveRecord, thus it always evaluated to true.

            throw new NotFoundHttpException('Article does not exists');
        }

        $this->model = $model;
        return $this->model;
    }

    public function actionComments($id, $page = 1, $limit = 10)
    {
        $this->layout = false;
        $comments = ArticleComment::find()
            ->alias('c')
            ->joinWith('user')
            ->where([
                'c.article_id' => $id,
            ])
            ->orderBy(['c.create_time' => SORT_DESC])
            ->offset(($page - 1) * $limit)
            ->all();
        
        return $this->render('comments', [
            'comments' => $comments,
        ]);
    }
}