PHP Treemenu solution for CCS

  
	  
	$tmp = new myTreeMenu(new clsDBinternetDB(),"directory_categories","category_id_parent","category_id","category_name","category_name");  
	$tmp->rootMenuLegend = "Directory Categories Menu"; // Root menu legend  
	$tmp->expandedbyDefault = false;  
	$tmp->setAllLinks = false; //false generates links at innermost level. Set to true to generate all links  
	$menuLabel->SetValue($tmp->generateTree());  
	unset($tmp);  
	

  
include_once("treemenu/TreeMenu.php");  
include_once("treemenu/Tree.php"); //usually not required to be included here but just in case   
  
class myTreeMenu	{  
	var $connection, $table, $parentIdField, $categoryField, $descriptionField;  
	var $urlField,$keyValueType,$where,$order;  
	var $setAllLinks,$linkTarget,$imagesPath;  
	var $expandedByDefault,$defaultMenuClass;  
  
	function myTreeMenu($connection=null,$table="",$parentIdField="",$categoryField="",$descriptionField="",$urlField="") {  
		if ($connection !== null)  {  
			$this->connection = $connection;    
		}  
		if (strlen($table))    
			$this->table = $table;    
		if (strlen($parentIdField))    
			$this->parentIdField = $parentIdField;    
		if (strlen($categoryField))    
			$this->categoryField = $categoryField;    
		if (strlen($descriptionField))  
			$this->descriptionField = $descriptionField;  
		if (strlen($urlField))    
			$this->urlField = $urlField;    
		$this->where = "";  
		$this->rootMenuLegend 	 = "My Tree Menu";  
		$this->setMenuOptions();  
	}  
  
	function generateTree()  {  
		//call this method from your label's BeforeShow event to generate the tree menu.  
		$this->_setMenuOptions();  
		return $this->_generateTree();  
	}  
      
	function setMenuOptions() {  
		// override these properties in your implementation class to customise the menu to your needs  
		$this->treeMenuFilesPath = "treemenu";  
		$this->order 		 = $this->descriptionField;  
		$this->icon 		 = "folder.gif";  
		$this->expandedIcon 	 = "folder-expanded.gif";  
		$this->linkTarget 	 = "_self";  
		$this->setAllLinks       = false;  
		$this->expandedByDefault = false;  
		$this->defaultStyleClass = "treeMenuDefault";  
		$this->keyValueType 	 = ccsInteger;  
		$this->HTMLStyle = "  
			<style type='text/css'>  
			body {  
				font-family: Comic Sans Serif;  
				font-size: 11pt;  
				font-color: #FFFFFF;  
			}  
		  
			.treeMenuDefault {  
				font-style: Normal;  
				font-color: #FFFFFF;  
			}  
		  
			.treeMenuBold {  
				font-color: #FFFFFF;  
				font-style: italic;  
				font-weight: bold;  
			}  
			</style>";  
  
	}  
	// I do not think there is a need to modify anything beyond this point.  
  
	function _generateTree() {  
		$category_id = 0;  
		$this->menu = new HTML_TreeMenu();  
		$this->menu->additem($this->_generateItems($category_id));  
		$treeMenu = &new HTML_TreeMenu_DHTML(  
							$this->menu,   
							array('images' => $this->imagesPath,  
							      'linkTarget'=> $this->linkTarget,    
								  'defaultClass' => $this->defaultStyleClass  
								)  
						);  
		    $html.= $this->HTMLStyle;  
			$html.= $this->menuJS;  
			$html.=$treeMenu->printMenu();  
			$html.='	';  
			return $html;  
	}  
  
  
	function &_generateItems($category_id)	{  
		$db = $this->connection;  
		$sql = "SELECT "  
			.$this->categoryField.","  
			.$this->descriptionField.","  
			.$this->urlField.","  
			.$this->parentIdField  
			." FROM ".$this->table;  
		$where = (strlen($this->where)) ? $this->where:"";  
		if ($category_id == 0) {  
			$sqlwhere = "(".$this->parentIdField."= 0 OR ".$this->parentIdField." IS NULL)";  
		} else {  
			$sqlwhere = $this->parentIdField."=".$db->ToSQL($category_id,$this->keyValueType);  
		}  
		$where = (strlen($where)) ? $where." AND ".$sqlwhere:$sqlwhere;  
		$order = $this->order;  
		$sql = CCBuildSQL($sql,$where,$order);  
		$db->query($sql);  
		$node = &$this->_addNode($category_id);  
		while ($db->next_record()) {  
			$parent_id = $db->f($this->categoryField);  
			$newnode = &$this->_generateItems($parent_id);  
			$node->additem($newnode);  
		}  
		unset($db);  
		return $node;  
	}  
  
	function &_addNode($category_id) {  
		if ($category_id == 0 || $category_id == null) {  
			$nodeText = $this->rootMenuLegend;  
			$nodeLink = "";  
		} else {  
			$db = $this->connection;  
			$nodeText = CCDLookUp(  
							$this->descriptionField,  
							$this->table,  
							$this->categoryField."="  
								.$db->ToSQL($category_id,$this->keyValueType),  
							$db  
						);  
			$nodeUrl = CCDLookUp(  
							$this->urlField,  
							$this->table,  
							$this->categoryField."="  
								.$db->ToSQL($category_id,$this->keyValueType),  
							$db  
						);  
			if ($this->setAllLinks) {  
				$nodeLink = $nodeUrl;  
			} else {  
				//generate a link only if there are not subcategories  
				$nodeLink = (!$this->_hasSubCats($category_id)) ? $nodeUrl:"";  
			}	  
			unset($db);  
		}  
		$node = &new HTML_TreeNode(  
					array(  
						'text' => $nodeText,  
						'link' => $nodeLink,   
						'icon' => $this->icon,   
						'expandedIcon' => $this->expandedIcon,   
						'expanded' => $this->expandedByDefault  
						)  
					);   
		return $node;  
	}  
  
	function _hasSubCats($category_id) {  
		$db = $this->connection;  
		$subcats = CCDLookup("count(*)",  
					$this->table,  
					$this->parentIdField."="  
						.$db->ToSQL($category_id,$this->keyValueType),  
					$db);  
		unset($db);  
		return $subcats;  
	}  
  
	function _setMenuOptions() {  
		//set/refresh runtime settings  
		$this->imagesPath=$this->treeMenuFilesPath."/images";  
		$this->menuJS = "<script src='"  
					    .$this->treeMenuFilesPath  
						."/TreeMenu.js' language='JavaScript'   
						type='text/javascript'></script>";  
	}  
  
}