Class DBMS_FIELD_DBOPTGRPSELLIST

• author: Peter Krebs <p.krebs@wpus.at>
• author: amicas project <opencsp@amicas.at>
• version: ap-06-05-02
• copyright: &copy; 2002-2005 by WURM & Partner Unternehmensservice
• project: Open CSP-Management
• since: pk-05-05-31
• license: GNU Public License

Located in /db/frmClasses/DBMS_FIELD_DBOPTGRPSELLIST.phpclass (line 38)

DBMS_FIELD
   |
   --DBMS_FIELD_SELECTLIST
      |
      --DBMS_FIELD_DBSELECTLIST
         |
         --DBMS_FIELD_DBOPTGRPSELLIST

mixed $className = "SelectDbOptGrpList" (line 44)

string $classSrcFile = __FILE__ (line 51)

source file of the class

---

Redefinition of:

DBMS_FIELD_DBSELECTLIST::$classSrcFile

string $dbColumns = "" (line 58)

database columns

string $dbGroupBy = "" (line 72)

group by field

string $dbOrderBy = "" (line 79)

order by field

string $dbTables = "" (line 65)

tables

boolean $navigateGrps = FALSE (line 85)

• var: use a select for each grp and call reload on Change
• since: ap-06-02-05

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

editTblForm (line 163)

echos the filed definition form

• version: pk-04-10-11
• version: ap-06-05-02

void editTblForm ([bool $showSize = FALSE])

• bool $showSize

---

Redefinition of:

DBMS_FIELD::editTblForm()

show the filed definition form

editTbl_getFieldEditArr (line 113)

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

• since: ap-06-05-02

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

getGrpSelect (line 403)

returns the html code for a grouped select

• todo: change $GLOBALS['USRDB'] to the propriate DB by using self::getGlobalDBObjIdx()
• since: ap-06-05-02

string getGrpSelect ( &$nofvals, string $grpCol,  &$selValues, [boolean $debug = FALSE], int $nofvals, array $selValues)

• int $nofvals: number of values in group
• string $grpCol
• array $selValues
• boolean $debug
• &$nofvals
• &$selValues

getKeyValColumns (line 250)

returns an array with key and value column name or NULL in case of an error

• since: ap-06-05-02

array getKeyValColumns ([boolean $debug = FALSE])

• boolean $debug

getOptionList (line 322)

returns a string with the options

• version: ap-06-05-02

string getOptionList (array $aValArr, [bool $addNULL = FALSE], [bool $debug = FALSE])

• array $aValArr: array of selected values
• bool $addNULL: add the null option (for search)
• bool $debug

---

Redefinition of:

DBMS_FIELD_SELECTLIST::getOptionList()

returns a string with the options

getSelectGroups (line 215)

returns an array of all group fields or an empty array if explode(",",$this->dbGroupBy) fails

• todo: check if we have a complex dbGroupBy with for example CONCAT(xxx,yyy)
• since: ap-06-05-02

array getSelectGroups ([boolean $debug = FALSE])

• boolean $debug

getSelectTag (line 473)

returns the html code for the select

• todo: change $GLOBALS['USRDB'] to the propriate DB by using self::getGlobalDBObjIdx()
• since: ap-06-05-02

string getSelectTag (string $aValue, [array $arrName = "DBVAL"], [boolean $debug = FALSE])

• string $aValue
• array $arrName
• boolean $debug

---

Redefinition of:

DBMS_FIELD_SELECTLIST::getSelectTag()

returns the html code for the select

getSQLStmt (line 280)

returns the SQL statement for key,values,groups

• since: ap-06-05-02

string getSQLStmt ([boolean $withOrder = TRUE], [boolean $debug = FALSE])

• boolean $withOrder: omit 'ORDER BY ...'
• boolean $debug

nofGrpFlds (line 233)

returns the number of group fields used

• since: ap-06-05-02

int nofGrpFlds ([boolean $debug = FALSE])

• boolean $debug

save (line 176)

save the filed definition form

• version: ap-06-05-02

bool save ()

---

Redefinition of:

DBMS_FIELD_DBSELECTLIST::save()

save the filed definition form

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

Inherited Constants

Inherited from DBMS_FIELD_DBSELECTLIST

DBMS_FIELD_DBSELECTLIST::CLASS_SRC_FILE