withoutGlobalScope and find not working

[Inkognitoo]

• Laravel Version: 5.5.19
• PHP Version: 7.1.1
• Database Driver & Version: psql

Description:

I have GlobalScope

<?php

namespace App\Scopes;

use App\Book;
use Illuminate\Database\Eloquent\Scope;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Builder;

class StatusScope implements Scope
{
    /**
     * 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('status', Book::OPEN_STATUS);
    }
}

and model

<?php

namespace App;

use App\Scopes\StatusScope;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Book extends Model
{
    use SoftDeletes;

    const OPEN_STATUS = 'open_by_author';

    const CLOSE_STATUS = 'close_by_author';

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'title', 'description',
    ];

    /**
     * The attributes that should be mutated to dates.
     *
     * @var array
     */
    protected $dates = ['deleted_at'];

    /**
     * The "booting" method of the model.
     *
     * @return void
     */
    protected static function boot()
    {
        parent::boot();

        static::addGlobalScope(new StatusScope);
    }
}

and when I make
Book::withoutGlobalScope(StatusScope::class)->find($id)
it return sql code like:
select * from "books" where "books"."deleted_at" is null and "status" = ?
and of course it does not working. But when I use where('id, $id) instead find, all okay.

[kenan-recebli]

Quite strange, because I also have a global scope (even multiple global scopes) and everything works as should:

<?php

namespace App\Concerns;

use App\Scopes\DraftingScope;
use App\Scopes\PublishingScope;
use Illuminate\Database\Eloquent\SoftDeletingScope;

trait HasGlobalScope
{
    /**
     * The "booting" method of the model.
     *
     * @return void
     */
    protected static function bootHasGlobalScope()
    {
        $scope = substr_replace(static::class, 'App\Scopes', 0, 3).'Scope';

        static::addGlobalScope(new $scope);
    }

    /**
     * Fetch the model without global scopes except it's own one.
     *
     * @param int $id
     *
     * @return null|static
     */
    public static function fetch($id)
    {
        return static::withoutGlobalScope(DraftingScope::class)
                     ->withoutGlobalScope(PublishingScope::class)
                     ->withoutGlobalScope(SoftDeletingScope::class)
                     ->find($id);
    }
}

My Laravel version is also 5.5.19

[themsaid]

I can't replicate this either, please check in a fresh laravel application and update the steps to replicate.