def put_psn(client, sn): info = json_post(client, host_graphdbget(), { "n": "task", "obj": "uid,sn", "opt": { "and": [{ "eq": "sn", "v": sn }] } }) uid = info[0]["uid"] result = json_post(client, host_graphdb(), { "a": [{ "v": [[{ "k": "sn", "v": sn }]], "u": uid, "n": "pcode" }] }) if result == "Success": return result else: return "Error"
def get_plan(client): data = mq_get(client, "MES.MEB.ASSEMBLE.PLAN.SEND") if data is None: return start = datetime.datetime.strptime(data["PT"], "%Y%m%d%H%M%S") diff = datetime.timedelta(minutes=15) pstart = start.strftime("%Y-%m-%dT%H:%M:%S") pend = (start + diff).strftime("%Y-%m-%dT%H:%M:%S") sn = data["CID"] ret = json_post(client, host_real_task(), { "sn": sn, "tsn": data["TSN"], "pstart": str(pstart), "pend": str(pend), "pnum": 1, "info": [ {"k": "ig2", "v": data["1G2"]}, {"k": "288", "v": data["288"]}, {"k": "gbt", "v": data["GBT"]}, {"k": "sqr", "v": data["SQR"]}, {"k": "prn", "v": data["PRN"]}, {"k": "tsn", "v": data["TSN"]} ] }) if ret != "Success": return ret = json_post(client, host_graphdbget(), { "n": "task", "obj": "uid,sn", "opt": { "and": [{"eq": "sn", "v": sn}] } }) if ret is None: return uid = ret[0]["uid"] ret = json_post(client, host_graphdb(), { "a": [{ "u": uid, "n": "pcode", "v": [[{"k": "sn", "v": sn}]] }] }) if ret != "Success": return ret = json2xml(client, "ack", "") mq_put("MES.MEB.ASSEMBLE.PLAN.ACK", ret)
def get_snstatus(rec): for i in range(len(rec)): sn = get_item(rec[i], u"WorkOrderNo") status = get_item(rec[i], u"Status") status_list = ["open", "close"] # only support such if status not in status_list: print(status) return { "Result": False, "Message": "Error no such status", "Resultint": 2000 } # info = json_requests_post("http://47.96.151.120/graphdb/get/line-two",{ info = json_requests_post( host_graphdbget(), { "n": "task", "obj": "sn,uid,state", "opt": { "and": [{ "eq": "sn", "v": sn }] } }) print(info) state = get_item(info[0], "state") uid = get_item(info[0], "uid") if status == state: if i >= len(rec) - 1: return {"Result": True, "Message": "ok", "Resultint": 1000} else: # data = json_requests_post("http://47.96.151.120/graphdb/md",{ data = json_requests_post( host_graphdb(), { "m": [{ "u": uid, "v": [{ "k": "sn", "v": sn }, { "k": "state", "v": status }] }] }) print(data) if data == "Success": if i >= len(rec) - 1: return {"Result": True, "Message": "ok", "Resultint": 1000} else: return {"Result": False, "Message": "error", "Resultint": 2000}
def get_plan(rec): line = get_item(rec, "ProdLineCode") sn = get_item(rec, "WorkOrderNo") pnum = get_item(rec, "Qty") tsn = get_item(rec, "TechnologyNo") pstart = get_item(rec, "StartTime") pend = get_item(rec, "EndTime") print(tsn,sn,pnum,pstart,pend) if tsn and sn and pnum and pstart and pend: print(tsn,sn,pnum,pstart,pend) else: return {"Result":False,"Message":"has null value","Resultint":2000} if tsn : uidinfo = json_requests_post(host_graphdbget(),{ "n":"tech", "obj":"uid,sn", "opt":{ "and":[{ "eq":"sn", "v":tsn }] } }) uid = uidinfo[0]["uid"] if not uid: return {"Result": False, "Message": "no such Technology", "Resultint": 2000} info = json_requests_post(host_graphdb(), { "a":[{ "u":"line-one", "n":"task", "v":[[ {"k":"sn","v":sn}, {"k":"tech","u":uid}, {"k":"pstart","v":pstart}, {"k":"pend","v":pend}, {"k":"pnum","v":pnum}, {"k":"state","v":"open"}, {"k":"linecode","v":line} ]] }]}) if info == "Success": return {"Result": True, "Message": info , "Resultint": 1000} else: return {"Result": False, "Message": "info error", "Resultint": 2000}
def get_psn(rec): for i in range(len(rec)): sn = get_item(rec[i], "WorkOrderNo") psn = get_item(rec[i], "SerialNumber") if sn and psn: print(sn, psn) else: return { "Result": False, "Message": "has null value", "Resultint": 2000 } uidinfo = json_requests_post(host_graphdbget(), { "n": "task", "obj": "uid,sn", "opt": { "and": [{ "eq": "sn", "v": sn }] } }) uid = uidinfo[0]["uid"] # psnresult = json_requests_post("http://47.96.151.120/graphdb/md",{ psnresult = json_requests_post( host_graphdb(), {"a": [{ "v": [[{ "k": "sn", "v": psn }]], "u": uid, "n": "pcode" }]}) print(psnresult) if psnresult == "Success": if i >= len(rec) - 1: print(i) return {"Result": True, "Message": "ok", "Resultint": 1000} else: return { "Result": False, "Message": "send error", "Resultint": 2000 }
def get_plan(client, tab, cfg, rec): st = None if tab in cfg: st = cfg[tab] #tsn = rec["tsn"] tsn = "11G 915 911" sn = rec["CID"] pt = rec["PT"] ig2 = rec["1G2"] b288 = rec["288"] gbt = rec["GBT"] pstar = datetime.datetime.strptime(pt, "%Y%m%d%H%M%S") nedtime = datetime.timedelta(minutes=15) pen = (pstar + nedtime).strftime("%Y-%m-%dT%H:%M:%S") pstart = str(pstar.strftime("%Y-%m-%dT%H:%M:%S")) pend = str(pen) if st is None: uidinfo = json_post(client, host_graphdbget(), { "n": "tech", "obj": "uid,sn", "opt": { "and": [{ "eq": "sn", "v": tsn }] } }) uid = uidinfo[0]["uid"] info = json_post( client, host_graphdb(), { "a": [{ "u": "line-one", "n": "task", "v": [[{ "k": "sn", "v": sn }, { "k": "tech", "u": uid }, { "k": "pstart", "v": pstart }, { "k": "pend", "v": pend }, { "k": "pnum", "v": "1" }, { "k": "state", "v": "open" }, { "k": "ig2", "v": ig2 }, { "k": "288", "v": b288 }, { "k": "gbt", "v": gbt }]] }] }) if info == "Success": return info