Module: SimpleSearch::ActiveRecord::ClassMethods

Defined in:
lib/simple_search/active_record.rb

Instance Method Summary collapse

Instance Method Details

#filtered_params(params) ⇒ Object 



34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
 
# File 'lib/simple_search/active_record.rb', line 34

def filtered_params(params)
	where_params = {}
	other_params = {}
     params.each do |key,value|
		if ["group_by","page_by","page", "order_by"].include?(key)
			other_params[key]=value
		elsif value != ''
			matches = /(.*)_([a-z]+)$/.match(key)
			if matches!=nil && matches.length==3
				all, col, op = matches.to_a
				operands = SimpleSearch::OP_MAP.keys
				if operands.include?(op.to_sym)
					where_params[key]=value
				end
			end
		end
	end
	[other_params, where_params]
end

#simplesearch(params = {}) ⇒ Object Also known as: ss 



21
22
23
24
25
26
27
28
29
30
 
# File 'lib/simple_search/active_record.rb', line 21

def simplesearch(params={})

  arel = self.scoped unless self.is_a?(::ActiveRecord::Relation)
				other_params, where_params=filtered_params(params)  # validate params
  arel = with_ss_where(arel,where_params)
  arel = with_ss_group(arel,other_params['group_by'])
  arel = with_ss_order(arel,other_params['order_by'])
  arel = with_ss_limit_offset(arel,other_params)
  arel
end

#with_ss_group(arel, group_by) ⇒ Object 



83
84
85
86
 
# File 'lib/simple_search/active_record.rb', line 83

def with_ss_group(arel,group_by)          
	arel= arel.group(group_by) if group_by
	arel
end

#with_ss_limit_offset(arel, params) ⇒ Object 



93
94
95
96
97
98
 
# File 'lib/simple_search/active_record.rb', line 93

def with_ss_limit_offset(arel,params)          
	page_by  = params['page_by'].to_i
     page_num = params['page'] ?  params['page'].to_i : ( page_by>0 ? 1 : 0 )
	arel = arel.limit(page_by).offset( (page_num-1)*page_by ) if page_by>0 && page_num>0
	arel
end

#with_ss_order(arel, order_by) ⇒ Object 



88
89
90
91
 
# File 'lib/simple_search/active_record.rb', line 88

def with_ss_order(arel,order_by)          
	arel= arel.order(order_by) if order_by
	arel
end

#with_ss_where(arel, params = {}) ⇒ Object 



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
 
# File 'lib/simple_search/active_record.rb', line 54

def with_ss_where(arel,params={})          
  params.each do |key,value|
					matches = /(.*)_([a-z]+)$/.match(key)
    all, col, op = matches.to_a
					where_col =  col =~ /\./ ? col : "#{arel.table_name}.#{col}" #if no table name, the add it
    where_value = case op.to_sym
      when :gt,:ge,:lt,:le,:eq,:ne  then value
      when :sw       then "#{value}%"  # LIKE
      when :ew       then "%#{value}"  # LIKE
      when :ct,:contains,:like then "%#{value}%" # LIKE
      when :nc,:notcontains,:notlike then "%#{value}%" # NOT LIKE
      when :is, :isnot, :it
        if    ["NULL","null"].include?(value)   then nil
        elsif ["TRUE","true"].include?(value)   then true
        elsif ["FALSE","false"].include?(value) then false
        end
    end
					if op.to_sym==:in
arel = arel.where("#{where_col}"=>value.split(','))
					elsif [:bt, :between].include? op.to_sym
      first,second = value.split('..')
arel = arel.where("#{where_col}"=>Range.new(first,second))
					else
arel = arel.where("#{where_col} #{SimpleSearch::OP_MAP[op.to_sym]} ?", where_value)
					end
  end
  arel
end