Exemplo n.º 1
0
 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);
 }
Exemplo n.º 2
0
 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);
 }