omanshardt/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Friday, January 12, 2018
by omanshardt
Repository
1 Watchers
0 Stars
27 Installations

PHP
0 Dependents
0 Suggesters
7 Forks
0 Open issues
13 Versions
8 % Grown

The README.md

omanshardt/doctrine-datatables

Helper library to implement Doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering., _(*1)

, _(*2)

Install

composer require omanshardt/doctrine-datatables

Usage with doctrine/dbal: Usage with doctrine/orm:, _(*3)

This is a clone from https://github.com/vaibhavpandeyvpz/doctrine-datatables with some intenal modifications. So please refer to the original tool for usage., _(*4)

See LICENSE.md file., _(*5)

This one supports, _(*6)

Doctrine\ORM\Tools\Pagination\Paginator

To search from datatables there are nine different search modes, _(*7)

*% (LIKE '…%') -> default: This performs a LIKE '…%' search where the start of the search term must match a value in the given column. This can be archived with only providing the search term (because it's default) or by prefixing the search term with "[*%]" ([*%]searchTerm).
%% (LIKE '%…%'): This performs a LIKE '%…%' search where any part the search term must match a value in the given column. This can be archived by prefixing the search term with "[%%]" ([%%]searchTerm).
= (Equality): This performs a = … search. The search term must exactly match a value in the given column. This can be archived by prefixing the search term with "[=]" ([=]searchTerm).
!= (No Equality): This performs a != … search. The search term must not exactly match a value in the given column. This can be archived by prefixing the search term with "[!=]" ([!=]searchTerm).
> (Greater Than): This performs a > … search. The search term must be smaller than a value in the given column. This can be archived by prefixing the search term with "[>]" ([>]searchTerm).
: This performs a search. The search term must be greater than a value in the given column. This can be archived by prefixing the search term with "[([.
: This performs an IN(…) search. One of the provided comma-separated search terms must exactly match a value in the given column. This can be archived by prefixing the search terms with "[IN]" ([IN]searchTerm,searchTerm,…).
: This performs multiple OR-connected LIKE('%…%') searches. One of the provided comma-separated search terms must match a fragment of a value in the given column. This can be archived by prefixing the search terms with "[OR]" ([OR]searchTerm,searchTerm,…).
>: This performs a BETWEEN … AND … search. Both search terms must be separated with a comma. This operation can be archived by prefixing the comma-separated search terms with "[>([>.

Prefixes are case-insenstive (IN, in, OR, or). Provided search terms were trimmed., _(*8)

The Versions

12/01 2018

dev-master

9999999-dev https://github.com/omanshardt/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

The Development Requires

doctrine/orm ~2.5

jquery doctrine datatables

12/01 2018

1.5.2

1.5.2.0 https://github.com/omanshardt/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

The Development Requires

doctrine/orm ~2.5

jquery doctrine datatables

12/01 2018

1.5.0

1.5.0.0 https://github.com/omanshardt/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

The Development Requires

doctrine/orm ~2.5

jquery doctrine datatables

12/01 2018

1.4.0

1.4.0.0 https://github.com/omanshardt/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

The Development Requires

doctrine/orm ~2.5

jquery doctrine datatables

08/01 2018

dev-stable

dev-stable https://github.com/omanshardt/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

The Development Requires

doctrine/orm ~2.5

jquery doctrine datatables

12/11 2017

1.3.3

1.3.3.0 https://github.com/omanshardt/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

The Development Requires

doctrine/orm ~2.5

jquery doctrine datatables

29/05 2017

1.3.2

1.3.2.0 http://vaibhavpandeyvpz.github.io/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

The Development Requires

doctrine/orm ~2.5

jquery doctrine datatables

21/05 2017

1.3.1

1.3.1.0 http://vaibhavpandeyvpz.github.io/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

The Development Requires

doctrine/orm ~2.5

jquery doctrine datatables

05/11 2016

1.3

1.3.0.0 http://vaibhavpandeyvpz.github.io/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

The Development Requires

doctrine/orm ~2.5

jquery doctrine datatables

04/11 2016

1.2.1

1.2.1.0 http://vaibhavpandeyvpz.github.io/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

jquery doctrine datatables

22/10 2016

1.2.0

1.2.0.0 http://vaibhavpandeyvpz.github.io/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

jquery doctrine datatables

22/10 2016

1.1.0

1.1.0.0 http://vaibhavpandeyvpz.github.io/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

jquery doctrine datatables

14/09 2016

1.0

1.0.0.0 http://vaibhavpandeyvpz.github.io/doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

jquery doctrine datatables

library doctrine-datatables

Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.