Public Member Functions | |
buildQuerySQL ($dataObj) | |
buildUpdateSQL ($dataObj) | |
buildUpdateSQLwithCondition ($dataObj, $setValue, $condition=null) | |
buildDeleteSQL ($dataObj) | |
buildDeleteSQLwithCondition ($dataObj, $condition=null) | |
buildInsertSQL ($dataObj, $joinValues=null) | |
Static Public Member Functions | |
static | instance () |
Protected Member Functions | |
getDataSqlObj () | |
getNewDataSqlObj () |
Definition at line 25 of file BizDataObj_SQLHelper.php.
buildDeleteSQL | ( | $ | dataObj ) |
Build delete-sql DELETE FROM table WHERE idcol1='id1' AND idcol2='id2'
BizDataObj | $dataObj |
Definition at line 281 of file BizDataObj_SQLHelper.php.
buildInsertSQL | ( | $ | dataObj, |
$ | joinValues = null |
||
) |
Build insert-sql INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....)
BizDataObj | $dataObj | |
array | $joinValues | array of join values |
Definition at line 339 of file BizDataObj_SQLHelper.php.
buildQuerySQL | ( | $ | dataObj ) |
Build the Select SQL statement based on the fields and search/sort rule
BizDataObj | $dataObj |
Definition at line 81 of file BizDataObj_SQLHelper.php.
buildUpdateSQL | ( | $ | dataObj ) |
Build update sql UPDATE table SET col1=val1, col2=val2 ... WHERE idcol1='id1' AND idcol2='id2'
BizDataObj | $dataObj |
Definition at line 175 of file BizDataObj_SQLHelper.php.
getDataSqlObj | ( | ) | [protected] |
Get curent BizDataSql object, if object=null, create new object
Definition at line 56 of file BizDataObj_SQLHelper.php.
getNewDataSqlObj | ( | ) | [protected] |
Get new BizDataSql object and store on internal variable (current object)
Definition at line 68 of file BizDataObj_SQLHelper.php.
static instance | ( | ) | [static] |
Get the singleton instance
Definition at line 44 of file BizDataObj_SQLHelper.php.