Remove cascading deletes, add another foreign key, and switch index around.

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

diff --git a/app/models/issue.rb b/app/models/issue.rb
index 7a481fe6cc80e0594f51a7ff167075a0a983d22b..00ee934f7a0fe430d1b54720fb85837e948206ab 100644 (file)
--- a/app/models/issue.rb
+++ b/app/models/issue.rb
@@ -1,45 +1,101 @@
+# == Schema Information
+#
+# Table name: issues
+#
+#  id               :integer          not null, primary key
+#  reportable_type  :string           not null
+#  reportable_id    :integer          not null
+#  reported_user_id :integer
+#  status           :integer
+#  assigned_role    :enum             not null
+#  resolved_at      :datetime
+#  resolved_by      :integer
+#  updated_by       :integer
+#  reports_count    :integer          default(0)
+#  created_at       :datetime         not null
+#  updated_at       :datetime         not null
+#
+# Indexes
+#
+#  index_issues_on_reportable_type_and_reportable_id  (reportable_type,reportable_id)
+#  index_issues_on_reported_user_id                   (reported_user_id)
+#  index_issues_on_updated_by                         (updated_by)
+#
+# Foreign Keys
+#
+#  issues_reported_user_id_fkey  (reported_user_id => users.id)
+#  issues_resolved_by_fkey       (resolved_by => users.id)
+#  issues_updated_by_fkey        (updated_by => users.id)
+#
+
 class Issue < ActiveRecord::Base
-       belongs_to :reportable, :polymorphic => true
-       has_many :reports
-       has_many :comments, :class_name => "IssueComment"
-       validates :reportable_id, :uniqueness => { :scope => [ :reportable_type ] }
-       belongs_to :user
-       validates :user_id, :presence => true
+  belongs_to :reportable, :polymorphic => true
+  belongs_to :reported_user, :class_name => "User", :foreign_key => :reported_user_id
+  belongs_to :user_resolved, :class_name => "User", :foreign_key => :resolved_by
+  belongs_to :user_updated, :class_name => "User", :foreign_key => :updated_by
+
+  has_many :reports, :dependent => :destroy
+  has_many :comments, :class_name => "IssueComment", :dependent => :destroy
+
+  validates :reportable_id, :uniqueness => { :scope => [:reportable_type] }
+
+  ASSIGNED_ROLES = %w[administrator moderator].freeze
+  validates :assigned_role, :presence => true, :inclusion => ASSIGNED_ROLES
+
+  before_validation :set_default_assigned_role
+  before_validation :set_reported_user
+
+  # Check if more statuses are needed
+  enum :status => %w[open ignored resolved]
 
-       # Check if more statuses are needed
-       enum status: %w( open ignored resolved )
+  scope :with_status, ->(issue_status) { where(:status => statuses[issue_status]) }
 
-       scope :with_status, -> (issue_status) { where(:status => statuses[issue_status])}
+  def read_reports
+    resolved_at.present? ? reports.where("updated_at < ?", resolved_at) : nil
+  end
 
-       def read_reports
-               resolved_at.present? ? reports.where("created_at < ?", resolved_at) : nil
-       end
+  def unread_reports
+    resolved_at.present? ? reports.where("updated_at >= ?", resolved_at) : reports
+  end
 
-       def unread_reports
-    resolved_at.present? ? reports.where("created_at >= ?", resolved_at) : reports
-       end
+  include AASM
+  aasm :column => :status, :no_direct_assignment => true do
+    state :open, :initial => true
+    state :ignored
+    state :resolved
 
-       include AASM
-       aasm :column => :status, :no_direct_assignment => true do
-               state :open, :initial => true
-               state :ignored
-               state :resolved
+    event :ignore do
+      transitions :from => :open, :to => :ignored
+    end
 
-               event :ignore do
-                       transitions :from => :open, :to => :ignored 
-               end
+    event :resolve do
+      transitions :from => :open, :to => :resolved
+      after do
+        self.resolved_at = Time.now.getutc
+      end
+    end
 
-               event :resolve do
-                       transitions :from => :open, :to => :resolved
-                       after do
-                               self.resolved_at = Time.now.getutc
-                       end
-               end
+    event :reopen do
+      transitions :from => :resolved, :to => :open
+      transitions :from => :ignored, :to => :open
+    end
+  end
 
-               event :reopen do
-                       transitions :from => :resolved, :to => :open
-               end
+  private
 
-       end
+  def set_reported_user
+    self.reported_user = case reportable.class.name
+                         when "User"
+                           reportable
+                         when "Note"
+                           reportable.author
+                         else
+                           reportable.user
+                         end
+  end
 
+  def set_default_assigned_role
+    role = %w[Note].include?(reportable.class.name) ? "moderator" : "administrator"
+    self.assigned_role = role if assigned_role.blank?
+  end
 end