Agfdhyk

I have a navigation structure stored in a database. There are two models Navigation and Navigation Items.

class Navigation < ApplicationRecord



  has_many :navigation_items



  scope :all_items, -> { 

    includes(navigation_items: [:translations, children: :translations])

      .order('navigation_items.position asc')

      .where(navigation_items: { parent_id: nil })

    }



end

class NavigationItem < ApplicationRecord



  has_many :children, class_name: "NavigationItem", foreign_key: "parent_id"

  belongs_to :parent, class_name: "NavigationItem", foreign_key: 'parent_id', optional: true

  belongs_to :navigation

end

I setup the navigations in the application controller like this

def set_navigation

  @navigations = Navigation.all_items

  @navigation = 

  @footer_navigation = 

  @header_navigation = 



  if (main = @navigations.detect { |n| n.handle == "main" })

    @navigation = main.navigation_items

  end

  if (footer = @navigations.detect { |n| n.handle == "footer" })

    @footer_navigation = footer.navigation_items

  end

  if (header = @navigations.detect { |n| n.handle == "header" })

    @header_navigation = header.navigation_items

  end

end

I then loop through each navigation_item in the layout with a nested loop for the children.

All is working well except one thing. The navigation items all have a position tied to them. The parent items display in the correct order however the children are not obeying the order. Is there a way to also scope the children navigation items to order by position?

try this

you can use default_scope or association condition

class Navigation < ApplicationRecord

  # has_many :navigation_items, -> { where(parent_id: nil).order(position: :asc) }

  has_many :navigation_items, -> { where(parent_id: nil) }



  scope :all_items, -> { includes(navigation_items: [children: :children]) }

end

class NavigationItem < ApplicationRecord



  # has_many :children, -> { order position: :asc }, class_name: "NavigationItem", foreign_key: "parent_id"

  has_many :children, class_name: "NavigationItem", foreign_key: "parent_id"

  belongs_to :parent, class_name: "NavigationItem", foreign_key: 'parent_id', optional: true

  belongs_to :navigation



  default_scope -> { order position: :asc }

end