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