Class: GenerateDeliveryMenuWorker

Inherits:
ApplicationWorker show all
Defined in:
app/workers/generate_delivery_menu_worker.rb

Instance Method Summary collapse

Methods inherited from ApplicationWorker

unlimited_retry

Instance Method Details

#perform(sql, emails, format) ⇒ Object 



3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
# File 'app/workers/generate_delivery_menu_worker.rb', line 3

def perform(sql, emails, format)
  emails = Array.wrap(emails)
  csv = nil
  reservations = Reservation.find_by_sql(sql)
  case format.to_sym
  when :csv
    csv = reservations_to_csv(reservations)
  else
    raise NotImplementedError
  end

  file_path = Rails.root.join("tmp/#{Time.zone.now}-#{rand(1000)}.csv")
  File.open(file_path, 'w') do |f|
    f.write csv
    f.close
  end
  attachment = Attachment.create! excel: open(file_path)
  StaffMailer.delivery_csv(emails, attachment.id).deliver_later!
end

#reservations_to_csv(reservations) ⇒ Object 



23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
 
# File 'app/workers/generate_delivery_menu_worker.rb', line 23

def reservations_to_csv(reservations)
  CSV.generate(headers: true) do |csv|
    csv << %w[tableno menuid menuname Quantity Price bookingid customername Phone ordTime
              ordDate ordStatus Section]
    reservations.each do |r|
      package_data = r.package['package_data'].presence || []
      package_data.each do |data|
        package = data['type'].constantize.fetch(data['id'])
        amount = HhMoney.new(data['price_cents'], data['price_currency']).amount.to_f

        csv << [
          r.table,
          package.fetch_package_attr.custom_menu_id,
          package.name,
          1,
          amount,
          r.id,
          r.name,
          r.phone,
          r.start_time_format,
          r.date.strftime('%m/%d/%Y'),
          r.service_type_humanize,
          'Package'
        ]
      end
      r.menu_sections.includes(package_menu_section: :translations,
                               menus: { package_menu: :translations }).find_each do |section|
        section.menus.find_each do |m|
          m.quantity.to_i.times do
            csv << [
              r.table,
              m.package_menu.custom_menu_id,
              m.package_menu.name,
              1,
              m.package_menu.price.amount.to_f,
              r.id,
              r.name,
              r.phone,
              r.start_time_format,
              r.date.strftime('%m/%d/%Y'),
              r.service_type_humanize,
              section.package_menu_section.name
            ]
          end
        end
      end
    end
  end
end