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
Modify column values 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
Easily attach a resource on json response via ->with() method.
Built-in support for exporting to CSV, EXCEL and PDF using Laravel-Excel.
Built-in printer friendly view or create your own by overriding printPreview() method.
Provides an artisan command for generating a DataTable service and scope.
See change logs for more details.

Requirements:

PHP 5.5.9 or later.
Laravel 5.0 or later.
DataTables jQuery Plugin v1.10.x

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

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

Service Provider

Yajra\Datatables\DatatablesServiceProvider::class

Facade

Datatables facade are automatically registered as an alias for Yajra\Datatables\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.

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

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.

Worm/laravel-datatables