• 홈
• NilPortugues
• Sql
• QueryBuilder
• Manipulation
• Select

PHP 클래스 NilPortugues\Sql\QueryBuilder\Manipulation\Select

파일 보기 프로젝트 열기: nilportugues/sql-query-builder 1 사용 예제들

보호된 프로퍼티들

프로퍼티	타입	설명
$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

메소드 상세

프로퍼티 상세