SgDatatablesBundle

, _(*1)

, _(*2)

, _(*3)

Help wanted

To all russian and polish speaking contributors. Please help me to update the translation files. Thanks a lot!, _(*4)

Recent Important Changes

The ClientSide mode is no longer supported by me!, _(*5)

use parent service instead of tagging datatables view class

services:
    app.datatable.post:
        class: AppBundle\Datatables\PostDatatable
        parent: sg_datatables.datatable.abstract

unlimited nested association support and fix filtered counter when using a custom query
start for PostgreSql support
Datatable Events supported
some new translations
render_if Closure parameter in action column
outsourcing individual filter in new classes, see below example

    public function buildDatatable(array $options = array())
    {
        // ...

        $users = $this->em->getRepository('AppBundle:User')->findAll();

        $this->columnBuilder
            ->add('title', 'column', array(
                'title' => 'Title',
                'filter' => array('text', array(
                    'search_type' => 'eq'
                ))
            ))
            ->add('visible', 'boolean', array(
                'title' => 'Visible',
                'filter' => array('select', array(
                    'search_type' => 'eq',
                    'select_options' => array('' => 'All', '1' => 'Yes', '0' => 'No')
                )),
            ))
            ->add('createdby.username', 'column', array(
                'title' => 'Createdby User',
                'filter' => array('select', array(
                    'search_type' => 'eq',
                    'select_options' => array('' => 'All') + $this->getCollectionAsOptionsArray($users, 'username', 'username'),
                ))
            ))
            ->add('createdAt', 'datetime', array(
                'title' => 'Created',
                'filter' => array('daterange', array()),
            ))
        ;
    }

Screenshots

Table with Bootstrap3 integration:

Table with default stylesheet (`display`):

Documentation

Installation, _(*6)

Column types, _(*7)

In-place editing, _(*8)

How to use the ColumnBuilder, _(*9)

Setup Datatable Class, _(*10)

Filtering, _(*11)

To use a line formatter, _(*12)

Query callbacks, _(*13)

Extensions like Buttons or Responsive, _(*14)

Options of the generator, _(*15)

Reference configuration, _(*16)

Example

Demo Application, _(*17)

Integrating 3rd party stuff

Integrate Bootstrap3, _(*18)

Integrate the Translatable behavior extension for Doctrine 2, _(*19)

Integrate the LiipImagineBundle / ImageColumn, GalleryColumn and thumbnails, _(*20)

Limitations and Known Issues

Much like every other piece of software SgDatatablesBundle is not perfect and far from feature complete., _(*21)

Use this Bundle in ServerSide mode

The ClientSide mode is no longer supported by me., _(*22)

Other limitations

This bundle does not support multiple Ids
Searching and filtering on a virtual column not yet implemented and disabled by default
PostgreSql is currently not fully supported

Reporting an issue or a feature request

Issues and feature requests are tracked in the Github issue tracker., _(*23)

Friendly License

This bundle is available under the MIT license. See the complete license in the bundle:, _(*24)

Resources/meta/LICENSE

You are free to use, modify and distribute this software, as long as the copyright header is left intact (specifically the comment block which starts with /*)!, _(*25)