markese/datatables

Create HTTP responses compatible with Datatables for JQuery from Eloquent Models, Query Builders, and Laravel Collections.

Datatables for Laravel

![Software License][ico-license], _(*1)

A package for Laravel that integrates Eloquent queries and Illuminate Collections into Datatables for JQuery., _(*2)

Structure

src/

Install

Via Composer, _(*3)

``` bash $ composer require markese/datatables, <sub>(*4)</sub>

## Usage

``` php
// Laravel:
namespace App\Http\Controllers;
use  Markese\Datatables\Datatables;

class Controller extends BaseController
{
    public function datatablesExample (Request $request)
    {
        $users = Users::query();
        return Datatables::response($users, $request);
    }
}

``` javascript // Datatables: $('#example').DataTable( { "serverSide": true, "processing": true, "ajax": "datatablesexample", columns : [ // The "name" property in the column initialization for Model attributes are optional., <sub>(*5)</sub>

    // This works...
    { "data": "id", "title": "Id" },

    // And so does this...
    { "data": "name", "title": "Name", "name": "name" },
    { "data": "email", "title": "Number", "name": "email" },

    // The "name" properties in your Datatables column initialization
    // will eager load the relations of the Model you are querying against 
    // when you use Laravel dot notation...
    { "data": "groups[].name", "title": "Groups", "name": "groups.*.name" },

    // The "data" properties in the column initialization represent the displayed data
    // which is accessible using standard JavaScript bracket notation...
    { "data": "groups[].roles[].title", "title": "Roles", "name": "groups.*.roles.*.title" }
]

} ); ```, <sub>(*6)</sub>

Change log

Please see CHANGELOG for more information on what has changed recently., <sub>(*7)</sub>

Contributing

Please see CONTRIBUTING and CONDUCT for details., <sub>(*8)</sub>

Security

If you discover any security related issues, please email john.markese@gmail.com instead of using the issue tracker., <sub>(*9)</sub>

Credits

• John Markese
• All Contributors

License

The MIT License (MIT). Please see License File for more information., <sub>(*10)</sub>