Class DBMS_FIELD_TIMESTAMP

Handles mySQL Timestamps Columns

• author: Peter Krebs <p.krebs@lvus.at>
• version: pk-05-06-30
• copyright: (c) 2002-2005 by LVUS <http://www.lvus.at>
• project: Open CSP-Management
• license: GNU Public License

Located in /db/frmClasses/DBMS_FIELD_TIMESTAMP.phpclass (line 34)

DBMS_FIELD
   |
   --DBMS_FIELD_DATE
      |
      --DBMS_FIELD_TIMESTAMP

mixed $className = "Timestamp" (line 35)

string $classSrcFile = __FILE__ (line 43)

source file of the class

• since: pk-05-01-20

---

Redefinition of:

DBMS_FIELD_DATE::$classSrcFile

source file of the class

Inherited Variables

Inherited from DBMS_FIELD_DATE

DBMS_FIELD_DATE::$fldDateformat
DBMS_FIELD_DATE::$fldTimeformat
DBMS_FIELD_DATE::$hideCalendarBtn
DBMS_FIELD_DATE::$lstDateformat
DBMS_FIELD_DATE::$lstTimeformat
DBMS_FIELD_DATE::$showDate
DBMS_FIELD_DATE::$showTime

Inherited from DBMS_FIELD

DBMS_FIELD::$addTag
DBMS_FIELD::$ajaxDebug
DBMS_FIELD::$ajaxNotifyLst
DBMS_FIELD::$allowNull
DBMS_FIELD::$dbDesc
DBMS_FIELD::$defaultValue
DBMS_FIELD::$enableCopy
DBMS_FIELD::$enableEdit
DBMS_FIELD::$enableEditIfEmpty
DBMS_FIELD::$enableNew
DBMS_FIELD::$errMsg
DBMS_FIELD::$exportCSV
DBMS_FIELD::$extConfOptions
DBMS_FIELD::$extJSxType
DBMS_FIELD::$fieldtd_add
DBMS_FIELD::$fldDbgGetValue
DBMS_FIELD::$fldDebug
DBMS_FIELD::$hideAddTag_ro
DBMS_FIELD::$hideCopy
DBMS_FIELD::$hideEdit
DBMS_FIELD::$hideNew
DBMS_FIELD::$hideReadOnly
DBMS_FIELD::$inputAdd
DBMS_FIELD::$isHidden
DBMS_FIELD::$isSearchable
DBMS_FIELD::$js_check
DBMS_FIELD::$label
DBMS_FIELD::$labelcol_hide
DBMS_FIELD::$labeltd_add
DBMS_FIELD::$lstColSpan
DBMS_FIELD::$lstDisableLinks
DBMS_FIELD::$lstLabel
DBMS_FIELD::$lstLink
DBMS_FIELD::$lstTDAdd
DBMS_FIELD::$lstWidth
DBMS_FIELD::$maxlength
DBMS_FIELD::$myAjaxObj
DBMS_FIELD::$myBlock
DBMS_FIELD::$myBlockId
DBMS_FIELD::$myControll
DBMS_FIELD::$myCurrentMode
DBMS_FIELD::$myDataArrName
DBMS_FIELD::$myDeleteFlag
DBMS_FIELD::$myDesc
DBMS_FIELD::$myDOMId
DBMS_FIELD::$myForm
DBMS_FIELD::$myFrmId
DBMS_FIELD::$myGrpKey
DBMS_FIELD::$myHelpUrl
DBMS_FIELD::$myModuleKey
DBMS_FIELD::$myName
DBMS_FIELD::$myTable
DBMS_FIELD::$myTableAlias
DBMS_FIELD::$myView
DBMS_FIELD::$nullErrMsg
DBMS_FIELD::$ps_defaultDataArrName
DBMS_FIELD::$regexcheck_pattern
DBMS_FIELD::$regexErrMsg
DBMS_FIELD::$searchGroup_allowAll
DBMS_FIELD::$showGroup
DBMS_FIELD::$showInList
DBMS_FIELD::$showQasHidden
DBMS_FIELD::$showQuery
DBMS_FIELD::$size
DBMS_FIELD::$sortOrder
DBMS_FIELD::$srcVersion
DBMS_FIELD::$tabIndex
DBMS_FIELD::$toolTip
DBMS_FIELD::$toolTipAsTitle
DBMS_FIELD::$trimValue

