def upgrade_to_202006():
"""
Upgrade operations to 2020.06
"""
from openstudio.os_customer_subscription import CustomerSubscription
###
# Set default value for CancellationPeriod in school subscriptions
###
query = (db.school_subscriptions.CancellationPeriod == None)
db(query).update(
CancellationPeriod = 1,
CancellationPeriodUnit = "month"
)
###
# Set default value for MinDuration in school subscriptions
###
query = (db.school_subscriptions.MinDuration == None)
db(query).update(
MinDuration=1,
)
###
# Set default value for MinEnddate in customer subscriptions (when not set)
###
query = (db.customers_subscriptions.MinEnddate == None)
rows = db(query).select(db.customers_subscriptions.id)
for row in rows:
cs = CustomerSubscription(row.id)
cs.set_min_enddate()
def subscription_buy_now():
"""
Get a subscription
"""
ssuID = request.vars['ssuID']
# init mollie
mollie = Client()
mollie_api_key = get_sys_property('mollie_website_profile')
mollie.set_api_key(mollie_api_key)
create_mollie_customer(auth.user.id, mollie)
# add subscription to customer
startdate = TODAY_LOCAL
shop_subscriptions_start = get_sys_property('shop_subscriptions_start')
if not shop_subscriptions_start == None:
if shop_subscriptions_start == 'next_month':
startdate = get_last_day_month(TODAY_LOCAL) + datetime.timedelta(
days=1)
csID = db.customers_subscriptions.insert(
auth_customer_id=auth.user.id,
school_subscriptions_id=ssuID,
Startdate=startdate,
payment_methods_id=
100, # important, 100 is the payment_methods_id for Mollie
)
# Add credits for the first month
cs = CustomerSubscription(csID)
cs.add_credits_month(startdate.year, startdate.month)
# clear cache to make sure it shows in the back end
cache_clear_customers_subscriptions(auth.user.id)
# Create invoice
cs = CustomerSubscription(csID)
iID = cs.create_invoice_for_month(startdate.year, startdate.month)
# Pay invoice ... SHOW ME THE MONEY!! :)
redirect(URL('invoice_pay', vars={'iID': iID}))
def task_mollie_subscription_invoices_and_payments():
"""
Create subscription invoices for subscriptions with payment method 100
Collect payment for these invoices
"""
def send_mail_failed(cuID):
"""
When a recurring payment fails, mail customer with request to pay manually
"""
os_mail = OsMail()
msgID = os_mail.render_email_template('payment_recurring_failed')
os_mail.send_and_archive(msgID, cuID)
from openstudio.os_customer import Customer
# hostname
sys_hostname = get_sys_property('sys_hostname')
# set up Mollie
mollie = Client()
mollie_api_key = get_sys_property('mollie_website_profile')
mollie.set_api_key(mollie_api_key)
# set dates
today = datetime.date.today()
firstdaythismonth = datetime.date(today.year, today.month, 1)
lastdaythismonth = get_last_day_month(firstdaythismonth)
# call some function to do stuff
# find all active subscriptions with payment method 100 (Mollie)
query = (db.customers_subscriptions.payment_methods_id == 100) & \
(db.customers_subscriptions.Startdate <= lastdaythismonth) & \
((db.customers_subscriptions.Enddate >= firstdaythismonth) |
(db.customers_subscriptions.Enddate == None))
rows = db(query).select(db.customers_subscriptions.ALL)
success = 0
failed = 0
# create invoices
for i, row in enumerate(rows):
cs = CustomerSubscription(row.id)
# This function returns the invoice id if it already exists
iID = cs.create_invoice_for_month(TODAY_LOCAL.year, TODAY_LOCAL.month)
#print 'invoice created'
#print iID
# Do we have an invoice?
if not iID:
continue
invoice = Invoice(iID)
# Only do something if the invoice status is sent
if not invoice.invoice.Status == 'sent':
continue
# We're good, continue processing
invoice_amounts = invoice.get_amounts()
#print invoice.invoice.InvoiceID
description = invoice.invoice.Description + ' - ' + invoice.invoice.InvoiceID
db.commit()
#create recurring payments using mandates
#subscription invoice
customer = Customer(row.auth_customer_id)
mollie_customer_id = customer.row.mollie_customer_id
mandates = customer.get_mollie_mandates()
valid_mandate = False
# set default recurring type, change to recurring if a valid mandate is found.
if mandates['count'] > 0:
# background payment
for mandate in mandates['_embedded']['mandates']:
if mandate['status'] == 'valid':
valid_mandate = True
break
if valid_mandate:
# Create recurring payment
try:
webhook_url = URL('mollie',
'webhook',
scheme='https',
host=sys_hostname)
payment = mollie.payments.create({
'amount': {
'currency': CURRENCY,
'value': str(invoice_amounts.TotalPriceVAT)
},
'customerId': mollie_customer_id,
'sequenceType': 'recurring', # important
'description': description,
'webhookUrl': webhook_url,
'metadata': {
'invoice_id': invoice.invoice.id,
'customers_orders_id':
'invoice' # This lets the webhook function know it's dealing with an invoice
}
})
# link invoice to mollie_payment_id
db.invoices_mollie_payment_ids.insert(
invoices_id=invoice.invoice.id,
mollie_payment_id=payment['id'],
RecurringType='recurring',
WebhookURL=webhook_url)
success += 1
except MollieError as e:
print(e)
# send mail to ask customer to pay manually
send_mail_failed(cs.auth_customer_id)
failed += 1
# return error
# return 'API call failed: ' + e.message
else:
# send mail to ask customer to pay manually
send_mail_failed(cs.auth_customer_id)
failed += 1
# For scheduled tasks, db has to be committed manually
db.commit()
return T("Payments collected") + ': ' + str(success) + '<br>' + \
T("Payments failed to collect") + ': ' + str(failed)