Contents

module Dorsale::Search
  extend ActiveSupport::Concern

  class_methods do
    def default_search_fields
      fields = columns.map do |column|
        "#{table_name}.#{column.name}"
      end
    end # def default_search_fields

    def search(q, *fields)
      words  = q.to_s.parameterize.split("-")
      fields = default_search_fields if fields.empty?

      sql_query = words.map.with_index do |word, index|
        fields.map do |field|
          "(LOWER(CAST(#{field} AS TEXT)) LIKE :w#{index})"
        end.join(" OR ")
      end.map{ |e| "(#{e})" }.join(" AND ")

      sql_params_a = words.map.with_index do |word, index|
        ["w#{index}".to_sym, "%#{word}%"]
      end

      sql_params_h = Hash[sql_params_a]

      self.where(sql_query, sql_params_h)
    end # def search
  end # class_methods
end # class Dorsale::Search

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
dorsale-3.4.0	app/models/concerns/dorsale/search.rb