Sha256: a51c27612ab3b563973f5a4e024a9b67bde1ba496c6c90770fe445cadb50071c

Contents?: true

Size: 1.68 KB

Versions: 27

Compression:

Stored size: 1.68 KB

Contents

module ForestLiana
  class OperatorValueParser

    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

    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

  end
end

Version data entries

27 entries across 27 versions & 1 rubygems

Version Path
forest_liana-1.3.6 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.3.5 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.3.4 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.3.3 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.3.2 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.3.1 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.3.0 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.2.6 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.2.5 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.2.3 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.2.2 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.2.1 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.1.35 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.1.34 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.1.33 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.1.32 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.1.31 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.1.30 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.1.29 app/services/forest_liana/operator_value_parser.rb
forest_liana-1.1.28 app/services/forest_liana/operator_value_parser.rb