Residence search hack

residence_search_hack.rb

class Residency < ActiveRecord::Base
  scope :filter, lambda { |query, *attributes|
    return if query.blank?

    attributes = self.new.attributes.keys if attributes.empty?

    query.split(/\s/).inject(self) do |collection, phrase|
      conditions = [""]
      attributes.each do |attribute|
        conditions[0] << attribute.to_s << " ILIKE ? OR "
        conditions.push "%#{phrase}%"
      end
      conditions[0] = conditions[0].sub(/ OR $/,"")
      collection = collection.where(conditions)
    end
  }
end

Residencies.joins(rooms: [:access_point, :building]).filter("Huxton Avenue 203A",
  'rooms.room_no',
  'access_pints.app_no',
  'buildings.name'
)