def GET(self):
#web.debug(name)
runData = {'runFlag': True}
user_data = web.input()
if user_data.has_key("filename"):
filename = user_data.filename
data = xlsUtil.getExcelData(filename)
data['filename'] = filename
return render.selectcolumn(data)
else:
runData['showMsg'] = "请先上传需要打印的excel文件..."
return render.msg(runData)
def GET(self):
# web.debug(name)
runData = {"runFlag": True}
user_data = web.input()
if user_data.has_key("filename"):
filename = user_data.filename
data = xlsUtil.getExcelData(filename)
data["filename"] = filename
return render.selectcolumn(data)
else:
runData["showMsg"] = "请先上传需要打印的excel文件..."
return render.msg(runData)
def POST(self):
flag = True
runData = {"runFlag": True, "showMsg": "OK"}
req = web.input()
# 检查必填项是否都有值
mustName = ["report_type", "filename"]
for name in mustName:
if req.has_key(name):
flag = True
else:
flag = False
if not flag:
msg = "输入参数不正确，请按照正常流程使用系统。"
runData["showMsg"] = msg
return render.err(runData)
# 取出所有的excel表中的列和数据库中的field的对应关系
fld_data_col = []
fld_data_col.append(req["fld_data_col_1"])
fld_data_col.append(req["fld_data_col_2"])
fld_data_col.append(req["fld_data_col_3"])
fld_data_col.append(req["fld_data_col_4"])
fld_data_col.append(req["fld_data_col_5"])
fld_data_col.append(req["fld_data_col_6"])
fld_data_col.append(req["fld_data_col_7"])
fld_data_col.append(req["fld_data_col_8"])
fld_data_col.append(req["fld_data_col_9"])
fld_data_col.append(req["fld_data_col_10"])
fld_data_col.append(req["fld_data_col_11"])
fld_data_col.append(req["fld_data_col_12"])
fld_data_col.append(req["fld_data_col_13"])
fld_data_col.append(req["fld_data_col_14"])
print (fld_data_col)
report_type = req["report_type"]
# 读出excel文件中的数据，并取出第一个sheet
filename = req["filename"]
data = xlsUtil.getExcelData(filename)
tables = data["tables"]
table1 = tables[0]
sheet1 = table1["t_data"]
strInsertTail = ""
iCount = 0
cx = getConn()
cu = cx.cursor()
for row in sheet1:
""" 第一条数据是标题，不需要导入，所以把第 0 条跳过 """
if iCount > 0:
strInsertTail = ""
for strIndex in fld_data_col:
if strIndex == u"":
strInsertTail = strInsertTail + ",''"
else:
iIndex = int(strIndex)
strText = row[iIndex - 1]
strInsertTail = strInsertTail + ",'" + unicode(strText) + "'"
data_no = getYmdhms() + "_" + str(iCount)
strInsertHead = (
"INSERT INTO temp_data (data_no, data_type, use_flag, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14 ) VALUES ( '"
+ data_no
+ "', '"
+ report_type
+ "', '0'"
)
strSql = strInsertHead + strInsertTail + ")"
print strSql
cu.execute(strSql)
iCount = iCount + 1
cx.commit()
cu.close()
cx.close()
# 检查机型名称能否对应到机型代码，如果不能，去机型名称出错页面。
invalidPhone = findInvalidPhoneName()
if len(invalidPhone) == 0:
print "机型名称检查合格。"
else:
runData["showMsg"] = "某些机型名称无法找到对应的机型代码，请先检查上传文件是否正确，或者维护好机型信息再进行制单操作。"
runData["invalidPhone"] = invalidPhone
return render.phoneNameLost(runData)
reportType = req["report_type"]
if reportType == "fld":
saveFld()
elif reportType == "sld":
saveSld()
elif reportType == "jld":
saveJld()
elif reportType == "lyd":
saveLyd()
elif reportType == "nbdbd":
saveNbdbd()
elif reportType == "rkd":
saveRkd()
else:
msg = "报表类型不正确"
runData["showMsg"] = msg
return render.err(runData)
msg = "导入操作执行成功，共导入数据" + str(iCount) + "条。"
runData["showMsg"] = msg
return render.msg(runData)
def POST(self):
flag = True
runData = {'runFlag':True,'showMsg':'OK'}
req = web.input()
# 检查必填项是否都有值
mustName = ['report_type','filename']
for name in mustName:
if req.has_key(name) :
flag = True
else:
flag = False
if not flag :
msg = "输入参数不正确，请按照正常流程使用系统。"
runData['showMsg'] = msg
return render.err(runData)
# 取出所有的excel表中的列和数据库中的field的对应关系
fld_data_col = []
fld_data_col.append( req['fld_data_col_1'])
fld_data_col.append( req['fld_data_col_2'])
fld_data_col.append( req['fld_data_col_3'])
fld_data_col.append( req['fld_data_col_4'])
fld_data_col.append( req['fld_data_col_5'])
fld_data_col.append( req['fld_data_col_6'])
fld_data_col.append( req['fld_data_col_7'])
fld_data_col.append( req['fld_data_col_8'])
fld_data_col.append( req['fld_data_col_9'])
fld_data_col.append( req['fld_data_col_10'])
fld_data_col.append( req['fld_data_col_11'])
fld_data_col.append( req['fld_data_col_12'])
fld_data_col.append( req['fld_data_col_13'])
fld_data_col.append( req['fld_data_col_14'])
print( fld_data_col )
report_type = req["report_type"]
# 读出excel文件中的数据，并取出第一个sheet
filename = req["filename"]
data = xlsUtil.getExcelData(filename)
tables = data['tables']
table1 = tables[0]
sheet1 = table1['t_data']
strInsertTail = ''
iCount = 0
cx = getConn()
cu = cx.cursor()
for row in sheet1:
""" 第一条数据是标题，不需要导入，所以把第 0 条跳过 """
if iCount > 0 :
strInsertTail = ''
for strIndex in fld_data_col :
if strIndex == u'' :
strInsertTail = strInsertTail + ",''"
else:
iIndex = int(strIndex)
strText = row[iIndex-1]
strInsertTail = strInsertTail + ",'" + unicode(strText) + "'"
data_no = getYmdhms() + "_" + str(iCount)
strInsertHead = "INSERT INTO temp_data (data_no, data_type, use_flag, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14 ) VALUES ( '" + data_no + "', '" + report_type + "', '0'"
strSql = strInsertHead + strInsertTail + ")"
print strSql
cu.execute(strSql)
iCount = iCount + 1
cx.commit()
cu.close()
cx.close()
#检查机型名称能否对应到机型代码，如果不能，去机型名称出错页面。
invalidPhone = findInvalidPhoneName();
if len(invalidPhone) == 0 :
print '机型名称检查合格。'
else:
runData['showMsg']='某些机型名称无法找到对应的机型代码，请先检查上传文件是否正确，或者维护好机型信息再进行制单操作。'
runData['invalidPhone']=invalidPhone
return render.phoneNameLost(runData)
reportType = req["report_type"]
if reportType == "fld" :
saveFld()
elif reportType == "sld" :
saveSld()
elif reportType == "jld" :
saveJld()
elif reportType == "lyd" :
saveLyd()
elif reportType == "nbdbd" :
saveNbdbd()
elif reportType == "rkd" :
saveRkd()
else :
msg = "报表类型不正确"
runData['showMsg'] = msg
return render.err(runData)
msg = "导入操作执行成功，共导入数据" + str(iCount) + "条。"
runData['showMsg'] = msg
return render.msg(runData)
