vegantech/sims

# == Schema Information
# Schema version: 20101101011500
#
# Table name: objective_definitions
#
#  id                 :integer(4)      not null, primary key
#  title              :string(255)
#  description        :text
#  goal_definition_id :integer(4)
#  position           :integer(4)
#  disabled           :boolean(1)
#  created_at         :datetime
#  updated_at         :datetime
#

class ObjectiveDefinition < ActiveRecord::Base
  include LinkAndAttachmentAssets
  belongs_to :goal_definition
  has_many :intervention_clusters, :order =>:position, :dependent=> :destroy
  has_many :intervention_definitions, :through => :intervention_clusters
  scope :enabled, where(:disabled => false)
  scope :content_export, enabled

  validates_presence_of :title, :description
  validates_uniqueness_of :description, :scope => [:goal_definition_id,:title]
  acts_as_list :scope => :goal_definition_id
  delegate :district, :to => :goal_definition, :allow_nil => true

  define_statistic :count , :count => :all, :joins => :goal_definition
  define_statistic :distinct_titles , :count => :all,  :column_name => 'distinct objective_definitions.title', :joins=>:goal_definition
  define_calculated_statistic :districts_with_changes do
    group("#{self.name.tableize}.title").having("count(#{self.name.tableize}.title)=1").select(
      'distinct district_id').joins(:goal_definition).length
  end

  def filename
    @filename ||= "#{title.split(" ").join("_")}".gsub("/","-").gsub("&","and")
  end


  def disable!
    intervention_clusters.each(&:disable!)
    update_attribute(:disabled,true)
  end

  def to_s
    title
  end

  def self.find_by_filename(filename)
    all.detect{|o| filename == o.filename}
  end
end