trinity / search
Trinity 搜索组件
v1.0.4
2017-12-02 18:56 UTC
Requires
- php: >=7.1
- doctrine/data-fixtures: ~1.1
- doctrine/orm: ~2.5
- friendsofsymfony/rest-bundle: ~2.0
- jms/serializer-bundle: ~2.0
- sensio/framework-extra-bundle: ~3.0 | ~5.0
- symfony/asset: ~3.2
- symfony/config: ~2.8 | ~3.0
- symfony/dependency-injection: ~2.8 | ~3.0
- symfony/http-kernel: ~2.8 | ~3.0
- symfony/property-access: ~2.8 | ~3.0
- symfony/property-info: ~2.8 | ~3.0
- symfony/routing: ~2.8 | ~3.0
- symfony/serializer: ~2.8 | ~3.0
- symfony/validator: ~2.8 | ~3.0
- trinity/utils: ~1.0
Requires (Dev)
- doctrine/doctrine-bundle: ~1.6
- fzaninotto/faker: ~1.5
- knplabs/doctrine-behaviors: ~1.3
- phpstan/phpstan: ~0.7
- phpunit/phpunit: ~6.0
- satooshi/php-coveralls: ~1.0
- symfony/browser-kit: ~2.8 | ~3.0
- symfony/console: ~2.8 | ~3.0
- symfony/debug: ~2.8 | ~3.0
- symfony/form: ~2.8 | ~3.0
- symfony/security-bundle: ~2.8 | ~3.0
- symfony/twig-bundle: ~2.8 | ~3.0
- symfony/var-dumper: ~2.8 | ~3.0
This package is not auto-updated.
Last update: 2024-09-19 14:16:36 UTC
README
#Trinity 搜索
Trinity 搜索是 Trinity 包的一部分。
描述
- 根据给定查询查找对象数组
基本路由
/admin/search/{entity}/?q=
##语法将查询附加到基本路由。查询可以由以下组成
- (可选) 列选择 - 将您希望返回的列放入简单括号中。如果您想访问关联表中的列,只需在冒号后加上关联表中列的名称即可
(column1,column2,column3,column4:attributeFromAssociatedTable:anotherAttribute)
- (可选) 条件 - 将条件放入花括号中。可用运算符:<、>、=、<=、>=、!=、AND、OR
{column1 > 500 AND column2 < 800 OR (column3 = <str>JohnDoe</str> AND column4 <= 20)}
- 字符串值必须用括号括起来
{name = <str>Jack</str> AND description LIKE <str>%it started as "game"%</str>}
- (可选) 限制 - 对于限制5行,只需附加
LIMIT=5
- (可选) 偏移 - 对于偏移10行,只需附加
OFFSET=10
- (可选) 排序 - 对于排序结果,附加关键字 ORDER BY,然后是您想要排序的列和方向,支持多个列排序 - 用逗号分隔列
ORDERBY column1 ASC, column2 DESC
#####示例
/admin/search/product/?q= (id,name,defaultBillingPlan:initialPrice) {defaultBillingPlan:initialPrice > "14"} LIMIT=10 OFFSET=0 ORDERBY clients:name ASC, defaultBillingPlan:initialPrice DESC