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 b7f6928b869a75c626422b46438b81a4f7d38262..6d8ca078fa42e1d12e1652e3795a1e32caf02c26 100644 (file)
--- a/app/models/note.rb
+++ b/app/models/note.rb
@@ -2,10 +2,10 @@
 #
 # Table name: notes
 #
 #
 # Table name: notes
 #

-#  id         :integer          not null, primary key
+#  id         :bigint(8)        not null, primary key

 #  latitude   :integer          not null
 #  longitude  :integer          not null
 #  latitude   :integer          not null
 #  longitude  :integer          not null

-#  tile       :integer          not null
+#  tile       :bigint(8)        not null

 #  updated_at :datetime         not null
 #  created_at :datetime         not null
 #  status     :enum             not null
 #  updated_at :datetime         not null
 #  created_at :datetime         not null
 #  status     :enum             not null


@@ -18,24 +18,29 @@
 #  notes_updated_at_idx   (updated_at)
 #
 
 #  notes_updated_at_idx   (updated_at)
 #
 

-class Note < ActiveRecord::Base
+class Note < ApplicationRecord

   include GeoRecord
 
   include GeoRecord
 

-  has_many :comments, -> { where(:visible => true).order(:created_at) }, :class_name => "NoteComment", :foreign_key => :note_id
+  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 },
 
   validates :id, :uniqueness => true, :presence => { :on => :update },

-                 :numericality => { :on => :update, :integer_only => true }
+                 :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
 
   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
 

-  scope :visible, -> { where("status != 'hidden'") }
-  scope :invisible, -> { where("status = 'hidden'") }
+  scope :visible, -> { where.not(:status => "hidden") }
+  scope :invisible, -> { where(:status => "hidden") }

 
   after_initialize :set_defaults
 
 
   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
     errors.add(:base, "Note is not in the world") unless in_world?
   # Sanity check the latitude and longitude and add an error if it's broken
   def validate_position
     errors.add(:base, "Note is not in the world") unless in_world?


@@ -44,7 +49,7 @@ class Note < ActiveRecord::Base
   # Close a note
   def close
     self.status = "closed"
   # Close a note
   def close
     self.status = "closed"

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

     save
   end
 
     save
   end
 


@@ -65,6 +70,18 @@ class Note < ActiveRecord::Base
     !closed_at.nil?
   end
 
     !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
     comments.first.author
   # Return the author object, derived from the first comment
   def author
     comments.first.author