商品详情页面的销售记录中如何包含配送区域？

2016-07-07 15:02 来源：www.chinab4c.com 作者：ecshop专家


给你一个思路，你可以看下发货单打印，看下里面的地区获取方式。

回答：
  1. function getsales_history($goods_id){

  3. $sql ='select f.c**ignee, f.order_sn, f.address, g.goods_number,f.add_time FROM '. $GLOBALS['ecs']->table('order_goods') .' as g,'. $GLOBALS['ecs']->table('order_info') .' as f where g.order_id = f.order_id and g.goods_id='.$goods_id;

  5. $res = $GLOBALS['db']->getAll($sql);

  7. $sales_history = array();

  9. foreach ($res AS $idx => $row){

  11. $order_id = $row['order_id'];

  13. $sql = "SELECT concat(IFNULL(c.region_name, ''), '', IFNULL(p.region_name, ''), " .
  14. "'', IFNULL(t.region_name, ''), '', IFNULL(d.region_name, '')) AS region " .
  15. "FROM " . $ecs->table('order_info') . " AS o " .
  16. "LEFT JOIN " . $ecs->table('region') . " AS c ON o.country = c.region_id " .
  17. "LEFT JOIN " . $ecs->table('region') . " AS p ON o.province = p.region_id " .
  18. "LEFT JOIN " . $ecs->table('region') . " AS t ON o.city = t.region_id " .
  19. "LEFT JOIN " . $ecs->table('region') . " AS d ON o.district = d.region_id " .
  20. "WHERE o.order_id = '$order_id'";


  23. $region = $db->getOne($sql);


  26. $sales_history[$idx]['address'] = $region . sub_str($row['c**ignee'], 1, false).'**'



  30. $sales_history[$idx]['order_sn'] = $row['order_sn'];

  32. $sales_history[$idx]['address'] = sub_str($row['address'], 10, false).'*******';

  34. $sales_history[$idx]['number'] = $row['goods_number'];

  36. // $sales_history[$idx]['add_time'] = local_date("Y-m-d", $row['add_time']);

  38. $sales_history[$idx]['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']);



  42. }

  44. return $sales_history;

  46. }
复制代码