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 post_snstatus(client,cfg): info = json_post(client,host_graphdbget(),{ # info = json_post(client, "http://47.96.151.120/graphdb/get/line-two", { "n": "task", "obj": "sn,uid,state", "opt": { "has":"sn" } }) print(info) for i in info: sn = get_item(i, "sn") state = get_item(i ,"state") snstatus = cfg["snstatus"] if i in range(len(snstatus)): if sn == snstatus[i]["sn"] and state == snstatus[i]["state"]: continue else: now_time = datetime.datetime.now() Tim = datetime.datetime.strftime(now_time, '%Y-%m-%d %H:%M:%S') info = json_requests_post("http://10.106.11.42:8049/restful/prod-plan/work-order-service/sync/status",[{ "workOrderNo":sn, "prodLineCode":"PL02", "status":state, "siteCode":"3310", "userNo":"AMES", "time":Tim }]) if info["result"]: print(info) snstatus[i]["state"] = state
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_module(rec): for i in range(len(rec)): prodlinecode = get_item(rec[i], "ProdLineCode") modulesn = get_item(rec[i], "ModuleSn") voltage = get_item(rec[i], "Voltage") maxvoltage = get_item(rec[i], "MaxVoltage") minvoltage = get_item(rec[i], "MinVoltage") resistance = get_item(rec[i], "Resistance") maxresistance = get_item(rec[i], "MaxResistance") minresistance = get_item(rec[i], "MinResistance") insulationvalue = get_item(rec[i], "InsulationValue") leakcurrent = get_item(rec[i], "LeakCurrent") singlevoltage = get_item(rec[i], "SingleVoltage") voltagediffer = get_item(rec[i], "VoltageDiffer") differntc = get_item(rec[i], "DifferNTC") resultmsg = get_item(rec[i], "ResultMsg") userno = get_item(rec[i], "UserNo") timein = get_item(rec[i], "Time") if modulesn and resultmsg and timein and voltage and prodlinecode and maxvoltage and minvoltage and resistance and maxresistance and minresistance and insulationvalue and leakcurrent and singlevoltage and voltagediffer and differntc and userno: print(modulesn, resultmsg) else: return { "Result": False, "Message": "has null value", "Resultint": 2000 } # global recresult recresult = json_requests_post( host_machine(), { "op010_op010_psn": modulesn, "op010_op010_moduleinfo": [{ "prodlinecode": prodlinecode, "voltage": voltage, "maxvoltage": maxvoltage, "minvoltage": minvoltage, "resistance": resistance, "maxresistance": maxresistance, "minresistance": minresistance, "insulationvalue": insulationvalue, "leakcurrent": leakcurrent, "singlevoltage": singlevoltage, "voltagediffer": voltagediffer, "differntc": differntc, "resultmsg": resultmsg, "userno": userno, "timein": timein }] }) print(recresult) if recresult["code"] == 1000: return {"Result": True, "Message": "ok", "Resultint": 1000} else: return {"Result": False, "Message": "send error", "Resultint": 2000}
def post_creatsn(client, cfg): # info1 = json_post(client, host_graphdbget(), { info1 = json_post(client, "http://10.106.160.10/graphdb/get/line-one", { "n": "task", "obj": "sn,uid,state,pstart,pend", "opt": { "has": "sn" } }) print(info1) tabname = None if "creatsn" in cfg: tabname = cfg["creatsn"] for i in info1: sn = get_item(i, "sn") state = get_item(i, "state") qty = "1" starttime = get_item(i, "pstart") endtime = get_item(i, "pend") snstatus = tabname if state == "open": if snstatus == None: info = json_requests_post("http://10.106.11.42:8049/restful/prod-plan/work-order-service/insert/ames", [{ "workOrderNo": sn, "prodLineCode": "PL02", "partNo": "", "qty":qty, "siteCode": "3310", "userNo": "AMES", "startTime": starttime, "endTime": endtime }]) print(info) if info["result"]: snstatus[i]["sn"] = sn print("creatsn post success") return else: print("creatsn post error") return else: snlen = len(snstatus) if i in range(snlen): if sn == snstatus[i]["sn"] and state == snstatus[i]["state"]: continue else: info = json_requests_post("http://10.106.11.42:8049/restful/prod-plan/work-order-service/insert/ames", [{ "workOrderNo": sn, "prodLineCode": "PL02", "partNo": "", "qty":qty, "siteCode": "3310", "userNo": "AMES", "startTime": starttime, "endTime": endtime }]) print(info) if info["result"]: print("creatsn post success") snstatus[i]["state"] = state return else: print("creatsn post error") return else: break