created_at_scopes.rb

module Concerns
  module CreatedAtScopes
    extend ActiveSupport::Concern

    included do
      %w(created_at updated_at).each do |prop|
        verb = prop.gsub('_at', '')

        scope "#{verb}_last_h",       lambda { where("#{prop} >=  ?", (Time.now-1.hour).to_s(:db)) }
        scope "#{verb}_last_6h",      lambda { where("#{prop} >=  ?", (Time.now-6.hour).to_s(:db)) }
        scope "#{verb}_today",        lambda { where("DATE(#{prop}) =  ?", Date.today.to_s(:db)) }
        scope "#{verb}_last7d",       lambda { where("DATE(#{prop}) >= ?", (Date.today-7).to_s(:db)) }
        scope "#{verb}_last30d",      lambda { where("DATE(#{prop}) >= ?", (Date.today-30).to_s(:db)) }
        scope "#{verb}_this_month",   lambda { where("DATE(#{prop}) >= ?", Date.today.beginning_of_month.to_s(:db)) }
        scope "#{verb}_last_6m",      lambda { where("DATE(#{prop}) >= ?", (Date.today - 6.months).to_s(:db)) }
      end
    end
  end
end