<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Article extends BaseModel
{
    protected $table = 'articles';

    protected $fillable = ['id', 'title', 'slug', 'description', 'editor', 'gu_content', 'content', 'thumbnail',
                           'preview', 'publish_at', 'important', 'view_number', 'type', 'user_id', 'is_published',
                           'is_activated', 'is_deleted', 'created_at', 'updated_at'];

    public function category() {
        return $this->hasMany(CategoryDetail::class, 'article_id', 'id')->select('id', 'article_id', 'category_id');
    }

    public function category_detail() {
        return $this->hasMany(CategoryDetail::class, 'article_id', 'id')->with('category')->select('id', 'article_id', 'category_id');
    }

    public function keyword_detail() {
        return $this->hasMany(KeywordDetail::class, 'ref_id', 'id')->with('keyword')->select('id', 'keyword_id', 'ref_id')->where('type', 'article');
    }
}