Свойство | Тип | Описание | |
---|---|---|---|
$allowedJoins | boolean | Allowed JOIN keywords | |
$distinct | boolean | Distinct keyword | |
$functions | boolean | SQL functions | |
$groupBy | string | GROUP BY value | |
$having | HAVING predicate object | ||
$joins | array | JOIN clauses | |
$where | WHERE predicate object |
Метод | Описание | |
---|---|---|
distinct ( ) : |
Set the DISTINCT keyword | |
groupBy ( mixed $by ) : |
Set the GROUP BY value | |
having ( ) : |
Set the HAVING clause | |
join ( mixed $tableToJoin, mixed $commonColumn, string $typeOfJoin = 'JOIN' ) : |
Set the JOIN clause | |
render ( ) : string | Render the SELECT statement | |
where ( boolean $reset = false ) : |
Set the WHERE clause |
Метод | Описание | |
---|---|---|
getLimitAndOffset ( ) : array | Method to get the limit and offset |
protected getLimitAndOffset ( ) : array | ||
Результат | array |
protected static bool $allowedJoins | ||
Результат | boolean |
protected static bool $functions | ||
Результат | boolean |
protected Predicate,Pop\Db\Sql $having | ||
Результат |