auto_matty.rb

require 'sinatra'
require 'json'
require 'google_drive'
require 'date'

get '/' do
  "Hello World, I'm Otto Matty"
end

post '/fulfilled' do
	data = JSON.parse request.body.read

	id = data['id']
	date = DateTime.iso8601(data['created_at'])
	total_price = "$#{data["total_price"]}"
	first_name = data['customer']['first_name']
	last_name = data['customer']['last_name']
	email = data['customer']['email']


	Thread.new {

		file = open("nicknames.txt")
		nicknames = file.read.split(/\n/)
		file.close

		prng = Random.new
		nickname = nicknames[prng.rand(nicknames.length) - 1]

		nickname = "I PROmise to PaSS" if last_name.upcase == "ORMSBY"
		nickname = "Evan Nicks" if last_name.upcase == "EVANS"
		nickname = "🌭" if last_name.upcase == "BILLARD"

		envConfig = ENV['DRIVE']

		io = envConfig != nil ? StringIO.new(envConfig) : "AutoMatty-fe567505bfbf.json"

		session = GoogleDrive::Session.from_service_account_key(io)
		sheet = session.spreadsheet_by_url('https://docs.google.com/spreadsheets/d/1q1haSv60cbKH_vPuZ9Iz82glrsF3jGZKVFwIc2kHLPw/edit').worksheets[0]

		if new_order(sheet, id)
			line_items = data['line_items']
			line_items.each do |item|
				row = sheet.num_rows + 1
				sheet.insert_rows(row, 1)
				sheet[row, 1] = item["title"]
				sheet[row, 2] = total_price
				sheet[row, 3] = "#{first_name} \"#{nickname}\" #{last_name}"
				sheet[row, 4] = email
				sheet[row, 5] = date.strftime("%b %e, %l:%M %p")
				sheet[row, 6] = id
			end
			sheet.save
		end
	}

	"Thanks Shopify 🙌"
end

def new_order(sheet, id)
	# sheets api is weird. Array is 1 based when using the sheet, but 0 based when using sheet.rows.
	# so using r[5] to read ID here, even though it's r[6] when setting
	sheet.rows.select { |r| r[5].to_s == id.to_s }.empty?
end