<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class FilterWord extends Model
{
    protected $table = 'filter_words';

    protected $fillable = ['id', 'word', 'content', 'type', 'is_activated', 'is_deleted', 'created_at', 'updated_at'];

    public function scopeIsDeleted($query)
    {
        return $query->where('is_deleted', true);
    }

    public function scopeNotDeleted($query)
    {
        return $query->where('is_deleted', false);
    }

    public function scopeIsActivated($query)
    {
        return $query->where('is_activated', true);
    }

    public function scopeNotActivated($query)
    {
        return $query->where('is_activated', false);
    }

    public function scopeIsPublished($query)
    {
        return $query->where('is_deleted', false)->where('is_activated', true);
    }
}