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')