File Source for DBMS_FIELD

<?php
/**
* Class file DBMS_FIELD_TIME.phpclass
*
* @project Open CSP-Management
* @package dbms_field
* @category real
*
* @author Peter Krebs <p.krebs@lvus.at>
* @copyright (c) 2002-2005 by LVUS <http://opencsp.lvu.at>
* @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")) {
require_once $GLOBALS['OCSP']['PHPFORMPATH']."DBMS_FIELD.phpclass";
}
/**
* Class DBMS_FIELD_TIME
*
* @project Open CSP-Management
* @package dbms_field
* @category real
*
* @author Peter Krebs <p.krebs@lvus.at>
* @copyright (c) 2002-2005 by LVUS <http://opencsp.lvu.at>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
***/
class DBMS_FIELD_TIME extends DBMS_FIELD {
var $className = "Time";
/**
* source file of the class
*
* @var string $classSrcFile
* @since pk-05-02-19
***/
var $classSrcFile=__FILE__;
// ###########################
function getInputTag($aTimeArr,$arrName="DBVAL") {
$ret="";
$ret.="<input name=\"".$arrName."[".$this->myName."][HOUR]\" value=\"".($aTimeArr['HOUR'])."\" size=\"2\" maxlength=\"2\">:\n";
$ret.="<input name=\"".$arrName."[".$this->myName."][MIN]\" value=\"".($aTimeArr['MIN']). "\" size=\"2\" maxlength=\"2\">:\n";
$ret.="<input name=\"".$arrName."[".$this->myName."][SEC]\" value=\"".($aTimeArr['SEC']). "\" size=\"2\" maxlength=\"2\">\n";
$ret.=" <a class=\"button\" href=\"#\" onClick=\"{";
$ret.="var aktDate=new Date();";
$ret.="setElemValByName(document.forms[0],'".$arrName."[".$this->myName."][HOUR]',aktDate.getHours());";
$ret.="setElemValByName(document.forms[0],'".$arrName."[".$this->myName."][MIN]',aktDate.getMinutes());";
$ret.="setElemValByName(document.forms[0],'".$arrName."[".$this->myName."][SEC]',aktDate.getSeconds());";
$ret.="}\"><img src=\"".$GLOBALS[PROJECT]['SYSIMGURL']."buttons/setnow.gif\" border=\"0\"></a> ";
return $ret;
}
function makeTimeArray($aString,$debug=FALSE) {
require_once $GLOBALS['PHPINCPATH']."common/pcf.phpinc";
$ret=array('HOUR'=>'','MIN'=>'','SEC'=>'');
$arr=explode(":",$aString);
if (sizeof($arr == 3)) {
$ret['HOUR']=pcf_addzero(intval($arr[0]),2);
$ret['MIN'] =pcf_addzero(intval($arr[1]),2);
$ret['SEC'] =pcf_addzero(intval($arr[2]),2);
}
if ($debug) {echo "<pre>$aString:\n";print_r($arr);print_r($ret);echo "</pre>";}
return $ret;
}
/**
* @param int $mode
* @param string $aValue
* @param string $arrName
* @param boolean $debug
*
* @version pk-05-09-05
*
***/
function writeField($mode,$aValue="",$arrName="DBVAL",$debug=FALSE) {
switch($mode) {
case FRM_MODE_NEW:
if ($this->enableNew) {
if (empty($aValue)) $aValue=$this->defaultValue;
echo $this->getInputTag($this->makeTimeArray($aValue),$arrName);
echo $this->getAddTag($arrName);
return TRUE;
} else {
return $this->writeField(FRM_MODE_READONLY,$aValue,$arrName,$debug);
}
case FRM_MODE_COPY: // <pk-05-09-05>
if ($this->enableCopy) {
if (empty($aValue)) $aValue=$this->defaultValue;
echo $this->getInputTag($this->makeTimeArray($aValue),$arrName);
echo $this->getAddTag($arrName);
return TRUE;
} else {
return $this->writeField(FRM_MODE_READONLY,$aValue,$arrName,$debug);
}
case FRM_MODE_EDIT:
if ($this->enableEdit) {
echo $this->getInputTag($this->makeTimeArray($aValue),$arrName);
echo $this->getAddTag($arrName);
return TRUE;
} else {
return $this->writeField(FRM_MODE_READONLY,$aValue,$arrName,$debug);
return FALSE;
}
case FRM_MODE_HIDDEN:
echo "<input name=\"".$arrName."[".$this->myName."]\" ";
echo "value=\"".$aValue."\" type=\"hidden\">";
return TRUE;
case FRM_MODE_READONLY:
echo $this->getScreenValue($aValue,$arrName,$debug);
echo $this->getAddTag($arrName);
return FALSE;
default:
echo $this->getScreenValue($aValue,$arrName,$debug);
return FALSE;
}
}
function checkTime($timeArr) {
if ((trim($timeArr['HOUR'])=="") || (intval($timeArr['HOUR']) < 0) || (intval($timeArr['HOUR']) > 24)) return FALSE;
if ((trim($timeArr['MIN'])=="") || (intval($timeArr['MIN']) < 0) || (intval($timeArr['MIN']) > 59)) return FALSE;
if ((trim($timeArr['SEC'])=="") || (intval($timeArr['SEC']) < 0) || (intval($timeArr['SEC']) > 59)) return FALSE;
return TRUE;
}
/**
* returns the string representation of the time
*
* @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
*
* @since pk-03-12-13
* @version pk-03-12-13
*
***/
function getValue($aValue,&$err,$arrName="DBVAL",$debug=FALSE) {
if ($debug) echo "<hr><p><b>DBMS_FIELD_SELECTLIST::getValue($aValue,$err,$arrName,$debug)</b> (".get_class($this)."/".$this->myName.")</p>";
if (!is_array($aValue)) {
$aValue=$this->makeTimeArray($aValue);
}
if (!$this->checkTime($aValue)) {
if ($this->allowNull()) {
return NULL;
} else {
$err['ERROR']=TRUE;
$err[$this->myName]['MSG']="NULL_NOT_ALLOWED";
$err[$this->myName]['LABEL']=$this->label;
if ($debug) print_r($err);
return FALSE;
}
}
return implode(":",$aValue);
}
/**
* add slashes to the value from getValue to add it to a sql command
*
* @param string $aValue the value
* @param array $err error array
* @param string $arrName name of the global array to access field gloabl ${$arrName}
* @param bool $debug
*
* @return string
*
* @version pk-03-12-13
*
***/
function slashedValue($aValue,&$err,$arrName="DBVAL",$debug=FALSE) {
if ($debug) echo "<hr><p><b>DBMS_FIELD_SELECTLIST::slashedValue($aValue,$err,$arrName,$debug)</b> (".get_class($this)."/".$this->myName.")</p>";
if (!($aValue=$this->getValue($aValue,$err,$arrName,$debug))) {
return $GLOBALS[$this->getGlobalDBObjIdx()]->qs_getNullStmt();
}
return $GLOBALS[$this->getGlobalDBObjIdx()]->qs_getSlashedValue($aValue);
}
}
?>

Source for file DBMS_FIELD_TIME.phpclass