This package provides a filter functionality for Backpack for Laravel administration panel. If you don't have the budget or haven't purchased the pro version, this is a great alternative for implementing filters.
- theme-coreuiv2 - YES
- theme-coreuiv4 - YES
- theme-tabler - YES
- Free Backpack Fields
- date_range (this is custom so it has limited customization, can change wrapper and attributes)
Via Composer
composer require winex01/backpack-filterclass EntityCrudController extends CrudController
{
use \Winex01\BackpackFilter\Http\Controllers\Operations\FilterOperation;
public function setup()
{
CRUD::setModel(\App\Models\SampleModel::class);
CRUD::setRoute(config('backpack.base.route_prefix') . '/sample');
CRUD::setEntityNameStrings('sample', 'samples');
$this->crud->allowAccess('filters'); // Allow access
}
public function setupFilterOperation()
{
$this->crud->field([
'name' => 'status',
'label' => __('Status'),
'type' => 'select_from_array',
'options' => [
1 => 'Connected',
2 => 'Disconnected'
],
'wrapper' => [
'class' => 'form-group col-md-6'
]
]);
//
$this->crud->field([
'name' => 'date_range',
'label' => __('Date Range'),
'type' => 'date_range',
// although this is a custom field, you can still use the wrapper and attribute here
]);
}To apply the filter field into queries, inside your setupListOperation:
public function setupListOperation()
{
// if you use this method closure, validation is automatically applied.
$this->filterQueries(function ($query) {
$status = request()->input('status');
$dates = request()->input('date_range');
if ($status) {
$query->where('status_id', $status);
}
if ($dates) {
$dates = explode('-', $dates);
//$query->where... your clause here or scope.
}
});
//CRUD::setFromDb();
CRUD::setFromDb(false, true); //by doing this, it will remove all those fields that was automatically added by backpack
// or dont use CRUD::setFromDb(false, true) and just manually add columns each
$this->crud->columns('testColumn');
// more columns etc...
}Filter validation automatically applied but if you want to make your own validation:
public function filterValidations()
{
// If no access to filters, then don't proceed but don't show an error.
if (!$this->crud->hasAccess('filters')) {
return false;
}
// if you dont want to use validator and want to use request file, modify below, up to you.
$validationErrors = [];
// validator here.
if (!empty($validationErrors)) {
\Alert::error($validationErrors)->flash();
return redirect()->back();
}
return redirect()->back()->withInput(request()->input());
}This package also provides with export using https://laravel-excel.com/, this operation automatically add entity/export route, be sure you have EntityExport.php file in your export directory. example if you have UserCrudController, you must have app/Exports/UserExport.php file. Also if you have an active filters it will also apply into the export.
// crud controller
class UserCrudController extends CrudController
{
use \Winex01\BackpackFilter\Http\Controllers\Operations\ExportOperation;
// Optional: if you dont want to use the entity/export or user/export convention you can override the export route:
public function exportRoute()
{
return route('test.export');; // if you define a route here then it will use instead of the auto
}
// setup method...
}php artisan vendor:publish --provider="Winex01\BackpackFilter\BackpackFilterServiceProvider" --tag="config"Changes are documented here on Github. Please see the Releases tab.
composer testPlease see contributing.md for a todolist and howtos.
If you discover any security related issues, please email winnie131212592@gmail.com instead of using the issue tracker.
This project was released under MIT, so you can install it on top of any Backpack & Laravel project. Please see the license file for more information.
However, please note that you do need Backpack installed, so you need to also abide by its YUMMY License. That means in production you'll need a Backpack license code. You can get a free one for non-commercial use (or a paid one for commercial use) on backpackforlaravel.com.