StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Solution below is assuming that status can be represented as a string.</p> <pre><code>class Campaign < ActiveRecord::Base has_many :contacts end class Contact < ActiveRecord::Base belongs_to :campaign has_many :contact_emails has_many :emails, :through => :contact_emails end class ContactEmail < ActiveRecord::Base belongs_to :contact belongs_to :email belongs_to :user # add a column called status end class Email < ActiveRecord::Base has_many :contact_emails belongs_to :contacts, :through => :contact_emails end </code></pre> <p>Adding emails to contact:</p> <pre><code>contact_email = @contact.contact_emails.build(:user => current_user, :email => @email, :status => "status1") contact_email.save </code></pre> <p>OR</p> <pre><code>@contact.contact_emails.create(:user => current_user, :email => @email, :status => "status1") </code></pre> <p>OR create multiple:</p> <pre><code>@contact.contact_emails.create( [ { :user => current_user, :email => @email, :status => "status1" }, { :user => current_user, :email => @email2, :status => "status2" } ] ) </code></pre> <p><strong>Edit 2</strong> Nested resources for ContactEmail.</p> <pre><code>map.resources :contacts, has_many :contact_emails </code></pre> <p>URL for ContactEmail</p> <pre><code>/contacts/1/contact_emails/new #new /contacts/1/contact_emails/2/edit #edit </code></pre> <p>The URL does not have the email id. You can pass the email_id as a query parameter, i.e.</p> <pre><code>new_contact_contact_email_path(@contact, :email_id => @email) </code></pre> <p>In your ContactEmailsController:</p> <pre><code>def new @contact = Contact.find(params[:contact_id]) @email = Email.find(params[:email_id]) @contact_email = @contact.contact_emails.build(:email => @email) end </code></pre> <p>In your view set <code>email_id</code> as hidden field. </p> <p>In the <code>create</code> method perform the save. </p> <pre><code>def create @contact = Contact.find(params[:contact_id]) @contact_email = @contact.contact_emails.build(params[:contact_email]) if @contact_email.save # success else # error end end </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload