181 / laravel-datatables

jQuery DataTables API for Laravel 4|5

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 [email protected] instead of using the issue tracker.

Credits

• Arjay Angeles
• bllim/laravel4-datatables-package
• All Contributors

License

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

Buy me a beer