Beispiel #1
0
    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)