Laravel Filters

Filters

A Laravel package for saving and reusing query based filtering.

Installation

Via Composer

$ composer require dcblogdev/laravel-filters

In Laravel 5.5 the service provider will automatically get registered. In older versions of the framework just add the service provider in config/app.php file:

'providers' => [
    // ...
    Dcblogdev\Filters\FiltersServiceProvider::class,
];

You can publish the migration with:

php artisan vendor:publish --provider="Dcblogdev\Filters\FiltersServiceProvider" --tag="migrations"

After the migration has been published migrate it:

php artisan migrate

You can publish the config file with:

php artisan vendor:publish --provider="Dcblogdev\Filters\FiltersServiceProvider" --tag="config"

When published, the config/filters.php config file contains:

<?php

return [

    
];

Model

Access filter model, to access the model reference this ORM model

use Dcblogdev\Filters\Models\Filter;

Usage

Note this package expects a user to be logged in.

A routes example:

Route::group(['middleware' => ['web', 'auth']], function(){
    Route::get('demo', function(){
        $filters = Filters::get();

        return view('demo');
    });
});

the get accepts 2 optional params:

1. The name of the module/section ie users
2. The relative url to redirect to ie /admin/users

In demo.blade.php view:

Save a filter:

<form method="get">
    <div class="control-group">
        <label for='savedfilter'>Use a saved filter:</label>
        <select name='savedfilter' id="savedfilter" class='form-control' onchange="this.form.submit()">
        <option value=''>Select</option>
        @if ($filters)
            @foreach($filters as $filter)
                <option value='{{ $filter->id }}'>{{ $filter->title }}</option>
            @endforeach
        @endif
        </select>
    </div>
</form>

Remove a filter

<form method="get">
    <div class="control-group">
        <label for='removefilter'>Remove a saved filter:</label>
        <select name='removefilter' id="removefilter" class='form-control' onchange="this.form.submit()">
        <option value=''>Select</option>
        @if ($filters)
            @foreach($filters as $filter)
                <option value='{{ $filter->id }}'>{{ $filter->title }}</option>
            @endforeach
        @endif
        </select>
    </div>
</form>

Store a new filter

<form method="get">
    <div class="control-group">
        <label for='filterTitle'>Save filter:</label>
        <input class='form-control' id='filterTitle' type="text" name="filterTitle" value="" />
    </div>

    <div class="control-group">
        <br><button type="submit" id='savefilter' class="btn btn-success" name="savefilter"><i class="fa fa-check"></i> Save Filter</button>
    </div>
</form>

For the filter actions to run call run($module, $url)

Filters::run('users', 'admin/users');

Internally there are 3 methods that will be called based on the query string parameters:

When savefilter exists in the url then storeFilter() will run to store the filter.
Also storeFilter requires a filterTitle parameter to give a name to the filter.

When savedfilter exists in the url then applyFilter() will return the filter stored.
When removefilter exists in the url then deleteFilter() will run to delete the filter.