Class DBMS_FIELD_DBLOOKUPSELECTLIST

Description

Class DBMS_FIELD_DBLOOKUPSELECTLIST

handels select fields (<SELECT>) where the values are selected form the database

  • author: Peter Krebs <pitlinz@users.sourceforge.net>
  • version: pk-06-02-10
  • version: pk-06-02-06
  • version: pk-07-08-31
  • version: $Id: DBMS_FIELD_DBLOOKUPSELECTLIST.phpclass,v 1.18 2008/12/03 21:32:40 pitlinz Exp $
  • project: Open CSP-Management
  • license: GNU Public License

Located in /db/frmClasses/DBMS_FIELD_DBLOOKUPSELECTLIST.phpclass (line 42)

DBMS_FIELD
   |
   --DBMS_FIELD_SELECTLIST
      |
      --DBMS_FIELD_DBSELECTLIST
         |
         --DBMS_FIELD_DBLOOKUPSELECTLIST
Direct descendents
Class Description
 class DBMS_FIELD_CLI_SEXLOOKUP Class DBMS_FIELD_CLI_SEXLOOKUP
 class DBMS_FIELD_DBLOOKUPMULTISELECTLIST Class DBMS_FIELD_DBLOOKUPMULTISELECTLIST
 class DBMS_FIELD_DBLOOKUPPOPUPSELECT Class DBMS_FIELD_DBLOOKUPPOPUPSELECT
 class DBMS_FIELD_DBTBLLIST Class DBMS_FIELD_DBTBLLIST
 class DBMS_FIELD_FOREIGNKEY handles foreign key fields
 class DBMS_FIELD_PRO_AUDIENCE Class DBMS_FIELD_PRO_AUDIENCE
 class DBMS_FIELD_TREESELECT Class DBMS_FIELD_TREESELECT
Class Constant Summary
 CLASS_SRC_FILE = __FILE__
Variable Summary
Method Summary
 string DBcheckEditInput (string $str)
 array editTbl_getFieldEditArr ([boolean $debug = False])
 string getDBValue (string $aValue, [ $mode = FRM_MODE_READONLY], [boolean $debug = False])
 string getInputTag (string $aValue, [array $arrName = "DBVAL"], [boolean $debug = False])
 string getListValue (mixed $aValue, [string $arrName = "DBVAL"], [boolean $debug = False])
 string getMyValueQuery ([boolean $debug = False])
 string getNewBtn ([boolean $debug = False])
 string getScreenValue (mixed $aValue, [string $arrName = "DBVAL"], [boolean $debug = False])
 boolean save ()
 void setMyValues ([string $arrName = NULL], [boolean $debug = False])
 string _getMyValueWhere (boolean $debug)
Variables
boolean $allowAddValues = False (line 118)
  • var: the class DOES NOT CARE if the added values are in the lookup table lookupShowField is used
  • access: protected

Redefined in descendants as:
boolean $allowEditValues = False (line 125)
  • since: pk-06-02-06
  • access: protected
mixed $classSrcFile = __FILE__ (line 72)
  • deprecated:
  • access: protected

Redefinition of:
DBMS_FIELD_DBSELECTLIST::$classSrcFile

Redefined in descendants as:
string $lookupShowLstField (line 92)
  • since: pk-06-04-26
  • access: protected

Redefined in descendants as:
string $lookupWhere = "" (line 104)
  • access: protected

Inherited Variables

Inherited from DBMS_FIELD_DBSELECTLIST

DBMS_FIELD_DBSELECTLIST::$classCache
DBMS_FIELD_DBSELECTLIST::$classValPopulateTs
DBMS_FIELD_DBSELECTLIST::$query

Inherited from DBMS_FIELD_SELECTLIST

