=" . $now_time; $fname = "/team/ajax_team_list_2"; } //秒杀商品 $id = getMobileStoId(); if (is_int($now_time / 7200)) { //双整点时间,如:10:00, 12:00 $start_time = $now_time; } else { $start_time = floor($now_time / 7200) * 7200; //取得前一个双整点时间 } $end_time = $start_time + 7200; //结束时间 $tt=time(); /*--and f.goods_num>f.buy_num--*/ $count = M('goods') ->alias('g') ->join('teamlist f', 'g.goods_id = f.goods_id', 'inner') ->where(" g.store_id=" . $id . " and g.is_on_sale=1 and f.show_time<" . $now_time . " and f.end_time>" . $now_time . $where) ->where("g.on_time<".$tt." and (g.down_time>".$tt." or g.down_time=0 ) and g.is_mainshow=1") ->where('f.is_show=1 and f.is_end=0') ->count(); //dump(" g.store_id=".$id." and g.is_on_sale=1 and f.goods_num>f.buy_num and f.show_time<".$now_time." and end_time>".$now_time);exit; $pagesize = 10;//C('PAGESIZE'); //每页显示数 $Page = new Page($count, $pagesize); // 实例化分页类 传入总记录数和每页显示的记录数 $show = $Page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 //mlog($Page->firstRow.','.$Page->listRows,"seckill"); /*and f.goods_num>f.buy_num*/ $list = M('goods') ->alias('g') ->join('teamlist f', 'g.goods_id = f.goods_id', 'inner') ->where(" g.store_id=" . $id . " and g.is_on_sale=1 and f.show_time<" . $now_time . " and f.end_time>" . $now_time . $where) ->where("g.on_time<".$tt." and (g.down_time>".$tt." or g.down_time=0 )") ->where('f.is_show=1 and f.is_end=0') ->order('f.ordid') ->limit($Page->firstRow . ',' . $Page->listRows) ->select(); foreach ($list as $item) { $item['cur_num'] = $item['goods_num'] - $item['buy_num']; $list1[] = $item; } $this->assign('list', $list1); $p = I("p/d", 1); if ($count <= $p * 10) { $this->assign('mshow', 0); } else { $this->assign('mshow', 1); } upload_ylp_log('秒杀活动列表'); return $this->fetch($fname, getMobileStoId()); } }