waringMessageID.py 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. from .flightDB import flightDB
  2. from unitls.LogerinTxt import app_logger
  3. def waringMessageID(database:flightDB):
  4. try:
  5. waringMessageID1_arr=[]
  6. waringMessageID2_arr = []
  7. waringMessageID3_arr = []
  8. waringMessageID4_arr = []
  9. waringMessageID5_arr = []
  10. waringMessageID6_arr = []
  11. waringMessageID0_arr = []
  12. waringMessageID_arrs={}
  13. waringMessageIDs=database.queryTabel('logs',"*","警告信息 !='' and 处理时间 =''")
  14. if len(waringMessageIDs) != 0:
  15. for i in waringMessageIDs:
  16. waringMessageID0_arr.append(i[1])
  17. if i[8] == "到位警告":
  18. waringMessageID1_arr.append(i[1])
  19. elif i[8] == "二送警告":
  20. waringMessageID2_arr.append(i[1])
  21. elif i[8] == "非航前预计到达":
  22. waringMessageID3_arr.append(i[1])
  23. elif i[8] == "非航前进港机位":
  24. waringMessageID4_arr.append(i[1])
  25. elif i[8] == "非航前预计起飞":
  26. waringMessageID5_arr.append(i[1])
  27. else:
  28. waringMessageID6_arr.append(i[1])
  29. waringMessageID_arrs["到位警告"]=waringMessageID1_arr
  30. waringMessageID_arrs["二送警告"] = waringMessageID2_arr
  31. waringMessageID_arrs["ETA"] = waringMessageID3_arr
  32. waringMessageID_arrs["BAY_2"] = waringMessageID4_arr
  33. waringMessageID_arrs["TD"] = waringMessageID5_arr
  34. waringMessageID_arrs["通用警告"] = waringMessageID6_arr
  35. waringMessageID_arrs["全部警告"] = waringMessageID0_arr
  36. return waringMessageID_arrs
  37. except Exception as e:
  38. app_logger.log_error(e)