• Главная
• NilPortugues
• Sql
• QueryBuilder
• Manipulation
• Select

PHP Класс NilPortugues\Sql\QueryBuilder\Manipulation\Select

Показать файл Открыть проект Примеры использования класса

Защищенные свойства (Protected)

Свойство	Тип	Описание
$camelCaseTableName	string
$columnQuery	NilPortugues\Sql\QueryBuilder\Manipulation\ColumnQuery
$groupBy	array
$having	NilPortugues\Sql\QueryBuilder\Syntax\Where
$havingOperator	string
$isDistinct	boolean
$joinQuery	JoinQuery
$parentQuery	ParentQuery
$table	NilPortugues\Sql\QueryBuilder\Syntax\Table
$where	NilPortugues\Sql\QueryBuilder\Syntax\Where

Открытые методы

Метод	Описание
__clone ( ) : Select	This __clone method will create an exact clone but without the object references due to the fact these are lost in the process of serialization and un-serialization.
__construct ( string $table = null, array $columns = null )
addJoin ( Select $select, string $selfColumn, string $refColumn ) : Select
count ( string $columnName = '*', string $alias = '' ) : NilPortugues\Sql\QueryBuilder\Manipulation\ColumnQuery
crossJoin ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [] ) : Select
distinct ( )
getAllColumns ( ) : array
getAllHavings ( ) : array
getAllJoins ( ) : array
getAllOrderBy ( ) : array
getAllWheres ( ) : array	Returns all the Where conditions to the BuilderInterface class in order to write the SQL WHERE statement.
getColumnFuncs ( ) : array
getColumnSelects ( ) : array
getColumnValues ( ) : array
getColumns ( ) : NilPortugues\Sql\QueryBuilder\Syntax\Column
getGroupBy ( ) : array
getHavingOperator ( ) : string
getJoinCondition ( ) : NilPortugues\Sql\QueryBuilder\Syntax\Where
getJoinType ( ) : string
getParentQuery ( ) : ParentQuery
groupBy ( array $columns )
having ( $havingOperator = 'AND' ) : NilPortugues\Sql\QueryBuilder\Syntax\Where
innerJoin ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [] ) : Select
isCount ( ) : boolean
isDistinct ( ) : boolean
isJoin ( boolean $isJoin = true ) : JoinQuery	Transforms Select in a joint.
isJoinSelect ( ) : boolean
join ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [], string $joinType = null ) : Select
joinCondition ( ) : NilPortugues\Sql\QueryBuilder\Syntax\Where	WHERE constrains used for the ON clause of a (LEFT/RIGHT/INNER/CROSS) JOIN.
leftJoin ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [] ) : Select
limit ( integer $start, $count )
on ( ) : NilPortugues\Sql\QueryBuilder\Syntax\Where	Alias to joinCondition.
orderBy ( string $column, string $direction = OrderBy::ASC, null $table = null )
partName ( ) : string
rightJoin ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [] ) : Select
setColumns ( array $columns ) : NilPortugues\Sql\QueryBuilder\Manipulation\ColumnQuery	Sets the column names used to write the SELECT statement.
setFunctionAsColumn ( string $funcName, array $arguments, string $alias ) : NilPortugues\Sql\QueryBuilder\Manipulation\ColumnQuery	Allows calculation on columns using predefined SQL functions.
setJoinType ( string | null $joinType )
setParentQuery ( Select $parentQuery )
setSelectAsColumn ( array $column ) : NilPortugues\Sql\QueryBuilder\Manipulation\ColumnQuery	Allows setting a Select query as a column value.
setValueAsColumn ( string $value, string $alias ) : NilPortugues\Sql\QueryBuilder\Manipulation\ColumnQuery	Allows setting a value to the select statement.

Защищенные методы

Метод	Описание
getAllOperation ( null | NilPortugues\Sql\QueryBuilder\Syntax\Where $data, string $operation ) : array

Описание методов

Описание свойств