is any way use default filter when the resource open

[loveyuxiao]

the model has Year filed ,i use filter to display

class demo extends Filter
{
    public function apply(Request $request, $query, $value)
    {
        return $query->where('Year',$value);
    }
    public function options(Request $request)
    {
        return [
            '2018',
            '2017',
            '2016',
            '2015',  
        ];
    }
}

Has any way use the default filter just like 2018 when the resource list?

[dkulyk]

Add a global scope with where(year, date('Y')) in the indexQuery. And remove it in the filter.
This way added condition with the current year by default.

[loveyuxiao]

@dkulyk
i set global scope in resource indexQuery.

    public static function indexQuery(NovaRequest $request, $query)
    {
        return $query->where('Year',\date('Y'));
    }

and use the filter

class demo extends Filter
{
    public function apply(Request $request, $query, $value)
    {
        return $query->where('Year',$value);
    }
    public function options(Request $request)
    {
        return [
            '2017',
        ];
    }
}

i think the $query is $query->where('Year','2018')->where('Year','2017')....

how can i set the default Year and user can change it by filter?
just like this?

    public static function indexQuery(NovaRequest $request, $query)
    {
       // check  $request->fitler ==( class demo extends Filter)???
        if ($request->fitler==demo filter)
        {
            return $query->where('Year',\date('Y'));
        else
       {
            return $query;
        }
    }

Now how can i get the $request->filter name and params.........

[dkulyk]

This is example of global scope of a query. You need to implement Illuminate\Database\Eloquent\Scope for using it.

In the resource:

public static function indexQuery(NovaRequest $request, $query)
{
    $query->withGlobalScope(DefaultYearScope::class, new DefaultYearScope());
}

And in the filter:

public function apply(Request $request, $query, $value)
{
    return $query->withoutGlobalScope(DefaultYearScope::class)->where(...);
}

[aurawindsurfing]

HI @dkulyk and thx a lot for your suggestion! I have a problem implementing it however. I seem to be unable to use:

public function apply(Request $request, $query, $value)
    {
        return $query->withoutGlobalScope(UpcomingOnlyScope::class);
    }

in my filter. It works on the index, and it is applied correctly but for some reason disabling it does not work.

Any ideas what could be the cause for that?

[aurawindsurfing]

There is no:

public static function indexQuery(NovaRequest $request, $query)
{
    $query->withGlobalScope(DefaultYearScope::class, new DefaultYearScope());
}

There should addGlobalScope on the boot method of the model.

Then it works. Not sure why ->withGlobalScope does not work in this particular scenario.

[davidhemphill]

In your filter, specify the defaults by using the default method.

[aurawindsurfing]

Hi @davidhemphill by now you mean in the latest release right?

[aurawindsurfing]

Ok I changed the way I update to private repo.

Can you tell me how to implement it please? It does not seem to work for me, my filter looks like this:

 public function apply(Request $request, $query, $value)
    {
        return $query->where('date', '>=', $value);
    }

    /**
     * Set the default options for the filter.
     *
     * @return array
     */
    public function default()
    {
        return [
            'Upcoming'
        ];
    }

    /**
     * Get the filter's available options.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return array
     */
    public function options(Request $request)
    {
        return [
            'Upcoming' => now()->format('Y-m-d h:m:s'),
            'All' => date('1900-01-01 00:00:00'),
        ];
    }

[davidhemphill]

the value on the right side is the key when it comes to filters:

return [
    'Admin' => 'admin', // <-- this is the key
    'User' => 'user', // <-- this is the key
]

And so you would specify admin as the default.

[aurawindsurfing]

Hi @davidhemphill !

Thank you for your suggestion. It works but not as expected. It seems like it will work well on a table with a small number of fields. If I get it down to 3 then on every refresh default filter kicks in. I, however, I increase the number of fields in the table it seems like the default filter query gets overwritten my the letter index query.

When I looked at my network tab I could see all the queries being executed. Please see attached where I have default filter set up and it only kicks in sometimes depending on how long the query takes to execute.

This is the only way I could figure this out. It seems like index query is being executed after filter query even though it should not be the case.

It seems like disabling just two of the BelongsTo:: does the trick but it still does not guarantee 100% correct behaviour.

BelongsTo::make('Venue')->sortable()->searchable()->rules('required'),
BelongsTo::make('Tutor')->sortable()->searchable()->rules('required'),

[ndberg]

Just for future readers, a global scope is not necessary anymore, this is now (v2.?) possible with adding a default to a filter:

    /**
     * Apply default on resource open 
     *
     * @return array|int|mixed
     */
    public function default()
    {
        return 3;
    }

[ahmadrio]

There is no:

public static function indexQuery(NovaRequest $request, $query)
{
    $query->withGlobalScope(DefaultYearScope::class, new DefaultYearScope());
}

There should addGlobalScope on the boot method of the model.

Then it works. Not sure why ->withGlobalScope does not work in this particular scenario.

thanks it works