I have a user that has many accounts. I want to use a collection_select to have the user select which account they want to use. The select need to select among all the accounts assigned to the user in the user_accounts table, but the select needs to check the accounts table to get the name of the account that the drop down menu needs to display.
#user.rb
class Account < ActiveRecord::Base
cattr_accessor :current_id
belongs_to :owner, class_name: 'User'
has_many :user_accounts
has_many :users, through: :user_accounts
accepts_nested_attributes_for :owner
end
#user.rb
class User < ActiveRecord::Base
has_one :owned_account, class_name: 'Account', foreign_key: 'owner_id'
has_many :user_accounts
has_many :accounts, through: :user_accounts
end
#user_account.rb
class UserAccount < ActiveRecord::Base
belongs_to :account
belongs_to :user
end
If I use the following, the select works, but only displays the account_id:
#settings.html.erb
<%= form_tag change_account_path do %>
<%= collection_select :user_account, :id, current_user.user_accounts, :id, :id %>
<%= submit_tag "Sign in", class: "btn btn-large btn-primary" %>
<% end %>
I tried replacing the collection_select with:
<%= collection_select :user_account, :id, current_user.user_accounts, :id, :name %>
which returns the following error:
undefined method `name' for #<UserAccount id: 1, account_id: 27, user_id: 55>
I tried combining the 2 tables via a map function but also was unsuccessful:
#settings.html.erb
<%= form_tag change_account_path do %>
<%= collection_select :user_account, :id, current_user.user_accounts.map{|x| {:id => x.account_id, :name => x.account.name} }, :id, :name %>
<%= submit_tag "Sign in", class: "btn btn-large btn-primary" %>
<% end %>
This option gives me the following error:
undefined method `name' for {:id=>27, :name=>"S1"}:Hash
