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

Ecshop分类树显示分类下的商品数量ECSHOP开发中心（68）第一步：修改includes/lib_goods.php找到function get_categories_tree($cat_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);在这段代码下新增$sql = SELECT cat_id, COUNT(*) AS goods_num . FROM . $GLOBALSecs-table(goods) . AS g . GROUP BY cat_id; $res2 = $GLOBALSdb-getAll($sql); $newres = array(); foreach($res2 AS $row) $newres$rowcat_id = $rowgoods_num; 第二步：在该方法中找到 $cat_arr$rowcat_idid = $rowcat_id;在这代码下增加$cat_arr$rowcat_idnum = !empty($newres$rowcat_id) ? $newres$rowcat_id : 0;第三步：找到function get_child_tree($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);代码下增加$sql = SELECT cat_id, COUNT(*) AS goods_num . FROM . $GLOBALSecs-table(goods) . AS g . GROUP BY cat_id; $res2 = $GLOBALSdb-getAll($sql); $newres = array(); foreach($res2 AS $row) $newres$rowcat_id = $rowgoods_num; 第四步：在该方法中的$three_arr$rowcat_idurl = build_uri(category, array(cid = $rowcat_id), $rowcat_name);代码下增加$three_arr$rowcat_idnum = !empty($newres$rowcat_id) ? $newres$rowcat_id : 0;第五步：修改category_tree.lib库，写入num变量。$|escape:html($cat.num)$|e