销售统计

gistfile1.rb

user    = User.all[1]
date    = '2012-11-11'.to_date
range   = date.beginning_of_day..date.end_of_day
trades  = user.trades.where(created: range).sales.sold.norefund
trades  = trades.only(:payment, :num)
payment = 0
num     = 0
nulls   = []
trades.each do |trade|
  if trade.payment && trade.num
    payment += trade.payment
    num += trade.num
  else
    nulls << trade._id
  end
end
Trade.in(_id: nulls).delete_all