欢迎光临
我们一直在努力

ecshop 分类树统计显示商品数量

includes/lib_goods.php 下找到这两个函数

function get_categories_tree
function get_child_tree

在它们2个函数里面找到

foreach ($res AS $row)

function get_categories_tree 的里面加入

/*获得分类下商品总数*/
$children = get_children($row['cat_id']);
$sql = 'SELECT count(*)' . "FROM " . $GLOBALS['ecs']->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=$GLOBALS['db']->getOne($sql);
$cat_arr[$row['cat_id']]['goods_num'] = $cat_goods_num == '' ? 0 : $cat_goods_num;

function get_child_tree 的里面加入

/*获得分类下商品总数*/
$children = get_children($row['cat_id']);
$sql = 'SELECT count(*)' . "FROM " . $GLOBALS['ecs']->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=$GLOBALS['db']->getOne($sql);
$three_arr[$row['cat_id']]['goods_num']   = $cat_goods_num == '' ? 0 : $cat_goods_num;

End!

赞(0) 打赏
未经允许不得转载:程序开发爱好者 » ecshop 分类树统计显示商品数量
分享到: 更多 (0)

网站设计及开发、微应用及微网站开发、微信公众平台开发、 HTML5手机网站开发、网络整合营销、APP开发、软件开发及企业电商服务

联系我们