def setUp(self):
self.release_order_file_location = 'release_orders.xlsx'
self.release_order_with_missing_data_file_location = 'release_orders_with_missing_data.xlsx'
self.create_release_order_workbook()
self.create_release_order_with_missing_data_workbook()
self.imported_release_order_data = [{'order_number': 54101099.0,
'so_number': 20148031.0,
'purchase_order': 81018523.0,
'consignee': 'L438000393',
'consignee_name': 'OYAM DISTRICT ADMIN',
'waybill': 72081598.0,
'shipment_end_date': '2014-01-08',
'items': [{'ro_item_number': 10,
'material_code': 'SL005144',
'description': 'Laptop Lenovo ThinkPad T510',
'quantity': 1,
'value': 1167.66,
'purchase_order': 81018523.0,
'po_item_number': 10,
'so_item_number': 10},
{'ro_item_number': 20,
'material_code': 'SL002248',
'description': 'Laptop bag',
'quantity': 1,
'value': 26.81,
'purchase_order': 81018523.0,
'po_item_number': 20,
'so_item_number': 20}]},
{'order_number': 54101128.0,
'so_number': 20147537.0,
'purchase_order': 45132639.0,
'consignee': 'L438000181',
'consignee_name': 'GULU HOSPITAL',
'waybill': 72081746.0,
'shipment_end_date': '2014-04-08',
'items': [{'ro_item_number': 10,
'material_code': 'S0000208',
'description': 'F-75 therap.diet sachet 102.5g/CAR-120',
'quantity': 20,
'value': 1188.79,
'purchase_order': 45132639.0,
'po_item_number': 20,
'so_item_number': 20}]}]
self.updated_imported_release_order_data = [{'order_number': 54101099.0,
'so_number': 20148031.0,
'purchase_order': 81018523.0,
'consignee': 'L438000393',
'consignee_name': 'OYAM DISTRICT ADMIN',
'waybill': 72081598.0,
'shipment_end_date': '2014-01-08',
'items': [{'ro_item_number': 10,
'material_code': 'SL005144',
'description': 'Laptop Lenovo ThinkPad T510',
'quantity': 2,
'value': 2335.32,
'purchase_order': 81018523.0,
'po_item_number': 10,
'so_item_number': 10},
{'ro_item_number': 20,
'material_code': 'SL002248',
'description': 'Laptop bag',
'quantity': 1,
'value': 26.81,
'purchase_order': 81018523.0,
'po_item_number': 20,
'so_item_number': 20}]},
{'order_number': 54101128.0,
'so_number': 20147537.0,
'purchase_order': 45132639.0,
'consignee': 'L438000181',
'consignee_name': 'GULU HOSPITAL',
'waybill': 72081746.0,
'shipment_end_date': '2014-04-08',
'items': [{'ro_item_number': 10,
'material_code': 'S0000208',
'description': 'F-75 therap.diet sachet 102.5g/CAR-120',
'quantity': 20,
'value': 1188.79,
'purchase_order': 45132639.0,
'po_item_number': 20,
'so_item_number': 20}]}]
self.facade = ReleaseOrderFacade(self.release_order_file_location)
self.facade_with_missing_data = ReleaseOrderFacade(self.release_order_with_missing_data_file_location)
class TestReleaseOrdersVisionFacade(TestCase):
def setUp(self):
self.release_order_file_location = 'release_orders.xlsx'
self.release_order_with_missing_data_file_location = 'release_orders_with_missing_data.xlsx'
self.create_release_order_workbook()
self.create_release_order_with_missing_data_workbook()
self.imported_release_order_data = [{'order_number': 54101099.0,
'so_number': 20148031.0,
'purchase_order': 81018523.0,
'consignee': 'L438000393',
'consignee_name': 'OYAM DISTRICT ADMIN',
'waybill': 72081598.0,
'shipment_end_date': '2014-01-08',
'items': [{'ro_item_number': 10,
'material_code': 'SL005144',
'description': 'Laptop Lenovo ThinkPad T510',
'quantity': 1,
'value': 1167.66,
'purchase_order': 81018523.0,
'po_item_number': 10,
'so_item_number': 10},
{'ro_item_number': 20,
'material_code': 'SL002248',
'description': 'Laptop bag',
'quantity': 1,
'value': 26.81,
'purchase_order': 81018523.0,
'po_item_number': 20,
'so_item_number': 20}]},
{'order_number': 54101128.0,
'so_number': 20147537.0,
'purchase_order': 45132639.0,
'consignee': 'L438000181',
'consignee_name': 'GULU HOSPITAL',
'waybill': 72081746.0,
'shipment_end_date': '2014-04-08',
'items': [{'ro_item_number': 10,
'material_code': 'S0000208',
'description': 'F-75 therap.diet sachet 102.5g/CAR-120',
'quantity': 20,
'value': 1188.79,
'purchase_order': 45132639.0,
'po_item_number': 20,
'so_item_number': 20}]}]
self.updated_imported_release_order_data = [{'order_number': 54101099.0,
'so_number': 20148031.0,
'purchase_order': 81018523.0,
'consignee': 'L438000393',
'consignee_name': 'OYAM DISTRICT ADMIN',
'waybill': 72081598.0,
'shipment_end_date': '2014-01-08',
'items': [{'ro_item_number': 10,
'material_code': 'SL005144',
'description': 'Laptop Lenovo ThinkPad T510',
'quantity': 2,
'value': 2335.32,
'purchase_order': 81018523.0,
'po_item_number': 10,
'so_item_number': 10},
{'ro_item_number': 20,
'material_code': 'SL002248',
'description': 'Laptop bag',
'quantity': 1,
'value': 26.81,
'purchase_order': 81018523.0,
'po_item_number': 20,
'so_item_number': 20}]},
{'order_number': 54101128.0,
'so_number': 20147537.0,
'purchase_order': 45132639.0,
'consignee': 'L438000181',
'consignee_name': 'GULU HOSPITAL',
'waybill': 72081746.0,
'shipment_end_date': '2014-04-08',
'items': [{'ro_item_number': 10,
'material_code': 'S0000208',
'description': 'F-75 therap.diet sachet 102.5g/CAR-120',
'quantity': 20,
'value': 1188.79,
'purchase_order': 45132639.0,
'po_item_number': 20,
'so_item_number': 20}]}]
self.facade = ReleaseOrderFacade(self.release_order_file_location)
self.facade_with_missing_data = ReleaseOrderFacade(self.release_order_with_missing_data_file_location)
def tearDown(self):
os.remove(self.release_order_file_location)
os.remove(self.release_order_with_missing_data_file_location)
ReleaseOrderItem.objects.all().delete()
SalesOrderItem.objects.all().delete()
PurchaseOrderItem.objects.all().delete()
Item.objects.all().delete()
Consignee.objects.all().delete()
ReleaseOrder.objects.all().delete()
Programme.objects.all().delete()
User.objects.all().delete()
def create_release_order_workbook(self):
work_book = Workbook()
sheet = work_book.add_sheet('Sheet 1')
self.header = ['Release Order Number', 'Release Order Item', 'Release Order Date', 'Recommended Delivery Date',
'Material', 'Material Description', 'Delivery Quantity', 'Value', 'Storage Location',
'Warehouse Number', 'Warehouse Description', 'Consignee', 'Consignee Name', 'Authorized Person',
'Release Document', 'Purchasing Document', 'Delivery', 'Grant', 'WBS Element', 'Pick Status',
'Transfer Order Number', 'Transportation Planning Status', 'Waybill Number', 'Forwarder Name',
'Shipment End Date', 'Goods Issue Status', 'Goods Issue Date', 'Release Order Sub-Item',
'HigherLevelItemBatch', 'Release Order Type', 'Release unit', 'Moving price', 'Plant',
'Plant Name', 'Storage Location Desc', 'Dest Warehouse Number', 'Dest Warehouse Description',
'Ship-to party', 'Means of Trans. ID', 'Program Officer', 'Release Document Item',
'Purchasing Item', 'Reference document', 'Reference item', 'Delivery Item',
'Transfer Order Item', 'Forwarder Number', 'Goods Issue Number', 'Goods Issue Item', 'Batch',
'SLED/BBD', 'Actual End Planning Date', 'Check-in Date', 'Planned Shipment Start Date',
'Loading Start Date', 'Loading End Date', 'Actual Shipment Start Date',
'Shipment Completion Date', 'Shipment Days Difference', 'Goods Issue Days Difference',
'Handed-Over to IP Planned', 'Handed-Over to IP', 'Reason for Amendment', 'RO User Reference 1',
'RO User Reference 2', 'RO User Reference 3', 'RO User Reference 4', 'RO User Reference 5',
'WB User Reference 1', 'WB User Reference 2', 'WB User Reference 3', 'WB User Reference 4',
'WB User Reference 5']
self.first_row = [u'54101099', u'10', u'2014-01-08', u'2014-01-08', u'SL005144', u'Laptop Lenovo ThinkPad T510',
u'1',
u'1167.66', u'2611', u'261', u'Kampala W1', u'L438000393', u'OYAM DISTRICT ADMIN',
u'Nuhoddin Maarij', u'20148031', u'81018523', u'56162712', u'SC130003',
u'4380/A0/04/107/002/012',
u'C', u'7732', u'C', u'72081598', u'UNICEF - Kampala Uganda Kampala Country Office Uganda',
u'2014-01-08', u'C', u'8/20/2014', u'0', u'0', u'ZLO', u'EA', u'1167.67', u'5617', u'Uganda',
u'Kampala W1-Prog', u'', u'', u'L438000393', u'', u'Silvia Pasti', u'10', u'10', u'', u'1',
u'1', u'1',
u'F43801', u'4900086016', u'1', u'SYS0084421', u'', u'2014-05-08', u'2014-05-08', u'',
u'2014-05-08',
u'2014-05-08', u'2014-05-08', u'2014-05-08', u'', u'15', u'', u'', u'', u'', u'', u'', u'',
u'',
u'CD 96-50U', u'UNICEF', u'Bongomin', u'', u'']
self.second_row = [u'54101099', u'20', '2014-01-08', '2014-01-08', 'SL002248', 'Laptop bag', '1', '26.81',
'2611',
'261', 'Kampala W1', 'L438000393', 'OYAM DISTRICT ADMIN', 'Nuhoddin Maarij', u'20148031',
u'81018523', u'56162712', 'SC130003', '4380/A0/04/107/002/012', 'C', '7732', 'C',
u'72081598',
'UNICEF - Kampala Uganda Kampala Country Office Uganda', '2014-04-08', 'C', '2014-08-20',
'0',
'0', 'ZLO', 'EA', '26.81', '5617', 'Uganda', 'Kampala W1-Prog', '', '', 'L438000393', '',
'Silvia Pasti', u'20', u'20', '', '2', '2', '2', 'F43801', '4900086016', '2', 'SYS0084422',
'',
'2014-05-08', '2014-05-08', '', '2014-05-08', '2014-05-08', '2014-05-08', '2014-05-08', '',
'15', '', '', '', '', '', '', '', '', 'CD 96-50U', 'UNICEF', 'Bongomin', '', '']
self.third_row = [54101128, 10, '2014-08-01', '2014-04-08', 'S0000208',
'F-75 therap.diet sachet 102.5g/CAR-120', '20', '1188.79', '2611', '261', 'Kampala W1',
'L438000181', 'GULU HOSPITAL', 'NUHODDIN MAARIJ', 20147537, 45132639, 56165211,
'SC130708', '4380/A0/04/105/004/022', 'C', '7665', 'C', 72081746,
'Express Logistics Group Ltd.', '2014-04-08', 'C', '2014-08-20', '0', '0', 'ZLO', 'CAR',
'59.44', '5617', 'Uganda', 'Kampala W1-Prog', '', '', 'L438000181', '', 'PRAKASH LAMSAL',
20, 20, '', '2', '2', '2', '2300027179', '4900086015', '2', '100314', '2016-03-31',
'2014-07-08', '2014-07-08', '', '2014-07-08', '2014-07-08', '2014-07-08', '1900-02-29', '',
'13', '', '', '', '', '', '', '', '', 'UAN 853F', 'EXPRESS LOGISTICS', '2MT', 'SAMUEL', '']
rows = [self.header, self.first_row, self.second_row, self.third_row]
for row_index, row in enumerate(rows):
for col_index, item in enumerate(row):
sheet.write(row_index, col_index, item)
work_book.save(self.release_order_file_location)
def create_release_order_with_missing_data_workbook(self):
work_book = Workbook()
sheet = work_book.add_sheet('Sheet 1')
self.header = ['Release Order Number', 'Release Order Item', 'Release Order Date', 'Recommended Delivery Date',
'Material', 'Material Description', 'Delivery Quantity', 'Value', 'Storage Location',
'Warehouse Number', 'Warehouse Description', 'Consignee', 'Consignee Name', 'Authorized Person',
'Release Document', 'Purchasing Document', 'Delivery', 'Grant', 'WBS Element', 'Pick Status',
'Transfer Order Number', 'Transportation Planning Status', 'Waybill Number', 'Forwarder Name',
'Shipment End Date', 'Goods Issue Status', 'Goods Issue Date', 'Release Order Sub-Item',
'HigherLevelItemBatch', 'Release Order Type', 'Release unit', 'Moving price', 'Plant',
'Plant Name', 'Storage Location Desc', 'Dest Warehouse Number', 'Dest Warehouse Description',
'Ship-to party', 'Means of Trans. ID', 'Program Officer', 'Release Document Item',
'Purchasing Item', 'Reference document', 'Reference item', 'Delivery Item',
'Transfer Order Item', 'Forwarder Number', 'Goods Issue Number', 'Goods Issue Item', 'Batch',
'SLED/BBD', 'Actual End Planning Date', 'Check-in Date', 'Planned Shipment Start Date',
'Loading Start Date', 'Loading End Date', 'Actual Shipment Start Date',
'Shipment Completion Date', 'Shipment Days Difference', 'Goods Issue Days Difference',
'Handed-Over to IP Planned', 'Handed-Over to IP', 'Reason for Amendment', 'RO User Reference 1',
'RO User Reference 2', 'RO User Reference 3', 'RO User Reference 4', 'RO User Reference 5',
'WB User Reference 1', 'WB User Reference 2', 'WB User Reference 3', 'WB User Reference 4',
'WB User Reference 5']
self.row = [u'', u'10', u'2014-01-08', u'', u'', u'',
u'1',
u'1167.66', u'2611', u'261', u'', u'L438000393', u'OYAM DISTRICT ADMIN',
u'', u'20148031', u'81018523', u'56162712', u'SC130003',
u'',
u'C', u'7732', u'C', u'72081598', u'UNICEF - Kampala Uganda Kampala Country Office Uganda',
u'08/05/2014', u'C', u'8/20/2014', u'0', u'0', u'ZLO', u'EA', u'1167.67', u'5617', u'Uganda',
u'Kampala W1-Prog', u'', u'', u'L438000393', u'', u'Silvia Pasti', u'10', u'10', u'', u'1',
u'1', u'1',
u'F43801', u'4900086016', u'1', u'SYS0084421', u'', u'2014-05-08', u'2014-05-08', u'',
u'2014-05-08',
u'2014-05-08', u'2014-05-08', u'2014-05-08', u'', u'15', u'', u'', u'', u'', u'', u'', u'',
u'',
u'CD 96-50U', u'UNICEF', u'Bongomin', u'', u'']
rows = [self.header, self.row]
for row_index, row in enumerate(rows):
for col_index, item in enumerate(row):
sheet.write(row_index, col_index, item)
work_book.save(self.release_order_with_missing_data_file_location)
def create_items(self):
self.item_one = ItemFactory(material_code='SL005144', description='Laptop Lenovo ThinkPad T510')
self.item_two = ItemFactory(material_code='SL002248', description='Laptop bag')
self.item_three = ItemFactory(material_code='S0000208', description='F-75 therap.diet sachet 102.5g/CAR-120')
def create_sales_orders(self):
self.sales_order_one = SalesOrderFactory(order_number=20148031)
self.sales_order_two = SalesOrderFactory(order_number=20147537)
self.sales_order_item_one = SalesOrderItemFactory(sales_order=self.sales_order_one, item=self.item_one,
item_number=10)
self.sales_order_item_two = SalesOrderItemFactory(sales_order=self.sales_order_one, item=self.item_two,
item_number=20)
self.sales_order_item_three = SalesOrderItemFactory(sales_order=self.sales_order_two, item=self.item_three,
item_number=20)
def create_purchase_orders(self):
self.purchase_order_one = PurchaseOrderFactory(order_number=81018523, sales_order=self.sales_order_one)
self.purchase_order_two = PurchaseOrderFactory(order_number=45132639, sales_order=self.sales_order_two)
self.purchase_order_item_one = PurchaseOrderItemFactory(purchase_order=self.purchase_order_one,
sales_order_item=self.sales_order_item_one,
item_number=10)
self.purchase_order_item_two = PurchaseOrderItemFactory(purchase_order=self.purchase_order_one,
sales_order_item=self.sales_order_item_two,
item_number=20)
self.purchase_order_item_three = PurchaseOrderItemFactory(purchase_order=self.purchase_order_two,
sales_order_item=self.sales_order_item_three,
item_number=20)
def create_consignees(self):
self.consignee_one = ConsigneeFactory(customer_id='L438000393', name='OYAM DISTRICT ADMIN')
self.consignee_two = ConsigneeFactory(customer_id='L438000181', name='GULU HOSPITAL')
def test_should_load_release_order_data(self):
release_order_data = self.facade.load_records()
self.assertEqual(release_order_data, self.imported_release_order_data)
def test_should_not_load_release_order_with_missing_data(self):
with self.assertRaises(ImportException) as context:
self.facade_with_missing_data.load_records()
expected_message = "Import has failed due to missing [order_number] in row [2]. Please correct the error then try the upload again"
self.assertEqual(context.exception.message, expected_message)
def test_should_save_release_order_data(self):
self.assertEqual(ReleaseOrder.objects.count(), 0)
self.assertEqual(ReleaseOrderItem.objects.count(), 0)
self.create_consignees()
self.create_items()
self.create_sales_orders()
self.create_purchase_orders()
self.facade.save_records(self.imported_release_order_data)
self.assert_release_orders_were_created()
self.assert_release_order_items_were_created()
def test_should_create_consignee_when_saving_release_order_data_if_there_is_no_matching_consignee(self):
Consignee.objects.all().delete()
self.create_items()
self.create_sales_orders()
self.create_purchase_orders()
self.facade.save_records(self.imported_release_order_data)
self.assert_consignees_were_created()
def test_should_not_save_a_release_order_with_no_matching_sales_order(self):
self.create_consignees()
self.create_items()
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrder.objects.count(), 0)
def test_should_not_save_a_release_order_with_no_matching_purchase_order(self):
self.create_consignees()
self.create_items()
self.create_sales_orders()
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrder.objects.count(), 0)
def test_should_not_recreate_existing_release_orders_when_saving_only_matching_by_order_number(self):
self.create_consignees()
self.create_items()
self.create_sales_orders()
self.create_purchase_orders()
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrder.objects.count(), 2)
first_release_order = ReleaseOrder.objects.all().first()
first_release_order.delivery_date = datetime.date(2100, 01, 13)
first_release_order.save()
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrder.objects.count(), 2)
def test_should_not_create_existing_release_order_items_when_there_is_no_matching_sales_order_item(self):
self.create_consignees()
self.create_items()
self.sales_order_one = SalesOrderFactory(order_number=20148031)
self.sales_order_two = SalesOrderFactory(order_number=20147537)
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrderItem.objects.count(), 0)
def test_should_not_create_existing_release_order_items_when_there_is_no_matching_purchase_order_item(self):
self.create_consignees()
self.create_items()
self.create_sales_orders()
self.purchase_order_one = PurchaseOrderFactory(order_number=81018523, sales_order=self.sales_order_one)
self.purchase_order_two = PurchaseOrderFactory(order_number=45132639, sales_order=self.sales_order_two)
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrderItem.objects.count(), 0)
def test_should_update_existing_release_order_items_when_saving_only_matching_by_order_number(self):
self.create_consignees()
self.create_items()
self.create_sales_orders()
self.create_purchase_orders()
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrderItem.objects.count(), 3)
self.facade.save_records(self.updated_imported_release_order_data)
self.assertEqual(ReleaseOrderItem.objects.count(), 3)
updated_release_order_item = ReleaseOrderItem.objects.all().first()
expected_ro_item = ReleaseOrderItem(release_order=ReleaseOrder.objects.all()[0], item=Item.objects.all()[0],
purchase_order_item=self.purchase_order_item_one, quantity=Decimal('2'),
value=Decimal('2335.32'), item_number=10)
self.assert_release_order_items_are_equal(expected_ro_item, updated_release_order_item)
def test_should_load_release_orders_from_excel_and_save(self):
self.assertEqual(ReleaseOrder.objects.count(), 0)
self.facade.load_records = MagicMock(return_value=self.imported_release_order_data)
self.facade.save_records = MagicMock()
self.facade.import_records()
self.facade.load_records.assert_called()
self.facade.save_records.assert_called_with(self.imported_release_order_data)
def assert_consignees_were_created(self):
oyam = 'OYAM DISTRICT ADMIN'
oyamID = 'L438000393'
gulu = 'GULU HOSPITAL'
guluID = 'L438000181'
Consignee(name=oyam, customer_id=oyamID,
type=Consignee.TYPES.implementing_partner, imported_from_vision=True)
Consignee(name=gulu, customer_id=guluID,
type=Consignee.TYPES.implementing_partner, imported_from_vision=True)
consignees = Consignee.objects.all()
consignee_names = [consignee.name for consignee in consignees]
consignee_ids = [consignee.customer_id for consignee in consignees]
self.assertEqual(len(consignees), 2)
self.assertIn(oyam, consignee_names)
self.assertIn(gulu, consignee_names)
self.assertIn(oyamID, consignee_ids)
self.assertIn(guluID, consignee_ids)
def assert_release_orders_were_created(self):
release_order_one = ReleaseOrder(order_number=54101099, consignee=self.consignee_one, waybill=72081598,
sales_order=self.sales_order_one, purchase_order=self.purchase_order_one,
delivery_date=datetime.date(2014, 1, 8))
release_order_two = ReleaseOrder(order_number=54101128, consignee=self.consignee_two, waybill=72081746,
sales_order=self.sales_order_two, purchase_order=self.purchase_order_one,
delivery_date=datetime.date(2014, 4, 8))
self.assert_release_orders_are_equal(release_order_one, ReleaseOrder.objects.all()[0])
self.assert_release_orders_are_equal(release_order_two, ReleaseOrder.objects.all()[1])
def assert_release_order_items_were_created(self):
order_item_one = ReleaseOrderItem(release_order=ReleaseOrder.objects.all()[0], item=self.item_one,
purchase_order_item=self.purchase_order_item_one, quantity=1,
value=Decimal('1167.66'), item_number=10)
order_item_two = ReleaseOrderItem(release_order=ReleaseOrder.objects.all()[0], item=self.item_two,
purchase_order_item=self.purchase_order_item_two, quantity=1,
value=Decimal('26.81'), item_number=20)
order_item_three = ReleaseOrderItem(release_order=ReleaseOrder.objects.all()[1], item=self.item_three,
purchase_order_item=self.purchase_order_item_three, quantity=20,
value=Decimal('1188.79'), item_number=10)
self.assertEqual(ReleaseOrderItem.objects.count(), 3)
actual_order_item_one = ReleaseOrderItem.objects.get(release_order=ReleaseOrder.objects.first(), item_number=10)
actual_order_item_two = ReleaseOrderItem.objects.get(release_order=ReleaseOrder.objects.first(), item_number=20)
actual_order_item_three = ReleaseOrderItem.objects.get(release_order=ReleaseOrder.objects.last(), item_number=10)
self.assert_release_order_items_are_equal(order_item_one, actual_order_item_one)
self.assert_release_order_items_are_equal(order_item_two, actual_order_item_two)
self.assert_release_order_items_are_equal(order_item_three, actual_order_item_three)
def assert_consignees_are_equal(self, consignee_one, consignee_two):
self.assertEqual(consignee_one.name, consignee_two.name)
self.assertEqual(consignee_one.customer_id, consignee_two.customer_id)
self.assertEqual(consignee_one.type, consignee_two.type)
self.assertEqual(consignee_one.imported_from_vision, consignee_two.imported_from_vision)
def assert_release_orders_are_equal(self, order_one, order_two):
self.assertEqual(order_one.order_number, order_two.order_number)
self.assertEqual(order_one.consignee_id, order_two.consignee_id)
self.assertEqual(order_one.delivery_date, order_two.delivery_date)
self.assertEqual(order_one.waybill, order_two.waybill)
self.assertEqual(order_one.sales_order_id, order_two.sales_order_id)
def assert_release_order_items_are_equal(self, order_item_one, order_item_two):
self.assertEqual(order_item_one.release_order_id, order_item_two.release_order_id)
self.assertEqual(order_item_one.item_id, order_item_two.item_id)
self.assertEqual(order_item_one.purchase_order_item_id, order_item_two.purchase_order_item_id)
self.assertEqual(order_item_one.quantity, order_item_two.quantity)
self.assertEqual(order_item_one.value, order_item_two.value)
def setUp(self):
self.release_order_file_location = 'release_orders.xlsx'
self.release_order_with_missing_data_file_location = 'release_orders_with_missing_data.xlsx'
self.create_release_order_workbook()
self.create_release_order_with_missing_data_workbook()
self.imported_release_order_data = [{
'order_number':
54101099.0,
'so_number':
20148031.0,
'purchase_order':
81018523.0,
'consignee':
'L438000393',
'consignee_name':
'OYAM DISTRICT ADMIN',
'waybill':
72081598.0,
'shipment_end_date':
'2014-01-08',
'items': [{
'ro_item_number': 10,
'material_code': 'SL005144',
'description': 'Laptop Lenovo ThinkPad T510',
'quantity': 1,
'value': 1167.66,
'purchase_order': 81018523.0,
'po_item_number': 10,
'so_item_number': 10
}, {
'ro_item_number': 20,
'material_code': 'SL002248',
'description': 'Laptop bag',
'quantity': 1,
'value': 26.81,
'purchase_order': 81018523.0,
'po_item_number': 20,
'so_item_number': 20
}]
}, {
'order_number':
54101128.0,
'so_number':
20147537.0,
'purchase_order':
45132639.0,
'consignee':
'L438000181',
'consignee_name':
'GULU HOSPITAL',
'waybill':
72081746.0,
'shipment_end_date':
'2014-04-08',
'items': [{
'ro_item_number': 10,
'material_code': 'S0000208',
'description': 'F-75 therap.diet sachet 102.5g/CAR-120',
'quantity': 20,
'value': 1188.79,
'purchase_order': 45132639.0,
'po_item_number': 20,
'so_item_number': 20
}]
}]
self.updated_imported_release_order_data = [{
'order_number':
54101099.0,
'so_number':
20148031.0,
'purchase_order':
81018523.0,
'consignee':
'L438000393',
'consignee_name':
'OYAM DISTRICT ADMIN',
'waybill':
72081598.0,
'shipment_end_date':
'2014-01-08',
'items': [{
'ro_item_number': 10,
'material_code': 'SL005144',
'description': 'Laptop Lenovo ThinkPad T510',
'quantity': 2,
'value': 2335.32,
'purchase_order': 81018523.0,
'po_item_number': 10,
'so_item_number': 10
}, {
'ro_item_number': 20,
'material_code': 'SL002248',
'description': 'Laptop bag',
'quantity': 1,
'value': 26.81,
'purchase_order': 81018523.0,
'po_item_number': 20,
'so_item_number': 20
}]
}, {
'order_number':
54101128.0,
'so_number':
20147537.0,
'purchase_order':
45132639.0,
'consignee':
'L438000181',
'consignee_name':
'GULU HOSPITAL',
'waybill':
72081746.0,
'shipment_end_date':
'2014-04-08',
'items': [{
'ro_item_number': 10,
'material_code': 'S0000208',
'description': 'F-75 therap.diet sachet 102.5g/CAR-120',
'quantity': 20,
'value': 1188.79,
'purchase_order': 45132639.0,
'po_item_number': 20,
'so_item_number': 20
}]
}]
self.facade = ReleaseOrderFacade(self.release_order_file_location)
self.facade_with_missing_data = ReleaseOrderFacade(
self.release_order_with_missing_data_file_location)
class TestReleaseOrdersVisionFacade(TestCase):
def setUp(self):
self.release_order_file_location = 'release_orders.xlsx'
self.release_order_with_missing_data_file_location = 'release_orders_with_missing_data.xlsx'
self.create_release_order_workbook()
self.create_release_order_with_missing_data_workbook()
self.imported_release_order_data = [{
'order_number':
54101099.0,
'so_number':
20148031.0,
'purchase_order':
81018523.0,
'consignee':
'L438000393',
'consignee_name':
'OYAM DISTRICT ADMIN',
'waybill':
72081598.0,
'shipment_end_date':
'2014-01-08',
'items': [{
'ro_item_number': 10,
'material_code': 'SL005144',
'description': 'Laptop Lenovo ThinkPad T510',
'quantity': 1,
'value': 1167.66,
'purchase_order': 81018523.0,
'po_item_number': 10,
'so_item_number': 10
}, {
'ro_item_number': 20,
'material_code': 'SL002248',
'description': 'Laptop bag',
'quantity': 1,
'value': 26.81,
'purchase_order': 81018523.0,
'po_item_number': 20,
'so_item_number': 20
}]
}, {
'order_number':
54101128.0,
'so_number':
20147537.0,
'purchase_order':
45132639.0,
'consignee':
'L438000181',
'consignee_name':
'GULU HOSPITAL',
'waybill':
72081746.0,
'shipment_end_date':
'2014-04-08',
'items': [{
'ro_item_number': 10,
'material_code': 'S0000208',
'description': 'F-75 therap.diet sachet 102.5g/CAR-120',
'quantity': 20,
'value': 1188.79,
'purchase_order': 45132639.0,
'po_item_number': 20,
'so_item_number': 20
}]
}]
self.updated_imported_release_order_data = [{
'order_number':
54101099.0,
'so_number':
20148031.0,
'purchase_order':
81018523.0,
'consignee':
'L438000393',
'consignee_name':
'OYAM DISTRICT ADMIN',
'waybill':
72081598.0,
'shipment_end_date':
'2014-01-08',
'items': [{
'ro_item_number': 10,
'material_code': 'SL005144',
'description': 'Laptop Lenovo ThinkPad T510',
'quantity': 2,
'value': 2335.32,
'purchase_order': 81018523.0,
'po_item_number': 10,
'so_item_number': 10
}, {
'ro_item_number': 20,
'material_code': 'SL002248',
'description': 'Laptop bag',
'quantity': 1,
'value': 26.81,
'purchase_order': 81018523.0,
'po_item_number': 20,
'so_item_number': 20
}]
}, {
'order_number':
54101128.0,
'so_number':
20147537.0,
'purchase_order':
45132639.0,
'consignee':
'L438000181',
'consignee_name':
'GULU HOSPITAL',
'waybill':
72081746.0,
'shipment_end_date':
'2014-04-08',
'items': [{
'ro_item_number': 10,
'material_code': 'S0000208',
'description': 'F-75 therap.diet sachet 102.5g/CAR-120',
'quantity': 20,
'value': 1188.79,
'purchase_order': 45132639.0,
'po_item_number': 20,
'so_item_number': 20
}]
}]
self.facade = ReleaseOrderFacade(self.release_order_file_location)
self.facade_with_missing_data = ReleaseOrderFacade(
self.release_order_with_missing_data_file_location)
def tearDown(self):
os.remove(self.release_order_file_location)
os.remove(self.release_order_with_missing_data_file_location)
ReleaseOrderItem.objects.all().delete()
SalesOrderItem.objects.all().delete()
PurchaseOrderItem.objects.all().delete()
Item.objects.all().delete()
Consignee.objects.all().delete()
ReleaseOrder.objects.all().delete()
Programme.objects.all().delete()
User.objects.all().delete()
def create_release_order_workbook(self):
work_book = Workbook()
sheet = work_book.add_sheet('Sheet 1')
self.header = [
'Release Order Number', 'Release Order Item', 'Release Order Date',
'Recommended Delivery Date', 'Material', 'Material Description',
'Delivery Quantity', 'Value', 'Storage Location',
'Warehouse Number', 'Warehouse Description', 'Consignee',
'Consignee Name', 'Authorized Person', 'Release Document',
'Purchasing Document', 'Delivery', 'Grant', 'WBS Element',
'Pick Status', 'Transfer Order Number',
'Transportation Planning Status', 'Waybill Number',
'Forwarder Name', 'Shipment End Date', 'Goods Issue Status',
'Goods Issue Date', 'Release Order Sub-Item',
'HigherLevelItemBatch', 'Release Order Type', 'Release unit',
'Moving price', 'Plant', 'Plant Name', 'Storage Location Desc',
'Dest Warehouse Number', 'Dest Warehouse Description',
'Ship-to party', 'Means of Trans. ID', 'Program Officer',
'Release Document Item', 'Purchasing Item', 'Reference document',
'Reference item', 'Delivery Item', 'Transfer Order Item',
'Forwarder Number', 'Goods Issue Number', 'Goods Issue Item',
'Batch', 'SLED/BBD', 'Actual End Planning Date', 'Check-in Date',
'Planned Shipment Start Date', 'Loading Start Date',
'Loading End Date', 'Actual Shipment Start Date',
'Shipment Completion Date', 'Shipment Days Difference',
'Goods Issue Days Difference', 'Handed-Over to IP Planned',
'Handed-Over to IP', 'Reason for Amendment', 'RO User Reference 1',
'RO User Reference 2', 'RO User Reference 3',
'RO User Reference 4', 'RO User Reference 5',
'WB User Reference 1', 'WB User Reference 2',
'WB User Reference 3', 'WB User Reference 4', 'WB User Reference 5'
]
self.first_row = [
u'54101099', u'10', u'2014-01-08', u'2014-01-08', u'SL005144',
u'Laptop Lenovo ThinkPad T510', u'1', u'1167.66', u'2611', u'261',
u'Kampala W1', u'L438000393', u'OYAM DISTRICT ADMIN',
u'Nuhoddin Maarij', u'20148031', u'81018523', u'56162712',
u'SC130003', u'4380/A0/04/107/002/012', u'C', u'7732', u'C',
u'72081598',
u'UNICEF - Kampala Uganda Kampala Country Office Uganda',
u'2014-01-08', u'C', u'8/20/2014', u'0', u'0', u'ZLO', u'EA',
u'1167.67', u'5617', u'Uganda', u'Kampala W1-Prog', u'', u'',
u'L438000393', u'', u'Silvia Pasti', u'10', u'10', u'', u'1', u'1',
u'1', u'F43801', u'4900086016', u'1', u'SYS0084421', u'',
u'2014-05-08', u'2014-05-08', u'', u'2014-05-08', u'2014-05-08',
u'2014-05-08', u'2014-05-08', u'', u'15', u'', u'', u'', u'', u'',
u'', u'', u'', u'CD 96-50U', u'UNICEF', u'Bongomin', u'', u''
]
self.second_row = [
u'54101099', u'20', '2014-01-08', '2014-01-08', 'SL002248',
'Laptop bag', '1', '26.81', '2611', '261', 'Kampala W1',
'L438000393', 'OYAM DISTRICT ADMIN', 'Nuhoddin Maarij',
u'20148031', u'81018523', u'56162712', 'SC130003',
'4380/A0/04/107/002/012', 'C', '7732', 'C', u'72081598',
'UNICEF - Kampala Uganda Kampala Country Office Uganda',
'2014-04-08', 'C', '2014-08-20', '0', '0', 'ZLO', 'EA', '26.81',
'5617', 'Uganda', 'Kampala W1-Prog', '', '', 'L438000393', '',
'Silvia Pasti', u'20', u'20', '', '2', '2', '2', 'F43801',
'4900086016', '2', 'SYS0084422', '', '2014-05-08', '2014-05-08',
'', '2014-05-08', '2014-05-08', '2014-05-08', '2014-05-08', '',
'15', '', '', '', '', '', '', '', '', 'CD 96-50U', 'UNICEF',
'Bongomin', '', ''
]
self.third_row = [
54101128, 10, '2014-08-01', '2014-04-08', 'S0000208',
'F-75 therap.diet sachet 102.5g/CAR-120', '20', '1188.79', '2611',
'261', 'Kampala W1', 'L438000181', 'GULU HOSPITAL',
'NUHODDIN MAARIJ', 20147537, 45132639, 56165211, 'SC130708',
'4380/A0/04/105/004/022', 'C', '7665', 'C', 72081746,
'Express Logistics Group Ltd.', '2014-04-08', 'C', '2014-08-20',
'0', '0', 'ZLO', 'CAR', '59.44', '5617', 'Uganda',
'Kampala W1-Prog', '', '', 'L438000181', '', 'PRAKASH LAMSAL', 20,
20, '', '2', '2', '2', '2300027179', '4900086015', '2', '100314',
'2016-03-31', '2014-07-08', '2014-07-08', '', '2014-07-08',
'2014-07-08', '2014-07-08', '1900-02-29', '', '13', '', '', '', '',
'', '', '', '', 'UAN 853F', 'EXPRESS LOGISTICS', '2MT', 'SAMUEL',
''
]
rows = [self.header, self.first_row, self.second_row, self.third_row]
for row_index, row in enumerate(rows):
for col_index, item in enumerate(row):
sheet.write(row_index, col_index, item)
work_book.save(self.release_order_file_location)
def create_release_order_with_missing_data_workbook(self):
work_book = Workbook()
sheet = work_book.add_sheet('Sheet 1')
self.header = [
'Release Order Number', 'Release Order Item', 'Release Order Date',
'Recommended Delivery Date', 'Material', 'Material Description',
'Delivery Quantity', 'Value', 'Storage Location',
'Warehouse Number', 'Warehouse Description', 'Consignee',
'Consignee Name', 'Authorized Person', 'Release Document',
'Purchasing Document', 'Delivery', 'Grant', 'WBS Element',
'Pick Status', 'Transfer Order Number',
'Transportation Planning Status', 'Waybill Number',
'Forwarder Name', 'Shipment End Date', 'Goods Issue Status',
'Goods Issue Date', 'Release Order Sub-Item',
'HigherLevelItemBatch', 'Release Order Type', 'Release unit',
'Moving price', 'Plant', 'Plant Name', 'Storage Location Desc',
'Dest Warehouse Number', 'Dest Warehouse Description',
'Ship-to party', 'Means of Trans. ID', 'Program Officer',
'Release Document Item', 'Purchasing Item', 'Reference document',
'Reference item', 'Delivery Item', 'Transfer Order Item',
'Forwarder Number', 'Goods Issue Number', 'Goods Issue Item',
'Batch', 'SLED/BBD', 'Actual End Planning Date', 'Check-in Date',
'Planned Shipment Start Date', 'Loading Start Date',
'Loading End Date', 'Actual Shipment Start Date',
'Shipment Completion Date', 'Shipment Days Difference',
'Goods Issue Days Difference', 'Handed-Over to IP Planned',
'Handed-Over to IP', 'Reason for Amendment', 'RO User Reference 1',
'RO User Reference 2', 'RO User Reference 3',
'RO User Reference 4', 'RO User Reference 5',
'WB User Reference 1', 'WB User Reference 2',
'WB User Reference 3', 'WB User Reference 4', 'WB User Reference 5'
]
self.row = [
u'', u'10', u'2014-01-08', u'', u'', u'', u'1', u'1167.66',
u'2611', u'261', u'', u'L438000393', u'OYAM DISTRICT ADMIN', u'',
u'20148031', u'81018523', u'56162712', u'SC130003', u'', u'C',
u'7732', u'C', u'72081598',
u'UNICEF - Kampala Uganda Kampala Country Office Uganda',
u'08/05/2014', u'C', u'8/20/2014', u'0', u'0', u'ZLO', u'EA',
u'1167.67', u'5617', u'Uganda', u'Kampala W1-Prog', u'', u'',
u'L438000393', u'', u'Silvia Pasti', u'10', u'10', u'', u'1', u'1',
u'1', u'F43801', u'4900086016', u'1', u'SYS0084421', u'',
u'2014-05-08', u'2014-05-08', u'', u'2014-05-08', u'2014-05-08',
u'2014-05-08', u'2014-05-08', u'', u'15', u'', u'', u'', u'', u'',
u'', u'', u'', u'CD 96-50U', u'UNICEF', u'Bongomin', u'', u''
]
rows = [self.header, self.row]
for row_index, row in enumerate(rows):
for col_index, item in enumerate(row):
sheet.write(row_index, col_index, item)
work_book.save(self.release_order_with_missing_data_file_location)
def create_items(self):
self.item_one = ItemFactory(material_code='SL005144',
description='Laptop Lenovo ThinkPad T510')
self.item_two = ItemFactory(material_code='SL002248',
description='Laptop bag')
self.item_three = ItemFactory(
material_code='S0000208',
description='F-75 therap.diet sachet 102.5g/CAR-120')
def create_sales_orders(self):
self.sales_order_one = SalesOrderFactory(order_number=20148031)
self.sales_order_two = SalesOrderFactory(order_number=20147537)
self.sales_order_item_one = SalesOrderItemFactory(
sales_order=self.sales_order_one,
item=self.item_one,
item_number=10)
self.sales_order_item_two = SalesOrderItemFactory(
sales_order=self.sales_order_one,
item=self.item_two,
item_number=20)
self.sales_order_item_three = SalesOrderItemFactory(
sales_order=self.sales_order_two,
item=self.item_three,
item_number=20)
def create_purchase_orders(self):
self.purchase_order_one = PurchaseOrderFactory(
order_number=81018523, sales_order=self.sales_order_one)
self.purchase_order_two = PurchaseOrderFactory(
order_number=45132639, sales_order=self.sales_order_two)
self.purchase_order_item_one = PurchaseOrderItemFactory(
purchase_order=self.purchase_order_one,
sales_order_item=self.sales_order_item_one,
item_number=10)
self.purchase_order_item_two = PurchaseOrderItemFactory(
purchase_order=self.purchase_order_one,
sales_order_item=self.sales_order_item_two,
item_number=20)
self.purchase_order_item_three = PurchaseOrderItemFactory(
purchase_order=self.purchase_order_two,
sales_order_item=self.sales_order_item_three,
item_number=20)
def create_consignees(self):
self.consignee_one = ConsigneeFactory(customer_id='L438000393',
name='OYAM DISTRICT ADMIN')
self.consignee_two = ConsigneeFactory(customer_id='L438000181',
name='GULU HOSPITAL')
def test_should_load_release_order_data(self):
release_order_data = self.facade.load_records()
self.assertEqual(release_order_data, self.imported_release_order_data)
def test_should_not_load_release_order_with_missing_data(self):
with self.assertRaises(ImportException) as context:
self.facade_with_missing_data.load_records()
expected_message = "Import has failed due to missing [order_number] in row [2]. Please correct the error then try the upload again"
self.assertEqual(context.exception.message, expected_message)
def test_should_save_release_order_data(self):
self.assertEqual(ReleaseOrder.objects.count(), 0)
self.assertEqual(ReleaseOrderItem.objects.count(), 0)
self.create_consignees()
self.create_items()
self.create_sales_orders()
self.create_purchase_orders()
self.facade.save_records(self.imported_release_order_data)
self.assert_release_orders_were_created()
self.assert_release_order_items_were_created()
def test_should_create_consignee_when_saving_release_order_data_if_there_is_no_matching_consignee(
self):
Consignee.objects.all().delete()
self.create_items()
self.create_sales_orders()
self.create_purchase_orders()
self.facade.save_records(self.imported_release_order_data)
self.assert_consignees_were_created()
def test_should_not_save_a_release_order_with_no_matching_sales_order(
self):
self.create_consignees()
self.create_items()
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrder.objects.count(), 0)
def test_should_not_save_a_release_order_with_no_matching_purchase_order(
self):
self.create_consignees()
self.create_items()
self.create_sales_orders()
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrder.objects.count(), 0)
def test_should_not_recreate_existing_release_orders_when_saving_only_matching_by_order_number(
self):
self.create_consignees()
self.create_items()
self.create_sales_orders()
self.create_purchase_orders()
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrder.objects.count(), 2)
first_release_order = ReleaseOrder.objects.all().first()
first_release_order.delivery_date = datetime.date(2100, 01, 13)
first_release_order.save()
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrder.objects.count(), 2)
def test_should_not_create_existing_release_order_items_when_there_is_no_matching_sales_order_item(
self):
self.create_consignees()
self.create_items()
self.sales_order_one = SalesOrderFactory(order_number=20148031)
self.sales_order_two = SalesOrderFactory(order_number=20147537)
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrderItem.objects.count(), 0)
def test_should_not_create_existing_release_order_items_when_there_is_no_matching_purchase_order_item(
self):
self.create_consignees()
self.create_items()
self.create_sales_orders()
self.purchase_order_one = PurchaseOrderFactory(
order_number=81018523, sales_order=self.sales_order_one)
self.purchase_order_two = PurchaseOrderFactory(
order_number=45132639, sales_order=self.sales_order_two)
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrderItem.objects.count(), 0)
def test_should_update_existing_release_order_items_when_saving_only_matching_by_order_number(
self):
self.create_consignees()
self.create_items()
self.create_sales_orders()
self.create_purchase_orders()
self.facade.save_records(self.imported_release_order_data)
self.assertEqual(ReleaseOrderItem.objects.count(), 3)
self.facade.save_records(self.updated_imported_release_order_data)
self.assertEqual(ReleaseOrderItem.objects.count(), 3)
updated_release_order_item = ReleaseOrderItem.objects.all().first()
expected_ro_item = ReleaseOrderItem(
release_order=ReleaseOrder.objects.all()[0],
item=Item.objects.all()[0],
purchase_order_item=self.purchase_order_item_one,
quantity=Decimal('2'),
value=Decimal('2335.32'),
item_number=10)
self.assert_release_order_items_are_equal(expected_ro_item,
updated_release_order_item)
def test_should_load_release_orders_from_excel_and_save(self):
self.assertEqual(ReleaseOrder.objects.count(), 0)
self.facade.load_records = MagicMock(
return_value=self.imported_release_order_data)
self.facade.save_records = MagicMock()
self.facade.import_records()
self.facade.load_records.assert_called()
self.facade.save_records.assert_called_with(
self.imported_release_order_data)
def assert_consignees_were_created(self):
oyam = 'OYAM DISTRICT ADMIN'
oyamID = 'L438000393'
gulu = 'GULU HOSPITAL'
guluID = 'L438000181'
Consignee(name=oyam,
customer_id=oyamID,
type=Consignee.TYPES.implementing_partner,
imported_from_vision=True)
Consignee(name=gulu,
customer_id=guluID,
type=Consignee.TYPES.implementing_partner,
imported_from_vision=True)
consignees = Consignee.objects.all()
consignee_names = [consignee.name for consignee in consignees]
consignee_ids = [consignee.customer_id for consignee in consignees]
self.assertEqual(len(consignees), 2)
self.assertIn(oyam, consignee_names)
self.assertIn(gulu, consignee_names)
self.assertIn(oyamID, consignee_ids)
self.assertIn(guluID, consignee_ids)
def assert_release_orders_were_created(self):
release_order_one = ReleaseOrder(
order_number=54101099,
consignee=self.consignee_one,
waybill=72081598,
sales_order=self.sales_order_one,
purchase_order=self.purchase_order_one,
delivery_date=datetime.date(2014, 1, 8))
release_order_two = ReleaseOrder(
order_number=54101128,
consignee=self.consignee_two,
waybill=72081746,
sales_order=self.sales_order_two,
purchase_order=self.purchase_order_one,
delivery_date=datetime.date(2014, 4, 8))
self.assert_release_orders_are_equal(release_order_one,
ReleaseOrder.objects.all()[0])
self.assert_release_orders_are_equal(release_order_two,
ReleaseOrder.objects.all()[1])
def assert_release_order_items_were_created(self):
order_item_one = ReleaseOrderItem(
release_order=ReleaseOrder.objects.all()[0],
item=self.item_one,
purchase_order_item=self.purchase_order_item_one,
quantity=1,
value=Decimal('1167.66'),
item_number=10)
order_item_two = ReleaseOrderItem(
release_order=ReleaseOrder.objects.all()[0],
item=self.item_two,
purchase_order_item=self.purchase_order_item_two,
quantity=1,
value=Decimal('26.81'),
item_number=20)
order_item_three = ReleaseOrderItem(
release_order=ReleaseOrder.objects.all()[1],
item=self.item_three,
purchase_order_item=self.purchase_order_item_three,
quantity=20,
value=Decimal('1188.79'),
item_number=10)
self.assertEqual(ReleaseOrderItem.objects.count(), 3)
actual_order_item_one = ReleaseOrderItem.objects.get(
release_order=ReleaseOrder.objects.first(), item_number=10)
actual_order_item_two = ReleaseOrderItem.objects.get(
release_order=ReleaseOrder.objects.first(), item_number=20)
actual_order_item_three = ReleaseOrderItem.objects.get(
release_order=ReleaseOrder.objects.last(), item_number=10)
self.assert_release_order_items_are_equal(order_item_one,
actual_order_item_one)
self.assert_release_order_items_are_equal(order_item_two,
actual_order_item_two)
self.assert_release_order_items_are_equal(order_item_three,
actual_order_item_three)
def assert_consignees_are_equal(self, consignee_one, consignee_two):
self.assertEqual(consignee_one.name, consignee_two.name)
self.assertEqual(consignee_one.customer_id, consignee_two.customer_id)
self.assertEqual(consignee_one.type, consignee_two.type)
self.assertEqual(consignee_one.imported_from_vision,
consignee_two.imported_from_vision)
def assert_release_orders_are_equal(self, order_one, order_two):
self.assertEqual(order_one.order_number, order_two.order_number)
self.assertEqual(order_one.consignee_id, order_two.consignee_id)
self.assertEqual(order_one.delivery_date, order_two.delivery_date)
self.assertEqual(order_one.waybill, order_two.waybill)
self.assertEqual(order_one.sales_order_id, order_two.sales_order_id)
def assert_release_order_items_are_equal(self, order_item_one,
order_item_two):
self.assertEqual(order_item_one.release_order_id,
order_item_two.release_order_id)
self.assertEqual(order_item_one.item_id, order_item_two.item_id)
self.assertEqual(order_item_one.purchase_order_item_id,
order_item_two.purchase_order_item_id)
self.assertEqual(order_item_one.quantity, order_item_two.quantity)
self.assertEqual(order_item_one.value, order_item_two.value)
def setUp(self):
self.release_order_file_location = 'release_orders.xlsx'
work_book = Workbook()
sheet = work_book.add_sheet('Sheet 1')
self.header = ['Release Order Number', 'Release Order Item', 'Release Order Date', 'Recommended Delivery Date',
'Material', 'Material Description', 'Delivery Quantity', 'Value', 'Storage Location',
'Warehouse Number', 'Warehouse Description', 'Consignee', 'Consignee Name', 'Authorized Person',
'Sales Document', 'Purchasing Document', 'Delivery', 'Grant', 'WBS Element', 'Pick Status',
'Transfer Order Number', 'Transportation Planning Status', 'Waybill Number', 'Forwarder Name',
'Shipment End Date', 'Goods Issue Status', 'Goods Issue Date', 'Release Order Sub-Item',
'HigherLevelItemBatch', 'Release Order Type', 'Sales unit', 'Moving price', 'Plant',
'Plant Name', 'Storage Location Desc', 'Dest Warehouse Number', 'Dest Warehouse Description',
'Ship-to party', 'Means of Trans. ID', 'Program Officer', 'Sales Document Item',
'Purchasing Item', 'Reference document', 'Reference item', 'Delivery Item',
'Transfer Order Item', 'Forwarder Number', 'Goods Issue Number', 'Goods Issue Item', 'Batch',
'SLED/BBD', 'Actual End Planning Date', 'Check-in Date', 'Planned Shipment Start Date',
'Loading Start Date', 'Loading End Date', 'Actual Shipment Start Date',
'Shipment Completion Date', 'Shipment Days Difference', 'Goods Issue Days Difference',
'Handed-Over to IP Planned', 'Handed-Over to IP', 'Reason for Amendment', 'RO User Reference 1',
'RO User Reference 2', 'RO User Reference 3', 'RO User Reference 4', 'RO User Reference 5',
'WB User Reference 1', 'WB User Reference 2', 'WB User Reference 3', 'WB User Reference 4',
'WB User Reference 5']
self.first_row = ['54101099', '10', '08/01/2014', '08/01/2014', 'SL005144', 'Laptop Lenovo ThinkPad T510', '1',
'1167.66', '2611', '261', 'Kampala W1', 'L438000393', 'OYAM DISTRICT ADMIN',
'Nuhoddin Maarij', '20148031', '81018523', '56162712', 'SC130003', '4380/A0/04/107/002/012',
'C', '7732', 'C', '72081598', 'UNICEF - Kampala Uganda Kampala Country Office Uganda',
'08/05/2014', 'C', '8/20/2014', '0', '0', 'ZLO', 'EA', '1167.67', '5617', 'Uganda',
'Kampala W1-Prog', '', '', 'L438000393', '', 'Silvia Pasti', '10', '10', '', '1', '1', '1',
'F43801', '4900086016', '1', 'SYS0084421', '', '08/05/2014', '08/05/2014', '', '08/05/2014',
'08/05/2014', '08/05/2014', '08/05/2014', '', '15', '', '', '', '', '', '', '', '',
'CD 96-50U', 'UNICEF', 'Bongomin', '', '']
self.second_row = ['54101099', '20', '08/01/2014', '08/01/2014', 'SL002248', 'Laptop bag', '1', '26.81', '2611',
'261', 'Kampala W1', 'L438000393', 'OYAM DISTRICT ADMIN', 'Nuhoddin Maarij', '20148031',
'81018523', '56162712', 'SC130003', '4380/A0/04/107/002/012', 'C', '7732', 'C', '72081598',
'UNICEF - Kampala Uganda Kampala Country Office Uganda', '08/05/2014', 'C', '8/20/2014', '0',
'0', 'ZLO', 'EA', '26.81', '5617', 'Uganda', 'Kampala W1-Prog', '', '', 'L438000393', '',
'Silvia Pasti', '20', '20', '', '2', '2', '2', 'F43801', '4900086016', '2', 'SYS0084422', '',
'08/05/2014', '08/05/2014', '', '08/05/2014', '08/05/2014', '08/05/2014', '08/05/2014', '',
'15', '', '', '', '', '', '', '', '', 'CD 96-50U', 'UNICEF', 'Bongomin', '', '']
self.third_row = ['54101128', '20', '08/01/2014', '08/04/2014', 'S0000208',
'F-75 therap.diet sachet 102.5g/CAR-120', '20', '1188.79', '2611', '261', 'Kampala W1',
'L438000181', 'GULU HOSPITAL', 'NUHODDIN MAARIJ', '20147537', '45132639', '56165211',
'SC130708', '4380/A0/04/105/004/022', 'C', '7665', 'C', '72081746',
'Express Logistics Group Ltd.', '08/07/2014', 'C', '8/20/2014', '0', '0', 'ZLO', 'CAR',
'59.44', '5617', 'Uganda', 'Kampala W1-Prog', '', '', 'L438000181', '', 'PRAKASH LAMSAL',
'20', '20', '', '2', '2', '2', '2300027179', '4900086015', '2', '100314', '3/31/2016',
'08/07/2014', '08/07/2014', '', '08/07/2014', '08/07/2014', '08/07/2014', '08/07/2014', '',
'13', '', '', '', '', '', '', '', '', 'UAN 853F', 'EXPRESS LOGISTICS', '2MT', 'SAMUEL', '']
for row_index, row in enumerate([self.header, self.first_row, self.second_row, self.third_row]):
for col_index, item in enumerate(row):
sheet.write(row_index, col_index, item)
work_book.save(self.release_order_file_location)
self.facade = ReleaseOrderFacade(self.release_order_file_location)
self.order_data = [{'order_number': '54101099',
'sales_order': '20148031',
'consignee': 'L438000393',
'waybill': '72081598',
'recommended_delivery_date': '08/01/2014',
'items': [{'material_code': 'SL005144',
'description': 'Laptop Lenovo ThinkPad T510',
'quantity': '1',
'value': '1167.66',
'purchase_order': '81018523',
'order_number': '54101099',
'waybill': '72081598',
'sales_order': '20148031',
'consignee': 'L438000393',
'recommended_delivery_date': '08/01/2014'},
{'material_code': 'SL002248',
'description': 'Laptop bag',
'quantity': '1',
'value': '26.81',
'purchase_order': '81018523',
'order_number': '54101099',
'waybill': '72081598',
'sales_order': '20148031',
'consignee': 'L438000393',
'recommended_delivery_date': '08/01/2014'}]},
{'order_number': '54101128',
'sales_order': '20147537',
'consignee': 'L438000181',
'waybill': '72081746',
'recommended_delivery_date': '08/04/2014',
'items': [{'material_code': 'S0000208',
'description': 'F-75 therap.diet sachet 102.5g/CAR-120',
'quantity': '20',
'value': '1188.79',
'purchase_order': '45132639',
'order_number': '54101128',
'waybill': '72081746',
'sales_order': '20147537',
'consignee': 'L438000181',
'recommended_delivery_date': '08/04/2014'}]}]
class TestReleaseOrdersVisionFacade(TestCase):
def setUp(self):
self.release_order_file_location = 'release_orders.xlsx'
work_book = Workbook()
sheet = work_book.add_sheet('Sheet 1')
self.header = ['Release Order Number', 'Release Order Item', 'Release Order Date', 'Recommended Delivery Date',
'Material', 'Material Description', 'Delivery Quantity', 'Value', 'Storage Location',
'Warehouse Number', 'Warehouse Description', 'Consignee', 'Consignee Name', 'Authorized Person',
'Sales Document', 'Purchasing Document', 'Delivery', 'Grant', 'WBS Element', 'Pick Status',
'Transfer Order Number', 'Transportation Planning Status', 'Waybill Number', 'Forwarder Name',
'Shipment End Date', 'Goods Issue Status', 'Goods Issue Date', 'Release Order Sub-Item',
'HigherLevelItemBatch', 'Release Order Type', 'Sales unit', 'Moving price', 'Plant',
'Plant Name', 'Storage Location Desc', 'Dest Warehouse Number', 'Dest Warehouse Description',
'Ship-to party', 'Means of Trans. ID', 'Program Officer', 'Sales Document Item',
'Purchasing Item', 'Reference document', 'Reference item', 'Delivery Item',
'Transfer Order Item', 'Forwarder Number', 'Goods Issue Number', 'Goods Issue Item', 'Batch',
'SLED/BBD', 'Actual End Planning Date', 'Check-in Date', 'Planned Shipment Start Date',
'Loading Start Date', 'Loading End Date', 'Actual Shipment Start Date',
'Shipment Completion Date', 'Shipment Days Difference', 'Goods Issue Days Difference',
'Handed-Over to IP Planned', 'Handed-Over to IP', 'Reason for Amendment', 'RO User Reference 1',
'RO User Reference 2', 'RO User Reference 3', 'RO User Reference 4', 'RO User Reference 5',
'WB User Reference 1', 'WB User Reference 2', 'WB User Reference 3', 'WB User Reference 4',
'WB User Reference 5']
self.first_row = ['54101099', '10', '08/01/2014', '08/01/2014', 'SL005144', 'Laptop Lenovo ThinkPad T510', '1',
'1167.66', '2611', '261', 'Kampala W1', 'L438000393', 'OYAM DISTRICT ADMIN',
'Nuhoddin Maarij', '20148031', '81018523', '56162712', 'SC130003', '4380/A0/04/107/002/012',
'C', '7732', 'C', '72081598', 'UNICEF - Kampala Uganda Kampala Country Office Uganda',
'08/05/2014', 'C', '8/20/2014', '0', '0', 'ZLO', 'EA', '1167.67', '5617', 'Uganda',
'Kampala W1-Prog', '', '', 'L438000393', '', 'Silvia Pasti', '10', '10', '', '1', '1', '1',
'F43801', '4900086016', '1', 'SYS0084421', '', '08/05/2014', '08/05/2014', '', '08/05/2014',
'08/05/2014', '08/05/2014', '08/05/2014', '', '15', '', '', '', '', '', '', '', '',
'CD 96-50U', 'UNICEF', 'Bongomin', '', '']
self.second_row = ['54101099', '20', '08/01/2014', '08/01/2014', 'SL002248', 'Laptop bag', '1', '26.81', '2611',
'261', 'Kampala W1', 'L438000393', 'OYAM DISTRICT ADMIN', 'Nuhoddin Maarij', '20148031',
'81018523', '56162712', 'SC130003', '4380/A0/04/107/002/012', 'C', '7732', 'C', '72081598',
'UNICEF - Kampala Uganda Kampala Country Office Uganda', '08/05/2014', 'C', '8/20/2014', '0',
'0', 'ZLO', 'EA', '26.81', '5617', 'Uganda', 'Kampala W1-Prog', '', '', 'L438000393', '',
'Silvia Pasti', '20', '20', '', '2', '2', '2', 'F43801', '4900086016', '2', 'SYS0084422', '',
'08/05/2014', '08/05/2014', '', '08/05/2014', '08/05/2014', '08/05/2014', '08/05/2014', '',
'15', '', '', '', '', '', '', '', '', 'CD 96-50U', 'UNICEF', 'Bongomin', '', '']
self.third_row = ['54101128', '20', '08/01/2014', '08/04/2014', 'S0000208',
'F-75 therap.diet sachet 102.5g/CAR-120', '20', '1188.79', '2611', '261', 'Kampala W1',
'L438000181', 'GULU HOSPITAL', 'NUHODDIN MAARIJ', '20147537', '45132639', '56165211',
'SC130708', '4380/A0/04/105/004/022', 'C', '7665', 'C', '72081746',
'Express Logistics Group Ltd.', '08/07/2014', 'C', '8/20/2014', '0', '0', 'ZLO', 'CAR',
'59.44', '5617', 'Uganda', 'Kampala W1-Prog', '', '', 'L438000181', '', 'PRAKASH LAMSAL',
'20', '20', '', '2', '2', '2', '2300027179', '4900086015', '2', '100314', '3/31/2016',
'08/07/2014', '08/07/2014', '', '08/07/2014', '08/07/2014', '08/07/2014', '08/07/2014', '',
'13', '', '', '', '', '', '', '', '', 'UAN 853F', 'EXPRESS LOGISTICS', '2MT', 'SAMUEL', '']
for row_index, row in enumerate([self.header, self.first_row, self.second_row, self.third_row]):
for col_index, item in enumerate(row):
sheet.write(row_index, col_index, item)
work_book.save(self.release_order_file_location)
self.facade = ReleaseOrderFacade(self.release_order_file_location)
self.order_data = [{'order_number': '54101099',
'sales_order': '20148031',
'consignee': 'L438000393',
'waybill': '72081598',
'recommended_delivery_date': '08/01/2014',
'items': [{'material_code': 'SL005144',
'description': 'Laptop Lenovo ThinkPad T510',
'quantity': '1',
'value': '1167.66',
'purchase_order': '81018523',
'order_number': '54101099',
'waybill': '72081598',
'sales_order': '20148031',
'consignee': 'L438000393',
'recommended_delivery_date': '08/01/2014'},
{'material_code': 'SL002248',
'description': 'Laptop bag',
'quantity': '1',
'value': '26.81',
'purchase_order': '81018523',
'order_number': '54101099',
'waybill': '72081598',
'sales_order': '20148031',
'consignee': 'L438000393',
'recommended_delivery_date': '08/01/2014'}]},
{'order_number': '54101128',
'sales_order': '20147537',
'consignee': 'L438000181',
'waybill': '72081746',
'recommended_delivery_date': '08/04/2014',
'items': [{'material_code': 'S0000208',
'description': 'F-75 therap.diet sachet 102.5g/CAR-120',
'quantity': '20',
'value': '1188.79',
'purchase_order': '45132639',
'order_number': '54101128',
'waybill': '72081746',
'sales_order': '20147537',
'consignee': 'L438000181',
'recommended_delivery_date': '08/04/2014'}]}]
def tearDown(self):
os.remove(self.release_order_file_location)
ReleaseOrderItem.objects.all().delete()
ReleaseOrder.objects.all().delete()
Item.objects.all().delete()
SalesOrder.objects.all().delete()
Consignee.objects.all().delete()
def test_can_load_release_order_data(self):
release_order_data = self.facade.load_order_data()
self.assertEqual(release_order_data, self.order_data)
def test_save_release_order_data(self):
SalesOrderFactory(order_number='20148031')
SalesOrderFactory(order_number='20147537')
ConsigneeFactory(customer_id='L438000393')
ConsigneeFactory(customer_id='L438000181')
ItemFactory(material_code='SL005144')
ItemFactory(material_code='SL002248')
ItemFactory(material_code='S0000208')
self.facade.save_order_data(self.order_data)
self.assertEqual(ReleaseOrder.objects.count(), 2)
self.assertEqual(ReleaseOrderItem.objects.count(), 3)
first_order = ReleaseOrder.objects.get(order_number='54101099')
self.assertEqual(first_order.waybill, '72081598')
self.assertEqual(first_order.sales_order.order_number, '20148031')
formatted_date = first_order.delivery_date.strftime("%m/%d/%Y")
self.assertEqual(formatted_date, '08/01/2014')
self.assertEqual(first_order.consignee.customer_id, 'L438000393')
first_item = first_order.releaseorderitem_set.first()
self.assertEqual(first_item.item.material_code, 'SL005144')
self.assertEqual(first_item.purchase_order, '81018523')
self.assertEqual(str(first_item.value), '1167.66')
self.assertEqual(str(int(first_item.quantity)), '1')
last_order = ReleaseOrder.objects.get(order_number='54101128')
self.assertEqual(last_order.waybill, '72081746')
self.assertEqual(last_order.sales_order.order_number, '20147537')
formatted_date = last_order.delivery_date.strftime("%m/%d/%Y")
self.assertEqual(formatted_date, '08/04/2014')
self.assertEqual(last_order.consignee.customer_id, 'L438000181')
last_item = last_order.releaseorderitem_set.first()
self.assertEqual(last_item.item.material_code, 'S0000208')
self.assertEqual(last_item.purchase_order, '45132639')
self.assertEqual(str(last_item.value), '1188.79')
self.assertEqual(str(int(last_item.quantity)), '20')
def test_should_load_release_orders_from_excel_and_save(self):
self.facade.load_order_data = MagicMock(return_value=self.order_data)
self.facade.save_order_data = MagicMock(return_value=None)
self.facade.import_orders()
self.facade.load_order_data.assert_called_with()
self.facade.save_order_data.assert_called_with(self.order_data)
