jQuery DataTables API for Laravel 4|5

This package is created to handle server-side works of DataTables jQuery Plugin via AJAX option by using Eloquent ORM, Fluent Query Builder or Collection.

use Yajra\Datatables\Facades\Datatables;

// Using Eloquent
return Datatables::eloquent(User::query())->make(true);

// Using Query Builder
return Datatables::queryBuilder(DB::table('users'))->make(true);

// Using Collection
return Datatables::collection(User::all())->make(true);

// Using the Engine Factory
return Datatables::of(User::query())->make(true);
return Datatables::of(DB::table('users'))->make(true);
return Datatables::of(User::all())->make(true);

Requirements

PHP 5.5.9 or later
Laravel 5.0 or later
DataTables jQuery Plugin Version 1.10.xx

Documentations

You will find user friendly and updated documentation in the wiki here: Laravel Datatables Wiki
You will find the API Documentation here: Laravel Datatables API
Demo Application is available for artisan's reference.

Quick Installation

composer require yajra/laravel-datatables-oracle:~6.0

Service Provider

Yajra\Datatables\DatatablesServiceProvider::class

Facade

Datatables facade is automatically registered as an alias for Yajra\Datatables\Facades\Datatables class.

Configuration and Assets

$ php artisan vendor:publish --tag=datatables

And that's it! Start building out some awesome DataTables!

Upgrading from v5.x to v6.x

Change all occurrences of yajra\Datatables to Yajra\Datatables. (Use Sublime's find and replace all for faster update).
Remove Datatables facade registration.
Temporarily comment out Yajra\Datatables\DatatablesServiceProvider.
Update package version on your composer.json and use yajra/laravel-datatables-oracle: ~6.0
Uncomment the provider Yajra\Datatables\DatatablesServiceProvider.

Debugging Mode

To enable debugging mode, just set APP_DEBUG=true and the package will include the queries and inputs used when processing the table.

IMPORTANT: Please make sure that APP_DEBUG is set to false when your app is on production.

Contributing

Please see CONTRIBUTING for details.

Security

If you discover any security related issues, please email aqangeles@gmail.com instead of using the issue tracker.

Credits

License

The MIT License (MIT). Please see License File for more information.

michail1982/laravel-datatables