import datetime import socket import sys import time import traceback from PyQt6 import QtCore from PyQt6.QtCore import Qt, QThread, pyqtSignal, QRunnable, QObject, pyqtSlot, QThreadPool, QTimer, \ QSortFilterProxyModel from PyQt6.QtGui import QColor, QFont,QPalette from PyQt6.QtTextToSpeech import QTextToSpeech from PyQt6.QtWidgets import QApplication, QWidget, QMessageBox, QPushButton, QTableWidgetItem, QFileDialog, \ QAbstractItemView, \ QCompleter, QMenu import requests import os import json from openpyxl import Workbook from UI.main2 import Ui_Form from Functions import utils from UI.checkCalllist import Ui_checkCalllist from UI.login import Ui_login from UI.addloaclip import Ui_Addloacalip from UI.checkLoadSingal import Ui_checkLoadSingal from UI.searchpeople_get import Ui_searchpeople_get from UI.amroLogin import Ui_amroLogin from UI.amroLogin2 import Ui_amroLogin2 from UI.adduser import Ui_FormAdduser from UI.handoverFlight import Ui_handoverFlight from UI.AddPG import Ui_FormAddPG from UI.addFlight import Ui_FormAddFlight from UI.findserver import Ui_FormLink from UI.changePassword import Ui_FormChangePssword from UI.checkLogs import Ui_checkLogs from UI.changeAuth import Ui_changeAuth from UI.mapWeb import Ui_FormMapWeb from Functions import serverFind from Functions.QtFunctions import ipcall import logging import logging.handlers from logging.handlers import RotatingFileHandler logger = logging.getLogger() logger.setLevel(logging.INFO) # Log等级总开关 # 第二步，创建一个handler，用于写入日志文件 rq = time.strftime('%Y%m%d%H%M', time.localtime(time.time())) log_name = 'D:/flightinfo/logs/BUGLOGS_qtmain.log' logfile = log_name fh = RotatingFileHandler(logfile, mode='a', maxBytes=10485760, backupCount=1, encoding='utf-8') fh.setLevel(logging.DEBUG) # 输出到file的log等级的开关 # 第三步，定义handler的输出格式 formatter = logging.Formatter("%(asctime)s - %(filename)s[line:%(lineno)d] - %(levelname)s: %(message)s") fh.setFormatter(formatter) # 第四步，将logger添加到handler里面 logger.addHandler(fh) class setlocalip(QObject): localipupdate = pyqtSignal(str) def __init__(self, ip, thread): super().__init__() self.ip = ip self.thread = thread def run(self): # print("jjingruy1") try: if self.ip != None: try: localcalltry = ipcall.searchinfo() self.localtoken = localcalltry.start(self.ip) # print("本地测试print(self.localtoken)") # print(self.localtoken) except Exception: self.localtoken = None self.localtoken = None logger.error(traceback.format_exc()) else: self.localtoken = None self.localipupdate.emit(self.localtoken) self.thread.quit() except Exception: logger.error(traceback.format_exc()) self.thread.quit() class sortdisplaySever(QObject): sortupdate = pyqtSignal(str, dict, list, str, str) def __init__(self, name, ip, selectedtime, text, displayMode, selectedbc, displayselect, thread): super().__init__() self.funcName = name self.ipinfo = ip self.selectedtime = selectedtime self.text = text self.displayMode = displayMode self.selectedbc = selectedbc self.displayselect_mode = displayselect self.thread = thread nowDay = datetime.datetime.now().strftime("%Y%m%d") tomorr =(datetime.date.today() + datetime.timedelta(days=1)).strftime("%Y%m%d") yester =(datetime.date.today() - datetime.timedelta(days=1)).strftime("%Y%m%d") if self.selectedtime == nowDay: self.date="2" elif self.selectedtime == tomorr: self.date = "3" elif self.selectedtime == yester: self.date = "1" else: self.date = "4" def run(self): try: list = [] if self.funcName == "sortTableWidgetDispaly": #print("1") self.sortTableWidgetDispaly() self.sortupdate.emit("sortTableWidgetDispaly", self.sorttableWidgetDispalydata, list, self.seversts,self.displayMode) self.sortupdate.emit("sortTableWidgetDispalyALL", self.DispalydataAll, list, self.seversts,self.displayMode) if self.funcName == "sortTableWidgetDispalyALL": #print("2") self.sortTableWidgetDispalyALL() self.sortupdate.emit("sortTableWidgetDispalyALL", self.sorttableWidgetDispalydata, list, self.seversts,self.displayMode) elif self.funcName == "SearchsortTableWidgetDispaly": #print("3") self.SearchsortTableWidgetDispaly() self.sortupdate.emit("SearchsortTableWidgetDispaly", self.sorttableWidgetDispalydata, list,self.seversts,self.displayMode) elif self.funcName == "sorttableWidgetDisplayChange": #print("4") self.sorttableWidgetDisplayChange() self.sortupdate.emit("sorttableWidgetDisplayChange", self.sortlogchange, list, self.seversts,self.displayMode) elif self.funcName == "sorttableWidgetPeopleDisplay": self.sorttableWidgetPeopleDisplay() self.sortupdate.emit("sorttableWidgetPeopleDisplay", self.sortdiplaylist, self.peopleOnJob,self.seversts, self.displayMode) elif self.funcName == "sorttableWidgetLOGDispaly": self.sorttableWidgetLOGDispaly() self.sortupdate.emit("sorttableWidgetLOGDispaly", self.sortlog, list, self.seversts, self.displayMode) elif self.funcName == "sorttableWidgetPHONEDispaly": self.sorttableWidgetPHONEDispaly() self.sortupdate.emit("sorttableWidgetPHONEDispaly", self.sorttableWidgetPHONEDispalydata, list,self.seversts, "") self.thread.quit() except Exception: logger.error(traceback.format_exc()) self.thread.quit() def severpost_nomeassge(self, postname, postdata, postdata2, postdata3): try: ip = "http://" + str(self.ipinfo) + "/static/" + str(postname) + str(postdata) + str(postdata2) + str(postdata3) try: res = requests.get(url=ip, timeout=30).json() self.seversts = "1" return res except Exception: logger.error(traceback.format_exc()) logger.error("重大bug") logger.error(ip) self.seversts = "0" return [] except Exception: logger.error(traceback.format_exc()) def sorttableWidgetPHONEDispaly(self): try: sorttableWidgetPHONEDispalydataall = self.severpost_nomeassge("getphonelist", "", "", "") self.sorttableWidgetPHONEDispalydata = {} num = 0 if sorttableWidgetPHONEDispalydataall != None: if self.text != "": for i in sorttableWidgetPHONEDispalydataall.keys(): if str.lower(str(self.text)) in str(sorttableWidgetPHONEDispalydataall[i]): self.sorttableWidgetPHONEDispalydata[str(num)] = sorttableWidgetPHONEDispalydataall[i] num += 1 else: self.sorttableWidgetPHONEDispalydata = sorttableWidgetPHONEDispalydataall except Exception: logger.error(traceback.format_exc()) def sortTableWidgetDispaly(self): try: text = self.text Partdisplay = self.displayselect_mode # 不显示起飞航班 # print(Partdisplay) tableWidgetDispalydataAll = {} if self.displayMode == "A" and (self.selectedbc == "0" or self.date=="4"): tableWidgetDispalydataAll = self.severpost_nomeassge("tableWidgetDispaly", "/%s" % self.selectedtime,"/%s"%self.date,"") elif self.displayMode == "B"and (self.selectedbc == "0" or self.date=="4"): tableWidgetDispalydataAll = self.severpost_nomeassge("tableWidgetDispaly2", "/%s" % self.selectedtime,"/%s"%self.date,"") elif self.displayMode == "A" and self.selectedbc == "1": tableWidgetDispalydataAll = self.severpost_nomeassge("tableWidgetDispalyRead","/%s"%self.date,"","") elif self.displayMode == "B"and self.selectedbc == "1": tableWidgetDispalydataAll = self.severpost_nomeassge("tableWidgetDispalyRead2","/%s"%self.date,"","") self.DispalydataAll=tableWidgetDispalydataAll self.sorttableWidgetDispalydata = {} num = 0 if tableWidgetDispalydataAll != None: if text != "" and text != "T1" and text != "T2" and text != "T6" and text != "T2T6" and text != "T1T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): if str(text) in str(tableWidgetDispalydataAll[i]): self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] == "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] != "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] != "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] != "1" and \ str(tableWidgetDispalydataAll[i]["8"])[0] != "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text != "" and text != "T1" and text != "T2" and text != "T6" and text != "T2T6" and text != "T1T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): if str(text) in str(tableWidgetDispalydataAll[i]) and tableWidgetDispalydataAll[i]["109"] != '4': self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] == "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] != "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1" and \ str(tableWidgetDispalydataAll[i]["8"])[0] != "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(tableWidgetDispalydataAll[i]["109"]) if tableWidgetDispalydataAll[i]["109"] != '4': self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text != "" and text != "T1" and text != "T2" and text != "T6" and text != "T2T6" and text != "T1T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): if str(text) in str(tableWidgetDispalydataAll[i]) and tableWidgetDispalydataAll[i]["109"] == '1': self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] == "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] != "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1" and \ str(tableWidgetDispalydataAll[i]["8"])[0] != "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(tableWidgetDispalydataAll[i]["109"]) if tableWidgetDispalydataAll[i]["109"] == '1': self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 else: self.sorttableWidgetDispalydata = tableWidgetDispalydataAll else: self.sorttableWidgetDispalydata = self.sortTableWidgetDispaly_bak() except Exception: logger.error(traceback.format_exc()) def sortTableWidgetDispaly_bak(self): try: text = self.text Partdisplay = self.displayselect_mode # 不显示起飞航班 # print(Partdisplay) tableWidgetDispalydataAll = {} if self.displayMode == "A" and (self.selectedbc == "0" or self.date == "4"): tableWidgetDispalydataAll = self.severpost_nomeassge("tableWidgetDispaly", "/%s" % self.selectedtime, "/%s" % self.date, "") elif self.displayMode == "B" and (self.selectedbc == "0" or self.date == "4"): tableWidgetDispalydataAll = self.severpost_nomeassge("tableWidgetDispaly2", "/%s" % self.selectedtime, "/%s" % self.date, "") elif self.displayMode == "A" and self.selectedbc == "1": tableWidgetDispalydataAll = self.severpost_nomeassge("tableWidgetDispalyRead", "/%s" % self.date, "", "") elif self.displayMode == "B" and self.selectedbc == "1": tableWidgetDispalydataAll = self.severpost_nomeassge("tableWidgetDispalyRead2", "/%s" % self.date, "", "") self.DispalydataAll=tableWidgetDispalydataAll sorttableWidgetDispalydata = {} num = 0 if tableWidgetDispalydataAll != None: if text != "" and text != "T1" and text != "T2" and text != "T6" and text != "T2T6" and text != "T1T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): if str(text) in str(tableWidgetDispalydataAll[i]): sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] == "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] != "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] != "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] != "1" and \ str(tableWidgetDispalydataAll[i]["8"])[0] != "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text != "" and text != "T1" and text != "T2" and text != "T6" and text != "T2T6" and text != "T1T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): if str(text) in str(tableWidgetDispalydataAll[i]) and tableWidgetDispalydataAll[i]["109"] != '4': sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] == "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] != "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1" and \ str(tableWidgetDispalydataAll[i]["8"])[0] != "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(tableWidgetDispalydataAll[i]["109"]) if tableWidgetDispalydataAll[i]["109"] != '4': sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text != "" and text != "T1" and text != "T2" and text != "T6" and text != "T2T6" and text != "T1T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): if str(text) in str(tableWidgetDispalydataAll[i]) and tableWidgetDispalydataAll[i]["109"] == '1': sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] == "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] != "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1" and \ str(tableWidgetDispalydataAll[i]["8"])[0] != "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(tableWidgetDispalydataAll[i]["109"]) if tableWidgetDispalydataAll[i]["109"] == '1': sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 else: sorttableWidgetDispalydata = tableWidgetDispalydataAll return sorttableWidgetDispalydata except Exception: logger.error(traceback.format_exc()) def sortTableWidgetDispalyALL(self): try: if self.displayMode == "A" and (self.selectedbc == "0" or self.date=="4"): self.sorttableWidgetDispalydata = self.severpost_nomeassge("tableWidgetDispaly", "/%s" % self.selectedtime,"/%s"%self.date,"") elif self.displayMode == "B"and (self.selectedbc == "0" or self.date=="4"): self.sorttableWidgetDispalydata = self.severpost_nomeassge("tableWidgetDispaly2", "/%s" % self.selectedtime,"/%s"%self.date,"") elif self.displayMode == "A" and self.selectedbc == "1": self.sorttableWidgetDispalydata = self.severpost_nomeassge("tableWidgetDispalyRead","/%s"%self.date,"","") elif self.displayMode == "B"and self.selectedbc == "1": self.sorttableWidgetDispalydata = self.severpost_nomeassge("tableWidgetDispalyRead2","/%s"%self.date,"","") except Exception: logger.error(traceback.format_exc()) def SearchsortTableWidgetDispaly(self): try: text = self.text self.seversts = "1" Partdisplay = self.displayselect_mode # 不显示起飞航班 # print(Partdisplay) tableWidgetDispalydataAll = self.selectedbc self.sorttableWidgetDispalydata = {} num = 0 if tableWidgetDispalydataAll != None: if text != "" and text != "T1" and text != "T2" and text != "T6" and text != "T2T6" and text != "T1T6"and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): if str(text) in str(tableWidgetDispalydataAll[i]): self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] == "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] != "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] != "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] != "1" and \ str(tableWidgetDispalydataAll[i]["8"])[0] != "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text != "" and text != "T1" and text != "T2" and text != "T6" and text != "T2T6" and text != "T1T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): if str(text) in str(tableWidgetDispalydataAll[i]) and tableWidgetDispalydataAll[i]["109"] != '4': self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] == "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] != "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1" and \ str(tableWidgetDispalydataAll[i]["8"])[0] != "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(tableWidgetDispalydataAll[i]["109"]) if tableWidgetDispalydataAll[i]["109"] != '4': self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text != "" and text != "T1" and text != "T2" and text != "T6" and text != "T2T6" and text != "T1T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): if str(text) in str(tableWidgetDispalydataAll[i]) and tableWidgetDispalydataAll[i]["109"] == '1': self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] == "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] != "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1" and \ str(tableWidgetDispalydataAll[i]["8"])[0] != "2": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(tableWidgetDispalydataAll[i]["109"]) if tableWidgetDispalydataAll[i]["109"] == '1': self.sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 else: self.sorttableWidgetDispalydata = tableWidgetDispalydataAll else: self.sorttableWidgetDispalydata = self.SearchsortTableWidgetDispaly_bak() except Exception: logger.error(traceback.format_exc()) def SearchsortTableWidgetDispaly_bak(self): try: text = self.text self.seversts = "1" Partdisplay = self.displayselect_mode # 不显示起飞航班 # print(Partdisplay) tableWidgetDispalydataAll = self.selectedbc sorttableWidgetDispalydata = {} num = 0 if tableWidgetDispalydataAll != None: if text != "" and text != "T1" and text != "T2" and text != "T6" and text != "T2T6" and text != "T1T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): if str(text) in str(tableWidgetDispalydataAll[i]): sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] == "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] != "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] != "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T6" and Partdisplay == "0": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "": if str(tableWidgetDispalydataAll[i]["8"])[0] != "1" and \ str(tableWidgetDispalydataAll[i]["8"])[0] != "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text != "" and text != "T1" and text != "T2" and text != "T6" and text != "T2T6" and text != "T1T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): if str(text) in str(tableWidgetDispalydataAll[i]) and tableWidgetDispalydataAll[i]["109"] != '4': sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] == "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] != "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T6" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] != '4': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1" and \ str(tableWidgetDispalydataAll[i]["8"])[0] != "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "" and Partdisplay == "1": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(tableWidgetDispalydataAll[i]["109"]) if tableWidgetDispalydataAll[i]["109"] != '4': sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text != "" and text != "T1" and text != "T2" and text != "T6" and text != "T2T6" and text != "T1T6"and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): if str(text) in str(tableWidgetDispalydataAll[i]) and tableWidgetDispalydataAll[i]["109"] == '1': sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] == "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T2T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T1T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] != "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "T6" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(str(tableWidgetDispalydataAll[i]["8"])) if str(tableWidgetDispalydataAll[i]["8"]) != "" and tableWidgetDispalydataAll[i]["109"] == '1': if str(tableWidgetDispalydataAll[i]["8"])[0] != "1" and \ str(tableWidgetDispalydataAll[i]["8"])[0] != "2": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif str(tableWidgetDispalydataAll[i]["8"]) == "" and str(tableWidgetDispalydataAll[i]["109"]) == "1": sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 elif text == "" and Partdisplay == "3": # print(tableWidgetDispalydataAll) for i in tableWidgetDispalydataAll.keys(): # print(tableWidgetDispalydataAll[i]["109"]) if tableWidgetDispalydataAll[i]["109"] == '1': sorttableWidgetDispalydata[str(num)] = tableWidgetDispalydataAll[i] num += 1 else: sorttableWidgetDispalydata = tableWidgetDispalydataAll return sorttableWidgetDispalydata except Exception: logger.error(traceback.format_exc()) def sorttableWidgetDisplayChange(self): try: text = self.text logall = self.severpost_nomeassge("tableWidgetDisplayChange", "/%s" % self.selectedtime, "", "") self.sortlogchange = {} num = 0 if text != "": for i in logall.keys(): if str(text) in str(logall[i]): self.sortlogchange[str(num)] = logall[i] num += 1 else: self.sortlogchange = logall except Exception: logger.error(traceback.format_exc()) def sorttableWidgetPeopleDisplay(self): try: if self.displayselect_mode == "" or self.displayselect_mode == []: text = self.text self.peopleOnJob = [""] bc = self.selectedbc nowDaystr = self.selectedtime # 选择的日期 diplaylistall = self.severpost_nomeassge("qtPeopleLoad", "/%s" % nowDaystr, "/%s" % bc, "") self.sortdiplaylist = {} num = 0 if text != "": for i in diplaylistall.keys(): if str(text) in str(diplaylistall[i]): self.sortdiplaylist[str(num)] = diplaylistall[i] num += 1 else: self.sortdiplaylist = diplaylistall for i in self.sortdiplaylist.keys(): self.peopleOnJob.append(self.sortdiplaylist[i]["姓名"]) else: names = self.displayselect_mode text = self.text self.peopleOnJob = [""] bc = self.selectedbc nowDaystr = self.selectedtime # 选择的日期 diplaylistall = self.severpost_nomeassge("qtPeopleLoad", "/%s" % nowDaystr, "/%s" % bc, "") self.sortdiplaylist = {} num = 0 if text != "": for i in diplaylistall.keys(): if str(text) in str(diplaylistall[i]): for name in names: if str(name) in str(diplaylistall[i]): self.sortdiplaylist[str(num)] = diplaylistall[i] num += 1 else: for i in diplaylistall.keys(): for name in names: if str(name) in str(diplaylistall[i]): self.sortdiplaylist[str(num)] = diplaylistall[i] num += 1 for i in self.sortdiplaylist.keys(): self.peopleOnJob.append(self.sortdiplaylist[i]["姓名"]) except Exception: logger.error(traceback.format_exc()) def sorttableWidgetLOGDispaly(self): try: text = self.text logall = self.severpost_nomeassge("tableWidgetLOGDispaly", "/%s" % self.selectedtime, "", "") self.sortlog = {} num = 0 if text != "": for i in logall.keys(): if str(text) in str(logall[i]): self.sortlog[str(num)] = logall[i] num += 1 else: self.sortlog = logall except Exception: logger.error(traceback.format_exc()) class MainWidget(QWidget, Ui_Form): AddPG_signal = QtCore.pyqtSignal(str, str, str) LoginWidget_signal = QtCore.pyqtSignal(str) addUserWidget_signal = QtCore.pyqtSignal(str) def __init__(self): super().__init__() try: self.displaySelectstr3 = "0" self.displaySelect_mode = "1" self.sum = 0 self.flightsum = 0 self.localip = None self.severupdatests = "0" self.localtoken = None self.searchpeoplestr = [] self.sorttableWidgetDispalydata = {} self.sorttableWidgetDispalydataALL = {} self.sortlogchange = {} self.sortlog = {} self.sortdiplaylist = {} self.peopleOnJob = [""] self.loginSts = False self.amroLoginSts = False self.findSever = False self.FLIGHTonChange_text = "" self.changeonChange_text = "" self.logonChange_text = "" self.threadpool = QThreadPool() self.doubleclickLock = 0 self.vin="328" self.timelock=datetime.datetime.now() self.doubleclickLockUpdate = 0 self.maintainAuthCheckSts = 1 self.peolpleonChange_text = "" self.changeupdatetime=datetime.datetime.now() self.setupUi(self) # self.show() self.loginWidget = LoginWidget() self.findServerWidget = findServerWidget() self.mapWebPage = mapWebWidget() self.checkCalllist = checkCalllist() self.checkCalllist.checkCalllist_signal.connect(self.checkCalllistclose) # self.amroLoginWidget = amroLoginWidget() if self.findSever: pass # if self.loginSts: # self.show() # else: # self.loginWidget.show() else: self.findServerWidget.show() self.findServerWidget.selectServer_signal.connect(self.setServer) # self.amroLoginWidget.amroLogin_signal.connect(self.displayMain) # data except Exception: logger.error(traceback.format_exc()) def setServer(self, *args): try: #self.ipinfo = args[0] + ':9527' self.ipinfo = args[0] + ':7162' self.clickrow = "" self.clickcolumn = "" # print(self.ipinfo) self.findServerWidget.close() self.loginWidget.ipinfo = self.ipinfo self.loginWidget.login_signal.connect(self.displayMain) self.loginWidget.login_user.connect(self.setUser) checksts="ok" ip = "http://" + str(self.ipinfo) + "/static/remoteCheck/16" res=requests.get(url=ip, timeout=180).json() if res["返回值"] != "ok": checksts = res["返回值"] if checksts == "ok": if self.loginSts: self.initDisplay() self.show() else: self.loginWidget.show() else: QMessageBox.warning(self, "提示", "有新版更新！请前往NAS共享平台[机务一队/天府机务分部/31准备组无纸化办公/1航班助手]获取综合平台最新版本【最新版版本号:%s】！！"%checksts) self.close() except Exception: logger.error(traceback.format_exc()) def remotelogin(self): self.amrologin = amroLoginWidget() self.amrologin.ipinfo = self.ipinfo self.amrologin.show() def remoteCookielogin(self): self.amrologin = amroLoginWidget2() self.amrologin.ipinfo = self.ipinfo self.amrologin.show() def setIpPhone(self): try: res="" if os.path.exists("ipPhoneIp.code") is True: read_path = os.getcwd() + "\\ipPhoneIp.code" with open(read_path, "r", encoding="utf-8") as f2: rember_2 = f2.read() try: ip = "http://" + str(self.ipinfo) + "/static/setIpPhone/%s" % rember_2 res=requests.get(url=ip, timeout=180).json()["返回值"] except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员！") logger.error(traceback.format_exc()) if res =="ok": QMessageBox.warning(self, "提示", "服务器IP电话配置成功，请测试后启用自动拨号！") else: QMessageBox.warning(self, "警告", "服务器IP电话配置失败，建议重启自动拨号电话后再次配置！") else: QMessageBox.warning(self, "警告", "程序下未找到指定配置文件！") except Exception: logger.error(traceback.format_exc()) def setLocalIpPhone(self): try: self.localipset = localipset() self.localipset.localipset_signal.connect(self.setLocalIpPhoneip) self.localipset.localip = self.localip self.localipset.start() except Exception: logger.error(traceback.format_exc()) def setLocalIpPhoneip(self, *args): try: self.localip = args[0] self.QThreadSortNow("setlocalip") self.localipset.close() # print(self.localip) except Exception: logger.error(traceback.format_exc()) def checkCalllistupdate(self): try: self.checkCalllist.ipinfo = self.ipinfo self.checkCalllist.selectedtime = self.selectedtime self.checkCalllist.start() except Exception: logger.error(traceback.format_exc()) def checkCalllistclose(self, *args): try: reply = args[0] # print(reply) if reply == "StandardButton.Yes": self.checkCalllist.hide() except Exception: logger.error(traceback.format_exc()) def showcheckLogs(self): try: self.checkLogs = checkLogs() self.checkLogs.ipinfo = self.ipinfo self.checkLogs.start() except Exception: logger.error(traceback.format_exc()) def initDisplay(self): try: self.oldjsondata = None self.cookie = None self.fl = None self.Auth=9999 self.tts = QTextToSpeech() self.tts.setEngine('sapi') nowDay = datetime.datetime.now() nowDayStr = nowDay.strftime("%Y%m%d") self.dateEdit.setDateTime(nowDay) self.selectedtime = self.dateEdit.date().toString('yyyyMMdd') # self.setipinfo() self.initFlightDatabase() # self.radioButtonDay. phoneLabel = ["序号", "姓名", "部门", "电话","name"] self.tableWidget_3.setColumnCount(len(phoneLabel)) self.tableWidget_3.verticalHeader().setVisible(False) self.tableWidget_3.setHorizontalHeaderLabels(phoneLabel) self.lineEdit_phonenum.textChanged.connect(self.changeonPhone) self.tableWidget_3.setContextMenuPolicy(Qt.ContextMenuPolicy.CustomContextMenu) self.tableWidget_3.customContextMenuRequested.connect(self.generateMenu3) peopleLabel = ["序号", "姓名", "角色", "总量", "当前", "最后时间"] self.tableWidgetPerson.setColumnCount(len(peopleLabel)) self.tableWidgetPerson.verticalHeader().setVisible(False) self.tableWidgetPerson.setHorizontalHeaderLabels(peopleLabel) self.tableWidgetPerson.setContextMenuPolicy(Qt.ContextMenuPolicy.CustomContextMenu) self.tableWidgetPerson.customContextMenuRequested.connect(self.generateMenu2) self.pushButton.clicked.connect(self.selectedtime_bc) self.radioButtonDay.toggled.connect(self.selected_bc_A) self.radioButtonNight.toggled.connect(self.selected_bc_B) judge_bc = self.severpost_nomeassge("judge_bc", "", "", "", "")["bc"] if judge_bc == "A": self.radioButtonDay.setChecked(True) elif judge_bc == "B": self.radioButtonNight.setChecked(True) self.AddPG = AddPGWidget() self.AddPG_signal.connect(self.AddPG.getname) self.pushButtonAddPG.clicked.connect(self.AddPG_widget) self.displayMode = "A" self.displayLabel = ["备","序号","备","机号","航班信息","机型","机型信息","发动机","备","航班号","备","计达","备","预达", "备","计飞","备","机位","备","类型","备","放行","备","工1","备","工2","备","工3","备","工4", "备","班组长","备","到位","备","放行","备","销夹","备","随机","备","随机","备","保留","备","工作包", "备","进出港城市","备","维修人员","备","放行","备","航班编号","备","任务编号","备","TATD","备","类型", "备","附加消息","备","备","备","备"] ''' self.displayLabel = ["序号", "机号", "机型", "发动机", "航班号", "计达", "预达", "计飞", "机位", "类型", "放行", "工1", "工2", "工3", "工4", "班组长", "到位", "放行", "销夹", "随机", "随机", "保留", "工作包", "进出港城市", "维修人员", "放行", "航班编号", "任务编号", "TATD", "类型", "附加消息"] ''' self.tableWidgetFlight.setColumnCount(len(self.displayLabel)) self.tableWidgetFlight.verticalHeader().setVisible(False) self.tableWidgetFlight.setHorizontalHeaderLabels(self.displayLabel) self.tableWidgetFlight.cellDoubleClicked.connect(self.itemclick2) self.tableWidgetFlight.cellClicked.connect(self.itemclick) # self.lineEdit_phonenum.setText("") # 允许单机右键响应 self.tableWidgetFlight.setContextMenuPolicy(Qt.ContextMenuPolicy.CustomContextMenu) # 构建右键的点击事件 self.tableWidgetFlight.customContextMenuRequested.connect(self.generateMenu) loglabel = ["序号", "待办信息", "操作", "编号", "航班编号", "提示内容"] self.tableWidget.setColumnCount(len(loglabel)) self.tableWidget.verticalHeader().setVisible(False) self.tableWidget.setHorizontalHeaderLabels(loglabel) self.tableWidgetLOG.setColumnCount(2) self.tableWidgetLOG.verticalHeader().setVisible(False) self.tableWidgetLOG.setHorizontalHeaderLabels(["序号", '日志信息']) self.checkBox.stateChanged.connect(self.displayChange) self.checkBox.setChecked(True) self.checkBox_2.stateChanged.connect(self.displaySelect2) self.checkBox_2.setChecked(True) self.checkBox_3.stateChanged.connect(self.displaySelect3) self.checkBox_3.setChecked(False) self.severpost_nomeassge("createWorkloadtablesFromPg", "/%s" % self.selectedtime, "", "", "") self.pushbutton_searchflight.clicked.connect(self.FLIGHTonChangeman) self.pushButton_searchpeople.clicked.connect(self.searchpeople) self.pushButton_5.clicked.connect(self.disearchpeople) self.pushButton_2.clicked.connect(self.call) self.pushButton_3.clicked.connect(self.calldown) self.pushButton_4.clicked.connect(self.relogin) self.pushButton_searchchange.clicked.connect(self.changeonChange) self.pushButton_searchlog.clicked.connect(self.logonChange) self.lineEdit_flight.textEdited[str].connect(lambda: self.changebackground()) self.lineEdit_people.textEdited[str].connect(lambda: self.changebackground()) self.lineEdit_change.textEdited[str].connect(lambda: self.changebackground()) self.lineEdit_log.textEdited[str].connect(lambda: self.changebackground()) self.lineEdit_flight.textChanged.connect(self.FLIGHTonChange) self.lineEdit_log.textChanged.connect(self.logonChange) self.lineEdit_people.textChanged.connect(self.peolpleonChange) self.lineEdit_change.textChanged.connect(self.changeonChange) self.serchTimer = QTimer() self.serchTimer.start(3 * 1000) self.serchTimer.timeout.connect(self.QThreadSortTimer) self.updatecheck() self.taskAtuoCheck("1") except Exception: logger.error(traceback.format_exc()) def searchpeople(self): try: self.searchpeoplelist = searchpeople_get() self.searchpeoplelist.searchpeoplelist_signal.connect(self.searchpeople_get) self.searchpeoplelist.ipinfo = self.ipinfo self.searchpeoplelist.selectedtime = self.selectedtime self.searchpeoplelist.selectedbc = self.selectedbc self.searchpeoplelist.Allpeoplelist = self.sortdiplaylist # self.searchpeoplelist.show() self.searchpeoplelist.start() except Exception: logger.error(traceback.format_exc()) def searchpeople_get(self, *args): try: # print(args) self.searchpeoplestr = args[0] self.QThreadSortNow("people") except Exception: logger.error(traceback.format_exc()) def disearchpeople(self): try: self.searchpeoplestr = [] self.QThreadSortNow("people") except Exception: logger.error(traceback.format_exc()) def call(self): try: if self.localtoken != None and self.localip != None: callnum = self.lineEdit_phonenum.text() try: data = {"PHB_AutoDialNumber": callnum, "ReturnPage": "/contacts.htm", "AutoDialSubmit": "submit", "PHB_AutoDialLine": "1" } header = { "Accept": "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9", "Connection": "keep-alive", "Cookie": self.localtoken } requests.post(url="http://%s/contacts.htm" % self.localip, data=data, headers=header) except Exception: QMessageBox.warning(self, "提示", "IP电话连接失败，请重新配置或再登陆！") logger.error(traceback.format_exc()) else: QMessageBox.warning(self, "提示", "未配置本地IP电话，请先配置！") except Exception: logger.error(traceback.format_exc()) def calldown(self): try: if self.localtoken != None and self.localip != None: try: data1 = {"HangupSubmit": "submit"} header1 = { "Accept": "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9", "Connection": "keep-alive", "Cookie": self.localtoken, } requests.post(url="http://%s/contacts.htm" % self.localip, data=data1, headers=header1) except Exception: QMessageBox.warning(self, "提示", "IP电话连接失败，请重新配置或再登陆！") logger.error(traceback.format_exc()) else: QMessageBox.warning(self, "提示", "未配置本地IP电话，请先配置！") except Exception: logger.error(traceback.format_exc()) def relogin(self): try: if self.localip != None: self.QThreadSortNow("setlocalip") else: QMessageBox.warning(self, "提示", "未配置本地IP电话，请先配置！") except Exception: logger.error(traceback.format_exc()) def changebackground(self): try: FLIGHTonChange_text = self.lineEdit_flight.text() peolpleonChange_text = self.lineEdit_people.text() changeonChange_text = self.lineEdit_change.text() logonChange_text = self.lineEdit_log.text() if FLIGHTonChange_text != "": self.lineEdit_flight.setStyleSheet("background-color:yellow;color:red;font-weight:bold") else: self.lineEdit_flight.setStyleSheet("background-color:white") if peolpleonChange_text != "": self.lineEdit_people.setStyleSheet("background-color:yellow;color:red;font-weight:bold") else: self.lineEdit_people.setStyleSheet("background-color:white") if changeonChange_text != "": self.lineEdit_change.setStyleSheet("background-color:yellow;color:red;font-weight:bold") else: self.lineEdit_change.setStyleSheet("background-color:white") if logonChange_text != "": self.lineEdit_log.setStyleSheet("background-color:yellow;color:red;font-weight:bold") else: self.lineEdit_log.setStyleSheet("background-color:white") except Exception: logger.error(traceback.format_exc()) def changeonPhone(self): try: self.changeonPhone_text = self.lineEdit_phonenum.text() self.QThreadSortNow("phone") except Exception: logger.error(traceback.format_exc()) def FLIGHTonChange(self): try: self.FLIGHTonChange_text = self.lineEdit_flight.text() # print(self.FLIGHTonChange_text) self.QThreadSortNow("search") except Exception: logger.error(traceback.format_exc()) def FLIGHTonChangeman(self): try: now=datetime.datetime.now()- datetime.timedelta(seconds=5) if now > self.timelock: print("点击") self.timelock=now + datetime.timedelta(seconds=5) self.FLIGHTonChange_text = self.lineEdit_flight.text() # print(self.FLIGHTonChange_text) #self.QThreadSortNow("ALL") self.QThreadSortNow("main") except Exception: logger.error(traceback.format_exc()) def peolpleonChange(self): try: self.peolpleonChange_text = self.lineEdit_people.text() self.QThreadSortNow("people") except Exception: logger.error(traceback.format_exc()) def changeonChange(self): try: self.changeonChange_text = self.lineEdit_change.text() self.QThreadSortNow("change") except Exception: logger.error(traceback.format_exc()) def logonChange(self): try: self.logonChange_text = self.lineEdit_log.text() self.QThreadSortNow("log") except Exception: logger.error(traceback.format_exc()) def taskAtuoCheck(self, time): try: ip = "http://" + str(self.ipinfo) + "/static/taskAtuoCheck/%s" % time requests.get(url=ip, timeout=30).json() # print("准备组任务自动更新") #客户端连接监测一次，12H监测一次 # logging.info("准备组任务自动更新") except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) def updatecheck(self): try: ip = "http://" + str(self.ipinfo) + "/static/updatecheck" res = requests.get(url=ip, timeout=30).json() if res["返回值"] == "1": self.label_11.setText("正 常") self.label_11.setStyleSheet( "background-color:green;color:white;border-radius:5px;padding:2px;font-weight:bold") if self.severupdatests != "1": self.severupdatests = "1" try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "服务器状态变更为正常/" + "%s/" % str("系统上报") + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self,"日志功能失效", "操作日志功能失效请联系管理员！") elif res["返回值"] == "0": self.label_11.setText("未更新") self.label_11.setStyleSheet("background-color:yellow;red:white;border-radius:5px;padding:2px;font-weight:bold") if self.severupdatests != "0": self.severupdatests = "0" try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "服务器状态变更为未更新，航班数据暂停刷新/" + "%s/" % str("系统上报") + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self,"日志功能失效", "操作日志功能失效请联系管理员！") QMessageBox.warning(self, "警告", "服务器状态变更为未更新，航班数据暂停刷新，请检查服务器端AMRO登录情况或联系管理员！") except Exception: self.label_11.setText("已断开") self.label_11.setStyleSheet("background-color:red;color:white;border-radius:5px;padding:2px;font-weight:bold") if self.severupdatests != "-": self.severupdatests = "-" try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "服务器状态变更为断开，航班数据暂停刷新/" + "%s/" % str("系统上报") + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.restartServer(self.ipinfo.split(':')[0],9935) logger.error(traceback.format_exc()) def initFlightDatabase(self): try: ip = "http://" + str(self.ipinfo) + "/static/initFlightDatabase/" + str(self.selectedtime) requests.get(url=ip, timeout=30).json() except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) def severpost_nomeassge(self, postname, postdata, postdata2, postdata3, postdata4): try: ip = "http://" + str(self.ipinfo) + "/static/" + str(postname) + str(postdata) + str(postdata2) + str(postdata3) + str(postdata4) res = requests.get(url=ip, timeout=30).json() return res except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) def severpostData_nomeassge(self, postname, data: dict): try: ip = "http://" + str(self.ipinfo) + "/static/" + str(postname) data = json.dumps(data) res = requests.post(url=ip, data=data, timeout=120).json() return res except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) def AddPG_widget(self): if int(self.authority) != 3: try: self.AddPG.show() self.AddPG_signal.emit(self.user, self.selectedtime, self.ipinfo) except Exception: logger.error(traceback.format_exc()) else: self.show_message2("提示", "权限不够，请联系管理员！") def selected_bc_A(self): try: bc = self.sender() if bc.isChecked(): self.selectedbc = "A" # print("白班") self.severpost_nomeassge("createWorkloadtablesFromPg", "/%s" % self.selectedtime, "", "", "") if self.loginSts == True: self.QThreadSortNow("people") except Exception: logger.error(traceback.format_exc()) def selected_bc_B(self): try: bc = self.sender() if bc.isChecked(): self.selectedbc = "B" # print("夜班") self.severpost_nomeassge("createWorkloadtablesFromPg", "/%s" % self.selectedtime, "", "", "") if self.loginSts == True: self.QThreadSortNow("people") except Exception: logger.error(traceback.format_exc()) def displaySelect2(self): try: displaySelect = self.sender() if displaySelect.isChecked(): self.displaySelectstr2 = "1" if self.loginSts == True: if self.displaySelectstr3 == "1": self.displaySelect_mode = "3" else: self.displaySelect_mode = "1" #self.QThreadSortNow("main") self.QThreadSortNow("search") else: self.displaySelectstr2 = "0" self.displaySelect_mode = "0" if self.loginSts == True: if self.displaySelectstr3 == "1": self.checkBox_3.setChecked(False) else: # self.QThreadSortNow("main") self.QThreadSortNow("search") except Exception: logger.error(traceback.format_exc()) def displaySelect3(self): try: displaySelect = self.sender() if displaySelect.isChecked(): self.displaySelectstr3 = "1" self.displaySelect_mode = "3" if self.loginSts == True: if self.displaySelectstr2 == "0": self.checkBox_2.setChecked(True) else: # self.QThreadSortNow("main") self.QThreadSortNow("search") else: self.displaySelectstr3 = "0" if self.loginSts == True: if self.displaySelectstr2 == "0": self.displaySelect_mode = "0" else: self.displaySelect_mode = "1" # self.QThreadSortNow("main") self.QThreadSortNow("search") except Exception: logger.error(traceback.format_exc()) def displayChange(self): try: bc = self.sender() if bc.isChecked(): if self.loginSts == True: self.displayMode = "A" self.QThreadSortNow("main") # print("A模式") else: if self.loginSts == True: self.displayMode = "B" self.QThreadSortNow("main") # print("B模式") except Exception: logger.error(traceback.format_exc()) def selectedtime_bc(self): try: self.selectedtime = self.dateEdit.date().toString('yyyyMMdd') judgedate = (datetime.date.today() + datetime.timedelta(days=1)).strftime("%Y%m%d") if self.selectedtime == judgedate: QMessageBox.warning(self, "重要提示","明日航班20:30后提供查询功能！由于第二日航班波动较大，22:00前仅提供查询功能，22:00以后提供第二日航班的航班变更以及节点监控功能！") self.initFlightDatabase() ip = "http://" + str(self.ipinfo) + "/map/" + str(self.selectedtime) self.QThreadSortNow("main") self.QThreadSortNow("people") # print(self.selectedtime) except Exception: logger.error(traceback.format_exc()) def show_info(self, title, text): try: reply = QMessageBox.question(self, title, text,QMessageBox.StandardButton.Yes | QMessageBox.StandardButton.Cancel,QMessageBox.StandardButton.Cancel) if reply == QMessageBox.StandardButton.Yes: return 1 else: return 0 except Exception: logger.error(traceback.format_exc()) def displayMain(self, *args): try: if args[0]: self.initDisplay() self.loginSts = True self.loginWidget.close() self.show() self.QThreadSortNow("main") self.QThreadSortNow("change") self.QThreadSortNow("people") self.QThreadSortNow("log") self.initlocalipback() except Exception: logger.error(traceback.format_exc()) def setUser(self, args): try: self.user = args[1] self.authority = args[3] self.label_username.setText(self.user) except Exception: logger.error(traceback.format_exc()) def AddFlight(self): try: self.addFlight = addFlightWidget() self.addFlight.ipinfo = self.ipinfo self.addFlight.user = self.user self.addFlight.show() except Exception: logger.error(traceback.format_exc()) def HandoverFlight(self): try: self.handoverFlight = handoverFlightWidget() self.handoverFlight.ipinfo = self.ipinfo self.handoverFlight.user = self.user self.handoverFlight.Allflight = self.sorttableWidgetDispalydataALL self.handoverFlight.selectedtime=self.selectedtime self.handoverFlight.handoverFlight_signal.connect(self.handoverFlight_update) self.handoverFlight.show() self.handoverFlight.start() except Exception: logger.error(traceback.format_exc()) def handoverFlight_update(self, *args): try: # print(args) self.QThreadSortNow("main") except Exception: logger.error(traceback.format_exc()) def showAdduser(self): try: self.addUser = addUserWidget() self.addUser.ipinfo = self.ipinfo self.addUser.user = self.user self.addUser.authority=self.authority self.addUser.show() except Exception: logger.error(traceback.format_exc()) def showChangePassword(self): try: self.changePassword = changePassword() self.changePassword.ipinfo = self.ipinfo self.changePassword.user = self.user self.changePassword.show() except Exception: logger.error(traceback.format_exc()) def showchangeAuth(self): try: self.changeAuth = changeAuth() self.changeAuth.ipinfo = self.ipinfo self.changeAuth.user = self.user self.changeAuth.start() except Exception: logger.error(traceback.format_exc()) ''' def showchangeFlight(self): try: self.changeFlight = changeFlight() self.changeFlight.ipinfo = self.ipinfo self.changeFlight.user = self.user self.changeFlight.start() except Exception: logger.error(traceback.format_exc()) ''' def openFile(self): try: fileName, _ = QFileDialog.getOpenFileName(self, '打开文件', '/') # print(fileName) data = {"fileName": fileName} res = self.severpostData_nomeassge("get_dic", data)["返回值"] if res != "ok": self.show_message2("警告", "文件错误") elif res == "ok": self.show_message2("提示", "人员信息添加成功！") except Exception: logger.error(traceback.format_exc()) def saveCase(self): try: fileName, _ = QFileDialog.getSaveFileName(None, "选取文件夹", "/停场航班导入模板.xlsx", "xlsx(*.xlsx)") if fileName: wb = Workbook() wb.create_sheet(title="停场航班导入模板", index=0) ws = wb.active ws.title = '航班数据' ws = wb['航班数据'] for row in range(1, 50): for cloumn in range(1, 7): ws.cell(row, cloumn).number_format = '@' ws.cell(1, 1).value = "序号" ws.cell(1, 2).value = "日期" ws.cell(1, 3).value = "机号" ws.cell(1, 4).value = "机位" ws.cell(1, 5).value = "机型" ws.cell(1, 6).value = "发动机" ws.cell(1, 7).value = "录入数据请从第三行开始录入，切勿覆盖第一二行数据！！！" ws.cell(2, 1).value = "1" ws.cell(2, 2).value = "2024/03/21" ws.cell(2, 3).value = "1663" ws.cell(2, 4).value = "722" ws.cell(2, 5).value = "A321" ws.cell(2, 6).value = "V2500" ws.cell(2, 7).value = "录入数据请从第三行开始录入，切勿覆盖第一二行数据！！！" wb.save(fileName) self.show_message2("提示", "导出成功！文件已保存至%s" % fileName) except Exception: self.show_message2("警告", "导出失败，确认%s是否被打开或联系管理员！！！") logger.error(traceback.format_exc()) def saveRisktable(self): try: fileName, _ = QFileDialog.getSaveFileName(None, "选取文件夹", "/风险数据库.xlsx","xlsx(*.xlsx)") if fileName: ip = "http://" + str(self.ipinfo) + "/static/saveRisktable" res = requests.get(url=ip, timeout=30).json()["返回值"] wb = Workbook() wb.create_sheet(title="风险数据库.xlsx", index=0) ws = wb.active ws.title = '风险数据库' ws = wb['风险数据库'] for row in range(1, len(res)+1): for cloumn in range(1, 8): ws.cell(row, cloumn).number_format = '@' ws.cell(1, 1).value = "风险编号" ws.cell(1, 2).value = "状态" ws.cell(1, 3).value = "提示内容" ws.cell(1, 4).value = "触发条件1" ws.cell(1, 5).value = "触发条件2" ws.cell(1, 6).value = "触发条件3" ws.cell(1, 7).value = "触发条件4" ws.cell(1, 8).value = "触发条件5" if len(res) != 0: ii=1 for i in res: for j in range(0, 8): #print(ii,j) ws.cell(int(ii) + 1, j+1).value = i[j] ii+=1 wb.save(fileName) except Exception: print(traceback.format_exc()) def saveAllflight(self): try: index = {"序号": "0", "类型": "9", "航班号": "4", "机型": "2", "发动机": "3", "机号": "1", "计达": "5", "预达": "6","计飞": "7", "机位": "8"} index2 = {1: "序号", 2: "类型", 3: "航班号", 4: "机型", 5: "发动机", 6: "机号", 7: "计达", 8: "预达", 9: "计飞", 10: "机位"} fileName, _ = QFileDialog.getSaveFileName(None, "选取文件夹", "/%s全天航班导出（未含保障结束）.xlsx" % self.selectedtime,"xlsx(*.xlsx)") # print(fileName) if fileName: ip = "http://" + str(self.ipinfo) + "/static/" + "tableWidgetDispaly22/" + "%s" % self.selectedtime res = requests.get(url=ip, timeout=30).json() # print(res) wb = Workbook() wb.create_sheet(title="%s全天航班导出（未含保障结束）.xlsx" % self.selectedtime, index=0) ws = wb.active ws.title = '航班数据' ws = wb['航班数据'] for row in range(1, 400): for cloumn in range(1, 10): ws.cell(row, cloumn).number_format = '@' ws.cell(1, 1).value = "序号" ws.cell(1, 2).value = "类型" ws.cell(1, 3).value = "航班号" ws.cell(1, 4).value = "机型" ws.cell(1, 5).value = "发动机" ws.cell(1, 6).value = "机号" ws.cell(1, 7).value = "计达" ws.cell(1, 8).value = "预达" ws.cell(1, 9).value = "计飞" ws.cell(1, 10).value = "机位" if len(res) != 0: for i in res.keys(): if res[i]["109"] != "4": for j in range(1, 11): if j == 2 and "3U" in res[i]["4"] and "CSC" in res[i]["4"]: ws.cell(int(i) + 2, j).value = "外" + str(res[i][index[index2[j]]]) elif j == 7 or j == 8: text = str(res[i][index[index2[j]]]).replace(":","") if str(res[i][index[index2[j]]]) != "" else "" ws.cell(int(i) + 2, j).value = text elif j == 9: text = str(str(res[i][index[index2[j]]]).split("]")[1]).replace(":","") if "]" in str(res[i][index[index2[j]]]) else "" ws.cell(int(i) + 2, j).value = text else: ws.cell(int(i) + 2, j).value = res[i][index[index2[j]]] wb.save(fileName) self.show_message2("提示", "%s全天航班导出成功！文件已保存至%s" % (self.selectedtime, fileName)) except Exception: self.show_message2("警告", "导出失败，确认%s是否被打开或联系管理员！！！" % fileName) logger.error(traceback.format_exc()) def saveAllflight2(self): try: time2 = datetime.datetime.strptime(self.selectedtime, "%Y%m%d") time1 = str((time2 - datetime.timedelta(days=1)).strftime("%Y%m%d")) index = {"序号": "0", "类型": "9", "航班号": "4", "机型": "2", "发动机": "3", "机号": "1", "计达": "5", "预达": "6","计飞": "7", "机位": "8","放行":"10","工1":"11","工2":"12","工3":"13","工4":"14","备注":"30","班组长":"15"} index2 = {1: "序号", 2: "类型", 3: "航班号", 4: "机型", 5: "发动机", 6: "机号", 7: "计达", 8: "预达", 9: "计飞", 10: "机位",11: "放行",12: "工1",13: "工2",14: "工3",15: "工4",16: "备注",17: "班组长"} fileName, _ = QFileDialog.getSaveFileName(None, "选取文件夹", "/%s航班安排备份导出.xlsx" %(str(time1)+"-"+str(self.selectedtime)[-2:]),"xlsx(*.xlsx)") # print(fileName) wb = Workbook() if fileName: for selectedtime in [self.selectedtime,time1]: ip = "http://" + str(self.ipinfo) + "/static/" + "tableWidgetDispaly11/" + "%s" %selectedtime res = requests.get(url=ip, timeout=30).json() # print(res) wb.create_sheet(title="%s" % selectedtime, index=0) ws = wb.active ws.title = "%s" % selectedtime ws = wb["%s" % selectedtime] for row in range(1, 400): for cloumn in range(1, 18): ws.cell(row, cloumn).number_format = '@' ws.cell(1, 1).value = "序号" ws.cell(1, 2).value = "类型" ws.cell(1, 3).value = "航班号" ws.cell(1, 4).value = "机型" ws.cell(1, 5).value = "发动机" ws.cell(1, 6).value = "机号" ws.cell(1, 7).value = "计达" ws.cell(1, 8).value = "预达" ws.cell(1, 9).value = "计飞" ws.cell(1, 10).value = "机位" ws.cell(1, 11).value = "放行" ws.cell(1, 12).value = "工1" ws.cell(1, 13).value = "工2" ws.cell(1, 14).value = "工3" ws.cell(1, 15).value = "工4" ws.cell(1, 16).value = "备注" ws.cell(1, 17).value = "班组长" if len(res) != 0: for i in res.keys(): for j in range(1, 18): if j == 2: if "3U" not in res[i]["4"] and "CSC" not in res[i]["4"]: ws.cell(int(i) + 2, j).value = "外" + str(res[i][index[index2[j]]]) else: ws.cell(int(i) + 2, j).value = res[i][index[index2[j]]] elif j == 7 or j == 8: text = str(res[i][index[index2[j]]]).replace(":","") if str(res[i][index[index2[j]]]) != "" else "" ws.cell(int(i) + 2, j).value = text elif j == 9: text = str(str(res[i][index[index2[j]]]).split("]")[1]).replace(":","") if "]" in str(res[i][index[index2[j]]]) else "" ws.cell(int(i) + 2, j).value = text else: ws.cell(int(i) + 2, j).value = res[i][index[index2[j]]] wb.save(fileName) self.show_message2("提示", "%s全天航班导出成功！文件已保存至%s" % (self.selectedtime, fileName)) except Exception: self.show_message2("警告", "导出失败，确认%s是否被打开或联系管理员！！！" % fileName) logger.error(traceback.format_exc()) def saveAllflight3(self): try: time2 = datetime.datetime.strptime(self.selectedtime, "%Y%m%d") time1 = str((time2 - datetime.timedelta(days=1)).strftime("%Y%m%d")) index = {"序号": "0", "类型": "9", "航班号": "4", "机型": "2", "发动机": "3", "机号": "1", "计达": "5", "预达": "6","计飞": "7", "机位": "8","工作单":"10","飞单":"11","客舱单":"12","临工单":"13","AMRO记录":"14","备注":"32","备用":"15"} index2 = {1: "序号", 2: "类型", 3: "航班号", 4: "机型", 5: "发动机", 6: "机号", 7: "计达", 8: "预达", 9: "计飞", 10: "机位",11: "工作单",12: "飞单",13: "客舱单",14: "临工单",15: "AMRO记录",16: "备注",17: "备用"} fileName, _ = QFileDialog.getSaveFileName(None, "选取文件夹", "/%s维修记录备份导出.xlsx" %(str(time1)+"-"+str(self.selectedtime)[-2:]),"xlsx(*.xlsx)") # print(fileName) wb = Workbook() if fileName: for selectedtime in [self.selectedtime,time1]: ip = "http://" + str(self.ipinfo) + "/static/" + "tableWidgetDispaly22/" + "%s" %selectedtime res = requests.get(url=ip, timeout=30).json() # print(res) wb.create_sheet(title="%s" % selectedtime, index=0) ws = wb.active ws.title = "%s" % selectedtime ws = wb["%s" % selectedtime] for row in range(1, 400): for cloumn in range(1, 18): ws.cell(row, cloumn).number_format = '@' ws.cell(1, 1).value = "序号" ws.cell(1, 2).value = "类型" ws.cell(1, 3).value = "航班号" ws.cell(1, 4).value = "机型" ws.cell(1, 5).value = "发动机" ws.cell(1, 6).value = "机号" ws.cell(1, 7).value = "计达" ws.cell(1, 8).value = "预达" ws.cell(1, 9).value = "计飞" ws.cell(1, 10).value = "机位" ws.cell(1, 11).value = "工作单" ws.cell(1, 12).value = "飞单" ws.cell(1, 13).value = "客舱单" ws.cell(1, 14).value = "临工单" ws.cell(1, 15).value = "AMRO记录" ws.cell(1, 16).value = "备注" ws.cell(1, 17).value = "备用" if len(res) != 0: for i in res.keys(): for j in range(1, 18): if j == 2: if "3U" not in res[i]["4"] and "CSC" not in res[i]["4"]: ws.cell(int(i) + 2, j).value = "外" + str(res[i][index[index2[j]]]) else: ws.cell(int(i) + 2, j).value = res[i][index[index2[j]]] elif j == 6: text = "B-"+str(res[i][index[index2[j]]]) ws.cell(int(i) + 2, j).value = text elif j == 7 or j == 8: text = str(res[i][index[index2[j]]]).replace(":","") if str(res[i][index[index2[j]]]) != "" else "" ws.cell(int(i) + 2, j).value = text elif j == 9: text = str(str(res[i][index[index2[j]]]).split("]")[1]).replace(":","") if "]" in str(res[i][index[index2[j]]]) else "" ws.cell(int(i) + 2, j).value = text else: ws.cell(int(i) + 2, j).value = res[i][index[index2[j]]] wb.save(fileName) self.show_message2("提示", "%s全天航班导出成功！文件已保存至%s" % (self.selectedtime, fileName)) except Exception: self.show_message2("警告", "导出失败，确认%s是否被打开或联系管理员！！！" % fileName) logger.error(traceback.format_exc()) def saveDealflight(self): try: index = {"序号": "0", "类型": "9", "航班号": "4", "机型": "2", "发动机": "3", "机号": "1", "计达": "5", "预达": "6","计飞": "7", "机位": "8"} index2 = {1: "序号", 2: "类型", 3: "航班号", 4: "机型", 5: "发动机", 6: "机号", 7: "计达", 8: "预达", 9: "计飞", 10: "机位"} fileName, _ = QFileDialog.getSaveFileName(None, "选取文件夹", "/%s交班航班导出.xlsx" % self.selectedtime,"xlsx(*.xlsx)") # print(fileName) if fileName: ip = "http://" + str(self.ipinfo) + "/static/" + "tableWidgetDispaly22/" + "%s" % self.selectedtime res = requests.get(url=ip, timeout=30).json() # print(res) wb = Workbook() wb.create_sheet(title="%s交班航班导出.xlsx" % self.selectedtime, index=0) ws = wb.active ws.title = '航班数据' ws = wb['航班数据'] for row in range(1, 400): for cloumn in range(1, 10): ws.cell(row, cloumn).number_format = '@' ws.cell(1, 1).value = "序号" ws.cell(1, 2).value = "类型" ws.cell(1, 3).value = "航班号" ws.cell(1, 4).value = "机型" ws.cell(1, 5).value = "发动机" ws.cell(1, 6).value = "机号" ws.cell(1, 7).value = "计达" ws.cell(1, 8).value = "预达" ws.cell(1, 9).value = "计飞" ws.cell(1, 10).value = "机位" if len(res) != 0: for i in res.keys(): if res[i]["109"] == "1" or res[i]["109"] == "3": for j in range(1, 11): if j == 2: if "3U" not in res[i]["4"] and "CSC" not in res[i]["4"]: ws.cell(int(i) + 2, j).value = "外" + str(res[i][index[index2[j]]]) else: ws.cell(int(i) + 2, j).value = res[i][index[index2[j]]] elif j == 7 or j == 8: text = str(res[i][index[index2[j]]]).replace(":","") if str(res[i][index[index2[j]]]) != "" else "" ws.cell(int(i) + 2, j).value = text elif j == 9: text = str(str(res[i][index[index2[j]]]).split("]")[1]).replace(":","") if "]" in str(res[i][index[index2[j]]]) else "" ws.cell(int(i) + 2, j).value = text else: ws.cell(int(i) + 2, j).value = res[i][index[index2[j]]] wb.save(fileName) self.show_message2("提示", "%s交班航班导出成功！文件已保存至%s" % (self.selectedtime, fileName)) except Exception: self.show_message2("警告", "导出失败，确认%s是否被打开或联系管理员！！！" % fileName) logger.error(traceback.format_exc()) ################################################################################################################################################ def updateStopFlight(self): try: fileName, _ = QFileDialog.getOpenFileName(self, '打开文件', '/') # print(fileName) data = {"fileName": fileName} res = self.severpostData_nomeassge("updateStopFlight", data)["返回值"] if res != "ok": self.show_message2("警告", "停场航班添加失败！") elif res == "ok": self.show_message2("提示", "停场航班添加成功！") self.QThreadSortNow("main") except Exception: logger.error(traceback.format_exc()) def updateTaskAuto(self): try: if int(self.authority) <= 1: fileName, _ = QFileDialog.getOpenFileName(self, '打开文件', '/') # print(fileName) data = {"fileName": fileName} res = self.severpostData_nomeassge("updateTaskAuto", data)["返回值"] if res != "ok": self.show_message2("警告", "文件错误") elif res == "ok": self.taskAtuoCheck("3") self.show_message2("提示", "准备组任务更新成功！") else: self.show_message2("提示", "权限不够，请联系管理员！") except Exception: # print('登录服务器失败') QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) def updateRiskdb(self): try: if int(self.authority) <= 1: fileName, _ = QFileDialog.getOpenFileName(self, '打开文件', '/') # print(fileName) data = {"fileName": fileName} res = self.severpostData_nomeassge("updateRiskdb", data)["返回值"] if res != "ok": self.show_message2("警告", "文件错误") elif res == "ok": self.show_message2("提示", "风险数据库更新成功！") else: self.show_message2("提示", "权限不够，请联系管理员！") except Exception: # print('登录服务器失败') QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) def show_message2(self, type, str): try: QMessageBox.warning(self, "%s" % type, "%s" % str) except Exception: logger.error(traceback.format_exc()) def QThreadSortDispalyTimer(self, name, dict, dict2, seversts, displayMode): try: if name == "sortTableWidgetDispaly": if displayMode == "A": self.displayLabel = ["备","序号","备","机号","航班信息","机型","机型信息","发动机","备","航班号","备","计达","备","预达", "备","计飞","备","机位","备","类型","备","放行","备","工1","备","工2","备","工3","备","工4", "备","班组长","备","到位","备","放行","备","销夹","备","随机","备","随机","备","保留","备","工作包", "备","进出港城市","备","维修人员","备","放行","备","航班编号","备","任务编号","备","TATD","备","类型", "备","附加消息","备","备","备","备"] ''' self.displayLabel = ["序号", "机号", "机型", "发动机", "航班号", "计达", "预达", "计飞", "机位", "类型", "放行", "工1", "工2", "工3","工4", "班组长", "到位", "放行", "销夹", "随机", "随机", "保留", "工作包", "进出港城市", "维修人员", "放行", "航班编号", "任务编号", "TATD", "类型", "附加消息"] ''' self.tableWidgetFlight.setColumnCount(len(self.displayLabel)) self.tableWidgetFlight.verticalHeader().setVisible(False) self.tableWidgetFlight.setHorizontalHeaderLabels(self.displayLabel) elif displayMode == "B": self.displayLabel = ["序号", "机号", "机型", "发动机", "航班号", "计达", "预达", "计飞", "机位", "类型", "工作单", "飞单", "客舱单", "临工单","AMRO记录", "备用", "到位", "二送", "放行", "销夹", "随机", "随机", "保留", "工作包", "进出港城市", "维修人员", "二送人员","放行", "航班编号", "任务编号", "TATD", "类型", "附加消息"] self.tableWidgetFlight.setColumnCount(len(self.displayLabel)) self.tableWidgetFlight.verticalHeader().setVisible(False) self.tableWidgetFlight.setHorizontalHeaderLabels(self.displayLabel) self.sorttableWidgetDispalydata = {} self.sorttableWidgetDispalydata = dict if self.doubleclickLockUpdate == 0: self.tableWidgetDispaly() # print(self.sorttableWidgetDispalydata) elif name == "sortTableWidgetDispalyALL": self.sorttableWidgetDispalydataALL = {} self.sorttableWidgetDispalydataALL = dict elif name == "sorttableWidgetDisplayChange": self.sortlogchange = {} self.sortlogchange = dict self.tableWidgetDisplayChange() # print(self.sortlogchange) elif name == "sorttableWidgetPeopleDisplay": self.sortdiplaylist = {} self.sortdiplaylist = dict self.peopleOnJob = [""] self.peopleOnJob = dict2 self.tableWidgetPeopleDisplay() # print(self.peopleOnJob) # print(self.sortdiplaylist) elif name == "sorttableWidgetLOGDispaly": self.sortlog = {} self.sortlog = dict self.tableWidgetLOGDispaly() # print(self.sortlog) if seversts == "0": self.severupdatests = "-" self.label_11.setText("已断开") self.label_11.setStyleSheet( "background-color:red;color:white;border-radius:5px;padding:2px;font-weight:bold") self.restartServer(self.ipinfo.split(':')[0],9935) elif seversts == "1" and self.severupdatests == "1": self.label_11.setText("正 常") self.label_11.setStyleSheet( "background-color:green;color:white;border-radius:5px;padding:2px;font-weight:bold") elif seversts == "1" and self.severupdatests == "0": self.label_11.setText("未更新") self.label_11.setStyleSheet( "background-color:yellow;color:red;border-radius:5px;padding:2px;font-weight:bold") except Exception: logger.error(traceback.format_exc()) def QThreadSortDispalyNow(self, name, dict, dict2, seversts, displayMode): try: if name == "sortTableWidgetDispaly": if displayMode == "A": self.displayLabel=["备","序号","备","机号","航班信息","机型","机型信息","发动机","备","航班号","备","计达","备","预达", "备","计飞","备","机位","备","类型","备","放行","备","工1","备","工2","备","工3","备","工4", "备","班组长","备","到位","备","放行","备","销夹","备","随机","备","随机","备","保留","备","工作包", "备","进出港城市","备","维修人员","备","放行","备","航班编号","备","任务编号","备","TATD","备","类型", "备","附加消息","备","备","备","备"] ''' self.displayLabel = ["序号", "机号", "机型", "发动机", "航班号", "计达", "预达", "计飞", "机位", "类型", "放行", "工1", "工2", "工3","工4", "班组长", "到位", "放行", "销夹", "随机", "随机", "保留", "工作包", "进出港城市", "维修人员", "放行", "航班编号","任务编号", "TATD", "类型", "附加消息"] ''' self.tableWidgetFlight.setColumnCount(len(self.displayLabel)) self.tableWidgetFlight.verticalHeader().setVisible(False) self.tableWidgetFlight.setHorizontalHeaderLabels(self.displayLabel) else: self.displayLabel = ["序号", "机号", "机型", "发动机", "航班号", "计达", "预达", "计飞", "机位", "类型", "工作单", "飞单", "客舱单", "临工单","AMRO记录", "备用", "到位", "二送", "放行", "销夹", "随机", "随机", "保留", "工作包", "进出港城市", "维修人员", "二送人员","放行", "航班编号", "任务编号", "TATD", "类型", "附加消息"] self.tableWidgetFlight.setColumnCount(len(self.displayLabel)) self.tableWidgetFlight.verticalHeader().setVisible(False) self.tableWidgetFlight.setHorizontalHeaderLabels(self.displayLabel) self.sorttableWidgetDispalydata = {} self.sorttableWidgetDispalydata = dict # print(self.sorttableWidgetDispalydata) if self.doubleclickLockUpdate == 0: self.tableWidgetDispaly() elif name == "SearchsortTableWidgetDispaly": if displayMode == "A": self.displayLabel = ["备","序号","备","机号","航班信息","机型","机型信息","发动机","备","航班号","备","计达","备","预达", "备","计飞","备","机位","备","类型","备","放行","备","工1","备","工2","备","工3","备","工4", "备","班组长","备","到位","备","放行","备","销夹","备","随机","备","随机","备","保留","备","工作包", "备","进出港城市","备","维修人员","备","放行","备","航班编号","备","任务编号","备","TATD","备","类型", "备","附加消息","备","备","备","备"] ''' self.displayLabel = ["序号", "机号", "机型", "发动机", "航班号", "计达", "预达", "计飞", "机位", "类型", "放行", "工1", "工2","工3","工4", "班组长", "到位", "放行", "销夹", "随机", "随机", "保留", "工作包", "进出港城市", "维修人员","放行", "航班编号","任务编号", "TATD", "类型", "附加消息"] ''' self.tableWidgetFlight.setColumnCount(len(self.displayLabel)) self.tableWidgetFlight.verticalHeader().setVisible(False) self.tableWidgetFlight.setHorizontalHeaderLabels(self.displayLabel) elif displayMode == "B": self.displayLabel =["序号", "机号", "机型", "发动机", "航班号", "计达", "预达", "计飞", "机位", "类型", "工作单", "飞单", "客舱单", "临工单","AMRO记录", "备用", "到位", "二送", "放行", "销夹", "随机", "随机", "保留", "工作包", "进出港城市", "维修人员", "二送人员","放行", "航班编号", "任务编号", "TATD", "类型", "附加消息"] self.tableWidgetFlight.setColumnCount(len(self.displayLabel)) self.tableWidgetFlight.verticalHeader().setVisible(False) self.tableWidgetFlight.setHorizontalHeaderLabels(self.displayLabel) self.sorttableWidgetDispalydata = {} self.sorttableWidgetDispalydata = dict if self.doubleclickLockUpdate == 0: self.tableWidgetDispaly() # print(self.sorttableWidgetDispalydata) elif name == "sortTableWidgetDispalyALL": self.sorttableWidgetDispalydataALL = {} self.sorttableWidgetDispalydataALL = dict elif name == "sorttableWidgetDisplayChange": self.sortlogchange = {} self.sortlogchange = dict self.tableWidgetDisplayChange() # print(self.sortlogchange) elif name == "sorttableWidgetPeopleDisplay": self.sortdiplaylist = {} self.sortdiplaylist = dict self.peopleOnJob = [""] self.peopleOnJob = dict2 self.tableWidgetPeopleDisplay() # print(self.peopleOnJob) # print(self.sortdiplaylist) elif name == "sorttableWidgetLOGDispaly": self.sortlog = {} self.sortlog = dict self.tableWidgetLOGDispaly() # print(self.sortlog) elif name == "sorttableWidgetPHONEDispaly": self.sorttableWidgetPHONEDispalydata = {} self.sorttableWidgetPHONEDispalydata = dict self.tableWidgetPhoneDispaly() if seversts == "0": self.severupdatests = "-" self.label_11.setText("已断开") self.label_11.setStyleSheet( "background-color:red;color:white;border-radius:5px;padding:2px;font-weight:bold") self.restartServer(self.ipinfo.split(':')[0],9935) elif seversts == "1" and self.severupdatests == "1": self.label_11.setText("正 常") self.label_11.setStyleSheet( "background-color:green;color:white;border-radius:5px;padding:2px;font-weight:bold") elif seversts == "1" and self.severupdatests == "0": self.label_11.setText("未更新") self.label_11.setStyleSheet( "background-color:yellow;color:red;border-radius:5px;padding:2px;font-weight:bold") except Exception: logger.error(traceback.format_exc()) def restartServer(self,serverIP,serverPort): client = socket.socket(socket.AF_INET, socket.SOCK_STREAM) client.settimeout(120) client.connect((serverIP, serverPort)) client.send("restart".encode()) client.close() QMessageBox.warning(self, "提示", "服务器端正在尝试自动重启服务器，请等待30S后刷新查看显示状态！若仍然断开，请联系管理员！") def initlocalipback(self): try: if os.path.exists("D:/flightinfo/logs/localip.code") is True: read_path = "D:/flightinfo/logs/localip.code" with open(read_path, "r", encoding="utf-8") as f2: rember_2 = f2.read() if ';;' in rember_2: self.localip = rember_2.split(';;')[0] self.localtoken = rember_2.split(';;')[-1] QMessageBox.warning(self, "提示", "本地网络电话获取缓存成功，可拨号尝试，如拨号失败则需重新配置！") except Exception: logger.error(traceback.format_exc()) def openmaintainAuthCheck(self): self.maintainAuthCheckSts=1 QMessageBox.warning(self, "提示", "授权检查已开启，将核对人员发动机授权情况！") def closemaintainAuthCheck(self): self.maintainAuthCheckSts=0 QMessageBox.warning(self, "提示", "授权检查已关闭，将无法核对人员发动机授权情况！") def setlocalipback(self, token): try: self.localtoken = None self.localtoken = token if "auth=" in token: QMessageBox.warning(self, "提示", "本地网络电话配置成功！") save_path = "D:/flightinfo/logs/localip.code" with open(save_path, "w", encoding="utf-8") as f1: f1.write(str(self.localip) + ";;" + str(self.localtoken)) self.lineEdit_phonenum.setText("") else: QMessageBox.warning(self, "提示", "本地网络电话配置失败，本地呼叫无法使用，请确认IP正确，可尝试重启IP电话后再试！") except Exception: logger.error(traceback.format_exc()) def QThreadSortTimer(self): try: nowDay = datetime.datetime.now().strftime("%Y%m%d") tomorr = (datetime.date.today() + datetime.timedelta(days=1)).strftime("%Y%m%d") yester = (datetime.date.today() - datetime.timedelta(days=1)).strftime("%Y%m%d") if self.selectedtime == nowDay: datestr = "2" elif self.selectedtime == tomorr: datestr = "3" elif self.selectedtime == yester: datestr = "1" else: datestr = "4" ip = "http://"+self.ipinfo+"/static/VinCheck/"+self.vin+"/"+self.displayMode+"/%s"%datestr res = requests.get(url=ip, timeout=30).json()["返回值"] self.sum += 1 self.flightsum += 1 #print(self.doubleclickLockUpdate) if self.loginSts == True: # print("多线程刷新1") self.FLIGHTonChange_text = self.lineEdit_flight.text() self.peolpleonChange_text = self.lineEdit_people.text() self.changeonChange_text = self.lineEdit_change.text() self.logonChange_text = self.lineEdit_log.text() if (self.doubleclickLockUpdate==0 and res =="ok" and self.flightsum % 20 == 0) or\ (self.doubleclickLockUpdate==0 and datestr =="4" and self.flightsum % 20 == 0): print(datetime.datetime.now(),"开始数据库刷新", self.vin) th1 = QThread() self.sortTableWidgetDispalyThread1 = sortdisplaySever("sortTableWidgetDispaly", self.ipinfo, self.selectedtime, self.FLIGHTonChange_text, self.displayMode, "0", self.displaySelect_mode, th1) self.sortTableWidgetDispalyThread1.sortupdate.connect(self.QThreadSortDispalyTimer) self.sortTableWidgetDispalyThread1.moveToThread(th1) th1.started.connect(self.sortTableWidgetDispalyThread1.run) th1.start() if datestr !="4": ip = "http://"+self.ipinfo+"/static/updateVin/" + self.displayMode + "/%s" % datestr self.vin = requests.get(url=ip, timeout=30).json()["返回值"] print(datetime.datetime.now(),"更新刷新",self.vin) elif self.doubleclickLockUpdate==0 and res !="ok": print(datetime.datetime.now(),"开始读取刷新", self.vin) th1234 = QThread() self.sortTableWidgetDispalyThread1234 = sortdisplaySever("sortTableWidgetDispaly", self.ipinfo, self.selectedtime, self.FLIGHTonChange_text, self.displayMode, "1", self.displaySelect_mode, th1234) self.sortTableWidgetDispalyThread1234.sortupdate.connect(self.QThreadSortDispalyTimer) self.sortTableWidgetDispalyThread1234.moveToThread(th1234) th1234.started.connect(self.sortTableWidgetDispalyThread1234.run) th1234.start() self.flightsum = 0 ip = "http://"+self.ipinfo+"/static/getVin/"+ self.displayMode + "/%s" % datestr self.vin = requests.get(url=ip, timeout=30).json()["返回值"] print(datetime.datetime.now(),"仅仅读取",self.vin) ''' else: th11111 = QThread() self.sortTableWidgetDispalyThread11111 = sortdisplaySever("sortTableWidgetDispalyALL", self.ipinfo, self.selectedtime, self.FLIGHTonChange_text, self.displayMode, "1", self.displaySelect_mode, th11111) self.sortTableWidgetDispalyThread11111.sortupdate.connect(self.QThreadSortDispalyTimer) self.sortTableWidgetDispalyThread11111.moveToThread(th11111) th11111.started.connect(self.sortTableWidgetDispalyThread11111.run) th11111.start() ''' if self.loginSts == True and self.sum % 20 == 0: th2 = QThread() self.sorttableWidgetDisplayChangeThread2 = sortdisplaySever("sorttableWidgetDisplayChange", self.ipinfo, self.selectedtime, self.changeonChange_text, "", "", "", th2) self.sorttableWidgetDisplayChangeThread2.sortupdate.connect(self.QThreadSortDispalyTimer) self.sorttableWidgetDisplayChangeThread2.moveToThread(th2) th2.started.connect(self.sorttableWidgetDisplayChangeThread2.run) th2.start() th3 = QThread() self.sorttableWidgetPeopleDisplayThread3 = sortdisplaySever("sorttableWidgetPeopleDisplay", self.ipinfo, self.selectedtime, self.peolpleonChange_text, "", self.selectedbc, "", th3) self.sorttableWidgetPeopleDisplayThread3.sortupdate.connect(self.QThreadSortDispalyTimer) self.sorttableWidgetPeopleDisplayThread3.moveToThread(th3) th3.started.connect(self.sorttableWidgetPeopleDisplayThread3.run) th3.start() th4 = QThread() self.sorttableWidgetLOGDispalyThread4 = sortdisplaySever("sorttableWidgetLOGDispaly", self.ipinfo, self.selectedtime, self.logonChange_text, "", "", "", th4) self.sorttableWidgetLOGDispalyThread4.sortupdate.connect(self.QThreadSortDispalyTimer) self.sorttableWidgetLOGDispalyThread4.moveToThread(th4) th4.started.connect(self.sorttableWidgetLOGDispalyThread4.run) th4.start() self.updatecheck() if self.loginSts == True and self.sum % 2400 == 0: self.taskAtuoCheck("2") self.sum=0 except Exception: logger.error(traceback.format_exc()) def QThreadSortNow(self, name): try: if "main" in str(name) and self.doubleclickLockUpdate == 0: # print(datetime.datetime.now()) th11 = QThread() self.sortTableWidgetDispalyThread11 = sortdisplaySever("sortTableWidgetDispaly", self.ipinfo, self.selectedtime, self.FLIGHTonChange_text, self.displayMode, "0", self.displaySelect_mode, th11) self.sortTableWidgetDispalyThread11.sortupdate.connect(self.QThreadSortDispalyNow) self.sortTableWidgetDispalyThread11.moveToThread(th11) th11.started.connect(self.sortTableWidgetDispalyThread11.run) th11.start() nowDay = datetime.datetime.now().strftime("%Y%m%d") tomorr = (datetime.date.today() + datetime.timedelta(days=1)).strftime("%Y%m%d") yester = (datetime.date.today() - datetime.timedelta(days=1)).strftime("%Y%m%d") if self.selectedtime == nowDay: datestr = "2" elif self.selectedtime == tomorr: datestr = "3" elif self.selectedtime == yester: datestr = "1" else: datestr = "4" if datestr != "4": ip = "http://" + self.ipinfo + "/static/updateVin/" + self.displayMode + "/%s" % datestr self.vin = requests.get(url=ip, timeout=30).json()["返回值"] print(datetime.datetime.now(), "人工更新刷新", self.vin) elif "ALL" in str(name) and self.doubleclickLockUpdate == 0: th111111 = QThread() self.sortTableWidgetDispalyThread111111 = sortdisplaySever("sortTableWidgetDispalyALL", self.ipinfo, self.selectedtime, self.FLIGHTonChange_text, self.displayMode, "1", self.displaySelect_mode, th111111) self.sortTableWidgetDispalyThread111111.sortupdate.connect(self.QThreadSortDispalyNow) self.sortTableWidgetDispalyThread111111.moveToThread(th111111) th111111.started.connect(self.sortTableWidgetDispalyThread111111.run) th111111.start() elif "search" in str(name) and self.doubleclickLockUpdate == 0: # print(datetime.datetime.now()) th111 = QThread() self.sortTableWidgetDispalyThread111 = sortdisplaySever("SearchsortTableWidgetDispaly", self.ipinfo, self.selectedtime, self.FLIGHTonChange_text, self.displayMode, self.sorttableWidgetDispalydataALL, self.displaySelect_mode, th111) self.sortTableWidgetDispalyThread111.sortupdate.connect(self.QThreadSortDispalyNow) self.sortTableWidgetDispalyThread111.moveToThread(th111) th111.started.connect(self.sortTableWidgetDispalyThread111.run) th111.start() elif "change" in str(name): # print(datetime.datetime.now()) th12 = QThread() self.sorttableWidgetDisplayChangeThread12 = sortdisplaySever("sorttableWidgetDisplayChange", self.ipinfo, self.selectedtime, self.changeonChange_text, "", "", "", th12) self.sorttableWidgetDisplayChangeThread12.sortupdate.connect(self.QThreadSortDispalyNow) self.sorttableWidgetDisplayChangeThread12.moveToThread(th12) th12.started.connect(self.sorttableWidgetDisplayChangeThread12.run) th12.start() elif "people" in str(name): # print(datetime.datetime.now()) th13 = QThread() self.sorttableWidgetPeopleDisplayThread13 = sortdisplaySever("sorttableWidgetPeopleDisplay", self.ipinfo, self.selectedtime, self.peolpleonChange_text, "", self.selectedbc, self.searchpeoplestr, th13) self.sorttableWidgetPeopleDisplayThread13.sortupdate.connect(self.QThreadSortDispalyNow) self.sorttableWidgetPeopleDisplayThread13.moveToThread(th13) th13.started.connect(self.sorttableWidgetPeopleDisplayThread13.run) th13.start() elif "log" in str(name): # print(datetime.datetime.now()) th14 = QThread() self.sorttableWidgetLOGDispalyThread14 = sortdisplaySever("sorttableWidgetLOGDispaly", self.ipinfo, self.selectedtime, self.logonChange_text, "", "", "", th14) self.sorttableWidgetLOGDispalyThread14.sortupdate.connect(self.QThreadSortDispalyNow) self.sorttableWidgetLOGDispalyThread14.moveToThread(th14) th14.started.connect(self.sorttableWidgetLOGDispalyThread14.run) th14.start() elif "setlocalip" in str(name): th99 = QThread() self.setlocalipThread = setlocalip(self.localip, th99) self.setlocalipThread.localipupdate.connect(self.setlocalipback) self.setlocalipThread.moveToThread(th99) th99.started.connect(self.setlocalipThread.run) th99.start() elif "phone" in str(name): th15 = QThread() self.sorttableWidgetPHONEDispaly15 = sortdisplaySever("sorttableWidgetPHONEDispaly", self.ipinfo, "", self.changeonPhone_text, "", "", "", th15) self.sorttableWidgetPHONEDispaly15.sortupdate.connect(self.QThreadSortDispalyNow) self.sorttableWidgetPHONEDispaly15.moveToThread(th15) th15.started.connect(self.sorttableWidgetPHONEDispaly15.run) th15.start() except Exception: logger.error(traceback.format_exc()) def tableWidgetLOGDispaly(self): try: log = self.sortlog self.tableWidgetLOG.setRowCount(len(log.keys())) if log != "": for i in log.keys(): self.tableWidgetLOG.setItem(int(i), 0, QTableWidgetItem(str(int(i)+1))) self.tableWidgetLOG.setItem(int(i), 1, QTableWidgetItem(str(log[i]))) self.tableWidgetLOG.item(int(i), 0).setTextAlignment(Qt.AlignmentFlag.AlignCenter) self.tableWidgetLOG.resizeColumnToContents(0) self.tableWidgetLOG.setColumnWidth(1, 240) self.tableWidgetLOG.resizeRowsToContents() except Exception: logger.error(traceback.format_exc()) def itemclick(self, row, column): if self.doubleclickLockUpdate == 1 and self.doubleclickLock == 0: self.doubleclickLockUpdate = 0 #self.QThreadSortNow("ALL") #self.QThreadSortNow("main") try: self.tableWidgetFlight.cellChanged.disconnect(self.cellchanged) except: pass def itemclick2(self, row, column): try: # print(self.doubleclickLock) if (int(column) - self.tableWidgetFlight.columnCount() == -1 or 9 < column < 16) and self.doubleclickLock == 0: self.doubleclickLockUpdate=1 self.clickrow = row self.clickcolumn = column self.olditem = self.tableWidgetFlight.item(row, column).text() item = self.tableWidgetFlight.item(row, column) # 如果单元格对象不存在，则返回默认的背景色 if not item: self.color=self.tableWidgetFlight.palette().color(QPalette.Base) else: # 获取并返回单元格的背景色 self.color=item.background() self.tableWidgetFlight.cellChanged.connect(self.cellchanged) else: self.doubleclickLockUpdate = 0 except Exception: logger.error(traceback.format_exc()) def cellchanged(self, row, column): if self.clickrow == row and self.clickcolumn == column and self.displayMode =="A": self.clickrow = None self.clickcolumn = None try: #t1 = datetime.datetime.now() self.doubleclickLock = 1 self.newitem = self.tableWidgetFlight.item(row, column).text().replace("\"","*").replace("\\",";").replace("\'","*").replace("/","、").replace("#","*") flightid = self.tableWidgetFlight.item(row, self.tableWidgetFlight.columnCount() - 5).text() flighttype = self.tableWidgetFlight.item(row, 9).text() acno = self.tableWidgetFlight.item(row, 1).text() flightno = self.tableWidgetFlight.item(row, 4).text() bgtype = str(self.displayLabel[column]).replace("/","") if int(column) - self.tableWidgetFlight.columnCount() == -1: item = self.tableWidgetFlight.item(row, column) if item.text() != "": text = item.text().replace("\"","*").replace("\\",";").replace("\'","*").replace("/","、").replace("#","*") else: text = "清空项目12345678987654321" ip = "http://" + str(self.ipinfo) + "/static/updateEidteItem/" + "%s/" % str(text) + "%s/" % str(flightid) + "%s/" % str(self.displayMode) + "%s/" % str(flighttype) + "%s" % str(self.selectedtime) # print(ip) ip2 = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "航班显示模块：%s,%s%s由%s变更为%s%s/" % (acno, flightno, bgtype, self.olditem, self.newitem,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) try: requests.get(url=ip, timeout=30).json() requests.get(url=ip2, timeout=30).json() except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) elif 9 < column < 16 and self.olditem != self.newitem: item = self.tableWidgetFlight.item(row, column) if item.text() != "": text = item.text().replace("\"","*").replace("\\",";").replace("\'","*").replace("/","、").replace("#","*") if "!" in str(text): text = text.replace("!", "") if "√" in str(text): text = text.replace("√", "") else: text = "清空项目12345678987654321" ip = "http://" + str(self.ipinfo) + "/static/checkPglist/%s/%s/%s" % (text, self.selectedtime, self.selectedbc) # print(ip) try: res = requests.get(url=ip, timeout=30).json() if res["返回值"] == "fail": self.tableWidgetFlight.setItem(int(row), column, QTableWidgetItem(str(self.olditem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor(self.color)) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) QMessageBox.warning(self, "警告", "%sAMRO未考勤，请核实考勤名单或者检查人员字母！" % text) elif res["返回值"] == "OK" and self.maintainAuthCheckSts == 1 and text != "清空项目12345678987654321" and column == 10 and "3U" not in str(flightno) and "CSC" not in str(flightno): ####需要加一把锁，有功能开关调用 airplanetype=self.tableWidgetFlight.item(row, 2).text() engtype=self.tableWidgetFlight.item(row, 3).text() if "A3" in airplanetype and engtype[0:3] =="LEA": auttype="ALEAP" elif "A3" in airplanetype and engtype[0:3] !="LEA": auttype = "ACSC" elif "737NG" in airplanetype: auttype = "737NG" elif "737MAX" in airplanetype: auttype = "737MAX" else: auttype = "ALL" ipp = "http://" + str(self.ipinfo) + "/static/maintainAuthCheck/%s/%s" % (text, auttype) try: res = requests.get(url=ipp, timeout=30).json() if res["返回值"] == "fail": self.tableWidgetFlight.setItem(int(row), column,QTableWidgetItem(str(self.olditem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor(self.color)) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) QMessageBox.warning(self, "警告", "%s不满足发动机授权条件！请核对信息或者更新授权信息！" % text) elif res["返回值"] == "ok": self.tableWidgetFlight.setItem(int(row), column,QTableWidgetItem(str(self.newitem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor("yellow")) self.tableWidgetFlight.item(int(row), column).setForeground(QColor("black")) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) ip = "http://" + str(self.ipinfo) + "/static/updateDragDropItem/%s/%s/%s/%s/%s/%s" % (column, text, flightid, self.displayMode, flighttype, self.selectedtime) # print(ip) ip2 = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "航班显示模块：%s,%s%s由%s变更为%s%s/" % (acno, flightno, bgtype, self.olditem, self.newitem,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) try: requests.get(url=ip, timeout=30).json() requests.get(url=ip2, timeout=30).json() except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) except: self.tableWidgetFlight.setItem(int(row), column, QTableWidgetItem(str(self.olditem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor(self.color)) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) elif (res["返回值"] == "OK" and (self.maintainAuthCheckSts == 0 or "3U" in str(flightno) or "CSC" in str(flightno))) or text == "清空项目12345678987654321" or column != 10: self.tableWidgetFlight.setItem(int(row), column, QTableWidgetItem(str(self.newitem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor("yellow")) self.tableWidgetFlight.item(int(row), column).setForeground(QColor("black")) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) ip = "http://" + str(self.ipinfo) + "/static/updateDragDropItem/%s/%s/%s/%s/%s/%s" % (column, text, flightid, self.displayMode, flighttype, self.selectedtime) # print(ip) ip2 = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "航班显示模块：%s,%s%s由%s变更为%s%s/" % (acno, flightno, bgtype, self.olditem, self.newitem,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) try: requests.get(url=ip, timeout=30).json() requests.get(url=ip2, timeout=30).json() except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) else: self.tableWidgetFlight.setItem(int(row), column, QTableWidgetItem(str(self.olditem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor(self.color)) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) except Exception: self.tableWidgetFlight.setItem(int(row), column, QTableWidgetItem(str(self.olditem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor(self.color)) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) self.doubleclickLockUpdate = 0 self.doubleclickLock = 0 self.tableWidgetFlight.cellChanged.disconnect(self.cellchanged) self.QThreadSortNow("main") #t2 = datetime.datetime.now() #print(f'【编辑操作】【客户端计时】:{t2 - t1}') except Exception: self.doubleclickLockUpdate = 0 self.clickrow = None self.clickcolumn = None try: self.tableWidgetFlight.cellChanged.disconnect(self.cellchanged) except: pass self.tableWidgetFlight.setItem(int(row), column, QTableWidgetItem(str(self.olditem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor(self.color)) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) logger.error(traceback.format_exc()) self.doubleclickLock = 0 self.QThreadSortNow("main") elif self.clickrow == row and self.clickcolumn == column and self.displayMode =="B": self.clickrow = None self.clickcolumn = None try: self.doubleclickLock = 1 self.newitem = self.tableWidgetFlight.item(row, column).text() flightid = self.tableWidgetFlight.item(row, self.tableWidgetFlight.columnCount() - 5).text() flighttype = self.tableWidgetFlight.item(row, 9).text() acno = self.tableWidgetFlight.item(row, 1).text() flightno = self.tableWidgetFlight.item(row, 4).text() bgtype = str(self.displayLabel[column]).replace("/","") if int(column) - self.tableWidgetFlight.columnCount() == -1: item = self.tableWidgetFlight.item(row, column) if item.text() != "": text = item.text().replace("\"","#").replace("\\",";").replace("\'","#") else: text = "清空项目12345678987654321" ip = "http://" + str(self.ipinfo) + "/static/updateEidteItem/" + "%s/" % str(text) + "%s/" % str(flightid) + "%s/" % str(self.displayMode) + "%s/" % str(flighttype) + "%s" % str(self.selectedtime) # print(ip) ip2 = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "维修记录模块：%s,%s%s由%s变更为%s%s/" % (acno, flightno, bgtype, self.olditem, self.newitem,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) try: requests.get(url=ip, timeout=30).json() requests.get(url=ip2, timeout=30).json() except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) elif 9 < column < 16 and self.olditem != self.newitem: item = self.tableWidgetFlight.item(row, column) if item.text() != "": text = item.text().replace("\"","#").replace("\\",";").replace("\'","#") if "!" in str(text): text = text.replace("!", "") if "√" in str(text): text = text.replace("√", "") else: text = "清空项目12345678987654321" # print(ip) try: if text != "清空项目12345678987654321": ####需要加一把锁，有功能开关调用 ip = "http://" + str(self.ipinfo) + "/static/updateDragDropItem/%s/%s/%s/%s/%s/%s" % (column, text, flightid, self.displayMode, flighttype, self.selectedtime) # print(ip) ip2 = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "维修记录模块：%s,%s%s由%s变更为%s%s/" % (acno, flightno, bgtype, self.olditem, self.newitem,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) try: requests.get(url=ip, timeout=30).json() self.tableWidgetFlight.setItem(int(row), column, QTableWidgetItem(str(self.newitem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor("yellow")) self.tableWidgetFlight.item(int(row), column).setForeground(QColor("black")) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) requests.get(url=ip2, timeout=30).json() except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) elif text == "清空项目12345678987654321": ip = "http://" + str(self.ipinfo) + "/static/updateDragDropItem/%s/%s/%s/%s/%s/%s" % (column, text, flightid, self.displayMode, flighttype, self.selectedtime) # print(ip) ip2 = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "维修记录模块：%s,%s%s由%s变更为%s%s/" % (acno, flightno, bgtype, self.olditem, self.newitem,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) try: requests.get(url=ip, timeout=30).json() self.tableWidgetFlight.setItem(int(row), column, QTableWidgetItem(str(self.newitem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor("yellow")) self.tableWidgetFlight.item(int(row), column).setForeground(QColor("black")) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) requests.get(url=ip2, timeout=30).json() except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) else: self.tableWidgetFlight.setItem(int(row), column, QTableWidgetItem(str(self.olditem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor(self.color)) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) except Exception: self.tableWidgetFlight.setItem(int(row), column, QTableWidgetItem(str(self.olditem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor(self.color)) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) self.doubleclickLockUpdate = 0 self.doubleclickLock = 0 self.tableWidgetFlight.cellChanged.disconnect(self.cellchanged) self.QThreadSortNow("main") except Exception: self.doubleclickLockUpdate = 0 self.clickrow = None self.clickcolumn = None try: self.tableWidgetFlight.cellChanged.disconnect(self.cellchanged) except: pass self.tableWidgetFlight.setItem(int(row), column, QTableWidgetItem(str(self.olditem))) self.tableWidgetFlight.item(int(row), column).setBackground(QColor(self.color)) self.tableWidgetFlight.item(int(row), column).setTextAlignment(Qt.AlignmentFlag.AlignCenter) logger.error(traceback.format_exc()) self.doubleclickLock = 0 self.QThreadSortNow("main") def btnClick(self, item): if int(self.authority) != 3: try: btn = self.sender() now_2=datetime.datetime.now()- datetime.timedelta(seconds=2) print(self.changeupdatetime,now_2) if btn: row = self.tableWidget.indexAt(btn.pos()).row() a = self.tableWidget.item(row, 3).text() self.severpost_nomeassge("dealLogs", "/%s" % self.user, "/%s" % a, "", "") self.QThreadSortNow("change") if self.changeupdatetime < now_2: self.changeupdatetime = datetime.datetime.now() self.QThreadSortNow("main") except Exception: logger.error(traceback.format_exc()) else: QMessageBox.warning(self, "提示", "权限不够，请联系管理员！") def tableWidgetDisplayChange(self): try: log = self.sortlogchange self.tableWidget.setRowCount(len(log.keys())) if log != "": for i in log.keys(): btnList = [QPushButton('处理')] self.tableWidget.setItem(int(i), 0, QTableWidgetItem(str(int(i)+1))) self.tableWidget.setItem(int(i), 1, QTableWidgetItem(str(log[i][2]))) self.tableWidget.setItem(int(i), 3, QTableWidgetItem(str(log[i][0]))) self.tableWidget.setItem(int(i), 4, QTableWidgetItem(str(log[i][1]))) self.tableWidget.setItem(int(i), 5, QTableWidgetItem(str(log[i][10]))) self.tableWidget.setCellWidget(int(i), 2, btnList[0]) self.tableWidget.item(int(i), 0).setForeground(QColor('red')) self.tableWidget.item(int(i), 1).setForeground(QColor('red')) self.tableWidget.item(int(i), 0).setTextAlignment(Qt.AlignmentFlag.AlignCenter) self.tableWidget.item(int(i), 1).setToolTip("%s" % str(log[i][10])) for btn in btnList: btn.clicked.connect(self.btnClick) self.tableWidget.setColumnHidden(5, True) self.tableWidget.setColumnHidden(4, True) self.tableWidget.setColumnHidden(3, True) self.tableWidget.resizeColumnToContents(0) self.tableWidget.setColumnWidth(2, 40) self.tableWidget.setColumnWidth(1, 210) self.tableWidget.resizeRowsToContents() except Exception: logger.error(traceback.format_exc()) def generateMenu3(self, pos): try: for i in self.tableWidget_3.selectionModel().selection().indexes(): menu = QMenu() item2 = menu.addAction('拨打IP电话') screenPos = self.tableWidget_3.mapToGlobal(pos) action = menu.exec(screenPos) rowIndex = i.row() phonenum = self.tableWidget_3.item(rowIndex, 3).text() if action == item2: if self.localip != None and self.localtoken != None: try: data = {"PHB_AutoDialNumber": phonenum, "ReturnPage": "/contacts.htm", "AutoDialSubmit": "submit", "PHB_AutoDialLine": "1" } header = { "Accept": "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9", "Connection": "keep-alive", "Cookie": self.localtoken } requests.post(url="http://%s/contacts.htm" % self.localip, data=data, headers=header) except Exception: self.show_info("警告", "拨号失败,请检查IP后重新配置或联系管理员！") logger.error(traceback.format_exc()) else: self.show_info("警告", "使用前请配置IP电话！") return except Exception: logger.error(traceback.format_exc()) def generateMenu2(self, pos): try: for i in self.tableWidgetPerson.selectionModel().selection().indexes(): menu = QMenu() item1 = menu.addAction('查看详情') item2 = menu.addAction('拨打IP电话') screenPos = self.tableWidgetPerson.mapToGlobal(pos) action = menu.exec(screenPos) rowIndex = i.row() colnum = self.tableWidgetPerson.columnCount() name = self.tableWidgetPerson.item(rowIndex, 1).text() # print(name) if action == item2: ip = "http://" + str(self.ipinfo) + "/static/get_empNos_phoone/%s" % name infos = requests.get(url=ip, timeout=30).json() # print(self.localtoken) # ''' if infos == {}: self.show_info("警告", "无法查询到%s个人信息，请更新后尝试！！" % name) else: try: # print(infos["电话"]) data = {"PHB_AutoDialNumber": infos["电话"], "ReturnPage": "/contacts.htm", "AutoDialSubmit": "submit", "PHB_AutoDialLine": "1" } header = { "Accept": "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9", "Connection": "keep-alive", "Cookie": self.localtoken } requests.post(url="http://%s/contacts.htm" % self.localip, data=data, headers=header) except Exception: logger.error(traceback.format_exc()) # ''' return elif action == item1: ip = "http://" + str(self.ipinfo) + "/static/get_empNos_phoone/%s" % name infos = requests.get(url=ip, timeout=30).json() # print(infos) # ''' if infos == {}: self.show_info("警告", "无法查询到%s个人信息，请更新后尝试！！" % name) else: ip = "http://" + str(self.ipinfo) + "/static/get_empNos_phoone/%s" % name infos = requests.get(url=ip, timeout=30).json() self.checkLoadSingal = checkLoadSingal() self.checkLoadSingal.worknum = infos["工号"] self.checkLoadSingal.ipinfo = self.ipinfo self.checkLoadSingal.name = name self.checkLoadSingal.selectedtime = self.selectedtime self.checkLoadSingal.start() # print("正在开发") else: return except Exception: logger.error(traceback.format_exc()) def LM_TSK_SURE_PG_NOW(self, id, empNos, type, shiftDate, shift): dict = {"taskid": id, "empNos": empNos, "type": type, "shiftDate": shiftDate, "shift": shift } res = self.severpostData_nomeassge("LM_TSK_SURE_PG", data=dict)["返回值"] return res def send_dingdong(self, a, b, c, d, e, f, g, h, i, j, k, l): dict_dingdong = {"acno": a, "actype": b, "tasktype": c, "tatd": d, "bay": e, "taskid": f, "wxemp": g, "fxemp": h, "wx": i, "fx": j, "ecsj":k, "msgInfo": l } res = self.severpostData_nomeassge("dingdong", data=dict_dingdong)["返回值"] return res def getRiskData(self,bay,flighttype): if "送" in flighttype or flighttype == "航前": type="出港提示" else: type = "进港提示" res="" try: ip = "http://" + str(self.ipinfo) + "/static/getRiskData/" + "%s/" % bay + "%s" % type res=requests.get(url=ip, timeout=30).json()["返回值"] except Exception: print(traceback.format_exc()) QMessageBox.warning(self, "风险提示失效", "风险提示推送功能失效请联系管理员！") return res def generateMenu(self, pos): if int(self.authority) < 3 and self.displayMode =="A": try: zydy = {"短停": "TR", "航后": "AF", "航前": "AP", "特后前": "TAF", "未显示": ""} for i in self.tableWidgetFlight.selectionModel().selection().indexes(): ''' col_dic = {"0": "序号", "1": "机号", "2": "机型", "3": "发动机", "4": "航班号", "5": "计达", "6": "预达", "7": "计飞", "8": "机位", "9": "类型", "10": "放行", "11": "工1", "12": "工2", "13": "工3", "14": "工4", "15": "班组长", "16": "到位", "18": "放行","19": "销夹", "17": "二送", "20": "随机", "21": "随机", "22": "保留", "23": "工作包", "24": "进出港城市","25": "维修人员", "26": "二送人员", "27": "放行", "28": "航班编号", "29": "任务编号","30":"TATD","31":"类型"，"32":"附加消息"} ''' menu = QMenu() item1 = menu.addAction('维修人员派工') item2 = menu.addAction('放行人员派工') item3 = menu.addAction('二送人员派工') item4 = menu.addAction('推送维修人员') item5 = menu.addAction('推送放行人员') item6 = menu.addAction('推送二送人员') item7 = menu.addAction('确认通知') item8 = menu.addAction('人工接机到位') item9 = menu.addAction('人工确认放行') item10 = menu.addAction('人工确认随机到位') item11 = menu.addAction('人工确认二送到位') item12 = menu.addAction('人工确认销夹取下') item13 = menu.addAction('一键派工&通知') item15 = menu.addAction('电话通知') item16 = menu.addAction('查看工作包') item17 = menu.addAction('删除航班') item18 = menu.addAction('工作交接') screenPos = self.tableWidgetFlight.mapToGlobal(pos) action = menu.exec(screenPos) rowIndex = i.row() colnum = self.tableWidgetFlight.columnCount() # print(colnum) acno = self.tableWidgetFlight.item(rowIndex, 1).text() flightno = self.tableWidgetFlight.item(rowIndex, 4).text() qw1 = self.tableWidgetFlight.item(rowIndex, 11).text().replace("!", "") if "!" in self.tableWidgetFlight.item(rowIndex, 11).text() else self.tableWidgetFlight.item(rowIndex, 11).text() qw2 = self.tableWidgetFlight.item(rowIndex, 12).text().replace("!", "") if "!" in self.tableWidgetFlight.item(rowIndex, 12).text() else self.tableWidgetFlight.item(rowIndex, 12).text() g1 = self.tableWidgetFlight.item(rowIndex, 13).text().replace("!", "") if "!" in self.tableWidgetFlight.item(rowIndex, 13).text() else self.tableWidgetFlight.item(rowIndex, 13).text() g2 = self.tableWidgetFlight.item(rowIndex, 14).text().replace("!", "") if "!" in self.tableWidgetFlight.item(rowIndex, 14).text() else self.tableWidgetFlight.item(rowIndex, 14).text() fx = self.tableWidgetFlight.item(rowIndex, 10).text().replace("!", "") if "!" in self.tableWidgetFlight.item(rowIndex, 10).text() else self.tableWidgetFlight.item(rowIndex, 10).text() qw1_1 = "" if "√" in qw1 else qw1 qw2_1 = "" if "√" in qw2 else qw2 g1_1 = "" if "√" in g1 else g1 g2_1 = "" if "√" in g2 else g2 fx_1 = "" if "√" in fx else fx qw1 = qw1.replace("√", "") if "√" in qw1 else qw1 qw2 = qw2.replace("√", "") if "√" in qw2 else qw2 g1 = g1.replace("√", "") if "√" in g1 else g1 g2 = g2.replace("√", "") if "√" in g2 else g2 fx = fx.replace("√", "") if "√" in fx else fx fj = str(self.tableWidgetFlight.item(rowIndex, colnum - 1).text()) dict_people = {"工1": qw1, "工2": qw2, "工3": g1, "工4": g2, "放行": fx } dict_people_noCall = {"工1": qw1_1, "工2": qw2_1, "工3": g1_1, "工4": g2_1, "放行": fx_1 } # print(dict_people) if action == item1: if str(self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) != "" and "MAN" not in str( self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) and str(self.tableWidgetFlight.item(rowIndex, colnum - 4).text()) != "" : empNos = self.severpostData_nomeassge("get_empNos", dict_people) # print(empNos) if empNos["code"] != "fail": res=self.LM_TSK_SURE_PG_NOW(self.tableWidgetFlight.item(rowIndex, colnum - 4).text(),empNos["WXempNos"],"WX",empNos["date"],empNos["bc"]) if res == "ok": try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工成功%s/" % (acno, flightno, str(qw1 + "-" + qw2 + "-" + g1 + "-" + g2),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.show_info("成功提示", "派工成功！") if empNos["faillist"] != []: try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]",""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.show_info("派工错误", "以下人员派工失败：%s，请确认考勤打卡情况！" % empNos["faillist"]) else: self.show_info("警告", "该航班非AMRO航班或者无任务编号，请确认是否为AMRO航班，如确认请使用AMRO人工派工！！") return elif action == item18: if int(self.authority) <= 2: if self.tableWidgetFlight.item(rowIndex, 24).text() !="" and "【交班航班】" not in fj and \ ("3U" in self.tableWidgetFlight.item(rowIndex, 4).text() or "CSC" in self.tableWidgetFlight.item(rowIndex, 4).text()): relay = QMessageBox.warning(self, "警告", "是否确定要对B-%s,%s进行工作交接？"%(self.tableWidgetFlight.item(rowIndex, 1).text(),self.tableWidgetFlight.item(rowIndex, 4).text()), QMessageBox.StandardButton.Yes, QMessageBox.StandardButton.Close) if relay == QMessageBox.StandardButton.Yes: data = {"taskid": self.tableWidgetFlight.item(rowIndex, 26).text(),"sts": "1"} res = self.severpostData_nomeassge("handoverflight", data=data)["返回值"] if res == "ok": flightid = self.tableWidgetFlight.item(rowIndex, colnum - 5).text() flighttype = self.tableWidgetFlight.item(rowIndex, 9).text() fjxx = "【交班航班】" + fj ip = "http://" + str(self.ipinfo) + "/static/updateEidteItem/" + "%s/" % str(fjxx) + "%s/" % str(flightid) + "A/%s/" % str(flighttype) + "%s" % str(self.selectedtime) try: requests.get(url=ip, timeout=30).json() except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) self.QThreadSortNow("main") QMessageBox.warning(self, "提示", "B-%s,%s工作交接推送成功"%(self.tableWidgetFlight.item(rowIndex, 1).text(),self.tableWidgetFlight.item(rowIndex, 4).text())) else: QMessageBox.warning(self, "警告", "航班交接失败，请重新尝试") elif "【交班航班】" in fj: QMessageBox.warning(self, "提示", "该航班已交接，请勿重复交接！") elif "3U" not in self.tableWidgetFlight.item(rowIndex, 4).text() and "CSC" not in self.tableWidgetFlight.item(rowIndex, 4).text(): QMessageBox.warning(self, "提示", "该航班为非川航航班，无需交接！！！") else: QMessageBox.warning(self, "提示", "无法对未安排人员的的航班无法进行交接班，请先进行派工后交班！") else: self.show_info("警告", "权限不够，请联系管理员！！！") return elif action == item17: if int(self.authority) <= 1: if "MAN" in str(self.tableWidgetFlight.item(rowIndex, colnum - 5).text()): ip = "http://" + str(self.ipinfo) + "/static/" + "deleteFlight/" + "%s/%s/%s" % ( self.tableWidgetFlight.item(rowIndex, colnum - 5).text(), self.user, self.selectedtime) res = requests.get(url=ip, timeout=30).json() if res["返回值"] == "ok": self.show_info("成功提示", "航班删除成功！") try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s航班被删除%s/" % (acno, flightno,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.QThreadSortNow("main") else: self.show_info("提示", "航班删除失败，如需请联系管理员！") else: self.show_info("警告", "删除航班功能仅限于人工添加的航班，AMRO航班无法删除！！！") else: self.show_info("警告", "权限不够，请联系管理员！！！") return elif action == item16: if str(self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) != "" and "MAN" not in str(self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) and str(self.tableWidgetFlight.item(rowIndex, colnum - 4).text()) != "": taskid = self.tableWidgetFlight.item(rowIndex, colnum - 4).text() ip = "http://" + str(self.ipinfo) + "/static/checkWorkjob/%s" % taskid infos = requests.get(url=ip, timeout=30).json() if infos["返回值"] == "ok": self.show_info("成功提示", "工作包查询成功！") self.QThreadSortNow("main") else: self.show_info("警告", "该航班非AMRO航班或者无任务编号，无法查询工作包！！") return elif action == item15: # {"工号":"0","电话":"1","姓名":"2","航班编号":"3","航班号":"4","附加消息":"5","拨号次数":"6","":"8","":"9","":"10"} if "人工" not in str(fj): for i in dict_people_noCall.keys(): if dict_people_noCall[i] != "": name = str(dict_people_noCall[i]) if "!" in name: name = name.replace("!", "") if "√" in name: name = name.replace("√", "") ip = "http://" + str(self.ipinfo) + "/static/get_empNos_phoone/%s" % name infos = requests.get(url=ip, timeout=30).json() # print(infos) flightnumber = self.tableWidgetFlight.item(rowIndex, 4).text() flighttype = self.tableWidgetFlight.item(rowIndex, 9).text() flightids = str(self.tableWidgetFlight.item(rowIndex, colnum - 4).text()) + str( flighttype) + str(name) + str(datetime.datetime.now().strftime("%H:%M:%S")) if infos == {}: self.show_info("警告", "无法查询到%s个人信息，请人工联系或更新后尝试！！" % name) ip = "http://" + str( self.ipinfo) + "/static/insertLogs/" + "%s%s%s未在通讯录，无法完成自动拨号，请人工联系或更新信息后尝试" % ( flightnumber, flighttype, name) + "/system/" + str( datetime.datetime.now().strftime("%Y-%m-%d %H:%M")) requests.get(url=ip, timeout=30).json() else: callnumber = 0 data = {"工号": "%s" % infos["工号"], "电话": "%s" % infos["电话"], "姓名": "%s" % name, "航班编号": "%s" % flightids, "航班号": "%s" % flightnumber, "附加消息": "%s" % fj, "拨号次数": callnumber} self.severpostData_nomeassge("insertCalllist", data) ip = "http://" + str(self.ipinfo) + "/static/calltry" requests.get(url=ip, timeout=30).json() self.severpost_nomeassge("infoConfirm", "/%s" % self.tableWidgetFlight.item(rowIndex, 9).text(), "/%s" % self.tableWidgetFlight.item(rowIndex, colnum - 5).text(), "/%s" % self.displayMode, "/%s" % self.selectedtime) try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s电话通知%s/" % ( acno, flightno,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.QThreadSortNow("main") # 需要一次拨号请求 else: ip = "http://" + str(self.ipinfo) + "/static/insertLogs/" + "%s，%s附加消息有需要人工通知的内容，请人工介入，请通知到位后点击确认通知！！" % (acno, flightno) + "/system/" + str(datetime.datetime.now().strftime("%Y-%m-%d %H:%M")) requests.get(url=ip, timeout=30).json() QMessageBox.warning(self, "人工提醒", "%s，%s附加消息有需要人工通知的内容，将推送航班监控席位由人工通知！" % (acno, flightno) ) return elif action == item2: if str(self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) != "" and "MAN" not in str( self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) and str(self.tableWidgetFlight.item(rowIndex, colnum - 4).text()) != "": empNos = self.severpostData_nomeassge("get_empNos", dict_people) if empNos["code"] != "fail": res = self.LM_TSK_SURE_PG_NOW(self.tableWidgetFlight.item(rowIndex, colnum - 4).text(),empNos["FXempNos"], "FX", empNos["date"], empNos["bc"]) if res == "ok": try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工成功%s/" % (acno, flightno, str(fx),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except: self.show_info("日志功能失效", "操作日志功能失效请联系管理员") self.show_info("成功提示", "派工成功！") if empNos["faillist"] != []: try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]",""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.show_info("派工错误", "以下人员派工失败：%s，请确认考勤打卡情况！" % empNos["faillist"]) else: self.show_info("警告", "该航班非AMRO航班或者无任务编号，请确认是否为AMRO航班，如确认请使用AMRO人工派工！！") return elif action == item3: if str(self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) != "" and "MAN" not in str(self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) and str(self.tableWidgetFlight.item(rowIndex, colnum - 4).text()) != "": empNos = self.severpostData_nomeassge("get_empNos", dict_people) if empNos["code"] != "fail": res = self.LM_TSK_SURE_PG_NOW(self.tableWidgetFlight.item(rowIndex, colnum - 4).text(),empNos["ESempNos"], "ECSJ", empNos["date"], empNos["bc"]) if res == "ok": try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工成功%s/" % (acno, flightno, str(g1 + "-" + g2),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.show_info("成功提示", "派工成功！") if empNos["faillist"] != []: try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]",""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.show_info("派工错误", "以下人员派工失败：%s，请确认考勤打卡情况！" % empNos["faillist"]) else: self.show_info("警告", "该航班非AMRO航班或者无任务编号，请确认是否为AMRO航班，如确认请使用AMRO人工派工！！") return elif action == item4: if str(self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) != "" and "MAN" not in str( self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) and str(self.tableWidgetFlight.item(rowIndex, colnum - 4).text()) != "": empNos = self.severpostData_nomeassge("get_empNos", dict_people) if empNos["code"] != "fail": risktips="" if self.tableWidgetFlight.item(rowIndex, 8).text() !="": res=self.getRiskData(self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, 9).text()) risktips=f"【风险提示】{res}" if res !="" else "" msgInfo="进港维修任务保障推送!%s%s" % (fj,risktips) res= self.send_dingdong(self.tableWidgetFlight.item(rowIndex, 1).text(),self.tableWidgetFlight.item(rowIndex, 2).text(), self.tableWidgetFlight.item(rowIndex, colnum - 2).text(), "进" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[1], self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, colnum - 4).text(), empNos["WXempNos"],"",empNos["WX"],empNos["FX"],"",msgInfo) if res != "ok": self.show_info("失败提示", "%s维修人员%s派工信息推送失败！" % (self.tableWidgetFlight.item(rowIndex, 1).text(), empNos["WX"])) else: try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送成功%s/" % (acno, flightno, str(qw1 + "-" + qw2 + "-" + g1 + "-" + g2),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.severpost_nomeassge("infoConfirm2", "/%s" % self.tableWidgetFlight.item(rowIndex, 9).text(),"/%s" % self.tableWidgetFlight.item(rowIndex,colnum - 5).text(),"/%s" % self.displayMode, "/%s" % self.selectedtime) self.show_info("成功提示", "%s维修人员%s派工信息推送成功！！！" % (self.tableWidgetFlight.item(rowIndex, 1).text(), empNos["WX"])) self.QThreadSortNow("main") if empNos["faillist"] != []: try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]",""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.show_info("通知错误", "以下人员通知失败：%s，请确认考勤打卡情况！" % empNos["faillist"]) else: self.show_info("警告", "该航班非AMRO航班或者无任务编号，请确认是否为AMRO航班，如确认请使用AMRO人工叮咚消息通知！！") return elif action == item5: if str(self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) != "" and "MAN" not in str( self.tableWidgetFlight.item(rowIndex, colnum - 5).text())and str(self.tableWidgetFlight.item(rowIndex, colnum - 4).text()) != "": empNos = self.severpostData_nomeassge("get_empNos", dict_people) if empNos["code"] != "fail": risktips="" if self.tableWidgetFlight.item(rowIndex, 8).text() !="": res=self.getRiskData(self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, 9).text()) risktips=f"【风险提示】{res}" if res !="" else "" msgInfo="放行人员保障推送!%s%s" % (fj,risktips) res= self.send_dingdong(self.tableWidgetFlight.item(rowIndex, 1).text(),self.tableWidgetFlight.item(rowIndex, 2).text(), self.tableWidgetFlight.item(rowIndex, colnum - 2).text(), "进" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[1], self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, colnum - 4).text(), "", empNos["FXempNos"],empNos["WX"],empNos["FX"],"",msgInfo) if res != "ok": self.show_info("失败提示", "%s放行人员%s派工信息推送失败！" % ( self.tableWidgetFlight.item(rowIndex, 1).text(), empNos["FX"])) else: try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送成功%s/" % (acno, flightno, str(fx),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.show_info("成功提示", "%s放行人员%s派工信息推成功！！！" % ( self.tableWidgetFlight.item(rowIndex, 1).text(), empNos["FX"])) self.severpost_nomeassge("infoConfirm2","/%s" % self.tableWidgetFlight.item(rowIndex, 9).text(), "/%s" % self.tableWidgetFlight.item(rowIndex,colnum - 5).text(), "/%s" % self.displayMode, "/%s" % self.selectedtime) self.QThreadSortNow("main") if empNos["faillist"] != []: try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]",""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.show_info("通知错误", "以下人员通知失败：%s，请确认考勤打卡情况！" % empNos["faillist"]) else: self.show_info("警告","该航班非AMRO航班或者无任务编号，请确认是否为AMRO航班，如确认请使用AMRO人工叮咚消息通知！！") return elif action == item6: if str(self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) != "" and "MAN" not in str( self.tableWidgetFlight.item(rowIndex, colnum - 5).text())and str(self.tableWidgetFlight.item(rowIndex, colnum - 4).text()) != "": empNos = self.severpostData_nomeassge("get_empNos", dict_people) if empNos["code"] != "fail": risktips = "" if self.tableWidgetFlight.item(rowIndex, 8).text() != "": res = self.getRiskData(self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, 9).text()) risktips = f"【风险提示】{res}" if res != "" else "" msgInfo = "二次送机任务推送!%s%s" % (fj, risktips) res= self.send_dingdong(self.tableWidgetFlight.item(rowIndex, 1).text(),self.tableWidgetFlight.item(rowIndex, 2).text(), self.tableWidgetFlight.item(rowIndex, colnum - 2).text(), "进" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[1], self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, colnum - 4).text(), empNos["ESempNos"], "",empNos["WX"],empNos["FX"],empNos["ES"],msgInfo) if res != "ok": self.show_info("失败提示", "%s二次送机人员%s派工信息推送失败！" % ( self.tableWidgetFlight.item(rowIndex, 1).text(), empNos["ES"])) else: try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送成功%s/" % (acno, flightno, str(g1 + "-" + g2),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.show_info("成功提示", "%s二次送机人员%s派工信息推送成功！！！" % ( self.tableWidgetFlight.item(rowIndex, 1).text(), empNos["ES"])) self.severpost_nomeassge("infoConfirm2","/%s" % self.tableWidgetFlight.item(rowIndex, 9).text(), "/%s" % self.tableWidgetFlight.item(rowIndex,colnum - 5).text(), "/%s" % self.displayMode, "/%s" % self.selectedtime) self.QThreadSortNow("main") if empNos["faillist"] != []: try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]",""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.show_info("通知错误", "以下人员通知失败：%s，请确认考勤打卡情况！" % empNos["faillist"]) else: self.show_info("警告","该航班非AMRO航班或者无任务编号，请确认是否为AMRO航班，如确认请使用AMRO人工叮咚消息通知！！") return elif action == item7: self.severpost_nomeassge("infoConfirm", "/%s" % self.tableWidgetFlight.item(rowIndex, 9).text(), "/%s" % self.tableWidgetFlight.item(rowIndex, colnum - 5).text(), "/%s" % self.displayMode, "/%s" % self.selectedtime) try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s点击确认通知%s/" % (acno, flightno,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.QThreadSortNow("main") return elif action == item8: self.severpost_nomeassge("manChangests", "/%s" % self.tableWidgetFlight.item(rowIndex, colnum - 5).text(), "/接机到位", "/%s" % self.selectedtime, "/%s" % self.user) try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s人工点击接机到位%s/" % (acno, flightno,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.QThreadSortNow("main") self.QThreadSortNow("change") self.QThreadSortNow("log") return elif action == item9: self.severpost_nomeassge("manChangests","/%s" % self.tableWidgetFlight.item(rowIndex, colnum - 5).text(), "/放行","/%s" % self.selectedtime, "/%s" % self.user) # print("人工确认放行") try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s人工点击放行%s/" % (acno, flightno,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.QThreadSortNow("main") self.QThreadSortNow("change") self.QThreadSortNow("log") return elif action == item10: self.severpost_nomeassge("manChangests","/%s" % self.tableWidgetFlight.item(rowIndex, colnum - 5).text(), "/随机到位","/%s" % self.selectedtime, "/%s" % self.user) # print("人工确认随机到位") try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s人工点击随机到位%s/" % (acno, flightno,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.QThreadSortNow("main") self.QThreadSortNow("change") self.QThreadSortNow("log") return elif action == item11: self.severpost_nomeassge("manChangests", "/%s" % self.tableWidgetFlight.item(rowIndex, colnum - 5).text(), "/二送到位", "/%s" % self.selectedtime, "/%s" % self.user) # print("人工确认二送到位") try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s人工点击二送到位%s/" % (acno, flightno,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.QThreadSortNow("main") self.QThreadSortNow("change") self.QThreadSortNow("log") return elif action == item12: self.severpost_nomeassge("manChangests", "/%s" % self.tableWidgetFlight.item(rowIndex, colnum - 5).text(), "/销子夹板", "/%s" % self.selectedtime, "/%s" % self.user) try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s人工点击销子夹板%s/" % (acno, flightno,datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") self.QThreadSortNow("main") self.QThreadSortNow("change") self.QThreadSortNow("log") return elif action == item13: msg = {} if str(self.tableWidgetFlight.item(rowIndex, colnum - 5).text()) != "" and "MAN" not in str(self.tableWidgetFlight.item(rowIndex, colnum - 5).text())and str(self.tableWidgetFlight.item(rowIndex, colnum - 4).text()) != "": if self.tableWidgetFlight.item(rowIndex, 9).text() != "短停送" and self.tableWidgetFlight.item(rowIndex, 9).text() != "特后前送": empNos = self.severpostData_nomeassge("get_empNos", dict_people) # print(empNos) try: if empNos["code"] != "fail": res=self.LM_TSK_SURE_PG_NOW(self.tableWidgetFlight.item(rowIndex, colnum - 4).text(),empNos["WXempNos"],"WX",empNos["date"],empNos["bc"]) if res == "ok": msg["aa"] = "%s维修人员派工成功！"% str(qw1 + "-" + qw2 + "-" + g1 + "-" + g2) try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工成功%s/" % (acno, flightno, str(qw1 + "-" + qw2 + "-" + g1 + "-" + g2),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") if empNos["faillist"] != []: msg["a"] = "以下维修人员派工失败：%s，请确认考勤打卡情况！" % empNos["faillist"] try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]", ""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") except: pass try: if empNos["code"] != "fail": res = self.LM_TSK_SURE_PG_NOW(self.tableWidgetFlight.item(rowIndex, colnum - 4).text(),empNos["FXempNos"], "FX", empNos["date"], empNos["bc"]) if res == "ok": msg["bb"] = "放行人员%s派工成功！"%str(fx) try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工成功%s/" % (acno, flightno, str(fx),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") if empNos["faillist"] != []: msg["b"] = "以下放行人员派工失败：%s，请确认考勤打卡情况！" % empNos["faillist"] try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]",""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") except: pass try: if empNos["code"] != "fail": risktips = "" if self.tableWidgetFlight.item(rowIndex, 8).text() != "": res = self.getRiskData(self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, 9).text()) risktips = f"【风险提示】{res}" if res != "" else "" msgInfo = "进港维修任务保障推送!%s%s" % (fj, risktips) res= self.send_dingdong(self.tableWidgetFlight.item(rowIndex, 1).text(),self.tableWidgetFlight.item(rowIndex, 2).text(), self.tableWidgetFlight.item(rowIndex, colnum - 2).text(), "进" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[1], self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, colnum - 4).text(),empNos["WXempNos"],"",empNos["WX"],empNos["FX"],"",msgInfo) if res == "ok": msg["cc"] = "%s维修人员%s派工信息推送成功！！！" % (self.tableWidgetFlight.item(rowIndex, 1).text(), empNos["WX"]) self.severpost_nomeassge("infoConfirm2","/%s" % self.tableWidgetFlight.item(rowIndex, 9).text(),"/%s" % self.tableWidgetFlight.item(rowIndex,colnum - 5).text(),"/%s" % self.displayMode, "/%s" % self.selectedtime) try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送成功%s/" % (acno, flightno, str(qw1 + "-" + qw2 + "-" + g1 + "-" + g2),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") if empNos["faillist"] != []: msg["c"] = "以下人员通知失败：%s，请确认考勤打卡情况！" % empNos["faillist"] try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]",""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") except: #pass print(traceback.format_exc()) try: if empNos["code"] != "fail": risktips = "" if self.tableWidgetFlight.item(rowIndex, 8).text() != "": res = self.getRiskData(self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, 9).text()) risktips = f"【风险提示】{res}" if res != "" else "" msgInfo = "放行任务保障信息!%s%s" % (fj, risktips) res= self.send_dingdong(self.tableWidgetFlight.item(rowIndex, 1).text(),self.tableWidgetFlight.item(rowIndex, 2).text(), self.tableWidgetFlight.item(rowIndex, colnum - 2).text(), "进" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[1], self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, colnum - 4).text(), "", empNos["FXempNos"],empNos["WX"],empNos["FX"],"",msgInfo) if res == "ok": msg["dd"] = "%s放行人员%s派工信息推成功！！！" % ( self.tableWidgetFlight.item(rowIndex, 1).text(), empNos["FX"]) self.severpost_nomeassge("infoConfirm2","/%s" % self.tableWidgetFlight.item(rowIndex, 9).text(),"/%s" % self.tableWidgetFlight.item(rowIndex,colnum - 5).text(),"/%s" % self.displayMode, "/%s" % self.selectedtime) try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送成功%s/" % (acno, flightno, str(fx),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") if empNos["faillist"] != []: msg["d"] = "以下人员通知失败：%s，请确认考勤打卡情况！" % empNos["faillist"] try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]",""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") except: pass else: empNos = self.severpostData_nomeassge("get_empNos", dict_people) if "【交班航班】" in fj: try: if empNos["code"] != "fail": res = self.LM_TSK_SURE_PG_NOW(self.tableWidgetFlight.item(rowIndex, colnum - 4).text(),empNos["FXempNos"], "FX", empNos["date"], empNos["bc"]) if res == "ok": msg["bb"] = "放行人员%s派工成功！"%str(fx) try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工成功%s/" % (acno, flightno, str(fx),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") if empNos["faillist"] != []: msg["b"] = "以下放行人员派工失败：%s，请确认考勤打卡情况！" % empNos["faillist"] try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]",""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") except: pass try: if empNos["code"] != "fail": risktips = "" if self.tableWidgetFlight.item(rowIndex, 8).text() != "": res = self.getRiskData(self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, 9).text()) risktips = f"【风险提示】{res}" if res != "" else "" msgInfo = "放行任务保障信息!%s%s" % (fj, risktips) res= self.send_dingdong(self.tableWidgetFlight.item(rowIndex, 1).text(),self.tableWidgetFlight.item(rowIndex, 2).text(), self.tableWidgetFlight.item(rowIndex, colnum - 2).text(), "进" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[1], self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, colnum - 4).text(), "", empNos["FXempNos"],empNos["WX"],empNos["FX"],"",msgInfo) if res == "ok": msg["dd"] = "%s放行人员%s派工信息推成功！！！" % ( self.tableWidgetFlight.item(rowIndex, 1).text(), empNos["FX"]) self.severpost_nomeassge("infoConfirm2","/%s" % self.tableWidgetFlight.item(rowIndex, 9).text(),"/%s" % self.tableWidgetFlight.item(rowIndex,colnum - 5).text(),"/%s" % self.displayMode, "/%s" % self.selectedtime) try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送成功%s/" % (acno, flightno, str(fx),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") if empNos["faillist"] != []: msg["d"] = "以下人员通知失败：%s，请确认考勤打卡情况！" % empNos["faillist"] try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]",""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") except: pass # print(empNos) if empNos["code"] != "fail": res = self.LM_TSK_SURE_PG_NOW(self.tableWidgetFlight.item(rowIndex, colnum - 4).text(),empNos["ESempNos"], "ECSJ", empNos["date"], empNos["bc"]) if res == "ok": msg["ee"] = "%s二次送机派工成功！"%str(g1 + "-" + g2) try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工成功%s/" % (acno, flightno, str(g1 + "-" + g2),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") if empNos["faillist"] != []: msg["e"] = "以下人员派工失败：%s，请确认考勤打卡情况！" % empNos["faillist"] if empNos["code"] != "fail": risktips = "" if self.tableWidgetFlight.item(rowIndex, 8).text() != "": res = self.getRiskData(self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, 9).text()) risktips = f"【风险提示】{res}" if res != "" else "" msgInfo = "二次送机任务推送!%s%s" % (fj, risktips) res= self.send_dingdong(self.tableWidgetFlight.item(rowIndex, 1).text(),self.tableWidgetFlight.item(rowIndex, 2).text(), self.tableWidgetFlight.item(rowIndex, colnum - 2).text(), "进" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("
")[1], self.tableWidgetFlight.item(rowIndex, 8).text(),self.tableWidgetFlight.item(rowIndex, colnum - 4).text(), empNos["ESempNos"], "",empNos["WX"],empNos["FX"],empNos["ES"],msgInfo) if res == "ok": msg["ff"] = "%s二次送机人员%s派工信息推送成功！！！" % ( self.tableWidgetFlight.item(rowIndex, 1).text(), empNos["ES"]) self.severpost_nomeassge("infoConfirm2","/%s" % self.tableWidgetFlight.item(rowIndex, 9).text(), "/%s" % self.tableWidgetFlight.item(rowIndex,colnum - 5).text(), "/%s" % self.displayMode, "/%s" % self.selectedtime) try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送成功%s/" % (acno, flightno, str(g1 + "-" + g2),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") if empNos["faillist"] != []: msg["f"] = "以下人员通知失败：%s，请确认考勤打卡情况！" % empNos["faillist"] try: ip = "http://" + str(self.ipinfo) + "/static/insertLogs2/" + "%s,%s%s派工信息推送失败%s/" % (acno, flightno,str(empNos["faillist"]).replace(",", "-").replace("'", "").replace("[", "").replace("]",""),datetime.datetime.now()) + "%s/" % str(self.user) + "%s" % str(datetime.datetime.now()) requests.get(url=ip, timeout=30).json() except Exception: logger.error(traceback.format_exc()) QMessageBox.warning(self, "日志功能失效", "操作日志功能失效请联系管理员！") msgs = "" for j in ["aa", "bb", "cc", "dd", "ee", "ff", "a", "b", "c", "d", "e", "f"]: if j in msg.keys(): if msgs == "": msgs = msg[j] else: msgs = msgs + "\n" + msg[j] self.show_info("一键派工提示信息", msgs) self.QThreadSortNow("main") else: self.show_info("警告", "该航班非AMRO航班或者无任务编号，请确认是否为AMRO航班，如确认请使用AMRO人工派工和叮咚消息通知！！") return else: return except Exception: logger.error(traceback.format_exc()) elif self.displayMode=="B": for i in self.tableWidgetFlight.selectionModel().selection().indexes(): menu = QMenu() item1 = menu.addAction("工作单确认检查") screenPos = self.tableWidgetFlight.mapToGlobal(pos) action = menu.exec(screenPos) rowIndex = i.row() colnum = self.tableWidgetFlight.columnCount() flightids=self.tableWidgetFlight.item(rowIndex, colnum - 5).text() flighttype = self.tableWidgetFlight.item(rowIndex, 9).text() if action == item1: nowstr=self.user+str(datetime.datetime.now().timestamp()).split(".")[0] ip = "http://" + str(self.ipinfo) + "/static/updateDragDropItem/%s/%s/%s/%s/%s/%s" % ( "10", nowstr, flightids, self.displayMode, flighttype, self.selectedtime) # print(ip) #self.tableWidgetFlight.setItem(int(rowIndex), column, QTableWidgetItem(str(nowstr))) try: requests.get(url=ip, timeout=30).json() except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) self.QThreadSortNow("main") return else: QMessageBox.warning(self, "提示", "权限不够，请联系管理员！") def tableWidgetPhoneDispaly(self): try: phoneLabel = ["序号", "姓名", "部门", "电话","name"] col = len(phoneLabel) diplaylist = self.sorttableWidgetPHONEDispalydata self.tableWidget_3.setRowCount(len(diplaylist.keys())) for row in diplaylist.keys(): for colNum in range(0, col): if colNum == 0: self.tableWidget_3.setItem(int(row), colNum, QTableWidgetItem(str(int(row)+1))) self.tableWidget_3.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) else: self.tableWidget_3.setItem(int(row), colNum, QTableWidgetItem(diplaylist[row][phoneLabel[colNum]])) self.tableWidget_3.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) self.tableWidget_3.resizeColumnsToContents() self.tableWidget_3.setColumnHidden(4, True) except Exception: logger.error(traceback.format_exc()) def tableWidgetPeopleDisplay(self): try: peopleLabel = ["序号", "姓名", "角色", "总量", "当前", "最后时间"] col = len(peopleLabel) diplaylist = self.sortdiplaylist self.tableWidgetPerson.setRowCount(len(diplaylist.keys())) # print( self.searchpeoplestr ) for row in diplaylist.keys(): for colNum in range(0, col): if colNum == 0: self.tableWidgetPerson.setItem(int(row), colNum, QTableWidgetItem(str(int(row)+1))) self.tableWidgetPerson.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) else: self.tableWidgetPerson.setItem(int(row), colNum, QTableWidgetItem(diplaylist[row][peopleLabel[colNum]])) self.tableWidgetPerson.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) self.tableWidgetPerson.resizeColumnsToContents() # self.tableWidgetPerson.itemEntered.connect(self.enter_item_slot) except Exception: logger.error(traceback.format_exc()) def enter_item_slot(self, item): try: self.tool_tip = item.text() # print("self.tool_tip:", self.tool_tip) except Exception: logger.error(traceback.format_exc()) def tableWidgetDispaly(self): try: selftaxi = ["166", "166L", "166R", "167", "167L", "167R", "168", "169", "170", "171", "172", "173", "174", "269", "270", "271", "272", "273", "274", "275", "287", "288", "601", "602", "603", "604", "605", "606", "607", "607L", "607R"] # 自滑位 if self.sorttableWidgetDispalydata != "": # print("刷新开始") # dateNow=datetime.datetime.now() tableWidgetDispalydata = self.sorttableWidgetDispalydata col = len(self.displayLabel) self.tableWidgetFlight.setRowCount(len(tableWidgetDispalydata.keys())) for row in tableWidgetDispalydata.keys(): for colNum in range(0, col): if colNum == 6: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem( str(tableWidgetDispalydata[row][str(colNum)]))) self.tableWidgetFlight.item(int(row), colNum).setBackground( QColor(str(tableWidgetDispalydata[row]["99"]))) self.tableWidgetFlight.item(int(row), colNum).setForeground( QColor(str(tableWidgetDispalydata[row]["102"]))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 7: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem( str(tableWidgetDispalydata[row][str(colNum)]))) self.tableWidgetFlight.item(int(row), colNum).setBackground( QColor(str(tableWidgetDispalydata[row]["99"]))) self.tableWidgetFlight.item(int(row), colNum).setForeground( QColor(str(tableWidgetDispalydata[row]["103"]))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 8: if tableWidgetDispalydata[row][str(colNum)] in selftaxi and tableWidgetDispalydata[row][str(colNum)] != "": self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem( str(tableWidgetDispalydata[row][str(colNum)]))) self.tableWidgetFlight.item(int(row), colNum).setBackground(QColor("lightgreen")) self.tableWidgetFlight.item(int(row), colNum).setForeground(QColor("black")) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment( Qt.AlignmentFlag.AlignCenter) if "自滑机位" not in tableWidgetDispalydata[row][str(col - 1)]: flightid = tableWidgetDispalydata[row][str(col - 5)] # print(flightid) flighttype = tableWidgetDispalydata[row]["9"] fjxx = "自滑机位;" + str(tableWidgetDispalydata[row][str(col - 1)]) ip = "http://" + str(self.ipinfo) + "/static/updateEidteItem/" + "%s/" % str( fjxx) + "%s/" % str(flightid) + "%s/" % str(self.displayMode) + "%s/" % str( flighttype) + "%s" % str(self.selectedtime) try: requests.get(url=ip, timeout=30).json() except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) if self.displayMode =="A": for colNum2 in (10, 11, 12, 13, 14): if tableWidgetDispalydata[row][str(colNum2)] != "" and "*" not in str(tableWidgetDispalydata[row][str(colNum2)]): self.severpost_nomeassge("selftaxiLogs", "/%s请通知%s,%s为自滑位，注意特殊机位保障要求！" % ( tableWidgetDispalydata[row]["1"], tableWidgetDispalydata[row][str(colNum2)], tableWidgetDispalydata[row]["8"]),"/%s" % tableWidgetDispalydata[row][str(col - 5)], "","") self.severpost_nomeassge("infoConfirm3","/%s" % tableWidgetDispalydata[row][str(9)],"/%s" % tableWidgetDispalydata[row][str(col - 5)], "/%s" % self.displayMode, "/%s" % self.selectedtime) elif tableWidgetDispalydata[row][str(colNum)] not in selftaxi or \ tableWidgetDispalydata[row][str(colNum)] == "": self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem( str(tableWidgetDispalydata[row][str(colNum)]))) self.tableWidgetFlight.item(int(row), colNum).setBackground( QColor(str(tableWidgetDispalydata[row]["99"]))) self.tableWidgetFlight.item(int(row), colNum).setForeground( QColor(str(tableWidgetDispalydata[row]["101"]))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment( Qt.AlignmentFlag.AlignCenter) font = QFont() # font.setFamily("SimHei") font.setFamily("Microsoft YaHei") font.setBold(True) self.tableWidgetFlight.item(int(row), colNum).setFont(font) elif colNum == 9: if tableWidgetDispalydata[row][str(colNum)] == "短停送" or tableWidgetDispalydata[row][str(colNum)] == "特后前送": self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem( str(tableWidgetDispalydata[row][str(colNum)]))) self.tableWidgetFlight.item(int(row), colNum).setBackground( QColor(str(tableWidgetDispalydata[row]["99"]))) self.tableWidgetFlight.item(int(row), colNum).setForeground(QColor(str("blue"))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment( Qt.AlignmentFlag.AlignCenter) font = QFont() # font.setFamily("SimHei") font.setFamily("Microsoft YaHei") font.setBold(True) self.tableWidgetFlight.item(int(row), colNum).setFont(font) else: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem( str(tableWidgetDispalydata[row][str(colNum)]))) self.tableWidgetFlight.item(int(row), colNum).setBackground( QColor(str(tableWidgetDispalydata[row]["99"]))) self.tableWidgetFlight.item(int(row), colNum).setForeground( QColor(str(tableWidgetDispalydata[row]["101"]))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment( Qt.AlignmentFlag.AlignCenter) elif 9 < colNum < 15: if "√" in tableWidgetDispalydata[row][str(colNum)] or tableWidgetDispalydata[row][str(colNum)] == "": self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem( str(tableWidgetDispalydata[row][str(colNum)]).replace("*",""))) self.tableWidgetFlight.item(int(row), colNum).setBackground( QColor(str(tableWidgetDispalydata[row]["99"]))) self.tableWidgetFlight.item(int(row), colNum).setForeground( QColor(str(tableWidgetDispalydata[row]["101"]))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment( Qt.AlignmentFlag.AlignCenter) elif "√" not in tableWidgetDispalydata[row][str(colNum)] and tableWidgetDispalydata[row][ str(colNum)] != "": self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem( str(tableWidgetDispalydata[row][str(colNum)]).replace("*",""))) self.tableWidgetFlight.item(int(row), colNum).setBackground(QColor("yellow")) self.tableWidgetFlight.item(int(row), colNum).setForeground(QColor("black")) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment( Qt.AlignmentFlag.AlignCenter) elif colNum == col - 1: if str(tableWidgetDispalydata[row][str(colNum)]) !="" and str(tableWidgetDispalydata[row][str(colNum)]) != None: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(colNum)]))) self.tableWidgetFlight.item(int(row), colNum).setBackground(QColor("yellow")) self.tableWidgetFlight.item(int(row), colNum).setForeground(QColor("red")) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) self.tableWidgetFlight.item(int(row), col - 1).setToolTip("%s" % str(tableWidgetDispalydata[row][str(col - 1)])) font = QFont() # font.setFamily("SimHei") font.setFamily("Microsoft YaHei") font.setBold(True) self.tableWidgetFlight.item(int(row), colNum).setFont(font) else: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(colNum)]))) self.tableWidgetFlight.item(int(row), colNum).setBackground(QColor(str(tableWidgetDispalydata[row]["99"]))) self.tableWidgetFlight.item(int(row), colNum).setForeground(QColor(str(tableWidgetDispalydata[row]["101"]))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) self.tableWidgetFlight.item(int(row), col - 1).setToolTip("%s" % str(tableWidgetDispalydata[row][str(col - 1)])) font = QFont() # font.setFamily("SimHei") font.setFamily("Microsoft YaHei") font.setBold(True) self.tableWidgetFlight.item(int(row), colNum).setFont(font) if "二拖" in tableWidgetDispalydata[row][str(colNum)]: for selftaxiPostion in selftaxi: if selftaxiPostion in tableWidgetDispalydata[row][str(colNum)]: for colNum2 in (10, 11, 12, 13, 14): if tableWidgetDispalydata[row][str(colNum2)] != "": self.severpost_nomeassge("selftaxiLogs", "/%s请通知%s,%s二拖机位目的机位为自滑位，注意特殊机位保障要求！" % ( tableWidgetDispalydata[row]["1"], tableWidgetDispalydata[row][str(colNum2)], tableWidgetDispalydata[row]["8"]), "/%s" % tableWidgetDispalydata[row][ str(col - 5)], "", "") elif colNum == 22: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem( str(tableWidgetDispalydata[row][str(colNum)]))) self.tableWidgetFlight.item(int(row), colNum).setBackground( QColor(str(tableWidgetDispalydata[row]["99"]))) self.tableWidgetFlight.item(int(row), colNum).setForeground( QColor(str(tableWidgetDispalydata[row]["101"]))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) self.tableWidgetFlight.item(int(row), 22).setToolTip( "%s" % str(tableWidgetDispalydata[row][str(22)])) elif 0 < colNum < 5: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem( str(tableWidgetDispalydata[row][str(colNum)]))) self.tableWidgetFlight.item(int(row), colNum).setBackground( QColor(str(tableWidgetDispalydata[row]["99"]))) self.tableWidgetFlight.item(int(row), colNum).setForeground( QColor(str(tableWidgetDispalydata[row]["101"]))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) if self.displayMode == "A": self.tableWidgetFlight.item(int(row), colNum).setToolTip( "%s" % str(tableWidgetDispalydata[row][str(23)])) else: self.tableWidgetFlight.item(int(row), colNum).setToolTip( "%s" % str(tableWidgetDispalydata[row][str(24)])) if colNum == 1 and tableWidgetDispalydata[row][str(colNum)] in ["8182","8185","8186"] and tableWidgetDispalydata[row][str(9)] =="航前": if "【工具提示】无TPIS,带胎压表" not in tableWidgetDispalydata[row][str(col - 1)]: flightid = tableWidgetDispalydata[row][str(col - 5)] # print(flightid) flighttype = tableWidgetDispalydata[row]["9"] fjxx = "【工具提示】无TPIS,带胎压表;" + str(tableWidgetDispalydata[row][str(col - 1)]) ip = "http://" + str(self.ipinfo) + "/static/updateEidteItem/" + "%s/" % str( fjxx) + "%s/" % str(flightid) + "%s/" % str(self.displayMode) + "%s/" % str( flighttype) + "%s" % str(self.selectedtime) try: requests.get(url=ip, timeout=30).json() except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) elif colNum == 0: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem(str(int(row)+1))) self.tableWidgetFlight.item(int(row), colNum).setBackground(QColor(str(tableWidgetDispalydata[row]["99"]))) self.tableWidgetFlight.item(int(row), colNum).setForeground(QColor(str(tableWidgetDispalydata[row]["101"]))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) if self.displayMode == "A": self.tableWidgetFlight.item(int(row), colNum).setToolTip( "[%s，%s]" % (str(tableWidgetDispalydata[row][str(col-5)]),str(tableWidgetDispalydata[row][str(col-4)]))) else: self.tableWidgetFlight.item(int(row), colNum).setToolTip( "[%s，%s]" % (str(tableWidgetDispalydata[row][str(col-5)]),str(tableWidgetDispalydata[row][str(col-4)]))) else: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem( str(tableWidgetDispalydata[row][str(colNum)]))) self.tableWidgetFlight.item(int(row), colNum).setBackground( QColor(str(tableWidgetDispalydata[row]["99"]))) self.tableWidgetFlight.item(int(row), colNum).setForeground( QColor(str(tableWidgetDispalydata[row]["101"]))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) self.tableWidgetFlight.setColumnHidden(col - 2, True) self.tableWidgetFlight.setColumnHidden(col - 3, True) self.tableWidgetFlight.setColumnHidden(col - 4, True) self.tableWidgetFlight.setColumnHidden(col - 5, True) self.tableWidgetFlight.setColumnHidden(col - 6, False) self.tableWidgetFlight.setColumnHidden(col - 7, False) self.tableWidgetFlight.setColumnHidden(col - 1, False) if self.displayMode == "A": self.tableWidgetFlight.setColumnHidden(col - 8, True) self.tableWidgetFlight.setColumnHidden(col - 9, False) self.tableWidgetFlight.setColumnHidden(col - 10, True) self.tableWidgetFlight.setColumnHidden(col - 11, False) self.tableWidgetFlight.setColumnHidden(col - 12, True) else: self.tableWidgetFlight.setColumnHidden(col - 8, False) self.tableWidgetFlight.setColumnHidden(col - 9, True) self.tableWidgetFlight.setColumnHidden(col - 10, False) self.tableWidgetFlight.setColumnHidden(col - 11, True) self.tableWidgetFlight.setColumnHidden(col - 12, True) self.tableWidgetFlight.resizeColumnsToContents() self.tableWidgetFlight.setColumnWidth(10, 70) self.tableWidgetFlight.setColumnWidth(11, 70) self.tableWidgetFlight.setColumnWidth(12, 70) self.tableWidgetFlight.setColumnWidth(13, 70) self.tableWidgetFlight.setColumnWidth(14, 70) self.tableWidgetFlight.setColumnWidth(15, 70) self.tableWidgetFlight.setColumnWidth(22, 45) # print("刷新结束") # print(datetime.datetime.now() - dateNow) except Exception: logger.error(traceback.format_exc()) def on_completer_activated(self, text): try: if text: index = self.comboBox.findText(text) self.comboBox.setCurrentIndex(index) except Exception: logger.error(traceback.format_exc()) def LM_TSK_SURE_PG(self): try: data = { "empNos": dict["empNos"], # 员工号 "taskid": dict["taskid"], # taskid "type": dict["type"], # 类型 "shiftDate": dict["shiftDate"], # 上班日期 "shift": dict["shift"], # 班次 } self.severpostData_nomeassge("LM_TSK_SURE_PG", data) except Exception: logger.error(traceback.format_exc()) def dingdong(self): try: data = { "acno": dict["empNos"], # 机号 "actype": dict["taskid"], # 机型 "tasktype": dict["type"], # 任务类型 "tatd": dict["shiftDate"], # 起飞/落地时间 "msgInfo": dict["shift"], # 消息 "bay": dict["empNos"], # 机位 "wxemp": dict["taskid"], # 维修人员员工号 "fxemp": dict["type"], # 放行人员员工号 "wx": dict["shiftDate"], # 维修人员 "fx": dict["shift"], # 放行人员 "ecsj": dict["shift"], # 二次送机人员 } self.severpostData_nomeassge("dingdong", data) except Exception: logger.error(traceback.format_exc()) def update_pglistA(self, text): try: self.severpost_nomeassge("getPglist", "A", "", "", "") except Exception: logger.error(traceback.format_exc()) def update_pglistB(self, text): try: self.severpost_nomeassge("getPglist", "B", "", "", "") except Exception: logger.error(traceback.format_exc()) def search(self): # print('进行查询') try: self.threadWOrk_get_flight_list() if self.cookie != None: # print('查询中') self.threadWOrk_get_flight_list() except Exception: logger.error(traceback.format_exc()) def threadWork_getcookie(self): try: self.fl = utils.flight_list() worker = Worker2(self.fn_cookie, self.fl) worker.signals.result.connect(self.print_output_cookie) worker.signals.finished.connect(self.thread_complete) worker.signals.error.connect(self.thread_error) self.threadpool.start(worker) except Exception: logger.error(traceback.format_exc()) def threadWOrk_get_flight_list(self): try: dateNow = datetime.datetime.now() dateNowStr = dateNow.strftime("%Y-%m-%d") worker = Worker2(self.fn_get_flight_list, self.fl, dateNowStr, self.cookie) worker.signals.result.connect(self.print_output_flight_list) worker.signals.finished.connect(self.thread_complete) worker.signals.error.connect(self.thread_error) self.threadpool.start(worker) except Exception: logger.error(traceback.format_exc()) def fn_get_flight_list(self, fl, date, cookie): try: # print(fl.token) # flight_list = fl.request_filght_list(date, cookie) flight_list = utils.loadjson('./temp/1/fl1688398151.json') return flight_list except Exception: logger.error(traceback.format_exc()) def fn_cookie(self, fl): try: # 耗时进程 # print(fl) fl.start() cookie = fl.get_cookie() return cookie except Exception: logger.error(traceback.format_exc()) def print_output_cookie(self, dlist): try: self.cookie = dlist except Exception: logger.error(traceback.format_exc()) def print_output_flight_list(self, dlist): try: # print(dlist['code']) self.tableDisplay2() except Exception: logger.error(traceback.format_exc()) def thread_complete(self): print("THREAD COMPLETE!") def thread_error(self, error): print("进程error：{}".format(error)) class LoginWidget(Ui_login, QWidget): login_signal = QtCore.pyqtSignal(bool) login_user = QtCore.pyqtSignal(list) def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) # print('login widget') self.pushButton.clicked.connect(self.btn) # self.setipinfo() self.ipinfo = None except Exception: logger.error(traceback.format_exc()) def severpost_meassge(self, postname, postdata, postdata2): try: ip = "http://" + str(self.ipinfo) + "/static/" + str(postname) + str(postdata) + str(postdata2) try: res = requests.get(url=ip, timeout=30).json() # print(res) except Exception: # print('登录服务器失败') logging.info('登录服务器失败') res = "" QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) return res except Exception: logger.error(traceback.format_exc()) def btn(self): try: username = self.lineEditUser.text() password = self.lineEditPassword.text() try: res = self.severpost_meassge("loginTable", "/%s" % username, "/%s" % password)["返回值"] # print(res) except Exception: res = "" logger.error(traceback.format_exc()) # print(res) if res != "" and int(res[3])<=3: self.login_signal.emit(True) self.login_user.emit(res) else: self.show_message() except Exception: logger.error(traceback.format_exc()) def show_message(self): try: QMessageBox.warning(self, "警告", "无此用户或密码错误或账号无权限访问办公平台") except Exception: logger.error(traceback.format_exc()) class amroLoginWidget(Ui_amroLogin, QWidget): def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) self.pushButton.clicked.connect(self.btn) self.ipinfo = None except Exception: logger.error(traceback.format_exc()) def btn(self): try: username = self.lineEditUsername.text() password = self.lineEditPassword.text() ip = "http://" + str(self.ipinfo) + "/static/remotelogin/%s/%s" % (username, password) try: res = requests.get(url=ip, timeout=60) if res.text == "ok": QMessageBox.warning(self, "提示", "服务器AMRO登录成功！") self.close() else: QMessageBox.warning(self, "提示", "服务器AMRO登录失败，请检查账号密码或服务器端登录或联系管理员检查服务器！") except: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") self.close() except Exception: logger.error(traceback.format_exc()) class amroLoginWidget2(Ui_amroLogin2, QWidget): def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) self.pushButton.clicked.connect(self.btn) self.ipinfo = None except Exception: logger.error(traceback.format_exc()) def btn(self): try: username = self.lineEditUsername.text() password = self.lineEditPassword.text() ip = "http://" + str(self.ipinfo) + "/static/remoteCookielogin/%s/%s" % (username, password) try: res = requests.get(url=ip, timeout=60) if res.text == "ok": QMessageBox.warning(self, "提示", "服务器AMRO登录成功！") self.close() else: QMessageBox.warning(self, "提示", "服务器AMRO登录失败，请检查账号和Cookie或服务器端登录或联系管理员检查服务器！") except: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") self.close() except Exception: logger.error(traceback.format_exc()) class checkCalllist(Ui_checkCalllist, QWidget): checkCalllist_signal = QtCore.pyqtSignal(str) def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) self.ipinfo = None self.selectedtime = None self.pushButton.clicked.connect(self.btn) # self.show() except Exception: logger.error(traceback.format_exc()) def start(self): try: selectedtime_time = str(self.selectedtime) + " 00:00:00" now = datetime.datetime.strptime(selectedtime_time, "%Y%m%d %H:%M:%S") tom = (now + datetime.timedelta(days=1)).strftime("%Y-%m-%d %H:%M:%S") yesterday = (now - datetime.timedelta(days=1)).strftime("%Y-%m-%d %H:%M:%S") self.label_5.setText("%s/%s" % (str(yesterday)[0:10], str(tom)[0:10])) ip = "http://" + str(self.ipinfo) + "/static/checkCalllist" + "/" + str(self.selectedtime) try: res = requests.get(url=ip, timeout=30).json() # print(res) except Exception: # print('登录服务器失败') QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) self.peopleLabel = ["序号", "电话", "工号", "姓名", "航班号", "拨号次数", "创建时间", "接通时间"] self.tableWidgetFlight.setColumnCount(len(self.peopleLabel)) self.tableWidgetFlight.verticalHeader().setVisible(False) self.tableWidgetFlight.setHorizontalHeaderLabels(self.peopleLabel) col = len(self.peopleLabel) diplaylist = res self.tableWidgetFlight.setRowCount(len(diplaylist.keys())) for row in diplaylist.keys(): for colNum in range(0, col): if colNum == 0: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem(str(row))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) else: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem(diplaylist[row][self.peopleLabel[colNum]])) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) self.tableWidgetFlight.resizeColumnsToContents() # self.show() except Exception: logger.error(traceback.format_exc()) def btn(self): try: ip = "http://" + str(self.ipinfo) + "/static/checkCalllist" + "/" + str(self.selectedtime) self.res = requests.get(url=ip, timeout=30).json() except Exception: # print('登录服务器失败') QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) self.res = {} col = len(self.peopleLabel) diplaylist = self.res self.tableWidgetFlight.setRowCount(len(diplaylist)) rownum = 0 for row in diplaylist: for colNum in range(0, col): if colNum == 0: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem(str(row))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) else: self.tableWidgetFlight.setItem(int(row), colNum,QTableWidgetItem(diplaylist[row][self.peopleLabel[colNum]])) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) self.tableWidgetFlight.resizeColumnsToContents() def closeEvent(self, event): try: reply = QMessageBox.question(self, '确认', '你确定要退出程序吗？') reply = str(reply) if reply == "StandardButton.Yes": self.checkCalllist_signal.emit(reply) event.ignore() else: event.ignore() except Exception: logger.error(traceback.format_exc()) class checkLoadSingal(Ui_checkLoadSingal, QWidget): def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) self.worknum = None self.name = None self.selectedtime = None self.ipinfo = None except Exception: logger.error(traceback.format_exc()) def start(self): try: # print(self.worknum) # print(self.name) # print(self.selectedtime) # print(self.ipinfo) self.label_3.setText(self.name) selectedtime_time = str(self.selectedtime) + " 00:00:00" now = datetime.datetime.strptime(selectedtime_time, "%Y%m%d %H:%M:%S") yesterday = (now - datetime.timedelta(days=1)).strftime("%Y-%m-%d %H:%M:%S") self.label_5.setText("%s/%s" % (str(yesterday)[0:10], str(now)[0:10])) # print(now) # print(yesterday) ip = "http://" + str(self.ipinfo) + "/static/checkLoadSingal" + "/" + str(self.worknum) + "/" + str( yesterday) + "/" + str(now) try: res = requests.get(url=ip, timeout=30).json() # print(res) except Exception: # print('登录服务器失败') logging.warning('登录服务器失败, res获取失败') QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) self.show() peopleLabel = ["序号", "保障日期", "类型", "机号", "机位", "开始时间", "结束时间"] self.tableWidgetFlight.setColumnCount(len(peopleLabel)) self.tableWidgetFlight.verticalHeader().setVisible(False) self.tableWidgetFlight.setHorizontalHeaderLabels(peopleLabel) col = len(peopleLabel) diplaylist = res self.tableWidgetFlight.setRowCount(len(diplaylist.keys())) for row in diplaylist.keys(): for colNum in range(0, col): if colNum == 0: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem(str(row))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) else: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem(diplaylist[row][peopleLabel[colNum]])) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) self.tableWidgetFlight.resizeColumnsToContents() except Exception: logger.error(traceback.format_exc()) class searchpeople_get(Ui_searchpeople_get, QWidget): searchpeoplelist_signal = QtCore.pyqtSignal(list) def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) self.pushButton.clicked.connect(self.btn) self.searchpeoplelist = None self.ipinfo = None self.Allpeoplelist = {} self.selectedtime = None self.selectedbc = None except Exception: logger.error(traceback.format_exc()) def btn(self): try: searchpeoplelist = [] for row in range(self.tableWidgetFlight.rowCount()): item = self.tableWidgetFlight.item(row, 2) if item is not None and item.checkState() == Qt.CheckState.Checked: name = self.tableWidgetFlight.item(row, 1).text() searchpeoplelist.append(name) # print(searchpeoplelist) self.searchpeoplelist = searchpeoplelist self.searchpeoplelist_signal.emit(self.searchpeoplelist) self.close() except Exception: logger.error(traceback.format_exc()) def start(self): try: self.show() peopleLabel = ["序号", "姓名", "选择"] diplaylist = self.Allpeoplelist self.tableWidgetFlight.setColumnCount(len(peopleLabel)) self.tableWidgetFlight.setHorizontalHeaderLabels(peopleLabel) self.tableWidgetFlight.verticalHeader().setVisible(False) self.tableWidgetFlight.setRowCount(len(diplaylist.keys())) for row in diplaylist.keys(): for colNum in range(0, 3): if colNum == 0: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem(str(row))) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 1: self.tableWidgetFlight.setItem(int(row), colNum, QTableWidgetItem(diplaylist[row][peopleLabel[colNum]])) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 2: checkbox = QTableWidgetItem() checkbox.setCheckState(Qt.CheckState.Unchecked) self.tableWidgetFlight.setItem(int(row), colNum, checkbox) self.tableWidgetFlight.item(int(row), colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) self.tableWidgetFlight.resizeColumnsToContents() except Exception: logger.error(traceback.format_exc()) class localipset(Ui_Addloacalip, QWidget): localipset_signal = QtCore.pyqtSignal(str) def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) self.pushButton.clicked.connect(self.btn) self.localip1 = None self.localip = None except Exception: logger.error(traceback.format_exc()) def start(self): self.show() self.lineEditIP.setText(self.localip) def btn(self): try: self.localip1 = self.lineEditIP.text() self.localipset_signal.emit(self.localip1) self.close() except Exception: logger.error(traceback.format_exc()) class checkLogs(Ui_checkLogs, QWidget): def __init__(self, parent=None): super().__init__(parent) self.setupUi(self) self.ipinfo = None self.endtime = (datetime.date.today() + datetime.timedelta(days=1)).strftime("%Y-%m-%d %H:%M:%S") self.starttime = (datetime.date.today() - datetime.timedelta(days=1)).strftime("%Y-%m-%d %H:%M:%S") self.dateTimeEdit.setDateTime(datetime.datetime.strptime(self.starttime, "%Y-%m-%d %H:%M:%S")) self.dateTimeEdit_2.setDateTime(datetime.datetime.strptime(self.endtime, "%Y-%m-%d %H:%M:%S")) self.lineEdit.textChanged.connect(self.changed) self.peopleLabel = ["序号", "航班编号", "警告信息", "信息状态", "提示信息", "产生时间", "处理人", "处理时间", "变更字段", "显示对象", "提示内容"] self.tableWidgetFlight.setColumnCount(len(self.peopleLabel)) self.tableWidgetFlight.verticalHeader().setVisible(False) self.tableWidgetFlight.setHorizontalHeaderLabels(self.peopleLabel) self.pushButton.clicked.connect(self.btn) def start(self): self.show() try: ip = "http://" + str(self.ipinfo) + "/static/checkLogs/" + self.starttime + "/" + self.endtime self.res = requests.get(url=ip, timeout=30).json() except Exception: # print('登录服务器失败') QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) self.res = {} col = len(self.peopleLabel) diplaylist = self.res self.tableWidgetFlight.setRowCount(len(diplaylist)) rownum = 0 for row in diplaylist: for colNum in range(0, col): if colNum == 0: self.tableWidgetFlight.setItem(rownum, colNum, QTableWidgetItem(str(rownum))) self.tableWidgetFlight.item(rownum, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) else: self.tableWidgetFlight.setItem(rownum, colNum, QTableWidgetItem(str(row[colNum]))) self.tableWidgetFlight.item(rownum, colNum).setTextAlignment(Qt.AlignmentFlag.AlignLeft) rownum += 1 self.tableWidgetFlight.resizeColumnsToContents() def changed(self): res = [] for i in self.res: if str(self.lineEdit.text()) in str(i): res.append(i) col = len(self.peopleLabel) diplaylist = res self.tableWidgetFlight.setRowCount(len(diplaylist)) rownum = 0 for row in diplaylist: for colNum in range(0, col): if colNum == 0: self.tableWidgetFlight.setItem(rownum, colNum, QTableWidgetItem(str(rownum))) self.tableWidgetFlight.item(rownum, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) else: self.tableWidgetFlight.setItem(rownum, colNum, QTableWidgetItem(str(row[colNum]))) self.tableWidgetFlight.item(rownum, colNum).setTextAlignment(Qt.AlignmentFlag.AlignLeft) rownum += 1 self.tableWidgetFlight.resizeColumnsToContents() def btn(self): self.starttime = self.dateTimeEdit.text() self.endtime = self.dateTimeEdit_2.text() try: ip = "http://" + str(self.ipinfo) + "/static/checkLogs/" + self.starttime + "/" + self.endtime self.res = requests.get(url=ip, timeout=30).json() except Exception: # print('登录服务器失败') QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) self.res = {} col = len(self.peopleLabel) diplaylist = self.res self.tableWidgetFlight.setRowCount(len(diplaylist)) rownum = 0 for row in diplaylist: for colNum in range(0, col): if colNum == 0: self.tableWidgetFlight.setItem(rownum, colNum, QTableWidgetItem(str(rownum))) self.tableWidgetFlight.item(rownum, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) else: self.tableWidgetFlight.setItem(rownum, colNum, QTableWidgetItem(str(row[colNum]))) self.tableWidgetFlight.item(rownum, colNum).setTextAlignment(Qt.AlignmentFlag.AlignLeft) rownum += 1 self.tableWidgetFlight.resizeColumnsToContents() class changeAuth(Ui_changeAuth, QWidget): def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) self.ipinfo = None self.label_5.setText("") self.label_6.setText("") self.pushButton.clicked.connect(self.btn) self.user = None self.comboBox.addItems(['1', '2', '3',"4"]) self.comboBox.setEditable(True) self.filterModel1 = QSortFilterProxyModel(self.comboBox) self.filterModel1.setFilterCaseSensitivity(Qt.CaseSensitivity.CaseInsensitive) self.filterModel1.setSourceModel(self.comboBox.model()) self.completer1 = QCompleter(self.filterModel1, self.comboBox) self.completer1.setCompletionMode(QCompleter.CompletionMode.UnfilteredPopupCompletion) self.completer1.setCaseSensitivity(Qt.CaseSensitivity.CaseInsensitive) self.comboBox.setCompleter(self.completer) self.comboBox.lineEdit().textEdited.connect(self.filterModel1.setFilterFixedString) self.completer1.activated.connect(self.on_completer_activated1) except Exception: logger.error(traceback.format_exc()) def start(self): self.show() try: ip = "http://" + str(self.ipinfo) + "/static/loginDbget/" + str(self.user) self.res = requests.get(url=ip, timeout=30).json() except Exception: # print('登录服务器失败') QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) self.res = {} if self.res != {}: namelist = [] for i in self.res.keys(): namelist.append(self.res[i]["登录名"]) print(namelist) self.comboBox_2.addItems(namelist) self.comboBox_2.setEditable(True) self.comboBox_2.currentIndexChanged.connect(self.changed) self.filterModel = QSortFilterProxyModel(self.comboBox_2) self.filterModel.setFilterCaseSensitivity(Qt.CaseSensitivity.CaseInsensitive) self.filterModel.setSourceModel(self.comboBox_2.model()) self.completer = QCompleter(self.filterModel, self.comboBox_2) self.completer.setCompletionMode(QCompleter.CompletionMode.UnfilteredPopupCompletion) self.completer.setCaseSensitivity(Qt.CaseSensitivity.CaseInsensitive) self.comboBox_2.setCompleter(self.completer) self.comboBox_2.lineEdit().textEdited.connect(self.filterModel.setFilterFixedString) self.completer.activated.connect(self.on_completer_activated) else: QMessageBox.warning(self, "提示", "获取数据库为空，请检查数据库或联系管理员") def on_completer_activated1(self, text): try: if text: index = self.comboBox.findText(text) self.comboBox.setCurrentIndex(index) except Exception: logger.error(traceback.format_exc()) def on_completer_activated(self, text): try: if text: print(text) index = self.comboBox_2.findText(text) self.comboBox_2.setCurrentIndex(index) except Exception: logger.error(traceback.format_exc()) def changed(self): if self.res != {}: self.label_5.setText(self.res[self.comboBox_2.currentText()]["使用人"]) self.label_6.setText(self.res[self.comboBox_2.currentText()]["权限"]) def btn(self): data = { '登录名': "'%s'" % self.comboBox_2.currentText(), "权限": "'%s'" % self.comboBox.currentText() } try: ip = "http://" + str(self.ipinfo) + "/static/changeAuth" data = json.dumps(data) res = requests.post(url=ip, data=data, timeout=30).json() if res["返回值"] == "1": QMessageBox.warning(self, "提示", "权限变更成功！") self.close() else: QMessageBox.warning(self, "提示", "权限变更失败，请联系管理员检查服务器！") except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) class changePassword(Ui_FormChangePssword, QWidget): def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) self.ipinfo = None self.pushButton.clicked.connect(self.btn) self.user = None except Exception: logger.error(traceback.format_exc()) def severpost_meassge(self, postname, postdata, postdata2): try: ip = "http://" + str(self.ipinfo) + "/static/" + str(postname) + str(postdata) + str(postdata2) res = requests.get(url=ip, timeout=30).json() return res except Exception: # print('登录服务器失败') QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) return '' def severpost_data(self, postname, data: dict): try: ip = "http://" + str(self.ipinfo) + "/static/" + str(postname) data = json.dumps(data) res = requests.post(url=ip, data=data, timeout=30).json() return res except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) return 'fail' def btn(self): try: oldpassword = self.lineEditold.text() newpassword = self.lineEditnew.text() newpassword2 = self.lineEditnew2.text() res = self.severpost_meassge("loginTable", "/%s" % self.user, "/%s" % oldpassword)["返回值"] # print(res) if res != "": if newpassword == newpassword2: dataDic = {'登录名': self.user, '新密码': newpassword, "旧密码": oldpassword} res = self.severpost_data("changePassword", dataDic) if res["返回值"] == "ok": self.close() QMessageBox.warning(self, "提示", "密码修改成功！！！") else: QMessageBox.warning(self, "提示", "密码修改失败，请检查服务器连接状态或联系管理员！！！") else: QMessageBox.warning(self, "警告", "两次密码输入不同！！！") else: QMessageBox.warning(self, "警告", "原密码错误！！！") except Exception: logger.error(traceback.format_exc()) class AddPGWidget(Ui_FormAddPG, QWidget): # AddPG_signal=QtCore.pyqtSignal(str) def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) nowDay = datetime.datetime.now() self.dateTimeEdit.setDateTime(nowDay) self.pushButton.clicked.connect(self.btn) # self.AddPG_signal.connect(self.getname) except Exception: logger.error(traceback.format_exc()) def getname(self, name, date, ip): try: self.getname = name self.getdate = date self.getip = ip # print(self.getname) # print(self.getdate) except Exception: logger.error(traceback.format_exc()) def severpost_meassge(self, postname, postdata, postdata2, postdata3): # print(ip) try: ip = "http://" + str(self.getip) + "/static/" + str(postname) + str(postdata) + str(postdata2) + str( postdata3) res = requests.get(url=ip, timeout=30).json() if res["返回值"] == "ok": QMessageBox.warning(self, "提示", "已创建待办") else: QMessageBox.warning(self, "提示", "创建待办失败，请检查配置文件或联系管理员检查服务器！") except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) def btn(self): try: dealtext = self.textEdit.toPlainText() time = self.dateTimeEdit.dateTime().toString('yyyy-M-d H:mm') # print(time) self.severpost_meassge("insertLogs", "/%s" % dealtext, "/%s" % self.getname, "/%s" % time) self.close() except Exception: logger.error(traceback.format_exc()) class addFlightWidget(Ui_FormAddFlight, QWidget): def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) nowDay = datetime.datetime.now() self.dateEdit.setDateTime(nowDay) self.dateTimeEdit.setDateTime(nowDay) self.dateTimeEdit_2.setDateTime(nowDay) self.pushButton.clicked.connect(self.btn) self.comboBox.addItems(['短停', '航前', '特后前', '航后']) self.comboBox.setEditable(True) self.comboBox.currentIndexChanged.connect(self.changed) self.filterModel = QSortFilterProxyModel(self.comboBox) self.filterModel.setFilterCaseSensitivity(Qt.CaseSensitivity.CaseInsensitive) self.filterModel.setSourceModel(self.comboBox.model()) self.completer = QCompleter(self.filterModel, self.comboBox) self.completer.setCompletionMode(QCompleter.CompletionMode.UnfilteredPopupCompletion) self.completer.setCaseSensitivity(Qt.CaseSensitivity.CaseInsensitive) self.comboBox.setCompleter(self.completer) self.comboBox.lineEdit().textEdited.connect(self.filterModel.setFilterFixedString) self.completer.activated.connect(self.on_completer_activated) self.ipinfo = None self.user = None except Exception: logger.error(traceback.format_exc()) def on_completer_activated(self, text): try: if text: print(text) index = self.comboBox.findText(text) self.comboBox.setCurrentIndex(index) except Exception: logger.error(traceback.format_exc()) def changed(self): if self.comboBox.currentText() == "航前": self.label_8.setEnabled(False) self.dateTimeEdit.setEnabled(False) self.label_9.setEnabled(True) self.dateTimeEdit_2.setEnabled(True) elif self.comboBox.currentText() == "航后": self.label_9.setEnabled(False) self.dateTimeEdit_2.setEnabled(False) self.label_8.setEnabled(True) self.dateTimeEdit.setEnabled(True) else: self.label_8.setEnabled(True) self.dateTimeEdit.setEnabled(True) self.label_9.setEnabled(True) self.dateTimeEdit_2.setEnabled(True) def btn(self): if self.lineEditPWD.text() != "" and self.lineEditUser.text() != "" and self.lineEditPeople.text() != "" and self.lineEdit.text() != "" and self.lineEdit_2.text() != "": ip = "http://" + str(self.ipinfo) + "/static/" + "manAddFlight/" + "%s/%s/%s/%s/%s/%s/%s/%s/%s/%s" % ( self.comboBox.currentText(), self.lineEditPWD.text(), self.lineEditUser.text(), self.lineEditPeople.text(), self.lineEdit.text(), self.dateEdit.text(), self.lineEdit_2.text(), self.dateTimeEdit.text(), self.dateTimeEdit_2.text(), self.user) try: res = requests.get(url=ip, timeout=30).json() if res["返回值"] == "ok": self.close() QMessageBox.warning(self, "提示", "航班添加成功！！！") else: self.close() QMessageBox.warning(self, "警告", "航班添加失败") except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) else: QMessageBox.warning(self, "警告", "请完善航班信息后再提交！") class handoverFlightWidget(Ui_handoverFlight, QWidget): handoverFlight_signal = QtCore.pyqtSignal(str) def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) self.pushButton.clicked.connect(self.btn) self.user = None self.ipinfo = None self.selectedtime=None self.Allflight = {} except Exception: logger.error(traceback.format_exc()) def severpostData_nomeassge(self, postname, data: dict): try: ip = "http://" + str(self.ipinfo) + "/static/" + str(postname) data = json.dumps(data) res = requests.post(url=ip, data=data, timeout=30).json() return res except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) def btn(self): try: list = [] sts=[] list_cz = [] sts_cz = [] rows=[] for row in range(self.tableWidgetFlight.rowCount()): item = self.tableWidgetFlight.item(row, 0) if item and item.checkState() == Qt.CheckState.Checked and self.tableWidgetFlight.item(row, 8).text() != "": name = self.tableWidgetFlight.item(row, 10).text() rows.append(row) list.append(name) sts.append("1") data = {"taskid": ','.join(list), "sts": ','.join(sts)} if list !=[]: res = self.severpostData_nomeassge("handoverflight", data=data)["返回值"] if res == "ok" : QMessageBox.warning(self, "提示", f"交班提交成功！请核对附加消息交班航班！") for ii in rows: try: if "【交班航班】" not in self.tableWidgetFlight.item(ii, 11).text() and self.tableWidgetFlight.item(ii, 8).text() != "": flightid = self.tableWidgetFlight.item(ii, 12).text() flighttype = self.tableWidgetFlight.item(ii, 7).text() fjxx = "【交班航班】" + self.tableWidgetFlight.item(ii, 11).text() ip = "http://" + str(self.ipinfo) + "/static/updateEidteItem/" + "%s/" % str(fjxx) + "%s/" % str(flightid) + "A/%s/" % str(flighttype) + "%s" % str(self.selectedtime) try: requests.get(url=ip, timeout=30).json() self.handoverFlight_signal.emit("1") except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) except: logger.error(traceback.format_exc()) self.close() else: QMessageBox.warning(self, "警告", "航班交接失败，请重新尝试") else: QMessageBox.warning(self, "警告", "请选择要交接的航班！未进行派工的航班无法进行交接班") except Exception: print(traceback.format_exc()) logger.error(traceback.format_exc()) def start(self): try: self.show() peopleLabel = ["选择","序号", "机号","航班号", "预达", "计飞", "机位", "类型", "维修人员","放行", "任务编号","附加消息","航班编号" ] tableWidgetDispalydata = self.Allflight self.tableWidgetFlight.setColumnCount(len(peopleLabel)) self.tableWidgetFlight.setHorizontalHeaderLabels(peopleLabel) self.tableWidgetFlight.verticalHeader().setVisible(False) self.tableWidgetFlight.setRowCount(len(tableWidgetDispalydata.keys())) i = 0 for row in tableWidgetDispalydata.keys(): if ("3U" in tableWidgetDispalydata[row][str(4)] or "CSC" in tableWidgetDispalydata[row][str(4)]) and \ tableWidgetDispalydata[row][str(24)] != "" and "【交班航班】" not in tableWidgetDispalydata[row][str(30)]: for colNum in range(0, 13): if colNum == 0: checkbox = QTableWidgetItem() checkbox.setCheckState(Qt.CheckState.Unchecked) self.tableWidgetFlight.setItem(i, colNum, checkbox) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 1: self.tableWidgetFlight.setItem(i, colNum, QTableWidgetItem(str(i+1))) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 2: self.tableWidgetFlight.setItem(i, colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(1)]))) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 3: self.tableWidgetFlight.setItem(i, colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(4)]))) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 4: self.tableWidgetFlight.setItem(i, colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(6)]))) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 5: self.tableWidgetFlight.setItem(i, colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(7)]))) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 6: self.tableWidgetFlight.setItem(i, colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(8)]))) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 7: self.tableWidgetFlight.setItem(i, colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(9)]))) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 8: self.tableWidgetFlight.setItem(i, colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(24)]))) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 9: self.tableWidgetFlight.setItem(i, colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(25)]))) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 10: self.tableWidgetFlight.setItem(i, colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(26)]))) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 12: self.tableWidgetFlight.setItem(i, colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(26)]))) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) elif colNum == 11: self.tableWidgetFlight.setItem(i, colNum, QTableWidgetItem(str(tableWidgetDispalydata[row][str(30)]))) self.tableWidgetFlight.item(i, colNum).setTextAlignment(Qt.AlignmentFlag.AlignCenter) if (i+1)%2 ==0: self.tableWidgetFlight.item(i, colNum).setBackground(QColor('#DDE2E3')) i += 1 self.tableWidgetFlight.resizeColumnsToContents() self.tableWidgetFlight.setColumnHidden(12, True) self.tableWidgetFlight.setColumnHidden(10, True) except Exception: #print(traceback.format_exc()) logger.error(traceback.format_exc()) class addUserWidget(Ui_FormAdduser, QWidget): def __init__(self, parent=None): super().__init__(parent) try: self.setupUi(self) self.pushButton.clicked.connect(self.btn) self.comboBox.addItems(['1', '2', '3',"4"]) self.comboBox.setEditable(True) self.filterModel = QSortFilterProxyModel(self.comboBox) self.filterModel.setFilterCaseSensitivity(Qt.CaseSensitivity.CaseInsensitive) self.filterModel.setSourceModel(self.comboBox.model()) self.completer = QCompleter(self.filterModel, self.comboBox) self.completer.setCompletionMode(QCompleter.CompletionMode.UnfilteredPopupCompletion) self.completer.setCaseSensitivity(Qt.CaseSensitivity.CaseInsensitive) self.comboBox.setCompleter(self.completer) self.comboBox.lineEdit().textEdited.connect(self.filterModel.setFilterFixedString) self.completer.activated.connect(self.on_completer_activated) self.ipinfo = None self.user = None self.authority=None except Exception: logger.error(traceback.format_exc()) def severpost_meassge(self, postname, data: dict): try: ip = "http://" + str(self.ipinfo) + "/static/" + str(postname) data = json.dumps(data) res = requests.post(url=ip, data=data, timeout=30).json() return res except Exception: QMessageBox.warning(self, "提示", "服务器连接超时，请联系管理员检查服务器！") logger.error(traceback.format_exc()) return 'fail' def on_completer_activated(self, text): try: if text: index = self.comboBox.findText(text) self.comboBox.setCurrentIndex(index) except Exception: logger.error(traceback.format_exc()) def btn(self): try: if int(self.authority) <= 1: username = self.lineEditUser.text() password = self.lineEditPWD.text() authority = self.comboBox.currentText() people = self.lineEditPeople.text() if username != "" and password != "": # print('用户名：{}，密码：{}，权限：{}，使用人：{}'.format(username,password,authority,people)) dataDic = { '登录名': username, '密码': password, '权限': authority, '使用人': people } res = self.severpost_meassge("addUserWidget", dataDic) if res["返回值"] == "1": self.close() self.show_message("提示", "用户创建成功！！！") else: self.show_message("警告", "此用户已存在") else: self.show_message("警告", "用户名或密码不能为空！！！") else: self.close() self.show_message("警告", "权限不够，请联系管理员！！！") except Exception: logger.error(traceback.format_exc()) def show_message(self, type, str): try: QMessageBox.warning(self, "%s" % type, "%s" % str) except Exception: logger.error(traceback.format_exc()) class findServerWidget(Ui_FormLink, QWidget): selectServer_signal = QtCore.pyqtSignal(str) def __init__(self, parent=None): super().__init__(parent) try: self.threadpool = QThreadPool() self.setupUi(self) self.serverList = [] self.tableWidget.setColumnCount(2) self.tableWidget.setHorizontalHeaderLabels(['服务器地址', '状态']) self.threadWork_findServer() self.tableWidget.setEditTriggers(QAbstractItemView.EditTrigger.NoEditTriggers) self.tableWidget.cellDoubleClicked.connect(self.selectServer) self.pushButton_manset.clicked.connect(self.setipinfo) except Exception: logger.error(traceback.format_exc()) def setipinfo(self): try: self.ipinfo = "" if os.path.exists("server.code") is True: read_path = os.getcwd() + "\\server.code" with open(read_path, "r", encoding="utf-8") as f2: rember_2 = f2.read() if ';' in rember_2: self.ipinfo = rember_2.split(';')[0] self.ipinfo1 = rember_2.split(':')[0] ip = "http://" + str(self.ipinfo) + "/static/linktest" try: res = requests.get(url=ip, timeout=30) self.selectServer_signal.emit(self.ipinfo1) if res.text == "ok": QMessageBox.warning(self, "提示", "服务器人工配置成功！") else: QMessageBox.warning(self, "提示", "服务器人工配置失败，请检查配置文件或联系管理员检查服务器！") except Exception: QMessageBox.warning(self, "提示", "服务器人工配置失败，请联系管理员检查服务器！") logger.error(traceback.format_exc()) else: QMessageBox.warning(self, "提示", "服务器人工配置失败，请检查配置文件或联系管理员检查服务器！") else: QMessageBox.warning(self, "提示", "服务器人工配置失败，系统缺少配置文件！") except Exception: logger.error(traceback.format_exc()) def setipinfo2(self): try: self.ipinfo = "" if os.path.exists("server.code") is True: read_path = os.getcwd() + "\\server.code" with open(read_path, "r", encoding="utf-8") as f2: rember_2 = f2.read() if ';' in rember_2: self.ipinfo = rember_2.split(';')[0] self.ipinfo1 = rember_2.split(':')[0] ip = "http://" + str(self.ipinfo) + "/static/linktest" try: res = requests.get(url=ip, timeout=30) self.selectServer_signal.emit(self.ipinfo1) if res.text == "ok": QMessageBox.warning(self, "提示", "服务器搜索失败，自动检索配置文件配置成功！") else: QMessageBox.warning(self, "提示", "服务器搜索失败，自动检索配置文件配置成功，服务器连接失败，请检查配置文件或联系管理员检查服务器！") except Exception: QMessageBox.warning(self, "提示", "服务器搜索失败，自动检索配置文件配置成功，服务器连接失败，请检查配置文件或联系管理员检查服务器！") logger.error(traceback.format_exc()) else: QMessageBox.warning(self, "提示", "服务器搜索失败，自动检索配置文件配置失败，请检查配置文件或联系管理员检查服务器！") else: QMessageBox.warning(self, "提示", "服务器搜索失败，自动检索配置文件配置失败，系统缺少配置文件！") except Exception: logger.error(traceback.format_exc()) def selectServer(self, row, col): # print(self.tableWidget.item(row,col).text()) try: self.selectServer_signal.emit(self.tableWidget.item(row, 0).text()) except Exception: logger.error(traceback.format_exc()) def threadWork_findServer(self): try: worker = Worker2(self.fn) worker.signals.result.connect(self.print_out_result) self.threadpool.start(worker) except Exception: logger.error(traceback.format_exc()) def fn(self): try: serverList = serverFind.findServer() return serverList except Exception: logger.error(traceback.format_exc()) def print_out_result(self, dlist): try: self.serverList = dlist # print(self.serverList) if self.serverList == [] or self.serverList ==None: self.setipinfo2() else: self.tableWidget.setRowCount(len(self.serverList)) rowNum = 0 for row in self.serverList: colNum = 0 for col in row: self.tableWidget.setItem(rowNum, colNum, QTableWidgetItem(col)) colNum += 1 rowNum += 1 except Exception: logger.error(traceback.format_exc()) class mapWebWidget(Ui_FormMapWeb, QWidget): def __init__(self): super().__init__() self.setupUi(self) # self.webEngineView.load(QUrl('http://192.168.2.22:6010/')) class Worker2(QRunnable): def __init__(self, fn, *args, **kwargs): super(Worker2, self).__init__() # Store constructor arguments (re-used for processing) self.fn = fn self.args = args self.kwargs = kwargs self.signals = WorkerSignals() @pyqtSlot() def run(self): try: result = self.fn( *self.args, **self.kwargs ) except Exception: traceback.print_exc() exctype, value = sys.exc_info()[:2] self.signals.error.emit((exctype, value, traceback.format_exc())) else: self.signals.result.emit(result) # Return the result of the processing finally: self.signals.finished.emit() class WorkerSignals(QObject): finished = pyqtSignal() error = pyqtSignal(tuple) result = pyqtSignal(object) if __name__ == '__main__': app = QApplication(sys.argv) mw = MainWidget() sys.exit(app.exec())