Method: Effective::Resources::Relation#search_any

Defined in:
app/models/effective/resources/relation.rb

#search_any(value, columns: nil, fuzzy: nil) ⇒ Object 



349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
 
# File 'app/models/effective/resources/relation.rb', line 349

def search_any(value, columns: nil, fuzzy: nil)
  raise 'expected relation to be present' unless relation

  # Assume this is a set of IDs
  if value.kind_of?(Integer) || value.kind_of?(Array) || (value.to_i.to_s == value)
    return relation.where(klass.primary_key => value)
  end

  # If the user specifies columns. Filter out invalid ones for this klass
  if columns.present?
    columns = Array(columns).map(&:to_s) - [nil, '']
    columns = (columns & search_columns)
  end

  # Otherwise, we fall back to a string/text search of all columns
  columns = Array(columns || search_columns).reject do |column|
    DO_NOT_SEARCH_EQUALS.any? { |value| column == value } ||
    DO_NOT_SEARCH_INCLUDE.any? { |value| column.include?(value) } ||
    DO_NOT_SEARCH_END_WITH.any? { |value| column.end_with?(value) }
  end

  return relation.none() if columns.blank?

  fuzzy = true unless fuzzy == false

  # Retval
  searched = relation
  terms = value.split(' ') - [nil, '']

  terms.each do |term|
    conditions = (
      if fuzzy
        columns.map { |name| "#{sql_column(name)} #{ilike} :fuzzy" }
      else
        columns.map { |name| "#{sql_column(name)} = :term" }
      end
    ).join(' OR ')

    searched = searched.where(conditions, fuzzy: "%#{term}%", term: term)
  end

  searched
end