public function listAuctions() { $per_page = Input::get('per_page', 30); try { $now = Tools::getNow(); $list = Auction::with('eventItem')->join('event_items', function ($q) { $q->on('event_items.e_id', '=', 'auctions.e_id'); })->where('event_items.e_end_at', '<', $now)->orderBy('event_items.e_end_at', 'DESC')->paginate($per_page); $data = []; foreach ($list as $key => $auction) { $data[] = $auction->showDetail(); } $re = Tools::reTrue('获取往届竞拍成功', $data); } catch (Exception $e) { $re = Tools::reFalse($e->getCode(), '获取往届竞拍失败:' . $e->getMessage()); } return Response::json($re); }
public function listAuctions() { $token = Input::get('token', ''); $u_id = Input::get('u_id', ''); $won = Input::get('won'); $per_page = Input::get('per_page', 30); try { $user = User::chkUserByToken($token, $u_id); $query = Auction::with('eventItem')->join('event_items', function ($q) { $q->on('event_items.e_id', '=', 'auctions.e_id'); })->join('auction_bids', function ($q) { $q->on('auction_bids.a_id', '=', 'auctions.a_id'); })->where('auction_bids.u_id', '=', $u_id); if ($won) { $query = $query->where('auction_bids.is_win', '=', 1); } $query = $query->groupBy('auctions.a_id')->orderBy('auctions.created_at', 'DESC'); $list = $query->paginate($per_page); $data = []; foreach ($list as $key => $auction) { $data[] = $auction->showDetail(); } $re = Tools::reTrue('获取竞拍成功', $data, $list); } catch (Exception $e) { $re = Tools::reFalse($e->getCode(), '获取竞拍失败:' . $e->getMessage()); } return Response::json($re); }