def test_class_cancel_confirmation_cannot_be_cancelled(client, web2py):
"""
Is the message showing notifying the customer that the class can't be cancelled anymore
"""
setup_profile_tests(web2py)
populate_classes(web2py)
d = datetime.date.today()
next_monday = next_weekday(d, 0)
clattID = web2py.db.classes_attendance.insert(classes_id=1,
ClassDate=next_monday,
auth_customer_id=300,
AttendanceType=1)
# Allow cancellation 24 hours or more in advance
web2py.db.sys_properties.insert(Property='shop_classes_cancellation_limit',
PropertyValue='744')
web2py.db.commit()
url = '/profile/class_cancel_confirm?clattID=' + str(clattID)
client.get(url)
assert client.status == 200
assert "We're sorry to inform" in client.text
def test_subscription_cancel_not_enabled(client, web2py):
"""
Is the "can cancel from date" correctly calculated when setting the period to calendar months
"""
setup_profile_tests(web2py)
populate_school_subscriptions(web2py)
url = '/default/user/login'
client.get(url)
assert client.status == 200
csID = web2py.db.customers_subscriptions.insert(
auth_customer_id = 300,
school_subscriptions_id = 1,
Startdate = '2014-01-01',
MinEnddate = '2999-12-31',
payment_methods_id = 1
)
web2py.db.commit()
url = '/profile/subscription_cancel?csID=%s' % csID
client.get(url)
assert client.status == 200
assert "When would you like to end this subscription?".lower() not in client.text.lower()
def test_subscription_buy_now_start_first_day_of_next_month(client, web2py):
"""
Can a subscription be bought
"""
import calendar
setup_profile_tests(web2py)
populate_school_subscriptions(web2py)
web2py.db.sys_properties.insert(
Property='mollie_website_profile',
PropertyValue='test_kBdWS2sfs2k9HcSCfx7cQkCbc3f5VQ' # Mollie test key
)
web2py.db.sys_properties.insert(
Property='shop_subscriptions_start',
PropertyValue='next_month'
)
web2py.db.commit()
url = '/mollie/subscription_buy_now?ssuID=1'
client.get(url)
assert client.status == 200
today = datetime.date.today()
first_next_month = datetime.date(today.year,
today.month,
calendar.monthrange(today.year,today.month)[1]) + datetime.timedelta(days=1)
cs = web2py.db.customers_subscriptions(1)
assert cs.auth_customer_id == 300
assert cs.Startdate == first_next_month
assert cs.school_subscriptions_id == 1
def test_enrollments(client, web2py):
"""
Are class enrollments listed correctly?
"""
setup_profile_tests(web2py)
# get the url, for some reason the customers_subscriptions table is empty if we don't get this first
url = '/profile/index'
client.get(url)
assert client.status == 200
populate_classes(web2py)
web2py.db.classes_reservation.insert(
classes_id=1,
auth_customer_id=300,
Startdate='2014-01-01',
)
web2py.db.commit()
url = '/profile/enrollments'
client.get(url)
assert client.status == 200
assert '2014-01-01' in client.text
assert 'End enrollment' in client.text # Check end link display
def test_deliver(client, web2py):
"""
Are orders delivered and unpaid invoices created correctly?
"""
url = '/user/login'
client.get(url)
assert client.status == 200
setup_profile_tests(web2py)
populate_customers_orders(web2py)
populate_customers_orders_items(web2py)
url = '/orders/deliver?coID=2'
client.get(url)
assert client.status == 200
assert 'Delivered order' in client.text
##
# Check whether order status was changed
##
order = web2py.db.customers_orders(2)
assert order.Status == 'delivered'
##
# Check whether an invoice was created
##
assert web2py.db(web2py.db.invoices).count() == 1
# print web2py.db().select(web2py.db.customers_orders.ALL)
# print web2py.db().select(web2py.db.customers_orders_items.ALL)
# print web2py.db().select(web2py.db.invoices.ALL)
# print web2py.db().select(web2py.db.invoices_items.ALL)
def test_enrollment_end(client, web2py):
"""
Are class enrollments listed correctly?
"""
setup_profile_tests(web2py)
# get the url, for some reason the customers_subscriptions table is empty if we don't get this first
url = '/profile/index'
client.get(url)
assert client.status == 200
populate_classes(web2py)
clrID = web2py.db.classes_reservation.insert(
classes_id=1,
auth_customer_id=300,
Startdate='2014-01-01',
)
web2py.db.commit()
url = '/profile/enrollment_end/' + str(clrID)
client.get(url)
assert client.status == 200
data = {'id': clrID, 'Enddate': '2017-12-31'}
url = '/profile/enrollment_end/' + str(clrID)
client.post(url, data=data)
assert client.status == 200
clr = web2py.db.classes_reservation(clrID)
assert clr.Enddate == datetime.date(2017, 12, 31)
def test_membership_buy_now(client, web2py):
"""
Is the membership buy now function working?
"""
# Get random url to init env
url = '/default/user/login'
client.get(url)
assert client.status == 200
setup_profile_tests(web2py)
populate_school_memberships(web2py)
web2py.db.sys_properties.insert(
Property='mollie_website_profile',
PropertyValue=mollie_key # Mollie test key
)
web2py.db.commit()
url = '/mollie/membership_buy_now?smID=1'
client.get(url)
assert client.status == 200
cm = web2py.db.customers_memberships(1)
assert cm.auth_customer_id == 300
assert cm.Startdate == datetime.date.today()
assert cm.school_memberships_id == 1
assert cm.DateID == datetime.date.today().strftime('%Y%m%d') + '00001'
assert not cm.Barcode == None
def test_invoices(client, web2py):
"""
Is the list of invoices showing?
"""
setup_profile_tests(web2py)
url = '/profile/invoices'
client.get(url)
assert client.status == 200
populate_invoices(web2py)
client.get(url)
assert client.status == 200
invoice = web2py.db.invoices(2)
assert invoice.InvoiceID in client.text
assert str(invoice.DateCreated) in client.text
assert invoice.Status in client.text.lower()
inv_amounts = web2py.db.invoices_amounts(2)
assert format(inv_amounts.TotalPriceVAT, '.2f') in client.text
# check payment button
assert 'Pay now' in client.text
assert '/mollie/invoice_pay?iID=2' in client.text
def test_index_memberships(client, web2py):
"""
Are current memberships on the index page?
"""
setup_profile_tests(web2py)
url = '/profile/index'
client.get(url)
assert client.status == 200
populate_customers_with_memberships(web2py)
cm = web2py.db.customers_memberships(1)
cm.auth_customer_id = 300
cm.Enddate = None
cm.update_record()
web2py.db.commit()
client.get(url)
assert client.status == 200
sm = web2py.db.school_memberships(1)
assert sm.Name in client.text
assert str(cm.Startdate) in client.text
def test_class_cancel(client, web2py):
"""
Can a customer cancel a class?
"""
setup_profile_tests(web2py)
populate_classes(web2py)
d = datetime.date.today()
next_monday = next_weekday(d, 0)
clattID = web2py.db.classes_attendance.insert(classes_id=1,
ClassDate=next_monday,
auth_customer_id=300,
AttendanceType=1)
# Allow cancellation 1 hours or more in advance
web2py.db.sys_properties.insert(Property='shop_classes_cancellation_limit',
PropertyValue='1')
web2py.db.commit()
url = '/profile/class_cancel?clattID=' + str(clattID)
client.get(url)
assert client.status == 200
clatt = web2py.db.classes_attendance(clattID)
assert clatt.BookingStatus == 'cancelled'
def test_classcard_info(client, web2py):
"""
Is the classcard info page showing correctly?
"""
setup_profile_tests(web2py)
prepare_classes(web2py)
ccdID = web2py.db.customers_classcards.insert(auth_customer_id=300,
school_classcards_id=1,
Startdate='2014-01-01',
Enddate='2999-12-31')
web2py.db.classes_school_classcards_groups.insert(
classes_id=1,
school_classcards_groups_id=1,
ShopBook=True,
Attend=True)
web2py.db.commit()
url = '/profile/classcard_info?ccdID=' + str(ccdID)
client.get(url)
assert client.status == 200
assert client.text.count(
'<span class="text-green"><i class="fa fa-check">') == 2
def test_subscriptions_display_credits_unlimited(client, web2py):
"""
Is the list of subscriptions showing?
"""
# get the url, for some reason the customers_subscriptions table is empty if not when asserting
url = '/profile/subscriptions'
client.get(url)
assert client.status == 200
setup_profile_tests(web2py)
populate_customers_with_subscriptions(web2py, credits=True)
ssu = web2py.db.school_subscriptions(1)
ssu.Unlimited = True
ssu.update_record()
cs = web2py.db.customers_subscriptions(1)
cs.auth_customer_id = 300
cs.update_record()
web2py.db.commit()
url = '/profile/subscriptions'
client.get(url)
assert client.status == 200
ss = web2py.db.school_subscriptions(1)
assert ss.Name in client.text
assert str(cs.Startdate) in client.text
assert 'Unlimited' in client.text # check if number of credits is displayed
def test_class_cancel_confirmation(client, web2py):
"""
Is the cancel conformation page showing?
"""
setup_profile_tests(web2py)
populate_classes(web2py)
d = datetime.date.today()
next_next_monday = next_weekday(d, 0) + datetime.timedelta(days=7)
clattID = web2py.db.classes_attendance.insert(classes_id=1,
ClassDate=next_next_monday,
auth_customer_id=300,
AttendanceType=1)
# Allow cancellation 24 hours or more in advance
web2py.db.sys_properties.insert(Property='shop_classes_cancellation_limit',
PropertyValue='24')
web2py.db.commit()
url = '/profile/class_cancel_confirm?clattID=' + str(clattID)
client.get(url)
assert client.status == 200
assert "Are you sure you want to cancel" in client.text
def test_subscription_info(client, web2py):
"""
Is the subscription info page showing correctly?
"""
setup_profile_tests(web2py)
url = '/default/user/login'
client.get(url)
assert client.status == 200
prepare_classes(web2py)
csID = web2py.db.customers_subscriptions.insert(auth_customer_id=300,
school_subscriptions_id=1,
Startdate='2014-01-01',
Enddate='2999-12-31',
payment_methods_id=1)
web2py.db.classes_school_subscriptions_groups.insert(
classes_id=1,
school_subscriptions_groups_id=1,
Enroll=True,
ShopBook=True,
Attend=True)
web2py.db.commit()
url = '/profile/subscription_info?csID=' + str(csID)
client.get(url)
assert client.status == 200
assert client.text.count(
'<span class="text-green"><i class="fa fa-check">') == 3
def test_subscription_cancel_months_min_enddate_used(client, web2py):
"""
Is the "can cancel from date" correctly calculated when setting the period to months
"""
setup_profile_tests(web2py)
populate_school_subscriptions(web2py)
url = '/default/user/login'
client.get(url)
assert client.status == 200
web2py.db.sys_properties.insert(
Property="shop_customers_can_cancel_subscriptions",
PropertyValue="on"
)
csID = web2py.db.customers_subscriptions.insert(
auth_customer_id = 300,
school_subscriptions_id = 1,
Startdate = '2014-01-01',
MinEnddate = '2999-12-31',
payment_methods_id = 1
)
web2py.db.commit()
url = '/profile/subscription_cancel?csID=' + str(csID)
client.get(url)
assert client.status == 200
assert "2999-12-31" in client.text
def test_classes_show_cancel_link(client, web2py):
"""
Is the cancel link shown when it should?
"""
setup_profile_tests(web2py)
populate_classes(web2py)
d = datetime.date.today()
next_next_monday = next_weekday(d, 0) + datetime.timedelta(days=7)
clattID = web2py.db.classes_attendance.insert(classes_id=1,
ClassDate=next_next_monday,
auth_customer_id=300,
AttendanceType=1)
# Allow cancellation 24 hours or more in advance
web2py.db.sys_properties.insert(Property='shop_classes_cancellation_limit',
PropertyValue='24')
web2py.db.commit()
# check profile/classes
url = '/profile/classes'
client.get(url)
assert client.status == 200
assert "/profile/class_cancel_confirm" in client.text
def test_events(client, web2py):
"""
Is the list of workshops showing?
"""
setup_profile_tests(web2py)
url = '/default/user/login'
client.get(url)
assert client.status == 200
populate_workshops_products_customers(web2py)
wspc = web2py.db.workshops_products_customers(1)
wspc.auth_customer_id = 300
wspc.update_record()
web2py.db.commit()
url = '/profile/events'
client.get(url)
assert client.status == 200
# check name of workshop on page
wsp = web2py.db.workshops_products(wspc.workshops_products_id)
ws = web2py.db.workshops(wsp.workshops_id)
assert wsp.Name in client.text
assert ws.Name in client.text
assert str(ws.Startdate) in client.text
def test_subscription_unlimited_credits_profile_home(client, web2py):
"""
Check if subscription credits are displayed on the home page of a profile
"""
setup_profile_tests(web2py)
# get the url, for some reason the customers_subscriptions table is empty if not when asserting
url = '/profile/index'
client.get(url)
assert client.status == 200
populate_customers_with_subscriptions(web2py, credits=True)
ssu = web2py.db.school_subscriptions(1)
ssu.Unlimited = True
ssu.update_record()
cs = web2py.db.customers_subscriptions(1)
cs.auth_customer_id = 300
cs.update_record()
web2py.db.commit()
client.get(url)
assert client.status == 200
assert 'Unlimited' in client.text # check if number of credits is displayed
def test_staff_payments(client, web2py):
"""
Is the staff payments page showing?
"""
from populate_os_tables import populate_auth_user_teachers_payment_invoices
setup_profile_tests(web2py)
au = web2py.db.auth_user(300)
au.teacher = True
au.update_record()
web2py.db.commit()
populate_auth_user_teachers_payment_invoices(web2py)
# log out and log back in again to make the profile user a teacher
url = '/default/user/logout'
client.get(url)
assert client.status == 200
data = dict(email='*****@*****.**',
password='******',
_formname='login')
client.post('/default/user/login', data=data)
assert client.status == 200
# Check payments display
url = '/profile/staff_payments'
client.get(url)
assert client.status == 200
ic = web2py.db.invoices_customers(auth_customer_id=300)
invoice = web2py.db.invoices(ic.invoices_id)
assert invoice.InvoiceID in client.text
def test_subscription_cancel_calendar_months(client, web2py):
"""
Is the "can cancel from date" correctly calculated when setting the period to months
"""
setup_profile_tests(web2py)
populate_school_subscriptions(web2py)
populate_define_school_subscriptions_cancel_reasons(web2py)
url = '/default/user/login'
client.get(url)
assert client.status == 200
web2py.db.sys_properties.insert(
Property="shop_customers_can_cancel_subscriptions",
PropertyValue="on"
)
ssu = web2py.db.school_subscriptions(1)
ssu.CancellationPeriodUnit = 'calendar_month'
ssu.update_record()
csID = web2py.db.customers_subscriptions.insert(
auth_customer_id = 300,
school_subscriptions_id = 1,
Startdate = '2014-01-01',
MinEnddate = '2015-12-31',
payment_methods_id = 1
)
web2py.db.commit()
url = '/profile/subscription_cancel?csID=' + str(csID)
client.get(url)
assert client.status == 200
today = datetime.date.today()
can_cancel_from_date = add_months_to_date(today, 1)
# Get last day of month for calendar month check
can_cancel_from_date = get_last_day_month(can_cancel_from_date)
assert str(can_cancel_from_date) in client.text
data = {
'id': csID,
'Enddate': can_cancel_from_date,
'school_subscriptions_cancel_reasons_id': '1',
'CancelReasonNote': "Hello world"
}
client.post(url, data=data)
assert client.status == 200
cs = web2py.db.customers_subscriptions(csID)
assert cs.Enddate == can_cancel_from_date
assert cs.school_subscriptions_cancel_reasons_id == 1
assert cs.CancelReasonNote == data['CancelReasonNote']
def test_staff_payments_link_not_shown(client, web2py):
"""
The staff payments link shouldn't show
"""
setup_profile_tests(web2py)
url = '/profile/index'
client.get(url)
assert client.status == 200
assert "Payments not in client.text"
def test_me(client, web2py):
"""
Is the profile edit page showing correctly?
"""
setup_profile_tests(web2py)
url = '/profile/me'
client.get(url)
assert client.status == 200
assert "fa-user-secret" in client.text
def test_subscription_cancel_months(client, web2py):
"""
Is the "can cancel from date" correctly calculated when setting the period to months.
The end date set in the code depends on the system time. When run on a development system with a non UTC
timezone, it might fail after a certain hour of the day.
"""
setup_profile_tests(web2py)
populate_school_subscriptions(web2py)
populate_define_school_subscriptions_cancel_reasons(web2py)
url = '/default/user/login'
client.get(url)
assert client.status == 200
web2py.db.sys_properties.insert(
Property="shop_customers_can_cancel_subscriptions",
PropertyValue="on"
)
csID = web2py.db.customers_subscriptions.insert(
auth_customer_id = 300,
school_subscriptions_id = 1,
Startdate = '2014-01-01',
MinEnddate = '2015-12-31',
payment_methods_id = 1
)
web2py.db.commit()
url = '/profile/subscription_cancel?csID=' + str(csID)
client.get(url)
assert client.status == 200
today = datetime.date.today()
can_cancel_from_date = add_months_to_date(today, 1)
assert str(can_cancel_from_date) in client.text
data = {
'id': csID,
'Enddate': can_cancel_from_date,
'school_subscriptions_cancel_reasons_id': '1',
'CancelReasonNote': "Hello world"
}
client.post(url, data=data)
assert client.status == 200
cs = web2py.db.customers_subscriptions(csID)
assert cs.Enddate == can_cancel_from_date
assert cs.school_subscriptions_cancel_reasons_id == 1
assert cs.CancelReasonNote == data['CancelReasonNote']
assert "Your subscription has been cancelled".lower() in client.text.lower()
def test_orders(client, web2py):
"""
Is the list of orders showing?
"""
setup_profile_tests(web2py)
url = '/profile/orders'
client.get(url)
assert client.status == 200
populate_customers_orders(web2py)
populate_customers_orders_items(web2py)
client.get(url)
assert client.status == 200
# check all invoices link
assert 'All invoices' in client.text
order = web2py.db.customers_orders(2)
# Check display of ID
assert str(order.id) in client.text
# check display of status
assert 'Awaiting payment' in client.text
# check time
import pytz
dc = pytz.utc.localize(order.DateCreated)
tz = pytz.timezone('Europe/Amsterdam')
local_dc = dc.astimezone(tz)
assert str(
local_dc
)[:
-9] in client.text #[:-3] removes seconds, they are not displayed by default
# check items display
query = (web2py.db.customers_orders_items.customers_orders_id == 2)
rows = web2py.db(query).select(web2py.db.customers_orders_items.ALL)
for row in rows:
assert row.Description in client.text
# Check total amount
ord_amounts = web2py.db.customers_orders_amounts(2)
assert format(ord_amounts.TotalPriceVAT, '.2f') in client.text
# check cancel button display
assert 'Cancel' in client.text
assert '/profile/order_cancel?coID=2' in client.text
# check payment button
assert 'Pay now' in client.text
assert '/mollie/order_pay?coID=2' in client.text
def test_login_profile_user(client, web2py):
"""
Logs in with a user without any permissions by default
"""
setup_profile_tests(web2py)
data = dict(email='*****@*****.**',
password='******',
_formname='login')
client.post('/default/user/login', data=data)
assert client.status == 200
assert '<li class="header">Account</li>' in client.text
def test_index_announcements(client, web2py):
"""
Are the announcements shown correctly?
"""
setup_profile_tests(web2py)
populate_settings_shop_customers_profile_announcements(web2py)
url = '/profile/index'
client.get(url)
assert client.status == 200
cpa = web2py.db.customers_profile_announcements(1)
assert cpa.Title in client.text
assert cpa.Announcement in client.text
def test_me_privacy_link_not_shown(client, web2py):
"""
Is the profile edit page showing correctly?
"""
setup_profile_tests(web2py)
url = '/profile/me'
client.get(url)
assert client.status == 200
features = web2py.db.customers_profile_features(1)
features.Privacy = False
features.update_record()
web2py.db.commit()
client.get(url)
assert client.status == 200
assert "fa-user-secret" not in client.text
def test_order_cancel(client, web2py):
"""
Can we actually cancel an order?
"""
setup_profile_tests(web2py)
url = '/profile/orders'
client.get(url)
assert client.status == 200
populate_customers_orders(web2py)
populate_customers_orders_items(web2py)
url = '/profile/order_cancel?coID=2'
client.get(url)
assert client.status == 200
assert 'Orders' in client.text # Verify redirection to orders page
order = web2py.db.customers_orders(2)
assert order.Status == 'cancelled'
def test_classes(client, web2py):
"""
Is the list of classes showing?
"""
setup_profile_tests(web2py)
populate_classes(web2py)
d = datetime.date.today()
next_monday = next_weekday(d, 0)
# Insert changed location into classes_otc for next Monday
web2py.db.classes_otc.insert(
classes_id=1,
ClassDate=next_monday,
school_locations_id=2,
school_classtypes_id=2,
)
web2py.db.classes_attendance.insert(
classes_id = 1,
ClassDate = '2014-01-06',
auth_customer_id = 300,
AttendanceType = 1
)
web2py.db.commit()
url = '/profile/classes'
client.get(url)
assert client.status == 200
# check regular class listing
location = web2py.db.school_locations(1)
location_name = location.Name.split(' ')[0]
assert location_name in client.text
# check otc class listing
location = web2py.db.school_locations(1)
location_name = location.Name.split(' ')[0]
assert location_name in client.text
def test_subscription_buy_now(client, web2py):
"""
Can a subscription be bought
"""
setup_profile_tests(web2py)
populate_school_subscriptions(web2py)
web2py.db.sys_properties.insert(
Property='mollie_website_profile',
PropertyValue=mollie_key # Mollie test key
)
web2py.db.commit()
url = '/mollie/subscription_buy_now?ssuID=1'
client.get(url)
assert client.status == 200
cs = web2py.db.customers_subscriptions(1)
assert cs.auth_customer_id == 300
assert cs.Startdate == datetime.date.today()
assert cs.school_subscriptions_id == 1