Contents

require 'active_record'

module Reparty
  class Report
    class ActiveRecord < Report
      @@color_index = 0
      attr_reader :model, :operation, :field

      def initialize(*args, &block)
        super(args.shift, args.shift)

        if args.first.is_a?(Symbol)
          @model = Kernel.const_get(args.first.to_s.capitalize)
        elsif args.first.is_a?(::ActiveRecord::Relation)
          @model = args.first
        else
          raise "Report::ActiveRecord: model undefined"
        end

        @operation = args.fetch(1, :count)
        @field = :created_at

        if args.last.is_a?(Hash)
          @field = args.last.fetch(:field, @field)
        end

        @color = "#85bdad"
      end

      def attach(attachments)
        @graph = @operation == :total ? build_daily_area_graph : build_daily_bar_graph

        @graph.data(@model.to_s.pluralize, daily_dataset, @graph.colors[@@color_index])
        @@color_index = (@@color_index + 1) % @graph.colors.length

        attachments.inline["#{self.hash}.png"] = @graph.to_blob
      end

      def daily_dataset
        if @operation == :total
          6.downto(0).map { |x| @model.where("#{@field.to_s} < ?", DateTime.now.utc.at_midnight-x).send(:count, @field) }
        else
          7.downto(1).map { |x| @model.where("DATE(#{@field.to_s}) = ?", DateTime.now.utc.to_date-x).send(@operation, @field) }
        end
      end

      def yesterday
        op = @operation == :total ? :count : @operation
        @model.where("DATE(#{@field.to_s}) = ?", DateTime.now.utc.to_date-1).send(op, @field)
      end

      def total
        op = @operation == :total ? :count : @operation
        @model.send(op, @field)
      end
    end
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
reparty-0.5.2	lib/reparty/report/active_record.rb
reparty-0.5.1	lib/reparty/report/active_record.rb
reparty-0.5.0	lib/reparty/report/active_record.rb