ngds/frontendApi/modules/v1/controllers/ArticleController.php

<?php
/**
 * Created by PhpStorm.
 * User: leo
 * Date: 2018/2/24
 * Time: 下午12:48
 */
namespace frontendApi\modules\v1\controllers;

use common\models\Article;
use common\models\ArticleCategory;
use common\models\User;
use Yii;

class ArticleController extends BaseController
{
    public $modelClass = Article::class;

    /**
     * 返回所有分类并带5条新闻
     * @return mixed
     * @throws \yii\web\HttpException
     */
    public function actionIndex()
    {
        $userInfo = User::getEnCodeInfo(Yii::$app->user->id);
        $news = ArticleCategory::find()->select('ID,CATE_NAME')->asArray()->all();
        foreach ($news as &$value){
            $value['LISTS']=Article::find()
                ->select('ID,TITLE,CID,CREATED_AT')
                ->where('CID=:CID AND STATUS=1 AND COUNTRY_ID=:COUNTRY_ID', [':CID'=>$value['ID'], ':COUNTRY_ID'=>$userInfo['COUNTRY_ID']])
                ->orderBy('SORT DESC, CREATED_AT DESC')
                ->limit(5)
                ->asArray()
                ->all();
        }
        return static::notice($news);
    }


    /**
     * 文章分类
     * @return mixed
     * @throws \yii\web\HttpException
     */
    public function actionCategory(){
        return static::notice(ArticleCategory::getAllCategory());
    }

    /**文章前10条列表
     * @return mixed
     * @throws \yii\web\HttpException
     */
    public function actionGetNewArticle(){
        $data = Article::find()->select('ID,TITLE,CID,CREATED_AT')->where('STATUS=1')->orderBy('CREATED_AT DESC')->limit(10)->asArray()->all();
        return static::notice($data);
    }

    /**
     * 文章列表
     * @return mixed
     * @throws \yii\web\HttpException
     */
    public function actionList()
    {
        $userInfo = User::getEnCodeInfo(\Yii::$app->user->id);

        $cid = \Yii::$app->request->get('cid');
        $condition = ' AND A.STATUS=1 AND A.COUNTRY_ID=:COUNTRY_ID';
        $params = [':COUNTRY_ID' => $userInfo['COUNTRY_ID']];
        if($cid){
            $condition .= ' AND CID=:CID';
            $params[':CID'] = $cid;
        }
        $data = Article::lists($condition, $params, [
            'select' => 'A.ID,A.TITLE,A.CID,A.CREATED_AT,C.CATE_NAME',
            'from' => Article::tableName().' AS A',
            'join' => [
                ['LEFT JOIN', ArticleCategory::tableName() . ' AS C', 'A.CID = C.ID'],
            ],
            'orderBy' => 'A.CREATED_AT DESC',
            'useSlaves' => true,
        ]);

        // 全部分类
        $data['allCategory'] = ArticleCategory::getAllCategory();
        return static::notice($data);
    }

    /**
     * 获取文章详细
     * @return mixed
     * @throws \yii\web\HttpException
     */
    public function actionDetail(){
        $id = \Yii::$app->request->get('id');
        $data = null;
        if($id){
            $data = Article::findOneAsArray('ID=:ID AND STATUS=1', [':ID'=>$id], 'ID,TITLE,CID,CREATED_AT');
        }
        if($data){
            // 暂时先从文件中取内容
            $path = \Yii::getAlias('@common/runtime/articleContent/').$data['ID'];
            if(!file_exists($path)){
                $data['CONTENT'] = '';
            } else {
                $data['CONTENT'] = file_get_contents($path);
            }
            return static::notice($data);
        } else {
            return static::notice(Yii::t('app', 'articleDoesNotExist'), 400);// 文章不存在
        }
    }
}