您现在的位置是:首页 > cms教程 > ecshop商城教程ecshop商城教程
ecshop拍卖活动列表显示开发教程
冰萍2023-12-23 20:57:19ecshop商城教程已有人查阅
导读ecshop的拍卖功能是ecshop提倡一大促销的主打功能,这个要求必须非常高,本程序为了调整ecshop列表页面活动倒计时和ecshop参与人数显示功能,给ecshop增 不少.
ecshop的拍卖功能是ecshop提倡一大促销的主打功能,这个要求必须非常高,本程序为了调整ecshop列表页面活动倒计时和ecshop参与人数显示功能,给ecshop增 不少.
1:auction.php的auction_list函数
$sql = "SELECT a.*, IFNULL(g.goods_thumb, '') AS goods_thumb " .
"FROM " . $GLOBALS['ecs']->table('goods_activity') . " AS a " .
"LEFT JOIN " . $GLOBALS['ecs']->table('goods') . " AS g ON a.goods_id = g.goods_id " .
"WHERE a.act_type = '" . GAT_AUCTION . "' " .
"AND a.start_time <= '$now' AND a.end_time >= '$now' AND a.is_finished < 2 ORDER BY a.act_id DESC";
同时修改该函数
function auction_count()
{
$now = gmtime();
$sql = "SELECT COUNT(*) " .
"FROM " . $GLOBALS['ecs']->table('goods_activity') .
"WHERE act_type = '" . GAT_AUCTION . "' " .
"AND start_time <= '$now' AND end_time >= '$now' AND is_finished < 2";
return $GLOBALS['db']->getOne($sql);
}
2:admin\auction.php的function auction_list()
$info = auction_info($row[act_id]);
$arr['bid_user_count'] = $info['bid_user_count'];
3:admin\templates\auction_list.htm
<td align="right">{$auction.bid_user_count}</td>
4:includes/lib_goods.php
function get_top10($cats = '')去掉
if ($GLOBALS['_CFG']['use_storage'] == 1)
{
$sql .= " AND g.goods_number > 0 ";
}
5:auction_list.dwt
<select name="sort">
<option value="start_time">开始时间</option>
<option value="end_time">结束时间</option>
</select>
6:auction.php的list中增加以下
$sort = isset($_REQUEST['sort'])&&($_REQUEST['sort'])?$_REQUEST['sort']:'act_id';
6:auction.php
function auction_list($size, $page,$sort = '')
{
if($sort){
$sort_string = ' order by a.'.$sort." asc";
}
$auction_list = array();
$auction_list['finished'] = $auction_list['finished'] = array();
$now = gmtime();
$sql = "SELECT a.*, IFNULL(g.goods_thumb, '') AS goods_thumb " .
"FROM " . $GLOBALS['ecs']->table('goods_activity') . " AS a " .
"LEFT JOIN " . $GLOBALS['ecs']->table('goods') . " AS g ON a.goods_id = g.goods_id " .
"WHERE a.act_type = '" . GAT_AUCTION . "' " .
"AND a.start_time <= '$now' AND a.end_time >= '$now' AND a.is_finished < 2 $sort_string";
8:auction.php的list
$pager = get_pager('auction.php', array('act' => 'list','sort'=>$sort), $count, $page, $size);
9:调用参与拍卖数量
$info = auction_info($row[act_id]);
$auction['bid_user_count'] = $info['bid_user_count'];
10:auction_list.dwt参与人数:{$auction.bid_user_count}
11:auction.php的auction_list()中增加倒计时
$auction['auction_end_time'] =local_date('Y/m/d H:i', $auction['end_time']);
$auction['act_id'] = $auction['act_id'];
1:auction.php的auction_list函数
$sql = "SELECT a.*, IFNULL(g.goods_thumb, '') AS goods_thumb " .
"FROM " . $GLOBALS['ecs']->table('goods_activity') . " AS a " .
"LEFT JOIN " . $GLOBALS['ecs']->table('goods') . " AS g ON a.goods_id = g.goods_id " .
"WHERE a.act_type = '" . GAT_AUCTION . "' " .
"AND a.start_time <= '$now' AND a.end_time >= '$now' AND a.is_finished < 2 ORDER BY a.act_id DESC";
同时修改该函数
function auction_count()
{
$now = gmtime();
$sql = "SELECT COUNT(*) " .
"FROM " . $GLOBALS['ecs']->table('goods_activity') .
"WHERE act_type = '" . GAT_AUCTION . "' " .
"AND start_time <= '$now' AND end_time >= '$now' AND is_finished < 2";
return $GLOBALS['db']->getOne($sql);
}
2:admin\auction.php的function auction_list()
$info = auction_info($row[act_id]);
$arr['bid_user_count'] = $info['bid_user_count'];
3:admin\templates\auction_list.htm
<td align="right">{$auction.bid_user_count}</td>
4:includes/lib_goods.php
function get_top10($cats = '')去掉
if ($GLOBALS['_CFG']['use_storage'] == 1)
{
$sql .= " AND g.goods_number > 0 ";
}
5:auction_list.dwt
<select name="sort">
<option value="start_time">开始时间</option>
<option value="end_time">结束时间</option>
</select>
6:auction.php的list中增加以下
$sort = isset($_REQUEST['sort'])&&($_REQUEST['sort'])?$_REQUEST['sort']:'act_id';
6:auction.php
function auction_list($size, $page,$sort = '')
{
if($sort){
$sort_string = ' order by a.'.$sort." asc";
}
$auction_list = array();
$auction_list['finished'] = $auction_list['finished'] = array();
$now = gmtime();
$sql = "SELECT a.*, IFNULL(g.goods_thumb, '') AS goods_thumb " .
"FROM " . $GLOBALS['ecs']->table('goods_activity') . " AS a " .
"LEFT JOIN " . $GLOBALS['ecs']->table('goods') . " AS g ON a.goods_id = g.goods_id " .
"WHERE a.act_type = '" . GAT_AUCTION . "' " .
"AND a.start_time <= '$now' AND a.end_time >= '$now' AND a.is_finished < 2 $sort_string";
8:auction.php的list
$pager = get_pager('auction.php', array('act' => 'list','sort'=>$sort), $count, $page, $size);
9:调用参与拍卖数量
$info = auction_info($row[act_id]);
$auction['bid_user_count'] = $info['bid_user_count'];
10:auction_list.dwt参与人数:{$auction.bid_user_count}
11:auction.php的auction_list()中增加倒计时
$auction['auction_end_time'] =local_date('Y/m/d H:i', $auction['end_time']);
$auction['act_id'] = $auction['act_id'];
本文标签:
很赞哦! ()
相关文章
随机图文
ecshop模板安装方法教程
ECSHOP模板安装很简单,主要分两种网站模板安装方法:1、无ECSHOP二次开发过的(就是新网站没有修改过ECSHOP程序的,模板也是独立的);ecshop商城首页文字修改成网站名称方法有利于SEO优化
ECSHOP商城都会显示一个首页连接和文字那里为了SEO优化好处,我们将首页文字和连接改成当前域名, 例如:首页 文字改成:代码号链接改成www.ebingou.cn,ecshop模板的修改方法
ecshop模板如何修改?很多人在问这个问题,今天就以图解的方式给大家详细说下。相信学完之后,你会很清楚如何修改ecshop模板,不管你是初学者还是程序高手。ecshop首页商品显示销售数量 销售数量为0不显示
众所周知作为商城网站的首页,对于潜在客户来说是一个极其重要的窗口。除了要体现网站的专业度和信誉度外,首页还起了一个特别重要的作用,就是给用户推荐产品。
留言与评论 (共有 条评论) |