文档介绍：Ecshop修改教程
本教程来次
68ecshop模板组常用SQL语句
UPDATE ecs_goods SET goods_number= '5000' 设置所有演示数据库存数为5000
商品详情页面属性价格显示其对应价格
ecshop默认的商品属性显示的是加多少钱
现在想让它显示不同属性对应多少钱如图
 
第一步:
function get_goods_properties   方法
将下面的get_goods_properties方法覆盖掉原来的get_goods_properties方法
/**
 * 获得商品的属性和规格
 *
 * ***@access  public
 * ***@param   integer $goods_id
 * ***@return  array
 */
 //yyy修改start
function get_goods_properties($goods_id , $shop_price=0)
//yyy修改end
{
    /* 对属性进行重新排序和分组*/
    $sql = "SELECT attr_group ".
            "FROM " . $GLOBALS['ecs']->table('goods_type') . " AS gt, " . $GLOBALS['ecs']->table('goods') . " AS g ".
            "WHERE ='$goods_id' AND =";
    $grp = $GLOBALS['db']->getOne($sql);
    if (!empty($grp))
    {
        $groups = explode("\n", strtr($grp, "\r", ''));
    }
    /* 获得商品的规格*/
    $sql = "SELECT , , , , , ".
                ", , " .
            'FROM ' . $GLOBALS['ecs']->table('goods_attr') . ' AS g ' .
            'LEFT JOIN ' . $GLOBALS['ecs']->table('attribute') . ' AS a ON = ' .
            "WHERE = '$goods_id' " .
            'ORDER BY , , ';
    $res = $GLOBALS['db']->getAll($sql);
    $arr['pro'] = array();     // 属性
    $arr['spe'] = array();     // 规格
    $arr['lnk'] = array();     // 关联的属性
foreach ($res AS $row)
    {
        $row['attr_value'] = str_replace("\n", '<br />', $row['attr_value']);
        if ($row['attr_type'] == 0)
        {
            $group = (isset($groups[$row['attr_group']])) ? $groups[$row['attr_group']] : $GLOBALS['_LANG']['goods_attr'];
            $arr['pro'][$group][$row['attr_id']]['name']  = $row['attr_name'];
            $arr['pro'][$group][$row['attr_id']]['value'] = $row['attr_value'];
        }
        else
        {
            $arr['spe'][$row['attr_id']]['attr_