ecshop商品分类树 显示该分类下的商品数量.doc

Ecshop商品分类树 显示分类下的商品数量ECSHOP开发中心（68）非常简单的改动1、includes/lib_goods.php下找到这两个函数改成我这样就行function get_categories_tree($cat_id = 0)function get_child_tree($tree_id = 0)/* 获得指定分类同级的所有分类以及该分类下的子分类* access public* param integer $cat_id 分类编号* return array*/function get_categories_tree($cat_id = 0) if ($cat_id 0) $sql = SELECT parent_id FROM . $GLOBALSecs-table(category) . WHERE cat_id = $cat_id; $parent_id = $GLOBALSdb-getOne($sql); else $parent_id = 0; /* 判断当前分类中全是是否是底级分类， 如果是取出底级分类上级分类， 如果不是取当前分类及其下的子分类 */ $sql = SELECT count(*) FROM . $GLOBALSecs-table(category) . WHERE parent_id = $parent_id AND is_show = 1 ; if ($GLOBALSdb-getOne($sql) | $parent_id = 0) /* 获取当前分类及其子分类 */ $sql = SELECT cat_id,cat_name ,parent_id,is_show . FROM . $GLOBALSecs-table(category) . WHERE parent_id = $parent_id AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC; $res = $GLOBALSdb-getAll($sql); foreach ($res AS $row) if ($rowis_show) /*获得分类下商品总数 begin-老杨：QQ359199843 */ $children = get_children($rowcat_id); $sql = SELECT count(*) . FROM . $GLOBALSecs-table(goods) . AS g . WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND . g.is_delete = 0 AND ( . $children . OR . get_extension_goods($children) . ) ; $cat_goods_num=$GLOBALSdb-getOne($sql); $cat_arr$rowcat_idgoods_num = $cat_goods_num = ? 0 : $cat_goods_num; $cat_arr$rowcat_idid = $rowcat_id; $cat_arr$rowcat_idname = $rowcat_name; $cat_arr$rowcat_idurl = build_uri(category, array(cid = $rowcat_id), $rowcat_name); if (isset($rowcat_id)NULL $cat_arr$rowcat_idcat_id = get_child_tree($rowcat_id); if(isset($cat_arr) return $cat_arr; function get_child_tree($tree_id = 0) $three_arr = array(); $sql = SELECT count(*) FROM . $GLOBALSecs-table(category) . WHERE parent_id = $tree_id AND is_show = 1 ; if ($GLOBALSdb-getOne($sql) | $tree_id = 0) $child_sql = SELECT cat_id, cat_name, parent_id, is_show . FROM . $GLOBALSecs-table(category) . WHERE parent_id = $tree_id AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC; $res = $GLOBALSdb-getAll($child_sql); foreach ($res AS $row) /*获得分类下商品总数 begin-老杨：QQ359199843 */ $children = get_children($rowcat_id); $sql = SELECT count(*) . FROM . $GLOBALSecs-table(goods) . AS g . WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND . g.is_delete = 0 AND ( . $children . OR . get_extension_goods($children) . ) ; $cat_goods_num=$GLOBALSdb-getOne($sql); $three_arr$rowcat_idgoods_num = $cat_goods_num = ? 0 : $cat_goods_num; if ($rowis_show) $three_arr$rowcat_idid = $rowcat_id; $three_arr$rowcat_idname = $rowcat_name; $three_arr$rowcat_idurl = build_uri(category, array(cid = $rowcat_id), $rowcat_name); if (isset($rowcat_id) != NULL) $three_arr$rowcat_idcat_id = get_child_tree($rowcat_id); return $three_arr;复制代码在模板文件中，可能是category_tree.lbi中，也可