Contents

module BestBoy
  class MonthReport < ActiveRecord::Base

    include BestBoy::ObeysTestMode

    # db configuration
    #
    #

    self.table_name = "best_boy_month_reports"

    # associations
    #
    #

    belongs_to :owner, polymorphic: true
    has_many :day_reports

    # validations
    #
    #

    validates :owner_type, :event, presence: true

    # scopes
    #
    #

    scope :created_on, ->(date)                 { where(created_at: date.beginning_of_day..date.end_of_day) }
    scope :between,    ->(start_date, end_date) { where(created_at: start_date.beginning_of_day..end_date.end_of_day) }

    # class methods
    #
    #

    def self.current_for(date, owner, type, source = nil)
      self.for(owner, type, source).between(date.beginning_of_month, date)
    end

    def self.current_or_create_for(owner, type, source = nil)
      month_report = self.current_for(Time.zone.now, owner, type, source).last
      month_report.present? ? month_report : self.create_for(owner, type, source)
    end

    def self.create_for(owner, type, source = nil)
      month_report = BestBoy::MonthReport.new
      month_report.owner_type   = owner.to_s
      month_report.event        = type
      month_report.event_source = source
      month_report.save ? month_report : nil
    end

    def self.for(owner, type, source = nil)
      self.where(owner_type: owner, event: type, event_source: source)
    end

    def self.monthly_occurrences_for(owner, type, source = nil, date)
      self.for(owner, type, source).between(date.beginning_of_month, date.end_of_month).sum(:occurrences)
    end

    def self.yearly_occurrences_for(owner, type, source = nil, date)
      self.for(owner, type, source).between(date.beginning_of_year, date).sum(:occurrences)
    end

    def self.overall_occurrences_for(owner, type, source = nil)
      self.for(owner, type, source).sum(:occurrences)
    end
  end
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
best_boy-2.2.0	lib/best_boy/models/active_record/best_boy/month_report.rb
best_boy-2.1.4	lib/best_boy/models/active_record/best_boy/month_report.rb
best_boy-2.1.3	lib/best_boy/models/active_record/best_boy/month_report.rb
best_boy-2.1.2	lib/best_boy/models/active_record/best_boy/month_report.rb
best_boy-2.1.1	lib/best_boy/models/active_record/best_boy/month_report.rb
best_boy-2.1.0	lib/best_boy/models/active_record/best_boy/month_report.rb