/**
* Get data from Standing for render short table in first page
* @return array|bool|\Illuminate\Database\Eloquent\Collection|static[]
*/
public function LeagueTable()
{
$liverpool = FootballStanding::whereTeamId('9249')->first();
$getRank = $liverpool->position - 3;
$rank = $getRank <= 1 ? $getRank === 1 : $getRank;
$standing = FootballStanding::where('position', '>=', $rank)->select('*')->orderBy('position', 'asc')->take(7)->get();
return $standing;
}
/**
* Get the query object to be processed by datatables.
*
* @return \Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder
*/
public function query()
{
$standing = FootballStanding::whereSeason('2015/2016')->select('position', 'team_name', 'overall_gp', 'overall_w', 'overall_d', 'overall_l', 'overall_gs', 'overall_ga', 'gd', 'points')->orderBy('position', 'asc');
return $this->applyScopes($standing);
}