def test_should_create_sales_order_items_with_different_item_numbers(self):
num_sales_order_imports = SalesOrderItem.objects.count()
sales_order_facade = SalesOrderFacade('some/location')
item = ItemFactory(material_code='MYCODE123',
description='Some Description')
sales_order = SalesOrderFactory()
SalesOrderItemFactory(item=item,
item_number=200,
sales_order=sales_order)
sales_order_item_row = {
'item_number': 220,
'material_code': 'MYCODE123',
'item_description': 'Some Description',
'date': '2015-8-5',
'net_value': 250.0,
'quantity': 5.0
}
sales_order_facade._create_new_item(sales_order_item_row, sales_order)
self.assertEqual(num_sales_order_imports + 2,
SalesOrderItem.objects.count())
def setUp(self):
self.sales_order_file_location = 'sales_orders.xlsx'
self.sales_order_with_missing_data_file_location = 'sales_with_missing_orders.xlsx'
self.create_sales_order_workbook()
self.create_sales_order_missing_data_workbook()
self.imported_sales_order_data = [{
'order_number':
20146879,
'programme_wbs_element':
'4380/A0/04/105',
'items': [{
'material_code': 'S0009113',
'item_number': 10,
'item_description': 'SQFlex 3-10 Pump C/W 1.4KW',
'date': '2014-01-03',
'net_value': 3179.47,
'quantity': 1
}, {
'material_code': 'SL006173',
'item_number': 20,
'item_description': 'Solar Power System',
'date': '2014-01-03',
'net_value': 2638.32,
'quantity': 12
}],
}, {
'order_number':
20147028,
'programme_wbs_element':
'4380/A0/04/106',
'items': [{
'material_code': 'S7800001',
'item_number': 10,
'item_description': 'Retinol 100,000IU soft gel.caps/PAC-500',
'date': '2014-01-09',
'net_value': 21592.3,
'quantity': 2630
}]
}]
self.updated_imported_sales_order_data = [{
'order_number':
20146879,
'programme_wbs_element':
'4380/A0/04/105/007',
'items': [{
'material_code': 'S0009113',
'item_number': 10,
'item_description': 'SQFlex 3-10 Pump C/W 1.4KW',
'date': '2014-01-04',
'net_value': 6358.94,
'quantity': 2
}, {
'material_code': 'SL006173',
'item_number': 20,
'item_description': 'Solar Power System',
'date': '2014-01-03',
'net_value': 2638.32,
'quantity': 12
}],
}, {
'order_number':
20147028,
'programme_wbs_element':
'4380/A0/04/106/004',
'items': [{
'material_code': 'S7800001',
'item_number': 10,
'item_description': 'Retinol 100,000IU soft gel.caps/PAC-500',
'date': '2014-01-09',
'net_value': 21592.3,
'quantity': 2630
}]
}]
self.facade = SalesOrderFacade(self.sales_order_file_location)
self.missing_data_facade = SalesOrderFacade(
self.sales_order_with_missing_data_file_location)
