public function top() { $this->breadcrumb->add('Rating'); $this->header(); $filter = new CustomDataFilter($this->flightPage->getPosition()); $filter->fieldForeign('categories', 'name', 'airlineName'); $filter->fieldForeign('categories', 'id', 'airlineId'); $filter->fieldCalculation('rating', '(AVG(vdr_rating)+AVG(bord_rating)+AVG(service_rating))/3'); $filter->join('categories', 'id', 'airline'); $filter->condition('published', 1); $filter->orderBy('rating', false); $filter->groupBy('airline'); $this->flightPage->overview('/Airlines/top', 0, $filter); $this->footer(); }