File Source for DBMS_FIELD

<?php
/**
* Class file DBMS_FIELD_ORDERNR.phpclass
*
* @project Open CSP-Management
* @package dbms_field
* @category int
*
* @author Peter Krebs <p.krebs@lvus.at>
* @copyright (c) 2002-2005 by LVUS <http://www.lvus.at>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
***/
pcf_require_class('DBMS_FIELD_INT',dirname(__FILE__) . "/");
/**
* Class DBMS_FIELD_ORDERNR
*
* @project Open CSP-Management
* @package dbms_field
* @category int
*
* @author Peter Krebs <p.krebs@lvus.at>
* @copyright (c) 2002-2003 by Peter Krebs and Landesverlag Unternehmensservice
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
***/
class DBMS_FIELD_ORDERNR extends DBMS_FIELD_INT {
var $className = "OrderNumber";
/**
* @var string $orderKeyFlds a comma seperated list of fields to add in the where claus of getNewOrderNr
***/
var $orderKeyFlds = "";
/**
* @var bool $showArrows
* @since pk-04-05-25
***/
var $showArrows = FALSE; /* <pk 04-05-27 to be compatible with old projects /> */
/**
* @var string $downArgTmpl
* @since pk-04-12-21
***/
var $downArgTmpl = "";
/**
* @var string $upArgTmpl
* @since pk-04-12-21
***/
var $upArgTmpl = "";
/**
* @var string $moveToArgTmpl
* @since pk-04-12-21
***/
var $moveToArgTmpl = "";
/**
* source file of the class
*
* @var string $classSrcFile
* @since pk-05-01-20
***/
var $classSrcFile=__FILE__;
/**
* do not link with edit in lists
*
* @since pk-06-01-30
***/
var $lstDisableLinks=TRUE;
// ###########################################################
// OBJECT SETTINGS METHODS
// ###########################################################
// ###########################################################
// FIELD DEFINITION DATA 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-07-22
*
***/
function editTbl_getFieldEditArr($debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_INT::editTbl_getFieldEditArr","",0);
$a_ret=parent::editTbl_getFieldEditArr($debug);
unset($a_ret['LAYOUT']['UNIT']);
unset($a_ret['VALCHECKS']['NULL2ZERO']);
$a_ret['SORTFLDDEF']=array(
'TITLE' =>"Sortfeld Eigenschanften",
'HIDDENFIELD' =>"",
'ISHIDDEN' =>FALSE,
'SORTKEY'=>array(
'FLDLAB'=>"Schlusselfelder",
'FLDVAL'=>"<input name=\"orderKeyFlds\" type=\"input\" value=\"".$this->orderKeyFlds."\" size=\"30\">"
),
'SHOWARROWS'=>array(
'FLDLAB'=>"<a href=\"#\" onClick=\"alert('Pfeile in der Liste anzeigen')\">Pfeile:</a>",
'FLDVAL'=>"<input name=\"showArrows\" type=\"checkbox\" value=\"1\" ".($this->showArrows ? "checked" : "").">"
),
'MOVEDOWN'=>array(
'FLDLAB'=>"Move Down ARGS: <a href=\"".$GLOBALS['PROJECT']['SYSTEMURL']."help/templatevars.html\" target=\"_blank\">?</a>",
'FLDVAL'=>"<input name=\"downArgTmpl\" type=\"input\" value=\"".htmlspecialchars($this->downArgTmpl)."\" size=\"30\">"
),
'MOVEUP'=>array(
'FLDLAB'=>"Move Up ARGS: <a href=\"".$GLOBALS['PROJECT']['SYSTEMURL']."help/templatevars.html\" target=\"_blank\">?</a>",
'FLDVAL'=>"<input name=\"upArgTmpl\" type=\"input\" value=\"".htmlspecialchars($this->upArgTmpl)."\" size=\"30\">"
),
'MOVEPOS'=>array(
'FLDLAB'=>"Move to positon ARGS: <a href=\"".$GLOBALS['PROJECT']['SYSTEMURL']."help/templatevars.html\" target=\"_blank\">?</a>",
'FLDVAL'=>"<input name=\"moveToArgTmpl\" type=\"input\" value=\"".htmlspecialchars($this->moveToArgTmpl)."\" size=\"30\">&NEWPOS=xxx"
)
);
return $a_ret;
}
/**
* echos the filed definition form
*
* @param boolean $showSize obsulet
* @param boolean $showUnit obsulet
* @param boolean $showNull obsulet
*
* @deprecated since pk-06-07-22
*
***/
function editTblForm($showSize=FALSE,$showUnit=TRUE,$showNull=TRUE) {
$a_FieldEditArr=$this->editTbl_getFieldEditArr($debug);
$this->editTbl_echoForm($a_FieldEditArr,$debug);
}
###############################
/**
* save the filed definition form
*
* @returns boolean
*
***/
function save() {
$ret=parent::save();
$this->orderKeyFlds=$_POST['orderKeyFlds'];
$this->showArrows=intval($_POST['showArrows']) ? TRUE : FALSE;
$this->downArgTmpl=$_POST['downArgTmpl'];
$this->upArgTmpl=$_POST['upArgTmpl'];
$this->moveToArgTmpl=$_POST['moveToArgTmpl'];
$this->size=4;
$this->lstDisableLinks=TRUE; // <pk-06-01-30 />
return $ret;
}
/**
* returns if the list cell can be linked with the ['EDIT'] link
*
* @returns boolean
*
* @since pk-06-01-30
***/
function lstLinksDisabled() {
return TRUE;
}
// ###########################################################
// OBJECT DATA METHODS
// ###########################################################
/**
* returns the htmlcode for the move down button
*
* @param int $aValue
* @param bool $debug
*
* @return string
*
* @since pk-05-01-03
*
***/
function getDownLink($aValue=NULL,$debug=FALSE) {
if ($debug) echo "<p><b>DBMS_FIELD_ORDERNR::getDownLink($aValue,...)</b> (".$this->myName."/".get_class($this).")</p>";
if (empty($this->myDataArrName)) $this->myDataArrName="DBVAL";
global ${$this->myDataArrName};
if ($debug) echo "<blockquote>";
if (!isset($GLOBALS['ORDERNR'][$this->myDataArrName][$this->myName]) ||
!intval($GLOBALS['ORDERNR'][$this->myDataArrName][$this->myName])) { // <pk-06-07-22 /> E_ALL
$maxNr=intval($this->getNewOrderNr($this->myDataArrName,$debug))-1;
$GLOBALS['ORDERNR'][$this->myDataArrName][$this->myName]=$maxNr;
} else {
$maxNr=$GLOBALS['ORDERNR'][$this->myDataArrName][$this->myName];
}
if ($debug) echo "<p>MAX Nr.: ".$maxNr."</p></blockquote>";
if (intval($aValue >= $maxNr)) {
if ($debug) echo "<p><blockquote>First Row (".$aValue.")</blockquote></p>";
return "";
}
if (!empty($this->downArgTmpl)) {
$link=$_SERVER['SCRIPT_NAME']."?";
require_once __OCSP_PHPINCPATH__."common/pcf_templates.phpinc";
if ($debug) echo "<blockquote><p>Tmplate:</p><pre>".htmlspecialchars(print_r($this->downArgTmpl,TRUE))."</pre>";
$link.=pcf_tmpl_parse($this->downArgTmpl,${$this->myDataArrName},$debug);
if ($debug) echo "</blockquote>";
} else {
$link=pcf_HTML_changeURI_GetValue($_SERVER['REQUEST_URI'],"cmd","down");
}
if (!empty($aValue)) $link=pcf_HTML_changeURI_GetValue($link,$this->myName,$aValue,$debug);
if ($debug) echo "<p>LINK:</p><pre>".htmlspecialchars($link)."</pre>";
$ret ="<a href=\"".pcf_HTML_getEncodedURI($link)."\">"; // <pk-06-10-19 />
$ret.="<img src=\"".$GLOBALS['PROJECT']['SYSIMGURL']."icons-16x16/down10x16.gif\" border=\"0\" alt=\"down\" align=\"middle\" class=\"button\"></a>";
return $ret;
}
/**
* returns the htmlcode for the move up button
* only if $this->upArgTmpl is not empty
*
* @param int $aValue
* @param bool $debug
*
* @return string
*
* @since pk-05-01-03
*
**/
function getUpLink($aValue=NULL,$debug=FALSE) {
if ($debug) echo "<p><b>DBMS_FIELD_ORDERNR::getUpLink($aValue,...)</b> (".$this->myName."/".get_class($this).")</p>";
if ((!empty($this->upArgTmpl)) && (intval($aValue) > 1)) {
$link=$_SERVER['SCRIPT_NAME']."?";
require_once __OCSP_PHPINCPATH__."common/pcf_templates.phpinc";
if (empty($this->myDataArrName)) $this->myDataArrName="DBVAL";
global ${$this->myDataArrName};
$link.=pcf_tmpl_parse($this->upArgTmpl,${$this->myDataArrName});
if (!empty($aValue)) $link=pcf_HTML_changeURI_GetValue($link,$this->myName,$aValue);
$ret ="<a href=\"".pcf_HTML_getEncodedURI($link)."\">"; // <pk-06-10-19 />
$ret.="<img src=\"".$GLOBALS['PROJECT']['SYSIMGURL']."icons-16x16/up10x16.gif\" border=\"0\" alt=\"up\" class=\"button\" align=\"middle\"></a>";
return $ret;
} else {
return "";
}
}
/**
* returns the htmlcode for the "move to position"
* only if $this->moveToArgTmpl is not empty otherwise $aValue is returned
*
* @param int $aValue
* @param bool $debug
*
* @return string
*
* @since pk-06-02-23
*
**/
function getMoveToLink($aValue=NULL,$debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_ORDERNR::getMoveToLink()","",0);
if (!empty($this->moveToArgTmpl)) {
$link=$_SERVER['SCRIPT_NAME']."?";
require_once __OCSP_PHPINCPATH__."common/pcf_templates.phpinc";
if (empty($this->myDataArrName)) $this->myDataArrName="DBVAL";
global ${$this->myDataArrName};
$link.=pcf_tmpl_parse($this->moveToArgTmpl,${$this->myDataArrName});
$s_ret ="<a href=\"javascript:{if (newPos=prompt('Neue Position')) {document.location.href='".$link."&NEWPOS='+newPos;}}\" title=\"neu positionieren\">";
$s_ret.=$aValue."</a>";
return $s_ret;
} else {
return $aValue;
}
}
// ###########################################################
// OBJECT HTML FORM METHODS
// ###########################################################
/**
* returns the html code for the field value input / show
* adds $this->myName to ${$this->myDataArrName}['_DBMS_FIELDS']
*
* @param int $mode
* @param mixed $aValue
* @param boolean $debug
*
* @returns string
*
* @since pk-05-01-03
* @version pk-06-01-30
*
**/
function getFieldTag($mode,$aValue=NULL,$debug=FALSE) {
$debug=($debug || $this->fldDebug);
if ($debug) echo "<p><b>DBMS_FIELD_ORDERNR::getFieldTag($mode,$aValue,...)</b> (".get_class($this).")";
if ($mode == FRM_MODE_LIST && $this->showArrows) {
if ($debug) echo "<blockquote>";
$s_style="style=\"border:0px;margin:0px;padding:0px;\" ";
$ret="<table ".$s_style." cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\"><tr>";
$ret.="<td ".$s_style." align=\"right\">".$this->getMoveToLink(intval($aValue),$debug)." </td>";
$ret.="<td ".$s_style." width=\"10\">".$this->getUpLink($aValue,$debug)."</td>";
$ret.="<td ".$s_style." width=\"10\">".$this->getDownLink($aValue,$debug)."</td>";
$ret.="</tr></table>";
if ($debug) echo "</blockquote>";
return $ret;
} else {
return parent::getFieldTag($mode,$aValue,$debug);
}
}
/**
* returns a empty link to not link the field
*
* @param mixed $aValue value of the db field
* @param string $arrName name of the GLOBAL array holding the row values
*
* @return string empty if no link is to show a <a href=...url..> if the field is linked
*
* @version pk-04-05-26
*
**/
function getListLink($aValue,$arrName="DBVAL") {
$this->linkrequested=TRUE;
return "";
}
// ###########################################################
// OBJECT VALUE CHECK METHODS
// ###########################################################
/**
* selects a new order number from the database
*
* NOTE: this is not save because no locking happens
*
* uses $arrName as global variable to get the key fields
* if it is not set $_GET is tried also
*
* @param string $arrName
* @param bool $debug
*
* @return int
*
* @version pk-03-12-13
*
**/
function getNewOrderNr($arrName,$debug=FALSE) {
if ($debug || $this->fldDebug) echo "<hr><p><b>DBMS_FIELD_ORDERNR::getNewOrderNr($arrName,$debug)</b> (".get_class($this)." | ".$this->myName.")</p>";
global ${$arrName};
if (!$obj_db = $this->myForm->getDBObj())
{
throw new Exception(_OCSP_EXCEP_NODBCONN_);
return false;
}
$query="SELECT ".$obj_db->qs_ifNullStmt("MAX(".$this->myName.")",0);
$query.=" FROM ".$this->myTable;
if (!empty($this->orderKeyFlds)) {
$where=" WHERE ";
$keyArr=explode(",",$this->orderKeyFlds);
if ($debug || $this->fldDebug) {echo "<pre>";print_r($keyArr);echo "</pre>"; }
foreach($keyArr as $key => $val) {
if (isset(${$arrName}[$val])) {
$query.=$where.$val."=".$obj_db->qs_getSlashedValue(${$arrName}[$val]);
$where=" AND ";
} else if (isset($_GET[$val])) {
$query.=$where.$val."=".$obj_db->qs_getSlashedValue($_GET[$val]);
$where=" AND ";
}
}
}
if ($debug || $this->fldDebug) {echo "<pre>".$this->orderKeyFlds."\n$query</pre>";}
$nr=intval($obj_db->quickQuery($query,0));
if ($debug || $this->fldDebug) {echo "<pre>Returns:".(intval($nr)+1)."</pre>";}
return intval($nr)+1;
}
/**
* checks if aValue is set.
* if not a new order number is created
* if aValue == $this->defaultValue a new order number is created (pk-03-12-13)
*
* @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_ORDERNR::getValue($aValue,$err,$arrName,$debug)</b> (".get_class($this)." | ".$this->myName.")</p>";
if (!intval($aValue) || ($aValue==$this->defaultValue)) {
$aValue=$this->getNewOrderNr($arrName,$debug);
}
return $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_ORDERNR::slashedValue($aValue,$err,$arrName,$debug)</b> (".get_class($this)."/".$this->myName.")</p>";
return parent::slashedValue($this->getValue($aValue,$err,$arrName,$debug),$err,$arrName,$debug);
}
} // end class DBMS_FIELD_ORDERNR
?>

Source for file DBMS_FIELD_ORDERNR.phpclass