ecshop会员中心我的收藏显示收藏的商品图片和时间的方法

ECSHOP首页商品增加购买按钮和收藏按钮支持属性选择

ECSHOP插件网开发的这款正版ECSHOP首页商品增加购买按钮和收藏按钮支持属性选择是ECSHOP插件上比较实用的版本以及下载图文介绍,效果截图,用户使用后的评论。

^¥150^¥200立即下载

function get_collection_goods($user_id, $num = 10, $start = 0)
{
    $sql = 'SELECT g.goods_id, g.goods_name, g.goods_thumb, g.market_price, g.shop_price AS org_price, '.
                "INULLmp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, ".
                'g.promote_price, g.promote_start_date,g.promote_end_date, c.rec_id, c.is_attention' .
            ' FROM ' . $GLOBALS['ecs']->table('collect_goods') . ' AS c' .
            " LEFT JOIN " . $GLOBALS['ecs']->table('goods') . " AS g ".
                "ON g.goods_id = c.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 c.user_id = '$user_id' ORDER BY c.rec_id DESC";
    $res = $GLOBALS['db'] -> selectLimit($sql, $num, $start);
    $goods_list = array();
    while ($row = $GLOBALS['db']->fetchRow($res))
    {
        if ($row['promote_price'] > 0)
        {
            $promote_price = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
        }
        else
        {
            $promote_price = 0;
        }
        $goods_list[$row['goods_id']]['rec_id']        = $row['rec_id']; 
$goods_list[$row['goods_id']]['formated_add_time'] = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']); 
$goods_list[$row['goods_id']]['is_attention']  = $row['is_attention'];
        $goods_list[$row['goods_id']]['goods_id']      = $row['goods_id'];
        $goods_list[$row['goods_id']]['goods_name']    = $row['goods_name']; 
$goods_list[$row['goods_id']]['goods_thumb']   = $row['goods_thumb']; 
$goods_list[$row['goods_id']]['market_price']  = price_format($row['market_price']);
        $goods_list[$row['goods_id']]['shop_price']    = price_format($row['shop_price']);
        $goods_list[$row['goods_id']]['promote_price'] = ($promote_price > 0) ? price_format($promote_price) : '';
        $goods_list[$row['goods_id']]['url']           = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);
    }
    return $goods_list;
}

商品图片：<img src="{$goods.goods_thumb}" />
收藏时间：{$goods.formated_add_time}