Homepage Demo Installation Get Start Columns Custom Render To Column Query Builder Text Filter "Select" filter Autocomplete Filter Pro Tag Filter Pro Link Action Confirm & Edit Ajax Action Add & Edit Ajax Action Bulk Action Pro Download About Me
| |

PHP Advanced Datatable in Laravel >= 5.0


IDUsernameFirstnameLastnameEmail

Tag filter:
It's used to filter data by multi values, and this values is searched in the same data or other.

The datatable class contians "addfilter(filed_name,'tag',label,operator)" method to add new select filter 


    $dt->addfilter(filed_name,'tag',label,operator);



           operator takes the following values: notin, in
How to create it?

  1. call "addfilter" method in the action of your controller: $dt->addfilter('filed_name','tag',label,operator);
  2. create end point method in your datatable class with name: "respond_filters_tag_" as prefix and field_name as suffix
  3. "respond_filters_tag" must be called by "respond_filters_tag_filed_name" as following example: 
    
       static function respond_filters_tag_filed_name($search){
            return parent::respond_filters_tag([1=>'Ahmad',2=>'Ali']);
        }

Note:

respond_filters_tag requires a two-dimensional array (key,value)


For example:
in the action of your controller put the following code: 


    $dt = new Your/Datatable/Class(
            array(
                'firstname' => 'Firstname',
                'lastname' => 'Lastname'
            ));
    $dt->addfilter('username','tag','Username','in');
    return $dt->display('Your/Blade/Template',$request);
in your datatable put the following code: 

    static function respond_filters_tag_username($search){

        $records=\DB::table('mdl_user')->where('username', 'like', '%'.$search.'%')->get();
        $d=[];
        foreach ($records as $record){
            $d[$record->username]='User: '.$record->username;
        }
        return parent::respond_filters_tag($d);
    }

By: Mohammad Alaa Aldeen
Git: https://github.com/mhdalaaaldeen