You can install the package via composer:
composer require binarcode/laravel-restableTo associate search with a model, the model must implement the following interface and trait:
namespace App\Models;
use BinarCode\LaravelRestable\HasRestable;
use BinarCode\LaravelRestable\Restable;
use Illuminate\Database\Eloquent\Model;
class YourModel extends Model implements Restable
{
use HasRestable;
}Using this lightweight package you can mainly customize search, matches and sorts.
Define columns you want to be searchable using $search model property:
class Dream extends Model implements Restable
{
use HasRestable;
public static array $search = [
'name',
];
}Now in the query of your request you can use the ?search= to find over your model. Let's assume this is the URL for
geting the list of dreams:
GET: /api/dreams?search=be happyThen in the controller you may have something like this:
use App\Models\Dream;
use Illuminate\Http\Request;
class DreamController extends Controller
{
public function index(Request $request)
{
$dreams = Dream::search($request);
return response()->json($dreams->paginate());
}
}This way Restable will find your dreams by name column and will return a Builder instance, so you can paginate
or do whatever you want over that query.
The query filtering is something like this: $query->where('column_name', 'like', "%$value%";
Matching by a specific column is a more strict type of search. You should define the columns you want to match along with the type:
use BinarCode\LaravelRestable\Types;
class Dream extends Model implements Restable
{
use HasRestable;
public static array $match = [
'id' => Types::MATCH_ARRAY,
'name' => Types::MATCH_TEXT,
];
}The URL may look like this:
GET: /api/dreams?id=1,2,3&name=happySo Restable will make a query like this:
$query->whereIn('id', [1, 2, 3])->where('name','=', 'happy');The controller could be same as we had for the search.
You can also specify what columns could be sortable:
class Dream extends Model implements Restable
{
use HasRestable;
public static array $sort = [
'id',
'name',
];
}The query params for sort could indicate whatever is asc or desc sorting by using the - sign:
Sorting desc by id column:
GET: /api/dreams?sort=-idSorting asc by id column:
GET: /api/dreams?sort=idYou can use methods to return your search, matches or sorts from the model definition:
class Dream extends Model implements Restable
{
use HasRestable;
public static function sorts(): array
{
return [ 'id', 'name' ];
}
public static function matches(): array
{
return [
'id' => 'int',
'name' => 'string',
];
}
public static function searchables(): array
{
return ['name'];
}
}Instead of using the default methods for filtering, you can have your own:
use BinarCode\LaravelRestable\Filters\MatchFilter;class Dream extends Model implements Restable
{
use HasRestable;
public static function matches(): array
{
return [
'something' => MatchFilter::make()->resolveUsing(function($request, $query) {
// filter it here
}),
'name' => 'string'
];
}
}So you can now match by something property, and implement your own search into the closure.
You can also create your own Match filter class, and implement the search there:
use BinarCode\LaravelRestable\Filters\MatchFilter;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Http\Request;
class MatchSomething extends MatchFilter
{
public function apply(Request $request, Builder $query, $value): Builder
{
// your filters
return $query->where('a', $value);
}
}Then use your MatchSomething filter:
class Dream extends Model implements Restable
{
use HasRestable;
public static function matches(): array
{
return [
'something' => MatchSomething::make(),
'name' => 'string'
];
}
}The same you could do for Search or Sort filter, by extending the BinarCode\LaravelRestable\Filters\SearchableFilter or BinarCode\LaravelRestable\Filters\SortableFilter filters.
composer testPlease see CHANGELOG for more information on what has changed recently.
Please see CONTRIBUTING for details.
Please review our security policy on how to report security vulnerabilities.
The MIT License (MIT). Please see License File for more information.