File Source for DBMS_FIELD_CLI

<?php
/**
* Class file DBMS_FIELD_CLI_SEXLOOKUP.phpclass
*
* @project Open CSP-Management
* @package dbms_field
* @category any
*
* @author Peter Krebs <pitlinz@users.sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @version pk-06-01-17
*
***/
if (empty($GLOBALS['OCSP']['PHPFORMPATH'])) $GLOBALS['OCSP']['PHPFORMPATH']=dirname(__FILE__)."/";
if (!class_exists("DBMS_FIELD_DBLOOKUPSELECTLIST")) {
require_once dirname(__FILE__)."/DBMS_FIELD_DBLOOKUPSELECTLIST.phpclass";
}
/**
* Class DBMS_FIELD_CLI_SEXLOOKUP
*
* @project Open CSP-Management
* @package dbms_field
* @category any
*
* @author Peter Krebs <pitlinz@users.sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @version pk-06-01-17
*
***/
class DBMS_FIELD_CLI_SEXLOOKUP extends DBMS_FIELD_DBLOOKUPSELECTLIST {
// ###########################################################
// OBJECT (CONST) VAR DECLARATION
// ###########################################################
var $className = "LookupCLI_SEX";
/**
* @var string lookupTable
***/
var $lookupTable="T_LOOKUP_SEX";
/**
* @var string showField
* @since pk-05-11-20
***/
var $lookupShowField="LUP_VALUE";
/**
* @var string lookupField
***/
var $lookupField="LUP_KEY";
/**
* @var boolean $isAddress
* @since pk-06-01-17
***/
var $isAddress=TRUE;
/**
* @var boolean $isClient
* @since pk-06-01-17
***/
var $isClient=TRUE;
/**
* @var boolean $isClient
* @since pk-06-01-17
***/
var $isStaff=TRUE;
/**
* @var allowAddValues
*
* DOES NOT CARE if the values are in the list check is disabled
* when is is enabled
***/
var $allowAddValues=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
*
* @return array
*
* @since pk-07-05-17
*
***/
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_VALQUERY']);
$a_ret['ADDR_LOOKUP']=array(
'TITLE' =>"Adressenart",
'FLD_ADRTYPE' => array(
'FLDLAB'=>"Adressenart",
'FLDVAL'=>"
<input type=\"checkbox\" name=\"isAddress\" value=\"1\" ".($this->isAddress ? "checked" : "")."> Adresse<br />
<input type=\"checkbox\" name=\"isClient\" value=\"1\" ".($this->isClient ? "checked" : "")."> Kunde/Einzelperson<br />
<input type=\"checkbox\" name=\"isStaff\" value=\"1\" ".($this->isStaff ? "checked" : "")."> Mitarbeiter<br />
"
)
);
return $a_ret;
}
/*
* echos the filed definition form
*
* @param boolean $showSize
* @param boolean $showDBFields
*
* @version pk-06-01-17
*
function editTblForm($showSize=FALSE,$showDBFields=FALSE) {
parent::editTblForm($showSize,$showDBFields);
// <pk-06-01-17>
echo "<tr><td class=\"fldName\">Adressenart:</td>";
echo "<td class=\"fldValue\">";
echo "<input type=\"checkbox\" name=\"isAddress\" value=\"1\" ".($this->isAddress ? "checked" : "")."> Adresse<br />\n";
echo "";
echo "\n";
echo "</td></tr>\n";
// </pk-06-01-17>
}
*/
/**
* save the filed definition form
*
* @return boolean
*
* @version pk-05-12-08
* @version pk-06-01-17
* @version pk-07-05-17
*
***/
function save() {
$b_ret=parent::save();
$this->lookupTable="T_LOOKUP_SEX";
$this->lookupShowField="LUP_VALUE";
$this->lookupField="LUP_KEY";
$this->lookupWhere="";
// <pk-06-01-17> <pk-07-05-17> E_ALL
$this->isAddress=((isset($_POST['isAddress']) && intval($_POST['isAddress'])) ? TRUE : FALSE);
$this->isClient =((isset($_POST['isClient']) && intval($_POST['isClient'])) ? TRUE : FALSE);
$this->isStaff =((isset($_POST['isStaff']) && intval($_POST['isStaff'])) ? TRUE : FALSE);
// </pk-06-01-17></pk-07-05-17>
$this->allowAddValues=FALSE; // <pk-05-12-08>
return $b_ret;
}
// ###########################################################
// OBJECT DATA METHODS
// ###########################################################
/**
* sets populates $this->myValues array from the database
*
* @param string $arrName
* @param boolean $debug
*
* @since pk-06-01-17
*
***/
function setMyValues($arrName="DBVAL",$debug=FALSE) {
if ($debug) echoDebug(__FILE__,"<p><b>DBMS_FIELD_CLI_SEXLOOKUP::setMyValues()</b> (".get_class($this).")</p>",0);
$this->lookupWhere="(";
$s_or="";
if ($this->isAddress) {
$this->lookupWhere.=$s_or."LUP_ADDR=1";
$s_or=" OR ";
}
if ($this->isClient) {
$this->lookupWhere.=$s_or."LUP_CLI=1";
$s_or=" OR ";
}
if ($this->isStaff) {
$this->lookupWhere.=$s_or."LUP_STAFF=1";
$s_or=" OR ";
}
if ($s_or != "") {
$this->lookupWhere.=")";
if ($debug) echoDebug(__FILE__,"<p>WHERE: ".$this->lookupWhere."</p>",1);
} else {
// no where condition clear lookupWhere
if ($debug) echoDebug(__FILE__,"<p>NO FILTER</p>",1);
$this->lookupWhere="";
}
parent::setMyValues($arrName,$debug);
}
// ###########################################################
// OBJECT HTML FORM METHODS
// ###########################################################
// ###########################################################
// SEARCH FORM METHODS
// ###########################################################
// ###########################################################
// OBJECT HTML FORM METHODS
// ###########################################################
// ###########################################################
// OBJECT VALUE CHECK METHODS
// ###########################################################
} // end class DBMS_FIELD_DBSELECTLIST
?>

Source for file DBMS_FIELD_CLI_SEXLOOKUP.phpclass