class CmAdmin::Models::Filter

def cm_date_and_range_filter(scope_value, records, filters)
  return nil if scope_value.nil?
  scope_value.each do |key, value|
    if value.present?
      value = value.split(' to ')
      from = value[0].presence
      to = value[1].presence
      records = records.where(key => from..to)
    end
  end
  records
end

def cm_dropdown_filter(scope_value, records, filters)
  return nil if scope_value.nil?
  scope_value.each do |key, value|
    records = records.where(key => value) if value.present?
  end
  records
end

def cm_search_filter(scope_value, records, filters)
  return nil if scope_value.blank?
  table_name = records.table_name
  filters.select{|x| x if x.filter_type.eql?(:search)}.each do |filter|
    terms = scope_value.downcase.split(/\s+/)
    terms = terms.map { |e|
      (e.gsub('*', '%').prepend('%') + '%').gsub(/%+/, '%')
    }
    sql = ""
    filter.db_column_name.each.with_index do |column, i|
      sql.concat("#{table_name}.#{column} ILIKE ?")
      sql.concat(' OR ') unless filter.db_column_name.size.eql?(i+1)
    end
    records = records.where(
      terms.map { |term|
        sql
      }.join(' AND '),
      *terms.map { |e| [e] * filter.db_column_name.size }.flatten
    )
  end
  records
end

def filtered_data(filter_params, records, filters)
  if filter_params
    filter_params.each do |scope_type, scope_value|
      scope_name = if scope_type.eql?('date') || scope_type.eql?('range')
        'date_and_range'
      elsif scope_type.eql?('single_select') || scope_type.eql?('multi_select')
        'dropdown'
      else
        scope_type
      end
      records = self.send("cm_#{scope_name}_filter", scope_value, records, filters) if scope_value.present?
    end
  end
  records
end

def initialize(db_column_name:, filter_type:, options: {})
  raise TypeError, "Can't have array of multiple columns for #{filter_type} filter" if db_column_name.is_a?(Array) && db_column_name.size > 1 && !filter_type.to_sym.eql?(:search)
  raise ArgumentError, "Kindly select a valid filter type like #{VALID_FILTER_TYPES.sort.to_sentence(last_word_connector: ', or ')} instead of #{filter_type} for column #{db_column_name}" unless VALID_FILTER_TYPES.include?(filter_type.to_sym)
  @db_column_name, @filter_type = structure_data(db_column_name, filter_type)
  options.each do |key, value|
    self.send("#{key.to_s}=", value)
  end
end

def structure_data(db_column_name, filter_type)
  filter_type = filter_type.is_a?(Array) ? filter_type[0].to_sym : filter_type.to_sym
  case filter_type
  when :search
    db_column_name = (Array.new << db_column_name).flatten.map(&:to_sym)
  else
    db_column_name = db_column_name.is_a?(Array) ? db_column_name[0].to_sym : db_column_name.to_sym
  end
  [db_column_name, filter_type]
end