Datatables Package 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.

Feature Overview

• Supports the following data source
  • Eloquent ORM
  • Fluent Query Builder
  • Collection [available on v5.x and later]
• DataTable Service Implementation (v6.x).
• Adding or editing content of columns and removing columns
• Templating new or current columns via Blade Template Engine or by using Closure
• Works with ALL the DATABASE supported by Laravel
• Works with Oracle Database using Laravel-OCI8 package
• Works with DataTables v1.10++.
  • Note: DT Legacy code is not supported on v5.x
• Works with DataTables v1.9 and v1.10 legacy code.
  • Note: Use v4.x for Laravel 5 and v3.x for Laravel 4
• Extended column filtering via filterColumn API.
• Extended column ordering via orderColumn API.
• Extended Query Builder functionality allowing you to filter using Datatables class directly.
• Decorate your data output using league\fractal Transformer with Serializer support.
• Works with Laravel Dependency Injection and IoC Container.
• Provides a DataTable Html Builder to help you use the package with less code.
• Provides XSS filtering function to optionally escape all or specified column values using escapeColumns('*'\['column']) method.
• Provides Query Logging when application is in debug state. Important: Make sure that debug is set to false when your code is in production

Requirements:

• PHP 5.5.9 or later.
• Laravel 5.0 or later.

Laravel 4.2 & DataTables v1.9.x Users

Most of the latest updates/features are not available on these versions. Please check L4 Branch and L5 DT1.9 for old documentations of its features.

Buy me a beer

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

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

Laravel 4: composer require yajra/laravel-datatables-oracle:~3.0

Service Provider

Yajra\Datatables\DatatablesServiceProvider

Facade

Laravel 4 'Datatables' => 'yajra\Datatables\Facades\Datatables',

Laravel 5++ Datatables facade are automatically registered as an alias for Yajra\Datatables\Datatables class.

Configuration

Laravel 5: $ php artisan vendor:publish --tag=datatables

Laravel 4: $ php artisan config:publish yajra/laravel-datatables-oracle

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.

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

• This project is used to be a fork from bllim/laravel4-datatables-package.
• All Contributors

License

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