DEDECMS获取无限栏目子分类的方法

最新推荐文章于 2023-01-04 15:53:23 发布

kacoro

最新推荐文章于 2023-01-04 15:53:23 发布

阅读量659

点赞数

分类专栏：织梦文章标签： sql function google sun 百度产品

织梦专栏收录该内容

21 篇文章 0 订阅

订阅专栏

做企业网站大部分是使用DEDECMS，今天在给客户设计网站时，把DEDE自动内链和URL全拼格式搞定后，又遇到了个小问题，因为产品分类最多有四级，客户要求在左侧有个弹出式菜单调用各级子分类出来，而DEDECMS默认只能调用一级分类。经过萧涵的努力，百度+GOOGLE+自己脑袋，终于搞定了这个东西，不敢独享，发出来给有需要的朋友分享。

首先要把/include/taglib/channerl.lib.php 文件的代码修改成以下的：

 
 <?php 
function lib_channel(&$ctag,&$refObj)  
{  
global $_sys_globals,$envs,$dsql;  
$attlist = “typeid|0,reid|0,row|100,col|1,type|son,currentstyle|”;  
FillAttsDefault($ctag->CAttribute->Items,$attlist);  
extract($ctag->CAttribute->Items, EXTR_SKIP);  
$innertext = $ctag->GetInnerText();  
if(empty($typeid) && $envs['typeid']!=0)  
{  
$typeid = $envs['typeid'];  
$reid = $envs['reid'];  
}else{  
$reid=0;  
}  
 
if($type==”||$type==’sun’) $type=”son”;  
if($innertext==”) $innertext = GetSysTemplets(“channel_list.htm”);  
 
if($reid==0 && $typeid>0)  
{  
$dbrow = $dsql->GetOne(“Select reid From ying_arctype where id=’$typeid’ “);  
if(is_array($dbrow)) $reid = $dbrow['reid'];  
}  
 
$likeType = ”;  
if($type==’top’)  
{  
$sql = “Select id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath,description  
From ying_arctype where reid=0 And ishidden<>1 order by sortrank asc limit 0,$row”;  
}  
else if($type==”son”)  
{  
//if($_sys_globals['typeid']>0) $typeid = $_sys_globals['typeid'];  
if($typeid==0) {  
return ”;  
}  
$sql = “Select id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath,description  
From ying_arctype where reid=’$typeid’ And ishidden<>1 order by sortrank asc limit 0,$row”;  
}  
else if($type==”self”)  
{  
if($reid==0) {  
return ”;  
}  
$sql = “Select id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath,description  
From ‘ying_arctype’ where reid=’$reid’ And ishidden<>1 order by sortrank asc limit 0,$row”;  
}  
//And id<>’$typeid’  
$dtp2 = new DedeTagParse();  
$dtp2->SetNameSpace(“field”,”[","]“);  
$dtp2->LoadSource($innertext);  
$dsql2 = clone $dsql;  
$dsql->SetQuery($sql);  
$dsql->Execute();  
 
$line = $row;  
$GLOBALS['autoindex'] = 0;  
for($i=0;$i < $line;$i++)  
{  
if($col>1) $likeType .= “<dl>\r\n”;  
for($j=0;$j<$col;$j++)  
{  
if($col>1) $likeType .= “<dd>\r\n”;  
if($row=$dsql->GetArray())  
{  
if($type==’self’ && $row['id']==$typeid) //处理同级栏目中，当前栏目的样式  
{  
if($currentstyle!=”)  
{  
$linkOkstr = $currentstyle;  
$row['typelink'] = GetOneTypeUrlA($row);  
$linkOkstr = str_replace(“~typelink~”,$row['typelink'],$linkOkstr);  
$linkOkstr = str_replace(“~typename~”,$row['typename'],$linkOkstr);  
$likeType .= $linkOkstr;  
}  
}else  
{  
$row['typelink'] = $row['typeurl'] = GetOneTypeUrlA($row);  
if(is_array($dtp2->CTags))  
{  
foreach($dtp2->CTags as $tagid=>$ctag){  
if(isset($row[$ctag->GetName()]))  
{  
$dtp2->Assign($tagid,$row[$ctag->GetName()]);  
}  
elseif (preg_match(‘/^sonchannel[0-9]*$/’,$ctag->GetName()))  
{  
$dtp2->Assign($tagid,lib_channel_son($ctag,$row['id'],$dsql2));  
}  
}  
}  
$likeType .= $dtp2->GetResult();  
}  
}  
if($col>1) $likeType .= “</dd>\r\n”;  
$GLOBALS['autoindex']++;  
}//Loop Col  
if($col>1)  
{  
$i += $col – 1;  
$likeType .= ” </dl>\r\n”;  
}  
}//Loop for $i  
reset($dsql2);  
$dsql->FreeResult();  
return $likeType;  
}  
function lib_channel_son($ctag,$typeid = 0,$dsql2)  
{  
$attlist = “row|100,col|1,currentstyle|”;  
FillAttsDefault($ctag->CAttribute->Items,$attlist);  
extract($ctag->CAttribute->Items, EXTR_SKIP);  
$innertext = $ctag->GetInnerText();  
$dsql3 = clone $dsql2;  
$likeType = ”;  
 
//if($_sys_globals['typeid']>0) $typeid = $_sys_globals['typeid'];  
if($typeid==0) {  
return ”;  
}  
$sql = “Select id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath,description  
From ying_arctype where reid=’$typeid’ And ishidden<>1 order by sortrank asc limit 0,$row”;  
//And id<>’$typeid’  
$dtp2 = new DedeTagParse();  
$dtp2->SetNameSpace(“field”,”[","]“);  
$dtp2->LoadSource($innertext);  
$dsql2->SetQuery($sql);  
$dsql2->Execute();  
$line = $row;  
 
for($i=0;$i < $line;$i++)  
{  
if($col>1) $likeType .= “<dl>\r\n”;  
for($j=0;$j<$col;$j++)  
{  
if($col>1) $likeType .= “<dd>\r\n”;  
if($row=$dsql2->GetArray())  
{  
$row['typelink'] = $row['typeurl'] = GetOneTypeUrlA($row);  
if(is_array($dtp2->CTags))  
{  
foreach($dtp2->CTags as $tagid=>$ctag){  
if(isset($row[$ctag->GetName()]))  
{  
$dtp2->Assign($tagid,$row[$ctag->GetName()]);  
}  
elseif (preg_match(‘/^sonchannel[0-9]*$/’,$ctag->GetName()))  
{  
$dtp2->Assign($tagid,lib_channel_son($ctag,$row['id'],$dsql3));  
}  
}  
}  
$likeType .= $dtp2->GetResult();  
}  
if($col>1) $likeType .= “</dd>\r\n”;  
}//Loop Col  
if($col>1)  
{  
$i += $col – 1;  
$likeType .= ” </dl>\r\n”;  
}  
}//Loop for $i  
reset($dsql3);  
$dsql2->FreeResult();  
return $likeType;  
}  
?>

