edweld/datatablesbundle

Symfony Datatable Bundle For Doctrine2 Entities

Thursday, July 14, 2016
by edweld
Repository
1 Watchers
0 Stars
12 Installations

PHP
0 Dependents
0 Suggesters
213 Forks
0 Open issues
19 Versions
0 % Grown

The README.md

SgDatatablesBundle

, _(*1)

, _(*2)

, _(*3)

, _(*4)

Recent Changes

In-place editing callback (#372)

$this->columnBuilder
    ->add('name', 'column', array(
        'title' => 'Name',
        'editable' => true,
        'editable_if' => function($row) {
            return (
                $this->authorizationChecker->isGranted('ROLE_USER') &&
                $row['public'] == true
            );
        }
    ))

Pipelining to reduce Ajax calls

$this->ajax->set(array(
    'url' => $this->router->generate('chili_private_results'),
    'pipeline' => 6
));

Search result highlighting.

Include the jQuery Highlight Plugin
Configure your Datatables-Class features

$this->features->set(array(
    // ...
    'highlight' => true,
    'highlight_color' => 'red' // 'red' is the default value
));

Enlargement of thumbnails with Featherlight

see #401, _(*5)

The Bootstrap modal window does not work properly in responsive mode., _(*6)

Load Featherlight with your base layout., _(*7)

`add_if` Closure for all Columns and TopActions

$this->columnBuilder
    ->add('title', 'column', array(
        // ...
        'add_if' => function() {
            return ($this->authorizationChecker->isGranted('ROLE_ADMIN'));
        },
    ))
;

$this->topActions->set(array(
    // ...
    'add_if' => function() {
        return ($this->authorizationChecker->isGranted('ROLE_ADMIN'));
    },
    'actions' => array(
        // ...
    )
));

Render Actions

before, _(*8)

'actions' => array(
    array(
        'route' => 'post_edit',
        'route_parameters' => array(
            'id' => 'id'
        ),
        'role' => 'ROLE_ADMIN',
        'render_if' => function($row) {
            return ($row['title'] === 'Title 1');
        },
    ),
    // ...

after, _(*9)

'actions' => array(
    array(
        'route' => 'post_edit',
        'route_parameters' => array(
            'id' => 'id'
        ),
        'render_if' => function($row) {
            return (
                $this->authorizationChecker->isGranted('ROLE_USER') &&
                $row['user']['username'] == $this->getUser()->getUsername()
            );
        },
    ),
    // ...

Multiselect: render checkboxes only if conditions are True

$this->columnBuilder
    ->add('title', 'multiselect', array(
        // ...
        'render_checkbox_if' => function($row) {
            return ($row['public'] == true);
        },
    ))
;

Screenshots

Table with Bootstrap3 integration:

Documentation

Installation, _(*10)

Column types, _(*11)

In-place editing, _(*12)

How to use the ColumnBuilder, _(*13)

Setup Datatable Class, _(*14)

Filtering, _(*15)

To use a line formatter, _(*16)

Query callbacks, _(*17)

Extensions like Buttons or Responsive, _(*18)

Options of the generator, _(*19)

Reference configuration, _(*20)

Example

Demo Application, _(*21)

Integrating 3rd party stuff

Integrate Bootstrap3, _(*22)

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

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

Limitations and Known Issues

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

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., _(*26)

You must know that all the pull requests you are going to submit must be released under the MIT license., _(*27)

Friendly License

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

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 /*)!, _(*29)