Class DBMS_FIELD_DATE

• author: Peter Krebs <pitlinz@users.sourceforge.net>
• version: pk-05-06-30
• project: Open CSP-Management
• license: GNU Public License

Located in /db/frmClasses/DBMS_FIELD_DATE.phpclass (line 33)

DBMS_FIELD
   |
   --DBMS_FIELD_DATE

string $classSrcFile = __FILE__ (line 40)

source file of the class

• since: pk-05-01-20

---

Redefinition of:

DBMS_FIELD::$classSrcFile

source file of the class

---

Redefined in descendants as:

• DBMS_FIELD_LINUXTIMESTAMP::$classSrcFile : source file of the class
• DBMS_FIELD_TIMESTAMP::$classSrcFile : source file of the class

string $fldDateformat = 'd.m.Y ' (line 67)

• var: format string for fields
• since: pk-04-07-29

string $fldTimeformat = 'H:i:s' (line 61)

• var: format string for fields
• since: pk-04-07-29

boolean $hideCalendarBtn = FALSE (line 75)

• since: pk-05-06-30

string $lstDateformat = 'd.m.Y ' (line 55)

• var: format string for list entries
• since: pk-04-07-29

string $lstTimeformat = 'H:i:s' (line 49)

• var: format string for list entries
• since: pk-04-07-29

mixed $showDate = TRUE (line 42)

mixed $showTime = FALSE (line 43)

Inherited Variables

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

editTblForm (line 197)

show the filed definition form

• version: pk-05-06-30
• deprecated: since pk-06-07-16

void editTblForm ([bool $showSize = TRUE], [bool $showNull = TRUE])

• bool $showSize: show size input
• bool $showNull: show input field to handle null values

---

Redefinition of:

DBMS_FIELD::editTblForm()

show the filed definition form

editTbl_getFieldEditArr (line 130)

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

---

Redefined in descendants as:

• DBMS_FIELD_LINUXTIMESTAMP::editTbl_getFieldEditArr() : returns an array of field to bie shown in the edit form by using editTbl_echoForm
• DBMS_FIELD_TIMESTAMP::editTbl_getFieldEditArr() : returns an array of field to bie shown in the edit form by using editTbl_echoForm

fldTypeIsUseable (line 89)

checks if a db fieldtype is compatible to the class

• since: pk-08-05-19

boolean fldTypeIsUseable (string $fldType, [boolean $debug = False])

• string $fldType
• boolean $debug

---

Redefinition of:

DBMS_FIELD::fldTypeIsUseable()

checks if a db fieldtype is compatible to the class

getDateObj (line 393)

returns a date object created from the value

• version: pk-07-10-01
• since: pk-06-08-18

OCSP_DATE getDateObj (mixed $aValue, [boolen $debug = FALSE])

• mixed $aValue
• boolen $debug

getDefaultValue (line 370)

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

• since: pk-03-12-14

string getDefaultValue ()

---

Redefinition of:

DBMS_FIELD::getDefaultValue()

returns the field default value

---

Redefined in descendants as:

• DBMS_FIELD_TIMESTAMP::getDefaultValue() : returns the field default value

getInputTag (line 258)

void getInputTag ( $aValue, [ $arrName = "DBVAL"], [ $nameAdd = ""], [ $debug = FALSE])

• $aValue
• $arrName
• $nameAdd
• $debug

---

Redefinition of:

DBMS_FIELD::getInputTag()

returns the html code for a editable formular element

getListValue (line 572)

returns the html representation of the field in a list (table col)

• return: the html representation of the field
• since: pk-06-07-17

mixed getListValue ([mixed $aValue = NULL], [string $arrName = "DBVAL"], [bool $debug = FALSE])

• mixed $aValue: the falue
• string $arrName: name of the global array holding data values
• bool $debug: show debug info

---

Redefinition of:

DBMS_FIELD::getListValue()

returns the html representation of the field in a list (table col)

getScreenValue (line 537)

returns the html representation of the field

• return: the html representation of the field
• since: pk-06-07-17

mixed getScreenValue ([mixed $aValue = NULL], [string $arrName = "DBVAL"], [boolean $debug = FALSE])

• mixed $aValue: the falue
• string $arrName: name of the global array holding data values
• boolean $debug: show debug info

---

Redefinition of:

DBMS_FIELD::getScreenValue()

returns the html representation of the field

---

Redefined in descendants as:

• DBMS_FIELD_LINUXTIMESTAMP::getScreenValue()

getSearchCompTypes (line 351)

returns the html code for the search compare type select

• since: pk-04-12-29

string getSearchCompTypes (string $arrName)

• string $arrName

getValue (line 432)

returns the field value

• version: pk-03-12-13
• version: pk-06-08-18
• version: pk-07-09-26
• 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

---

Redefined in descendants as:

• DBMS_FIELD_LINUXTIMESTAMP::getValue() : returns the field value
• DBMS_FIELD_TIMESTAMP::getValue() : returns the field value

save (line 211)

save the filed definition form

• version: pk-04-12-29
• version: pk-05-01-03
• version: pk-05-06-30

bool save ()

---

Redefinition of:

DBMS_FIELD::save()

save the filed definition form

searchWhere (line 598)

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

---

Redefined in descendants as:

• DBMS_FIELD_TIMESTAMP::searchWhere() : get a where clause for the search settings

slashedValue (line 491)

returns the value with slashes create use in a db statement

• version: pk-03-11-27 DB-Object used instead of DB_.. function
• version: pk-03-12-13 use $this->getValue to check the Value

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

---

Redefined in descendants as:

• DBMS_FIELD_LINUXTIMESTAMP::slashedValue() : returns the value with slashes create use in a db statement
• DBMS_FIELD_TIMESTAMP::slashedValue() : add slashes to the value to add it to a sql command

Inherited Methods

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()