ecshop文章页关联商品显示商品简单描述

2016-09-07 22:03 来源:www.chinab4c.com 作者:ecshop专家

chinab4c在给客户制作ecshop时候,发现文章内关联商品都比较简洁,若是能在关联商品的标题下面显示简单的产品描述,那样会比较好看。

如下图:

 

chinab4c研究出如下方法:

找到 ecshop根目录文件article.php

获得文章关联的商品 这个定义函数:

原是:

 

/**

 * 获得文章关联的商品

 *

 * @access  public

 * @param   integer $id

 * @return  array

 */

function article_related_goods($id)

{

    $sql = 'SELECT g.goods_id, g.goods_name, g.goods_thumb, g.goods_img, g.shop_price AS org_price, ' .

                "IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, ".

                'g.market_price, g.promote_price, g.promote_start_date, g.promote_end_date ' .

            'FROM ' . $GLOBALS['ecs']->table('goods_article') . ' ga ' .

            'LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON g.goods_id = ga.goods_id ' .

            "LEFT JOIN " . $GLOBALS['ecs']->table('member_price') . " AS mp ".

                    "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' ".

            "WHERE ga.article_id = '$id' AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0";

    $res = $GLOBALS['db']->query($sql);

 

    $arr = array();

    while ($row = $GLOBALS['db']->fetchRow($res))

    {

        $arr[$row['goods_id']]['goods_id']      = $row['goods_id'];

        $arr[$row['goods_id']]['goods_name']    = $row['goods_name'];

        $arr[$row['goods_id']]['short_name']   = $GLOBALS['_CFG']['goods_name_length'] > 0 ?

            sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];

        $arr[$row['goods_id']]['goods_thumb']   = get_image_path($row['goods_id'], $row['goods_thumb'], true);

        $arr[$row['goods_id']]['goods_img']     = get_image_path($row['goods_id'], $row['goods_img']);

        $arr[$row['goods_id']]['market_price']  = price_format($row['market_price']);

        $arr[$row['goods_id']]['shop_price']    = price_format($row['shop_price']);

        $arr[$row['goods_id']]['url']           = build_uri('goods', array('gid' => $row['goods_id']), $row['goods_name']);

 

        if ($row['promote_price'] > 0)

        {

            $arr[$row['goods_id']]['promote_price'] = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);

            $arr[$row['goods_id']]['formated_promote_price'] = price_format($arr[$row['goods_id']]['promote_price']);

        }

        else

        {

            $arr[$row['goods_id']]['promote_price'] = 0;

        }

    }

 

    return $arr;

}

 

修改成:

 

/**

 * 获得文章关联的商品

 *

 * @access  public

 * @param   integer $id

 * @return  array

 */

function article_related_goods($id)

{

    $sql = 'SELECT g.goods_id, g.goods_name, g.goods_thumb, g.goods_img, g.goods_brief, g.shop_price AS org_price, ' .

                "IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, ".

                'g.market_price, g.promote_price, g.promote_start_date, g.promote_end_date ' .

            'FROM ' . $GLOBALS['ecs']->table('goods_article') . ' ga ' .

            'LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON g.goods_id = ga.goods_id ' .

            "LEFT JOIN " . $GLOBALS['ecs']->table('member_price') . " AS mp ".

                    "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' ".

            "WHERE ga.article_id = '$id' AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0";

    $res = $GLOBALS['db']->query($sql);

 

    $arr = array();

    while ($row = $GLOBALS['db']->fetchRow($res))

    {

        $arr[$row['goods_id']]['goods_id']      = $row['goods_id'];

        $arr[$row['goods_id']]['goods_name']    = $row['goods_name'];

 

        $arr[$row['goods_id']]['short_name']   = $GLOBALS['_CFG']['goods_name_length'] > 0 ?

            sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];

        $arr[$row['goods_id']]['goods_thumb']   = get_image_path($row['goods_id'], $row['goods_thumb'], true);

        $arr[$row['goods_id']]['goods_img']     = get_image_path($row['goods_id'], $row['goods_img']);

        $arr[$row['goods_id']]['market_price']  = price_format($row['market_price']);

        $arr[$row['goods_id']]['shop_price']    = price_format($row['shop_price']);

        $arr[$row['goods_id']]['url']           = build_uri('goods', array('gid' => $row['goods_id']), $row['goods_name']);

        $arr[$row['goods_id']]['goods_brief']    = $row['goods_brief'];

 

 

        if ($row['promote_price'] > 0)

        {

            $arr[$row['goods_id']]['promote_price'] = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);

            $arr[$row['goods_id']]['formated_promote_price'] = price_format($arr[$row['goods_id']]['promote_price']);

        }

        else

        {

            $arr[$row['goods_id']]['promote_price'] = 0;

        }

    }

 

    return $arr;

}

 

红色为增加部分!

在模板库:goods_related.lbi 相应位置出入: {$releated_goods_data.goods_brief}。搞定!

chinab4c原创,转载请注明网址!

 

(责任编辑:chinab4c)