Sort list based on their i18n translation

Given i have a list of items in my DB and their respective translation in i18n file.

i18n file:

  basic_categories:  
    item_1: Z
    item_2: A
    item_3: F

on the view:

      &l开发者_开发知识库t;% @basic_categories.each do |category| %>
        <%= t("basic_categories.#{category.name}") %>
      <% end %>

How can i sort this list for each language?

You might want to have the translation in your database if your list is too long, for performance reason. MySQL sort faster than ruby.

Otherwise I think you could do something like this:

In your controller, use ruby to build an array of string or hash:

@basic_categories = categories.collect { |category|
  { :name => I18n.t("basic_categories.#{category.name}"), ... }
}.sort_by { |category| category[:name] }

And sort it with ruby, see http://ruby-doc.org/core/classes/Enumerable.html

In you view simply:

<% @basic_categories.each do |category| %>
  <%= category[:name] %>
  ...
<% end %>

Also you can pass json with translations to PG query and then order by translated value from json:

categories_i18n = I18n.backend.instance_variable_get(:@translations).dig(:en, :basic_categories).to_json
@basic_categories = categories.order("'#{categories_i18n}::json'->>name")