Sha256: 9ea6341d2707e141276020a9da19f06460ac033feace57d54e75cfe7423bcffd
Contents?: true
Size: 1.63 KB
Versions: 12
Compression:
Stored size: 1.63 KB
Contents
module Calagator
class Venue < ActiveRecord::Base
class SearchEngine
class Sql < Struct.new(:query, :opts)
def self.search(*args)
new(*args).search
end
def search
base.keywords.non_duplicates.with_wifi.in_business.order.limit.scope.to_a
end
protected
attr_accessor :scope
def base
column_names = Venue.column_names.map { |name| "venues.#{name}" }
@scope = Venue.all
.group(column_names)
.joins("LEFT OUTER JOIN taggings on taggings.taggable_id = venues.id AND taggings.taggable_type LIKE '%Venue'")
.joins("LEFT OUTER JOIN tags ON tags.id = taggings.tag_id")
self
end
def keywords
query_conditions = @scope
.where(['LOWER(title) LIKE ?', "%#{query.downcase}%"])
.where(['LOWER(description) LIKE ?', "%#{query.downcase}%"])
query_conditions = query.split.inject(query_conditions) do |query_conditions, keyword|
query_conditions.where(['LOWER(tags.name) = ?', keyword])
end
@scope = @scope.where(query_conditions.where_values.join(' OR '))
self
end
def non_duplicates
@scope = @scope.non_duplicates
self
end
def order
@scope = @scope.order('LOWER(venues.title) ASC')
self
end
def limit
@scope = @scope.limit(opts[:limit] || 50)
self
end
def with_wifi
@scope = @scope.with_public_wifi if opts[:wifi]
self
end
def in_business
@scope = @scope.in_business unless opts[:include_closed]
self
end
end
end
end
end
Version data entries
12 entries across 12 versions & 2 rubygems