overlapping.rb

  # find any jobs that chronologically overlap an array of job_assignments
  # ex: find any jobs that overlap an interpreter's existing jobs via the job_assignments
  def self.overlapping(job_assignments)
    jobs_table = Job.arel_table
    query = Job.scoped
    job_assignments.each do |ja|
      query = query.where((jobs_table[:start_datetime].in(ja.scheduled_start..ja.estimated_end)).
                              or(jobs_table[:end_datetime].in(ja.scheduled_start..ja.estimated_end)))
    end
    query
  end