Rails app w/ graph

Technologies explored

Ruby ('2.5.1')
Ruby on Rails ('~> 5.1.6.2') — disabled Turbolinks
Postgres ('~> 11.2')
ActiveRecord
Rails Action View Form Helpers -including form_for
HTML5 Form Validation
Slim Template
HighCharts JS
Gon
Faker
LoremFlickr
Materialize Sass
Material Icons

AND:

Engineering principles:
- MVC
- Fat Models, Skinny Controllers
- Rails Conventions:
  - Keep Accepted calculations in Concern methods
  - 7 types of Controller Actions:
    - Index: List all objects HTTP: GET
    - Show: Show one object HTTP: GET
    - Edit: Edit one object HTTP: GET
    - Update: Save changes to one object HTTP: PATCH/PUT
    - New: Enter info for a new object HTTP: GET
    - Create: Save new object HTTP: POST
    - Delete: Delete one object HTTP: DELETE

Models

Schema Specifics

Queries for Table and Graph Data Kept in mind the MVC principle of fat models and skinny controllers.

Two main instance methods on the Membership model get my table and graph data. For Table: table For Graph: sorted_hts_pts

Membership Model /app/models/membership.rb

class Membership < ApplicationRecord

  belongs_to :house
  belongs_to :banner_person
  has_many :loyalty_points
  has_many :advisements
  has_many :handouts

  def table
    ActiveRecord::Base.connection.execute("
      SELECT COALESCE(l.date, h.date, a.date) AS cdate,
      l.pts AS lpts, h.units AS hunits, a.units AS aunits, a.id AS aid,
      l.date AS ldate, h.date AS hdate, a.date AS adate
      FROM (SELECT * FROM loyalty_points WHERE membership_id = #{self.id}) l
      FULL OUTER JOIN (SELECT * FROM handouts WHERE membership_id = #{self.id}) h
        ON l.date = h.date
      FULL OUTER JOIN (SELECT * FROM advisements WHERE membership_id = #{self.id}) a
        ON COALESCE(l.date, h.date) = a.date
      ORDER BY cdate ASC;
      ")
  end

  def sorted_hts_pts
    handouts = []
    pts = []
    adv = []
    self.table.each{|r|
      if r["hdate"]
        handouts.push( [ r["hdate"], r["hunits"] ] )
      end
      if r["ldate"]
        pts.push( [ r["ldate"], r["lpts"] ] )
      end
    }
    return { 'hts' => handouts, 'pts' => pts }
  end

end

% Accepted Accepted is calculated in a Concern /app/models/concerns/accepted.rb

module Accepted
  extend ActiveSupport::Concern

  def self.rates(membership:)
    uniqs = {}
    num = 0.0
    denom = 0.0
    last_a = nil

    membership.table.each do |r, i|
      a = r["aunits"]
      h = r["hunits"]

      unless a == nil
        unless last_a == nil
          uniqs[ last_a[0] ] = num.to_f / denom
          num = 0.0
          denom = 0.0
        end

        last_a = [ r["cdate"], a ]
      end

      unless h == nil or last_a == nil

        if h == last_a[1]
          num += 1
        end

        denom += 1
      end
    end

    unless last_a == nil
      if uniqs[ last_a[0] ] == nil
        uniqs[ last_a[0] ] = num.to_f / denom
      end
    end

    return uniqs
  end

  def self.rate(advisement:)
    all = Accepted.rates(membership: advisement.membership)
    accepted = all[advisement.date.strftime("%F")]
    advisement.accepted = accepted
    return accepted
  end

  def self.col(membership:)
    col = []
    uniqs = Accepted.rates(membership: membership)
    cur_rate = 0.0
    membership.table.each_with_index do |r, i|
      p "rcdate"
      p r["cdate"]
      if uniqs[r["cdate"]]
        cur_rate = uniqs[r["cdate"]]
      end
      col.push( '%.2f' % (100 * cur_rate) )
    end
    return col
  end

end