category_finder.rb
3.62 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
class CategoryFinder
def initialize(cat)
@category = cat
@category_id = @category.id
end
attr_reader :category_id
def find(asset, query='', options={})
@region = Region.find_by_id(options.delete(:region)) if options.has_key?(:region)
if @region && options[:within]
options[:origin] = [@region.lat, @region.lng]
else
options.delete(:within)
end
options = {:page => 1, :per_page => options.delete(:limit)}.merge(options)
if query.blank?
asset_class(asset).paginate(:all, options_for_find(asset_class(asset), {:order => "created_at desc, #{asset_table(asset)}.id desc"}.merge(options)))
else
ferret_options = {:page => options.delete(:page), :per_page => options.delete(:per_page)}
asset_class(asset).find_by_contents(query, ferret_options, options_for_find(asset_class(asset), options))
end
end
def recent(asset, limit = nil)
find(asset, nil, :limit => limit)
end
def count(asset, query='', options={})
# because will_paginate needs a page
options = {:page => 1}.merge(options)
find(asset, query, options).total_entries
end
def most_commented_articles(limit=10)
Article.find(:all, options_for_find(Article, :limit => limit, :order => 'comments_count DESC'))
end
def current_events(year, month)
range = Event.date_range(year, month)
Event.find(:all, :include => :categories, :conditions => { 'categories.id' => category_id, :start_date => range })
end
protected
def options_for_find(klass, options={})
if defined? options[:product_category]
prod_cat = options.delete(:product_category)
# FIXME this is SLOOOOW
prod_cat_ids = prod_cat.map_traversal(&:id) if prod_cat
end
case klass.name
when 'Comment'
{:joins => 'inner join articles_categories on articles_categories.article_id = comments.article_id', :conditions => ['articles_categories.category_id = (?)', category_id]}.merge!(options)
when 'Product'
if prod_cat_ids
{:joins => 'inner join categories_profiles on products.enterprise_id = categories_profiles.profile_id', :conditions => ['categories_profiles.category_id = (?) and products.product_category_id in (?)', category_id, prod_cat_ids]}.merge!(options)
else
{:joins => 'inner join categories_profiles on products.enterprise_id = categories_profiles.profile_id', :conditions => ['categories_profiles.category_id = (?)', category_id]}.merge!(options)
end
when 'Article', 'Event'
{:joins => 'inner join articles_categories on (articles_categories.article_id = articles.id)', :conditions => ['articles_categories.category_id = (?)', category_id]}.merge!(options)
when 'Enterprise'
if prod_cat_ids
{:joins => 'inner join categories_profiles on (categories_profiles.profile_id = profiles.id) inner join products on (products.enterprise_id = profiles.id)', :conditions => ['categories_profiles.category_id = (?) and products.product_category_id in (?)', category_id, prod_cat_ids]}.merge!(options)
else
{:joins => 'inner join categories_profiles on (categories_profiles.profile_id = profiles.id)', :conditions => ['categories_profiles.category_id = (?)', category_id]}.merge!(options)
end
when 'Person', 'Community'
{:joins => 'inner join categories_profiles on (categories_profiles.profile_id = profiles.id)', :conditions => ['categories_profiles.category_id = (?)', category_id]}.merge!(options)
else
raise "unreconized class #{klass.name}"
end
end
def asset_class(asset)
asset.to_s.singularize.camelize.constantize
end
def asset_table(asset)
asset_class(asset).table_name
end
end