/** * 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); }