Rename some columns and indexes in the bug tables

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

diff --git a/app/models/map_bug.rb b/app/models/map_bug.rb
index 61c9f145f5aff0b2c37c73b009cf90d873cc7009..2ae110bf2fcc897c30f56f8dde60f60c5e9641be 100644 (file)
--- a/app/models/map_bug.rb
+++ b/app/models/map_bug.rb
@@ -1,32 +1,49 @@
 class MapBug < ActiveRecord::Base
   include GeoRecord
 
-  set_table_name 'map_bugs'
+  has_many :comments, :class_name => "MapBugComment",
+                      :foreign_key => :bug_id,
+                      :order => :created_at,
+                      :conditions => "visible = true AND body IS NOT NULL"
 
   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 :date_created
-  validates_presence_of :last_changed
-  validates_inclusion_of :status, :in => [ "open", "closed", "hidden" ]
-
-
-  def self.create_bug(lat, lon, comment)
-       bug = MapBug.new(:lat => lat, :lon => lon);
-       raise OSM::APIBadUserInput.new("The node is outside this world") unless bug.in_world?
-       bug.text = comment
-       bug.date_created = Time.now.getutc
-       bug.last_changed = Time.now.getutc
-       bug.status = "open";
-       bug.save;
-       return bug;
+  validates_presence_of :closed_at if :status == "closed"
+  validates_inclusion_of :status, :in => ["open", "closed", "hidden"]
+
+  def self.create_bug(lat, lon)
+    bug = MapBug.new(:lat => lat, :lon => lon, :status => "open")
+    raise OSM::APIBadUserInput.new("The node is outside this world") unless bug.in_world?
+
+    return bug
   end
 
   def close_bug
-       self.status = "closed"
-       self.last_changed = Time.now.getutc
-       self.save;
+    self.status = "closed"
+    self.closed_at = Time.now.getutc
+
+    self.save
   end
 
+  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
+  end
+
+  def visible
+    return status != "hidden"
+  end
 end