Create note subscription table and model

[rails.git] / app / models / note.rb

diff --git a/app/models/note.rb b/app/models/note.rb
index 892ada1aa8a5163d474bbde166ca4b9251f4d1fa..6d8ca078fa42e1d12e1652e3795a1e32caf02c26 100644 (file)
--- a/app/models/note.rb
+++ b/app/models/note.rb
@@ -1,88 +1,101 @@
-class Note < ActiveRecord::Base
+# == Schema Information
+#
+# Table name: notes
+#
+#  id         :bigint(8)        not null, primary key
+#  latitude   :integer          not null
+#  longitude  :integer          not null
+#  tile       :bigint(8)        not null
+#  updated_at :datetime         not null
+#  created_at :datetime         not null
+#  status     :enum             not null
+#  closed_at  :datetime
+#
+# Indexes
+#
+#  notes_created_at_idx   (created_at)
+#  notes_tile_status_idx  (tile,status)
+#  notes_updated_at_idx   (updated_at)
+#
+
+class Note < ApplicationRecord

   include GeoRecord
 
   include GeoRecord
 

-  has_many :comments, :class_name => "NoteComment",
-                      :foreign_key => :note_id,
-                      :order => :created_at,
-                      :conditions => { :visible => true }
-
-  validates_presence_of :id, :on => :update
-  validates_uniqueness_of :id
-  validates_numericality_of :latitude, :only_integer => true
-  validates_numericality_of :longitude, :only_integer => true
-  validates_presence_of :closed_at if :status == "closed"
-  validates_inclusion_of :status, :in => ["open", "closed", "hidden"]
+  has_many :comments, -> { left_joins(:author).where(:visible => true, :users => { :status => [nil, "active", "confirmed"] }).order(:created_at) }, :class_name => "NoteComment", :foreign_key => :note_id
+  has_many :all_comments, -> { left_joins(:author).order(:created_at) }, :class_name => "NoteComment", :foreign_key => :note_id, :inverse_of => :note
+  has_many :subscriptions, :class_name => "NoteSubscription"
+  has_many :subscribers, :through => :subscriptions, :source => :user
+
+  validates :id, :uniqueness => true, :presence => { :on => :update },
+                 :numericality => { :on => :update, :only_integer => true }
+  validates :latitude, :longitude, :numericality => { :only_integer => true }
+  validates :closed_at, :presence => true, :if => proc { :status == "closed" }
+  validates :status, :inclusion => %w[open closed hidden]
+

   validate :validate_position
 
   validate :validate_position
 

+  scope :visible, -> { where.not(:status => "hidden") }
+  scope :invisible, -> { where(:status => "hidden") }
+
+  after_initialize :set_defaults
+
+  DEFAULT_FRESHLY_CLOSED_LIMIT = 7.days
+

   # Sanity check the latitude and longitude and add an error if it's broken
   def validate_position
   # Sanity check the latitude and longitude and add an error if it's broken
   def validate_position

-    errors.add_to_base("Note is not in the world") unless in_world?
-  end
-
-  # Fill in default values for new notes
-  def after_initialize
-    self.status = "open" unless self.attribute_present?(:status)
+    errors.add(:base, "Note is not in the world") unless in_world?

   end
 
   # Close a note
   def close
     self.status = "closed"
   end
 
   # Close a note
   def close
     self.status = "closed"

-    self.closed_at = Time.now.getutc
-    self.save
+    self.closed_at = Time.now.utc
+    save

   end
 
   end
 

-  # Return a flattened version of the comments for a note
-  def flatten_comment(separator_char, upto_timestamp = :nil)
-    resp = ""
-    comment_no = 1
-    self.comments.each do |comment|
-      next if upto_timestamp != :nil and comment.created_at > upto_timestamp
-      resp += (comment_no == 1 ? "" : separator_char)
-      resp += comment.body if comment.body
-      resp += " [ " 
-      resp += comment.author_name if comment.author_name
-      resp += " " + comment.created_at.to_s + " ]"
-      comment_no += 1
-    end
-
-    return resp
+  # Reopen a note
+  def reopen
+    self.status = "open"
+    self.closed_at = nil
+    save

   end
 
   # Check if a note is visible
   def visible?
   end
 
   # Check if a note is visible
   def visible?

-    return status != "hidden"
+    status != "hidden"
+  end
+
+  # Check if a note is closed
+  def closed?
+    !closed_at.nil?
+  end
+
+  def freshly_closed?
+    return false unless closed?
+
+    Time.now.utc < freshly_closed_until
+  end
+
+  def freshly_closed_until
+    return nil unless closed?
+
+    closed_at + DEFAULT_FRESHLY_CLOSED_LIMIT

   end
 
   # Return the author object, derived from the first comment
   def author
   end
 
   # Return the author object, derived from the first comment
   def author

-    self.comments.first.author
+    comments.first.author

   end
 
   # Return the author IP address, derived from the first comment
   def author_ip
   end
 
   # Return the author IP address, derived from the first comment
   def author_ip

-    self.comments.first.author_ip
+    comments.first.author_ip

   end
 
   end
 

-  # Return the author id, derived from the first comment
-  def author_id
-    self.comments.first.author_id
-  end
+  private

 
 

-  # Return the author name, derived from the first comment
-  def author_name
-    self.comments.first.author_name
-  end
-
-  # Custom JSON output routine for notes
-  def to_json(options = {})
-    super options.reverse_merge(
-      :methods => [ :lat, :lon ], 
-      :only => [ :id, :status, :created_at ],
-      :include => {
-         :comments => {
-           :only => [ :event, :author_name, :created_at, :body ]
-         }
-      }
-    )
+  # Fill in default values for new notes
+  def set_defaults
+    self.status = "open" unless attribute_present?(:status)

   end
 end
   end
 end