unepwcmc/SAPI

# == Schema Information
#
# Table name: trade_taxon_concept_term_pairs
#
#  id               :integer          not null, primary key
#  taxon_concept_id :integer
#  term_id          :integer
#  created_at       :datetime         not null
#  updated_at       :datetime         not null
#

class Trade::TaxonConceptTermPair < ApplicationRecord
  # Migrated to controller (Strong Parameters)
  # attr_accessible :taxon_concept_id, :term_id
  validates_uniqueness_of :taxon_concept_id, scope: :term_id

  belongs_to :taxon_concept
  belongs_to :term, :class_name => "TradeCode"

  def self.search(query)
    if query.present?
      where("UPPER(taxon_concepts.full_name) LIKE UPPER(:query)
            OR UPPER(trade_codes.code) LIKE UPPER(:query)",
            :query => "%#{query}%").
      joins(<<-SQL
          LEFT JOIN taxon_concepts
            ON taxon_concepts.id = trade_taxon_concept_term_pairs.taxon_concept_id
          LEFT JOIN trade_codes
            ON trade_codes.id = trade_taxon_concept_term_pairs.term_id
        SQL
      )
    else
      all
    end
  end
end