File Source for MED_CATEGORY.phpclass

<?php
/**
* Class file MED_CATEGORY.phpclass
*
* @project Open CSP-Management
* @package media
* @category category-tree
*
* @author Peter Krebs (pk) <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
*
***/
require_once __OCSP_PHPINCPATH__."db/dbms_tree.phpclass";
require_once __OCSP_PHPINCPATH__."default_config/media.conf.phpinc";
require_once $GLOBALS['MED']['PHPINCPATH']."MED_MIMETYPE.phpclass";
require_once $GLOBALS['MED']['PHPINCPATH']."MED_CATEGORY_NODE.phpclass";
class MED_CATEGORY extends DBMS_TREE {
/**
* @var string $myGlobalTreeKey index in $GLOABLS['DBMS_TREE'][]
***/
var $myGlobalTreeKey = "T_MED_CATEGORY";
/**
* @staticvar string $myTable
*/
var $myTable="T_MED_CATEGORY";
/**
* @staticvar string $myIdFld id column = root
***/
var $myIdFld ="MEC_ID";
/**
* @staticvar string $myParentFld name of the parent column
***/
var $myParentFld ="MEC_PARENT";
/**
* @staticvar string $mySortFld name of the sort field
***/
var $mySortFld ="MEC_NAME";
/**
* @var string $myChildClass
***/
var $myChildClass = "MED_CATEGORY_NODE";
/**
* @var int $projId CMS_PROJECT (-1 == all)
* @since pk-06-03-03
***/
var $projId=-1;
/**
* @var boolean $addDefaultProj show project and default project (PROJ_ID=0)
* @since pk-06-03-05
***/
var $addDefaultProj=FALSE;
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// object var access methods
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/**
* sets the projectID
*
* @param int $aProjId
*
* @since pk-06-03-03
*
***/
function set_projId($aProjId) {
$this->projId = $aProjId;
}
/**
* returns if we have set a projId
*
* @returns boolean
*
***/
function projId_IsSet() {
if ($this->projId > -1) return TRUE;
return FALSE;
}
/**
* sets $addDefaultProj
*
* @param boolean $onOff on TRUE off =FALSE
*
* @since pk-06-03-05
*
***/
function setAddDefaulProj_OnOff($onOff) {
$this->addDefaultProj=$onOff;
}
/**
* sets child class vars
*
* @param &DBMS_TREE_NODE $child
*
* @since pk-06-03-05
*
***/
function setChildClassVar(&$child) {
parent::setChildClassVar($child);
$child->set_projId($this->projId);
$child->setAddDefaulProj_OnOff($this->addDefaultProj);
}
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// database methods
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/**
* populates the children
*
* @param bool $useCache
* @param bool $debug
*
* @version pk-05-07-27
*
***/
function populate($useCache=TRUE,$debug=FALSE,$filtered=FALSE) {
if ($debug) echo "<hr />DBMS_TREE::populate(".($useCache ? "USECACHE" : "NOCACHE").") (".get_class($this).")<blockquote>";
$s_query ="SELECT * FROM ".$this->myTable;
$s_query.=" WHERE ".$this->myParentFld."=".$this->getRootId(); // IDs are integer COLUMNS and VALUES
if ((!empty($this->myChildKeys)) && ($keyCols=explode(",",$this->myChildKeys))) {
foreach($keyCols as $col) {
$s_query.=" AND ".$col." = ".$GLOBALS[$this->get_gDBIDX()]->qs_getSlashedValue($this->getKey($col));
}
}
if ($this->projId_IsSet()) {
$s_query.=" AND (PROJ_ID=".intval($this->projId);
if (intval($this->projId) && $this->addDefaultProj) {
$s_query.=" OR PROJ_ID=0";
}
$s_query.=")";
}
if ($filtered && (is_array($this->myFilterArr))) {
foreach($this->myFilterArr as $s_Col => $s_Val) {
$s_query.=" AND ".$s_Col."=".$GLOBALS[$this->get_gDBIDX()]->qs_getSlashedValue($s_Val);
}
}
if (!empty($this->mySortFld)) {
$s_query.=" ORDER BY ".$this->mySortFld;
}
if ($debug) echo "<pre sytle='font-size:10px'>DB: ".$this->get_gDBIDX()."\n$s_query</pre>";
if ($cursor=$GLOBALS[$this->get_gDBIDX()]->query($s_query)) {
$this->myChildren=array();
$noc=0;
while($row = $cursor->fetchArrayFld()) {
$noc++;
if (($useCache) && is_object($GLOBALS['DBMS_TREE'][$this->getGlobalTreeKey()][$row[$this->myIdFld]])) {
if ($debug) echo "using cached object";
$tmpObj=$GLOBALS['DBMS_TREE'][$this->getGlobalTreeKey()][$row[$this->myIdFld]];
} else {
// send 0 as id to avoid reselecting the node from the database
$cmd="\$tmpObj=new ".$this->myChildClass."(0,\"".$this->get_gDBIDX()."\",".($debug ? "TRUE" : "FALSE").");"; /* <pk-04-12-21 /> */
if ($debug) echo "<pre style='font-size:10px;'>CHILD NEW:\n$cmd</pre><blockquote>";
eval($cmd);
if ($debug) echo "</blockquote>";
}
if ($debug) echo "Object Nr $noc created ".print_r(implode(";",$row),TRUE)."";
$tmpObj->setDBRow($row,TRUE,FALSE); // no debug
$tmpObj->setOrderNr($noc);
$this->setChildClassVar($tmpObj);
$tmpObj->setParentId($this->getRootId());
$tmpObj->setLevel(1);
$tmpObj->myTree=&$this;
if ($debug) echo "<blockquote><pre>".print_r($tmpObj->getDBVal())."</pre></blockquote>";
if ($debug) echo "Setting GLOBALS['DBMS_TREE'][".$this->getGlobalTreeKey()."][".$row[$this->myIdFld]."]";
$GLOBALS['DBMS_TREE'][$this->getGlobalTreeKey()][$row[$this->myIdFld]]=$tmpObj;
// copies tmpObj -> do not manipulate $tmpObj from here !!!!!
$this->myChildren[$noc]=$row[$this->myIdFld]; // only the index
}
}
if ($debug) echo "</blockquote>";
return TRUE;
}
/**
* returns a html code to use in select elements
*
* @param MED_CATEGORY_NODE $rootNode
* @param boolean $debug
*
* @returns string
*
* @since pk-04-08-12
*
***/
function getHTMLSelectOptionList($rootNode=NULL,$selectedId=0,$debug=FALSE) {
$nodeArr=$this->getIndexedTreeArr($rootNode,"","","  ","MEC_NAME",$debug);
$ret="";
if ($debug) echo "<hr><blockquote><pre>".pcf_print_r($nodeArr,TRUE,3)."</pre></blockquote>";
if (pcf_is_instance_of($rootNode,"DBMS_TREE_NODE")) {
$ret.="<option value=".$rootNode->getId().">".$rootNode->getDBField("MEC_NAME")."</option>\n";
}
foreach($nodeArr as $node) {
$ret.="<option value=".$node['NODEID'];
if ($selectedId==$node['NODEID']) $ret.= " selected";
$ret.=">".$node['INTEND'].$node['INDEX']." ".$node['NODENAME']."</option>\n";
}
return $ret;
}
}

Source for file MED_CATEGORY.phpclass