Download the PHP package omanshardt/doctrine-datatables without Composer
On this page you can find all versions of the php package omanshardt/doctrine-datatables. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download omanshardt/doctrine-datatables
More information about omanshardt/doctrine-datatables
Files in omanshardt/doctrine-datatables
Package doctrine-datatables
Short Description Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.
License MIT
Homepage https://github.com/omanshardt/doctrine-datatables
Informations about the package doctrine-datatables
omanshardt/doctrine-datatables
Helper library to implement Doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.
Install
Usage with doctrine/dbal: Usage with doctrine/orm:
This is a clone from https://github.com/vaibhavpandeyvpz/doctrine-datatables with some intenal modifications. So please refer to the original tool for usage.
See LICENSE.md file.
This one supports
To search from datatables there are nine different search modes
- *% (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).
- < (Smaller Than)
- 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 "[<]" ([<]searchTerm).
- < (IN)
- 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,…).
- < (OR)
- 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,…).
- >< (Between)
- 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 "[><]" ([><]searchTerm,searchTerm).
Prefixes are case-insenstive (IN, in, OR, or). Provided search terms were trimmed.