| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118 |
- from .flightDB import flightDB
- from unitls.LogerinTxt import app_logger
- import unitls.baseFunction as baseFunction
- from unitls.StaticDataclass import get_dic
- def mapDispaly(fdb:flightDB,selectedtime):
- try:
- mapDispalydata = {}
- nowDayStr = selectedtime
- sortdatas= fdb.queryTabel('sortFlight{}'.format(nowDayStr), '*', "航班编号!=''")
- sorttable= baseFunction.TuplefindInList2(sortdatas,"1","3",5)
- #sorttable1 = fdb.queryTabel("sortFlight{}".format(nowDayStr),"*","CAST(级别 AS integer)='1' or CAST(级别 AS integer)='3'")
- #{机位：[机号，机型，发动机，航班类型，航班号，ta，td，进港机场，出港机场，状态，放行，维修人员，二送人员，保留，工作包，TASKID，flightid，color，备注]}
- datas = fdb.queryTabel('TaskFlightinfo{}'.format(nowDayStr), '*', "航班编号!=''")
- for row in sorttable:
- # print(row)
- otheroneSts = []
- flightinfodata = baseFunction.TuplefindInList1(datas, row[1],0)[0]
- if flightinfodata[3] == "TR":
- iddd=row[1]+"-1"
- iddddd = row[1] + "-2"
- jfjSts=baseFunction.TuplefindInList3(sortdatas,iddd,0,5)
- sfjSts = baseFunction.TuplefindInList3(sortdatas, iddddd, 0, 5)
- #jfjSts= fdb.queryTabel("sortFlight{}".format(nowDayStr),"级别","编号='%s'"%iddd)[0][0]
- #sfjSts = fdb.queryTabel("sortFlight{}".format(nowDayStr), "级别", "编号='%s'" % iddddd)[0][0]
- # print(otheroneSts)
- if (flightinfodata[3] =="AP" and flightinfodata[11] !="") or (flightinfodata[3] !="AP" and flightinfodata[10] !=""):
- if flightinfodata[3] == "AP" and flightinfodata[11] != "":
- bay=flightinfodata[11]
- color="#99CCCC"
- elif flightinfodata[3] == "AF" and flightinfodata[10] != "" and row[5]=="3":
- bay = flightinfodata[10]
- color = "#0095d9"
- elif flightinfodata[3] == "停场" and flightinfodata[10] != "" and row[5]=="3":
- bay = flightinfodata[10]
- color = "#0095d9"
- elif flightinfodata[3] == "AF" and flightinfodata[10] != "" and row[5]=="1":
- bay = "Y"+flightinfodata[10]
- color = "#f6ad49"
- elif flightinfodata[3] == "TAF" and flightinfodata[10] != "" and flightinfodata[6] == "":
- bay = "Y"+flightinfodata[10]
- color = "#f6ad49"
- elif flightinfodata[3] == "TAF" and flightinfodata[10] != "" and flightinfodata[6] != "":
- bay = flightinfodata[10]
- color = "#4c6cb3"
- elif flightinfodata[3] == "TR" and flightinfodata[10] != "" and jfjSts=="1":
- bay = "Y"+flightinfodata[10]
- color = "#f6ad49"
- elif flightinfodata[3] == "TR" and flightinfodata[10] != "" and jfjSts=="4" and sfjSts=="1":
- bay = flightinfodata[10]
- color = "#69b076"
- acno=flightinfodata[1]
- airpalneType=flightinfodata[26]
- EngType=flightinfodata[25]
- flightType = get_dic('taskType')[flightinfodata[3]]
- flightNos = flightinfodata[21]
- DEP_CH=flightinfodata[23].split("</br>")[0] #进港机场
- DEP_CH1=flightinfodata[23].split("</br>")[1] #出港机场
- flightsts = ""#flightinfodata[10]TASKINFO没有这个节点
- wx=flightinfodata[12]
- fx = flightinfodata[13]
- es = flightinfodata[19]
- flightid=flightinfodata[0]
- message=""#flightinfodata[32]
- e = "" #保留
- F = ""#工作包
- g = "" #taskid
- ta = ""
- td=""
- if flightinfodata[16] != "":
- e = "有保留"
- if flightinfodata[18] != "":
- F = "有工作包"
- if flightinfodata[0] != "":
- g = flightinfodata[0]
- if "-" not in flightinfodata[9].split('</br>')[0]:
- ta = flightinfodata[9].split('</br>')[0]
- if "-" not in flightinfodata[9].split('</br>')[1]:
- td = flightinfodata[9].split('</br>')[1]
- if "CZ" in str(flightNos) or "OQ" in str(flightNos):
- nanhang="1"
- elif "3U" not in str(flightNos) or "CSC" not in str(flightNos):
- nanhang = "0"
- else:
- nanhang = "3"
- try:
- mapDispalydata[bay] = {"机号":acno,
- "机型":airpalneType,
- "发动机":EngType,
- "航班类型":flightType,
- "航班号":flightNos,
- "到达":ta,
- "起飞":td,
- "进港机场":DEP_CH,
- "出港机场":DEP_CH1,
- "状态":flightsts,
- "放行":fx,
- "维修人员":wx,
- "二送人员":es,
- "保留":e,
- "工作包":F,
- "TASKID":g,
- "flightid":flightid,
- "color":color,
- "备注":message,
- "南航":nanhang
- }
- except Exception as e:
- app_logger.log_error(e)
- pass
- return mapDispalydata
- except Exception as e:
- app_logger.log_error(e)
|
