Prerequisite - RESTful Consumer Exercise 2

Prerequisites for Excercise 2

This exercise will simulate an ERP response to retrieve multiple production orders. We will retrieve the production orders and save them as Work Order objects in the MES software.

This provider assumes you have the OEE and Production modules installed with an MES database. If that is not the case, investigate the Getting Set Up section of the Practical Tutorial.
This provider assumes you have OEE Materials assigned to Production Lines. If that is not the case, investigate the OEE Practical Tutorial.
Exercise 2 will consume an example endpoint on your local server. Ensure you have the following RESTful Provider on your system:

Navigate to Providers → RESTful Endpoints → Instructor Tools → getProductionOrders

If this exists, nothing further is needed. Skip to the next page.
If this does not exist, create a new structure with the endpoint to match:
Open the endpoint getProductionOrders and match the following settings:
Paste the following into the do_GET(request) script function:

do_GET body

Copy Code

Python

    
    req_path = request['path']
    req_query = request['query']
    req_headers = request['headers']
    req_metadata = request['remote']
    req_body = request['body']
    res_headers = {}
    
    eqPath =  str(request['query']['path'])
    line = eqPath.split('\\')[3:][0]
    
    opsList =  system.mes.getAvailableOperations(eqPath, '', False, False)
    if opsList.size() == 0:
        res_code = 400
        res_content = {'error': "No Operations Configured on Line"}
        return {'code': res_code, 'headers': res_headers, 'content': res_content}
    
    matList = []
    for item in opsList:
        matList.append(item.getName().split('-')[0])
        
    import random
    
    firstStart = system.date.addHours(system.date.now(), 4)
    firstEnd = system.date.addHours(firstStart, 1)
    secondStart = system.date.addMinutes(firstEnd, 5)
    secondEnd = system.date.addHours(secondStart, 2)
    
    #generating wo numbers
    firstId = system.date.toMillis(system.date.now())
    secondId = firstId + 1
    
    res_content = {"Data": 
      {  
        "lines": [
          {
            "line": line,
                  "scheduled_items": [
                    {
                      "duration": 2.1171843383,
                      "end_dtm": firstEnd,
                      "id": system.date.toMillis(firstStart),
                      "item_type": "WORK_ORDER",
                      "newDuration": 0.0,
                      "overflow": False,
                      "related_data": [{
                        "ct_units": 0,
                        "id": firstId,
                        "item_code": random.choice(matList),
                        "item_desc1": "Product Description",
                        "item_desc2": "",
                        "item_net_weight": 0.0,
                        "item_size": random.random(),
                        "order_qty": 1200.0,
                        "remarks": "",
                        "routing_code": "Y901C721F8",
                        "site": "11",
                        "status_code": "C",
                        "type_code": "S"
                      }],
                      "sequence": 2,
                      "start_dtm": firstStart
                    },
                    {
                      "duration": 2.1171843383,
                      "end_dtm": secondEnd,
                      "id": system.date.toMillis(secondStart),
                      "item_type": "WORK_ORDER",
                      "newDuration": 0.0,
                      "overflow": False,
                      "related_data": [{
                        "ct_units": 0,
                        "id": secondId,
                        "item_code": random.choice(matList),
                        "item_desc1": "Great Product",
                        "item_desc2": "",
                        "item_net_weight": 0.0,
                        "item_size": 0.0,
                        "order_qty": 3600,
                        "remarks": "",
                        "routing_code": "Y901C721F8",
                        "site": "11",
                        "status_code": "C",
                        "type_code": "S"
                      }],
                      "sequence": 2,
                      "start_dtm": secondStart
                    }
                  ]
           }
        ]
      }
    }
    
    res_code = 200
    
    return {'code': res_code, 'headers': res_headers, 'content': res_content}