-
$dbConnId
-
-
$dbdatabase
-
-
$dbhost
-
-
$dbinitcmd
-
-
$dbisInit
-
-
$dbpasswd
-
-
$dbTableDefinitions
-
array of already seen tables definitions
-
$dbTableDefinitions
-
array of already seen tables definitions
-
$dbuser
-
-
$debugInsert
-
var boolean $debugInsert
-
db.phpinc
-
-
DBMS_SIMPLETREE.phpclass
-
-
DBMS_TABLEOBJ.phpclass
-
-
DBMS_TREE.phpclass
-
-
DBMS_TREE_NODE.phpclass
-
-
dbDelete
-
-
dbDelete
-
deletes the row from the database
-
dbGetDataArray
-
returns the the data array of a joins to the current row
-
dbGetForm
-
returns a database form
-
dbInsert
-
inserts a new row to the table
-
dbInsert
-
inserts a new row to the table
-
DBMS_FLDTYPE_DATE
-
-
DBMS_FLDTYPE_DATETIME
-
-
DBMS_FLDTYPE_FLOAT
-
-
DBMS_FLDTYPE_INT
-
-
DBMS_FLDTYPE_STRING
-
-
DBMS_FLDTYPE_TEXT
-
-
DBMS_FLDTYPE_TIME
-
-
DBMS_FLDTYPE_TIMESTAMP
-
-
DBMS_FLDTYPE_UNKNOWN
-
-
DBMS_SIMPLETREE
-
openCSP class DBMS_SIMPLETREE
-
DBMS_TABLEOBJ
-
Base class DBMS_TABLEOBJ to handel table data in an object
-
DBMS_TABLEOBJ
-
constructor
-
DBMS_TREE
-
ABSTRACT class DBMS_TREE to handel table tree data in an object
-
DBMS_TREE
-
-
DBMS_TREE_NODE
-
Base class DBMS_TABLEOBJ to handel table data in an object
-
DBMS_TREE_NODE
-
-
dbPopulate
-
populates the object values form the database
-
dbReplace
-
replaces a row in the table
-
dbReplace
-
replaces a row in the table
-
dbSave
-
save the Object
-
dbSave
-
save the Object if $this->autoIncFld is not empty
-
DB_ORA
-
ORACLE database connection class
-
DB_ORA
-
-
db_SetKey
-
-
db_SetKeyArray
-
sets an array with keys
-
DB_UPDATE_backup
-
-
DB_UPDATE_backupTable
-
backups a table with serialized arrays
-
DB_UPDATE_checkForm
-
checks a form and adds fields if not in the form
-
DB_UPDATE_execCmd
-
-
DB_UPDATE_execScript
-
executs a sql script file
-
DB_UPDATE_setVersion
-
stores the new version of table in the database and clears $GLOBALS['PROJECT']['OBJCACHEPATH']
-
debugMyTree
-
outputs debug information about the global tree array
-
deleteArray
-
deletes an existing row where $valueArr are conditions
-
deleteArray
-
deletes an existing row where the primary key must be set in $valueArr
-
deleteArray
-
deletes an existing row where the primary key must be set in $valueArr
-
deleteRows
-
deletes a row form the database note delKeys must have at least one key => value element
-
disconnect
-
-
disconnect
-
disconnect from the database
-
getAllInstances
-
returns an array with all populated instances
-
getArray
-
generates a query and returns an array of the resultset
-
getArray
-
generates a query and returns an array of the resultset
-
getArray
-
generates a query and returns an array of the resultset
-
getArray
-
generates a query and returns an array of the resultset
-
getChild
-
-
getChildQueryString
-
returns the select statement to get the children
-
getChildrenCursor
-
opens a course to fetch node objects under the root (1st level)
-
getChildrenList
-
-
getChildrenList
-
returns a array of pointers to the child objects
-
getChildrenTag
-
returns the html code for the subtree if $this->myFilterArr is array only children matching the filter are shown
-
getChildrenTagTmpl
-
returns the html code for the subtree if $this->myFilterArr is array only children matching the filter are shown
-
getChildTblName
-
-
getClassInclude
-
returns the class source file if $this->classSrcFile is set
-
getColumnDef
-
returns the database column definition to use in create table or alter column
-
getControll
-
-
getControllObj
-
instantiates a new class if $this->myControll not type of $contrClass
-
getDbDesc
-
returns the dbDesc array ($this->myFields);
-
getDBField
-
returns the value of a db column
-
getDBRow
-
returns a field => value array
-
getDBRow
-
returns a field => value array
-
getDBTblColNames
-
returns an array of table column names
-
getDBTblDesc
-
returns an array with column description arrays for each column where column name is the array index
-
getDBTblDesc
-
returns an array with column description arrays for each column where column name is the array index
-
getDBTblList
-
returns an array with all tables in the database
-
getDBTblList
-
returns an array with all tables in the database
-
getDBType
-
returns the dbType
-
getDBType
-
returns the database type
-
getDBType
-
returns the dbType
-
getDBVal
-
returns a field => value array for dbms
-
getDefaults
-
returns an array of db default values
-
getDefaults
-
returns an array of db default values
-
getEmptyTblArr
-
-
getError
-
-
getErrorMsg
-
-
getErrorMsg
-
returns the last mySQL error message
-
getErrorNo
-
returns the last mySQL error nr
-
getFieldDBDefault
-
returns the db default value for aField
-
getFilteredChildrenList
-
returns a array of pointers to childs matching $myFilterArr
-
getForm
-
replaces dbGetForm and returns a OCSP_FORM
-
getFormClassName
-
returns the form class name to use
-
getFormCmdFields
-
add some values to the forms (hidden) command fields
-
getFormName
-
returns the required form name
-
getGlobalTreeKey
-
returns the GlobalTreeKey
-
getGlobalTreeKey
-
returns the GlobalTreeKey
-
getId
-
returns the id
-
getId
-
returns the id
-
getIndexedArray
-
generates a query and returns an array of the resultset with $idxCol as index and $valCols as values
-
getIndexedTreeArr
-
returns an array sorted as tree the index is like [1] [1.1] [1.2] [2] [2.1] ....
-
getInstance
-
returns the instance with id $aId
-
getJSON
-
returns a json string for the object data
-
getKey
-
gets a child key
-
getKeyArr
-
returns the key array an array of all key fields
-
getKeyTree
-
returns the key tree [PARENT][ID]=>array()
-
getKeyTreeNode
-
returns a node in the key tree to store more information to the keytree overwrite this in
-
getLevel
-
returns the Level
-
getLinkUrl
-
returns the link url
-
getListControll
-
if $contrClass is not set to "NO" a controll object will be created if none exists ($this->myControll) is empty
-
getListView
-
-
getMyConfFile
-
can also be called without object OCSP_DB::getMyConfFile() if $this->myConfFile is empty the global dbConffile is returned
-
getMyDBName
-
-
getMyTable
-
returns the table name
-
getName
-
-
getNode
-
get a node if the
-
getNodeDBRowFromDB
-
selects a node row from the database and returns the DB Values as array with quickQuery to the database object
-
getNodeObjectFromCache
-
-
getNodeTag
-
returns the htmlcode for the node
-
getNodeTagTmpl
-
returns the html code for the nodetemplate
-
getObjValArray
-
returns the object value array
-
getObjValValue
-
returns an object value value
-
getOne
-
Runs the query provided and returns the data from the first column of the first row then frees the result set.
-
getOrderNr
-
returns the orderNr
-
getParentId
-
returns the parent id
-
getParentId
-
returns the parent id
-
getParentObj
-
returns the parent object or null if parent is root
-
getPopulateTs
-
returns the populate timestamp if it returns 0 the object has not been populated which means not that it is empty
-
getPrimaryKeys
-
returns an array with all primary key column names
-
getQueryArray
-
returns an array with the main parts of an select the returned array has the following indexes
-
getResultArray
-
-
getRootId
-
returns the tree root id
-
getRootNode
-
returns the root node
-
getRootPath
-
returns a array back to the root (same as DBMS_TREE->getRootPath) but the tree is not populated saves time and space
-
getRootPath
-
returns an array of pointers to the elements till root with all
-
getRootPathIdx
-
returns the index of the node in the root path
-
getRow
-
returns the first row matching $filter
-
getSubmitAction
-
get main commands for the form
-
getTableDesc
-
-
getTableFields
-
-
getTableList
-
-
getTimeStamp
-
returns the linux timestamp (mktime) of a date column
-
getTree
-
returns myTree object
-
getTreeArray
-
returns a pointers to the global tree array
-
getView
-
-
getViewObj
-
instantiates a new class if $this->myControll not type of $contrClass
-
getWhere
-
generates a where clause to select the object identfied by DBMS_TBLOBJ::myKeys
-
qs_getDateStmt
-
returns a Date object in string representation
-
qs_getLikeStmt
-
returns a sql statement for use in search
-
qs_getLikeStmt
-
returns a sql statement for use in search
-
qs_getNowStmt
-
returns the db NOW() statement for date/time values
-
qs_getNullStmt
-
returns the db NULL statement for NULL values
-
qs_getPassword
-
returns a password command $aValue
-
qs_getSlashedValue
-
returns $aValue with slashes to use to create query strings
-
qs_getSlashedValue
-
returns $aValue with slashes to use to create query strings
-
qs_getSlashedValue
-
replaces ' with ''
-
qs_getSlashedValue
-
returns $aValue with slashes to use to create query strings
-
qs_getWhereClause
-
returns the where clause for a select
-
qs_getWhereIn
-
returns WHERE col IN($valArr)
-
qs_getWhereIn
-
returns WHERE col IN($valArr)
-
qs_ifNullStmt
-
returns the db IFNULL/nvl statement
-
query
-
-
query
-
opens a cursor for a query
-
query
-
opens a cursor for a query
-
queryArray
-
returns an array of table rows
-
queryArray
-
returns an array of table rows
-
quickQuery
-
returns (a column) of the first row match
-
quickQuery
-
returns (a column) of the first row match
-
quickQuery
-
returns (a column) of the first row match
-
$staticClassVars
-
-
saveLinkedRow
-
saves a linked row due to $cmd
-
saveLinkedTableRows
-
handels linked tables after insert
-
saveObjVals
-
saves the object values
-
server_info
-
returns the mysql server info()
-
setChanged
-
sets the changed flag ($this->valChangeTS > $this-populateTS)
-
setChildClassVar
-
sets child class vars
-
setChildClassVar
-
sets child class vars
-
setConfigurationArr
-
sets configuration attributes (if not set) out of an array
-
setControll
-
sets a controll
-
setDBField
-
sets the value of a object var (DB COLUMN)
-
setDBFieldIfDiff
-
sets the value of an object var (DB COLUMN) if it differs with $aValue
-
setDBFieldIfEmpty
-
sets the value of an column if it is empty or not set
-
setDBRow
-
sets a database row to the object fields
-
setDBRow
-
sets a database row to the object fields
-
setDBVal
-
sets all fields of an array to the objcet
-
setDefaults
-
sets the database default values to the fields
-
setError
-
sets an error cmd
-
setGlobalTreeKey
-
sets the GlobalTreeKey
-
setId
-
sets the id
-
setKey
-
sets a child key
-
setKeyTree
-
sets the key tree
-
setLevel
-
sets the Level
-
setLink
-
sets the link url for the output
-
setLinkedTableRow
-
sets the row of an other table
-
setLinkedTableRow
-
sets the row of an other table
-
setMyTable
-
sets the table name an recals init if $this->myTable != $aTablName
-
setObjValArray
-
sets an array of values as object values
-
setObjValValue
-
sets an object value value
-
setObjVarIfEmpty
-
sets an object var if it's empty or null NOTE the object var has to be set already NOTE does not set the changed flag
-
setOrderNr
-
sets the OrderNr
-
setParentId
-
sets the parent id
-
setParentObj
-
-
setRootId
-
sets the tree root id
-
setSubmitAction
-
sets a main cmmonad of the form
-
setTreeObj
-
sets the tree object
-
setUnChanged
-
clears the changed flag
-
storebasket.phpinc
-