File Source for DBMS_FIELD_DBMS_FORMFIELDSELECT.phpclass

<?php
/**
* Class file DBMS_FIELD_DBMS_FORMFIELDSELECT.phpclass
*
* @project Open CSP-Management
* @package dbms_field
* @category int
*
* @author Peter Krebs <p.krebs@lvus.at>
* @copyright (c) 2002-2005 by Peter Krebs and LVUS
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
***/
pcf_require_class('DBMS_FIELD_FOREIGNKEY',dirname(__FILE__)._OCSP_DIRSEP_."DBMS_FIELD_FOREIGNKEY.phpclass");
/**
* Class file DBMS_FIELD_DBMS_FORMFIELDSELECT.phpclass
*
* @project Open CSP-Management
* @package dbms_field
* @category int
*
* @author Peter Krebs <p.krebs@lvus.at>
* @copyright (c) 2002-2005 by Peter Krebs and LVUS
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-05-10-03
*
***/
class DBMS_FIELD_DBMS_FORMFIELDSELECT extends DBMS_FIELD_FOREIGNKEY {
protected $className = "Formfield Select";
/**
* source file of the class
*
* @var string $classSrcFile
* @since pk-05-01-20
***/
protected $classSrcFile=__FILE__;
protected $lookupTable = "T_DBMS_FORMFIELDS";
protected $lookupShowField = "CONCAT(IFNULL(FLD_LABEL,'FLD:'),' (',FLD_NAME,')')";
protected $lookupField = "FLD_KEY";
protected $lookupSort = "FLD_SORTORDER";
protected $allowNullSelect = True;
protected $nullLabel ="--- ??? ----";
/**
* column name of the form id
* @var string $myFormIdCol
***/
protected $myFormIdCol="FRM_ID";
/**
* 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-07-01-09
* @version pk-08-06-26
*/
function editTbl_getFieldEditArr($debug=False)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_DBMS_FORMFIELDSELECT::editTbl_getFieldEditArr","",0);
if (empty($this->lookupField)) $this->lookupField=$this->myName; // <pk-06-11-29 />
if (empty($this->myFormIdCol)) $this->myFormIdCol = 'FRM_ID';
if (empty($this->lookupShowField)) $this->lookupShowField = "CONCAT(IFNULL(FLD_LABEL,'FLD:'),' (',FLD_NAME,')')";
if (empty($this->lookupSort)) $this->lookupSort = "FLD_TABLE,FLD_SORTORDER";
$a_ret=parent::editTbl_getFieldEditArr($debug);
unset($a_ret['SELECT']);
//unset($a_ret['DBLOOKUP']);
$a_ret['DBLOOKUP']['FLD_LUTBL']['FLDVAL'] = 'T_DBMS_FORMFIELDS';
$a_ret['DBLOOKUP']['FLD_VALFLD']['FLDVAL'] = 'FLD_KEY';
$str_lookupWhereAdd = str_replace("FRM_ID='\$*" . $this->myFormIdCol ."\$' AND ","",$this->lookupWhere);
$str_lookupWhereAdd = str_replace("FRM_ID='\$*" . $this->myFormIdCol ."\$' ","",$str_lookupWhereAdd);
$a_ret['DBLOOKUP']['FLD_WHEREFLD']['FLDVAL'] = "
FRM_ID='\$*<input type=\"text\" size=\"20\" name=\"myFormIdCol\" value=\"" . $this->myFormIdCol . "\" />\$' AND <br />
<textarea name=\"lookupWhereAdd\" rows=\"2\" cols=\"40\">".htmlspecialchars($str_lookupWhereAdd)."</textarea>
";
unset($a_ret['FTBL_POPUPS']);
return $a_ret;
}
/**
* @return boolean
**/
function save() {
$ret=parent::save();
$this->lookupTable = "T_DBMS_FORMFIELDS";
$this->lookupField = "FLD_KEY";
$this->myFormIdCol = (isset($_POST['myFormIdCol']) ? $_POST['myFormIdCol'] : $this->myFormIdCol);
$this->lookupWhere = "FRM_ID='\$*" . $this->myFormIdCol ."\$' ";
if (!isset($_POST['lookupWhereAdd']) && !empty($_POST['lookupWhereAdd']))
{
$this->lookupWhere .= "AND " . $_POST['lookupWhereAdd'];
}
return $ret;
}
/**
* returns the where part of to select the foreign Value
*
* @param string $arrName
* @param string $append
* @param boolean $debug
* @param boolean $withWhereAnd
*
* @return string
*
**/
function getWhereStmt($arrName="DBVAL",$append="",$debug=FALSE,$withWhereAnd=TRUE) {
global ${$arrName};
$debug=($debug || $this->fldDebug || $this->fldDbgGetValue);
if ($debug) echo "<hr /><p><b>DBMS_FIELD_DBMS_FORMFIELDSELECT::getWhereStmt($arrName,$append,$debug)</b> (".get_class($this)."/".$this->myName.")</p><blockquote>";
if ($withWhereAnd) {
$ret=" WHERE FRM_ID=".intval(${$arrName}[$this->myFormIdCol]);
} else {
$ret=" WHERE 1=1";
}
if ($debug) echo "<pre>2:\n$wKey</pre>";
if (!empty($append)) {
$ret .=" AND ".$append; // <pk-06-10-18 /> E_ALL
}
if ($debug) echo "<pre>3:\n$ret</pre>";
if ($debug) echo "</blockquote>";
return $ret;
}
/**
* returns the html code for a button to zoom to the foreign record
* first ensure FRM_ID is set in $this->editUrl
* then calls the parent method
*
* @param string $arrName
* @param boolean $debug
*
* @return string
*
* @since pk-05-10-23
*
**/
function getZoomButton($arrName="DBVAL",$debug=FALSE) {
if (empty($arrName)) $arrName = $this->myDataArrName; else $this->myDataArrName=$arrName;
$debug=($debug || $this->fldDebug);
if ($debug) echo "<p><b>DBMS_FIELD_DBMS_FORMFIELDSELECT::getAddButton($arrName,$url,...)</b> (".get_class($this).")</p>";
$this->editUrl=str_replace("\$*FRM_ID\$",$this->myFormIdCol,$this->editUrl);
return parent::getZoomButton($arrName,$debug);
}
}

Source for file DBMS_FIELD_DBMS_FORMFIELDSELECT.phpclass