Active Global Scope Query Laravel

gistfile1.txt

<?php namespace App;

use Illuminate\Database\Eloquent\ScopeInterface;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;

class ActiveScope implements ScopeInterface
{
    /**
     * Apply the scope to a given Eloquent query builder.
     *
     * @param  \Illuminate\Database\Eloquent\Builder  $builder
     * @param  \Illuminate\Database\Eloquent\Model  $model
     * @return void
     */
    public function apply(Builder $builder, Model $model)
    {
        $builder->where('active', '=', 1);
    }

    /**
     * Remove the scope from the given Eloquent query builder.
     *
     * @param  \Illuminate\Database\Eloquent\Builder  $builder
     * @param  \Illuminate\Database\Eloquent\Model  $model
     * @return void
     */
    public function remove(Builder $builder, Model $model)
    {
        $query = $builder->getQuery();
        $bindings = $query->getRawBindings()['where'];
        $bindingKey = 0;

        foreach ((array)$query->wheres as $key => $where) {
            if ($where['type'] === 'Basic' && $where['column'] === 'active' && $where['value'] === 1) {
                unset($query->wheres[$key]); //remove wheres
                unset($bindings[$bindingKey]); //remove where bindings
            }
            if ( ! in_array($where['type'], ['Null', 'NotNull'])) {
                $bindingKey++;
            }
        }

        $query->wheres = array_values($query->wheres); //reset wheres
        $query->setBindings($bindings); //reset where bindings
    }
}