How can I sum values from array?

Question

I did an application using rails and I'm having problems doing a total sum on each row but i'm getting errors.

Here my tables:

|policies|
   |id|  |num_policy|
    1       1000
    2       1001
    3       1002
    4       1003

|policy_vehicles|    
   |id|  |policy_id|  |vehicle_id|
    1         1            1
    2         1            2
    3         2            1
    4         2            3
    5         3            1
    6         4            4
    7         4            2

|vehicles|
   |id|  |name|     |amount|
    1    VEHICLE1     8000
    2    VEHICLE2     8001
    3    VEHICLE3     8002
    4    VEHICLE4     8003

Here is my controller: "app/controllers/policy_controller.rb"

Models:

class PolicyVehicle < ActiveRecord::Base
   belongs_to :vehicle
   belongs_to :policy
end

class Vehicle < ActiveRecord::Base
   belongs_to :policy
   has_many :policy_vehicles
end

class Vehicle < ActiveRecord::Base
   has_many :policy_vehicles
end

Here is my index view: "app/views/policy/index.html.erb"

<table border="1">
  <tr>
    <td>POLICY ID</td>
    <td>NUM POLICY</td>
  </tr>

<% @policies.each do |policy| %>
  <tr>
    <td><%= policy.id %></td>
    <td><%= policy.num_policy %></td>
  </tr>

  <% policy.policy_vehicles.each do |policy_vehicle| %>
  <tr>
    <td></td>
    <td><%= policy_vehicle.vehicle.name %></td>
    <td><%= policy_vehicle.vehicle.amount %></td>
  </tr>
  <% end %>

  <tr>
    <td></td> 
    <td>TOTAL</td>
    <td><%= policy.policy_vehicles.vehicles.sum(:amount) %></td>
  </tr>

<% end %> 
</table>

If I try:

<%= policy.policy_vehicles.vehicles.sum(:amount) %>
##### GET THIS ERROR  #####
undefined method `vehicles' for #<Class:0x7ff4293ac3f0>

If I try:

<%= policy.policy_vehicles.vehicle.sum(:amount) %>
##### GET THIS ERROR  #####
undefined method `vehicle' for #<Class:0x7ff42ae95a90>

If I try:

<%= policy.policy_vehicles.vehicles.collect(&:amount).sum %>
##### GET THIS ERROR  #####
undefined method `vehicles' for #<Class:0x7ff429337410>

If I try:

<% policy.policy_vehicles.each do |policy_vehicle|%> 
  <%= policy_vehicle.vehicle.sum(:amount)
<% end %>
##### GET THIS ERROR  #####
undefined method `sum' for #<ActiveRecord::Associations::BelongsToAssociation:0x7ff4295dbd60>

Finally I tried:

<% policy.policy_vehicles.each do |policy_vehicle|%> 
  <%= policy_vehicle.vehicle.amount.sum
<% end %>
##### GET THIS ERROR  #####
undefined method `sum' for 8000:Fixnum

I'm trying to do this example:

enter image description here

Please somebody can help me?

What is wrong?

All kind of help will be accepted.

BroiSatse · Accepted Answer · 2014-09-23 15:56:43Z

5

You could do:

class Policy < ActiveRecord::Base
   has_many :policy_vehicles
   has_many :vehicles, through: policy_vehicles
end

and then:

<tr>
  <td></td> 
  <td>TOTAL</td>
  <td><%= policy.vehicles.sum(:amount) %></td>
</tr>

answered Sep 23, 2014 at 15:56

BroiSatse

44.8k8 gold badges63 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Carlos Morales Over a year ago

Fantastic +1 for excellent answer, notice that also I wrote good details and explained as good question :D

Collectives™ on Stack Overflow

How can I sum values from array?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related