def course_userregister(): if current_user is not None and current_user.is_privileged(UserType.registered): cid = request.args.get('cid', -1) csid = request.args.get('csid', -1) if csid < 0: return render_template('error.html', message='查找不到与之匹配的课程班次') courseSchedule = CourseSchedule.query.filter(CourseSchedule.csid == csid).first() if courseSchedule is None: return render_template('error.html', message='查找不到与之匹配的课程班次') course = Course.query.filter(Course.cid==cid).first() if course is None: return render_template('error.html', message='查找不到与之匹配的课程') else: count = CourseStudent.query.filter(CourseStudent.cid==cid, CourseStudent.csid==csid).count() teachernames = "" mteacher = Teacher.query.filter(Teacher.tid == courseSchedule.mteacher).first(); muser = Users.query.filter(Users.username==mteacher.username).first() if muser: teachernames = muser.getName() # if(len( teachernames ) > 0): teachernames += " " bteacher = Teacher.query.filter(Teacher.tid == courseSchedule.bteacher).first(); if bteacher: buser = Users.query.filter(Users.username==bteacher.username).first() if buser: teachernames += buser.getName() return render_template('register_usercourse.html',\ username=current_user.username,\ course=course,\ courseSchedule = courseSchedule, \ studentCount=count, \ pays=PayType.getAllSupported(), \ teachernames = teachernames, \ amount = course.charge) else: flash(u'您需要登录后才能访问该页面') return redirect(url_for('login'))