By Hardik Savani July 2, 2020 Category : LaravelNow, let's see example of laravel datatables filter dropdown example. We will use laravel datatables custom filter with dropdown. i would like to show you laravel datatables dropdown filter example. it's simple example of datatables dropdown filter with laravel. You just need to some step to done yajra datatable dropdown filter with laravel.
you can easily add dropdown filter with yajra datatables in laravel 6, laravel 7, laravel 8 and laravel 9.
Someday ago i already posted with laravel 7 datatables simple example. you can also view from here : Click Here. and also posted Laravel 7 Server Side Processing to view click here: Click Here.
In this tutorial, i will show you how to add custom filter with dropdown with laravel yajra datatable. we will add status column in users table and we will display status "Active" and "Deactive" in out table. add dropdown with active and deactive in top so you can select it and filter it.
So let's follow this tutorial and you will get layout as like bellow:
Preview:
Step 1: Install Laravel
In this step, if you haven't laravel application setup then we have to get fresh laravel 7 application. So run bellow command and get clean fresh laravel 7 application.
composer create-project --prefer-dist laravel/laravel blog
Step 2 : Install Yajra Datatable
We need to install yajra datatable composer package for datatable, so you can install using following command:
<?php use Illuminate\Database\Migrations\Migration;use Illuminate\Database\Schema\Blueprint;use Illuminate\Support\Facades\Schema; class AddStatusColumn extends Migration{ /** * Run the migrations. * * @return void */ public function up() { Schema::table('users', function (Blueprint $table) { $table->boolean('status')->default(0); }); } /** * Reverse the migrations. * * @return void */ public function down() { }}
Now we can run our migration:
php artisan migrate
Step 4: Add Dummy Records
In this step, we will create some dummy users using tinker factory. so let's create dummy records using bellow command:
In this is step we need to create route for datatables layout file and another one for getting data. so open your routes/web.php file and add following route.
In this point, now we should create new controller as UserController. this controller will manage layout and getting data request and return response, so put bellow content in controller file:
app/Http/Controllers/UserController.php
<?php namespace App\Http\Controllers; use App\User;use Illuminate\Http\Request;use DataTables; class UserController extends Controller{ /** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { if ($request->ajax()) { $data = User::select('*'); return Datatables::of($data) ->addIndexColumn() ->addColumn('status', function($row){ if($row->status){ return '<span class="badge badge-primary">Active</span>'; }else{ return '<span class="badge badge-danger">Deactive</span>'; } }) ->filter(function ($instance) use ($request) { if ($request->get('status') == '0' || $request->get('status') == '1') { $instance->where('status', $request->get('status')); } if (!empty($request->get('search'))) { $instance->where(function($w) use($request){ $search = $request->get('search'); $w->orWhere('name', 'LIKE', "%$search%") ->orWhere('email', 'LIKE', "%$search%"); }); } }) ->rawColumns(['status']) ->make(true); } return view('users'); }}
Step 7: Create View
In Last step, let's create users.blade.php(resources/views/users.blade.php) for layout and we will write design code here and put following code:
Now, let's see example of laravel datatables filter dropdown example. We will use laravel datatables custom filter with dropdown. i would like to show you laravel datatables dropdown filter example. it's simple example of datatables dropdown filter with laravel. You just need to some step to done yajra datatable dropdown filter with laravel.