PLEASE NOTE: THIS IS NO LONGER UNDER ACTIVE DEVELOPMENT. THERE IS A POTENTIAL FOR ME TO PORT THE CODE TO CAKEPHP 3 IN THE DISTANT FUTURE, BUT WHO KNOWS. YOU MAY CONTINUE CREATING ISSUES AND I WILL ATTEMPT ANSWERING, BUT GENERALLY MY RESPONSE WILL INCLUDE THIS IS NO LONGER UNDER ACTIVE DEVELOPMENT. YOU ARE OF COURSE WELCOME TO FORK AND CONTINUE DEVELOPMENT FOR CAKE 2 OR BEGIN DEVELOPMENT FOR CAKE 3. THANKS! - Chris Nizzardini, 2015-10-13
Provides server-side interoperability between CakePHP 2.x and jQuery DataTables plugin.
You can either clone the project, download the project, or just copy & paste DataTableComponent.php into your projects Controller/Component directory
http://cakephpdatatables.cnizz.com/
You can setup the demo locally with the following steps:
The demo application is designed for CakePHP 2.3 and was built on Ubuntu 12.10 running Apache2 with PHP 5.4. It does not have the full Cake framework in it, so you'll need to have cakephp in your php include paths or create a symbolic link to cake in test.
I'm in the process of enhancing documentation and moving it out of the README and into the wiki.
Ordering and conditions supplied via DataTables work "automagically" and nothing else is needed. Deep relations using the ContainableBehavior will break the response due to the way conditions work within that behavior. To get around this it is recommended that the LinkableBehavior be used instead. The Component respects many of the options you can define within jQuery DataTables settings such as bSearchable and bSortable on a per field basis.
With ContainableBehavior:
$this->paginate = array(
'fields' => array('Field.A','Field.B', 'Field.C','AssocatiatedModal.D'),
'conditions' => array(
'active'=>1
)
'contain' => array('AssocatiatedModal')
);
$this->set('response', $this->DataTable->getResponse());
$this->set('_serialize','response');
Using models from other controllers. Sometimes the case may be that you are in a CustomersController and you have a method within that wants to display data from another model such as an Order model. This can be accomplished with the following parameters:
$this->DataTable->getResponse(null,$this->Order);
Code is licensed under the MIT License.