Multi Datatable with using only one model

[jamesriady]

This is My controller

        $languages = Language::where('IsActive', 1)->get();
        if($request->ajax()) {  
                $post = Post::where('LanguageID', $request->input('LanguageID')));
            return Datatables::of($post)
            ->addColumn('action', function($post){
                return '<a id="edit" class="btn btn-info" 
                                     href="post/' . $post->id . '/edit">
                                        <i class="glyphicon glyphicon-edit icon-white"></i>
                                        Edit
                                    </a>
                                    <button type="button" class="btn btn-danger"
                                     onclick="checkDelete('.$post->id.', this);" 
                                     data-token="{{ csrf_token() }}">
                                        <i class="glyphicon glyphicon-trash icon-white"></i>
                                        Delete
                                    </button>';
                                })
            ->make(true);
        } 
        return view('pages.back-end.lists.post')->with('languages', $languages);  

This is my view
https://i.stack.imgur.com/TbMHv.png

This is my yajra

  $('.tabPost').each(function(){
    var lang_id = $(this).attr('id');
    console.log(lang_id);
    var oTable = $("#data-post" + lang_id).DataTable({
      processing: true,
      serverSide: true,
      ajax:{
        url: "{{ url("post") }}",
        data: function(d) {
          d.LanguageID = lang_id
        }
      },
      columns: [
          { data: 'PostDate', name: 'PostDate'},
          { data: 'PostTitle', name: 'PostTitle' },
          { data: 'PostSlug', name: 'PostTitle' },
          { data: 'action', name: 'action'}
      ]
    });

    $('#'+lang_id).on('click', function(e){
      oTable.draw();
      e.preventDefault();
    });

  }); 

I want to make my table has tab panel.. So, if I choose tab with language id 1, then display all data with language id 1, if I choose tab with language id 2, then display all data with language 2. Can I do like that in Yajra?

System details

• Operating System
• PHP Version
• Laravel Version
• Laravel-Datatables Version

[yajra]

I think your code is fine and just need a little tweak. Try something like:

if ($request->ajax()) {  
    $post = Post::where('LanguageID', request('languageid'));
    
    return Datatables::of($post)
        ->addColumn('action', function($post){
            return '<a id="edit" class="btn btn-info" 
                                 href="post/' . $post->id . '/edit">
                                    <i class="glyphicon glyphicon-edit icon-white"></i>
                                    Edit
                                </a>
                                <button type="button" class="btn btn-danger"
                                 onclick="checkDelete('.$post->id.', this);" 
                                 data-token="{{ csrf_token() }}">
                                    <i class="glyphicon glyphicon-trash icon-white"></i>
                                    Delete
                                </button>';
                            })
        ->make(true);
} 

return view('pages.back-end.lists.post')->with('languages', $languages); 

The trick is to just include the languageid and use it to filter the results.

[jamesriady]

$post = Post::where('LanguageID', request('languageid')); //does not work
So, I am using the way like this $post = Post::where('LanguageID', $request->has('LanguageID'));
But, when i click Indonesia, it shows all data where LanguageID = Indonesia, But when I click the other language, it does not show anything.. why? @yajra
It only select * from posts where LanguageID = 1;

[yajra]

Maybe the languageid is not changing on your script? Try dumping the inputs to see the url query params. Also, try using this script:

ajax:{
    url: "{{ url("post") }}",
    data: function(d) {
        d.languageid = languageid;
        etc...
    }
},

[jamesriady]

Still get the same result.. how can I do dump in ajax(yajra datatable)

[yajra]

Inspect the ajax request using chrome dev tools or firebug. Enable APP_DEBUG, and all inputs and queries will be included in the ajax response.

[jamesriady]

I got result like this.. my data only show in Indonesia tab

[yajra]

Did you create a separate script for each tab? There should be 2 ajax request. 1 for Indonesia & 1 for mandarin where languageid is diff.

[jamesriady]

I only use 1 script.. you can see in my post.. I don't know why the other language does not show the data.. Do you have any idea?

[yajra]

Does the languageid changes on each tab? The issue here is on your script. There should be two ajax request to fetch the data for each language

[jamesriady]

The languageid on tab header changed when you click.. but, in tab panel, I don't know how to check if the languageid changes or not

[yajra]

You need to redraw the table too when you click the tab panel to reload the data with proper language id.

[jamesriady]

There is id = Lang-1 and Lang 3, but the content is different

[jamesriady]

how to redraw the table? can you give me a sample?