SQL_Trait_Order
SQL_Trait_Order
SQLのORDER BY句を生成するためのトレイト
Table of Contents
Properties
- $_fdOrders : SQL_Field, values: array}|null
- $_orders : array<string|int, SQL_Field}>
Methods
- addOrder() : true
- 指定されたfieldでORDER BY句を生成する<br> $SQL->addOrder('entry_id', 'ASC', 'acms_entry');<br> ORDER BY acms_entry.entry_id ASC
- setFieldOrder() : void
- setOrder() : true
- 指定されたorderのSQLを生成する<br> $SQL->setOrder('entry_id', 'ASC', 'acms_entry');<br> LIMIT 10, 30
- order() : void
- Order句を生成する
Properties
$_fdOrders
public
SQL_Field, values: array}|null
$_fdOrders
= \null
$_orders
public
array<string|int, SQL_Field}>
$_orders
= []
Methods
addOrder()
指定されたfieldでORDER BY句を生成する<br> $SQL->addOrder('entry_id', 'ASC', 'acms_entry');<br> ORDER BY acms_entry.entry_id ASC
public
addOrder(SQL_Field|string $fd[, "ASC"|"DESC"|"asc"|"desc" $ord = 'ASC' ][, string|null $scp = null ]) : true
Parameters
- $fd : SQL_Field|string
- $ord : "ASC"|"DESC"|"asc"|"desc" = 'ASC'
- $scp : string|null = null
Return values
truesetFieldOrder()
public
setFieldOrder([SQL_Field|string|null $fd = null ][, array<string|int, mixed> $values = [] ][, string|null $scp = null ]) : void
Parameters
- $fd : SQL_Field|string|null = null
- $values : array<string|int, mixed> = []
- $scp : string|null = null
setOrder()
指定されたorderのSQLを生成する<br> $SQL->setOrder('entry_id', 'ASC', 'acms_entry');<br> LIMIT 10, 30
public
setOrder([SQL_Field|string|null $fd = null ][, "ASC"|"DESC"|"asc"|"desc" $ord = 'ASC' ][, string|null $scp = null ]) : true
Parameters
- $fd : SQL_Field|string|null = null
- $ord : "ASC"|"DESC"|"asc"|"desc" = 'ASC'
- $scp : string|null = null
Return values
trueorder()
Order句を生成する
protected
order(QueryBuilder $qb[, Dsn|null $dsn = null ]) : void
Parameters
- $qb : QueryBuilder
- $dsn : Dsn|null = null