Contents

require 'active_reporter/dimension/base'

module ActiveReporter
  module Dimension
    class Category < Base
      def filter(relation)
        values = filter_values
        query = "#{expression} IN (?)"
        query = "#{expression} IS NULL OR #{query}" if values.include?(nil)
        relation.where(query, values.compact)
      end

      def group(relation)
        order relation.select("#{expression} AS #{sql_value_name}").group(sql_value_name)
      end

      def group_values
        return filter_values if filtering?

        i = report.groupers.index(self)
        report.raw_data.keys.map { |x| x[i] }.uniq
      end

      def all_values
        relate(report.base_relation).pluck("DISTINCT #{expression}").map(&method(:sanitize_sql_value))
      end
    end
  end
end

Version data entries

10 entries across 10 versions & 1 rubygems

Version	Path
active_reporter-0.6.3	lib/active_reporter/dimension/category.rb
active_reporter-0.6.2	lib/active_reporter/dimension/category.rb
active_reporter-0.6.1	lib/active_reporter/dimension/category.rb
active_reporter-0.6.0	lib/active_reporter/dimension/category.rb
active_reporter-0.5.13	lib/active_reporter/dimension/category.rb
active_reporter-0.5.12	lib/active_reporter/dimension/category.rb
active_reporter-0.5.11	lib/active_reporter/dimension/category.rb
active_reporter-0.5.10	lib/active_reporter/dimension/category.rb
active_reporter-0.5.9	lib/active_reporter/dimension/category.rb
active_reporter-0.5.8	lib/active_reporter/dimension/category.rb