class Transaction < ActiveRecord::Base
  belongs_to :request

  validates :transaction_type, inclusion: { in: ['request', 'response', 'fulfillment'] }

  def self.sort_by_group(group)
    Transaction.joins(:request).where(requests: {group_id: group.id})
  end

  def self.sort_by_user(user)
    Transaction.joins(:request).where(requests: {requester_id: user.id})
  end

  def self.sort_by_active
    Transaction.joins(:request).where('transaction_type LIKE :type AND transactions.created_at BETWEEN :then AND :now', type: 'request', then: 1.hour.ago, now: Time.now).where(requests: {is_fulfilled: false})
  end
end
class Transaction < ActiveRecord::Base
  belongs_to :request

  validates :transaction_type, inclusion: { in: ['request', 'response', 'fulfillment'] }

  def self.sort_by_group(group)
    Transaction.joins(:request).where(requests: {group_id: group.id})
  end

  def self.sort_by_user(user)
    Transaction.joins(:request).where(requests: {requester_id: user.id})
  end

  def self.sort_by_active
    Transaction.joins(:request).where('transaction_type LIKE :type AND transactions.created_at BETWEEN :then AND :now', type: 'request', then: 1.hour.ago, now: Time.now).where(requests: {is_fulfilled: false})
  end

  def pretty_date
    time_ago_in_words(created_at)
  end
end
Add method for displaying date in words
Add method for displaying date in words
