SilexStarter-Datatable

A datatable module for SilexStarter to provide backend for jquery-datatable library (http://datatable.net)

##Installation

• Add this repository and the following package to your composer.json

{
    "repositories" : [
        {
            "type" : "vcs",
            "url" : "https://github.com/xsanisty/EloquentDataTable"
        },
        {
            "type" : "vcs",
            "url" : "https://github.com/xsanisty/SilexStarter-Datatable"
        }
    ],
    "requires" : {
        "xsanisty/silexstarter-datatable" : "^1.0"
    }
}

• Register the module provider on app/config/modules.php

return [
    //...
    "Xsanisty\Datatable\DatatableModule",
    //...
]

##Usage

• on client side (template), load the datatable script and stylesheet

{% block stylesheet %}
    {{parent()}}

    {{ stylesheet([
        '@silexstarter-datatable/css/dataTables.bootstrap.css',
        '@silexstarter-datatable/css/responsive.bootstrap.min.css'
    ]) }}
{% endblock %}

{% block javascript %}
    {{parent()}}

    {{ javascript([
        '@silexstarter-datatable/js/jquery.dataTables.min.js',
        '@silexstarter-datatable/js/dataTables.bootstrap.min.js',
        '@silexstarter-datatable/js/dataTables.responsive.min.js'
    ]) }}
{% endblock %}

• on the server side, you can build datatable response by simply using datatable shortcut

$datatable = Datatable::of(User::where('id', '<>', $my->id))
    ->setColumn(['profile_pic', 'first_name', 'last_name', 'email', 'activated', 'last_login', 'id'])
    ->setFormatter(
        function ($row) {
            /* do something with the row */
            return [
                $row->id,
                $row->field
                /* etc */
            ];
        }
    )
    ->make();

return Response::json($datatable);