DBMS_FIELD_SELECTLIST::$ajax_onChange_FuncName
DBMS_FIELD_SELECTLIST::$extJSxType
DBMS_FIELD_SELECTLIST::$lstValueIsHtml
DBMS_FIELD_SELECTLIST::$multiselect
DBMS_FIELD_SELECTLIST::$mySeperator
DBMS_FIELD_SELECTLIST::$myValues
DBMS_FIELD_SELECTLIST::$notInLstValues
DBMS_FIELD_SELECTLIST::$nullLabel
DBMS_FIELD_SELECTLIST::$nullToZero
DBMS_FIELD_SELECTLIST::$reloadFormOnChange
DBMS_FIELD_SELECTLIST::$selectAddTag
DBMS_FIELD_SELECTLIST::$selectsize
DBMS_FIELD_SELECTLIST::$showAsCheckRadio
DBMS_FIELD_SELECTLIST::$showNullOption
DBMS_FIELD_SELECTLIST::$showValuesInList
DBMS_FIELD_SELECTLIST::$static_fixedSelSize

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::$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
Methods
DBcheckEditInput (line 253)

ensures that no ; is in $str used in a sql statements

string DBcheckEditInput (string $str)
  • string $str

Redefined in descendants as:
editTbl_getFieldEditArr (line 169)

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

  • global: $OCSP_CONF $OCSP_CONF:
  • version: pk-06-04-29
  • since: pk-06-04-26
array editTbl_getFieldEditArr ([boolean $debug = False])
  • boolean $debug

Redefinition of:
DBMS_FIELD_DBSELECTLIST::editTbl_getFieldEditArr()
returns an array of field to bie shown in the edit form by using editTbl_echoForm

Redefined in descendants as:
getClassCacheKey (line 135)
  • access: protected
void getClassCacheKey ()

Redefinition of:
DBMS_FIELD_DBSELECTLIST::getClassCacheKey()

Redefined in descendants as:
getDBValue (line 461)

returns the db value for a value

  • global: $OCSP_VAL $OCSP_VAL:
  • since: pk-06-01-24
string getDBValue (string $aValue, [ $mode = FRM_MODE_READONLY], [boolean $debug = False])
  • string $aValue
  • boolean $debug
  • $mode
getInputTag (line 425)

returns the html code for the select

  • version: pk-05-12-01
  • version: pk-06-04-26 getNewBtn()
string getInputTag (string $aValue, [array $arrName = "DBVAL"], [boolean $debug = False])
  • string $aValue
  • array $arrName
  • boolean $debug

Redefinition of:
DBMS_FIELD_SELECTLIST::getInputTag()
returns the html code

Redefined in descendants as:
getListValue (line 566)

returns the html code for the readonly field in a list (table col)

if is_array($aValue) a list (&lt;ul&gt;) is returned

  • version: pk-06-05-29 (lstValueIsHtml added)
  • since: pk-06-04-26
string getListValue (mixed $aValue, [string $arrName = "DBVAL"], [boolean $debug = False])
  • mixed $aValue
  • string $arrName
  • boolean $debug

Redefinition of:
DBMS_FIELD_SELECTLIST::getListValue()
returns the html code to show the value(s) in a list (table column)
getMyValueQuery (line 310)

returns the database query

  • global: ${$this->myDataArrName} 0:
  • version: pk-08-04-15
  • todo: DBMS_FIELD_DBLOOKUPSELECTLIST::getMyValueQuery() remove inline SQL
  • since: pk-07-09-03
  • requires: pcf_templates.phpinc
string getMyValueQuery ([boolean $debug = False])
  • boolean $debug

Redefined in descendants as:
getNewBtn (line 391)

returns the html code for the new button

  • since: pk-06-04-26
string getNewBtn ([boolean $debug = False])
  • boolean $debug

Redefined in descendants as:
getScreenValue (line 524)

returns the html code for the readonly field

if is_array($aValue) a list (&lt;ul&gt;) is returned

  • version: pk-06-01-24
  • version: pk-06-02-10
  • version: pk-06-04-26
  • version: pk-06-04-14
