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
