X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/283e7b975b5a80d3f3e8091ce83e8f89b33bb06c..0488e66d4c10100ff62d816beb84fe83da50674c:/app/models/note.rb diff --git a/app/models/note.rb b/app/models/note.rb index d23f458e5..807ee9ec8 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,10 +20,16 @@ # 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 + belongs_to :author, :class_name => "User", :foreign_key => "user_id", :optional => true + 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" @@ -84,22 +93,20 @@ class Note < ApplicationRecord # Return the note's description, derived from the first comment def description - comments.first.body + if user_ip.nil? && user_id.nil? + all_comments.first.body + else + RichText.new("text", super) + end end # Return the note's author object, derived from the first comment def author - comments.first.author - end - - # Return the note's author ID, derived from the first comment - def author_id - comments.first.author_id - end - - # Return the note's author IP address, derived from the first comment - def author_ip - comments.first.author_ip + if user_ip.nil? && user_id.nil? + all_comments.first.author + else + super + end end private