在模板里面用 [field:sonchannel0] [/field:sonchannel0] 调用，这个是用来取子栏目用得（使用【sonchannel+数字】作为标签名是为了防止嵌套的时候无法正确解析标签），这个的作用就是当你的栏目有很多子栏目无限分级的时候方便你取子栏目的。实例一下：

 
 <ul id=”left_nav”> 
                    {dede:channel type=’son’ typeid=’16′}  
     <li><a href=”[field:typelink/]“>[field:typename/]</a> 
      <ul> 
       [field:sonchannel0]  
       <li><a href=”[field:typelink/]“>[field:typename/]</a> 
                             <ul> 
        [field:sonchannel1]  
        <li><a href=”[field:typelink/]“>[field:typename/]</a> 
                                 <ul> 
         [field:sonchannel2]  
         <li><a href=”[field:typelink/]“>[field:typename/]</a> 
                                     <ul> 
          [field:sonchannel3]  
          <li><a href=”[field:typelink/]“>[field:typename/]</a></li> 
          [/field:sonchannel3]  
                                        </ul> 
                                    </li> 
         [/field:sonchannel2]  
                                    </ul> 
                                </li> 
        [/field:sonchannel1]  
                                </ul> 
                            </li> 
       [/field:sonchannel0]  
      </ul> 
                    </li> 
     {/dede:channel}  
                </ul>