pp_cms/webApp/common/services/ArticleService.php

<?php
/**
 * Author: lf
 * Blog: https://blog.feehi.com
 * Email: job@feehi.com
 * Created at: 2020-01-30 14:40
 */

namespace common\services;

use Yii;
use backend\models\search\ArticleSearch;
use common\libs\Constants;
use common\models\Article;
use common\models\ArticleContent;
use common\models\Comment;
use yii\base\Exception;
use yii\helpers\ArrayHelper;
use yii\web\NotFoundHttpException;

class ArticleService extends Service implements ArticleServiceInterface
{

    public function getSearchModel(array $options = [])
    {
        return new ArticleSearch();
    }

    public function getModel($id, array $options = [])
    {
        $model = Article::findOne($id);
        if( isset($options['scenario']) && !empty($options['scenario']) ){
            if($model !== null) {
                $model->setScenario($options['scenario']);
            }
        }
        return $model;
    }

    public function newModel(array $options = [])
    {
        $type = Article::ARTICLE;
        isset($options['scenario']) && $type = $options['scenario'];
        $model = new Article(['scenario' => $type]);
        $model->loadDefaultValues();
        return $model;
    }

    public function newArticleContentModel(array $options= [])
    {
        return new ArticleContent();
    }

    public function getArticleContentDetail($id, array $options = [])
    {
        $model = ArticleContent::findOne(['aid'=>$id]);
        if( empty($model) ){
            throw new NotFoundHttpException("Id " . $id . " not exists");
        }
        return $model;
    }

    public function create(array $postData, array $options = [])
    {
        $articleModel = new Article(['scenario'=>$options['scenario']]);
        $articleContentModel = new ArticleContent();
        if( !$articleModel->load($postData) || !$articleContentModel->load($postData) ){
            return [
                'articleModel' => $articleModel,
                'articleContentModel' => $articleContentModel,
            ];
        }
        $db = Yii::$app->getDb();
        $transaction = $db->beginTransaction();
        try{
            if ( !$articleModel->save() ){
                throw new Exception("save article error");
            }

            $articleContentModel->setAttribute("aid", $articleModel->id);
            if( !$articleContentModel->save() ){
                throw new Exception("save article content error");
            }
            $transaction->commit();
        }catch (Exception $exception){
            Yii::error("create article failed:" . $exception->getFile() . "(" . $exception->getLine() . ")" . $exception->getMessage() );
            $transaction->rollBack();
            return [
                'articleModel' => $articleModel,
                'articleContentModel' => $articleContentModel,
            ];
        }
        return true;
    }

    public function update($id, array $postData, array $options = [])
    {
        /** @var Article $articleModel */
        $articleModel = $this->getDetail($id, $options);
        /** @var ArticleContent $articleContentModel */
        $articleContentModel = $this->getArticleContentDetail($id);

        if ( isset($postData[$articleModel->formName()]) && !$articleModel->load($postData) ) {
            return [
                'articleModel' => $articleModel,
                'articleContentModel' => $articleContentModel,
            ];
        }

        if( isset($postData[$articleContentModel->formName()]) && !$articleContentModel->load($postData) ){
            return [
                'articleModel' => $articleModel,
                'articleContentModel' => $articleContentModel,
            ];
        }
        $db = Yii::$app->getDb();
        $transaction = $db->beginTransaction();
        try {
            if (!$articleModel->save()) {
                throw new Exception("save article error");
            }

            if (!$articleContentModel->save()) {
                throw new Exception("save article content error");
            }
            $transaction->commit();
        } catch (Exception $exception) {
            $transaction->rollBack();
            return [
                'articleModel' => $articleModel,
                'articleContentModel' => $articleContentModel,
            ];
        }
        return true;
    }

    public function delete($id, array $options = [])
    {
        /** @var Article $articleModel */
        $articleModel = $this->getDetail($id, $options);
        /** @var ArticleContent $articleContentModel */
        $articleContentModel = $this->getArticleContentDetail($id);
        $db = Yii::$app->getDb();
        $transaction = $db->beginTransaction();
        try{
            if( $articleModel->delete() === false || $articleContentModel->delete() === false || !is_int( Comment::deleteAll(['aid'=>$id]) ) ){
                throw new \Exception("delete article failed");
            }
            $transaction->commit();
        }catch (Exception $exception){
            $transaction->rollBack();
            $articleModel->addError("id", $exception->getMessage());
            return $articleModel;
        };
        return true;
    }

    public function getFlagHeadLinesArticles($limit, $sort = SORT_DESC)
    {
        return Article::find()->limit($limit)->where(['flag_headline'=>Constants::YesNo_Yes])->limit($limit)->with('category')->orderBy(["sort"=>$sort])->all();
    }

    public function getArticleSubTitle($subTitle)
    {
        return Article::findOne(['type' => Article::SINGLE_PAGE, 'sub_title' => $subTitle]);
    }

    public function getArticleById($aid)
    {
        return Article::find()->where(['id'=>$aid, "status"=>Constants::YesNo_Yes, 'type'=>Article::ARTICLE])->one();
    }

    public function getArticlesCountByPeriod($startAt=null, $endAt=null)
    {
        $model = Article::find();
        $model->andWhere(["type"=>Article::ARTICLE]);
        if( $startAt != null && $endAt != null ){
            $model->andWhere(["between", "created_at", $startAt, $endAt]);
        }else if ($startAt != null){
            $model->andwhere([">", "created_at", $startAt]);
        } else if($endAt != null){
            $model->andWhere(["<", "created_at", $endAt]);
        }
        return $model->count('id');
    }

    public  function getFrontendURLManager()
    {
        $localConfig = [];
        if (file_exists(Yii::getAlias("@frontend/config/main-local.php"))) {
            $localConfig = require Yii::getAlias("@frontend/config/main-local.php");
        }
        $config = ArrayHelper::merge(
            require Yii::getAlias("@frontend/config/main.php"),
            $localConfig
        );

        $properties = [];
        if( isset( $config['components']['urlManager']) ){
            $properties = $config['components']['urlManager'];
        }

        $urlManager = Yii::$app->getUrlManager();
        $frontendURLManager = clone $urlManager;
        Yii::configure($frontendURLManager, $properties);
        return $frontendURLManager;
    }

    public function getSinglePages()
    {
        return  Article::find()->where(['type' => Article::SINGLE_PAGE])->all();
    }
}