File Source for DBMS_FIELD_SELECTLIST.phpclass

<?php
/**
* Class file DBMS_FIELD_SELECTLIST.phpclass
*
* @project Open CSP-Management
* @package dbms_field
* @category any
*
* @author Peter Krebs <pitlinz@sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @version $Id: DBMS_FIELD_SELECTLIST.phpclass,v 1.33 2008/11/24 23:30:31 pitlinz Exp $
*
*/
if (!class_exists('DBMS_FIELD'))
{
require_once dirname(__FILE__) . _OCSP_DIRSEP_ . "DBMS_FIELD.phpclass";
}
if (!interface_exists('INFA_DBMS_FIELD_SELECTLIST'))
{
require_once dirname(__FILE__) . _OCSP_DIRSEP_ . "INFA_DBMS_FIELD_SELECTLIST.phpclass";
}
/**
* Class DBMS_FIELD_SELECTLIST
*
* handels select fields (<SELECT>)
* the class holds all values available in $this->myValues
*
*
* in case of multiselect
* serialization is done with expolde and implode functions
* the default seperator is "\n" make sure the database column
* is big enough to hold all the values.
*
*
* @project Open CSP-Management
* @package dbms_field
* @category any
*
* @author Peter Krebs <pitlinz@sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @version pk-06-02-10
* @version $Id: DBMS_FIELD_SELECTLIST.phpclass,v 1.33 2008/11/24 23:30:31 pitlinz Exp $
*/
class DBMS_FIELD_SELECTLIST
extends DBMS_FIELD
implements INFA_DBMS_FIELD_SELECTLIST
{
/**
* source file of the class
*
* @var string $classSrcFile
* @since pk-04-10-05
***/
protected $classSrcFile=__FILE__;
// ###########################################################
// OBJECT (CONST) VAR DECLARATION
// ###########################################################
/**
* @var array $myValues
* @access protected
*/
protected $myValues = array();
/**
* @var boolean $multiselect
* @access protected
*/
protected $multiselect = False;
/**
* @var boolean $showListNullEntry
* @since pk-04-08-31
* @access protected
***/
protected $showNullOption = False;
/**
* @var string $nullLabel
* @access protected
*/
protected $nullLabel = "--- ??? ---";
/**
* @var boolean $nullToZero set the NullOptionValue to 0
* @since pk-05-12-12
* @access protected
***/
protected $nullToZero = False;
/**
* @var int $selectsize (added into <select ... size=&quote;$this->selectsize&quote; ... >)
* @access protected
*/
protected $selectsize = 1;
/**
* @var string $selectAddTag (additional html tag attributes for <select ...>)
* @access protected
*/
protected $selectAddTag = "";
/**
* @var int $reloadFormOnChange (if >0 a onChange event forces to reload the form)
* @since pk-04-09-15
***/
protected $reloadFormOnChange = 0;
/**
* @staticvar boolean $static_fixedSelSize
* @since pk-05-08-29
* @access protected
***/
protected $static_fixedSelSize=False;
/**
* use a table of checkboxes or radio boxes instead of
* a select
* @var boolean $showAsCheckRadio
* @since pk-05-09-16
* @access protected
***/
protected $showAsCheckRadio=False;
/**
* show not in list values
* if true all values of $valArr are added to the list
* even if the are not in myValues
* @var boolean $notInLstValues
* @since pk-05-12-01
* @access protected
***/
protected $notInLstValues=False;
/**
* seperator used in multiselect mode
* NOTE: this::save() sets this too
* @var char $mySeperator
* @since pk-06-02-10
* @access protected
***/
protected $mySeperator="\n";
/**
* do not htmlspecialchars list values
* @var boolean $lstValueIsHtml
* @since pk-06-05-29
* @access protected
***/
protected $lstValueIsHtml=False;
/**
* wether to lookup in the select list for the representation of a value
* or just output the value in list view
* @var boolean $showValuesInList
* @since pk-06-07-22
* @access protected
***/
protected $showValuesInList=False;
/**
* @var boolean $ajax_onChange_FuncName
* @since pk-07-03-07
* @access protected
***/
protected $ajax_onChange_FuncName=NULL;
/**
* xtype to use in the extJS framework for the field
*
* @var string $extJSxType
*/
protected $extJSxType = 'combo';
// ###########################################################
// OBJECT SETTINGS METHODS
// ###########################################################
// ###########################################################
// OBJECT DATA METHODS
// ###########################################################
/**
* extracts the array out of the input string
* where it is inter like
* <code>
* key:value\n
* </code>
*
* @param string $str
*
* @returns array
*
***/
function getArrayFromString($str) {
$str_ret=NULL;
if ($arr=explode("\n",$str)) {
$str_ret=array();
while(list($line,$keyVal)=each($arr)) {
if ($keyVal != "\n") {
$tmp=explode(":",$keyVal,2);
if ((!empty($tmp[0])) || ($tmp[0] === "0")) {
if (isset($tmp[1]) && !empty($tmp[1]))
{
$str_ret[$tmp[0]]=$tmp[1];
} else {
$str_ret[$tmp[0]]=$tmp[0];
}
}
}
}
}
foreach($str_ret as $key => $val) {
$str_ret[$key]=str_replace("\n","",$val);
$str_ret[$key]=str_replace("\r","",$val);
}
return $str_ret;
}
/**
* does nothing in this class becaus $this->myValues
* is stored internal. Is redefined in descendants
* make sure this is called once before accessing
* $this->myValues
*
* @param string $arrName
* @param bool $debug
*
* @version pk-03-12-18
*
***/
function setMyValues($arrName="DBVAL",$debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_SELECTLIST::setMyValues()","<pre>" . print_r($this->myValues,True) ."</pre>");
//overwrite in subclasses if needed
}
// -----------------------------------------------------------
// ajax
// -----------------------------------------------------------
/**
* returns the html select tag onChange statement to reload the form
*
* @param array $arrName
*
* @since pk-04-08-18
*
***/
function getOnChangedTag()
{
return " onChange=\"ocsp_from_fieldChanged('".$this->myForm->getHTMLName()."','".$this->getJsName()."',this.value);\"";
}
// ###########################################################
// OBJECT HTML FORM METHODS
// ###########################################################
/**
* returns the html code
*
* @param string $aValue
* @param array $arrName
* @param boolean $debug
*
* @returns string
*
* @version pk-04-08-31 $debug added
* @version pk-05-09-16
*
***/
function getInputTag($aValue,$arrName="DBVAL",$debug=False)
{
if (!empty($arrName)) $this->myDataArrName=$arrName;
$debug=($debug || $this->fldDebug); // <pk-04-08-31>
if ($debug) echoDebugMethod(__FILE__,get_class($this),__CLASS__."::getInputTag(\$aValue,\$arrName,...) [".$this->getKey()."]","\$aValue=".print_r($aValue,TRUE));
if (intval($this->showAsCheckRadio)) {
return $this->getCheckRadio($aValue,$arrName,$debug);
} else {
return $this->getSelectTag($aValue,$arrName,$debug);
}
}
/**
* returns the html code for the select
*
* @param string $aValue
* @param array $arrName
* @param boolean $debug
*
* @returns string
*
* @since pk-05-05-16
* @version pk-06-02-10
*
* @deprecated since pk-08-02-06
*/
protected function getSelectTag($aValue,$arrName="DBVAL",$debug=False) {
$debug=($debug || $this->fldDebug); // <pk-04-08-31>
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_SELECTLIST::getSelectTag()","\$aValue=".print_r($aValue,TRUE)."<br />\n\$arrName: $arrName");
$str_tag = "";
//$s_tag = $this->js_getFieldScript($debug);
$str_tag .= $this->getFormFieldSelect($aValue,$debug);
return $str_tag;
}
/**
* returns the html code for the checkbox or radiobox table
*
* @param string $aValue
* @param array $arrName
* @param boolean $debug
*
* @returns string
*
* @since pk-05-05-16
* @version pk-06-02-10
*
* @var string $s_tag
* @var string $s_input
* @var string $s_onChange
* @var int $i_colNr
*
* @todo notInLstValues
*
* @version pk-06-10-30 bugfix 1 entry uses 2 columsn
*
***/
function getCheckRadio($aValue,$arrName="DBVAL",$debug=False) {
$debug=($debug || $this->fldDebug); // <pk-04-08-31>
if ($debug) {
echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_SELECTLIST::getCheckRadio()",$aValue."\n Size: ".$this->selectsize);
}
if ($this->multiselect) {
$s_input="<input type=\"checkbox\" name=\"".$arrName."[".$this->myName."][]"."\" ";
} else {
$s_input="<input type=\"radio\" name=\"".$arrName."[".$this->myName."]"."\" ";
}
if ($this->reloadFormOnChange) {
$s_input.=$this->getOnChangedTag($arrName);
}
if (!($a_ValArr=explode($this->mySeperator,$aValue))) { // <pk-06-02-10 />
$a_ValArr=array();
$a_ValArr[]=$aValue;
}
if ($debug) echoDebug(__FILE__,"<pre>Values: \n".print_r($a_ValArr,TRUE)."</pre>");
if ($debug) echoDebug(__FILE__,"<p>SelectSize: ".intval($this->selectsize)."</p>");
$s_tag = "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border:none;margin:0px;padding:0px\" align=\"center\">";
$s_tag.="<tr>\n";
$i_colNr=0;
// null value
if (($this->showNullOption) && (!$this->multiselect)) {
if ($this->nullToZero) $s_nullValue="0"; else $s_nullValue="";
$s_tag.="\t<td align=\"right\" valign=\"top\">".$s_input." value=\"".$s_nullValue."\" ".(empty($aValue) ? "checked" : "")."></td><td>".$this->nullLabel."</td>\n";
$i_colNr++;
}
$this->setMyValues($this->myDataArrName,$debug);
if (!intval($this->selectsize)) $this->selectsize=1;
if (is_array($this->myValues)) {
if ($debug) echo "<pre>getCheckRadio::myValues\n".print_r($this->myValues,TRUE)."</pre>";
foreach($this->myValues as $key => $s_val) {
if ($i_colNr >= $this->selectsize) {
$s_tag.="</tr>\n";
$s_tag.="<tr>\n";
$i_colNr=0;
}
$s_tag.="\t<td align=\"right\" valign=\"top\">".$s_input ."value=\"".htmlspecialchars($key)."\" ";
// if ((!empty($key) || ($key==="0")) && in_array($key,$a_ValArr)) $s_tag.="checked"; // <pk-06-07-28 />
if (in_array($key,$a_ValArr)) $s_tag.="checked"; // <pk-06-08-19 /> a array key can't be NULL
$s_tag.=" ></td><td>".$s_val."</td>";
$i_colNr++;
}
}
while ($i_colNr++ < $this->selectsize) $s_tag.="\t<td colspan=\"2\"> </td>\n"; // <pk-06-10-30 />
$s_tag.="</tr>\n";
$s_tag.="</table>\n";
if ($this->reloadFormOnChange) {
$s_tag.=$this->getReloadButton($arrName);
}
$s_tag.="\n";
return $s_tag;
}
/**
*
* returns the html code for the readonly field
*
* @param mixed $aValue
* @param string $arrName
* @param boolean $debug
*
* @returns string
*
* @version pk-04-09-08
* @version pk-06-02-10
*
***/
function getScreenValue($aValue,$arrName="DBVAL",$debug=False) {
$debug=($debug || $this->fldDebug);
if ($debug) echo "<hr /><p><b>DBMS_FIELD_SELECTLIST::getScreenValue($aValue,$arrName,...)</b></p>";
$this->setMyValues($arrName,$debug);
$str_ret="";
if ($this->multiselect) $str_ret= "<ul>";
if ($valArr=explode($this->mySeperator,$aValue)) { // <pk-06-02-10 />
while(list($key,$val)=each($valArr)) {
if (!empty($val) || isset($this->myValues[intval($val)])) { // <pk-06-05-15> // <pk-07-02-28 />
if ($this->multiselect) $str_ret.= "<li>";
if (!empty($this->myValues[$val])) {
$str_ret .= $this->myValues[$val];
} else {
$str_ret .= $val;
}
if ($this->multiselect) $str_ret.= "</li>\n";
}
}
if ($this->multiselect) $str_ret .= "</ul>";
return $str_ret;
} else if (!empty($aValue)) {
return $aValue;
}
return "";
}
/**
* returns the html code to show the value(s) in a list (table column)
*
* @param mixed $aValue
* @param string $arrName
* @param boolean $debug
*
* @returns string
*
* @since pk-06-07-22
* @version pk-06-10-09
*
***/
function getListValue($aValue,$arrName="DBVAL",$debug=False) {
$debug=($debug || $this->fldDebug);
if ($debug) echo "<hr /><p><b>DBMS_FIELD_SELECTLIST::getListValue($aValue,$arrName,...)</b></p>";
if (empty($aValue) && ($this->nullToZero)) { // <pk-06-10-09>
return $this->nullLabel;
}
if (!$this->showValuesInList) { // use show representation of the value
return $this->getScreenValue($aValue,$arrName,$debug);
}
$str_ret="";
if ($this->multiselect) $str_ret= "<ul>";
if ($valArr=explode($this->mySeperator,$aValue)) { // <pk-06-02-10 />
while(list($key,$val)=each($valArr)) {
if (!empty($val)) { // <pk-06-05-15>
if ($this->multiselect) $str_ret.= "<li>";
$str_ret .= $val;
if ($this->multiselect) $str_ret.= "</li>\n";
}
}
if ($this->multiselect) $str_ret .= "</ul>";
return $str_ret;
} else if (!empty($aValue)) {
return $aValue;
}
return "";
}
// ################################################
// SEARCH FORM METHODS
// ################################################
/**
* returns the html code for the search comp types
*
* @param string $arrName
*
* @returns string
*
***/
function getSearchCompTypes($arrName) {
return "<input type=\"hidden\" name=\"".$arrName."[".$this->myName."][COMPTYPE]\" value=\"=\"> =  ";
}
/**
* returns the html code for a searchformular element
*
* @param mixed $aValue the value to set
* @param string $arrName
* @param string $nameAdd @see DBMS_FIELD::getInputTag()
*
* @returns string
*
* @version pk-06-02-10
*
***/
function getSearchInputTag($aValue,$arrName="DBVAL") {
$s_tag = "<select name='".$arrName."[".$this->myName."][VALUE]' size=\"1\" ";
$s_tag .= $this->selectAddTag;
$s_tag.=" size=\"".(intval($this->selectsize)+1)."\" ";
$s_tag .= ">\n";
if (!empty($aValue)) {
if (!($valArr=explode($this->mySeperator,$aValue))) { // <pk-06-02-10 />
$valArr=array();
$valArr[]=$aValue;
}
} else $valArr=array(NULL);
$s_tag.=$this->getOptionList($valArr,TRUE);
$s_tag.="</select>\n";
return $s_tag;
}
// ###########################################################
// OBJECT VALUE CHECK/RETURN METHODS
// ###########################################################
/**
* add slashes to the value from getValue to add it to a sql command
*
* @param string $aValue the value
* @param array $err error array
* @param string $arrName name of the global array to access field gloabl ${$arrName}
* @param bool $debug
*
* @returns string
*
* @version pk-03-12-14
*
* @deprecated since pk-08-08-11
*
*/
function slashedValue($aValue,&$err,$arrName="DBVAL",$debug=False)
{
$debug=($debug || $this->fldDebug);
if ($debug) echo "<hr><p><b>DBMS_FIELD_SELECTLIST::slashedValue($aValue,$err,$arrName,$debug)</b> (".get_class($this)."/".$this->myName.")</p>";
$val = $this->getValue($aValue,$err,$arrName,$debug);
if ($val !== False) {
if ($debug) echo "<p>slashedValue: returned ". $GLOBALS[$this->getGlobalDBObjIdx()]->qs_getSlashedValue($val)." for $aValue</p>";
return $GLOBALS[$this->getGlobalDBObjIdx()]->qs_getSlashedValue($val);
} else if ($val === False) {
return False;
} else {
if ($debug) echo "<p>slashedValue: NULL returned for $aValue</p>";
return $GLOBALS[$this->getGlobalDBObjIdx()]->qs_getNullStmt();
}
}
// ###########################################################
// ###########################################################
// ###########################################################
//
// rewrite
// implementation of INFA_DBMS_FIELD
//
// ###########################################################
// ###########################################################
// ###########################################################
// --------------------------------------------------------
// getter / setter
// --------------------------------------------------------
/**
* returns the input name
*
* @return string
*
* @version pk-08-02-06
*/
function getInputName()
{
$str_ret = $this->myDataArrName."[".$this->myName."]";
if ($this->multiselect)
{
$str_ret .= "[]";
}
return $str_ret;
}
// --------------------------------------------------------
// field configuration
// --------------------------------------------------------
/**
* returns an array of field to bie shown in the edit form
* by using editTbl_echoForm
*
* the array is in the form:
*
* <code>
* [_sectionName_]
* [TITLE] -> string
* [_rowName_]
* [FLDLAB] (complete html code with <td></td>)
* [FLDVAL] (complete html code with <td></td>)
* </code>
*
* @param boolean $debug
*
* @returns array
*
* @since pk-06-04-26
* @version pk-08-02-06
*
***/
protected function editTbl_getFieldEditArr($debug=False) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_SELECTLIST::editTbl_getFieldEditArr","",0);
$a_ret=parent::editTbl_getFieldEditArr($debug);
include __OCSP_PHPINCPATH__."db/forms/languages/DBMS_FIELD_SELECTLIST_FieldEditArr.de.phpinc";
return $a_ret;
}
/**
* save the filed definition form
*
* @param boolean $debug
*
* @global array $_POST
*
* @returns boolean
*
*/
public function editTabl_save($debug=False)
{
$bol_ret = parent::editTabl_save();
$this->nullLabel = (isset($_POST['nullLabel']) ? $_POST['nullLabel'] : "");
$this->showNullOption = ((isset($_POST['showNullOption']) && intval($_POST['showNullOption'])) ? TRUE : False );
if (stristr($this->dbDesc['TYPE'],"int")) { // <pk-05-12-10>
$this->nullToZero = ((isset($_POST['nullToZero']) && intval($_POST['nullToZero'])) ? TRUE : False );
} else {
$this->nullToZero=False;
}
if (!$this->allowNull && (isset($_POST['allowNull']) && intval($_POST['allowNull'])))
{
// we have not null db column check if we should use 0 for the null value
$this->allowNull=$this->nullToZero;
}
$this->multiselect = ((isset($_POST['MULTISELECT']) && intval($_POST['MULTISELECT'])) ? TRUE : False );
$this->showAsCheckRadio = ((isset($_POST['showAsCheckRadio']) && intval($_POST['showAsCheckRadio'])) ? TRUE : False); // <pk-05-09-16 />
$this->notInLstValues = ((isset($_POST['notInLstValues']) && intval($_POST['notInLstValues'])) ? TRUE : False); // <pk-05-12-01 />
if (!$this->showAsCheckRadio)
{
$this->extJSxType = 'combo';
}
if (isset($_POST['SELECTSIZE']) && intval($_POST['SELECTSIZE'])) {
$this->selectsize = intval($_POST['SELECTSIZE']);
} else {
$this->selectsize=1;
}
if (isset($_POST['VALUES']) && !empty($_POST['VALUES'])) {
$this->myValues=$this->getArrayFromString($_POST['VALUES']);
}
$this->selectAddTag =(isset($_POST['selectAddTag']) ? $_POST['selectAddTag'] : "");
$this->reloadFormOnChange =(isset($_POST['RELOADONCHANGE']) ? intval($_POST['RELOADONCHANGE']) : 0);
$this->mySeperator="\n"; // <pk-06-02-10 /> set to the default seperator
// if a derived class uses a different one you have to overwrite this
$this->lstValueIsHtml= ((isset($_POST['lstValueIsHtml']) && intval($_POST['lstValueIsHtml'])) ? TRUE : False); // <pk-06-05-29 /> <pk-07-5-17 /> E_ALL
$this->showValuesInList=((isset($_POST['showValuesInList']) && intval($_POST['showValuesInList'])) ? TRUE : False); // <pk-06-07-22 /> <pk-07-5-17 /> E_ALL
return $bol_ret;
}
// --------------------------------------------------------
// jOCSP
// --------------------------------------------------------
/**
* returns an array of jOCSP/jQuery Modules which are required
*
* $arr_ret[]="script url";
*
* @param boolean $debug
*
* @return string
*
* @version pk-08-06-02
*/
public function jOCSP_getRequiredModules($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_classe($this),"DBMS_FIELD::jOCSP_getRequiredModules()");
$arr_ret = parent::jOCSP_getRequiredModules($debug);
$arr_ret[] = array(
'CLASS' => 'jOCSP.FLDOBJ_SelectList',
'SRC' => OCSP_OBJ::getConf('SYSTEMURL')."jOCSP/formFields/jOCSP_FLDOBJ_SelectList.js"
);
$arr_ret[] = array(
'CLASS' => 'jQuery.fn.ajaxSubmit',
'SRC' => OCSP_OBJ::getConf('SYSTEMURL')."javascript/jquery/jquery.form.js"
);
return $arr_ret;
}
/**
* returns additional object elements of the field object
*
* array definition: [elemName] = value
*
* NOTE: do not js_escapte value this is done when building the json object
*
* @param boolean $debug
*
* @return array
*
* @since pk-08-02-06
* @version pk-08-06-02
*/
protected function jOCSP_getAdditonalFieldObjElems($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_SELECTLIST::jOCSP_getAdditonalFieldObjElems();");
$arr_ret = parent::jOCSP_getAdditonalFieldObjElems($debug);
switch($this->reloadFormOnChange)
{
case "0":
$arr_ret['reloadOnChange'] = "false";
break;
case "1":
$arr_ret['reloadUrl'] = "'" . pcf_js_escape($_SERVER['REQUEST_URI']) . "'";
$arr_ret['reloadOnChange'] = "true";
break;
case "2":
if (!($str_reloadUrl = $this->getControl()->getReloadUrl()) || empty($str_reloadUrl))
{
$str_reloadUrl = OCSP_OBJ::getConf('SYSTEMURL') . "jOCSP/formRPC.php";
}
$arr_ret['reloadUrl'] = "'" . pcf_js_escape($str_reloadUrl) . "'";
$arr_ret['reloadOnChange'] = "true";
break;
default:
$arr_ret['reloadOnChange'] = "false";
$arr_ret['doReload'] = "function(aValue) {alert('reload type not defined');}";
}
$arr_ret['fldClass'] = "'FLDOBJ_SelectList'";
if ($this->ajaxDebug) // <pk-08-05-21 />
{
$arr_ret['debug'] = True;
}
return $arr_ret;
}
// form reloading
/**
* returns a javascript to be called for reloading the form
*
* @param boolean $debug
*
* @return string
*
* @todo could sometimes not get the controll
*/
public function jOCSP_getReloadScript($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_SELECTLIST::JOCSP_getReloadScript()");
$debug = ($debug || $this->ajaxDebug);
if ($debug)
{
$str_ret = "try {
alert('Reload: " . $this->myName . "');";
} else {
$str_ret = "";
}
if (!pcf_is_instance_of($this->getControl(),'OCSP_FRMCONTR'))
{
try {
$this->setControl($this->getMyForm()->getControl());
if (!pcf_is_instance_of($this->getControl(),'OCSP_FRMCONTR'))
{
pcf_js_alert("no control: " . get_class($this) . "\n" . basename(__FILE__) . "L: " . __LINE__);
}
} catch(Exception $e) {
pcf_js_alert($e->getMessage());
return "";
}
}
if (method_exists($this->getControl(),"jOCSP_getfrmHash"))
{
$str_ret .= "
if (obj_form = jOCSP.getFormByHash('" . $this->getControl()->jOCSP_getfrmHash() . "'))
{
obj_form.fieldChanged('" . $this->getDOMId() . "',this.value);
}
";
if ($debug) {
$str_ret .= " else { alert('Form: " . $this->getControl()->jOCSP_getfrmHash() . " not found\\nField: " . $this->myName . "\\n" . basename(__FILE__) . " L: " . __LINE__ ."');}";
}
} else {
$str_ret .= "alert('Fehler: wrong controll " . get_class($this->myControll) . "\\nField: " . $this->myName . "\\n" . basename(__FILE__) . " L: " . __LINE__ ."');";
}
if ($debug)
{
$str_ret .= "} catch(e) {alert('Field: " . $this->myName . ": ' + e);}";
}
return $str_ret;
}
/**
* returns options of an ext js field config object
*
* NOTE the return string is NOT enclosed by {}
*
* @param boolean $debug
*
* @return string (json)
*
* @since pk-08-09-09
*/
public function getExtJSConfigOptions($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_SELECTLIST::getExtJSConfigOptions()");
$arr_ret = parent::getExtJSConfigOptions($debug);
$arr_ret['name'] = "'" . $this->myName . "_showField'";
$arr_ret['id'] = "'" . $this->getJsName() . "_showField'";
$arr_ret['hiddenName'] = "'" . $this->getInputName() . "'";
$arr_ret['hiddenId'] = "'" . $this->getJsName() . "'";
$this->setMyValues($this->myDataArrName,$debug);
$arr_ret['store'] = "new Ext.data.SimpleStore({
fields: [{name: 'optVal'}, {name: 'optLabel'}],
data : [";
if (is_array($this->myValues))
{
foreach($this->myValues as $m_key => $m_val)
{
$arr_ret['store'] .= $cha_sep . "['" . pcf_js_escape($m_key) . "','" . pcf_js_escape($m_val) . "']";
$cha_sep = ",";
}
}
$arr_ret['store'] .= "]})";
$arr_ret['displayField'] = "'optLabel'";
$arr_ret['valueField'] = "'optVal'";
$arr_ret['forceSelection'] = "true";
$arr_ret['mode'] = "'local'";
$arr_ret['typeAhead']= "true";
$arr_ret['triggerAction'] = "'all'";
$arr_ret['selectOnFocus'] = "true";
//$arr_ret['editable'] = "false";
//$arr_ret['disableKeyFilter'] = "true";
return $arr_ret;
}
// --------------------------------------------------------
// html form output
// --------------------------------------------------------
/**
* returns an array of <select> attributes
*
* @see http://www.w3schools.com/tags/tag_select.asp
*
* array('Attribute' => "\"Value\"");
*
* NOTE: the output of value is done as is.
* Ensure values are in " if needed
*
* <code>
* echo $attribute . "=" . $value;
* </code>
*
* @param boolean $debug
*
* @return array
*
* @since pk-08-02-06
*/
protected function getFormFieldSelectAttributes($debug)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_SELECTLIST::getFormFieldSelectAttributes");
$arr_ret = array();
if ($this->multiselect)
{
$arr_ret['multiple']="\"multiple\"";
}
if (intval($this->selectsize))
{
$arr_ret['size'] = intval($this->selectsize);
}
$arr_ret['onchange'] = "\"" . $this->jOCSP_getReloadScript($debug) . "\"";
if (intval($this->tabIndex))
{
$arr_ret['tabindex'] = intval($this->tabIndex);
}
return $arr_ret;
}
/**
* returns the html code for the <select&gt field
*
* @param mixed $aValue
* @param boolean $debug
*/
protected function getFormFieldSelect($aValue,$debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_SELECTLIST::getFormFieldSelect");
$arr_attributes = $this->getFormFieldSelectAttributes($debug);
$str_tag = "<select name=\"" . $this->getInputName() ."\" id=\"" . $this->getDOMId() . "\"";
if (is_array($arr_attributes))
{
foreach($arr_attributes as $str_att => $str_val)
{
$str_tag .= " " . $str_att . "=" . $str_val;
}
}
$str_tag .= ">";
// options ------------------------------
if (!is_array($aValue))
{
if (!($arr_val = explode($this->mySeperator,$aValue)))
{
$arr_val = array();
}
} else {
$arr_val = $aValue;
}
$str_tag .= $this->getOptionList($arr_val,$this->showNullOption,$debug);
$str_tag .= "</select>";
if (intval($this->reloadFormOnChange)) {
$str_tag .= $this->getReloadButton($debug);
}
return $str_tag;
}
/**
* returns a string with the options
*
* calls setMyValues to be sure $this->myValues is set correkt
*
* @param array $aValArr
* @param bool $addNull
* @param bool $debug
* @return string
*
*
*/
protected function getOptionList($aValArr,$addNull=False,$debug=False) {
$debug=($debug || $this->fldDebug); // <pk-04-08-31>
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_SELECTLIST::getOptionList(\$aValArr,\$addNull=$addNull)",print_r($aValArr,TRUE));
$this->setMyValues($this->myDataArrName,$debug); // <pk-05-08-02 />
$str_ret="";
/* <pk-05-01-11 /> */
// if (($this->allowNull) || ($addNull)) {
if ($addNull) { /* <pk-05-02-08 addNull -> addNULL /> */
$str_ret.="\t<option value=\"\">".$this->nullLabel."</option>\n";
}
if ($debug) echoDebugLine(__FILE__,__LINE__,"<pre style=\"font-size:80%;padding-left: 100px;\">".print_r($this->myValues,TRUE)."</pre>");
if (is_array($aValArr) && sizeof($aValArr)) { // <pk-07-01-15>
$a_flipVal=@array_flip($aValArr);
} else {
$a_flipVal=array();
}
if ($debug) echoDebugLine(__FILE__,__LINE__,"flippedValues=<pre style=\"font-size:80%;padding-left: 100px;\">".print_r($a_flipVal,TRUE)."</pre>");
// <pk-07-09-26>
if (is_array($this->myValues)) {
foreach($this->myValues as $m_key => $m_val)
{
$str_ret.="<option value=\"".$m_key."\"";
if (isset($a_flipVal[$m_key]))
{
$str_ret.=" selected=\"selected\"";
unset($a_flipVal[$m_key]);
}
// <pk-08-09-26>
if (is_array($m_val))
{
$str_ret.=">".strip_tags($m_val['SHOWFIELD'])."</option>\n";
} else {
$str_ret.=">".strip_tags($m_val)."</option>\n";
}
}
}
if (sizeof($a_flipVal)) {
if ($debug) echoDebugLine(__FILE__,__LINE__,"flippedValues=<pre style=\"font-size:80%;padding-left: 100px;\">".print_r($a_flipVal,TRUE)."</pre>");
foreach($aValArr as $s_value) {
if (!empty($s_value)) $str_ret.="<option value=\"$s_value\" selected=\"selected\">$s_value</option>\n";
}
} else if ($debug) {
echoDebugLine(__FILE__,__LINE__,"all values found in array");
}
// </pk-07-09-26>
return $str_ret;
}
/**
* returns the html code for a button to reload the form
*
* @param boolean $debug
*
* @global $OCSP_CONF
*
* @return string
*
* @since pk-04-08-18
*
* @version pk-06-10-10 link name added
* @version pk-07-08-31
* @version pk-08-02-12
*
*/
protected function getReloadButton($debug=False)
{
if ($this->getView())
{
$str_ret = $this->myView->getButton('RELOAD',$debug);
$str_ret = str_replace("/>"," onclick=\"" . pcf_js_escapeOnEventCmd($this->jOCSP_getReloadScript($debug),'"') . "\"/>",$str_ret);
return $str_ret;
}
/*
global $OCSP_CONF;
$str_ret="";
$str_ret.="<img src=\"{$OCSP_CONF['SYSIMGURL']}icons-16x16/reload.gif\" border=\"0\" alt=\"refresh form\" class=\"button\"
onClick=\"ocsp_from_fieldChanged('".$this->myForm->getHTMLName()."','".$this->getJsName()."');\" title=\"Formular aktualisieren\"
/>";
return $str_ret;
*/
}
// --------------------------------------------------------
// data validation
// --------------------------------------------------------
/**
* returns the field value if its an array,
* it is imploded with $this->mySeperator as seperator
*
* @param string $aValue the value
* @param array $err error array
* @param string $arrName name of the array to access fieldsarray gloabl ${$arrName}
* @param bool $debug
*
* @returns string
*
* @since pk-03-12-13
* @version pk-03-12-01
* @version pk-05-12-10
*
***/
function getValue($aValue,&$err,$arrName="DBVAL",$debug=False) {
$debug=($debug || $this->fldDebug);
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_SELECTLIST::getValue({$aValue}, ...)</p>",$this->getName());
if (is_array($aValue)) {
$aValue = implode($this->mySeperator,$aValue);
}
if (empty($aValue) && ($this->nullToZero)) $aValue="0"; //<pk-05-12-10 />
return parent::getValue($aValue,$err,$arrName,$debug);
}
} // end class DBMS_FIELD_SELECTLIST
?>

Source for file DBMS_FIELD_SELECTLIST.phpclass