from .flightDB import flightDB from unitls.LogerinTxt import app_logger from .judge_bc import judge_bc def get_empNos(database:flightDB,dict:dict): try: date=judge_bc()["date"] date_str=judge_bc()["date"][0:4]+"-"+judge_bc()["date"][4:6]+"-"+judge_bc()["date"][6:] bc = judge_bc()["bc"] faillist=[] WXempNos = "" ESempNos = "" FXempNos = "" WX = "" ES = "" FX = "" wxkey = ["工1", "工2", "工3", "工4"] eskey = ["工1", "工2", "工3", "工4"] for i in wxkey: if dict[i] != "": aa = [] if bc == "A": aa = database.queryTabel("pglist{}".format(date), "工号", "班次='A' and 姓名='%s'" % dict[i]) elif bc == "B": aa = database.queryTabel("pglist{}".format(date), "工号", "班次='B' and 姓名='%s'" % dict[i]) if len(aa) != 0 and WXempNos == "": if aa[0][0] !="": WXempNos = str(aa[0][0]) else: faillist.append(dict[i]) elif len(aa) != 0 and WXempNos != "": if aa[0][0] != "": WXempNos =WXempNos+","+str(aa[0][0]) else: faillist.append(dict[i]) elif len(aa) == 0: faillist.append(dict[i]) if dict[i] != "" and WX == "": WX=dict[i] elif dict[i] != "" and WX != "": WX=WX+","+dict[i] for i in eskey: if dict[i] != "": aa = [] if bc == "A": aa = database.queryTabel("pglist{}".format(date), "工号", "班次='A' and 姓名='%s'" % dict[i]) elif bc == "B": aa = database.queryTabel("pglist{}".format(date), "工号", "班次='B' and 姓名='%s'" % dict[i]) if len(aa) != 0 and ESempNos == "": if aa[0][0] !="": ESempNos = str(aa[0][0]) else: faillist.append(dict[i]) elif len(aa) != 0 and ESempNos != "": if aa[0][0] != "": ESempNos =ESempNos+","+str(aa[0][0]) else: faillist.append(dict[i]) elif len(aa) == 0: faillist.append(dict[i]) if dict[i] != "" and ES == "": ES=dict[i] elif dict[i] != "" and ES != "": ES=ES+","+dict[i] if dict["放行"] != "": aa = [] if bc == "A": aa=database.queryTabel("pglist{}".format(date),"工号","班次='A' and 姓名='%s'"%dict["放行"]) elif bc == "B": aa=database.queryTabel("pglist{}".format(date),"工号","班次='B' and 姓名='%s'"%dict["放行"]) if len(aa) != 0 and FXempNos == "": if aa[0][0] != "": FXempNos = str(aa[0][0]) else: faillist.append(dict["放行"]) elif len(aa) != 0 and FXempNos != "": if aa[0][0] != "": FXempNos = FXempNos + "," + str(aa[0][0]) else: faillist.append(dict["放行"]) elif len(aa) == 0: faillist.append(dict["放行"]) FX=dict["放行"] if WXempNos =="" and FXempNos=="" and ESempNos=="": dict1={"code":"fail","WXempNos":"","FXempNos":"","ESempNos":"","faillist":faillist,"date":date_str,"bc":bc,"WX":WX,"FX":FX,"ES":ES} elif faillist=="": dict1 = {"code": "ok", "WXempNos": WXempNos, "FXempNos": FXempNos, "ESempNos": ESempNos, "faillist":faillist,"date":date_str,"bc":bc,"WX":WX,"FX":FX,"ES":ES} elif faillist !="": dict1 = {"code": "justok", "WXempNos": WXempNos, "FXempNos": FXempNos, "ESempNos": ESempNos, "faillist":faillist,"date":date_str,"bc":bc,"WX":WX,"FX":FX,"ES":ES} return dict1 except Exception as e: app_logger.log_error(e)