cirandas.net

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20

require_dependency 'category'

Category.class_eval do
  # Use count_without_distinct
  scope :pg_search_plugin_profiles_facets, -> scope {
    joins(:profiles).
    where('profiles.id' => scope.map(&:id)).
    where('categories_profiles.virtual' => false).
    where("categories.type IS NULL").
    group('categories.id')
  }

  scope :pg_search_plugin_articles_facets, -> scope {
    joins(:articles).
    where('articles.id' => scope.map(&:id)).
    where('articles_categories.virtual' => false).
    where("categories.type IS NULL").
    group('categories.id')
  }
end