def get_grade_data():
g_id = request.form.get('student_id')
subject = request.form.get('subject')
grades = Grade.getByUserId(g_id).filter(Grade.subject==subject).\
order_by(Grade.contest_time).all()
resp = make_response()
resp.headers['Access-Control-Allow-Origin'] = '*'
resp.headers['Access-Control-Allow-Methods'] = 'POST'
resp.headers[
'Access-Control-Allow-Headers'] = 'x-requested-with,content-type'
data = {}
data_name = []
data_value = []
for x in grades:
data_value.append(x.score)
data_name.append(str(x.contest_time))
u = User.getById(g_id)
data['code'] = 0
data['value'] = data_value
data['name'] = data_name
data['title'] = User.getById(g_id).name + u"的" + subject + u"成绩曲线"
resp.data = json.dumps(data)
return resp
def grade_list():
print g.user.priv
if g.user.priv == 'student':
q = Grade.getByUserId(g.user.id)
else:
q = Grade.getByTeacherId(g.user.id)
print q.count()
subj = request.args.get('subject', None)
if subj:
grades = q.filter(
or_(Grade.subject.like("%" + subj + "%"),
Grade.name.like("%" + subj + "%"))).all()
else:
grades = q.all()
resp = []
for grade in grades:
res = {}
res['id'] = grade.student_id
res['teacher'] = u'无'
res['name'] = u'数据缺失'
u = User.getById(grade.student_id)
if u:
res['name'] = u.name
else:
print grade.student_id
u = User.getById(grade.teacher_id)
if u:
res['teacher'] = u.name
res['subject'] = grade.subject
res['contest_time'] = str(grade.contest_time)
res['semester'] = grade.semester
res['score'] = grade.score
resp.append(res)
return render_template('grade.html',
user=g.user,
grades=resp,
cur_page='grade')
