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------"