# frozen_string_literal: true
require "forwardable"
class CustomerPlan
extend Forwardable
attr_reader :expires_at
def_delegator :@plan, :name, :plan_name
def_delegators :@plan, :currency, :merchant_account
def initialize(customer_id, plan: nil, expires_at: Time.now)
@customer_id = customer_id
@plan = plan || OpenStruct.new
@expires_at = expires_at
end
def active?
plan_name && @expires_at > Time.now
end
def bill_plan
EM.promise_fiber do
DB.transaction do
charge_for_plan
add_one_month_to_current_plan unless activate_plan_starting_now
end
end
end
def activate_plan_starting_now
DB.exec(<<~SQL, [@customer_id, plan_name]).cmd_tuples.positive?
INSERT INTO plan_log
(customer_id, plan_name, date_range)
VALUES ($1, $2, tsrange(LOCALTIMESTAMP, LOCALTIMESTAMP + '1 month'))
ON CONFLICT DO NOTHING
SQL
end
protected
def charge_for_plan
params = [
@customer_id,
"#{@customer_id}-bill-#{plan_name}-at-#{Time.now.to_i}",
-@plan.monthly_price
]
DB.exec(<<~SQL, params)
INSERT INTO transactions
(customer_id, transaction_id, created_at, amount)
VALUES ($1, $2, LOCALTIMESTAMP, $3)
SQL
end
def add_one_month_to_current_plan
DB.exec(<<~SQL, [@customer_id])
UPDATE plan_log SET date_range=range_merge(
date_range,
tsrange(
LOCALTIMESTAMP,
GREATEST(upper(date_range), LOCALTIMESTAMP) + '1 month'
)
)
WHERE
customer_id=$1 AND
date_range && tsrange(LOCALTIMESTAMP, LOCALTIMESTAMP + '1 month')
SQL
end
end