m1ome / phalcon-datatables
DataTables adapter for Phalcon Framework
Installs: 41 319
Dependents: 5
Suggesters: 0
Security: 0
Stars: 49
Watchers: 10
Forks: 51
Open Issues: 11
Requires (Dev)
- crysalead/kahlan: ~1.1
- fzaninotto/faker: 1.5.*@dev
README
About
This is a Phalcon Framework adapter for DataTables.
Support
Currently supported
- QueryBuilder interface
- ResultSet interface
- Pagination
- Global search (by value)
- Ordering
- Multiple column ordering
- Column-based search
Installation
Installation via Composer
- Install a composer
- Create
composer.json
file inside your project directory - Paste into it
{ "require": { "m1ome/phalcon-datatables": "1.*" } }
- Run
composer update
Example usage
It uses Phalcon QueryBuilder for pagination in DataTables.
In example we have a stantart MVC application, with database enabled. Don't need to provide a normal bootstrap PHP file, for Phalcon documentation, visit official site.
Controller (using QueryBuilder):
<?php use \DataTables\DataTable; class TestController extends \Phalcon\Mvc\Controller { public function indexAction() { if ($this->request->isAjax()) { $builder = $this->modelsManager->createBuilder() ->columns('id, name, email, balance') ->from('Example\Models\User'); $dataTables = new DataTable(); $dataTables->fromBuilder($builder)->sendResponse(); } } }
Controller (using ResultSet):
<?php use \DataTables\DataTable; class TestController extends \Phalcon\Mvc\Controller { public function indexAction() { if ($this->request->isAjax()) { $resultset = $this->modelsManager->createQuery("SELECT * FROM \Example\Models\User") ->execute(); $dataTables = new DataTable(); $dataTables->fromResultSet($resultset)->sendResponse(); } } }
Controller (using Array):
<?php use \DataTables\DataTable; class TestController extends \Phalcon\Mvc\Controller { public function indexAction() { if ($this->request->isAjax()) { $array = $this->modelsManager->createQuery("SELECT * FROM \Example\Models\User") ->execute()->toArray(); $dataTables = new DataTable(); $dataTables->fromArray($array)->sendResponse(); } } }
Model:
<?php /** * @property integer id * @property string name * @property string email * @property float balance */ class User extends \Phalcon\Mvc\Model { }
View:
<html> <head> <title>Simple DataTables Application</title> <script type="text/javascript" language="javascript" src="//code.jquery.com/jquery-1.11.1.min.js"></script> <script type="text/javascript" language="javascript" src="//cdn.datatables.net/1.10.4/js/jquery.dataTables.min.js"></script> <script type="text/javascript"> $(document).ready(function() { $('#example').DataTable({ serverSide: true, ajax: { url: '/test/index', method: 'POST' }, columns: [ {data: "id", searchable: false}, {data: "name"}, {data: "email"}, {data: "balance", searchable: false} ] }); }); </script> </head> <body> <table id="example"> <thead> <th>ID</th> <th>Username</th> <th>Email</th> <th>Balance</th> </thead> <tbody> </tbody> </table> </body> </html>
More examples
For more examples please search in site
directory.
It contains basic Phalcon bootstrap page to show all Phalcon-DataTables functionality.