Tacone\Bees\Demo\Models\Article

Complexity

Total Complexity

7

Size/Duplication

Total Lines	47
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes	1
Bugs	0	Features	0

<?php
class Article extends \Eloquent
{
    protected $table = 'demo_articles';

    public function author()
    {
        return $this->belongsTo('\Tacone\Bees\Demo\Models\Author', 'author_id');
    }

    public function comments()
    {
        return $this->hasMany('\Tacone\Bees\Demo\Models\Comment', 'article_id');
    }

    public function categories()
    {
        return $this->belongsToMany('\Tacone\Bees\Demo\Models\Category', 'demo_article_category', 'article_id', 'category_id');
    }

    public function detail()
    {
        return $this->hasOne('\Tacone\Bees\Demo\Models\ArticleDetail', 'article_id');
    }

    public function scopeFreesearch($query, $value)
    {
        return $query->where('title', 'like', '%'.$value.'%')
            ->orWhere('body', 'like', '%'.$value.'%')
            ->orWhereHas('author', function ($q) use ($value) {
                $q->whereRaw(" CONCAT(firstname, ' ', lastname) like ?", array("%".$value."%"));
            })->orWhereHas('categories', function ($q) use ($value) {
                $q->where('name', 'like', '%'.$value.'%');
            });
    }

    protected static function boot()
    {
        parent::boot();

        static::deleting(function ($article) {
            $article->detail()->delete();
            if ($article->photo) {
                @unlink(public_path().'/uploads/demo/'.$article->photo);
            }
        });
    }
}