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
|
# File 'lib/pattern_query_helper/filtering.rb', line 3
def self.create_filters(filters, valid_columns_map=nil, symbol_prefix="")
filters ||= {}
all_conditions = []
filter_params = {}
filter_array = []
filters.each do |filter_attribute, criteria|
if valid_columns_map
raise ArgumentError.new("Invalid filter '#{filter_attribute}'") unless valid_columns_map[filter_attribute]
filter_column = valid_columns_map[filter_attribute]
else
filter_column = filter_attribute
end
criteria.each do |operator_code, criterion|
filter_symbol = "#{symbol_prefix}#{filter_attribute}_#{operator_code}"
case operator_code
when "gte"
operator = ">="
when "lte"
operator = "<="
when "gt"
operator = ">"
when "lt"
operator = "<"
when "eql"
operator = "="
when "noteql"
operator = "!="
when "like"
modified_filter_column = "lower(#{filter_column})"
operator = "like"
criterion.downcase!
when "in"
operator = "in (:#{filter_symbol})"
if criterion.scan(/[^\d|,|\s]/).any?
modified_filter_column = "lower(#{filter_column})"
end
criterion = criterion.downcase.split(",")
filter_symbol_already_embedded = true
when "notin"
operator = "not in (:#{filter_symbol})"
if criterion.scan(/[^\d|,|\s]/).any?
modified_filter_column = "lower(#{filter_column})"
end
criterion = criterion.downcase.split(",")
filter_symbol_already_embedded = true
when "null"
operator = criterion.to_s == "true" ? "is null" : "is not null"
filter_symbol = ""
else
raise ArgumentError.new("Invalid operator code '#{operator_code}' on '#{filter_attribute}' filter")
end
filter_column = modified_filter_column || filter_column
condition = "#{filter_column} #{operator}"
condition << " :#{filter_symbol}" unless filter_symbol_already_embedded or filter_symbol.blank?
all_conditions << condition
filter_params["#{filter_symbol}"] = criterion unless filter_symbol.blank?
filter_array << {
column: filter_attribute,
operator: operator,
value: criterion,
symbol: filter_symbol
}
end
end
filter_string = ""
filter_string = "where " + all_conditions.join("\n and ") unless all_conditions.empty?
{
filter_string: filter_string,
filter_params: filter_params,
filter_array: filter_array
}
end
|