MES系统SCADA数据采集平台JSON数据解释

admin · 发表于 2019-9-3 11:34:11

MES系统SCADA数据采集平台都会以JSON数据格式返回
以第一枪的数据为例：

此时程序界面显示如下：

总体结构如下：

原始数据如下：

{
"tag": 418,
"device": {
"tag": 418,
"line": "3A",
"section": "TEST",
"group": "BT",
"station_num": "9",
"w_station": "192.168.2.10",
"mygroup": "BT",
"mo_date": "19810920",
"w_section": 12
},
"emp": {
"tag": 418,
"empno": "GNET",
"emp": "GNET",
"empname": "GNET",
"empbc": "GNET",
"RandID": 1567481306.3926
},
"product": {
"tag": 418,
"model": "NAGOMES",
"mo_type": "",
"version_code": "",
"wo": "99999999",
"sn": "F1111111",
"bc": "F1111111"
},
"sfc": {
"tag": 418,
"port1": "5",
"port2": 0
},
"xw": {
"tag": 418,
"version": "418",
"xw": "5",
"smo_work": [
{
"STATION_TYPE": "5",
"WORK_TYPE": "1",
"WORK_TYPE_INDEX": "2",
"SECOND": "0",
"FORK": "0",
"LENGTH": "0",
"RULE": "3",
"LAST": "0",
"RUN_PRIOR": "1",
"LINE_NAME": "Default",
"WORK_TYPE_NAME": "输入SN",
"CODE": "SN",
"PARAM": "SN",
"PARAM2": "序号",
"DATA": "F1111111"
},
{
"STATION_TYPE": "5",
"WORK_TYPE": "12",
"WORK_TYPE_INDEX": "3",
"SECOND": "15",
"FORK": "0",
"LENGTH": "0",
"RULE": "2",
"LAST": "0",
"RUN_PRIOR": "1",
"LINE_NAME": "Default",
"WORK_TYPE_NAME": "输入客戶组件SN",
"CODE": "CPS",
"PARAM": "CPS",
"PARAM2": "CPS",
"DATA": []
},
{
"STATION_TYPE": "5",
"WORK_TYPE": "15",
"WORK_TYPE_INDEX": "4",
"SECOND": "12",
"FORK": "12",
"LENGTH": "0",
"RULE": "3",
"LAST": "1",
"RUN_PRIOR": "1",
"LINE_NAME": "Default",
"WORK_TYPE_NAME": "输入结束指令",
"CODE": "END",
"PARAM": "CM2",
"PARAM2": "CM2",
"DATA": ""
}
],
"smo_sp": {
"1": [
{
"WORK_TYPE": "1",
"STOREDPROC": "INPUT_SN_FIRST",
"STOREDPROC_INDEX": "1",
"RETURN_FLAG": "1",
"RandID": 1567481306.3926
},
{
"WORK_TYPE": "1",
"STOREDPROC": "CHECK_ROUTE",
"STOREDPROC_INDEX": "2",
"RETURN_FLAG": "1",
"RandID": 1567481306.3926
},
{
"WORK_TYPE": "1",
"STOREDPROC": "DEL_TEMP_CPS",
"STOREDPROC_INDEX": "3",
"RETURN_FLAG": "1",
"RandID": 1567481306.3926
}
],
"6": [
{
"WORK_TYPE": "6",
"STOREDPROC": "CHECK_EMP",
"STOREDPROC_INDEX": "1",
"RETURN_FLAG": "1",
"RandID": ""
}
],
"12": [
{
"WORK_TYPE": "12",
"STOREDPROC": "CHECK_KP_VALID",
"STOREDPROC_INDEX": "1",
"RETURN_FLAG": "1",
"RandID": ""
}
],
"15": [
{
"WORK_TYPE": "15",
"STOREDPROC": "CHECK_END_KP",
"STOREDPROC_INDEX": "1",
"RETURN_FLAG": "1",
"RandID": ""
},
{
"WORK_TYPE": "15",
"STOREDPROC": "INSERT_R108_KP",
"STOREDPROC_INDEX": "2",
"RETURN_FLAG": "1",
"RandID": ""
},
{
"WORK_TYPE": "15",
"STOREDPROC": "ASSY_INPUT",
"STOREDPROC_INDEX": "3",
"RETURN_FLAG": "1",
"RandID": ""
},
{
"WORK_TYPE": "15",
"STOREDPROC": "RECORD_SP",
"STOREDPROC_INDEX": "4",
"RETURN_FLAG": "1",
"RandID": ""
}
]
}
},
"dta": {
"tag": 418,
"version": "418",
"xw": "5",
"stepnow": 1,
"data": {
"SN": "F1111111",
"CPS": [],
"END": ""
}
},
"isDebug": true,
"tick": 0.188,
"ip": "192.168.2.10",
"id": "190829-00049",
"stepnow": 1,
"stepcode": "CPS",
"data": "F1111111",
"res": "OK",
"res2": "",
"command": null,
"cursor": [],
"prompt": "请扫描 CPS ?",
"debug": {
"log": [
"sfc.smo.device.config found in mem!",
"SMO_02_EMP found in mem!",
"mes database connect ok!",
"sfc.smo.device.sfc not in mem!",
"[sp_check_sp]Array\n(\n [tag] => 418\n [bc] => \n [port1] => 5\n)\n",
"current xw=5",
"XW=5 not in mem!",
"SMO_05_DTA not in mem!"
],
"sql": [
{
"sp": "INPUT_SN_FIRST",
"sql": "call sfc.INPUT_SN_FIRST('3A','TEST','BT','192.168.2.10','F1111111',@res)",
"sql1": "select @res res,@command1 command,@cursor1 cursor_out from dual",
"res": "OK",
"command": null,
"str": "开始执行execute_sp",
"tick": 0.002000093460083,
"cursor_out": null
},
{
"sp": "CHECK_ROUTE",
"sql": "call sfc.CHECK_ROUTE('3A','BT','F1111111',@res)",
"sql1": "select @res res,@command1 command,@cursor1 cursor_out from dual",
"res": "OK",
"command": null,
"str": "开始执行execute_sp",
"tick": 0.00099992752075195,
"cursor_out": null
},
{
"sp": "DEL_TEMP_CPS",
"sql": "call sfc.DEL_TEMP_CPS('F1111111','9','BT',@res)",
"sql1": "select @res res,@command1 command,@cursor1 cursor_out from dual",
"res": "OK",
"command": null,
"str": "开始执行execute_sp",
"tick": 0.023999929428101,
"cursor_out": null
}
]
},
"time": "2019-09-03 11:28:30190829-00049"
}

