mercredi 24 février 2016

Laravel Datatable doesn't work

I'm using Datatables Package for Laravel on Laravel 5 following get started guide but result is no matching record. when I check ajax manually, result has one user inside json file.

Route:

Route::get('/target' , [
    'as' => 'targets', 'uses' => 'TargetController@show'
]);

Route::controller('datatables', 'TargetController', [
    'anyData'  => 'datatables.data',
    'getIndex' => 'datatables',
]);

View:

<script>
$(function() {
    $('#targets-table').DataTable({
        processing: true,
        serverSide: true,
        ajax: '{!! route('datatables.data') !!}',
        columns: [
            { data: 'id', name: 'id' },
            { data: 'name', name: 'name' },
            { data: 'email', name: 'email' },
            { data: 'created_at', name: 'created_at' },
            { data: 'updated_at', name: 'updated_at' }
        ]
    });
});
</script>

Controller:

public function show()
{
    return view('targets');
}

public function anyData()
{
    return Datatables::of(TUser::query())->make(true);
}

Datatable Table with search and pagination is loaded normally and the problem is just about data loading.

Result of checking datatables/data page is :

{"draw":0,"recordsTotal":1,"recordsFiltered":1,"data":[{"id":1,"name":"saaaaaaa","email":"aaaaaa","remember_token":null,"created_at":"2016-02-03 13:00:01","updated_at":"2016-02-03 13:00:01"}],"queries":[{"query":"select count(*) as aggregate from (select '1' as \"row_count\" from \"users\") count_row_table","bindings":[],"time":1.75},{"query":"select * from \"users\"","bindings":[],"time":0.72}],"input":[]}



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire