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 management_handle():
if request.method == 'POST':
return makepublic._makepublic()#?????????
elif request.method == 'GET':
if request.args.get('Delete',type=str)=='Delete':#删除某个加分项
itemID=request.args.get('itemID',type=int)
Score_items.delete(itemID)
return " "
elif request.args.get('Delete',type=str)=='DeleteStu':#删除学生
campID=request.args.get('campID',type=str)
User.delete(campID)
return " "
elif request.args.get('Edit',type=str)=='Edit':#编辑
id=request.args.get('id',type=str)
name=request.args.get('edit_name',type=unicode)
campID=request.args.get('edit_campID',type=str)
grade=request.args.get('edit_grade',type=unicode)
studentID=request.args.get('edit_studentID',type=str)
return User.edit(id,campID,name,grade,studentID)
elif request.args.get('Add',type=str)=='Add':#添加学生
name=request.args.get('add_name',type=unicode)
campID=request.args.get('add_campID',type=str)
grade=request.args.get('add_grade',type=unicode)
studentID=request.args.get('add_studentID',type=str)
user=User.get_user(campID)
if user:
return u"一卡通号重复"
else :
User.addstudent(campID,name,grade,addstudent)
return u"添加成功"
elif request.args.get('action',type=str)=='resetpw':
campID=request.args.get('campID',type=str)
user=User.get_user(campID)
try:
user.password=user.campID
db.session.commit()
return u"重置成功"
except StandardError,e:
return u"未知错误"
