def SearchExec(inputValue, sPage):
nPage = int(sPage)
cursor = connect.cursor()
sSql = SearchSql(inputValue)
cursor.execute(sSql)
row = cursor.fetchone()
sList = []
nAllNum = 0
while row:
sDict = {
'sCardNo': row[0],
'sMaterialNo': row[1],
'sOrderNo': row[2],
'sEquipmentNo': row[3],
'sCheckType': row[4],
'ID': row[5],
'nHDRID': row[6],
}
nAllNum += 1
if nAllNum > (nPage - 1) * 10 and nAllNum <= nPage * 10:
sList.append(sDict)
row = cursor.fetchone()
cursor.close()
nPageNumber = math.ceil(nAllNum / 11)
return sList, nPageNumber
def DyeingData():
sSQL = ExportSQL()
# print(sSQL)
cursor = connect.cursor()
cursor.execute(sSQL)
row = cursor.fetchone()
returnData = []
print(sSQL)
while row:
dictVar = {
'sEquipmentNo': row[0],
'sPlanEquipmentNo': row[1],
'sOverTime': row[2],
'sCustomerName': row[3],
'sCardNo': row[4],
'sMaterialNo': row[5],
'sMaterialLot': row[6],
'sColorNo': row[7],
'nFactInputQty': row[8],
'sWorkingProcedureNameLast': row[9],
'sWorkingProcedureNameCurrent': row[10],
'sWorkingProcedureNameNext': row[11],
'nDyeingTime': row[12],
'sLocation': row[13],
'sRemark': row[14],
'sOrderNo': row[15],
}
returnData.append(dictVar)
row = cursor.fetchone()
print(returnData)
cursor.close()
return returnData
def DXTop3():
ReturnData = []
sSql = DXTop3Sql()
cursor = connect.cursor()
cursor.execute(sSql)
row = cursor.fetchone()
getData = []
nNabnorNumber = 0
nStateNumber = 0
nStartUpNumber = 0
while row:
sType = row[2]
dictVar = {
'sType': sType,
'sRemark': row[3],
'sEquipmentNo': row[4],
'nCount': row[5],
}
if sType == 'abnormal':
nNabnorNumber += 1
elif sType == 'state':
nStateNumber += 1
elif sType == 'startUp':
nStartUpNumber += 1
getData.append(dictVar)
row = cursor.fetchone()
cursor.close()
return getData, nNabnorNumber, nStateNumber, nStartUpNumber
def wpStatus():
TJWip = []
SXWip = []
YDWip = []
DyeWip = []
CDWip = []
BZWip = []
cursor = connect.cursor()
# 创建一个游标对象,python里的sql语句都要通过cursor来执行
WorkingProcedureStatus = WorkingStatusSQL()
cursor.execute(WorkingProcedureStatus)
# 执行sql语句
row = cursor.fetchone()
while row:
sPerinner = ''
sPerOut = '100%'
sOutColor = ''
sInnerColor = ''
if row[1] <= int(80):
sPerinner = str(row[1]) + '%'
sOutColor = 'progress-bar-success'
sInnerColor = 'progress-bar-info'
elif row[1] > int(80) and int(row[1]) <= int(100):
sPerinner = str(row[1]) + '%'
sOutColor = 'progress-bar-success'
sInnerColor = 'progress-bar-warning'
elif row[1] > int(100):
sPerinner = str(row[1]) + '%'
sOutColor = 'progress-bar-danger'
sInnerColor = 'progress-bar-warning'
dictVar = {
'sWorkingProcedureName': row[0],
'sPerinner': sPerinner,
'sPerOut': sPerOut,
'sOutColor': sOutColor,
'sInnerColor': sInnerColor,
'sTDX': row[2],
}
if row[0] == '退卷':
TJWip.append(dictVar)
elif row[0] == '水洗':
SXWip.append(dictVar)
elif row[0] == '预定':
YDWip.append(dictVar)
elif row[0] == '染色':
DyeWip.append(dictVar)
elif row[0] == '成定型':
CDWip.append(dictVar)
elif row[0] == '包装':
BZWip.append(dictVar)
row = cursor.fetchone()
cursor.close()
return TJWip, SXWip, YDWip, DyeWip, CDWip, BZWip
def GetWorking(sWorkingProcedureName):
ReturnData = []
sSQL = SearchWoringSQL(sWorkingProcedureName)
cursor = connect.cursor()
cursor.execute(sSQL)
row = cursor.fetchone()
while row:
ReturnData.append(row[0])
row = cursor.fetchone()
cursor.close()
return ReturnData
def SearchEquipment(sEquipmentModelName):
ReturnData = []
sSQL = SearchEquipmentSQL(sEquipmentModelName)
cursor = connect.cursor()
cursor.execute(sSQL)
row = cursor.fetchone()
while row:
dictVar = {
'sEquipmentNo': row[1],
'sEquipmentName': row[2],
'uemEquipmentGUID': row[3],
}
ReturnData.append(dictVar)
row = cursor.fetchone()
cursor.close()
return ReturnData
def DXDone():
ReturnData = []
sSql = DXDoneSql()
cursor = connect.cursor()
cursor.execute(sSql)
row = cursor.fetchone()
while row:
dictVar = {
'sEquipmentNo': row[0],
'nFinish': row[1],
'nNotFinish': row[2],
}
ReturnData.append(dictVar)
row = cursor.fetchone()
cursor.close()
return ReturnData
def Data_DXPlan(sEquipmentID):
sSQL = DXPlanSQL(sEquipmentID)
cursor = connect.cursor()
cursor.execute(sSQL)
row = cursor.fetchone()
returnData = []
equipmentList = []
while row:
dictVar = {
'sBorderColor': row[0],
'sCardNo': row[1],
'sMaterialNo': row[2],
'sMaterialLot': row[3],
'sColorNo': row[4],
'nFactInPutQty': row[5],
'sCustomerName': row[6],
'sSalesGroupName': row[7],
'nTemp': row[8],
'nSpeed': row[9],
'nTime': row[10],
'sProductWidth': row[11],
'sProductGMWT': row[12],
'sColorBorder': row[13],
'uppTrackJobGUID': row[14],
'sWorkingProcedureNameCurrent': row[15],
'sLocation': row[16],
'sEquipmentNo': row[17],
'nHDRID': row[18],
'nRowNumber': row[19],
'sWorkingProcedureNameLast': row[20],
'sWorkingProcedureNameNext': row[21],
}
equipmentDict = {
'nHDRID': row[18],
}
if equipmentDict not in equipmentList:
equipmentList.append(equipmentDict)
# print(dictVar)
# print(dictVar)
returnData.append(dictVar)
row = cursor.fetchone()
cursor.close()
return returnData
def StoreStatus():
FPStore = []
STAStore = []
STCStore = []
storeStatus = storeStatusSQL()
cursor = connect.cursor()
cursor.execute(storeStatus)
row = cursor.fetchone()
sPerinner = ''
sOutColor = ''
sInnerColor = ''
while row:
if row[1] <= int(80):
sPerinner = str(row[1]) + '%'
sOutColor = 'progress-bar-success'
sInnerColor = 'progress-bar-info'
elif row[1] > int(80) and int(row[1]) <= int(100):
sPerinner = str(row[1]) + '%'
sOutColor = 'progress-bar-success'
sInnerColor = 'progress-bar-warning'
elif row[1] > int(100):
sPerinner = '100%'
sOutColor = 'progress-bar-warning'
sInnerColor = 'progress-bar-danger'
dictVar = {
'sStoreName': row[0],
'sPerinner': sPerinner,
'sTDX': row[2],
'sOutColor': sOutColor,
'sInnerColor': sInnerColor,
}
if row[0] == '胚仓':
FPStore.append(dictVar)
elif row[0] == '成品仓AB':
STAStore.append(dictVar)
elif row[0] == '成品仓C':
STCStore.append(dictVar)
row = cursor.fetchone()
cursor.close()
return FPStore, STAStore, STCStore
def SearchFun(sSearchValue):
print(sSearchValue)
ReturnData = []
sSQL = SearchFunSql(sSearchValue)
cursor = connect.cursor()
cursor.execute(sSQL)
row = cursor.fetchone()
sEquipmentNo = ''
while row:
sEquipmentNo = row[1]
dictVar = {
'nRowNumber': row[0],
'sEquipmentNo': row[1],
'tPlanTime': row[2],
'sOverTime': row[3],
'sCustomerName': row[4],
'sLocation': row[5],
'sMaterialNo': row[6],
'sMaterialLot': row[7],
'sCardNo': row[8],
'sColorNo': row[9],
'nFactInputQty': row[10],
'sWorkingProcedureNameLast': row[11],
'sWorkingProcedureNameCurrent': row[12],
'sWorkingProcedureNameNext': row[13],
'dReplyDate': row[14],
'dDeliveryDate': row[15],
'nTime': row[16],
'sSalesGroupName': row[17],
'sRemark': row[18],
'sLabel': row[19],
'tFactEndTime': row[20],
'tUpdateTime': row[21],
'nPMCNumber': row[22],
'sPMCType': row[23],
'uppTrackJobGUID': row[24],
'sOrderNo': row[25]
}
ReturnData.append(dictVar)
row = cursor.fetchone()
cursor.close()
return ReturnData, sEquipmentNo
def DyeingEquipment(sEquipmentModelName):
ReturnData = []
sSQL = DyeingEquipmentSql(sEquipmentModelName)
print(sSQL)
cursor = connect.cursor()
cursor.execute(sSQL)
row = cursor.fetchone()
while row:
dictVar = {
'ID': row[0],
'sEquipmentNo': row[1],
'sEquipmentName': row[2],
'nCardCount': row[3],
'nCheckCount': row[4],
'nNoCheckCount': row[5],
}
ReturnData.append(dictVar)
row = cursor.fetchone()
cursor.close()
return ReturnData
def searchValue(inputValue):
ReturnData = []
sSQL = searchSql(inputValue)
print('=====================')
print(sSQL)
cursor = connect.cursor()
cursor.execute(sSQL)
row = cursor.fetchone()
while row:
dictVar = {
'sCardNo': row[0],
'sEquipmentNo': row[1],
'sMaterialNo': row[2],
'sWorkingProcedureNameCurrent': row[3],
'nHDRID': row[4],
}
ReturnData.append(dictVar)
row = cursor.fetchone()
cursor.close()
return ReturnData
def importData_PMC(Data):
cursor = connect.cursor()
INSERTData = []
sql = InsertImportData()
for innerData in Data:
sType = innerData['sType']
dData = innerData['Data']
print(dData)
e = 0
for i in dData:
sList = (sType, e, i['TrackJob'], GetDate(), i['加急'], i['生产卡号'])
print(sList)
INSERTData.append(sList)
e += 1
print('============插入===========')
cursor.executemany(sql, INSERTData)
connect.commit()
cursor.close()
# print(sql)
print('导入成功')
def IDGetData(ID):
ReturnData = []
sSQL = IDGetDataSql(ID)
print(sSQL)
cursor = connect.cursor()
cursor.execute(sSQL)
row = cursor.fetchone()
while row:
dictVar = {
'sEquipmentNo': row[0],
'ID': row[1],
'sOverTime': row[2],
'sCardNo': row[3],
'sMaterialNo': row[4],
'sMaterialLot': row[5],
'sColorNo': row[6],
'sWorkingProcedureNameLast': row[7],
'sWorkingProcedureNameCurrent': row[8],
'nFactInputQty': row[9],
'nDyeingTime': row[10],
'sCustomerName': row[11],
'sSalesGroupName': row[12],
'sSalesName': row[13],
'sColorCode': row[14],
'nRowNumber': row[15],
'sType': row[16],
'sIsStart': row[17],
'sPSColor': row[18],
'sDyeingCount': row[19],
'sDyeingColor': row[20],
'sWorkCode': row[21],
'sIsHYS': row[22],
'bISCheck': row[23],
'sOverColor': row[24],
'sWorkingProcedureNameNext': row[25],
}
ReturnData.append(dictVar)
row = cursor.fetchone()
cursor.close()
return ReturnData
def SearchAllData(sFeild, sWoring):
ReturnData = []
sSQL = GetData_AllNoPlan(sFeild, sWoring)
cursor = connect.cursor()
cursor.execute(sSQL)
row = cursor.fetchone()
while row:
dictVar = {
'ID': row[0],
'sIsRush': row[1],
'sCardNo': row[2],
'sMaterialNo': row[3],
'sMaterialLot': row[4],
'sColorNo': row[5],
'nFactInputQty': row[6],
'sWorkingProcedureNameCurrent': row[7],
'tFactEndTimeLast': row[8],
'sNotDoneProcedure': row[9],
'nTJTime': row[10],
'nPSTime': row[11],
'nDyeingTime': row[12],
'nSETime': row[13],
'sCustomerName': row[14],
'sSalesName': row[15],
'sSalesGroupName': row[16],
'sColorBorder': row[17],
'nOverTime': row[18],
'uppTrackJobGUID': row[20],
'sLocation': row[21],
'sWorkingProcedureNameLast': row[22],
'sWorkingProcedureNameNext': row[23],
'dReplyDate': row[24],
'dDeliveryDate': row[25],
'sRemark': row[26]
}
ReturnData.append(dictVar)
row = cursor.fetchone()
cursor.close()
return ReturnData
def equipmentServiceData(*args):
nPage = ''.join(args)
nThisPage = 1
if nPage == '' or nPage == None:
nThisPage = 1
else:
nThisPage = nPage
cursor = connect.cursor()
sSql = equipmentServiceSQL()
cursor.execute(sSql)
row = cursor.fetchone()
sList = []
nCount = 0
nAllPage = 0
while row:
# print(row)
sDict = {
'sServiceNo': row[0],
'sTime': row[1],
'sWorkCentreName': row[2],
'sReportName': row[3],
'sServiceType': row[4],
'sEquipmentName': row[5],
'sEquipmentNo': row[6],
'sEquipmentDetailType': row[7],
'sEquipmentDetail': row[8],
'sServiceName': row[9],
'sFaultReason': row[10],
'sServiceStatus': row[11],
'sStatus': row[12],
}
if nCount // 10 == int(nThisPage):
sList.append(sDict)
nAllPage = nCount // 10
nCount += 1
row = cursor.fetchone()
cursor.close()
return sList, nCount, nAllPage
def Data_DXNoPlan_Type(sWorkingProcedureName, sMaterialType):
# print(args)
sSQL = NoDXPlanSQL(sWorkingProcedureName)
cursor = connect.cursor()
cursor.execute(sSQL)
row = cursor.fetchone()
returnData2 = []
while row:
if sMaterialType == str(row[19]):
dictVar = {
'sBorderColor': row[0],
'sCardNo': row[1],
'sMaterialNo': row[2],
'sMaterialLot': row[3],
'sColorNo': row[4],
'nFactInPutQty': row[5],
'sCustomerName': row[6],
'sSalesGroupName': row[7],
'nTemp': row[8],
'nSpeed': row[9],
'nTime': row[10],
'sProductWidth': row[11],
'sProductGMWT': row[12],
'sColorBorder': row[13],
'uppTrackJobGUID': row[14],
'sWorkingProcedureName': str(row[15]),
'sLocation': str(row[16]),
'sWorkingProcedureNameLast': str(row[17]),
'sWorkingProcedureNameNext': str(row[18]),
'sMaterialType': str(row[19]),
}
# print('bbbbbffdsd')
# print(dictVar)
returnData2.append(dictVar)
row = cursor.fetchone()
cursor.close()
return returnData2
def Data_NoPlan(sWorkingProcedureName):
ReturnData = []
print(sWorkingProcedureName)
sSQL = GetData_NoPlan(sWorkingProcedureName)
print(sSQL)
cursor = connect.cursor()
cursor.execute(sSQL)
row = cursor.fetchone()
while row:
dictVar = {
'nOverTime': row[0],
'sCustomerName': row[1],
'sLocation': row[2],
'sMaterialNo': row[3],
'sMaterialLot': row[4],
'sCardNo': row[5],
'sColorNo': row[6],
'nFactInputQty': row[7],
'sWorkingProcedureNameLast': row[8],
'sWorkingProcedureNameCurrent': row[9],
'sWorkingProcedureNameNext': row[10],
'dReplyDate': row[11],
'dDeliveryDate': row[12],
'nTJTime': row[13],
'nPSTime': row[14],
'nDyeingTime': row[15],
'nSETime': row[16],
'sSalesGroupName': row[17],
'sRemark': row[18],
'sLabel': row[19],
'uppTrackJobGUID': row[20],
}
ReturnData.append(dictVar)
row = cursor.fetchone()
cursor.close()
return ReturnData
def Data_Plan(sWorkingProcedureName):
ReturnData = []
sSQL = GetData_Plan(sWorkingProcedureName)
print('================')
print(sWorkingProcedureName)
print(sSQL)
cursor = connect.cursor()
cursor.execute(sSQL)
row = cursor.fetchone()
while row:
tPlanTime = row[24]
sEquipmentNo = row[23]
nRowNumber = row[22]
if tPlanTime == None and sEquipmentNo != None:
tPlanTime = '未开机'
if nRowNumber != None:
nRowNumber = int(nRowNumber) + 1
else:
nRowNumber = ''
if tPlanTime == None:
tPlanTime = ''
if sEquipmentNo == None:
sEquipmentNo = ''
dictVar = {
'nOverTime': row[0],
'sCustomerName': row[1],
'sLocation': row[2],
'sMaterialNo': row[3],
'sMaterialLot': row[4],
'sCardNo': row[5],
'sColorNo': row[6],
'nFactInputQty': row[7],
'sWorkingProcedureNameLast': row[8],
'sWorkingProcedureNameCurrent': row[9],
'sWorkingProcedureNameNext': row[10],
'dReplyDate': row[11],
'dDeliveryDate': row[12],
'nTJTime': row[13],
'nPSTime': row[14],
'nDyeingTime': row[15],
'nSETime': row[16],
'sSalesGroupName': row[17],
'sRemark': row[18],
'sLabel': row[19],
'uppTrackJobGUID': row[20],
'tUpdateTime': row[21],
'nRowNumber': nRowNumber,
'sEquipmentNo': sEquipmentNo,
'tPlanTime': tPlanTime,
}
ReturnData.append(dictVar)
row = cursor.fetchone()
# print(ReturnData)
if ReturnData == []:
dictVar = {
'ID': 1,
'sIsRush': '',
'sCardNo': '',
'sMaterialNo': '',
'sMaterialLot': '',
'sColorNo': '',
'nFactInputQty': '',
'sWorkingProcedureNameCurrent': '',
'tFactEndTimeLast': '',
'sNotDoneProcedure': '',
'nTJTime': '',
'nPSTime': '',
'nDyeingTime': '',
'nSETime': '',
'sCustomerName': '',
'sSalesName': '',
'sSalesGroupName': '',
'sColorBorder': '',
'nOverTime': '',
'uppTrackJobGUID': '',
'sLabel': '#FFF',
'sLocation': '',
'sRemark': '',
'sWorkingProcedureNameLast': '',
'sWorkingProcedureNameNext': '',
'dReplyDate': '',
'dDeliveryDate': '',
}
ReturnData.append(dictVar)
cursor.close()
return ReturnData
def emStatus():
# 执行SQL语句转为List-详细
TJ_eq = []
Dye_eq1 = []
Dye_eq2 = []
Dye_eq3 = []
Dye_eq4 = []
Dye_eq5 = []
Dye_eq6 = []
TS_eq = []
SX_eq = []
DX_eq1 = []
DX_eq2 = []
DJ_eq = []
YB_eq = []
MM_eq = []
PB_eq = []
DB_eq = []
FB_eq = []
equipmentStatus = equipmentStatusSQL()
cursor = connect.cursor()
# 创建一个游标对象,python里的sql语句都要通过cursor来执行
cursor.execute(equipmentStatus)
# 执行sql语句
row = cursor.fetchone()
# 读取查询结果
while row:
# print(row)
dictVar = {
'sEquipmentNo': row[1],
'sEquipmentName': row[2],
'sStatusColor': row[8],
}
if row[1] in ('LDR03', 'LDR02', 'LDR01'):
TJ_eq.append(dictVar)
elif row[1] in ('HQ03'):
MM_eq.append(dictVar)
elif row[1] in ('E027', 'E030', 'E029'):
Dye_eq1.append(dictVar)
elif row[1] in ('E028', 'E031', 'E026', 'E025'):
Dye_eq2.append(dictVar)
elif row[1] in ('A001', 'A002', 'A003', 'A004', 'A005', 'A006', 'C020'):
Dye_eq3.append(dictVar)
elif row[1] in ('B007', 'B008', 'B009', 'B010'):
Dye_eq4.append(dictVar)
elif row[1] in ('C015', 'C016', 'C017', 'C018', 'C019'):
Dye_eq5.append(dictVar)
elif row[1] in ('D021', 'D022', 'D023', 'D024'):
Dye_eq6.append(dictVar)
elif row[1] in ('HP01'):
PB_eq.append(dictVar)
elif row[1] in ('订边机'):
DB_eq.append(dictVar)
elif row[1] in ('LT03', 'LT02', 'LT01'):
TS_eq.append(dictVar)
elif row[1] in ('DR03'):
FB_eq.append(dictVar)
elif row[1] in ('LS01', 'LS02'):
SX_eq.append(dictVar)
elif row[1] in ('LB03', 'LB04', 'LB05'):
DX_eq1.append(dictVar)
elif row[1] in ('LB01', 'LB02'):
DX_eq2.append(dictVar)
elif row[1] in ('KJ04', 'KJ03', 'KJ02', 'KJ01'):
DJ_eq.append(dictVar)
elif row[1] in ('KI04', 'KI03', 'KI02', 'KI01'):
YB_eq.append(dictVar)
row = cursor.fetchone()
cursor.close()
# connect.close()
return TJ_eq, MM_eq, Dye_eq1, Dye_eq2, Dye_eq3, Dye_eq4, Dye_eq5, Dye_eq6, PB_eq, DB_eq, TS_eq, FB_eq, SX_eq, DX_eq1, DX_eq2, DJ_eq, YB_eq
def JSSearchData(*args):
print(args)
sWorkingProcedureName = args[0]
sMaterialNoList = args[1]
# print(sWorkingProcedureName)
# print(sMaterialNoList)
sMaterialNo1 = ''
sMaterialNo2 = ''
sMaterialNo3 = ''
sMaterialNo4 = ''
sMaterialNo5 = ''
sMaterialNo6 = ''
sMaterialNo7 = ''
sMaterialNo8 = ''
sMaterialNo9 = ''
varList0 = []
varList1 = []
varList2 = []
varList3 = []
varList4 = []
varList5 = []
varList6 = []
varList7 = []
varList8 = []
varList9 = []
nNumber = 0
for i in sMaterialNoList:
if nNumber == 0:
sMaterialNo1 = i
elif nNumber == 1:
sMaterialNo2 = i
elif nNumber == 2:
sMaterialNo3 = i
elif nNumber == 3:
sMaterialNo4 = i
elif nNumber == 4:
sMaterialNo5 = i
elif nNumber == 5:
sMaterialNo6 = i
elif nNumber == 6:
sMaterialNo7 = i
elif nNumber == 7:
sMaterialNo8 = i
elif nNumber == 8:
sMaterialNo9 = i
nNumber += 1
sSQL = JSSearchDataSQL(sWorkingProcedureName, sMaterialNo1, sMaterialNo2,
sMaterialNo3, sMaterialNo4, sMaterialNo5,
sMaterialNo6, sMaterialNo7, sMaterialNo8,
sMaterialNo9)
cursor = connect.cursor()
# 创建一个游标对象,python里的sql语句都要通过cursor来执行
cursor.execute(sSQL)
print(sSQL)
# 执行sql语句
row = cursor.fetchone()
varList0 = []
varList1 = []
varList2 = []
varList3 = []
varList4 = []
varList5 = []
varList6 = []
varList7 = []
varList8 = []
varList9 = []
returnList = []
while row:
print('3222222222222222222222222222')
print(row)
print(len(row))
varList0.append(row[0])
varList1.append(row[1])
varList2.append(row[2])
varList3.append(row[3])
if len(row) >= 5:
print('==============5')
varList4.append(row[4])
if len(row) >= 6:
print('==============6')
varList5.append(row[5])
if len(row) >= 7:
print('==============7')
varList6.append(row[6])
if len(row) >= 8:
print('==============8')
varList7.append(row[7])
if len(row) >= 9:
print('==============9')
varList8.append(row[8])
if len(row) >= 10:
print('==============10')
varList9.append(row[9])
row = cursor.fetchone()
cursor.close()
nNumber = len(varList0)
print('==========1212121=========3232')
print(varList0)
print(len(varList0))
print('==========q3212121=========3232')
if nNumber == 1:
for i in range(9):
varList0.append('')
varList1.append('')
varList2.append('')
varList3.append('')
varList4.append('')
varList5.append('')
varList6.append('')
varList7.append('')
varList8.append('')
varList9.append('')
elif nNumber == 2:
for i in range(8):
varList0.append('')
varList1.append('')
varList2.append('')
varList3.append('')
varList4.append('')
varList5.append('')
varList6.append('')
varList7.append('')
varList8.append('')
varList9.append('')
elif nNumber == 3:
for i in range(7):
varList0.append('')
varList1.append('')
varList2.append('')
varList3.append('')
varList4.append('')
varList5.append('')
varList6.append('')
varList7.append('')
varList8.append('')
varList9.append('')
elif nNumber == 4:
for i in range(6):
varList0.append('')
varList1.append('')
varList2.append('')
varList3.append('')
varList4.append('')
varList5.append('')
varList6.append('')
varList7.append('')
varList8.append('')
varList9.append('')
elif nNumber == 5:
for i in range(5):
varList0.append('')
varList1.append('')
varList2.append('')
varList3.append('')
varList4.append('')
varList5.append('')
varList6.append('')
varList7.append('')
varList8.append('')
varList9.append('')
elif nNumber == 6:
for i in range(4):
varList0.append('')
varList1.append('')
varList2.append('')
varList3.append('')
varList4.append('')
varList5.append('')
varList6.append('')
varList7.append('')
varList8.append('')
varList9.append('')
elif nNumber == 7:
for i in range(3):
varList0.append('')
varList1.append('')
varList2.append('')
varList3.append('')
varList4.append('')
varList5.append('')
varList6.append('')
varList7.append('')
varList8.append('')
varList9.append('')
elif nNumber == 8:
for i in range(2):
varList0.append('')
varList1.append('')
varList2.append('')
varList3.append('')
varList4.append('')
varList5.append('')
varList6.append('')
varList7.append('')
varList8.append('')
varList9.append('')
elif nNumber == 9:
for i in range(1):
varList0.append('')
varList1.append('')
varList2.append('')
varList3.append('')
varList4.append('')
varList5.append('')
varList6.append('')
varList7.append('')
varList8.append('')
varList9.append('')
returnList.append(varList0)
returnList.append(varList1)
returnList.append(varList2)
returnList.append(varList3)
returnList.append(varList4)
returnList.append(varList5)
returnList.append(varList6)
returnList.append(varList7)
returnList.append(varList8)
returnList.append(varList9)
nNumber = len(returnList[0])
# if nNumber == 1:
# returnList[0].
print('-------------232323-----------')
print(varList0)
print('-------------212881-----------')
print(returnList)
print('-------------1299999-----------')
return returnList
def JSData(*args):
sVarArgs = ''.join(args)
cursor = connect.cursor()
JSInformation = JSInformationSQL(sVarArgs)
print(sVarArgs)
print(JSInformation)
cursor.execute(JSInformation)
row = cursor.fetchone()
allDataList = []
salesGroupList = []
SalesGroupList2 = []
SalesGroupList_value = []
WoringList = []
WoringList_value = []
SalesList = []
SalesList_value = []
sWorkingProcedureList = []
sPageList = []
nPageNumber = 1
a = 0
while row:
borderColor = ''
if row[9] == '加急':
borderColor = '#FF0000'
elif row[10] != None:
borderColor = '#111111'
else:
borderColor = '#'
sKanBanRemark = str(row[10]).replace(' ', '')
# 页码
if a == 6:
a = 0
nPageNumber += 1
# print('nPageNumber' + str(nPageNumber))
dDict = {
'sSalesName': row[0],
'sCardNo': row[1],
'sMaterialNo': row[2],
'tCardTime': row[3],
'sWorkingProcedureName': row[4],
'sTopColor': row[5],
'sSalesGroupName': row[6],
'tFactStartTime': row[7],
'tFactEndTime': row[8],
'borderColor': borderColor,
'sKanBanRemark': sKanBanRemark,
'ID': row[11],
'nSaleGroupCount': row[12],
'nSaleCount': row[13],
'sWorkingProcedureName2': row[14],
'nWorkingProcedureCount': row[15],
'sSalesNo': row[16],
'sSalesGroupNo': row[17],
'sWorkingProcedureNo': row[18],
'nPageNumber': nPageNumber,
}
allDataList.append(dDict)
# 业务课别的数量
salesGroupDict = {
'sSalesGroupNo': dDict['sSalesGroupNo'],
'sSalesGroupName': dDict['sSalesGroupName'],
'nSaleGroupCount': dDict['nSaleGroupCount'],
}
if salesGroupDict not in salesGroupList:
salesGroupList.append(salesGroupDict)
# 工段的数量
sWorkingDict = {
'sWorkingProcedureNo': dDict['sWorkingProcedureNo'],
'sWorkingProcedureName': dDict['sWorkingProcedureName2'],
'nWorkingProcedureCount': dDict['nWorkingProcedureCount'],
}
if sWorkingDict not in sWorkingProcedureList:
sWorkingProcedureList.append(sWorkingDict)
# 传入业务课别
if sVarArgs == dDict['sSalesGroupNo']:
SalesDict = {
'sSalesGroupNo': dDict['sSalesGroupNo'],
'sSalesGroupName': dDict['sSalesGroupName'],
'nSaleGroupCount': dDict['nSaleGroupCount'],
}
if SalesDict not in SalesGroupList2:
SalesGroupList2.append(SalesDict)
if dDict not in SalesGroupList_value:
SalesGroupList_value.append(dDict)
# 传入工序名称
elif sVarArgs == dDict['sWorkingProcedureNo']:
WoringDict = {
'sWorkingProcedureName2': dDict['sWorkingProcedureName2'],
'sWorkingProcedureNo': dDict['sWorkingProcedureNo'],
'nWorkingProcedureCount': dDict['nWorkingProcedureCount'],
}
if WoringDict not in WoringList:
WoringList.append(WoringDict)
if dDict not in WoringList_value:
WoringList_value.append(dDict)
# 传入业务员
elif sVarArgs == dDict['sSalesNo']:
SalesDict = {
'sSalesNo': dDict['sSalesNo'],
'sSalesName': dDict['sSalesName'],
'nSaleCount': dDict['nSaleCount'],
}
if SalesDict not in SalesList:
SalesList.append(SalesDict)
if dDict not in SalesList_value:
SalesList_value.append(dDict)
a += 1
row = cursor.fetchone()
cursor.close()
return allDataList, salesGroupList, SalesGroupList2, SalesGroupList_value, WoringList, WoringList_value, SalesList, SalesList_value, nPageNumber, sWorkingProcedureList
