Clauses
2 years ago
Concerns
9 months ago
Types
4 years ago
JoinQueryBuilder.php
4 years ago
QueryBuilder.php
1 year ago
WhereQueryBuilder.php
4 years ago
QueryBuilder.php
68 lines
| 1 | <?php |
| 2 | |
| 3 | namespace Give\Framework\QueryBuilder; |
| 4 | |
| 5 | use Give\Framework\QueryBuilder\Concerns\Aggregate; |
| 6 | use Give\Framework\QueryBuilder\Concerns\CRUD; |
| 7 | use Give\Framework\QueryBuilder\Concerns\FromClause; |
| 8 | use Give\Framework\QueryBuilder\Concerns\GroupByStatement; |
| 9 | use Give\Framework\QueryBuilder\Concerns\HavingClause; |
| 10 | use Give\Framework\QueryBuilder\Concerns\InsertInto; |
| 11 | use Give\Framework\QueryBuilder\Concerns\JoinClause; |
| 12 | use Give\Framework\QueryBuilder\Concerns\LimitStatement; |
| 13 | use Give\Framework\QueryBuilder\Concerns\MetaQuery; |
| 14 | use Give\Framework\QueryBuilder\Concerns\OffsetStatement; |
| 15 | use Give\Framework\QueryBuilder\Concerns\OrderByStatement; |
| 16 | use Give\Framework\QueryBuilder\Concerns\SelectStatement; |
| 17 | use Give\Framework\QueryBuilder\Concerns\TablePrefix; |
| 18 | use Give\Framework\QueryBuilder\Concerns\UnionOperator; |
| 19 | use Give\Framework\QueryBuilder\Concerns\WhereClause; |
| 20 | |
| 21 | /** |
| 22 | * @since 2.19.0 |
| 23 | */ |
| 24 | class QueryBuilder |
| 25 | { |
| 26 | use Aggregate; |
| 27 | use CRUD; |
| 28 | use FromClause; |
| 29 | use GroupByStatement; |
| 30 | use HavingClause; |
| 31 | use JoinClause; |
| 32 | use LimitStatement; |
| 33 | use MetaQuery; |
| 34 | use OffsetStatement; |
| 35 | use OrderByStatement; |
| 36 | use SelectStatement; |
| 37 | use TablePrefix; |
| 38 | use UnionOperator; |
| 39 | use WhereClause; |
| 40 | use InsertInto; |
| 41 | |
| 42 | /** |
| 43 | * @return string |
| 44 | */ |
| 45 | public function getSQL() |
| 46 | { |
| 47 | $sql = array_merge( |
| 48 | $this->getSelectSQL(), |
| 49 | $this->getFromSQL(), |
| 50 | $this->getJoinSQL(), |
| 51 | $this->getWhereSQL(), |
| 52 | $this->getGroupBySQL(), |
| 53 | $this->getHavingSQL(), |
| 54 | $this->getOrderBySQL(), |
| 55 | $this->getLimitSQL(), |
| 56 | $this->getOffsetSQL(), |
| 57 | $this->getUnionSQL() |
| 58 | ); |
| 59 | |
| 60 | // Trim double spaces added by DB::prepare |
| 61 | return str_replace( |
| 62 | [' ', ' '], |
| 63 | ' ', |
| 64 | implode(' ', $sql) |
| 65 | ); |
| 66 | } |
| 67 | } |
| 68 |