/**
  * Get the query object to be processed by datatables.
  *
  * @return \Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder
  */
 public function query()
 {
     $fixtures = FootballMatches::select(['*']);
     $fixtures->orderBy('formatted_date', 'asc')->get();
     return $this->applyScopes($fixtures);
 }
 /**
  * Get game info from last match for display in first page
  * @return \Illuminate\Database\Eloquent\Model|null|static
  */
 public function LastMatch()
 {
     $match = FootballMatches::whereIn('status', ['FT', 'AET'])->whereDate('formatted_date', '<=', Date::today()->format('Y-m-d'))->orderBy('formatted_date', 'desc')->first();
     return $match;
 }
 /**
  * Get the query object to be processed by datatables.
  *
  * @return \Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder
  */
 public function query()
 {
     $fixtures = FootballMatches::select(['formatted_date', 'match_id', 'time', 'localteam_id', 'localteam_name', 'localteam_score', 'visitorteam_id', 'visitorteam_name', 'visitorteam_score', 'status']);
     $fixtures->orderBy('formatted_date', 'asc')->get();
     return $this->applyScopes($fixtures);
 }