ecshop首页调用团购信息产品购买人数

当我们在ecshop后台录入ecshop的团购信息之后,我们在ecshop的前台首页index.php里面,,可以看到他能调用ecshop的团购商品信息,其中就包括团购商品的一些价格信息。但是如何在ecshop首页调用团购产品的购买数量呢。我们将结合以下代码,来调用数据。

1:index.php

function index_get_group_buy(){$time = gmtime();$limit = get_library_number(‘group_buy’, ‘index’);

$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;}

在这个函数里面,我们调用了$stat = group_buy_stat($row[‘group_buy_id’], $ext_info[‘deposit’]);方法,这样一来我们就可以知道每个团购商品他的一些销售情况。

然后在模板里面。直接这样调用就可以<div class="index_group">售出 <strong>{$goods1.vn}</strong> 件</div>

什么天荒地老,什么至死不渝。都只是锦上添花的借口…

ecshop首页调用团购信息产品购买人数

相关文章:

你感兴趣的文章:

标签云: