exercism/website

class Track::Search
  STATUSES = %i[all joined unjoined].freeze

  include Mandate

  def initialize(criteria: nil, tags: nil, status: nil, user: nil)
    @criteria = criteria
    @tags = tags
    @status = status.try(&:to_sym)
    @user = user
  end

  def call
    @tracks = Track.active
    filter_criteria!
    filter_tags!
    filter_status!
    @tracks
  end

  private
  attr_reader :criteria, :tags, :status, :user, :tracks

  def filter_criteria!
    return if criteria.blank?

    @tracks = tracks.where("title like ?", "%#{criteria}%").
      or(tracks.where("slug like ?", "%#{criteria}%"))
  end

  def filter_tags!
    return if tags.blank?

    tags.each do |tag|
      # The correct SQL for this is:
      # JSON_CONTAINS(tags, '"tag"', '$')
      @tracks = @tracks.where("JSON_CONTAINS(tags, ?, '$')", %("#{tag}"))
    end
  end

  def filter_status!
    return if status.blank?
    raise TrackSearchStatusWithoutUserError unless user
    raise TrackSearchInvalidStatusError unless STATUSES.include?(status.to_sym)
    return if status == :all

    if status == :joined
      @tracks = tracks.where(id: user.tracks)
    else
      @tracks = tracks.where.not(id: user.tracks)
    end
  end
end