复制代码

zhgc · 发表于 2021-5-10 18:19:48

{
"tag": 418,
"device": {
      "tag": 418,
      "line": "L1",
      "section": "TEST",
      "group": "VI",
      "station_num": "534",
      "w_station": "192.168.84.25",
      "mygroup": "VI",
      "mo_date": "19810920",
      "w_section": 12
},
"emp": {
      "tag": 418,
      "empno": "PD",
      "emp": "PD",
      "empname": "PD",
      "empbc": "PD",
      "RandID": 1620641763.0679
},
"product": {
      "tag": 418,
      "model": "GVPH04-HBL-PPC1",
      "mo_type": "",
      "version_code": "",
      "wo": "1000025556",
      "sn": "VPH04EHBLD182100007",
      "bc": "VPH04EHBLD182100007"
},
"sfc": {
      "tag": 418,
      "port1": "28",
      "port2": 0
},
"xw": {
      "tag": 418,
      "version": "418",
      "xw": "28",
      "smo_work": [
         {
            "STATION_TYPE": "28",
            "WORK_TYPE": "5",
            "WORK_TYPE_INDEX": "2",
            "SECOND": "1",
            "FORK": "1",
            "LENGTH": "0",
            "RULE": "2",
            "LAST": "0",
            "RUN_PRIOR": "1",
            "LINE_NAME": "Default",
            "WORK_TYPE_NAME": "输入不良现象代码",
            "CODE": "EC",
            "PARAM": "EC",
            "PARAM2": "不良代码",
            "DATA": []
         },
         {
            "STATION_TYPE": "28",
            "WORK_TYPE": "1",
            "WORK_TYPE_INDEX": "3",
            "SECOND": "5",
            "FORK": "0",
            "LENGTH": "0",
            "RULE": "3",
            "LAST": "1",
            "RUN_PRIOR": "1",
            "LINE_NAME": "Default",
            "WORK_TYPE_NAME": "输入SN",
            "CODE": "SN",
            "PARAM": "SN",
            "PARAM2": "序号",
            "DATA": [
                  "VPH04EHBLD182100007"
            ]
         }
      ],
      "smo_sp": {
         "1": [
            {
                  "WORK_TYPE": "1",
                  "STOREDPROC": "CHECK_SN",
                  "STOREDPROC_INDEX": "1",
                  "RETURN_FLAG": "1",
                  "RandID": ""
            },
            {
                  "WORK_TYPE": "1",
                  "STOREDPROC": "TEST_INPUT_MAN_ONLY_QTY",
                  "STOREDPROC_INDEX": "2",
                  "RETURN_FLAG": "1",
                  "RandID": ""
            },
            {
                  "WORK_TYPE": "1",
                  "STOREDPROC": "RECORD_SP",
                  "STOREDPROC_INDEX": "3",
                  "RETURN_FLAG": "1",
                  "RandID": ""
            }
         ],
         "5": [
            {
                  "WORK_TYPE": "5",
                  "STOREDPROC": "CHECK_EC",
                  "STOREDPROC_INDEX": "1",
                  "RETURN_FLAG": "1",
                  "RandID": ""
            }
         ],
         "6": [
            {
                  "WORK_TYPE": "6",
                  "STOREDPROC": "CHECK_EMP",
                  "STOREDPROC_INDEX": "1",
                  "RETURN_FLAG": "1",
                  "RandID": ""
            }
         ]
      }
},
"dta": {
      "tag": 418,
      "version": "418",
      "xw": "28",
      "stepnow": 0,
      "data": {
         "EC": [],
         "SN": "VPH04EHBLD182100007"
      }
},
"isDebug": true,
"tick": 0.066,
"ip": "192.168.84.25",
"id": "210507-00044",
"stepnow": 0,
"stepcode": "EC",
"data": "VPH04EHBLD182100007",
"res": "OK,OK",
"res2": " NO EC",
"command": null,
"cursor": [],
"prompt": "请扫描 EC ?",
"debug": {
      "log": [
         "sfc.smo.device.config found in mem!",
         "SMO_02_EMP found in mem!",
         "mes database connect ok!",
         "sfc.smo.device.sfc not in mem!",
         "[sp_check_sp]Array\n(\n [tag] => 418\n [bc] => \n [port1] => 28\n)\n",
         "current xw=28",
         "XW=28 not in mem!",
         "SMO_05_DTA not in mem!",
         "SP EXCEPT JUMP!",
         "==Fork JUMP==1!",
         "==Fork Execute==!",
         "##sta0rt clear"
      ],
      "sql": [
         {
            "sp": "CHECK_EC",
            "sql": "call sfc.CHECK_EC('VPH04EHBLD182100007',@res)",
            "sql1": "select @res res,@command1 command,@cursor1 cursor_out from dual",
            "res": " NO EC",
            "command": null,
            "str": "开始执行execute_sp",
            "tick": 0.0039999485015869,
            "cursor_out": null
         },
         {
            "sp": "CHECK_SN",
            "sql": "call sfc.CHECK_SN('VPH04EHBLD182100007',@res)",
            "sql1": "select @res res,@command1 command,@cursor1 cursor_out from dual",
            "res": "OK",
            "command": null,
            "str": "开始执行execute_sp",
            "tick": 0.0030012130737305,
            "cursor_out": null
         },
         {
            "sp": "TEST_INPUT_MAN_ONLY_QTY",
            "sql": "call sfc.TEST_INPUT_MAN_ONLY_QTY('L1','TEST','192.168.84.25',now(),'N/A','VPH04EHBLD182100007','19810920','12','VI',@res,'PD')",
            "sql1": "select @res res,@command1 command,@cursor1 cursor_out from dual",
            "res": "OK",
            "command": null,
            "str": "开始执行execute_sp",
            "tick": 0.02000093460083,
            "cursor_out": null
         },
         {
            "sp": "RECORD_SP",
            "sql": "call sfc.RECORD_SP('VPH04EHBLD182100007','VPH04EHBLD182100007','534','VI',@res)",
            "sql1": "select @res res,@command1 command,@cursor1 cursor_out from dual",
            "res": "OK,OK",
            "command": null,
            "str": "开始执行execute_sp",
            "tick": 0.003000020980835,
            "cursor_out": null
         }
      ]
},
"sound": 1,
"time": "2021-05-10 18:16:30"
}

		自动登录	找回密码
密码			立即注册

MES系统SCADA数据采集平台JSON数据解释

浏览过的版块