class Note < ActiveRecord::Base
include GeoRecord
- has_many :comments, :class_name => "NoteComment",
- :foreign_key => :note_id,
- :order => :created_at,
- :conditions => { :visible => true }
+ has_many :comments, -> { where(:visible => true).order(:created_at) }, :class_name => "NoteComment", :foreign_key => :note_id
validates_presence_of :id, :on => :update
validates_uniqueness_of :id
validates_inclusion_of :status, :in => ["open", "closed", "hidden"]
validate :validate_position
- attr_accessible :lat, :lon
+ scope :visible, -> { where("status != 'hidden'") }
+ scope :invisible, -> { where("status = 'hidden'") }
after_initialize :set_defaults
self.save
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.display_name if comment.author
- resp += " " + comment.created_at.to_s + " ]"
- comment_no += 1
- end
-
- return resp
+ # Reopen a note
+ def reopen
+ self.status = "open"
+ self.closed_at = nil
+ self.save
end
# Check if a note is visible