Redmine

  # Groups and active users

  scope :active, lambda { where(:status => STATUS_ACTIVE) }

  scope :like, lambda {|q|

    q = q.to_s

      active.uniq.joins(:members).where("#{Member.table_name}.project_id IN (?)", ids)

    end

  }

  # Principals that are not members of projects

  scope :not_member_of, lambda {|projects|

    projects = [projects] unless projects.is_a?(Array)

    issue_custom_fields = []

    if project

      unless project.leaf?

        subprojects = project.descendants.visible.all

        principals += Principal.member_of(subprojects)

      end

      versions = project.shared_versions.all

      categories = project.issue_categories.all

    else

      if all_projects.any?

        principals += Principal.member_of(all_projects)

      end

      versions = Version.visible.find_all_by_sharing('system')

      issue_custom_fields = IssueCustomField.where(:is_filter => true, :is_for_all => true).all

  has_many :member_principals, :class_name => 'Member',

                               :include => :principal,

                               :conditions => "#{Principal.table_name}.type='Group' OR (#{Principal.table_name}.type='User' AND #{Principal.table_name}.status=#{Principal::STATUS_ACTIVE})"

  has_many :users, :through => :members

  has_many :principals, :through => :member_principals, :source => :principal

  has_many :enabled_modules, :dependent => :delete_all

  has_and_belongs_to_many :trackers, :order => "#{Tracker.table_name}.position"