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

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

보호된 프로퍼티들

프로퍼티 타입 설명
$isJoin boolean
$joinCondition NilPortugues\Sql\QueryBuilder\Syntax\Where
$joinType string
$joins array
$select Select

공개 메소드들

메소드 설명
__construct ( Select $select )
addJoin ( Select $select, string $selfColumn, string $refColumn ) : Select
crossJoin ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [] ) : Select
getAllJoins ( ) : array
getJoinCondition ( ) : NilPortugues\Sql\QueryBuilder\Syntax\Where
getJoinType ( ) : string
getJoins ( ) : array
innerJoin ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [] ) : Select
isJoin ( ) : boolean
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
on ( ) : NilPortugues\Sql\QueryBuilder\Syntax\Where Alias to joinCondition.
rightJoin ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [] ) : Select
setJoin ( boolean $isJoin = true ) Transforms Select in a joint.
setJoinCondition ( NilPortugues\Sql\QueryBuilder\Syntax\Where $joinCondition )
setJoinType ( string $joinType )
setJoins ( array $joins )
setTable ( string $table )

메소드 상세

__construct() 공개 메소드

public __construct ( Select $select )
$select Select

addJoin() 공개 메소드

public addJoin ( Select $select, string $selfColumn, string $refColumn ) : Select
$select Select
$selfColumn string
$refColumn string
리턴 Select

crossJoin() 공개 메소드

public crossJoin ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [] ) : Select
$table string
$selfColumn string
$refColumn string
$columns string[]
리턴 Select

getAllJoins() 공개 메소드

public getAllJoins ( ) : array
리턴 array

getJoinCondition() 공개 메소드

public getJoinCondition ( ) : NilPortugues\Sql\QueryBuilder\Syntax\Where
리턴 NilPortugues\Sql\QueryBuilder\Syntax\Where

getJoinType() 공개 메소드

public getJoinType ( ) : string
리턴 string

getJoins() 공개 메소드

public getJoins ( ) : array
리턴 array

innerJoin() 공개 메소드

public innerJoin ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [] ) : Select
$table string
$selfColumn string
$refColumn string
$columns string[]
리턴 Select

isJoin() 공개 메소드

public isJoin ( ) : boolean
리턴 boolean

isJoinSelect() 공개 메소드

public isJoinSelect ( ) : boolean
리턴 boolean

join() 공개 메소드

public join ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [], string $joinType = null ) : Select
$table string
$selfColumn string
$refColumn string
$columns string[]
$joinType string
리턴 Select

joinCondition() 공개 메소드

WHERE constrains used for the ON clause of a (LEFT/RIGHT/INNER/CROSS) JOIN.
public joinCondition ( ) : NilPortugues\Sql\QueryBuilder\Syntax\Where
리턴 NilPortugues\Sql\QueryBuilder\Syntax\Where

leftJoin() 공개 메소드

public leftJoin ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [] ) : Select
$table string
$selfColumn string
$refColumn string
$columns string[]
리턴 Select

on() 공개 메소드

Alias to joinCondition.
public on ( ) : NilPortugues\Sql\QueryBuilder\Syntax\Where
리턴 NilPortugues\Sql\QueryBuilder\Syntax\Where

rightJoin() 공개 메소드

public rightJoin ( string $table, string $selfColumn = null, string $refColumn = null, string[] $columns = [] ) : Select
$table string
$selfColumn string
$refColumn string
$columns string[]
리턴 Select

setJoin() 공개 메소드

Transforms Select in a joint.
public setJoin ( boolean $isJoin = true )
$isJoin boolean

setJoinCondition() 공개 메소드

public setJoinCondition ( NilPortugues\Sql\QueryBuilder\Syntax\Where $joinCondition )
$joinCondition NilPortugues\Sql\QueryBuilder\Syntax\Where

setJoinType() 공개 메소드

public setJoinType ( string $joinType )
$joinType string

setJoins() 공개 메소드

public setJoins ( array $joins )
$joins array

setTable() 공개 메소드

public setTable ( string $table )
$table string

프로퍼티 상세

$isJoin 보호되어 있는 프로퍼티

protected bool $isJoin
리턴 boolean

$joinCondition 보호되어 있는 프로퍼티

protected Where,NilPortugues\Sql\QueryBuilder\Syntax $joinCondition
리턴 NilPortugues\Sql\QueryBuilder\Syntax\Where

$joinType 보호되어 있는 프로퍼티

protected string $joinType
리턴 string

$joins 보호되어 있는 프로퍼티

protected array $joins
리턴 array

$select 보호되어 있는 프로퍼티

protected Select,NilPortugues\Sql\QueryBuilder\Manipulation $select
리턴 Select