module ExpressAdmin class Search def self.execute(scope, params = nil) @search_results = [] @tables_traversed = [] @scope = scope @params = params self.search_parent_tables(scope) @search_results = @search_results | scope.basic_search(params) if searchable?(scope.columns) @search_results = @search_results | scope.fuzzy_search(params) if searchable?(scope.columns) @search_results end def self.search_parent_tables(scope) @associations = scope.reflect_on_all_associations(:belongs_to).map(&:name) if @associations.present? @associations.each do |assoc| @tables_traversed.push assoc associated_table = scope.reflect_on_association(assoc.to_sym).try(:klass) rescue nil unless associated_table.nil? column_names = self.get_columns(associated_table).map(&:name) column_names.each do |columns| # Search using Textacular result = @scope.joins(self.join_generator).fuzzy_search(associated_table.table_name.to_sym => {columns.to_sym => @params }) @search_results = @search_results | result unless result.empty? end self.search_parent_tables(associated_table) end end end @tables_traversed.pop end def self.join_generator @tables_traversed.reverse.inject { |memo, table| {table => memo} } end def self.get_columns(associated_table) assoc_table_columns = associated_table.columns string_columns = [] assoc_table_columns.each do |columns| if columns.type.eql? :string string_columns << columns end end string_columns end def self.searchable?(columns) type = columns.map(&:type) type.include?(:string) || type.include?(:text) end private_class_method :searchable? end end