File Source for DBMS_FIELD_MENUSELECT.phpclass

<?php
/**
* Class file DBMS_FIELD_MENUSELECT.phpclass
*
* @project Open CSP-Management
* @project Open CSP-Management
* @package dbms_field
* @category int
*
* @author Peter Krebs <pitlinz@users.sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
* @version $Id: DBMS_FIELD_MENUSELECT.phpclass,v 1.5 2008/06/14 09:50:39 pitlinz Exp $
*/
pcf_require_class('DBMS_FIELD_TREESELECT',dirname(__FILE__)."/DBMS_FIELD_TREESELECT.phpclass");
/**
* Class DBMS_FIELD_MENUSELECT
*
* @project Open CSP-Management
* @package dbms_field
* @category int
*
* @author Peter Krebs <pitlinz@users.sourceforge.net>
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
* @version $Id: DBMS_FIELD_MENUSELECT.phpclass,v 1.5 2008/06/14 09:50:39 pitlinz Exp $
*/
class DBMS_FIELD_MENUSELECT extends DBMS_FIELD_TREESELECT {
var $className = "MENUSELECT";
var $nullLabel = "keine Zuordnung";
var $projId = -1;
var $langId = -1;
/**
* source file of the class
*
* @var string $classSrcFile
* @since pk-05-01-20
***/
var $classSrcFile=__FILE__;
/**
* 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-04
*
***/
function editTbl_getFieldEditArr($debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_TREESELECT::editTbl_getFieldEditArr","",0);
$a_ret=parent::editTbl_getFieldEditArr($debug);
$a_ret['COMMON']['FLD_SHOWNULLOPT']=array(
'FLDLAB'=>"Wurzel (Null) Anzeigen",
'FLDVAL'=>"<input name=\"showNullOption\" type=\"checkbox\" value=\"1\" ".($this->showNullOption ? "checked=\"checked\"" : "")." /> anzeigen
<input type=\"hidden\" name=\"nullToZero\" value=\"1\" />"
);
$a_ret['DBLOOKUP']['FLD_LUTBL']=array(
'FLDLAB' => "Wert:",
'FLDVAL' => "T_CMS_MENU.MEN_ID"
);
unset($a_ret['DBLOOKUP']['FLD_VALFLD']);
unset($a_ret['DBLOOKUP']['TREEROOTKEY']);
unset($a_ret['DBLOOKUP']['PARENTFIELD']);
$a_ret['DBLOOKUP']['PROJECT']['FLDLAB']="Projekt:";
$a_ret['DBLOOKUP']['PROJECT']['FLDVAL']='
<select name="projId" size="1">
<option value="-1" '.(($this->projId == -1) ? "selected" : "").'>HTTP_GET/DBVAL</option>
<option value="0" '.(($this->projId == 0) ? "selected" : "").'>default</option>'."\n";
$query="SELECT * FROM T_CMS_PROJECT ORDER BY PROJ_ID";
if ($cursor=$GLOBALS['USRDB']->query($query)) {
while($row=$cursor->fetchArray()) {
$a_ret['DBLOOKUP']['PROJECT']['FLDVAL'].="<option value='".$row['PROJ_ID']."' ";
if ($row['PROJ_ID'] == $this->projId) {
$a_ret['DBLOOKUP']['PROJECT']['FLDVAL'].="selected";
}
$a_ret['DBLOOKUP']['PROJECT']['FLDVAL'].=">".$row['PROJ_NAME']."</option>\n";
}
}
$a_ret['DBLOOKUP']['PROJECT']['FLDVAL'].="</select>\n";
$a_ret['DBLOOKUP']['LANGUAGE']['FLDLAB']="Sprache:";
$a_ret['DBLOOKUP']['LANGUAGE']['FLDVAL']='
<select name="langId" size="1">
<option value="-2" '.(($this->langId == -2) ? "selected" : "").'>kein Filter</option>
<option value="-1" '.(($this->langId == -1) ? "selected" : "").'>HTTP_GET/DBVAL</option>
<option value="0" '.(($this->langId == 0) ? "selected" : "").'>default</option>'."\n";
$query="SELECT * FROM T_SYS_LANGUAGE ORDER BY LANG_NAME";
if ($cursor=$GLOBALS['USRDB']->query($query)) {
while($row=$cursor->fetchArray()) {
$a_ret['DBLOOKUP']['LANGUAGE']['FLDVAL'].="<option value='".$row['LANG_ID']."' ";
if ($row['LANG_ID'] == $this->langId) {
$a_ret['DBLOOKUP']['LANGUAGE']['FLDVAL'].="selected";
}
$a_ret['DBLOOKUP']['LANGUAGE']['FLDVAL'].=">".$row['LANG_NAME']."</option>\n";
}
}
$a_ret['DBLOOKUP']['LANGUAGE']['FLDVAL'].="</select>\n";
return $a_ret;
}
function save() {
$ret = parent::save();
$this->lookupTable ="T_CMS_MENU";
$this->lookupField ="MEN_ID";
$this->parentField ="MEN_PARENT";
$this->projId =intval($_POST['projId']);
$this->langId =intval($_POST['langId']);
$this->sortField ="MEN_SORTORDER";
$this->nullLabel ="Menu Wurzel";
$this->nullToZero =true;
return $ret;
}
// ###########################################
/**
* returns the database query
*
* @param boolean $debug
*
* @global ${$this->myDataArrName}
*
* @return string
*
* @requires pcf_templates.phpinc
*
* @since pk-07-09-03
* @version pk-07-09-26 bugfix PROJ_ID
*
* @todo DBMS_FIELD_DBLOOKUPSELECTLIST::getMyValueQuery() remove inline SQL
*/
function getMyValueQuery($debug=FALSE)
{
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_MENUSELECT::getMyValueQuery()");
global ${$this->myDataArrName};
$str_query ="SELECT ".$this->lookupField. " AS KEYFIELD";
$str_query.=",".$this->lookupShowField. " AS SHOWFIELD";
$str_query.=",".$this->parentField. " AS PARENTFIELD";
$str_query.=",(MEN_SHOW AND MEN_SHOWFROM < NOW() AND MEN_SHOWTILL >= NOW()) AS ISTOSHOW";
$str_query.=" FROM ".$this->lookupTable;
if (!empty($this->lookupWhere)) { // <pk-05-08-10>
require_once __OCSP_PHPINCPATH__."common"._OCSP_DIRSEP_."pcf_templates.phpinc";
$str_query.=" WHERE (".pcf_tmpl_parse($this->lookupWhere,${$this->myDataArrName}).")";
$str_whereAnd=" AND ";
} else {
$str_whereAnd=" WHERE ";
}
if (intval($this->projId > -1))
{
$str_query.=$str_whereAnd."PROJ_ID=".intval($this->projId);
} else {
$str_query.=$str_whereAnd." (";
if (isset(${$this->myDataArrName}['PROJ_ID'])) {
$str_query.="PROJ_ID=".intval(${$this->myDataArrName}['PROJ_ID'])." OR ";
}
if (isset($_GET['PROJ_ID'])) {
$str_query.="PROJ_ID=".intval($_GET['PROJ_ID'])." OR ";
}
if (isset($_POST['PROJ_ID']))
{
$str_query.="PROJ_ID=".intval($_POST['PROJ_ID'])." OR ";
}
$str_query=substr($str_query,0,-4).")";
}
if (empty($this->lookupSort)) {
$str_query.=" ORDER BY PROJ_ID,MEN_PARENT,MEN_SORTORDER";
} else {
$str_query.=" ORDER BY PROJ_ID,MEN_PARENT,MEN_SORTORDER,".$this->lookupSort;
}
if ($debug) echoDebugLine(__FILE__,__LINE__,"<strong>myValueQuery:</strong><br /> $str_query");
return $str_query;
}
}
?>

Source for file DBMS_FIELD_MENUSELECT.phpclass