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

《ecshop商品分类树 显示该分类下商品数量》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Ecshop商品分类树显示分类下的商品数量ECSHOP开发中心（68ecshop.com）非常简单的改动1、includes/lib_goods.php下找到这两个函数改成我这样就行functionget_categories_tree($cat_id=0)functionget_child_tree($tree_id=0)/***获得指定分类同级的所有分类以及该分类下的子分类**@access public*@param  integer    $cat_id    分类编号*@return array*/functionget_categories_tre

2、e($cat_id=0){   if($cat_id>0)   {       $sql='SELECTparent_idFROM'.$GLOBALS['ecs']->table('category')."WHEREcat_id='$cat_id'";       $parent_id=$GLOBALS['db']->getOne($sql);   }   else   {       $parent_id=0;   }    /*    判断当前分类中全是是否是底级分类，    如果是取出底级分类上级分类，    如果不是取当前分类及其下的子分类   */ 

3、  $sql='SELECTcount(*)FROM'.$GLOBALS['ecs']->table('category')."WHEREparent_id='$parent_id'ANDis_show=1";   if($GLOBALS['db']->getOne($sql)

4、

5、$parent_id==0)   {       /*获取当前分类及其子分类*/       $sql='SELECTcat_id,cat_name,parent_id,is_show'.               'FROM'.$GLOBALS['ecs']->table('ca

6、tegory').               "WHEREparent_id='$parent_id'ANDis_show=1ORDERBYsort_orderASC,cat_idASC";        $res=$GLOBALS['db']->getAll($sql);        foreach($resAS$row)       {           if($row['is_show'])           {               /*获得分类下商品总数begin-老杨：QQ359199843*/               $chil

7、dren=get_children($row['cat_id']);               $sql='SELECTcount(*)'."FROM".$GLOBALS['ecs']->table('goods').'ASg'.               'WHEREg.is_on_sale=1ANDg.is_alone_sale=1AND'.                'g.is_delete=0AND('.$children.'OR'.get_extension_goods($children).')';               $cat_g

8、oods_num=$GLOBALS['db']->getOne($sql);               $cat_arr[$row['cat_id']]['goods_num']  =$cat_goods_num==''?0:$cat_goods_num;                             $cat_arr[$row['cat_id']]['id']  =$row['cat_id'];               $cat_arr[$row['cat_id']]['name']=$row['cat_name'];            

9、   $cat_arr[$row['cat_id']]['url'] =build_uri('category',array('cid'=>$row['cat_id']),$row['cat_name']);                if(isset($row['cat_id'])NULL>               {                   $cat_arr[$row['cat_id']]['cat_id']=get_child_tree($row['cat_id']);               }           }     

10、  }   }   if(isset(