怎么调用商品规格？怎么改这段代码

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

我想在商品详细页里面调用礼包，礼包里面显示商品的属性规格，需要重新写过一个函数吗？
大家指点下。。。



  1. function get_goods_properties($goods_id)
  2. {
  3. /* 对属性进行重新排序和分组 */
  4. $sql = "SELECT attr_group ".
  5. "FROM " . $GLOBALS['ecs']->table('goods_type') . " AS gt, " . $GLOBALS['ecs']->table('goods') . " AS g ".
  6. "WHERE g.goods_id='$goods_id' AND gt.cat_id=g.goods_type";
  7. $grp = $GLOBALS['db']->getOne($sql);

  9. if (!empty($grp))
  10. {
  11. $groups = explode("\n", strtr($grp, "\r", ''));
  12. }

  14. /* 获得商品的规格 */
  15. $sql = "SELECT a.attr_id, a.attr_name, a.attr_group, a.is_linked, a.attr_type, ".
  16. "g.goods_attr_id, g.attr_value, g.attr_price " .
  17. 'FROM ' . $GLOBALS['ecs']->table('goods_attr') . ' AS g ' .
  18. 'LEFT JOIN ' . $GLOBALS['ecs']->table('attribute') . ' AS a ON a.attr_id = g.attr_id ' .
  19. "WHERE g.goods_id = '$goods_id' " .
  20. 'ORDER BY a.sort_order, g.attr_price, g.goods_attr_id';
  21. $res = $GLOBALS['db']->getAll($sql);

  23. $arr['pro'] = array(); // 属性
  24. $arr['spe'] = array(); // 规格
  25. $arr['lnk'] = array(); // 关联的属性

  27. foreach ($res AS $row)
  28. {
  29. if ($row['attr_type'] == 0)
  30. {
  31. $group = (isset($groups[$row['attr_group']])) ? $groups[$row['attr_group']] : $GLOBALS['_LANG']['goods_attr'];

  33. $arr['pro'][$group][$row['attr_id']]['name'] = $row['attr_name'];
  34. $arr['pro'][$group][$row['attr_id']]['value'] = $row['attr_value'];
  35. }
  36. else
  37. {
  38. $arr['spe'][$row['attr_id']]['attr_type'] = $row['attr_type'];
  39. $arr['spe'][$row['attr_id']]['name'] = $row['attr_name'];
  40. $arr['spe'][$row['attr_id']]['values'][] = array(
  41. 'label' => $row['attr_value'],
  42. 'price' => $row['attr_price'],
  43. 'format_price' => price_format(abs($row['attr_price']), false),
  44. 'id' => $row['goods_attr_id']);
  45. }

  47. if ($row['is_linked'] == 1)
  48. {
  49. /* 如果该属性需要关联，先保存下来 */
  50. $arr['lnk'][$row['attr_id']]['name'] = $row['attr_name'];
  51. $arr['lnk'][$row['attr_id']]['value'] = $row['attr_value'];
  52. }
  53. }

  55. return $arr;
  56. }
复制代码