aaronbullard / eads
PHP工具,用于EADS API
1.0.1
2020-02-14 15:15 UTC
Requires
- php: ^7.0
Requires (Dev)
- phpunit/phpunit: ^6.4
This package is auto-updated.
Last update: 2024-09-15 01:09:54 UTC
README
EADS工具
企业数据共享标准API的PHP工具
筛选
这是一个辅助类,用于将筛选字符串转换为可用的SQL语句。
示例查询
?filters=status==verified,age>18,weight>=<150;200
此查询转换为
- WHERE status = 'verified'
- AND age > 18
- AND weight BETWEEN 150 AND 200
安装
composer require aaronbullard/eads
使用
查看测试用例以了解使用示例 /tests
// GET `?filters=status==verified,age>18,weight>=<150;200` $filterString = Request::get('filters'); $parser = new EADS\Filters\Parser($filterString); // Get first query $filter = $parser->getFilters()[0]; $sql = $filter->getSQL(); // "status = ?" $bindings = $filter->getBindings(); // ['verified']
或
// GET `?filters=status==verified,age>18,weight>=<150;200` $filterString = Request::get('filters'); $filters = EADS::filters($filterString); // Get first query $filter = $filters[0]; $sql = $filter->getSQL(); // "status = ?" $bindings = $filter->getBindings(); // ['verified']
许可证
该软件包可以在MIT许可证的条款下作为开源软件使用。MIT License.