string getScreenValue (mixed $aValue, [string $arrName = "DBVAL"], [boolean $debug = False])
  • mixed $aValue
  • string $arrName
  • boolean $debug

Redefinition of:
DBMS_FIELD_SELECTLIST::getScreenValue()
returns the html code for the readonly field

Redefined in descendants as:
save (line 274)

save the filed definition form

  • version: pk-04-12-31
  • version: pk-06-02-06 popUp_frmId
  • version: pk-06-04-29 lookupSort
boolean save ()

Redefinition of:
DBMS_FIELD_DBSELECTLIST::save()
save the filed definition form

Redefined in descendants as:
setMyValues (line 370)

sets populates $this->myValues array from the database

  • version: pk-04-10-11
  • version: pk-05-08-10
  • version: pk-08-06-13 use OCSP_OBJ::defaultReadDBObj()
void setMyValues ([string $arrName = NULL], [boolean $debug = False])
  • string $arrName
  • boolean $debug

Redefinition of:
DBMS_FIELD_DBSELECTLIST::setMyValues()

Redefined in descendants as:
_getMyValueWhere (line 345)

returns the where condition for $this->getMyValueQuery

  • since: pk-08-12-03
  • access: protected
string _getMyValueWhere (boolean $debug)
  • boolean $debug

Inherited Methods

Inherited From DBMS_FIELD_DBSELECTLIST

 DBMS_FIELD_DBSELECTLIST::editTbl_getFieldEditArr()
 DBMS_FIELD_DBSELECTLIST::getClassCacheKey()
 DBMS_FIELD_DBSELECTLIST::getPopupLinkJs()
 DBMS_FIELD_DBSELECTLIST::jOCSP_reloadOptionLst()
 DBMS_FIELD_DBSELECTLIST::save()
 DBMS_FIELD_DBSELECTLIST::setMyValues()

Inherited From DBMS_FIELD_SELECTLIST

 DBMS_FIELD_SELECTLIST::editTabl_save()
 DBMS_FIELD_SELECTLIST::editTbl_getFieldEditArr()
 DBMS_FIELD_SELECTLIST::getArrayFromString()
 DBMS_FIELD_SELECTLIST::getCheckRadio()
 DBMS_FIELD_SELECTLIST::getExtJSConfigOptions()
 DBMS_FIELD_SELECTLIST::getFormFieldSelect()
 DBMS_FIELD_SELECTLIST::getFormFieldSelectAttributes()
 DBMS_FIELD_SELECTLIST::getInputName()
 DBMS_FIELD_SELECTLIST::getInputTag()
 DBMS_FIELD_SELECTLIST::getListValue()
 DBMS_FIELD_SELECTLIST::getOnChangedTag()
 DBMS_FIELD_SELECTLIST::getOptionList()
 DBMS_FIELD_SELECTLIST::getReloadButton()
 DBMS_FIELD_SELECTLIST::getScreenValue()
 DBMS_FIELD_SELECTLIST::getSearchCompTypes()
 DBMS_FIELD_SELECTLIST::getSearchInputTag()
 DBMS_FIELD_SELECTLIST::getSelectTag()
 DBMS_FIELD_SELECTLIST::getValue()
 DBMS_FIELD_SELECTLIST::jOCSP_getAdditonalFieldObjElems()
 DBMS_FIELD_SELECTLIST::jOCSP_getReloadScript()
 DBMS_FIELD_SELECTLIST::jOCSP_getRequiredModules()
 DBMS_FIELD_SELECTLIST::setMyValues()
 DBMS_FIELD_SELECTLIST::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()
Class Constants
CLASS_SRC_FILE = __FILE__ (line 51)

Inherited Constants

Inherited from DBMS_FIELD_DBSELECTLIST

DBMS_FIELD_DBSELECTLIST::CLASS_SRC_FILE

Documentation generated on Thu, 08 Jan 2009 17:41:05 +0100 by phpDocumentor 1.4.0a2