lucasff/cakephp-datatable

CakePHP DataTable Plugin

CakePHP DataTable Plugin

DataTable is a cakephp plugin for JQuery DataTables., _(*1)

Requirements

• CakePHP 2.2 or higher

Installation

[Manual], _(*2)

1. Download this: http://github.com/tigrang/cakephp-datatable/zipball/master.
2. Unzip
3. Copy the resulting folder to app/Plugin
4. Rename the folder to DataTable

[GIT Submodule], _(*3)

In your app directory run:, _(*4)

git submodule add https://github.com/tigrang/cakephp-datatable.git Plugin/DataTable
git submodule init
git submodule update

[GIT Clone], _(*5)

In your plugin directory run:, _(*6)

git clone https://github.com/tigrang/cakephp-datatable.git DataTable

Enable Plugin

In your app/Config/bootstrap.php:, _(*7)

CakePlugin::loadAll();
// OR
CakePlugin::load('DataTable');

Usage

Example controller:

<?php
class UsersController extends AppController {

/**
 * Components
 *
 * @var array
 */
    public $components = array(
        'DataTable.DataTable' => array(
            'columns' => array(
                'id' => false,                      // bSearchable and bSortable will be false
                'username' => 'Name',               // bSearchable and bSortable will be true, with a custom label `Name`
                                                    // by default, the label with be a Inflector::humanize() version of the key
                'email' => array(
                    'bSearchable' => 'customSearch',// will use model callback to add search conditions
                ),
                'Actions' => null,                  // tells DataTable that this column is not tied to a field
            ),
        ),
    );

/**
 * Helpers
 *
 * @var array
 */
    public $helpers = array(
        'DataTable.DataTable',
    );
}

You may now paginate more than one model in a view. This becomes useful when displaying two or more hasMany associated models for a view page. List all models to paginate in $this->DataTable->paginate property:, _(*8)

<?php
public function view() {
    $this->DataTable->paginate = array('User', 'Article');
}

Note: These models must be directly related., _(*9)

See docblock for complete list of component settings., _(*10)

Once you have your component setup, you will need to add your view., _(*11)

• First create a View/[ModelName]/datatable folder
• Create action_name.ctp view inside the folder

The DataTableResponseView (automatically set by the component) class has a member called dtResponse which holds the return data for jquery datatables, including aaData., _(*12)

By default, the view var $dtResults will hold resultant model data after searching and paginating. It can be customized with the viewVar setting., _(*13)

Example view file:

<?php
foreach($dtResults as $result) {
    $this->dtResponse['aaData'][] = array(
        $result['User']['id'],
        $result['User']['username'],
        $result['User']['email'],
        'actions',
    );
}

Example bSearchable callback:

<?php
class Users extends AppModel {
    public function customSearch($field, $searchTerm, $columnSearchTerm, $conditions) {
        if ($searchTerm) {
            $conditions[] = array("$field LIKE" => '%' . $searchTerm);  // only do left search
        }
        if ($columnSearchTerm) {
            $conditions[] = array($field => $columnSearchTerm);         // only do exact match
        }
        return $conditions;
    }
}

Helper Usage

<?php
$this->DataTable->render(); // renders default model for this view
$this->DataTable->render('AssociatedModel'); // renders 'AssociatedModel' table

If you create the <table> yourself, be sure to add a data-model="Model" attribute to the table tag. The helper is still required to parse the column settings and outputs a global javascript dataTableSettings available for you to use. The helper by default uses the following init script:, _(*14)

$('.dataTable').each(function() {
    var table = $(this);
    var model = table.attr('data-model');
    var settings = dataTableSettings[model];
    table.dataTable(settings);
});