PHP Class NilPortugues\Sql\QueryBuilder\Manipulation\JoinQuery

Mostrar archivo Open project: nilportugues/sql-query-builder Class Usage Examples

Protected Properties

Property Type Description
$isJoin boolean
$joinCondition NilPortugues\Sql\QueryBuilder\Syntax\Where
$joinType string
$joins array
$select Select

Public Methods

Method Description
__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 )

Method Details

__construct() public method

public __construct ( Select $select )
$select Select

addJoin() public method

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

crossJoin() public method

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

getAllJoins() public method

public getAllJoins ( ) : array
return array

getJoinCondition() public method

public getJoinCondition ( ) : NilPortugues\Sql\QueryBuilder\Syntax\Where
return NilPortugues\Sql\QueryBuilder\Syntax\Where

getJoinType() public method

public getJoinType ( ) : string
return string

getJoins() public method

public getJoins ( ) : array
return array

innerJoin() public method

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

isJoin() public method

public isJoin ( ) : boolean
return boolean

isJoinSelect() public method

public isJoinSelect ( ) : boolean
return boolean

join() public method

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
return Select

joinCondition() public method

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

leftJoin() public method

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

on() public method

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

rightJoin() public method

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

setJoin() public method

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

setJoinCondition() public method

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

setJoinType() public method

public setJoinType ( string $joinType )
$joinType string

setJoins() public method

public setJoins ( array $joins )
$joins array

setTable() public method

public setTable ( string $table )
$table string

Property Details

$isJoin protected_oe property

protected bool $isJoin
return boolean

$joinCondition protected_oe property

protected Where,NilPortugues\Sql\QueryBuilder\Syntax $joinCondition
return NilPortugues\Sql\QueryBuilder\Syntax\Where

$joinType protected_oe property

protected string $joinType
return string

$joins protected_oe property

protected array $joins
return array

$select protected_oe property

protected Select,NilPortugues\Sql\QueryBuilder\Manipulation $select
return Select