#!/usr/bin/env python """ py.test test cases to test OpenStudio. These tests run based on webclient and need web2py server running. """ from gluon.contrib.populate import populate from populate_os_tables import prepare_classes from populate_os_tables import populate_customers from populate_os_tables import populate_invoices from populate_os_tables import populate_invoices_items from populate_os_tables import populate_auth_user_teachers_fixed_rate_default from populate_os_tables import populate_auth_user_teachers_fixed_rate_class_1 from populate_os_tables import populate_auth_user_teachers_travel from populate_os_tables import populate_teachers_payment_attendance_lists_school_classtypes from populate_os_tables import populate_teachers_payment_classes from populate_os_tables import populate_workshops_messages from populate_os_tables import populate_customers_with_subscriptions import datetime def test_employee_expenses_pending_page(client, web2py): """ Check pending page and if a pending claim is displayed """ from populate_os_tables import populate_employee_claims url = '/default/user/login' client.get(url) assert client.status == 200 populate_employee_claims(web2py) # Check expenses display url = '/finance/employee_expenses' client.get(url) assert client.status == 200 assert 'First Expense' in client.text def test_employee_expenses_move_claim_to_accepted(client, web2py): """Check if a claim can be moved to accepted""" from populate_os_tables import populate_employee_claims url = '/default/user/login' client.get(url) assert client.status == 200 populate_employee_claims(web2py) # Check expenses display url = '/finance/employee_expenses_accept?ecID=1' client.get(url) assert client.status == 200 assert web2py.db(web2py.db.employee_claims.Status == 'accepted').count() == 2 def test_employee_expenses_accept_all(client, web2py): """Check if a claim can be moved to accepted""" from populate_os_tables import populate_employee_claims url = '/default/user/login' client.get(url) assert client.status == 200 populate_employee_claims(web2py) # Check expenses display url = '/finance/employee_expenses_accept_all' client.get(url) assert client.status == 200 assert web2py.db(web2py.db.employee_claims.Status == 'accepted').count() == 2 def test_employee_expenses_move_claim_to_rejected(client, web2py): """Check if a claim can be moved to accepted""" from populate_os_tables import populate_employee_claims url = '/default/user/login' client.get(url) assert client.status == 200 populate_employee_claims(web2py) # Check expenses display url = '/finance/employee_expenses_reject?ecID=1' client.get(url) assert client.status == 200 assert web2py.db(web2py.db.employee_claims.Status == 'rejected').count() == 2 def test_employee_expenses_move_claim_to_pending(client, web2py): """Check if a claim can be moved to accepted""" from populate_os_tables import populate_employee_claims url = '/default/user/login' client.get(url) assert client.status == 200 populate_employee_claims(web2py) # Check expenses display url = '/finance/employee_expenses_pending?ecID=2' client.get(url) assert client.status == 200 assert web2py.db(web2py.db.employee_claims.Status == 'pending').count() == 2 def test_employee_expenses_rejected_page(client, web2py): """ Check rejected page and if a accepted claim is displayed """ from populate_os_tables import populate_employee_claims url = '/default/user/login' client.get(url) assert client.status == 200 populate_employee_claims(web2py) # Check expenses display url = '/finance/employee_expenses_rejected' client.get(url) assert client.status == 200 assert 'Rejected Expense' in client.text def test_employee_expenses_accepted_page(client, web2py): """ Check accepted page and if a accepted claim is displayed """ from populate_os_tables import populate_employee_claims url = '/default/user/login' client.get(url) assert client.status == 200 populate_employee_claims(web2py) # Check expenses display url = '/finance/employee_expenses_accepted' client.get(url) assert client.status == 200 assert 'Accepted Expense' in client.text def test_employee_expenses_process_accepted(client, web2py): """Check if a claim can be moved to accepted""" from populate_os_tables import populate_employee_claims url = '/default/user/login' client.get(url) assert client.status == 200 populate_employee_claims(web2py) # Check expenses display url = '/finance/employee_expenses_process_accepted' client.get(url) assert client.status == 200 assert web2py.db(web2py.db.employee_claims.Status == 'processed').count() == 2 assert web2py.db(web2py.db.invoices).count() >= 1 # Get first invoice with employee claim set to true and check description query = (web2py.db.invoices.EmployeeClaim == True) invoice = web2py.db(query).select().first() assert invoice.Description == 'Expenses' # Check invoice items query = (web2py.db.invoices_items_employee_claims.id > 0) rows = web2py.db(query).select(web2py.db.invoices_items_employee_claims.ALL) for i, row in enumerate(rows): claim = web2py.db.employee_claims(row.employee_claims_id) invoice_item = web2py.db.invoices_items(row.invoices_items_id) assert invoice_item.Description == claim.Description assert invoice_item.Quantity == claim.Quantity assert invoice_item.Price == claim.Amount * -1 assert invoice_item.TotalPriceVAT == (claim.Amount * -1) * claim.Quantity def test_employee_expenses_processed_page(client, web2py): """ Check proccessed page and if a processed claim is displayed """ from populate_os_tables import populate_employee_claims url = '/default/user/login' client.get(url) assert client.status == 200 populate_employee_claims(web2py) # Check expenses display url = '/finance/employee_expenses_processed' client.get(url) assert client.status == 200 assert 'Processed Expense' in client.text def test_teacher_payments_batch_set_status_sent_to_bank_add_payments(client, web2py): """ Check if payments are added to invoices when the status of a batch becomes 'sent to bank' """ url = '/finance/batch_add?export=payment&what=teacher_invoices' client.get(url) assert client.status == 200 prepare_classes(web2py) populate_auth_user_teachers_fixed_rate_default(web2py) populate_auth_user_teachers_fixed_rate_class_1(web2py) populate_auth_user_teachers_travel(web2py) ## # Create invoices ## # Find classes url = '/finance/teacher_payment_find_classes' client.get(url) assert client.status == 200 data = { 'Startdate': '2014-01-01', 'Enddate': '2014-01-31' } client.post(url, data=data) assert client.status == 200 # Verify url = '/finance/teachers_payment_classes_verify_all' client.get(url) assert client.status == 200 # Process (create invoices) url = '/finance/teachers_payment_classes_process_verified' client.get(url) # Create batch url = '/finance/batch_add?export=payment&what=teacher_payments' client.get(url) assert client.status == 200 today = datetime.date.today() data = { 'Name': 'Batch3435435', 'ColMonth': today.month, 'ColYear': today.year, 'Exdate': '2099-01-01', } client.post(url, data=data) assert client.status == 200 # check setting of status 'sent_to_bank' url = '/finance/batch_content_set_status?pbID=1&status=sent_to_bank' client.get(url) assert client.status == 200 # check if 2 payments have been added assert web2py.db(web2py.db.invoices_payments.id > 0).count() == 1 ip = web2py.db.invoices_payments(1) assert ip.payment_methods_id == 2 # check payment amounts sum = web2py.db.invoices_amounts.TotalPriceVAT.sum() invoices_amount = web2py.db().select(sum).first()[sum] sum = web2py.db.invoices_payments.Amount.sum() payments_amount = web2py.db().select(sum).first()[sum] assert invoices_amount == payments_amount def test_teacher_payments(client, web2py): """ Are teacher payment invoices listed correctly? """ url = '/default/user/login' client.get(url) assert client.status == 200 populate_customers(web2py) populate_invoices(web2py, teacher_fixed_price_invoices=True) url = '/finance/teacher_payments_invoices' client.get(url) assert client.status == 200 assert 'INV1001' in client.text def test_teacher_payment_find_classes_fixed_rate_default(client, web2py): """ Is the fixed rate applied when finding classes? """ prepare_classes(web2py) populate_auth_user_teachers_fixed_rate_default(web2py) url = '/finance/teacher_payment_find_classes' client.get(url) assert client.status == 200 data = { 'Startdate': '2014-01-01', 'Enddate': '2014-01-31' } client.post(url, data=data) assert client.status == 200 assert web2py.db(web2py.db.teachers_payment_classes).count() == 3 default_rate = web2py.db.teachers_payment_fixed_rate_default(1) tpc = web2py.db.teachers_payment_classes(1) assert tpc.ClassDate == datetime.date(2014, 1, 6) assert tpc.classes_id == 1 assert tpc.ClassRate == default_rate.ClassRate assert tpc.tax_rates_id == default_rate.tax_rates_id def test_teacher_payment_find_classes_travel_allowance(client, web2py): """ Is the fixed rate applied when finding classes? """ prepare_classes(web2py) populate_auth_user_teachers_fixed_rate_default(web2py) populate_auth_user_teachers_travel(web2py) url = '/finance/teacher_payment_find_classes' client.get(url) assert client.status == 200 data = { 'Startdate': '2014-01-01', 'Enddate': '2014-01-31' } client.post(url, data=data) assert client.status == 200 assert web2py.db(web2py.db.teachers_payment_classes).count() == 3 tpc = web2py.db.teachers_payment_classes(1) ta = web2py.db.teachers_payment_travel(1) assert tpc.TravelAllowance == ta.TravelAllowance def test_teacher_payment_find_classes_fixed_rate_class_specific(client, web2py): """ Is the fixed rate class specific rate applied when finding classes? """ prepare_classes(web2py) populate_auth_user_teachers_fixed_rate_default(web2py) populate_auth_user_teachers_fixed_rate_class_1(web2py) url = '/finance/teacher_payment_find_classes' client.get(url) assert client.status == 200 data = { 'Startdate': '2014-01-01', 'Enddate': '2014-01-31' } client.post(url, data=data) assert client.status == 200 assert web2py.db(web2py.db.teachers_payment_classes).count() == 3 class_rate = web2py.db.teachers_payment_fixed_rate_class(1) tpc = web2py.db.teachers_payment_classes(1) assert tpc.ClassDate == datetime.date(2014, 1, 6) assert tpc.classes_id == 1 assert tpc.ClassRate == class_rate.ClassRate assert tpc.tax_rates_id == class_rate.tax_rates_id def test_teacher_payment_find_classes_attendance(client, web2py): """ Is the fixed rate applied when finding classes? """ prepare_classes(web2py) populate_auth_user_teachers_fixed_rate_default(web2py) populate_teachers_payment_attendance_lists_school_classtypes(web2py) url = '/finance/teacher_payment_find_classes' client.get(url) assert client.status == 200 sprop = web2py.db.sys_properties(Property='TeacherPaymentRateType') sprop.PropertyValue = 'attendance' sprop.update_record() web2py.db.commit() data = { 'Startdate': '2014-01-01', 'Enddate': '2014-01-31' } client.post(url, data=data) assert client.status == 200 list = web2py.db.teachers_payment_attendance_lists(1) rate = web2py.db.teachers_payment_attendance_lists_rates(1) tpc = web2py.db.teachers_payment_classes(1) assert tpc.ClassDate == datetime.date(2014, 1, 6) assert tpc.classes_id == 1 assert tpc.ClassRate == rate.Rate assert tpc.tax_rates_id == list.tax_rates_id def test_teacher_payment_classes_not_verified(client, web2py): """ """ populate_teachers_payment_classes(web2py) url = '/finance/teacher_payment_classes?status=not_verified' client.get(url) assert client.status == 200 tpc = web2py.db.teachers_payment_classes(1) assert str(tpc.ClassDate) in client.text assert format(tpc.ClassRate, '.2f') in client.text def test_teacher_payment_classes_verify(client, web2py): """ """ populate_teachers_payment_classes(web2py) url = '/finance/teachers_payment_attendance_class_verify?tpcID=1' client.get(url) assert client.status == 200 query = (web2py.db.teachers_payment_classes.Status == 'verified') assert web2py.db(query).count() == 1 def test_teacher_payment_classes_unverify(client, web2py): """ """ populate_teachers_payment_classes(web2py, status='verified') url = '/finance/teachers_payment_attendance_class_unverify?tpcID=1' client.get(url) assert client.status == 200 query = (web2py.db.teachers_payment_classes.Status == 'not_verified') assert web2py.db(query).count() == 1 def test_teacher_payment_classes_verify_all(client, web2py): """ """ populate_teachers_payment_classes(web2py) query = (web2py.db.teachers_payment_classes.Status == 'not_verified') count_not_verified = web2py.db(query).count() url = '/finance/teachers_payment_classes_verify_all' client.get(url) assert client.status == 200 query = (web2py.db.teachers_payment_classes.Status == 'verified') assert web2py.db(query).count() == count_not_verified def test_teacher_payment_classes_verified(client, web2py): """ """ populate_teachers_payment_classes(web2py, status='verified') url = '/finance/teacher_payment_classes?status=verified' client.get(url) assert client.status == 200 tpc = web2py.db.teachers_payment_classes(1) assert str(tpc.ClassDate) in client.text assert format(tpc.ClassRate, '.2f') in client.text def test_teacher_payment_classes_processed(client, web2py): """ """ populate_teachers_payment_classes(web2py, status='processed') url = '/finance/teacher_payment_classes?status=processed' client.get(url) assert client.status == 200 tpc = web2py.db.teachers_payment_classes(1) assert str(tpc.ClassDate) in client.text assert format(tpc.ClassRate, '.2f') in client.text # def test_teacher_payments_generate_invoices_choose_month(client, web2py): # """ # Is the month chooser working like it should? # """ # url = '/finance/teacher_payments_generate_invoices_choose_month' # client.get(url) # assert client.status == 200 # # assert 'Create teacher credit invoices for month' in client.text # # def test_teacher_payments_generate_invoices(client, web2py): # """ # Are the credit invoices created like they should? # Check default rate # Check class specific rate # Check travel allowance # """ # prepare_classes(web2py) # populate_auth_user_teachers_fixed_rate_default(web2py) # populate_auth_user_teachers_fixed_rate_class_1(web2py) # populate_auth_user_teachers_travel(web2py) # # url = '/finance/teacher_payments_generate_invoices_choose_month' # client.get(url) # assert client.status == 200 # # today = datetime.date.today() # # data = { # 'month': today.month, # 'year': today.year # } # client.post(url, data=data) # assert client.status == 200 # # # Teacher 2 should have an item with the class specific rate # query = (web2py.db.invoices_customers.auth_customer_id == 2) # ic = web2py.db(query).select(web2py.db.invoices_customers.ALL).first() # invoice = web2py.db.invoices(ic.invoices_id) # # assert invoice.TeacherPayment == True # assert invoice.TeacherPaymentMonth == data['month'] # assert invoice.TeacherPaymentYear == data['year'] # # query = (web2py.db.invoices_items.invoices_id == ic.invoices_id) # rows = web2py.db(query).select(web2py.db.invoices_items.ALL) # item = rows[0] # # # Check travel allowance # tpfrt = web2py.db.teachers_payment_travel(1) # assert item.ProductName == 'Travel allowance' # assert item.Price == tpfrt.TravelAllowance * -1 # # # Check no travel allowance for consecutive classes # item_2 = rows[1] # item_3 = rows[2] # assert not item_2.ProductName == 'Travel allowance' # assert not item_3.ProductName == 'Travel allowance' # # # Check class_specific_rate # item_2 = rows[1] # tpfrc = web2py.db.teachers_payment_fixed_rate_class(1) # assert item_2.Price == tpfrc.ClassRate * -1 # # # # # Check invoice terms & footer # ig_1 = web2py.db.invoices_groups(100) # assert ig_1.Terms == invoice.Terms # assert ig_1.Footer == invoice.Footer # # # Teacher 3 should have an item with the default rate # query = (web2py.db.invoices_customers.auth_customer_id == 3) # ic = web2py.db(query).select(web2py.db.invoices_customers.ALL).first() # # query = (web2py.db.invoices_items.invoices_id == ic.invoices_id) # rows = web2py.db(query).select(web2py.db.invoices_items.ALL) # item = rows.first() # # # check default_specific_rate # tpfrd = web2py.db.teachers_payment_fixed_rate_default(auth_teacher_id=3) # assert item.Price == tpfrd.ClassRate * -1 # # # Don't create invoices when they already exist # client.post(url, data=data) # assert client.status == 200 # # query = (web2py.db.invoices.TeacherPayment == True) # assert web2py.db(query).count() == 2 #TODO Replace by process test # def test_add_batch_teacher_payment(client, web2py): # """ # Can we add a batch for teacher payments? # """ # prepare_classes(web2py) # populate_auth_user_teachers_fixed_rate_default(web2py) # populate_auth_user_teachers_fixed_rate_class_1(web2py) # populate_auth_user_teachers_travel(web2py) # # # Create invoices # url = '/finance/teacher_payments_generate_invoices_choose_month' # client.get(url) # assert client.status == 200 # # today = datetime.date.today() # # data = { # 'month': today.month, # 'year': today.year # } # client.post(url, data=data) # assert client.status == 200 # # url = '/finance/batch_add?export=payment&what=teacher_payments' # client.get(url) # assert client.status == 200 # # data = { # 'Name': 'Batch3435435', # 'ColMonth': today.month, # 'ColYear': today.year, # 'Exdate': '2099-01-01', # } # client.post(url, data=data) # assert client.status == 200 # # invoice_1 = web2py.db.invoices(1) # amounts_1 = web2py.db.invoices_amounts(1) # pb_item_1 = web2py.db.payment_batches_items(1) # # assert invoice_1.Description == pb_item_1.Description # assert amounts_1.TotalPriceVAT == pb_item_1.Amount # # amounts_2 = web2py.db.invoices_amounts(2) # pb_item_2 = web2py.db.payment_batches_items(2) # assert amounts_2.TotalPriceVAT == pb_item_2.Amount def test_batches_index_collection(client, web2py): """ Check whether the list of batches shows correctly """ url = '/finance/batches_index?export=collection' client.get(url) assert client.status == 200 assert 'Collection' in client.text def test_batches_index_payment(client, web2py): """ Check whether the list of batches shows correctly """ url = '/finance/batches_index?export=payment' client.get(url) assert client.status == 200 assert 'Payment' in client.text def test_add_batch_invoices_without_zero_lines(client, web2py): """ Check whether we can add a default batch and items are generated properly """ url = '/finance/batch_add?export=collection&what=invoices' client.get(url) assert client.status == 200 populate_customers_with_subscriptions(web2py, 10) # create invoices inv_url = '/test_automation_customer_subscriptions/' + \ 'test_create_invoices' + \ '?month=1&year=2014&description=Subscription_Jan' client.get(inv_url) assert client.status == 200 # go back to the page where we have to submit the data for the new batch client.get(url) assert client.status == 200 # Add a batch data = {'Name' : 'Test export', 'Description' : 'Cherry shake', 'Exdate' : '2014-02-01', 'Note' : 'Who loves bananas? Gorilla does!'} client.post(url, data=data) assert client.status == 200 # check note assert 'Gorilla' in client.text # check amount total sum = web2py.db.invoices_amounts.TotalPriceVAT.sum() amount = web2py.db().select(sum).first()[sum] assert str(round(amount, 2)) in client.text # check batch item text acc_holder = web2py.db.customers_payment_info(1).AccountHolder assert acc_holder in client.text ## check batch total items # customer2's subscription is paused # Customer 8 & 9's subscription don't have an invoice # customer10's subscription has price 0, so should be skipped assert web2py.db(web2py.db.payment_batches_items).count() == 7 def test_add_batch_invoices_with_zero_lines(client, web2py): """ Check whether we can add a default batch and items are generated properly and check whether lines with amount 0 are included """ url = '/finance/batch_add?export=collection&what=invoices' client.get(url) assert client.status == 200 populate_customers_with_subscriptions(web2py, 10) # create invoices inv_url = '/test_automation_customer_subscriptions/' + \ 'test_create_invoices' + \ '?month=1&year=2014&description=Subscription_Jan' client.get(inv_url) assert client.status == 200 # remove the amount for 1 invoice amount = web2py.db.invoices_amounts(1) amount.TotalPriceVAT = 0 amount.update_record() web2py.db.commit() # go back to the page where we have to submit the data for the new batch client.get(url) assert client.status == 200 # Add a batch data = {'Name' : 'Test export', 'Description' : 'Cherry shake', 'Exdate' : '2014-02-01', 'Note' : 'Who loves bananas? Gorilla does!', 'IncludeZero' : 'on'} client.post(url, data=data) assert client.status == 200 # check note assert 'Gorilla' in client.text # check amount total sum = web2py.db.invoices_amounts.TotalPriceVAT.sum() amount = web2py.db().select(sum).first()[sum] assert str(round(amount, 2)) in client.text # check batch item text acc_holder = web2py.db.customers_payment_info(1).AccountHolder.split(' ')[0] assert acc_holder in client.text ## check batch total items assert web2py.db(web2py.db.payment_batches_items).count() == 7 def test_add_batch_invoices_location(client, web2py): """ Check whether we can add an invoice based batch and items are generated propery for a selected location """ client.get('/default/user/login') assert client.status == 200 ## set sys_property # without this, the form doesn't accept 'school_locations_id' web2py.db.sys_properties.insert( Property='Customer_ShowLocation', PropertyValue='on' ) web2py.db.commit() school_locations_id = 1 url = '/finance/batch_add?export=collection&what=invoices' client.get(url) assert client.status == 200 populate_customers_with_subscriptions(web2py, 10) # create invoices inv_url = '/test_automation_customer_subscriptions/' + \ 'test_create_invoices' + \ '?month=1&year=2014&description=Subscription_Jan' client.get(inv_url) assert client.status == 200 # back to the place where we want to be to create a batch client.get(url) assert client.status == 200 data = {'Name' : 'Test export', 'Description' : 'Cherry shake', 'Exdate' : '2014-02-01', 'school_locations_id' : school_locations_id, 'Note' : 'Who loves bananas? Gorilla does!'} client.post(url, data=data) assert client.status == 200 # check redirection assert 'Added batch' in client.text # check note assert 'Gorilla' in client.text # count customers query = (web2py.db.auth_user.school_locations_id == school_locations_id) customers_count = web2py.db(query).count() # all customers should have an invoice # check amount total left = [ web2py.db.invoices.on(web2py.db.invoices.id == web2py.db.invoices_amounts.invoices_id), web2py.db.invoices_customers.on( web2py.db.invoices_customers.invoices_id == web2py.db.invoices.id ), web2py.db.auth_user.on(web2py.db.auth_user.id == web2py.db.invoices_customers.auth_customer_id) ] sum = web2py.db.invoices_amounts.TotalPriceVAT.sum() query = (web2py.db.auth_user.school_locations_id == school_locations_id) amount = web2py.db(query).select(sum, left=left).first()[sum] assert str(round(amount, 2)) in client.text # check batch item text (first 5 customers get school_locations_id 1) payinfo = web2py.db.customers_payment_info(1) # check that the first customer is in the batch acc_holder = payinfo.AccountHolder.split(' ')[0] assert acc_holder in client.text # nr of batches should be equal to nr of customers with locations_id 1 query = (web2py.db.auth_user.school_locations_id == 1) items_count = web2py.db(web2py.db.payment_batches_items).count() assert customers_count == items_count def test_add_batch_category_without_zero_lines(client, web2py): """ Check if a batch for a direct debit extra category is exported correctly """ url = '/finance/batch_add?export=collection&what=category' client.get(url) assert client.status == 200 populate_customers_with_subscriptions(web2py, 10) web2py.db.payment_categories.insert( Name = 'Papaya', CategoryType = 0 ) alt_amount_1 = 200 alt_desc_1 = 'Papaya' web2py.db.alternativepayments.insert( auth_customer_id = 1001, PaymentYear = 2014, PaymentMonth = 1, Amount = alt_amount_1, Description = alt_desc_1, payment_categories_id = 1) alt_amount_2 = 2009 alt_desc_2 = 'Pineapple' web2py.db.alternativepayments.insert( auth_customer_id = 1002, PaymentYear = 2014, PaymentMonth = 1, Amount = alt_amount_2, Description = alt_desc_2, payment_categories_id = 1) alt_amount_3 = 0 alt_desc_3 = 'Mango' web2py.db.alternativepayments.insert( auth_customer_id = 1003, PaymentYear = 2014, PaymentMonth = 1, Amount = alt_amount_3, Description = alt_desc_3, payment_categories_id = 1) web2py.db.commit() #print web2py.db().select(web2py.db.customers_payment_info.ALL) data = {'Name' : 'Test export', 'Description' : 'Cherry shake', 'ColYear' : '2014', 'ColMonth' : '1', 'Exdate' : '2014-02-01', 'Note' : 'Who loves bananas? Gorilla does!', 'payment_categories_id' : '1'} client.post(url, data=data) assert client.status == 200 ## check amount total amount = 0 rows = web2py.db().select(web2py.db.alternativepayments.ALL) for row in rows: amount += row.Amount assert str(round(amount, 2)) in client.text # check batch total items assert web2py.db(web2py.db.payment_batches_items).count() == 2 # check description assert alt_desc_2 in client.text # check ignore zero lines assert not alt_desc_3 in client.text def test_invoices_batch_set_status_sent_to_bank_add_payments(client, web2py): """ Check if payments are added to invoices when the status of a batch becomes 'sent to bank' """ url = '/finance/batch_add?export=collection&what=invoices' client.get(url) assert client.status == 200 populate_customers_with_subscriptions(web2py, 10) # create invoices inv_url = '/test_automation_customer_subscriptions/' + \ 'test_create_invoices' + \ '?month=1&year=2014&description=Subscription_Jan' client.get(inv_url) assert client.status == 200 # go back to the page where we have to submit the data for the new batch client.get(url) assert client.status == 200 # Add a batch data = {'Name' : 'Test export', 'Description' : 'Cherry shake', 'Exdate' : '2014-02-01', 'Note' : 'Who loves bananas? Gorilla does!'} client.post(url, data=data) assert client.status == 200 # check note assert 'Gorilla' in client.text # check setting of status 'sent_to_bank' url = '/finance/batch_content_set_status?pbID=1&status=sent_to_bank' client.get(url) assert client.status == 200 # check if 6 payments have been added assert web2py.db(web2py.db.invoices_payments.id > 0).count() == 7 ip = web2py.db.invoices_payments(1) assert ip.payment_methods_id == 3 # check payment amounts sum = web2py.db.invoices_amounts.TotalPriceVAT.sum() invoices_amount = web2py.db().select(sum).first()[sum] sum = web2py.db.invoices_payments.Amount.sum() payments_amount = web2py.db().select(sum).first()[sum] assert invoices_amount == payments_amount