示例#1
0
 public function index()
 {
     $boardgames = Boardgame::all();
     $mostPlayedGames = \DB::table('events')->join('boardgames', 'boardgames.id', '=', 'events.boardgame_id')->whereNotNull('events.boardgame_id')->groupBy('events.boardgame_id')->select(array('boardgames.*', \DB::raw('count(*) AS c')))->take(10)->orderBy('c', 'desc')->get();
     $nearEvents = \DB::table('events')->join('users', 'events.user_id', '=', 'users.id')->join('boardgames', 'boardgames.id', '=', 'events.boardgame_id')->where('event_date', '>', date('Y-m-d H:i'))->take(10)->orderBy('event_date', 'asc')->get(['users.name as host', 'users.avatar as host_avatar', 'events.name', 'boardgames.name as game_name', 'boardgames.image as game_image', 'boardgames.url as game_url']);
     $var = ["mostPlayedGames" => $mostPlayedGames, "boardgames" => $boardgames, "nearEvents" => $nearEvents];
     return view('home.index', $var);
 }
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     \DB::table('boardgames')->delete();
     $xml = file_get_contents("http://www.boardgamegeek.com/xmlapi/collection/Kondov");
     $xml = simplexml_load_string($xml);
     $json = json_encode($xml);
     $collection = json_decode($json, TRUE);
     $i = 1;
     foreach ($collection['item'] as $game) {
         $boardgame = new Boardgame();
         $boardgame->id = $i;
         $boardgame->name = $game['name'];
         $boardgame->description = 'description';
         $boardgame->url = "https://boardgamegeek.com/boardgame/" . $game['@attributes']['objectid'];
         $boardgame->image = $game['image'];
         $boardgame->save();
         $i++;
     }
 }
示例#3
0
 public function shortDetails($id)
 {
     $event = Event::find($id);
     $hostId = $event->user_id;
     $gameId = $event->boardgame_id;
     $boardGame = Boardgame::find($gameId);
     $user = User::find($hostId);
     $flagApproveEnable = \DB::table('event_user')->where('event_id', '=', $event->id)->where('user_id', '=', \Auth::id())->count() == 0;
     $event->event_date_formated = Date('g:ia \\o\\n jS F Y', strtotime($event->event_date));
     $peopleCount = \DB::table('event_user')->where('event_id', $id)->where('status', 'approved')->count();
     $event->people_count = $peopleCount;
     $flagApproveEnable = true;
     $var = ['event' => $event, 'user' => $user, 'boardGame' => $boardGame, 'flagApproveEnable' => $flagApproveEnable];
     return view('events.short-details', $var);
 }