dobtco/dispatch

# == Schema Information
#
# Table name: opportunities
#
#  id                                :integer          not null, primary key
#  created_by_user_id                :integer
#  title                             :string
#  description                       :text
#  department_id                     :integer
#  contact_name                      :string
#  contact_email                     :string
#  contact_phone                     :string
#  submission_adapter_name           :string
#  submission_adapter_data           :text
#  publish_at                        :datetime
#  submissions_open_at               :datetime
#  submissions_close_at              :datetime
#  submission_deadline_reminder_sent :boolean          default(FALSE), not null
#  enable_questions                  :boolean          default(FALSE), not null
#  questions_open_at                 :datetime
#  questions_close_at                :datetime
#  question_deadline_reminder_sent   :boolean          default(FALSE), not null
#  submitted_at                      :datetime
#  approved_at                       :datetime
#  approved_by_user_id               :integer
#  deleted_at                        :datetime
#  created_at                        :datetime         not null
#  updated_at                        :datetime         not null
#
# Indexes
#
#  index_opportunities_on_department_id  (department_id)
#
 
Class `Opportunity` has 21 methods (exceeds 20 allowed). Consider refactoring.
class Opportunity < ActiveRecord::Base
  include PgSearch
 
  has_storage_unit
 
  # Currently using this to manage permissions. Eventually we could switch
  # to a 1-many
  belongs_to :created_by_user, class_name: 'User'
 
  belongs_to :approved_by_user, class_name: 'User'
  belongs_to :department
 
  has_and_belongs_to_many :users
  has_and_belongs_to_many :categories
  has_many :questions, dependent: :destroy
  has_many :attachments, dependent: :destroy
 
  serialize :submission_adapter_data, Hash
 
  scope :not_approved, -> { where('approved_at IS NULL') }
  scope :approved, -> { where('approved_at IS NOT NULL') }
 
  scope :published, -> do
    where('publish_at IS NULL OR publish_at < ?', Time.now)
  end
 
  scope :not_published, -> do
    where('publish_at IS NOT NULL AND publish_at > ?', Time.now)
  end
 
  scope :posted, -> { approved.published }
 
  scope :not_posted, -> do
    where('(publish_at IS NOT NULL AND publish_at > ?) || approved_at IS NULL')
  end
 
  scope :order_by_recently_posted, -> do
    order('GREATEST(publish_at, approved_at) DESC')
  end
 
  scope :order_by_recently_updated, -> do
    order('updated_at DESC')
  end
 
  scope :submissions_open, -> do
    where('submissions_close_at IS NULL OR submissions_close_at > ?', Time.now)
  end
 
  scope :submissions_closed, -> do
    where(
      'submissions_close_at IS NOT NULL AND submissions_close_at < ?',
      Time.now
    )
  end
 
  pg_search_scope(
    :full_text,
    against: [
      :title,
      :description,
      :contact_name,
      :contact_email,
      :contact_phone
    ],
    associated_against: {
      questions: [:question_text, :answer_text],
      attachments: [:upload, :text_content],
      department: [:name]
    },
    using: {
      tsearch: {
        prefix: true
      }
    }
  )
 
  validates :title, presence: true
  validates :created_by_user, presence: true
  validate :ensure_submission_adapter_is_valid
 
  delegate :submission_page,
           :view_proposals_url,
           :view_proposals_link_text,
           :submit_proposals_url,
           :submit_proposals_instructions,
           :submittable?,
           to: :submission_adapter
 
  before_create :set_default_submission_adapter_params,
                :set_default_contact_info
 
  def self.with_any_category(category_ids)
    where(
      %(
        (SELECT categories_opportunities.category_id
        FROM categories_opportunities
        WHERE categories_opportunities.opportunity_id = opportunities.id
        AND categories_opportunities.category_id IN (?)
        LIMIT 1) IS NOT NULL
      ).squish,
      category_ids
    )
  end
 
  def self.needs_question_deadline_reminders
    posted.
    where(enable_questions: true).
    where(question_deadline_reminder_sent: false).
    where(
      'questions_close_at IS NOT NULL and questions_close_at < ?',
      Time.now + DispatchConfiguration.question_deadline_reminder_hours.hours
    )
  end
 
  def self.needs_submission_deadline_reminders
    posted.
    where(submission_deadline_reminder_sent: false).
    where(
      'submissions_close_at IS NOT NULL and submissions_close_at < ?',
      Time.now + DispatchConfiguration.submission_deadline_reminder_hours.hours
    )
  end
 
  def posted?
    approved? && published?
  end
 
  def approved?
    approved_at.present?
  end
 
  def approve!
    update approved_at: Time.now
  end
 
  def unapprove!
    update approved_at: nil
  end
 
  def published?
    !publish_at ||
    publish_at < Time.now
  end
 
  def posted_at
    [
      publish_at,
      approved_at
    ].compact.max
  end
 
  def to_param
    "#{id}-#{title.parameterize}"
  end
 
  def submission_adapter
    if submission_adapter_name.present?
      "SubmissionAdapters::#{submission_adapter_name}".constantize.new(self)
    else
      blank_submission_adapter
    end
  rescue
    blank_submission_adapter
  end
 
  def open_for_submissions?
    (!submissions_open_at || submissions_open_at < Time.now) &&
    (!submissions_close_at || submissions_close_at > Time.now)
  end
 
  def open_for_questions?
    enable_questions? &&
    (!questions_open_at || questions_open_at < Time.now) &&
    (!questions_close_at || questions_close_at > Time.now)
  end
 
  def submitted_for_approval?
    submitted_at.present?
  end
 
  def submit_for_approval!
    update submitted_at: Time.now
  end
 
  def contact_info?
    contact_name.present? ||
    contact_email.present? ||
    contact_phone.present?
  end
 
  # @return [Symbol] one of the following:
  # :not_approved, :submitted_for_approval, :not_published,
  # :open_for_submissions, :closed
Method `status_key` has a Cognitive Complexity of 7 (exceeds 5 allowed). Consider refactoring.
  def status_key
    if !approved?
      if submitted_for_approval?
        :pending_approval
      else
        :draft
      end
    elsif !posted?
      :not_published
    elsif open_for_submissions?
      :open
    else
      :closed
    end
  end
 
  private
 
  def blank_submission_adapter
    SubmissionAdapters::None.new(self)
  end
 
  def set_default_submission_adapter_params
    self.submission_adapter_name ||= 'Email'
 
    if submission_adapter_name == 'Email'
      self.submission_adapter_data = {
        'email' => created_by_user.email,
        'name' => created_by_user.name
      }
    end
  end
 
  def set_default_contact_info
    self.contact_name ||= created_by_user.name
    self.contact_email ||= created_by_user.email
  end
 
  def ensure_submission_adapter_is_valid
    unless submission_adapter.valid?
      errors.add(:submission_adapter, :invalid)
    end
  end
end