如何将ecshop"商品的备注"内容打印出来?

2016-07-07 16:01 来源:www.chinab4c.com 作者:ecshop专家

订单打印设置里已经写了{$goods.seller_note},但打印还是不出来!
求大神解答!

回答:
模板文件里的标签都是由php赋值来的,
对应的PHP文件没有读取 seller_note,你调用一年也出不来的。
修改 admin/order.php文件
在下面的SQL语句中加入g.seller_note字段
  1. $sql = "SELECT o.*, IF(o.product_id > 0, p.product_number, g.goods_number) AS storage, o.goods_attr, g.suppliers_id, IFNULL(b.brand_name, '') AS brand_name, p.product_sn
  2. FROM " . $ecs->table('order_goods') . " AS o
  3. LEFT JOIN " . $ecs->table('products') . " AS p
  4. ON p.product_id = o.product_id
  5. LEFT JOIN " . $ecs->table('goods') . " AS g
  6. ON o.goods_id = g.goods_id
  7. LEFT JOIN " . $ecs->table('brand') . " AS b
  8. ON g.brand_id = b.brand_id
  9. WHERE o.order_id = '$order[order_id]'";
复制代码


能告诉我怎么加入字段吗?小白不太懂!谢谢!

谢谢!已经知道了!

哦,这么快解决了,还是论坛好人多啊。

这里的人都是专业的呀

收藏了,正需要!!!!