editTbl_getFieldEditArr (line 69)

returns an array of field to bie shown in the edit form by using editTbl_echoForm

the array is in the form:

1.  [_sectionName_]
2.       [TITLE] -> string
3.       [_rowName_]
4.          [FLDLAB]  (complete html code with <td></td>)
5.          [FLDVAL] (complete html code with <td></td>)

NOTE as this is not implemented in the whole classTree at the moment ensure all parents use editTbl_echoForm() in theire editTblForm otherwise you'll get a mismatch of field order

• since: pk-06-07-16

array editTbl_getFieldEditArr ([boolean $debug = FALSE])

• boolean $debug

---

Redefinition of:

DBMS_FIELD_DATE::editTbl_getFieldEditArr()

returns an array of field to bie shown in the edit form by using editTbl_echoForm

getDefaultValue (line 210)

returns the field default value

if $defaultValue !empty it is returned else getDbDefault is return

• version: pk-04-08-17

mixed getDefaultValue ([ $debug = FALSE])

• $debug

---

Redefinition of:

DBMS_FIELD_DATE::getDefaultValue()

returns the field default value if parent::getDefaultValue() includes "NOW()" current date and time is set

getFieldTag (line 159)

returns the html code for the field value input / show adds $this->myName to ${$this->myDataArrName}['_DBMS_FIELDS']

• version: pk-05-09-05
• version: pk-06-01-09
• since: pk-04-12-29

string getFieldTag (int $mode, [mixed $aValue = NULL], [boolean $debug = FALSE])

• int $mode
• mixed $aValue
• boolean $debug

---

Redefinition of:

DBMS_FIELD::getFieldTag()

returns the html code for the field value input / show adds $this->myName to ${$this->myDataArrName}['_DBMS_FIELDS']

getTSDate (line 118)

converts a timestamp into a date object

if $aValue is an array pcf_Date::setFromArray() is called to transform to a date if $aValue is doubleval pcf_Date::setMySqlTimeStamp() is called

pcf_Date getTSDate (mixed $aValue, [boolean $debug = FALSE])

• mixed $aValue
• boolean $debug

getValue (line 237)

returns the field value

• version: pk-03-12-13
• version: pk-06-08-18
• todo: DBMS_FIELD_TIMESTAMP::getValue() returns MySQL Timestamp format
• since: pk-03-12-13

string getValue (string $aValue,  &$err, [string $arrName = "DBVAL"], [bool $debug = FALSE], array $err)

• string $aValue: the value
• array $err: error array
• string $arrName: name of the array to access fieldsarray gloabl ${$arrName}
• bool $debug
• &$err

---

Redefinition of:

DBMS_FIELD_DATE::getValue()

returns the field value

searchWhere (line 270)

get a where clause for the search settings

$aArr array post values of the serach form return string where clause

void searchWhere ( $aArr, [ $debug = FALSE])

• $aArr
• $debug

---

Redefinition of:

DBMS_FIELD_DATE::searchWhere()

get a where clause for the search settings

slashedValue (line 259)

add slashes to the value to add it to a sql command

NOTE allways returns DB Now statement

• version: pk-03-12-13

string slashedValue (string $aValue,  &$err, [string $arrName = "DBVAL"], [bool $debug = FALSE], array $err)

• string $aValue: the value
• array $err: error array
• string $arrName: name of the global array to access field gloabl ${$arrName}
• bool $debug
• &$err

---

Redefinition of:

DBMS_FIELD_DATE::slashedValue()

returns the value with slashes create use in a db statement

Inherited Methods

Inherited From DBMS_FIELD_DATE

