flightinfo_QT/Functions/QTMain_old.py

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("</br>")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("</br>")[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("</br>")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("</br>")[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("</br>")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("</br>")[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("</br>")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("</br>")[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("</br>")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("</br>")[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("</br>")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("</br>")[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("</br>")[0] + ",出" +self.tableWidgetFlight.item(rowIndex, colnum - 3).text().split("</br>")[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())