登 录
<?php<br /> /**<br /> * 功能: 根据条件建立分类缓存减少类别使用<br /> * 创建日期:Thu May 31 15:55:11 CST 2007<br /> * 最后更新:<br /> * 作者: sanshi <sanshi0815@tom.com><br /> */</p> <p>class treeCache<br /> {<br /> var $tableName = "index_category"; //表名<br /> var $where = "1"; //where条件<br /> var $pidStr ="i_c_pid"; //pid 的字段名<br /> var $tempCode = array(); //生成文件的数组<br /> var $pid = '0'; //pid的初始值<br /> var $db ; //数据库句柄<br /> var $idStr="i_c_id"; //取得的数据id<br /> var $title = "i_c_cn"; //名字字段<br /> var $createArrayName = "treeCache"; //建立的数组名字<br /> var $createFileName =""; //建立文件的名字<br /> var $appendArr = array(); //附加的属性，需要字段名与数据里的名对应<br /> var $is_utf8 = false;<br /> function treeCache()<br /> {<br /> }<br /> function set($db)<br /> {<br /> $this->db = $db;<br /> $this->tempCode[] = "<?php";<br /> }<br /> //取得所有的一级<br /> function getRootID()<br /> {<br /> $sql = "SELECT {$this->idStr} FROM {$this->tableName} WHERE<br /> {$this->pidStr}='{$this->pid}' AND {$this->where} ";<br /> //exit($sql);<br /> $result = $this->db->select($sql);<br /> $temp = array();<br /> foreach ($result as $r)<br /> {<br /> $temp[]=$r["{$this->idStr}"];<br /> }<br /> $this->tempCode[] = "/${$this->createArrayName}['root']='".implode(',',$temp)."';";<br /> //print_r($temp);<br /> return $temp;<br /> }<br /> //取得子id<br /> function getChildren($pid)<br /> {<br /> $sql = "SELECT {$this->idStr} FROM {$this->tableName} WHERE<br /> {$this->pidStr}='{$pid}' AND {$this->where} ";<br /> $result = $this->db->select($sql);<br /> $temp = array();<br /> foreach ($result as $r)<br /> {<br /> $temp[]=$r["{$this->idStr}"];<br /> }<br /> return $temp;<br /> }<br /> //取得夫id<br /> function getParent($cid)<br /> {<br /> $sql = "SELECT {$this->pidStr} FROM {$this->tableName} WHERE<br /> {$this->idStr}='{$cid}' AND {$this->where} ";<br /> $result = $this->db->select($sql);<br /> //print_r($result);exit();<br /> return $result[0]["{$this->pidStr}"];<br /> }<br /> //取得上级的id<br /> function getPidStr($cid,$pidStr="")<br /> {<br /> $pid=$this->getParent($cid);<br /> $temp = array();<br /> while ($pid!=$this->pid && !empty($pid)) {<br /> $temp[] = $pid;<br /> $pid=$this->getParent($pid);<br /> }<br /> //print_r($temp);<br /> return implode(',',$temp);<br /> }<br /> //取得深度<br /> function getDepth($cid,$depth=0)<br /> {<br /> $pid=$this->getParent($cid);<br /> $depth++;<br /> if( $pid != $this->pid && !empty($pid))<br /> $depth = $this->getDepth($pid,$depth);<br /> return $depth;<br /> }<br /> //建立文件<br /> function make()<br /> {<br /> if(empty($this->createFileName))<br /> $this->createFileName = "{$this->createArrayName}.data.php";</p> <p> $rootArr = $this->getRootID();<br /> $selectF = "{$this->idStr},{$this->title},{$this->pidStr}";<br /> foreach ($this->appendArr as $app)<br /> {<br /> if(empty($app)) continue;<br /> $selectF .=",{$app}";<br /> }<br /> $sql = "SELECT {$selectF} FROM {$this->tableName} WHERE<br /> {$this->where}";<br /> $result = $this->db->select($sql);<br /> for ($i=0;$i<count($result);$i++)<br /> {<br /> //id值<br /> $this->tempCode[] =<br /> "/${$this->createArrayName}['{$result[$i][$this->idStr]}']['id']='{$result[$i]["{$this->idStr}"]}';";<br /> //标题<br /> $this->tempCode[] =<br /> "/${$this->createArrayName}['{$result[$i][$this->idStr]}']['title']='{$result[$i]["{$this->title}"]}';";<br /> //父id<br /> $this->tempCode[] =<br /> "/${$this->createArrayName}['{$result[$i][$this->idStr]}']['pid']='{$result[$i]["{$this->pidStr}"]}';";<br /> //子id<br /> $this->tempCode[] =<br /> "/${$this->createArrayName}['{$result[$i][$this->idStr]}']['cid']='".implode(',',$this->getChildren($result[$i]["$this->idStr"]))."';";<br /> //目录深度<br /> $this->tempCode[] =<br /> "/${$this->createArrayName}['{$result[$i][$this->idStr]}']['depth']='".$this->getDepth($result[$i]["$this->idStr"])."';";<br /> //父id的id串<br /> $this->tempCode[] =<br /> "/${$this->createArrayName}['{$result[$i][$this->idStr]}']['pstr']='".$this->getPidStr($result[$i]["$this->idStr"])."';";<br /> //添加的附加属性<br /> foreach ($this->appendArr as $app)<br /> {<br /> if(empty($app)) continue;<br /> $this->tempCode[] =<br /> "/${$this->createArrayName}['{$result[$i][$this->idStr]}']['{$app}']='{$result[$i]["{$app}"]}';";<br /> }<br /> }<br /> $this->tempCode[] = "return /${$this->createArrayName};";<br /> $this->tempCode[] = "?>";<br /> //$content = implode("/n",$this->tempCode);<br /> //print_r($this->tempCode);<br /> $content = implode("/n",$this->tempCode);<br /> //建立文件<br /> $fio=Factory::getBaseClass('FileIO');<br /> if($this->is_utf8) $content = "/xEF/xBB/xBF".$content;<br /> $fio->writeFile($this->createFileName,$content);<br /> return $content ;<br /> }<br /> }<br /> //加载的文件就是为了，数据库连接<br /> //需要数据库有 select 方法<br /> /*<br /> include_once(dirname(dirname(__FILE__))."/config/config.inc.php");<br /> include_once(CLASSES_PATH."factryObject.class.php");</p> <p>$db = factryObject::getDB('indexPush');<br /> $c = new treeCache($db);<br /> $c->make();<br /> //exit();</p> <p>//做分析<br /> include_once("treeCache.data.php");<br /> $treeCache=isset($treeCache) ? $treeCache : array();<br /> $rootStr = isset($treeCache['root']) ? $treeCache['root'] : "";<br /> echo parseTree($treeCache,$rootStr);<br /> function parseTree($treeCache,$rootStr)<br /> {<br /> $tempStr = "";<br /> $temp = explode(',',$rootStr);<br /> foreach ($temp AS $cid)<br /> {<br /> $info = $treeCache[$cid];<br /> $cidStr = $info['cid'];<br /> $tempStr .= str_repeat('-',($info['depth']-1)*3);<br /> $tempStr.=$info['title'];<br /> if(empty($info['pid']))<br /> {<br /> //附加操作<br /> }<br /> $tempStr .= "<br/>";<br /> if(!empty($info['cid']))<br /> $tempStr .=parseTree($treeCache,$info['cid']);<br /> }<br /> return $tempStr;<br /> }<br /> */<br /> ?>
这个类是改善过的，当初做这个的适合，只能是数字的作为数组下标，这次支持字母了
另外就是关于解析
<?php<br /> class parseTree<br /> {<br /> var $ads_type_file = "";<br /> var $isX = false;<br /> var $rowSize=2;<br /> function parseTree()<br /> {<br /> $this->ads_type_file = CACHE_PATH."ads_type_arr.data.php";<br /> $this->ads_city_file = CACHE_PATH."ads_city_arr.data.php";<br /> }<br /> function make_ads_type()<br /> {<br /> $db = Factory::getDB("ads_type");<br /> $tree =Factory::getItemClass('treeCache');<br /> $tree->set($db);<br /> $tree->tableName=$db->tableName;<br /> $tree->pidStr ="ads_type_pid";<br /> $tree->idStr = "ads_type_id";<br /> $tree->title = "ads_type_name";<br /> $tree->createArrayName ="ads_type_arr";<br /> $tree->where = " ads_type_state=1 ORDER BY ads_type_id DESC ";<br /> $tree->appendArr = array("ads_type_info");<br /> $tree->createFileName = $this->ads_type_file;<br /> $tree->is_utf8 = true;<br /> return $tree->make();<br /> }<br /> function get_ads_type_str()<br /> {<br /> $temp_arr = $this->get_ads_type_arr();<br /> $treeArr = empty($temp_arr) ? array() : $temp_arr;<br /> $rootStr = isset($temp_arr['root']) ? $temp_arr['root'] : "";<br /> $show_content = $this->__parseTree($treeArr,$rootStr,'pares_type_link');<br /> return $show_content;<br /> }<br /> function get_ads_type_arr()<br /> {<br /> return is_file($this->ads_type_file) ? require($this->ads_type_file) : array();<br /> }<br /> function pares_type_link($info)<br /> {<br /> $class_name = "ads_type";<br /> $tempStr = "[<a href="?c={$class_name}&m=add&ads_type_pid={$info[" mce_href="?c={$class_name}&m=add&ads_type_pid={$info["id']}'>子-添加</a>]";<br /> $tempStr .="[<a href="?c={$class_name}&m=edit&ads_type_id={$info[" mce_href="?c={$class_name}&m=edit&ads_type_id={$info["id']}'>编辑</a>]";<br /> $tempStr .="[<a href="?c={$class_name}&m=del&ads_type_id={$info[" mce_href="?c={$class_name}&m=del&ads_type_id={$info["id']}'>删除</a>]";<br /> return $tempStr;<br /> }<br /> //根据提供的类别号取得类别数组<br /> function get_type_arr($type_no=0)<br /> {<br /> $temp_arr = $this->get_ads_type_arr();<br /> $rootStr = $type_no==0 ? (isset($temp_arr['root'])?$temp_arr['root'] : "") : (isset($temp_arr[$type_no]['cid'])?$temp_arr[$type_no]['cid']:"");<br /> $temp = explode(',',$rootStr);<br /> $return_temp = array();<br /> foreach($temp as $cid)<br /> {<br /> if(isset($temp_arr[$cid])) $return_temp[$temp_arr[$cid]['id']]=$temp_arr[$cid]['title'];<br /> }<br /> return $return_temp;<br /> }</p> <p> function make_ads_city()<br /> {<br /> $db = Factory::getDB("ads_city");<br /> $tree =Factory::getItemClass('treeCache');<br /> $tree->set($db);<br /> $tree->tableName=$db->tableName;<br /> $tree->pidStr ="ads_city_pid";<br /> $tree->idStr = "ads_city_no";<br /> $tree->title = "ads_city_name";<br /> $tree->createArrayName ="ads_city_arr";<br /> $tree->where = " ads_city_state=1 ORDER BY ads_city_no DESC ";<br /> $tree->appendArr = array("ads_city_info");<br /> $tree->createFileName = $this->ads_city_file;<br /> $tree->is_utf8 = true;<br /> return $tree->make();<br /> }<br /> function get_ads_city_arr()<br /> {<br /> return is_file($this->ads_city_file) ? require($this->ads_city_file) : array();<br /> }<br /> function get_ads_city_str()<br /> {<br /> $temp_arr = $this->get_ads_city_arr();<br /> $treeArr = empty($temp_arr) ? array() : $temp_arr;<br /> $rootStr = isset($temp_arr['root']) ? $temp_arr['root'] : "";<br /> $show_content = $this->__parseTree($treeArr,$rootStr,'pares_city_link');<br /> return $show_content;<br /> }<br /> function pares_city_link($info)<br /> {<br /> $class_name = "ads_city";<br /> $tempStr = "[<a href="?c={$class_name}&m=add&ads_city_pid={$info[" mce_href="?c={$class_name}&m=add&ads_city_pid={$info["id']}'>子-添加</a>]";<br /> $tempStr .="[<a href="?c={$class_name}&m=edit&ads_city_no={$info[" mce_href="?c={$class_name}&m=edit&ads_city_no={$info["id']}'>编辑</a>]";<br /> $tempStr .="[<a href="?c={$class_name}&m=del&ads_city_no={$info[" mce_href="?c={$class_name}&m=del&ads_city_no={$info["id']}'>删除</a>]";<br /> return $tempStr;<br /> }<br /> //根据提供的城市号取得城市数组<br /> function get_city_arr($city_no=0)<br /> {<br /> $temp_arr = $this->get_ads_city_arr();<br /> $rootStr = $city_no==0 ? (isset($temp_arr['root'])?$temp_arr['root'] : "") : (isset($temp_arr[$city_no])?$temp_arr[$city_no]:"");<br /> $temp = explode(',',$rootStr);<br /> $return_temp = array();<br /> foreach($temp as $cid)<br /> {<br /> if(isset($temp_arr[$cid])) $return_temp[$temp_arr[$cid]['id']]=$temp_arr[$cid]['title'];<br /> }<br /> return $return_temp;<br /> }</p> <p> function __parseTree($treeCache,$rootStr,$fuc_str)<br /> {<br /> $tempStr = "";<br /> $temp = explode(',',$rootStr);<br /> if(empty($temp)) return "";<br /> $this->layer=0;<br /> foreach ($temp AS $cid)<br /> {<br /> if(isset($treeCache[$cid]))<br /> {<br /> $info = $treeCache[$cid];<br /> $cidStr = $info['cid'];<br /> //如果下面有子id<br /> if($info["cid"]!="")<br /> {<br /> $tempStr .="<div >";<br /> $tempStr .= str_repeat(' ',($info['depth']-1)*3);<br /> if($info["cid"]!="")<br /> {<br /> //$tempStr .="<img src="/images/arrow.jpg" mce_src="images/arrow.jpg" style="cursor:hand;" mce_style="cursor:hand;" onClick='javascript:ShowMenu(/"l_{$info['id']}/");' id='pic_l_{$info['id']}'>";<br /> }<br /> //$tempStr .=">";<br /> $tempStr.=$info['title'];<br /> $tempStr .=$this->{$fuc_str}($info);<br /> $tempStr .="</div>";<br /> $tempStr .="<div id='l_{$info['id']}' >";<br /> $tempStr .= $this->__parseTree($treeCache,$info['cid'],$fuc_str);<br /> $tempStr .="</div>";<br /> }else{<br /> $this->layer++;<br /> $tempStr .= str_repeat(' ',($info['depth']-1)*3);<br /> $tempStr.=$info['title'];<br /> $tempStr .=$this->{$fuc_str}($info);<br /> if($this->isX==true)<br /> {<br /> if($this->layer % $this->rowSize ==0)<br /> $tempStr .= "<br/>";<br /> else<br /> $tempStr .= " ";<br /> }else{<br /> $tempStr .= "<br/>";<br /> }<br /> }<br /> }<br /> }<br /> return $tempStr;<br /> }<br /> }<br /> ?>
抱歉!评论已关闭.