def _makepublic():
_name = request.form["name"]
_timestart = request.form["timestart"]
_timeend = request.form["timeend"]
_note = request.form["note"]
_ischecked = request.form["ischecked"]
_adminID = request.form["admin"] #as campID
_adminName = request.form["adminNAME"]
_maketime = datetime.today()
_time = _maketime.strftime('%Y-%m-%d %H:%M:%S') #TODO change format?
_grade = request.form["grade"]
if _ischecked == "true":
_status = OPEN
else:
_status = CLOSE
#需要写进excel的info栏的内容
excelinfo = {
"filename": _name,
"start": _timestart,
"end": _timeend,
"admin": _adminName,
"note": _note,
"maketime": _maketime,
"grade": _grade
}
engine = Engine()
userlist = engine.getUserlist_byGrade(_grade) #得到该年级全部的學生
if len(userlist) == 0:
return u"不存在该年级"
maker = MakeExcel(excelinfo) #创建MakeExcel对像并初始化
if maker.run(userlist, _timestart, _timeend): #开始创建excel文件，接收变量userlist
filepath = __ExcelDir__ + _name + "_" + _time.split(
" ")[0] + "_" + _time.split(" ")[1].replace(":", "_") + ".xls"
maker.saveAs(filepath)
#把生成的excel的相关信息存放到数据库的表中
exceldb = Excelmap(Excelname=_name,
creater=_adminName,
creater_time=_maketime,
start_time=_timestart,
end_time=_timeend,
filepath=filepath,
status=_status,
grade=_grade)
db.session.add(exceldb)
db.session.commit()
return "true"
else:
return u"0条结果，无法生成公示"
def _makepublic():
_name = request.form["name"]
_timestart=request.form["timestart"]
_timeend=request.form["timeend"]
_note=request.form["note"]
_ischecked=request.form["ischecked"]
_adminID=request.form["admin"]#as campID
_adminName=request.form["adminNAME"]
_maketime=datetime.today()
_time=_maketime.strftime('%Y-%m-%d %H:%M:%S')#TODO change format?
_grade=request.form["grade"]
if _ischecked=="true":
_status=OPEN
else:
_status=CLOSE
#需要写进excel的info栏的内容
excelinfo={
"filename" : _name,
"start" : _timestart,
"end" : _timeend,
"admin" : _adminName,
"note":_note,
"maketime":_maketime,
"grade":_grade
}
engine=Engine()
userlist=engine.getUserlist_byGrade(_grade)#得到该年级全部的學生
if len(userlist)==0:
return u"不存在该年级"
maker=MakeExcel(excelinfo)#创建MakeExcel对像并初始化
if maker.run(userlist,_timestart,_timeend):#开始创建excel文件，接收变量userlist
filepath=__ExcelDir__+_name+"_"+_time.split(" ")[0]+"_"+_time.split(" ")[1].replace(":","_")+".xls"
maker.saveAs(filepath)
#把生成的excel的相关信息存放到数据库的表中
exceldb=Excelmap(Excelname=_name,
creater=_adminName,
creater_time=_maketime,
start_time=_timestart,
end_time=_timeend,
filepath=filepath,
status=_status,
grade=_grade
)
db.session.add(exceldb)
db.session.commit()
return "true"
else :
return u"0条结果，无法生成公示"
if __name__ == '__main__':
excelinfo={
"filename" : "_name",
"start" : "_timestart",
"end" : "_timeend",
"admin" : "_adminName",
"note":"_note",
"maketime":"_maketime",
"grade":"_grade"
}
engine=Engine()
userlist=engine.getUserlist_byGrade(u"本2013")#得到该年级全部的學生
maker=MakeExcel(excelinfo)#创建MakeExcel对像并初始化
if maker.run(userlist,"2015-03-01","2015-03-30"):#开始创建excel文件，接收变量userlist
filepath=__ExcelDir__+"_name"+"_"+".xls"
maker.saveAs(filepath)
# x=ImportFromXls(__Add_info__+"1.xlsx")
# if x.isValid():
# campID_not_unique,num,successful,unknown=x.Read2DB()
# result=u"读取"+str(num)+u"条记录\n------\n"\
# +u"成功\t\t"+str(successful)+u" 条\n------\n"\
# +u"失败(学号重复)\t"+str(len(campID_not_unique))+u" 条\n------\n"\
# +u"未知错误\t"+str(unknown)+u" 条\n------"
