item_height = None,
item_width = None,
item_volume = None,
item_manufacturer = "supplier")
salt = physicalGood_class( item_code = "0002",
item_description = "salt",
item_weight = None,
item_length = None,
item_height = None,
item_width = None,
item_volume = None,
item_manufacturer = "supplier")
# %% define entities
tomato_supplier= physicalGood("tomato", tomato)
basil_supplier= physicalGood("basil",basil)
salt_supplier= physicalGood("salt", salt)
tomato_sauce= physicalGood("tomato_sauce")
tomato_bottle= physicalGood("tomato_product", tomato_sauce_bottle_class)
tomato_pack_6_bottles= physicalGood("tomato_pack_6_bottles",tomato_sauce_6bottle_class)
# %% define nodes
mixing_machine = node(nodeId = '0001',
nodeNet='production_plant',
nodeType='ProductionMachine',
nodeName='Tomato mixer 100',
geo_position=(41.413896,15.056329),
plant_position = (1000.0, 2500.0, 0.0))
boiling_machine = node(nodeId = '0002',
'basil': basil,
'salt': salt,
}
# %% generate inbound list
listNumber = 'LIST_000001'
pickerCode = 'OPERATOR_02'
source = ('truck', 'inbound')
D_list = pd.DataFrame(columns=['epc', 'quantity'])
for i in range(0, num_inbound_SKUs):
sku = random.choice(list(sku_master_file.keys()))
EPCs = physicalGood(f"prod_{i}", sku_master_file[sku])
temp = pd.DataFrame([EPCs], columns=['epc'])
temp['quantity'] = np.random.uniform(min_qty, max_qty)
D_list = D_list.append(temp)
# %% define control points
acceptanceAreaNode = node(nodeId='wh_01',
nodeNet='warehouse',
nodeType='AcceptanceArea',
nodeName='Material receiving - inbound',
geo_position=(41.413896, 15.056329),
plant_position=(150.0, 200.0, 0.0))
qualityControlAreaNode = node(nodeId='wh_02',
nodeNet='warehouse',
nodeType='AcceptanceArea',
num_containers = 120
# %% generate inbound list
bol_number="R_HK_037672"
listNumber='PICKLIST_00023481'
pickerCode='CRANE_006'
source=('terminal','outbound')
D_list = pd.DataFrame(columns=['epc','quantity'])
for i in range(0,num_containers):
EPCs= physicalGood(f"container_{i}")
temp = pd.DataFrame([EPCs],columns=['epc'])
D_list = D_list.append(temp)
# %% define control points
loadingPort = node( nodeId='H_port',
nodeNet='distribution_network',
nodeType='DockingArea',
nodeName='Export terminal Asia',
geo_position=(51.9496,4.1453),
plant_position = (1000.0, 2500.0, 0.0))
dischargingPort = node(nodeId='HK_port',
nodeNet='distribution_network',
from database.entities.node import node
from database.steps.object_DELETE import removing
from database.steps.object_OBSERVE import replacing
from database.steps.object_ADD import installing
# %% define control points
maintenanceReport = "REP_000001"
operatorId = "MAIN_OPER_005"
milling_machine = node(nodeId='MACH_0302',
nodeNet='production_plant',
nodeType='ProductionMachine',
nodeName='Pallet rack',
geo_position=(41.413896, 15.056329),
plant_position=(1000.0, 2500.0, 0.0))
old_part = physicalGood("electronic_board_01")
new_part = physicalGood("electronic_board_02")
# %%
result = removing(physicalGoodDict=old_part.__dict__,
nodeDict=milling_machine.__dict__,
quantity=1,
quantity_udm='pz',
disposition='damaged',
bizTransactionList=maintenanceReport,
sourceDestList=[],
ilmd=operatorId,
extensions={},
dbname="EPCIS_DB")
nodeNet='distribution_network',
nodeType='Truck',
nodeName='MarioTruck_01',
)
# %% generate outbound list
listNumber = 'PICKLIST_00023481'
pickerCode = 'PICKER_006'
source = ('warehouse', 'outbound')
D_list = pd.DataFrame(columns=['epc', 'quantity'])
for i in range(0, num_outbound_SKUs):
sku = random.choice(list(sku_master_file.keys()))
EPCs = physicalGood(f"prod_{i}", sku_master_file[sku])
temp = pd.DataFrame([EPCs], columns=['epc'])
temp['quantity'] = np.random.uniform(min_qty, max_qty)
D_list = D_list.append(temp)
# %% accept epc
for index, row in D_list.iterrows():
results = picking(physicalGoodDict=row['epc'].__dict__,
nodeDict=storageAreaNode.__dict__,
quantity=row['quantity'],
quantity_udm='Kg',
disposition='in_progress',
bizTransactionList=listNumber,
sourceDestList=[],
ilmd=pickerCode,
# %% export nodes
D_results = pd.DataFrame()
for singleNode in nodesDict:
node_row = pd.DataFrame([nodesDict[singleNode].__dict__])
D_results = D_results.append(node_row)
D_results = D_results.reset_index(drop=True)
# %% generate EPCs
EPCsDict={}
for i in range(0,num_EPCs):
EPCsDict[i] = physicalGood(f"prod_{i}")
# %% define objectEvents
#add objsect
for i in range (0,num_obj_ADD):
#random choose a node
node_key = random.choice(list(nodesDict.keys()))
chooseNode = nodesDict[node_key]
#random coose an epc
epc_key = random.choice(list(EPCsDict.keys()))
chooseEpc= EPCsDict[epc_key]