function views_handler_sort_menu_hierarchy::query

Overrides views_handler_sort::query

File

handlers/views_handler_sort_menu_hierarchy.inc, line 46

Class

views_handler_sort_menu_hierarchy

Sort in menu hierarchy order.

Code

public function query() {
    $this->ensure_my_table();
    $max_depth = isset($this->definition['max depth']) ? $this->definition['max depth'] : MENU_MAX_DEPTH;
    for ($i = 1; $i <= $max_depth; ++$i) {
        if ($this->options['sort_within_level']) {
            $join = new views_join();
            $join->construct('menu_links', $this->table_alias, $this->field . $i, 'mlid');
            $menu_links = $this->query
                ->add_table('menu_links', NULL, $join);
            $this->query
                ->add_orderby($menu_links, 'weight', $this->options['order']);
            $this->query
                ->add_orderby($menu_links, 'link_title', $this->options['order']);
        }
        // We need this even when also sorting by weight and title, to make sure
        // that children of two parents with the same weight and title are
        // correctly separated.
        $this->query
            ->add_orderby($this->table_alias, $this->field . $i, $this->options['order']);
    }
}