# frozen_string_literal: true

# = Informations
#
# == License
#
# Ekylibre - Simple agricultural ERP
# Copyright (C) 2008-2009 Brice Texier, Thibaud Merigon
# Copyright (C) 2010-2012 Brice Texier
# Copyright (C) 2012-2014 Brice Texier, David Joulin
# Copyright (C) 2015-2023 Ekylibre SAS
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU Affero General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with this program.  If not, see http://www.gnu.org/licenses.
#
# == Table: entity_links
#
#  created_at   :datetime         not null
#  creator_id   :integer(4)
#  description  :text
#  entity_id    :integer(4)       not null
#  entity_role  :string           not null
#  id           :integer(4)       not null, primary key
#  linked_id    :integer(4)       not null
#  linked_role  :string           not null
#  lock_version :integer(4)       default(0), not null
#  main         :boolean          default(FALSE), not null
#  nature       :string           not null
#  post         :string
#  started_at   :datetime
#  stopped_at   :datetime
#  updated_at   :datetime         not null
#  updater_id   :integer(4)
#

class EntityLink < ApplicationRecord
  belongs_to :entity
  belongs_to :linked, class_name: 'Entity'
  refers_to :nature, class_name: 'EntityLinkNature'
  # [VALIDATORS[ Do not edit these lines directly. Use `rake clean:validations`.
  validates :description, length: { maximum: 500_000 }, allow_blank: true
  validates :entity_role, :linked_role, presence: true, length: { maximum: 500 }
  validates :main, inclusion: { in: [true, false] }
  validates :entity, :linked, :nature, presence: true
  validates :post, length: { maximum: 500 }, allow_blank: true
  validates :started_at, timeliness: { on_or_after: -> { Time.new(1, 1, 1).in_time_zone }, on_or_before: -> { Time.zone.now + 100.years } }, allow_blank: true
  validates :stopped_at, timeliness: { on_or_after: ->(entity_link) { entity_link.started_at || Time.new(1, 1, 1).in_time_zone }, on_or_before: -> { Time.zone.now + 100.years } }, allow_blank: true
  # ]VALIDATORS]
  validates :nature, inclusion: { in: nature.values }

  selects_among_all :main, scope: :entity_id

  scope :of_entity, lambda { |entity|
    # where("stopped_at IS NULL AND ? IN (entity_id, linked_id)", entity.id)
    # where(stopped_at: nil, entity.id => [:entity_id, :linked_id])
    where(stopped_at: nil).where('? IN (entity_id, linked_id)', entity.id)
  }
  scope :at, lambda { |at|
    where(arel_table[:started_at].eq(nil).or(arel_table[:started_at].lt(at)).and(arel_table[:stopped_at].eq(nil).or(arel_table[:stopped_at].gt(at))))
  }
  scope :actives, -> { at(Time.zone.now) }

  before_validation do
    self.started_at ||= Time.zone.now
    if (item = Onoma::EntityLinkNature[nature])
      self.entity_role = item.entity
      self.linked_role = item.linked
    end
  end
end
