广州传奇网络
地址:广州市天河区东圃大马路富华楼C座
电话:13808825895
QQ:1564443073
团购商品的功能调用ecshop已经写好了
$smarty->assign('group_buy_goods', index_get_group_buy()); // 团购商品
group_buy_goods函数。
我们需要调用的是它的销售数量,下面是函数声明
function index_get_group_buy()
{
$time = gmtime();
$limit =6;//直接指定需要调用几个团购商品
$group_buy_list = array();
if ($limit > 0)
{
$sql = 'SELECT gb.act_id AS group_buy_id, gb.goods_id, gb.ext_info, gb.goods_name, g.goods_thumb, g.goods_img ' .
'FROM ' . $GLOBALS['ecs']->table('goods_activity') . ' AS gb, ' .
$GLOBALS['ecs']->table('goods') . ' AS g ' .
"WHERE gb.act_type = '" . GAT_GROUP_BUY . "' " .
"AND g.goods_id = gb.goods_id " .
"AND gb.start_time <= '" . $time . "' " .
"AND gb.end_time >= '" . $time . "' " .
"AND g.is_delete = 0 " .
"ORDER BY gb.act_id DESC " .
"LIMIT $limit" ;
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res))
{
/* 如果缩略图为空,使用默认图片 */
$row['goods_img'] = get_image_path($row['goods_id'], $row['goods_img']);
$row['thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
/* 根据价格阶梯,计算最低价 */
$ext_info = unserialize($row['ext_info']);
$stat = group_buy_stat($row['group_buy_id'], $ext_info['deposit']);
$price_ladder = $ext_info['price_ladder'];
if (!is_array($price_ladder) || empty($price_ladder))
{
$row['last_price'] = price_format(0);
}
else
{
foreach ($price_ladder AS $amount_price)
{
$price_ladder[$amount_price['amount']] = $amount_price['price'];
}
}
ksort($price_ladder);
$row['vn'] = $stat['valid_goods'];
$row['last_price'] = price_format(end($price_ladder));
$row['url'] = build_uri('group_buy', array('gbid' => $row['group_buy_id']));
$row['short_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ?
sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
$row['short_style_name'] = add_style($row['short_name'],'');
$group_buy_list[] = $row;
}
}
return $group_buy_list;
}
将这个替换原来的函数,然后在首页模版上,修改
<!--{foreach from=$group_buy_goods item=goods}-->
<div class="c4ysx1 mg">
<div class="c4ysx1z fl"><img src="images/index_30.jpg" /></div>
<div class="c4ysx1m fl"><A href="{$goods.url}"><img src="{$goods.thumb}" border="0" alt="{$goods.goods_name|escape:html}" class="thumb" /></A></div>
<div class="c4ysx1y fl ta"><a href="{$goods.url}" title="{$goods.goods_name|escape:html}">{$goods.short_style_name|escape:html}</A><br />
团购:{$goods.vn} 件</div>
</div>
<!--{/foreach}-->
这个div在ecshop中不存在,可以只把{$*}符号的变量拷贝过去。
{$goods.thumb}为产品缩略图
{$goods.goods_name|escape:html}为团购商品的名称
{$goods.url}为团购商品的链接地址
{$goods.vn} 团购开始后已经销售的数量