app/Traits/HasWhereNotTrait.php

HasWhereNotTrait.php

<?php

namespace App\Traits;

use Closure;
use Illuminate\Database\Eloquent\Builder;

trait HasWhereNotTrait
{
    /**
     * @param Builder $query
     * @param string|Closure $column
     * @param mixed $value
     */
    public function scopeWhereNot($query, $column, $value = null)
    {
        $query->where($column, $value, null, 'and not');
    }

    /**
     * @param Builder $query
     * @param string|Closure $column
     * @param mixed $value
     */
    public function scopeOrWhereNot($query, $column, $value = null)
    {
        $query->where($column, $value, null, 'or not');
    }
}