Detailed Description
Definition at line 24 of file BizDataSql.php.
Member Function Documentation
addAssociation |
( |
$ |
assoc ) |
|
Add association in the SQL
- Parameters:
-
array | $assoc | additional SQL statment |
- Returns:
- void
Definition at line 221 of file BizDataSql.php.
addJoinTable |
( |
$ |
tableJoin ) |
|
Add a join table in the sql statement Ti alias
SELECT T1.col, T2.col
FROM table1 T1
INNER JOIN table2 T2 ON T1.col1=T2.col1
LEFT JOIN table3 T3 ON T1.col1=T3.col1
WHERE
- Parameters:
-
- Returns:
- void
Definition at line 65 of file BizDataSql.php.
addMainTable |
( |
$ |
mainTable ) |
|
Add main table in the sql statement T0 alias
- Parameters:
-
string | $mainTable | main table name |
- Returns:
- void
Definition at line 46 of file BizDataSql.php.
Add order by clause
- Parameters:
-
string | $orderBy | SQL ORDER BY clause |
- Returns:
- void
Definition at line 181 of file BizDataSql.php.
addOtherSQL |
( |
$ |
otherSQL ) |
|
Add other SQL clause
- Parameters:
-
string | $otherSQL | additional SQL statment |
- Returns:
- void
Definition at line 201 of file BizDataSql.php.
addSqlExpression |
( |
$ |
sqlExpr, |
|
|
$ |
alias = null |
|
) |
| |
Add SQL expression in the sql statement sqlExpr has format of "...join1.column1, ... join2.column2...". Replace join with alias
- Parameters:
-
string | $sqlExpr | sql expression |
string | $alias | sql alias |
- Returns:
- void
Definition at line 105 of file BizDataSql.php.
addSqlWhere |
( |
$ |
sqlWhere ) |
|
Add the where clause (search rule) into the SQL statement
- Parameters:
-
string | $sqlWhere | SQL WHERE clause |
- Returns:
- void
Definition at line 161 of file BizDataSql.php.
addTableColumn |
( |
$ |
join, |
|
|
$ |
column, |
|
|
$ |
alias = null |
|
) |
| |
Add a join table and cloumn in the sql statement
- Parameters:
-
string | $join | table join name |
string | $column | column name |
- Returns:
- void
Definition at line 87 of file BizDataSql.php.
Get join table alias
- Parameters:
-
- Returns:
- string join table alias
Definition at line 121 of file BizDataSql.php.
Get the SQL statement
- Returns:
- string SQL statement
Definition at line 285 of file BizDataSql.php.
getTableColumn |
( |
$ |
join, |
|
|
$ |
col |
|
) |
| |
Get table column, combine a table with a column.
- Parameters:
-
string | $join | join name |
string | $col | column |
- Returns:
- string table column combination string
Definition at line 136 of file BizDataSql.php.
The documentation for this class was generated from the following file: