X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/3426976606d30278fcf5ed279d3c95900785c4a5..16bdcac6d7a91250bd29b3fbbcc6f1d92531b2d0:/app/models/note.rb diff --git a/app/models/note.rb b/app/models/note.rb index ec57b770b..d3d4d5c73 100644 --- a/app/models/note.rb +++ b/app/models/note.rb @@ -2,14 +2,17 @@ # # 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 +# 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 +# description :text default(""), not null +# user_id :bigint(8) +# user_ip :inet # # Indexes # @@ -17,11 +20,18 @@ # notes_tile_status_idx (tile,status) # notes_updated_at_idx (updated_at) # +# Foreign Keys +# +# notes_user_id_fkey (user_id => users.id) +# class Note < ApplicationRecord include GeoRecord 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 } @@ -36,6 +46,8 @@ class Note < ApplicationRecord 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? @@ -44,7 +56,7 @@ class Note < ApplicationRecord # Close a note def close self.status = "closed" - self.closed_at = Time.now.getutc + self.closed_at = Time.now.utc save end @@ -65,6 +77,18 @@ class Note < ApplicationRecord !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