def makePublic():
if request.method == 'POST':
return makepublic._makepublic()
elif request.method == 'GET':
if request.args.get('Delete',type=str)=='Delete':#删除公示信息
excelID=request.args.get('id',type=int)
Excelmap.deleteExcel(excelID)
return " "
elif request.args.get('View',type=str)=='View':#查看公示信息
excelID=request.args.get('id',type=int)
e=Excelmap.query.filter(excelID==Excelmap.id).first()
filename= os.path.basename(e.filepath)
return url_for('download_excel', filename = filename)
elif request.args.get('Changestatus',type=str)=='Changestatus':#改变公示状态
excelID=request.args.get('id',type=int)
e=Excelmap.query.filter(excelID==Excelmap.id).first()
_status=request.args.get('status',type=int)
e.status=_status
db.session.commit()
return str(_status)
elif request.args.get('act',type=str)=='updateTotal':#更新总分
engine=Engine()
engine.updateTotal()
return " "
else:
#返回excel公示列表
return Excelmap.getExcelLits()#must be a jsonify object or it will return dict is not callable
def getStuInfo():
engine=Engine()
searchtype=request.args.get('searchtype',type=str)#按照全部或是区间
starttime=request.args.get('starttime',type=unicode)#区间起始时间
endtime=request.args.get('endtime',type=unicode)#区间截止时间
if searchtype=="bycampID":
campID=request.args.get('campID',type=str)
user=User.get_user(campID)
return engine.getUserDetail(user,starttime,endtime)
elif searchtype=="bygrade":
grade=request.args.get('grade',type=unicode)
engine.updateTotal()#如果按年级查询，更新数据库总分
return engine.getGradeSumary(grade,starttime,endtime)
else:
return u"无法找到"
