talent_map/server/common/modules/book/models/Book.php

<?php

namespace common\modules\book\models;

use common\behaviors\CommentBehavior;
use common\helpers\Tree;
use common\models\Comment;
use common\modules\attachment\behaviors\UploadBehavior;
use Yii;
use yii\behaviors\TimestampBehavior;

/**
 * This is the model class for table "{{%book}}".
 *
 * @property integer $id
 * @property string $book_name
 * @property string $book_cover
 * @property string $book_link
 * @property integer $book_author
 * @property string $book_description
 * @property integer $view
 * @property integer $created_at
 * @property integer $updated_at
 * @property BookChapter $firstChapters
 * @property BookChapter[] $chapters
 */
class Book extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return '{{%book}}';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['book_author'], 'integer'],
            [['book_name'], 'string', 'max' => 50],
            [['book_cover', 'book_link'], 'string', 'max' => 255],
            [['book_description'], 'string', 'max' => 1000],
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'book_name' => '书名',
            'book_cover' => '书封面',
            'book_author' => '作者',
            'book_description' => '书简介',
            'book_link' => '书外链',
            'created_at' => '创建时间',
            'updated_at' => '更新时间',
        ];
    }

    public function behaviors()
    {
        return [
            TimestampBehavior::className(),
            [
                'class' => UploadBehavior::className(),
                'attribute' => 'book_cover'
            ],
            CommentBehavior::className()
        ];
    }

    public function afterDelete()
    {
        parent::afterDelete();
        foreach ($this->chapters as $chapter) {
            $chapter->delete();
        }
    }

    public function getFirstChapter()
    {
        return $this->hasOne(BookChapter::className(), ['book_id' => 'id'])->orderBy(['sort' => SORT_ASC]);
    }

    public function getChapters()
    {
        return $this->hasMany(BookChapter::className(), ['book_id' => 'id'])->orderBy(['sort' => SORT_ASC]);
    }

    public function addView()
    {
        return $this->updateCounters(['view' => 1]);
    }

    /**
     * 获取所有评论数
     */
    public function getAllCommentTotal()
    {
        $chapters = $this->chapters;
        $chapterIds = [];
        $total = 0;
        foreach ($chapters as $chapter) {
            $total += $chapter->getCommentTotal();
        }
        return $total;
    }

}