omanshardt / doctrine-datatables
Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.
1.7.0
2023-10-15 15:33 UTC
Requires
- php: >=8.0
- doctrine/dbal: ~3.5
Requires (Dev)
- doctrine/orm: ~2.5
README
Helper library to implement Doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering.
Install
composer require omanshardt/doctrine-datatables
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
Doctrine\ORM\Tools\Pagination\Paginator
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.