Select column from different model and show attributes in view

Question

I have a scaffolded 'Customer.rb' model and a 'Invoice.rb' model. I want people to select a existing Customer from the Customer model and put a few attributes of that selected option in the view of the invoice.

This is the code inside my Invoice#new (@customer = Customer.all in the Invoice_controller)

                <%= @customer.select(:company_name) do |f| %>
                    Customer:
                    
                      
                        <%= f.company_name %>

                        <%= f.first_name + f.last_name if f.first_name.present? && f.last_name.present?%>

                        <%= f.address_line_1 %>

                        <%= f.address_line_2 if present? %>
                      
                    
                <% end %>

Invoices Controller

class InvoicesController < ApplicationController
  before_action :set_invoice, only: [:show, :edit, :update, :destroy]

  # GET /invoices
  # GET /invoices.json
  def index
    @invoices = Invoice.all
  end

  # GET /invoices/1
  # GET /invoices/1.json
  def show
  end

  # GET /invoices/new
  def new
    @invoice = Invoice.new
    @customer = Customer.all
  end

  # GET /invoices/1/edit
  def edit
  end

  # POST /invoices
  # POST /invoices.json
  def create
    @invoice = Invoice.new(invoice_params)

    respond_to do |format|
      if @invoice.save
        format.html { redirect_to @invoice, notice: 'Invoice was successfully created.' }
        format.json { render :show, status: :created, location: @invoice }
      else
        format.html { render :new }
        format.json { render json: @invoice.errors, status: :unprocessable_entity }
      end
    end
  end

  # PATCH/PUT /invoices/1
  # PATCH/PUT /invoices/1.json
  def update
    respond_to do |format|
      if @invoice.update(invoice_params)
        format.html { redirect_to @invoice, notice: 'Invoice was successfully updated.' }
        format.json { render :show, status: :ok, location: @invoice }
      else
        format.html { render :edit }
        format.json { render json: @invoice.errors, status: :unprocessable_entity }
      end
    end
  end

  # DELETE /invoices/1
  # DELETE /invoices/1.json
  def destroy
    @invoice.destroy
    respond_to do |format|
      format.html { redirect_to invoices_url, notice: 'Invoice was successfully destroyed.' }
      format.json { head :no_content }
    end
  end

  private
    # Use callbacks to share common setup or constraints between actions.
    def set_invoice
      @invoice = Invoice.find(params[:id])
    end

    # Never trust parameters from the scary internet, only allow the white list through.
    def invoice_params
      params.require(:invoice).permit(:number, :currency, :date, :duedate, :btwtotal, :subtotal, :total, :footer)
    end
end

This shows the correct information but it shows it for ALL columns in the Customers table. I wan't people to pick a specific column only. Like lets say; someone selects 'Coca Cola Ltd.' from a dropdown and then sees only the information of Coca Cola Ltd. (f.company_name: Coca Cola Ltd. etcetera)

The Invoice.rb model contains 'has_one :customer'
The Customer.rb model contains 'belongs_to :invoice'

I tried everything from the ruby on rails guides but i don't seem to get it. Any help would be MUCH appreciated

UPDATE

Invoices#_form

