Download the PHP package carbdrox/pimcore-querybuilder-bundle without Composer
On this page you can find all versions of the php package carbdrox/pimcore-querybuilder-bundle. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download carbdrox/pimcore-querybuilder-bundle
More information about carbdrox/pimcore-querybuilder-bundle
Files in carbdrox/pimcore-querybuilder-bundle
Package pimcore-querybuilder-bundle
Short Description Pimcore QueryBuilder Bundle for easy query generation.
License MIT
Informations about the package pimcore-querybuilder-bundle
Pimcore Querybuilder Bundle
This bundle adds a Service to your Pimcore project, which can resolve vite assets.
Installation
Using composer
Usage
You can either use the service directly or use the provided trait.
Using the service directly
Using the provided trait
if you want to use the provided trait, you must either add \QueryBuilderBundle\Traits\HasQueryBuilder
in your
DataObject definition in the Use(traits) field, or extend your DataObject class and insert
use \QueryBuilderBundle\Traits\HasQueryBuilder;
there.
Interface
Trait
The trait adds the following static methods to your DataObject class:
Method | Returns |
---|---|
query() | QueryBuilder |
orderBy(string $field, string $order = 'asc') | QueryBuilder |
limit(int $limit) | QueryBuilder |
offset(int $offset) | QueryBuilder |
count() | int |
first() | Concrete|null |
all() | array |
where(string|\Closure $field, string $operation, mixed $value, bool $escaped = true) | QueryBuilder |
Service
The service provides the following methods:
Method | Returns |
---|---|
where(string|\Closure $field, string $operation = '=', mixed $value = '', bool $escaped = true) | QueryBuilder |
whereNested(\Closure $callback) | QueryBuilder |
orWhere(string|\Closure $field, string $operation = '=', mixed $value = '', bool $escaped = true) | QueryBuilder |
orWhereNested(\Closure $callback) | QueryBuilder |
join(string $tableName, string $name) | QueryBuilder |
limit(int $limit) | QueryBuilder |
offset(int $offset) | QueryBuilder |
orderBy(string $field, string $order = 'asc') | QueryBuilder |
groupBy(string $column) | QueryBuilder |
count() | int |
get() | array |
first() | Concrete|null |
all() | array |
toSql() | string |
paginate(int $page = 1, int $perPage = 10) | PaginationInterface |
Contributing
Thank you for considering contributing! The contribution guide can be found in the CONTRIBUTING.md.
Code of Conduct
Please review and abide by the Code of Conduct.
License
The Pimcore Vite bundle is licensed under the MIT license.
TODOs
- [ ] Add tests
- [ ] The join method needs to be revised so that you don't have to manually join from the alphabetically smaller class to the larger one.