ecshop调用指定分类下分类
2013-09-12 14:18:29   来源：   浏览： 次

在文件 includes/lib_goods.php 最后加上

//*** 调用商品分类指定分类下级分类
function get_parent_id_tree($parent_id)
{
     $three_c_arr = array();
     $sql = 'SELECT count(*) FROM ' . $GLOBALS['ecs']- >table('category') . " WHERE parent_id = '$parent_id' AND is_show = 1 ";
     if ($GLOBALS['db']- >getOne($sql))
     {
         $child_sql = 'SELECT cat_id, cat_name, parent_id, is_show ' .
                 'FROM ' . $GLOBALS['ecs']- >table('category') .
                 "WHERE parent_id = '$parent_id' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC";
         $res = $GLOBALS['db']- >getAll($child_sql);
         foreach ($res AS $row)
         {
             if ($row['is_show'])
                $three_c_arr[$row['cat_id']]['id']   = $row['cat_id'];
                $three_c_arr[$row['cat_id']]['name'] = $row['cat_name'];
                $three_c_arr[$row['cat_id']]['url'] = build_uri('category', array('cid' = > $row['cat_id']), $row['cat_name']);
         }
     }
     return $three_c_arr;
}

声明后用$smarty调用，就是在index.php中加上下面一句：

$smarty->assign('get_parent_id16_tree', get_parent_id_tree(16));//调用父级分类16的下级分类

最后就可以在index.dwt模板文件里开始调用了
<!--{foreach from=$get_parent_id16_tree item=list}-->
<a href="{$list.url}" target="_blank">{$list.name|truncate:15:true}</a>
<!--{/foreach}--></div>