wicool/laravel-filters

A Laravel package to make it easy to consult eloquente

dev-master 2020-01-20 15:23 UTC

Requires

• php: >=7.3.0

MIT

• Flaviano Honorato

• package
• laravel

README

• Install:

composer require wicool/laravel-filters

How to use:

• Model app/Models/User.php

<?php

namespace App\Models\User;

use Illuminate\Database\Eloquent\Model;
use Wicool\LaraFilter\LaraFilterTrait;

class User extends Model
{
    use LaraFilterTrait;

    /**
     * set string fields for filtering
     * @var array
     */
    protected $likeFilterFields = ['name', 'email', 'phone'];

    /**
     * set boolean fields for filtering
     * @var array
     */
    protected $boolFilterFields = ['status'];
}

• Controller app/Http/Controllers/UserController.php

You only need to pass the parameters via request in the controller scope filter.

<?php

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use App\Models\User;
use Illuminate\Http\Request;

class UsersController extends Controller
{
	public function index(Request $request)
	{
		$users = User->filter($request->all())->get();
		
		return $users;
	}
}

• The return will be something like:

/users?name=Fulaninho&email=[e-mail]?phone=999999999&status=true

SELECT * FROM users WHERE name = 'Fulaninho' AND email = '[e-mail]' AND status = true