File Source for DBMS_FIELD_DBATTRSELLIST.phpclass

<?php
/**
* Class file DBMS_FIELD_DBATTRSELLIST.phpclass
*
* @project Open CSP-Management
* @package dbms_field
* @category any
*
* @author Peter Krebs <p.krebs@lvus.at>
* @copyright © 2002-2005 by LVUS <http://www.lvus.at>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
***/
if (empty($GLOBALS['OCSP']['DBMSFLD_PATH'])) $GLOBALS['OCSP']['DBMSFLD_PATH']=dirname(__FILE__)."/";
require_once $GLOBALS['OCSP']['DBMSFLD_PATH']."DBMS_FIELD_SELECTLIST.phpclass";
/**
* Class DBMS_FIELD_DBATTRSELLIST
*
* @project Open CSP-Management
* @package dbms_field
* @category any
*
* @author Peter Krebs <p.krebs@lvus.at>
* @copyright © 2002-2005 by LVUS <http://www.lvus.at>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
***/
class DBMS_FIELD_DBATTRSELLIST extends DBMS_FIELD_SELECTLIST {
var $className = "SelectDbAttribList";
var $attribTbl = "";
var $attribLabelFld = "";
var $attribValueFld = "";
var $getParams = "";
var $query = "";
var $allowNullSelect = FALSE;
/**
* source file of the class
*
* @var string $classSrcFile
* @since pk-05-01-20
***/
var $classSrcFile=__FILE__;
function editTblForm($showSize=FALSE) {
global $USRDB;
parent::editTblForm($showSize);
echo "<tr><td class=\"fldName\">Tabelle:<td>";
echo "<td class=\"fldValue\">";
echo "<select name=\"ATTRIBTBL\">\n";
$tblLst=$USRDB->getDBTblList();
reset($tblLst);
while(list($key,$val)=each($tblLst)) {
echo "\t<option value=\"$val\"";
if ($val==$this->attribTbl) echo " selected";
echo ">$val\n";
}
echo "</select>";
echo "</td></tr>";
echo "<tr><td class=\"fldName\">Attribut Label Field:<td>";
echo "<td class=\"fldValue\">";
echo "<input name=\"ATTRIBLABELFLD\" value=\"".$this->attribLabelFld."\" size=\"32\">";
echo "</td></tr>";
echo "<tr><td class=\"fldName\">Attribut Label Field:<td>";
echo "<td class=\"fldValue\">";
echo "<input name=\"ATTRIBVALUEFLD\" value=\"".$this->attribValueFld."\" size=\"32\">";
echo "</td></tr>";
echo "<tr><td class=\"fldName\">Get-Where-Params:<br>(; als Trennung)<td>";
echo "<td class=\"fldValue\">";
echo "<input name=\"GETPARAMS\" value=\"".$this->getParams."\" size=\"32\">";
echo "</td></tr>";
echo "<tr><td class=\"fldName\">NULL Werte:<td>";
echo "<td class=\"fldValue\">";
echo "<input name=\"allowNullSelect\" type=\"checkbox\" ".($this->allowNullSelect ? "checked" : "")." value=\"1\"> NULL Werte zulassen";
echo "</td><tr>\n";
echo "<tr><td class=\"fldName\">NULL Label:<td>";
echo "<td class=\"fldValue\">";
echo "<input name=\"NULLLABEL\" value=\"".$this->nullLabel."\" size=\"40\">";
echo "</td></tr>";
}
function save() {
$this->attribTbl=$_POST['ATTRIBTBL'];
$this->attribLabelFld=$_POST['ATTRIBLABELFLD'];
$this->attribValueFld=$_POST['ATTRIBVALUEFLD'];
$this->getParams=$_POST['GETPARAMS'];
$this->allowNullSelect = (intval($_POST['allowNullSelect']) ? TRUE : FALSE );
$this->nullLabel =$_POST['NULLLABEL'];
$this->query="SELECT ".$this->attribValueFld.",".$this->attribLabelFld." FROM ".$this->attribTbl;
return parent::save();
}
// ###################################
function writeLabelCol($debug=FALSE) {
global $USRDB;
echo "<td class=\"fldName\">";
$this->toolTip=str_replace("\r","",$this->toolTip);
if (!empty($this->toolTip)) echo "<a href=\"javascript:{alert('".str_replace("\n"," ",addslashes($this->toolTip))."');}\" class=\"fldName\">";
if (!is_object($USRDB)) {
$objcmd = "\$DBOBJ = new DB_".$GLOBALS['PROJECT']['DBTYPE'].";";
eval ($objcmd);
$DBOBJ->publicConnect($GLOBALS['PROJECT']['DBCONF']);
$dbVal=$DBOBJ->quickQuery($this->query.$where,1);
$DBOBJ->disconnect();
} else {
$dbVal=$USRDB->quickQuery($this->query.$where,1);
}
if ($dbVal) echo $dbVal;
else echo $this->label;
if (!empty($this->toolTip)) echo "</a>";
if ($debug) echo "(".$this->sortOrder.")";
echo "</td>";
}
function setMyValues($arrName="DBVAL",$debug=FALSE) {
global $USRDB,${$arrName};
if (!is_object($USRDB)) {
$objcmd = "\$DBOBJ = new DB_".$GLOBALS['PROJECT']['DBTYPE'].";";
eval ($objcmd);
$DBOBJ->publicConnect($GLOBALS['PROJECT']['DBCONF']);
$dbVals=$DBOBJ->quickQuery($this->query.$where,0);
$DBOBJ->disconnect();
} else {
$dbVals=$USRDB->quickQuery($this->query.$where,0);
}
$whereFlds=explode(";",$this->getParams);
if (is_array($whereFlds)) {
reset($whereFlds);
$where=" WHERE 1 ";
while(list($key,$val)=each($whereFlds)) {
$where.=" AND $val='".$_GET[$val]."'";
}
}
if (!is_object($USRDB)) {
$objcmd = "\$DBOBJ = new DB_".$GLOBALS['PROJECT']['DBTYPE'].";";
eval ($objcmd);
$DBOBJ->publicConnect($GLOBALS['PROJECT']['DBCONF']);
$dbVals=$DBOBJ->quickQuery($this->query.$where,0);
$DBOBJ->disconnect();
} else {
$dbVals=$USRDB->quickQuery($this->query.$where,0);
}
if ($GLOBALS['DEBUGMODE']) echo $this->query.$where."<br><pre>".$dbVals."</pre><br>";
$valArr=$this->getArrayFromString($dbVals);
if ($GLOBALS['DEBUGMODE']) { echo "<pre>"; print_r($valArr); echo "</pre>"; }
if (!is_array($valArr)) $valArr=array("NULL"=>"keine Datensätzegefunden");
if ($this->allowNullSelect) {
$this->myValues=array_merge(array('-'=>$this->nullLabel),$valArr);
} else {
$this->myValues=$valArr;
}
if ($GLOBALS['DEBUGMODE']) { echo "<pre>"; print_r($this->myValues); echo "</pre>"; }
}
function writeField($mode,$aValue="",$arrName="DBVAL") {
$this->setMyValues($arrName,$debug);
return parent::writeField($mode,$aValue,$arrName);
}
function getScreenValue($aValue,$arrName="DBVAL",$debug=FALSE) {
$this->setMyValues($arrName,$debug);
return parent::getScreenValue($aVlaue,$arrName,$debug);
}
} // end class DBMS_FIELD_DBSELECTLIST
?>

Source for file DBMS_FIELD_DBATTRSELLIST.phpclass