af83/chouette-core

module Chouette
  class Footnote < Chouette::ActiveRecord
    include ChecksumSupport

    belongs_to :line, inverse_of: :footnotes
    has_and_belongs_to_many :vehicle_journeys, :class_name => 'Chouette::VehicleJourney'

    scope :associated, -> {
      joins(:vehicle_journeys).where("vehicle_journeys.id is not null")
    }

    scope :not_associated, -> {
      joins('LEFT JOIN "footnotes_vehicle_journeys" ON footnotes_vehicle_journeys.footnote_id = footnotes.id')
      .where("footnotes_vehicle_journeys.vehicle_journey_id is null")
    }

    scope :for_vehicle_journey, -> (vehicle_journey){
      joins('INNER JOIN "footnotes_vehicle_journeys" ON footnotes_vehicle_journeys.footnote_id = footnotes.id').where("footnotes_vehicle_journeys.vehicle_journey_id = ?", vehicle_journey.id)
    }

    validates_presence_of :line

    def checksum_attributes(db_lookup = true)
      attrs = ['code', 'label']
      self.slice(*attrs).values
    end
  end
end