def getUserDetail(self,
user,
start_time=None,
end_time=None,
is_jsonify=True):
"""
获取用户的具体信息
args：
user:用户（对象）
start_time:统计区间起始时间
end_time：统计区间截止时间
is_jsonify：是否json化
"""
if user:
userDetailDict = {}
items = self.getUserScoreitems(user.campID, Score_items.time_st,
Score_items.time_ed, start_time,
end_time)
userDetailDict = {
"name": user.name,
"campID": user.campID,
"studentID": user.studentID,
"grade": user.grade,
"sum": self.getSum(items),
"items": [Score_items.getItemInfo(item)
for item in items] #存放查询得到的全部加分项
}
return jsonify(userDetailDict) if is_jsonify else userDetailDict
else:
return u"无法找到"
def getUserDetail(self,user,start_time=None,end_time=None,is_jsonify=True):
"""
获取用户的具体信息
args：
user:用户（对象）
start_time:统计区间起始时间
end_time：统计区间截止时间
is_jsonify：是否json化
"""
if user:
userDetailDict={}
items=self.getUserScoreitems(user.campID,Score_items.time_st,
Score_items.time_ed,
start_time,end_time)
userDetailDict={
"name" : user.name,
"campID" : user.campID,
"studentID":user.studentID,
"grade" : user.grade,
"sum" : self.getSum(items),
"items":[Score_items.getItemInfo(item) for item in items]#存放查询得到的全部加分项
}
return jsonify(userDetailDict) if is_jsonify else userDetailDict
else:
return u"无法找到"
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"未知错误"
def _saveapply(filepath=False):
"""
保存申请项目
"""
#by default we think there is no pic has been uploaded
_catagory = request.args.get(
'catagory',
type=unicode) #should be unicode,if it is str than we will get None
_name = request.args.get('name', type=unicode)
_campID = request.args.get('campID', type=str)
_time_st = request.args.get('time_st', type=unicode) #should get a unicode
_time_ed = request.args.get('time_ed', type=unicode) #should get a unicode
_applytime = datetime.today().strftime(
'%Y-%m-%d %H:%M:%S') #format the timestamp return as a string
_add = getvalue(_catagory, _name)
_uuid = request.args.get('UUID', type=str)
_pic = request.args.get('pic', type=str) #if pic uploaded
_explanation = request.args.get('explanation', type=unicode)
user = User.get_user(_campID)
s = Score_items(
catagory=_catagory,
item_name=_name,
time_st=_time_st,
time_ed=_time_ed,
add=_add,
applytime=_applytime,
student=user,
uuid=_uuid,
explanation=_explanation,
)
db.session.add(s)
db.session.flush()
if _pic == "true":
s.picpath = basedir + "/uploads/" + _uuid + ".jpg"
elif _pic == "false":
s.picpath = None
db.session.commit()
return ""
def _saveapply(filepath=False):
"""
保存申请项目
"""
#by default we think there is no pic has been uploaded
_catagory = request.args.get('catagory', type=unicode)#should be unicode,if it is str than we will get None
_name = request.args.get('name', type=unicode)
_campID = request.args.get('campID', type=str)
_time_st=request.args.get('time_st',type=unicode)#should get a unicode
_time_ed=request.args.get('time_ed',type=unicode)#should get a unicode
_applytime=datetime.today().strftime('%Y-%m-%d %H:%M:%S')#format the timestamp return as a string
_add=getvalue(_catagory,_name)
_uuid=request.args.get('UUID', type=str)
_pic=request.args.get('pic',type=str)#if pic uploaded
_explanation=request.args.get('explanation',type=unicode)
user=User.get_user(_campID)
s=Score_items(catagory=_catagory,
item_name=_name,
time_st=_time_st,
time_ed=_time_ed,
add=_add,
applytime=_applytime,
student=user,
uuid=_uuid,
explanation=_explanation,
)
db.session.add(s)
db.session.flush()
if _pic=="true":
s.picpath=basedir+"/uploads/"+_uuid+".jpg"
elif _pic=="false":
s.picpath=None
db.session.commit()
return ""
def pageslicer(page, rp, _score_items):
"""分页函数
args:
page:当前页数
rp：每页结果数
_score_items：全部条目列表
"""
total = len(_score_items)
jsondict = {
"page": page, #当前页
"total": total, #总数
"rows": []
}
for i in xrange((page - 1) * rp,
(page * rp if page * rp - 1 < total else total)):
s = _score_items[i]
#控件要求每行必须是如下结构的字典，cell中包含实际的数据
data = {"id": s.item_name, "cell": Score_items.getItemInfo(s)}
jsondict["rows"].append(data)
return jsondict
def pageslicer(page,rp,_score_items):
"""分页函数
args:
page:当前页数
rp：每页结果数
_score_items：全部条目列表
"""
total=len(_score_items)
jsondict={
"page": page,#当前页
"total": total,#总数
"rows": []
}
for i in xrange((page-1)*rp,(page*rp if page*rp-1<total else total)):
s=_score_items[i]
#控件要求每行必须是如下结构的字典，cell中包含实际的数据
data={
"id": s.item_name,
"cell": Score_items.getItemInfo(s)
}
jsondict["rows"].append(data)
return jsondict