<%= form_for(@invoice) do |f| %>
  <% if @invoice.errors.any? %>
    
      <%= pluralize(@invoice.errors.count, "error") %> prohibited this invoice from being saved:

      
      <% @invoice.errors.full_messages.each do |message| %>
        <%= message %>
      <% end %>
      
    
  <% end %>



  
    
      
        
          
            
              
                
              
              
                
                  <%= @invoice.number %>  23-07-2016 
                
              
            
            
            
              
                <%= f.select :customer, :customer_id, options_for_select(@customers.map{ |customer| [customer.company_name, customer.id, {"data-some-field" => customer.company_name}] },
                                                                         id: "my_select") %>
                    Klant:
                    
                      
                        

                        <%= f.text_field :company_name, id: "my_field" %>
                        

                        P: (123) 456-7890
                      
                      
                        E-mail:
                         info@customer.com 
                      
                    
              
              
                Gegevens:
                
                  
                    BTW #: 233243444
                  
                  
                    Bedrijfsnaam: Company B.V
                  
                  
                    IBAN: 1233F4343ABCDEW
                  
                  
                    Factuurdatum: 01/01/2016
                  
                  
                    Te betalen voor: 11/02/2016
                  
                
              
            
            
              
                
                  
                  
                     # 
                     Item 
                     Description 
                     Quantity 
                     Unit Cost 
                     Total 
                  
                  
                  
                  
                     1 
                     Lorem 
                     Drem psum dolor 
                     12 
                     $35 
                     $1152 
                  
                  
                     2 
                     Ipsum 
                     Consectetuer adipiscing elit 
                     21 
                     $469 
                     $6159 
                  
                  
                     3 
                     Dolor 
                     Olor sit amet adipiscing eli 
                     24 
                     $144 
                     $8270 
                  
                  
                     4 
                     Sit 
                     Laoreet dolore magna 
                     194 
                     $317 
                     $966 
                  
                  
                
              
            
            
              
                
                  
                    Subtotaal:
                    
                    <%= f.text_field :subtotal %>
                  
                  
                  
                  
                    BTW:
                    
                      <%= f.text_field :btwtotal %>
                    
                  
                  
                    Totaal:
                    
                      <%= f.text_field :total %>
                    
                  
                
                

              
            
          
          
            <%= @invoice.footer.present? ? @invoice.footer : "We verzoeken u vriendelijk het bovenstaande bedrag van
            € #{@invoice.total} voor #{@invoice.duedate} te voldoen op onze bankrekening onder vermelding van het
            factuurnummer #{@invoice.number}. Voor vragen kunt u contact opnemen per e-mail." %>
          
        
      
    
    
      
        
          
            
              <%= f.label :Factuurnummer %>

              <%= f.text_field :number, placeholder: '2016-0001' %>
            
            
              <%= f.label :Munteenheid %>

              <%= f.select(:currency, [[' €', 1, title: 'Euro', value: 'EURO'], [' $', 2, title: 'US Dollar', value: 'USD'],
                                       [' £', 3, title: 'GBP Pound', value: 'GBP']]) %>
            
            
              <%= f.label :factuurdatum %>

              <%= f.date_select :date %>
            
            
              <%= f.label 'te betalen voor' %>

              <%= f.date_select :duedate %>
            
            
              <%= f.label :footer %>

              <%= f.text_area :footer %>
            
            
              <%= f.submit 'opslaan', class: 'btn btn-primary btn-success' %>
              <%= link_to 'annuleren', invoices_path, class: 'btn btn-primary btn-info' %>
               print 
            
            <% end %>

MarsAtomic · Accepted Answer

What you want is more complicated than you might have imagined. Anytime you want dynamic stuff going on, you're going to have to rely on scripting. The view is largely inert -- it's only displaying information supplied to it by the controller, so you're going to need help from JavaScript and potentially AJAX.

Firstly, pluralize your field name in invoice#new to save potential confusion for people viewing your code.

@customer = Customer.all

should be:

@customers = Customer.all

This way, it's clear that you're referring to a collection and not a single record.

Then replace your select in the view with the following:

<%= f.select :customer, options_for_select(@customers.map { | cust | [cust.name, cust.id, 'data-some-field' => cust.some_field] }), { id: "my_select" } %>

What you're doing here is passing the select an options_for_select that uses an HTML data attribute to pass in additional information. You're going to have to modify invoice#new to build this information, an exercise I leave to you because I have no idea what you wish to display.

Add a textfield to your view to display the new information:

text_field_tag (:some_field, id: "my_field")

Then, you're going to have to modify your invoice.js asset with the following JavaScript:

$("#my_select").change(function()
{
    var selection = $(this).find(":selected");
    getElementById("my_field").value = selection.data("data-some-field");
});

Select column from different model and show attributes in view

Answers (2)

Related Questions