Sha256: 8b37546bb0ea51da63581ab5b4c079e1bc637e54656661de03521ec4b4e6105a
Contents?: true
Size: 1.32 KB
Versions: 40
Compression:
Stored size: 1.32 KB
Contents
class UserCheckoutStat < ActiveRecord::Base
include CalculateStat
default_scope :order => 'id DESC'
scope :not_calculated, where(:state => 'pending')
has_many :checkout_stat_has_users
has_many :users, :through => :checkout_stat_has_users
state_machine :initial => :pending do
before_transition :pending => :completed, :do => :calculate_count
event :calculate do
transition :pending => :completed
end
end
def self.per_page
10
end
def calculate_count
self.started_at = Time.zone.now
User.find_each do |user|
daily_count = user.checkouts.completed(self.start_date, self.end_date).size
if daily_count > 0
self.users << user
sql = ['UPDATE checkout_stat_has_users SET checkouts_count = ? WHERE user_checkout_stat_id = ? AND user_id = ?', daily_count, self.id, user.id]
ActiveRecord::Base.connection.execute(
self.class.send(:sanitize_sql_array, sql)
)
end
end
self.completed_at = Time.zone.now
end
end
# == Schema Information
#
# Table name: user_checkout_stats
#
# id :integer not null, primary key
# start_date :datetime
# end_date :datetime
# note :text
# state :string(255)
# created_at :datetime
# updated_at :datetime
# started_at :datetime
# completed_at :datetime
#
Version data entries
40 entries across 40 versions & 1 rubygems