File Source for DBMS_FIELD_DBRADIOSELECT.phpclass

<?php
/**
* Class file DBMS_FIELD_DBRADIOSELECT.phpclass
*
* @project Open CSP-Management
* @package dbms_field
* @category any
*
* @author Peter Krebs <p.krebs@lvus.at>
* @copyright © 2002-2005 by Peter Krebs and Landesverlag Unternehmensservice
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
***/
if (empty($GLOBALS['OCSP']['PHPFORMPATH'])) $GLOBALS['OCSP']['PHPFORMPATH']=dirname(__FILE__)."/";
if (!class_exists("DBMS_FIELD_RADIOSELECT")) {
require_once dirname(__FILE__)."/DBMS_FIELD_RADIOSELECT.phpclass";
}
/**
* Class DBMS_FIELD_DBRADIOSELECT
*
* @project Open CSP-Management
* @package dbms_field
* @category any
*
* @author Peter Krebs <p.krebs@lvus.at>
* @copyright © 2002-2005 by Peter Krebs and Landesverlag Unternehmensservice
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
***/
class DBMS_FIELD_DBRADIOSELECT extends DBMS_FIELD_RADIOSELECT {
// ###########################################################
// OBJECT (CONST) VAR DECLARATION
// ###########################################################
var $className = "RadioDBSelect";
/**
* a sql query to get data array
* @var string $query
***/
var $query = "";
/**
* allow not selecting an entry
* if $this->allowNullSelect = TRUE and $this->allowNull is false 0 is returned
* @param bool $allowNullSelect
***/
var $allowNullSelect = FALSE;
/**
* source file of the class
*
* @var string $classSrcFile
* @since pk-05-02-19
***/
var $classSrcFile=__FILE__;
// ###########################################################
// OBJECT SETTINGS 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-04-26
*
***/
function editTbl_getFieldEditArr($debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_DBRADIOSELECT::editTbl_getFieldEditArr","",0);
$a_ret=parent::editTbl_getFieldEditArr($debug);
$a_ret['SELECT']['FLD_LSTVALS']=NULL;
$a_ret['SELECT']['FLD_LSTQUERY']=array(
'FLDLAB'=>"Query (SELECT KEY,VALUE ..)",
'FLDVAL'=>"<textarea name=\"SELECTQUERY\" cols=\"40\" rows=\"5\" wrap=\"off\">".htmlspecialchars($this->query)."</textarea>"
);
return $a_ret;
}
/* *
* echos the filed definition form
*
* @param boolean $showSize
* @param boolean $showNull
* @param boolean $showValueList
*
* @version pk-05-11-25 bugfix
*
*
function editTblForm($showSize=FALSE,$showNull=TRUE,$showValueList=FALSE) {
parent::editTblForm($showSize,$showNull,$showValueList);
if ($this->className == "RadioDBSelect") {
echo "<tr><td class=\"fldName\">Query (SELECT KEY,VALUE ..):</td>";
echo "<td class=\"fldValue\">";
echo "<textarea name=\"SELECTQUERY\" cols=\"40\" rows=\"5\" wrap=\"off\">";
echo htmlspecialchars($this->query); // <pk-05-11-25 /> htmlspecialchars added
echo "</textarea></td><tr>\n";
}
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>";
}
*/
/**
* save the filed definition form
**/
function save() {
$ret=parent::save();
$this->query =$GLOBALS[$this->getGlobalDBObjIdx()]->checkQuery($_POST['SELECTQUERY'],PQT_SELECT);
$this->allowNullSelect =(intval($_POST['allowNullSelect']) ? TRUE : FALSE );
$this->nullLabel =$_POST['nullLabel'];
$this->myValues =NULL; // make sure that is has no entries from historical class changes
return $ret;
}
// ###########################################################
// OBJECT DATA METHODS
// ###########################################################
/**
* sets populates $this->myValues array from the database
*
* @param string $arrName
* @param bool $debug
*
* @version pk-03-12-18
*
***/
function setMyValues($arrName="DBVAL",$debug=FALSE) {
if ($debug) echo "<p><b>DBMS_FIELD_DBRADIOSELECT::setMyValues($arrName)</b> (".get_class($this).")</p><blockquote>\n";
global ${$arrName};
if ($debug) echo "<p>Query: ".htmlspecialchars($this->query)."</p>";
if (!is_object($GLOBALS[$this->getGlobalDBObjIdx()])) {
$objcmd = "\$DBOBJ = new DB_".$GLOBALS['PROJECT']['DBTYPE'].";";
eval ($objcmd);
$DBOBJ->publicConnect($GLOBALS['PROJECT']['DBCONF']);
$dbVals=$DBOBJ->queryArray($this->query,0,1);
$DBOBJ->disconnect();
} else {
$dbVals=$GLOBALS['USRDB']->queryArray($this->query,0,1);
}
if (!is_array($dbVals)) $dbVals=array("NULL"=>"keine Datensätzegefunden");
if ($this->allowNullSelect) {
$this->myValues=array_merge(array(0=>$this->nullLabel),$dbVals);
} else {
$this->myValues=$dbVals;
}
if ($debug) echo "ROWS: <pre>".htmlspecialchars(print_r($this->myValues,TRUE))."</pre>";
}
// ###########################################################
// OBJECT HTML FORM METHODS
// ###########################################################
// ###########################################################
// SEARCH FORM METHODS
// ###########################################################
// ###########################################################
// OBJECT HTML FORM METHODS
// ###########################################################
// ###########################################################
// OBJECT VALUE CHECK METHODS
// ###########################################################
} // end class DBMS_FIELD_DBRADIOSELECT
?>

Source for file DBMS_FIELD_DBRADIOSELECT.phpclass