File Source for DBMS_FIELD_DBCOLSELECTLIST.phpclass

<?php
/**
* Class file DBMS_FIELD_DBCOLSELECTLIST.phpclass
*
* @project Open CSP-Management
* @package dbms_field
* @category string
*
* @author Peter Krebs <pitlinz@users.sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
***/
require_once dirname(__FILE__)._OCSP_DIRSEP_."DBMS_FIELD_SELECTLIST.phpclass";
/**
* Class DBMS_FIELD_DBCOLSELECTLIST
*
* handles file upload
*
* @author Peter Krebs <pitlinz@users.sourceforge.net>
* @author Christian Gaisberger <c.gaisberger@lvus.at>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-06-02-06
* @version pk-06-09-11 $this->tblFilter as cvs
* @version pk-07-03-05 ajax
*
* @todo DBMS_FIELD_DBCOLSELECTLIST use $myForm->getDBObj for database handle
*
***/
class DBMS_FIELD_DBCOLSELECTLIST extends DBMS_FIELD_SELECTLIST {
/**
* source file of the class
*
* @var string $classSrcFile
* @since pk-04-10-05
***/
protected $classSrcFile=__FILE__;
var $allowNullSelect = FALSE;
/**
* filter of the table names
* @var string $tblFilter
* @access protected
***/
protected $tblFilter = "";
/**
* @var string $myTblField formfield contains the table
* @since pk-07-03-05
* @access protected
***/
protected $myTblField = "";
/**
* the default table
* @var string $defaultTbl
* @access protected
***/
protected $defaultTbl = "";
/**
* user is allowed to change table
* @var boolean $allowChangeTbl
* @access protected
***/
protected $allowChangeTbl = FALSE;
/**
* return tableNAME.columnNAME if true else columnNAME
* @var boolean $addTblName
* @access protected
***/
protected $addTblName = FALSE;
// ###########################################################
// FIELD DEFINITION DATA METHODS
// ###########################################################
/**
* 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-08-11
*
***/
function editTbl_getFieldEditArr($debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_DBSELECTLIST::editTbl_getFieldEditArr","",0);
$a_ret=parent::editTbl_getFieldEditArr($debug);
unset($a_ret['SELECT']['FLD_LSTVALISHTML']);
unset($a_ret['SELECT']['FLD_LSTVALS']);
$a_ret['DB_TABLE']=array(
'TITLE'=>"Tabelle",
'FLD_TBLFIELD'=>array('ISHIDDEN'=>TRUE),
'FLD_FILTER'=>array(
'FLDLAB'=>"Default Tabelle",
'FLDVAL'=>"<input name=\"tblFilter\" value=\"".$this->tblFilter."\" size=\"40\" />"
),
'FLD_DEFAULTTBL'=>array(
'FLDLAB'=>"Tabellenfilter (durch Komma getrennt)"
),
'FLD_ALLOWCHGTBL'=>array(
'FLDLAB'=>"Tabelle wechseln",
'FLDVAL'=>"<input type=\"checkbox\" name=\"allowChangeTbl\" value=\"1\" ".($this->allowChangeTbl ? "checked" : "")." /> erlauben"
),
'FLD_ADDTBLNAME'=>array(
'FLDLAB'=>"Tabellenname mitspiechern",
'FLDVAL'=>"
<input type=\"radio\" value=\"1\" name=\"addTblName\" ".($this->addTblName ? "checked=\"checked\"" : "")." /> ja (TABLE.COLUMN speichern)<br />
<input type=\"radio\" value=\"0\" name=\"addTblName\" ".($this->addTblName ? "" : "checked=\"checked\"")." /> nein (COLUMN speichern)<br />
"
)
);
// <pk-07-03-05> get table fields
$this->getMyForm();
$a_flds=$this->myForm->getFieldArr(TRUE);
$a_tblFields=array();
foreach($a_flds as &$o_fld) {
if ($debug) echo "<p>".get_class($o_fld)."</p>";
if (pcf_is_instance_of($o_fld,'DBMS_FIELD_DBTBLLIST')) {
if ($debug) echo "<p><b>Feld gefunden: ".$o_fld->getKey()."</b></p>";
$a_tblFields[]=$o_fld;
}
}
if (sizeof($a_tblFields)) {
$a_ret['DB_TABLE']['FLD_TBLFIELD']['ISHIDDEN']=FALSE;
$a_ret['DB_TABLE']['FLD_TBLFIELD']['FLDLAB']="Tabellenfeld";
$s_tag ="<select name=\"myTblField\" onChange=\"if (this.options[this.options.selectedIndex].value != '') {";
$s_tag.="this.form.tblFilter.defaultValue=this.form.tblFilter.value;";
$s_tag.="this.form.tblFilter.value='-- vom Tabellen Feld --';";
$s_tag.="this.form.defaultTbl.defaultIndex=this.form.defaultTbl.options[this.form.defaultTbl.options.selectedIndex];";
$s_tag.="this.form.defaultTbl.options[0].text='-- Tabellen Feld verwenden --';";
$s_tag.="this.form.defaultTbl.options.selectedIndex=0;";
$s_tag.="} else {";
$s_tag.="this.form.tblFilter.value=this.form.tblFilter.defaultValue;";
$s_tag.="this.form.defaultTbl.options[0].text='-- ??? --';";
$s_tag.="this.form.defaultTbl.options.selectedIndex=this.form.defaultTbl.defaultIndex;";
$s_tag.="}\">\n";
$s_tag.="<option value=\"\">--- ??? ---</option>\n";
foreach($a_tblFields as $o_fld) {
$s_tag.="<option value=\"".$o_fld->getKey()."\" ".(($this->myTblField == $o_fld->getKey()) ? " selected=\"selected\"" : "").">".$o_fld->getLabel()." (".$o_fld->getName().")</option>\n";
}
$s_tag.="</select>";
$a_ret['DB_TABLE']['FLD_TBLFIELD']['FLDVAL']=$s_tag;
}
// </pk-07-03-05
$a_ret['DB_TABLE']['FLD_DEFAULTTBL']['FLDVAL'] ="<select name=\"defaultTbl\" size=\"1\">\n";
$a_ret['DB_TABLE']['FLD_DEFAULTTBL']['FLDVAL'].="<option value=\"\">--- ??? ---</option>\n";
$a_tables=$GLOBALS['USRDB']->getDBTblList();
foreach($a_tables as $s_tbl) {
$s_opt="<option value=\"".$s_tbl."\"";
if ($this->defaultTbl==$s_tbl) $s_opt.=" selected=\"selected\"";
$s_opt.=">$s_tbl</option>\n";
$a_ret['DB_TABLE']['FLD_DEFAULTTBL']['FLDVAL'].=$s_opt;
}
$a_ret['DB_TABLE']['FLD_DEFAULTTBL']['FLDVAL'].="</select>\n";
return $a_ret;
}
/**
* saves the fld definition
*
* @return bool
*
***/
function save() {
$ret = parent::save();
$this->myTblField = $_POST['myTblField'];
$this->tblFilter = $_POST['tblFilter'];
$this->defaultTbl = $_POST['defaultTbl'];
$this->allowChangeTbl = (intval($_POST['allowChangeTbl']) ? TRUE : FALSE);
$this->addTblName = (intval($_POST['addTblName']) ? TRUE : FALSE);
if (!empty($this->myTblField)) {
$this->getMyForm(); // ensure we have the right form object
if ($o_tblfld=$this->myForm->getField($this->myTblField)) {
$o_tblfld->ajax_registerFldToNotify('onChange',$this->getKey(),'ajax_setColLst',$debug);
}
}
return $ret;
}
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// javascript & ajax
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/**
* returns the js code to update the column select list
* NOTE: the axCURVAL is the table
*
* @returns string
*
* @since pk-07-03-05
*
* @access public
*/
function ajax_setColLst()
{
$s_arrName=((isset($_GET['axARRNAME']) && (!empty($_GET['axARRNAME']))) ? $_GET['axARRNAME'] : $this->getDataArrName());
$s_tblName=(isset($_GET['axCURVAL']) ? $_GET['axCURVAL'] : "");
global ${$s_arrName};
$s_ret="";
$s_ret.="
if (fld_colSel=searchElement(document,\"".$this->getColSelName()."\"))
{
var str_curCol=fld_colSel.options[fld_colSel.options.selectedIndex].value;
var bol_selected=false;
fld_colSel.options.length=0;
";
$a_optlst=$this->getColOptLst($s_tblName,NULL);
if (is_array($a_optlst))
{
foreach($a_optlst as $a_option)
{
$s_ret.="bol_selected=(str_curCol==\"".$a_option['VALUE']."\");\n";
$s_ret.="fld_colSel.options[fld_colSel.options.length]=new Option(";
$s_ret.="\"".$a_option['NAME']."\",\"".$a_option['VALUE']."\",".($a_option['DEFAULTSELECT'] ? "true" : "false").",".($a_option['SELECTED'] ? "true" : "bol_selected").");\n";
}
}
$s_ret.="
}
";
return $s_ret;
}
/**
* returns the js code to update the table list select
*
* @returns string
*
* @since pk-07-03-7
*
* @access public
*/
function ajax_updateTblLst()
{
$s_arrName=((isset($_GET['axARRNAME']) && (!empty($_GET['axARRNAME']))) ? $_GET['axARRNAME'] : $this->getDataArrName());
$s_value=(isset($_GET['axCURVAL']) ? $_GET['axCURVAL'] : "");
return "alert(\"TODO ".__CLASS__."::".__METHOD__."()\");";
}
// ###########################################################
// VALUE METHODS
// ###########################################################
// -----------------------------------------------------------
// table methods
// -----------------------------------------------------------
/**
* returns the table name out of $aValue or the global ${$this->getDataArrName()}
* NOTE: does not check if the table exists
*
* @param string $aValue
* @param boolean $debug
*
* @returns string
*
* @since pk-07-03-07
*
* @access public
*
***/
function getTablName($aValue,$debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__." L: ".__LINE__,get_class($this),__CLASS__."::".__METHOD__."()","\$aValue: <pre>".print_r($aValue)."</pre>");
$s_defTbl=$this->defaultTbl;
global ${$this->getDataArrName()};
if (!empty($this->myTblField)) {
$this->getMyForm();
if ($o_fld=$this->myForm->getField($this->myTblField)) {
$s_defTbl=${$this->getDataArrName()}[$o_fld->getName()];
}
}
if (!empty($aValue)) {
if (is_array($aValue) && !empty($aValue['TBL'])) {
return $aValue['TBL'];
}
if (strstr($aValue,'.')) {
if ($a_TblCol=explode('.',$aValue,2) && !empty($a_TblCol[0])) {
return $a_TblCol[0];
}
}
// return the default table to avoid an endless loop when recalling the function for empty values below
return $s_defTbl;
} else if (!empty(${$this->getDataArrName()}[$this->getName()])) {
return $this->getTablName(${$this->getDataArrName()}[$this->getName()]);
}
if (empty($s_defTbl)) {
if (strstr($this->getDefaultValue(),".")) {
return $this->getTablName($this->getDefaultValue());
}
}
return $s_defTbl;
}
/**
* returns an array of tables as options which can be used (in a js) to populate the list
*
* @param string $aTblName
* @param boolean $debug
*
* @returns array array(string [NAME], string [VALUE],boolean [DEFAULTSELECT],boolean [SELECTED])
*
* @since pk-07-03-07
*
*/
function getTblOptLst($aTblName,$debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__." L: ".__LINE__,get_class($this),__CLASS__."::".__METHOD__."($aTblName)");
if ($a_tables=$GLOBALS['USRDB']->getDBTblList()) {
if (!empty($this->tblFilter)) {
$a_filter=explode(',',$this->tblFilter);
} else {
$s_ret=array();
foreach($a_tables as $s_tbl)
{
$b_selected=(($s_tbl == $aTblName) ? TRUE : FALSE);
if ($a_filter) {
reset($a_filter); $b_found=FALSE;
while(!$b_found && (list($i_dx, $s_tbl) = each($a_tblFlter))) {
if (stristr($s_val,$s_tbl)) {
$s_ret[]=array('NAME'=>$s_tbl,'VALUE'=>$s_tag,'DEFAULTSELECT'=>FALSE,'SELECTED'=>$b_selected);
$b_found=TRUE;
}
}
} else {
$s_ret[]=array('NAME'=>$s_tbl,'VALUE'=>$s_tag,'DEFAULTSELECT'=>FALSE,'SELECTED'=>$b_selected);
}
}
}
return $s_ret;
} else {
return NULL;
}
}
// -----------------------------------------------------------
// col methods
// -----------------------------------------------------------
/**
* returns the name of the column select element
*
* @returns string
*
* @since pk-07-03-07
*
* @access public
*/
function getColSelName()
{
if ($this->allowChangeTbl && empty($this->myTblField))
{
return $this->getDataArrName()."[".$this->getName()."][COL]";
}
else
{
return $this->getDataArrName()."[".$this->getName()."]";
}
}
/**
* reads the table columns
* and adds all entries to $this->myValues
*
* @param string $arrName index of the data array in $GLOBALS
* @param bool $debug
*
***/
function setMyValues($arrName="DBVAL",$debug=FALSE) {
if ($debug) echo "<p><b>DBMS_FIELD_DBCOLSELECTLIST::setMyValues($arrName,$debug)</b> (".get_class($this).")</p>";
global ${$arrName};
$a_optlst=$this->getColOptLst($this->getTablName(${$arrName}[$this->getName()]));
if (is_array($a_optlst))
{
$this->myValues=array();
foreach($a_optlst as $a_option) {
$this->myValues[$a_option['VALUE']]=$a_option['NAME'];
}
}
else
{
}
}
/**
* returns an array of tables columns as options which can be used (in a js) to populate the list
*
* @param string $aTblName
* @param boolean $debug
*
* @returns array array(string [NAME], string [VALUE],boolean [DEFAULTSELECT],boolean [SELECTED])
*
* @since pk-07-03-07
* @version pk-07-11-28
*
*/
function getColOptLst($aTblName,$aValue=NULL,$debug=FALSE)
{
if ($debug) echoDebugMethod(__FILE__." L: ".__LINE__,get_class($this),__CLASS__."::".__METHOD__."($aTblName)");
$a_ret=array();
if (!empty($aTblName))
{
$obj_myDB=$this->myForm->getDBObj(); // <pk-07-11-28 />
$a_tblDesc=$obj_myDB->getDBTblDesc($aTblName);
if (sizeof($a_tblDesc))
{
if ($this->allowNull)
{
$s_ret[]=array('NAME'=>$this->nullLabel,'VALUE'=>"",'DEFAULTSELECT'=>FALSE,'SELECTED'=>FALSE);
}
foreach($a_tblDesc as $s_colName => $a_colDesc)
{
$a_opt=array();
if ($a_colDesc['PRIMARY_KEY'])
{
$a_opt['NAME']=strtoupper($s_colName);
}
else
{
$a_opt['NAME']=strtolower($s_colName);
}
$a_opt['NAME'].=" (".$a_colDesc['TYPE'];
if (!$a_colDesc['NULL'])
{
$a_opt['NAME'].=" NN";
}
$a_opt['NAME'].=")";
$a_opt['VALUE']=$s_colName;
if ($this->addTblName)
{
$a_opt['VALUE']=$aTblName.".".$s_colName;
}
$a_opt['DEFAULTSELECT']=FALSE;
$a_opt['SELECTED']=($aValue==$a_opt['VALUE']);
$s_ret[]=$a_opt;
}
}
else
{
$s_ret[]=array('NAME'=>"Wählen Sie bitte eine Tabelle aus!",'VALUE'=>"",'DEFAULTSELECT'=>FALSE,'SELECTED'=>FALSE);
}
}
else
{
$s_ret[]=array('NAME'=>"Wählen Sie bitte eine Tabelle aus!",'VALUE'=>"",'DEFAULTSELECT'=>FALSE,'SELECTED'=>FALSE);
}
return $s_ret;
}
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/**
* returns the html code for the select
*
* @param string $aValue
* @param string $arrName
* @param boolean $debug
*
* @returns string
*
* @version pk-04-08-18
* @version pk-05-06-24
*
*/
function getInputTag($aValue,$arrName="DBVAL",$debug=FALSE) {
$debug=($debug || $this->fldDebug);
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_DBCOLSELECTLIST::getInputTag()","Value: ".print_r($aValue,TRUE)."\n$arrName");
$this->getMyForm(); // ensure the object is loaded
$s_tbl=$this->getTablName($aValue);
$s_tag="<a name=\"".$this->myName."\"></a>";
global ${$arrName};
/*
if ($this->myForm->isReloaded($arrName,$debug)) {
if (isset($_POST[$arrName][$this->myName]['TBL'])) {
$s_tbl=$_POST[$arrName][$this->myName]['TBL'];
$s_col=(isset($_POST[$arrName][$this->myName]['COL']) ? $_POST[$arrName][$this->myName]['COL'] : "");
} else {
$s_col=$aValue;
}
} else {
$s_col=$aValue;
}
*/
$s_col=$aValue;
if (strstr($s_col,".")) { // value is TABLE.COLUMN
$a_tblCol=explode('.',$s_col,2);
$s_tbl=$a_tblCol[0];
$s_col=$a_tblCol[1];
}
if ($debug) $s_tag.="Table: $s_tbl<br/>Value: $s_col<br />";
$o_ajax=$this->myForm->ajax_getObj();
if ($this->allowChangeTbl && !$o_tblFld) {
$s_ret.="TODO change Table ..".substr(__FILE__,-20)." LINE: ".__LINE__;
}
$a_optlst=$this->getColOptLst($s_tbl,$s_col,$debug);
$s_tag.= "<select name=\"".$this->getColSelName()."\" >\n";
foreach($a_optlst as $a_opt) {
$s_tag.="<option value=\"".$a_opt['VALUE']."\"".($a_opt['SELECTED'] ? " selected" : "").">".$a_opt['NAME']."</option>\n";
}
$s_tag.= "</select>\n";
return $s_tag;
}
/**
* returns the field value
*
* @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
*
* @return string
*
* @version pk-04-08-19
* @version pk-05-06-24
*
***/
function getValue($aValue,&$err,$arrName="DBVAL",$debug=FALSE) {
$debug=($debug || $this->fldDebug);
if ($debug) echoDebug(__FILE__,"<p><b>DBMS_FIELD_DBCOLSELECTLIST::getValue($aValue,$err,$arrName,$debug)</b> (".get_class($this)." | ".$this->myName.")</p>",0);
if (is_array($aValue)) {
if (!empty($aValue['COL'])) {
if ($this->addTblName) {
$col=$aValue['TBL'].".".$aValue['COL'];
} else {
$col=$aValue['COL'];
}
} else {
$col=NULL;
}
} else {
$col=$aValue;
}
return parent::getValue($col,$err,$arrName,$debug);
}
} // end class DBMS_FIELD_DBCOLSELECTLIST
?>

Source for file DBMS_FIELD_DBCOLSELECTLIST.phpclass