Class: ForestLiana::OperatorValueParser

Inherits:
Object
  • Object
show all
Defined in:
app/services/forest_liana/operator_value_parser.rb

Class Method Summary collapse

Class Method Details

.add_where(query, field, operator, value) ⇒ Object 



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
 
# File 'app/services/forest_liana/operator_value_parser.rb', line 32

def self.add_where(query, field, operator, value)
  case value
  when 'yesterday'
    range = 1.day.ago.beginning_of_day..1.day.ago.end_of_day
    query = query.where(created_at: range)
  when 'lastWeek'
    range = 1.week.ago.beginning_of_week..1.week.ago.end_of_week
    query = query.where(created_at: range)
  when 'last2Weeks'
    range = 2.week.ago.beginning_of_week..1.week.ago.end_of_week
    query = query.where(created_at: range)
  when 'lastMonth'
    range = 1.month.ago.beginning_of_month..1.month.ago.end_of_month
    query = query.where(created_at: range)
  when 'last3Months'
    range = 3.month.ago.beginning_of_month..1.month.ago.end_of_month
    query = query.where(created_at: range)
  when 'lastYear'
    range = 1.year.ago.beginning_of_year..1.year.ago.end_of_year
    query = query.where(created_at: range)
  else
    where = "#{field} #{operator}"
    where += " '#{value}'" if value
    query = query.where(where)
  end
end

.parse(value) ⇒ Object 



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
 
# File 'app/services/forest_liana/operator_value_parser.rb', line 4

def self.parse(value)
  operator = nil

  if value.first == '!'
    operator = '!='
    value.slice!(0)
  elsif value.first == '>'
    operator = '>'
    value.slice!(0)
  elsif value.first == '<'
    operator = '<'
    value.slice!(0)
  elsif value.include?('*')
    operator = 'ILIKE'
    value.gsub!('*', '%')
  elsif value === '$present'
    operator = 'IS NOT NULL'
    value = nil
  elsif value === '$blank'
    operator = 'IS NULL'
    value = nil
  else
    operator = '='
  end

  [operator, value]
end