DBMS_FIELD_DATE::editTblForm()
DBMS_FIELD_DATE::editTbl_getFieldEditArr()
DBMS_FIELD_DATE::fldTypeIsUseable()
DBMS_FIELD_DATE::getDateObj()
DBMS_FIELD_DATE::getDefaultValue()
DBMS_FIELD_DATE::getInputTag()
DBMS_FIELD_DATE::getListValue()
DBMS_FIELD_DATE::getScreenValue()
DBMS_FIELD_DATE::getSearchCompTypes()
DBMS_FIELD_DATE::getValue()
DBMS_FIELD_DATE::save()
DBMS_FIELD_DATE::searchWhere()
DBMS_FIELD_DATE::slashedValue()

Inherited From DBMS_FIELD

DBMS_FIELD::DBMS_FIELD()
DBMS_FIELD::allowNull()
DBMS_FIELD::check()
DBMS_FIELD::editLst_getAdminLstStyle()
DBMS_FIELD::editLst_getClassSelectOptions()
DBMS_FIELD::editTblForm()
DBMS_FIELD::editTbl_echoForm()
DBMS_FIELD::editTbl_getForm()
DBMS_FIELD::fldTypeIsUseable()
DBMS_FIELD::getAddTag()
DBMS_FIELD::getBlockId()
DBMS_FIELD::getDataArrName()
DBMS_FIELD::getDBColName()
DBMS_FIELD::getDBColType()
DBMS_FIELD::getDbDefault()
DBMS_FIELD::getdbDesc()
DBMS_FIELD::getDebugMode()
DBMS_FIELD::getDefaultValue()
DBMS_FIELD::getFieldRow()
DBMS_FIELD::getFieldRowCols()
DBMS_FIELD::getFieldTag()
DBMS_FIELD::getFrmId()
DBMS_FIELD::getInputTag()
DBMS_FIELD::getKey()
DBMS_FIELD::getLabel()
DBMS_FIELD::getLabelColTag()
DBMS_FIELD::getListLink()
DBMS_FIELD::getListLinkArr()
DBMS_FIELD::getListValue()
DBMS_FIELD::getLstColSpan()
DBMS_FIELD::getLstLabel()
DBMS_FIELD::getLstWidth()
DBMS_FIELD::getModuleKey()
DBMS_FIELD::getMyBlock()
DBMS_FIELD::getMyForm()
DBMS_FIELD::getMyFormName()
DBMS_FIELD::getName()
DBMS_FIELD::getObjectData()
DBMS_FIELD::getObjectVars()
DBMS_FIELD::getOrderNr()
DBMS_FIELD::getScreenValue()
DBMS_FIELD::getSetting()
DBMS_FIELD::getShowGroup()
DBMS_FIELD::getSize()
DBMS_FIELD::getSourceFile()
DBMS_FIELD::getTabIndex()
DBMS_FIELD::getTable()
DBMS_FIELD::getTblAlias()
DBMS_FIELD::getToolTip()
DBMS_FIELD::getType()
DBMS_FIELD::getValId()
DBMS_FIELD::get_lstTDAdd()
DBMS_FIELD::incOrderNr()
DBMS_FIELD::isAutoInc()
DBMS_FIELD::isEnabled()
DBMS_FIELD::isHidden()
DBMS_FIELD::isLayoutFld()
DBMS_FIELD::isMarkedDeleted()
DBMS_FIELD::isPrimaryKey()
DBMS_FIELD::isReadOnlyShown()
DBMS_FIELD::isSearchable()
DBMS_FIELD::isToShow()
DBMS_FIELD::labelIsHidden()
DBMS_FIELD::lstLinksDisabled()
DBMS_FIELD::markDeleted()
DBMS_FIELD::markUnDeleted()
DBMS_FIELD::save()
DBMS_FIELD::setDataArrName()
DBMS_FIELD::setdbDesc()
DBMS_FIELD::setFieldVar()
DBMS_FIELD::setFrmId()
DBMS_FIELD::setHidden()
DBMS_FIELD::setLabel()
DBMS_FIELD::setModuleKey()
DBMS_FIELD::setMyBlock()
DBMS_FIELD::setMyForm()
DBMS_FIELD::setName()
DBMS_FIELD::setObjectVars()
DBMS_FIELD::setObjVarsFrom()
DBMS_FIELD::setOrderNr()
DBMS_FIELD::setShown()
DBMS_FIELD::setTable()
DBMS_FIELD::setTblAlias()
DBMS_FIELD::showInList()