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

def self.paged_search(query, from, category, locality, page, per_page = 10)
    query_str = []
    query_prms = []
    if from
      query_str << "created_at > ?"
      query_prms << from
    end
    unless locality.blank?
      unless locality.is_a?(Array)
        l = Locality.find(locality)
        locality = l.direct_children.collect {|i| i.id } << l.id if l.direct_children.size > 0
      end
      query_str << "locality_id IN (?)"
      query_prms << locality
    end
    unless category.blank?
      unless category.is_a?(Array)
        c = Category.find(category)
        category = c.direct_children.collect {|i| i.id } << c.id if c.direct_children.size > 0
      end
      query_str << "category_assignments.category_id IN (?)"
      query_prms << category
    end
    conditions = [query_str.join(" AND ")] + query_prms
    if query.blank?
      companies = Company.paginate(:conditions=> conditions, :page => page, :joins => :category_assignments, :per_page => per_page)
    else
      companies = Company.find_by_contents(query, {:page => page, :per_page => per_page}, :joins => :category_assignments, :conditions => conditions )  
    end
    return companies.uniq
  end