BuildDeleteSQL [line 277]
Build delete-sql DELETE FROM table WHERE idcol1='id1' AND idcol2='id2'
Parameters:
API Tags:
BuildDeleteSQLforTableJoin [line 293]
array BuildDeleteSQLforTableJoin(
BizDataObj $dataObj
)
|
|
Build delete-SQL for table join
NOTE: Added by Jixian on 2009-02-16 for implement onSaveDataObj
Parameters:
API Tags:
BuildInsertSQL [line 319]
string BuildInsertSQL(
BizDataObj $dataObj, [ $joinValues = null]
)
|
|
Build insert-sql INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....)
Parameters:
API Tags:
| Return: | Insert-SQL statement |
BuildInsertSQLforTableExtension [line 439]
array BuildInsertSQLforTableExtension(
BizDataObj $dataObj
)
|
|
Build insert-SQL for table extension
NOTE: Added by Jixian on 2009-02-23 for implement onSaveDataObj
Parameters:
API Tags:
BuildInsertSQLforTableJoin [line 381]
array BuildInsertSQLforTableJoin(
BizDataObj $dataObj
)
|
|
Build insert-SQL for table join
NOTE: Added by Jixian on 2009-02-16 for implement onSaveDataObj
Parameters:
API Tags:
BuildUpdateSQL [line 154]
mixed BuildUpdateSQL(
mixed $dataObj, BizDataObj $dataobj
)
|
|
Build update sql UPDATE table SET col1=val1, col2=val2 ...
WHERE idcol1='id1' AND idcol2='id2'
Parameters:
BuildUpdateSQLforTableJoin [line 217]
array BuildUpdateSQLforTableJoin(
BizDataObj $dataObj
)
|
|
Build update-SQL for table join
NOTE: Added by Jixian on 2009-02-16 for implement onSaveDataObj
Parameters:
API Tags:
RuleToSql [line 495]
string RuleToSql(
BizDataObj $dataObj, string $rule
)
|
|
Convert search/sort rule to sql clause, replace [fieldName] with table.column openbiz SQL expression as : "[fieldName] opr 'Value' AND/OR [fieldName] opr 'Value'...". "()" is valid syntax
Parameters:
|
BizDataObj |
$dataObj: |
|
|
string |
$rule: |
"[fieldName] ..." |
API Tags:
substr_lr [line 599]
string substr_lr(
mixed &$str, mixed $left, mixed $right, mixed &$startpos, [mixed $findfirst = false]
)
|
|
substr_lr() - help function (helper).
Get the sub string whose left and right boundary character is $left and $right. The search is in $str, starting from position of $startpos. If $findfirst is true, $left must be the charater on the $startpos.
_compKeyRuleToSql [line 543]
string _compKeyRuleToSql(
string $compColumn, string $compValue
)
|
|
Parameters:
|
string |
$compColumn: |
|
|
string |
$compValue: |
|
API Tags:
| Return: | SQL rule statement |
_convertSqlExpression [line 569]
string _convertSqlExpression(
BizDataObj $dataObj, string $sqlExpr
)
|
|
Convert Sql Expression Replace [field name] in the SQL expression with table_alias.column
Parameters:
|
BizDataObj |
$dataObj: |
- the instance of BizDataObj |
|
string |
$sqlExpr: |
- SQL expression supported by the database engine. The syntax is FUNC([FieldName1]...[FieldName2]...) |
API Tags:
| Return: | real sql expression with column names |
