定型管 電子鈑金
返回列表 回復 發帖

帖子標題:[分享] 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 交流討論區"交流請遵守台灣法律規範,"最模板" 發表的文章《ecshop首頁調用團購信息產品購買人數》版權歸屬作者所有,如是轉貼版權歸屬原作者所有.本論壇不對其真實性做任何考證.
返回列表