## Class CFW_Data_Criteria

Description

SQLデータベース用検索条件

- author: okada

Located in /Data/Criteria.php (line 7)

Class Constant Summary
DIRECTION_ASC = "ASC"
DIRECTION_DESC = "DESC"
LIMIT_INFINITE = -1
OPERATOR_AND = "AND"
OPERATOR_BETWEEN = "BETWEEN"
OPERATOR_EQ = "="
OPERATOR_GE = ">="
OPERATOR_GT = ">"
OPERATOR_IN = "IN"
OPERATOR_LE = "<="
OPERATOR_LIKE = "LIKE"
OPERATOR_LT = "<"
OPERATOR_NE = "<>"
OPERATOR_NONE = ""
OPERATOR_NOT = "NOT"
OPERATOR_NOT_IN = "NOT IN"
OPERATOR_OR = "OR"
OPTION_DISTINCT = "DISTINCT"
Variable Summary
mixed $queryOption
array $_parameters
Method Summary
unknown_type __construct ()
unknown_type addGroupBy ($expr $expr)
unknown_type addHaving (CFW_Data_Criteria_Condition $condition, [string $operator = self::OPERATOR_AND])
unknown_type addHavingAnd (CFW_Data_Criteria_Condition $condition)
unknown_type addHavingOr (CFW_Data_Criteria_Condition $condition)
unknown_type addOrderBy ($expr $expr, [$direction $direction = "ASC"])
void addWhere (CFW_Data_Criteria_Condition $condition, [string $operator = self::OPERATOR_AND])
unknown_type addWhereAnd (CFW_Data_Criteria_Condition $condition)
unknown_type addWhereOr (CFW_Data_Criteria_Condition $condition)
unknown_type assemble ()
unknown_type assembleGroupBy ()
unknown_type assembleHaving ()
unknown_type assembleOrderBy ()
unknown_type assembleWhere ()
unknown_type getGroupByExpression ()
unknown_type getHavingExpression ()
unknown_type getLimit ()
unknown_type getOffset ()
unknown_type getOrderByExpression ()
unknown_type getOrderByReverseExpression ()
unknown_type getParameters ()
unknown_type getWhereExpression ()
unknown_type setLimit ($limit $limit)
unknown_type setOffset ($offset $offset)
unknown_type setQueryOption ($option $option)
Variables
mixed $queryOption (line 88)
array $_parameters (line 86)

$exprに対して設定されるパラメータ

Methods
Constructor __construct (line 93)

構築

- access: public

unknown_type __construct ()
addGroupBy (line 184)

グルーピング列追加

- access: public

unknown_type addGroupBy ($expr $expr)

- $expr $expr

addHaving (line 147)

集計抽出条件追加

- access: public

unknown_type addHaving (CFW_Data_Criteria_Condition $condition, [string $operator = self::OPERATOR_AND])

- CFW_Data_Criteria_Condition $condition: 検索条件
- string $operator: 追加するときの演算子

addHavingAnd (line 158)

集計抽出条件追加

- access: public

unknown_type addHavingAnd (CFW_Data_Criteria_Condition $condition)

- CFW_Data_Criteria_Condition $condition: 検索条件

addHavingOr (line 166)

集計抽出条件追加

- access: public

unknown_type addHavingOr (CFW_Data_Criteria_Condition $condition)

- CFW_Data_Criteria_Condition $condition: 検索条件

addOrderBy (line 176)

ソート列追加

- access: public

unknown_type addOrderBy ($expr $expr, [$direction $direction = "ASC"])

- $expr $expr
- $direction $direction: "ASC" or "DESC"

addWhere (line 116)

WHERE句に条件を追加

- access: public

void addWhere (CFW_Data_Criteria_Condition $condition, [string $operator = self::OPERATOR_AND])

- CFW_Data_Criteria_Condition $condition
- string $operator

addWhereAnd (line 128)

WHERE句にANDで条件追加

- access: public

unknown_type addWhereAnd (CFW_Data_Criteria_Condition $condition)

- CFW_Data_Criteria_Condition $condition: 検索条件

addWhereOr (line 137)

WHERE句にORで条件追加

- access: public

unknown_type addWhereOr (CFW_Data_Criteria_Condition $condition)

- CFW_Data_Criteria_Condition $condition: 検索条件

assemble (line 217)

条件を解析する

- access: public

unknown_type assemble ()
assembleGroupBy (line 259)

group by句の生成

unknown_type assembleGroupBy ()
assembleHaving (line 272)

having句の生成

unknown_type assembleHaving ()
assembleOrderBy (line 247)

order by句の生成

unknown_type assembleOrderBy ()
assembleWhere (line 228)

where句の生成

unknown_type assembleWhere ()
getGroupByExpression (line 323)

条件解析後の式を取得

- access: public

unknown_type getGroupByExpression ()
getHavingExpression (line 331)

条件解析後の式を取得

- access: public

unknown_type getHavingExpression ()
getLimit (line 339)

条件解析後の式を取得

- access: public

unknown_type getLimit ()
getOffset (line 347)

条件解析後の式を取得

- access: public

unknown_type getOffset ()
getOrderByExpression (line 298)

条件解析後の式を取得

- access: public

unknown_type getOrderByExpression ()
getOrderByReverseExpression (line 306)

条件解析後の式を取得(逆ソート)

- access: public

unknown_type getOrderByReverseExpression ()
getParameters (line 355)

この条件に設定されたパラメータを取得する

- access: public

unknown_type getParameters ()
getWhereExpression (line 291)

条件解析後の式を取得

- access: public

unknown_type getWhereExpression ()
setLimit (line 193)

読み取りサイズ 設定

- access: public

unknown_type setLimit ($limit $limit)

- $limit $limit

setOffset (line 201)

読み取り開始位置設定

- access: public

unknown_type setOffset ($offset $offset)

- $offset $offset

setQueryOption (line 209)

クエリーに付けるオプション

- access: public

unknown_type setQueryOption ($option $option)

- $option $option

Class Constants
DIRECTION_ASC = "ASC" (line 23)
DIRECTION_DESC = "DESC" (line 24)
LIMIT_INFINITE = -1 (line 26)
OPERATOR_AND = "AND" (line 20)
OPERATOR_BETWEEN = "BETWEEN" (line 18)
OPERATOR_EQ = "=" (line 9)
OPERATOR_GE = ">=" (line 13)
OPERATOR_GT = ">" (line 14)
OPERATOR_IN = "IN" (line 15)
OPERATOR_LE = "<=" (line 11)
OPERATOR_LIKE = "LIKE" (line 17)
OPERATOR_LT = "<" (line 12)
OPERATOR_NE = "<>" (line 10)
OPERATOR_NONE = "" (line 8)
OPERATOR_NOT = "NOT" (line 19)
OPERATOR_NOT_IN = "NOT IN" (line 16)
OPERATOR_OR = "OR" (line 21)
OPTION_DISTINCT = "DISTINCT" (line 27)

Documentation generated on Fri, 25 Dec 2009 22:44:33 +0900 by phpDocumentor 1.4.3