Bearbeitungszeiten Bücher August 2013

bearbeitungszeiten.rb

def bearbeitungszeiten(monat = Date.today.month, location = Tempfile.new('Bearbeitungszeiten'))
  monat = monat.to_i
  ois = OrderItem.where(:created_at => Date.parse("2013-#{monat}-01")..Date.parse("2013-#{monat + 1}-01"))
  CSV.open(location, "w", {:col_sep => ";"}) do |csv|
    ois.each do |oi|
      t0 = OrderItemStateTransition.where(:order_item_id => oi.id, :to => 'new').first.created_at.to_date
      delivered = OrderItemStateTransition.where(:order_item_id => oi.id, :to => 'to_delivery').last
      delivered.nil? ? t1 = Date.today : t1 = delivered.created_at.to_date
      csv << [oi.code, t0.to_s, t1.to_s, (t1 - t0).to_i.to_s]
    end
  end
  puts "Neuen Tab aufmachen (Ctrl + Shift + t), dann folgenden Befehl reinkopieren:"
  puts "scp [email protected]:#{location.path} ."
end