麻豆小视频在线观看_中文黄色一级片_久久久成人精品_成片免费观看视频大全_午夜精品久久久久久久99热浪潮_成人一区二区三区四区

首頁 > CMS > Ecshop > 正文

ECSHOP開發(fā)拍賣活動(dòng)列表顯示

2024-07-09 22:56:29
字體:
供稿:網(wǎng)友

ecshop的拍賣功能是ecshop提倡一大促銷的主打功能,這個(gè)要求必須非常高,本程序?yàn)榱苏{(diào)整ecshop列表頁面活動(dòng)倒計(jì)時(shí)和ecshop參與人數(shù)顯示功能,給ecshop增色不少.
1:auction.php的auction_list函數(shù)
$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";

同時(shí)修改該函數(shù)
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">開始時(shí)間</option>
    <option value="end_time">結(jié)束時(shí)間</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:調(diào)用參與拍賣數(shù)量
$info = auction_info($row[act_id]);
 
   $auction['bid_user_count']   = $info['bid_user_count'];

10:auction_list.dwt參與人數(shù):{$auction.bid_user_count}

11:auction.php的auction_list()中增加倒計(jì)時(shí)
$auction['auction_end_time']   =local_date('Y/m/d H:i', $auction['end_time']);
$auction['act_id']   = $auction['act_id'];

發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 欧美激情性色生活片在线观看 | 精品国产91一区二区三区 | 911网站大全在线观看 | 国产精品一区在线观看 | 精品国产一区二区三区四区在线 | 91成人免费看片 | 欧美999| 中文字幕亚洲欧美 | h视频在线播放 | 看毛片电影| 99精品视频在线观看免费播放 | 成人精品久久 | 99精品视频99 | 在线观看免费污视频 | 未成年人在线观看 | 久久久噜噜噜久久熟有声小说 | 久久久久久91 | 精品久久久久99 | 麻豆小视频在线观看 | 午夜天堂在线视频 | 电影av在线| 87成人免费看片 | 精精国产xxxx视频在线播放7 | 国产男女 爽爽爽爽视频 | 成年人免费视频播放 | 黄色免费播放网站 | 69性欧美高清影院 | 国产成人精品二区 | 超碰97人 | 精品一二三区视频 | 羞羞色网站 | 久章草影院 | av在线免费电影 | 久草在线免费看 | 免看黄大片aa | 91在线色视频 | 国产午夜亚洲精品理论片大丰影院 | 欧美乱码精品一区 | 一区二区美女视频 | 黄色一级片毛片 | 久久亚洲视频网 |