Generating column-based table in ruby on rails view

Question

I need a bit help with dynamically generating column-based table instead of row-based table.

Let's say that I have a hospital and hospital has many patients.

Hospital no 1

          | Day 1 | Day 2 | Day 3     
Patient 1 | 36.6  | 36.4  | 36.5      
Patient 2 | 37.0  | 37.1  | 36.6      
Patient 3 | 37.1  | 36.4  | 36.7      
Patient 4 | 36.6  | 36.6  | 36.6      
Patient 5 | 36.7  | 37.1  | 36.4

Each day, each patient has his body temperature checked. I would like to get a tip/hint or example of help dynamically drawing such table - adding new data vertically, not horizontally. Hopefully you get what i mean.

Thank you, in advance :)

what do you mean by dynamically drawing such table. Do want to make something with ajax? Right now your question has nothing to do with RoR — jigfox
– jigfox, Commented Jun 30, 2010 at 13:13
First, thanks for editing my post, that table is looking like a table now. "Dynamically drawing such table" may be indeed unfortunate wording. I just want to iterate through a collection. I need a suggestion how to prepare such collection to iterate through it in a view, in a column-based style. — socjopata
– socjopata, Commented Jun 30, 2010 at 13:21

jigfox · Accepted Answer · 2010-06-30 13:32:47Z

5

I'm assuming you meant something like this:

you have three models:

class Hostpital < ActiveRecord::Base
  has_many :patients
  has_many :temp_readings, :through => :patients
end

class Patient < ActiveRecord::Base
  belongs_to :hospital
  has_many :temp_readings
end

class TempReading < ActiveRecord::Base
  belongs_to :patient
end

Than you can build a table in an erb view like this:

<table>
  <thead>
    <tr>
      <th>&nbsp;</th>
      <%- some_hospital.temp_readings.map(&:date_of_reading).sort do |date_of_reading| -%>
        <th><%= date_of_reading %></th>
      <%- end -%>
    </tr>
  </thead>
  <tbody>
    <%- some_hospital.patients.each do |patient| -%>
      <tr>
        <th><%= patient.name %></th>
        <%- patient.hospital.temp_readings.map(&:date_of_reading).sort do |date_of_reading| -%>
          <td><%= patient.temp_reading.find_by_date_of_reading(date_of_reading) %></td>
        <%- end -%>
      </tr>
    <%- end -%>
  </tbody>
</table>

I'm assuming you have some column with a date in your Reading Model, I just called it date_of_reading

answered Jun 30, 2010 at 13:32

jigfox

18.2k3 gold badges62 silver badges74 bronze badges

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

1 Comment

socjopata Over a year ago

You sir, are brilliant! The view is what have been problematic to me. It needed a few corrections, but anyone who will find this topic will know how to help himself. Many, many thanks.

bjg · Accepted Answer · 2010-06-30 13:26:49Z

0

If your question relates to the storage and representation of the data within your application then you can do this with 2 models as follows:

class Patient < ActiveRecord::Base
  has_many :temp_readings
end

class TempReading < ActiveRecord::Base
  belongs_to :patient
end

When creating a new reading for each patient you add a row to the temp_readings table. When displaying these readings (say for the last 7 days) you print the last 7 row values of temp_readings for each patient across a single line giving you the columnar output.

answered Jun 30, 2010 at 13:26

bjg

7,4771 gold badge27 silver badges21 bronze badges

Collectives™ on Stack Overflow

Generating column-based table in ruby on rails view

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related