催付

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, status: 'WAIT_BUYER_PAY')
CSV.open("#{date.to_s}-trades.csv", "wb:GB18030", col_sep: ',') do |csv|
  trades.each do |trade|
    row = [
      trade.tid,
      trade.payment,
      trade.buyer_nick,
      trade.receiver_name,
      trade.receiver_mobile,
      trade.receiver_city,
    ]
    trade.orders.each do |order|
    row + [
        order.num_iid,
        order.num,
        order.outer_iid,
        order.title
      ]
    end
    csv << row
  end
end