kirimemail/phalcon-datatables

A DataTables adapter for Phalcon Framework

, _(*1)

About

This is a Phalcon Framework adapter for DataTables., _(*2)

Support

Currently supported

• QueryBuilder interface
• ResultSet interface
• Pagination
• Raw query interface(*new)
• Global search (by value)
• Ordering
• Multiple column ordering
• Column-based search
• Caching

Installation

Installation via Composer

• Install a composer
• Create composer.json file inside your project directory
• Paste into it

{
    "require": {
        "kirimemail/phalcon-datatables": "1.*"
    }
}

• Run composer update

Example usage

It uses Phalcon QueryBuilder for pagination in DataTables., _(*3)

In example we have a standart MVC application, with database enabled. Don't need to provide a normal bootstrap PHP file, for Phalcon documentation, visit official site., _(*4)

Controller (using QueryBuilder):

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
request->isAjax()) {
          $resultset  = $this->modelsManager->createQuery("SELECT * FROM \Example\Models\User")
                             ->execute();

          $dataTables = new DataTable();
          $dataTables->fromResultSet($resultset)->sendResponse();
        }
    }
}
```

### Controller (using Array):
```php
request->isAjax()) {
          $array  = $this->modelsManager->createQuery("SELECT * FROM \Example\Models\User")
                             ->execute()->toArray();

          $dataTables = new DataTable();
          $dataTables->fromArray($array)->sendResponse();
        }
    }
}
```

### Controller (using Raw Query):
```php
request->isAjax()) {
          $dataTables = new DataTable();
          $dataTables->fromQuery([
              "select"=> "*",
              "from"=> "user"
          ])->sendResponse();
        }
    }
}
```

### Model:
```php

    
        
        
        
        
    
    
        

``` # Options There are few additional option available ```php true, "cache_di"=>"modelsCache", "cache_lifetime"=>3600 ]; //example $dt = new \DataTables\DataTable($options); ?> , _(*5)

More examples

For more examples please search in site directory. It contains basic Phalcon bootstrap page to show all Phalcon-DataTables functionality., _(*6)

This is fork repo from m10me/phalcon-datatables with some bugfix and additional methods., _(*7)