[OK]ECSHOP后台的商品列表里显示商品品牌

来源:互联网 发布:mdb数据库查看器 编辑:程序博客网 时间:2024/04/29 10:53

第一步:
首先我们来打开程序文件: /admin/includes/lib_goods.php

定位到 goods_list  函数部分

找到下面代码(大概在911行左右)

$sql = "SELECT goods_id, goods_name, goods_type, goods_sn, shop_price, is_on_sale, is_best, is_new, is_hot, sort_order, goods_number, integral, " .                    " (promote_price > 0 AND promote_start_date <= '$today' AND promote_end_date >= '$today') AS is_promote ".                    " FROM " . $GLOBALS['ecs']->table('goods') . " AS g WHERE is_delete='$is_delete' $where" .                    " ORDER BY $filter[sort_by] $filter[sort_order] ".                    " LIMIT " . $filter['start'] . ",$filter[page_size]";

将它修改为

$sql = "SELECT goods_id, goods_name, goods_type, goods_sn, shop_price, is_on_sale, is_best, is_new, is_hot, g.sort_order, goods_number, integral, " .                    " (promote_price > 0 AND promote_start_date <= '$today' AND promote_end_date >= '$today') AS is_promote,b.brand_name ".                    " FROM " . $GLOBALS['ecs']->table('goods') . " AS g "."left join ".$GLOBALS['ecs']->table('brand') . " AS b on g.brand_id=b.brand_id "." WHERE is_delete='$is_delete' $where" .                    " ORDER BY $filter[sort_by] $filter[sort_order] ".                    " LIMIT " . $filter['start'] . ",$filter[page_size]";


第二步:

修改 admin/templates/goods_list.htm 文件

找到

{$goods.goods_name|escape:html}

在它后面增加一行代码:

(品牌:{$goods.brand_name}

找到


    <th><a href="javascript:listTable.sort('goods_name'); ">{$lang.goods_name}</a>{$sort_goods_name}</th>

在它后面增加一行代码:
    <th><a href="javascript:listTable.sort('brand_name'); ">{$lang.brand_name}</a>{$sort_brand_name}</th>


修改到这里,你会发现品牌是能显示出来了,但是搜索功能里的按品牌搜索却失效了。别着急,第三步就是来解决这个问题的。

第三步(很重要):

向上,找到下面代码(大概在865行左右)

$where .= " ANDbrand_id='$filter[brand_id]'";

将它修改为

$where .= " AND g.brand_id='$filter[brand_id]'";